For Registration of Reports,Pl/SQL Procedures,SQL * Plus... etc from Back end By using PL/SQL Procedure And code shown below.
For Executables:-==========
fnd_program.executable (
executable => 'ZENGLJEINT'
,short_name => 'ZENGLJEINT'
,application => 'EAG Customization'
,description => 'ZENSI GL Journal Entry Interface (Loader and Validation)'
,execution_method => 'Host'
,execution_file_name => 'ZENGLJEINT'
,subroutine_name => NULL
,ICON_NAME => NULL
,LANGUAGE_CODE => 'US'
,EXECUTION_FILE_PATH => NULL
);
For Concurent Programs:
================
fnd_program.register (
program => 'ZENSI GL Journal Entry Interface (Loader and Validation)'
,application => 'Oracle General Ledger'
,enabled => 'Y'
,short_name => 'ZENGLJEINT'
,description => 'ZENSI GL Journal Entry Interface (Loader and Validation)'
,executable_short_name => 'ZENGLJEINT'
,executable_application => 'Oracle General Ledger'
,priority => NULL
,save_output => 'Y'
,print => 'N'
,cols => 132
,rows => 45
,style => 'Landscape'
,style_required => 'N'
,printer => ''
,use_in_SRS => 'Y'
,allow_disabled_values => 'N'
,run_alone => 'N'
,enable_trace => 'N'
,restart => 'Y'
,nls_compliant => 'Y'
,output_type => 'Text'
,execution_options => NULL
,request_type => NULL
,request_type_application => NULL
,icon_name => NULL
,language_code => 'US'
,mls_function_short_name => NULL
,mls_function_application => NULL
,incrementor => NULL
);
For Concurrent Program Parameters:
=======================
fnd_program.parameter (
program_short_name => 'ZENGLJEINT'
,application => 'Oracle General Ledger'
,sequence => 1
,parameter => 'Base Path'
,description => 'Base Path'
,enabled => 'Y'
,value_set => 'FND_CHAR240'
,default_type => 'Constant'
,default_value => v_base_path
,required => 'Y'
,enable_security => 'N'
,range => ''
,display => 'Y'
,display_size => 15
,description_size => 50
,concatenated_description_size => 25
,prompt => 'Base Path'
,token => ''
);
For Request Groups:
==============
fnd_program.request_group
fnd_program.add_to_group - Add the C.P to the Request Group
VERY NICE MATERIAL
ReplyDelete