--- Creating Excecutables
Begin
FND_PROGRAM.EXECUTABLE
(executable => 'XXHFTUPGITEMLDR'
,application => 'Harbor Freight Custom Application'
,short_name => 'XXHFTUPGITEMLDR'
,description => 'SQLLOADER Item Program from 11i to R12'
,execution_method => 'SQL*Loader'
,execution_file_name => 'XXHFTUPGITEMLDR'
,subroutine_name => ''
,icon_name => ''
,language_code => 'US'
,execution_file_path => '');
end;
---- Creating Concurrent Programs ----
Begin
FND_PROGRAM.REGISTER
(program => 'HFT Item Conversion loader' --- Concurrent Program Name
,application => 'Harbor Freight Custom Application' --- Application Name
,enabled => 'Y' --- Enabled Flag
,short_name => 'XXHFTUPGITEMLDR' --- Short Name of Conc Program
,description => '' --- Description
,executable_short_name => 'XXHFTUPGITEMLDR' --- Executable of the Conc Program
,executable_application => 'Harbor Freight Custom Application' --- Executable application
,execution_options => ''
,priority => ''
,save_output => 'Y'
,print => 'Y'
,cols => ''
,rows => ''
,style => ''
,style_required => 'N'
,printer => ''
,request_type => ''
,request_type_application => ''
,use_in_srs => 'Y'
,allow_disabled_values => 'N'
,run_alone => 'N'
,output_type => 'Text' ---- Out put format
,enable_trace => 'N'
,restart => 'Y'
,nls_compliant => 'Y'
,icon_name => ''
,language_code => 'US'
,mls_function_short_name => ''
,mls_function_application => ''
,incrementor => '');
end;
How to add Parameters to Concurrent Program
Begin
fnd_program.parameter
(program_short_name => 'xxhftupgitemldr' --- Short Name of Conc Program
,application => 'harbor freight custom application' --- Application Name
,sequence => '1' --- Sequnce Number
,parameter => 'path' --- Parameter Name
,description => 'path of data file.' --- Paramter Description
,enabled => 'y' --- Enabled Flag
,value_set => 'ar_varchar_150' --- Value Set Name
,default_type => ''
,default_value => ''
,required => 'y' --- Required flag ( Mandatory or not)
,enable_security => 'n'
,range => ''
,display => 'y'
,display_size => '15'
,description_size => '50'
,concatenated_description_size=> '25'
,prompt => 'path '
,token => '');
end;
How to add Concurrent program to request group
Begin
FND_PROGRAM.ADD_TO_GROUP
(program_short_name => 'XXHFTUPGITEMLDR' --- Short Name of Conc Program
,program_application => 'Harbor Freight Custom Application' --- Application Name
,request_group => 'All Inclusive GUI' --- Request group name
,group_application => 'Inventory'); --- Requst group Application Name
end;
How to delete Concurrent program & Executable
IF (FND_PROGRAM.PROGRAM_EXISTS
(program => 'XXHFTUPGITEMLDR'
,application => 'Harbor Freight Custom Application'))
THEN
FND_PROGRAM.DELETE_PROGRAM('XXHFTUPGITEMLDR', 'HFT');
--- Short Name of Conc Program , --- Application Name
FND_PROGRAM.DELETE_EXECUTABLE('XXHFTITEMLDR', 'HFT');
---- Short Name of Excutable Program , --- Application Name
END IF;
Begin
FND_PROGRAM.EXECUTABLE
(executable => 'XXHFTUPGITEMLDR'
,application => 'Harbor Freight Custom Application'
,short_name => 'XXHFTUPGITEMLDR'
,description => 'SQLLOADER Item Program from 11i to R12'
,execution_method => 'SQL*Loader'
,execution_file_name => 'XXHFTUPGITEMLDR'
,subroutine_name => ''
,icon_name => ''
,language_code => 'US'
,execution_file_path => '');
end;
---- Creating Concurrent Programs ----
Begin
FND_PROGRAM.REGISTER
(program => 'HFT Item Conversion loader' --- Concurrent Program Name
,application => 'Harbor Freight Custom Application' --- Application Name
,enabled => 'Y' --- Enabled Flag
,short_name => 'XXHFTUPGITEMLDR' --- Short Name of Conc Program
,description => '' --- Description
,executable_short_name => 'XXHFTUPGITEMLDR' --- Executable of the Conc Program
,executable_application => 'Harbor Freight Custom Application' --- Executable application
,execution_options => ''
,priority => ''
,save_output => 'Y'
,print => 'Y'
,cols => ''
,rows => ''
,style => ''
,style_required => 'N'
,printer => ''
,request_type => ''
,request_type_application => ''
,use_in_srs => 'Y'
,allow_disabled_values => 'N'
,run_alone => 'N'
,output_type => 'Text' ---- Out put format
,enable_trace => 'N'
,restart => 'Y'
,nls_compliant => 'Y'
,icon_name => ''
,language_code => 'US'
,mls_function_short_name => ''
,mls_function_application => ''
,incrementor => '');
end;
How to add Parameters to Concurrent Program
Begin
fnd_program.parameter
(program_short_name => 'xxhftupgitemldr' --- Short Name of Conc Program
,application => 'harbor freight custom application' --- Application Name
,sequence => '1' --- Sequnce Number
,parameter => 'path' --- Parameter Name
,description => 'path of data file.' --- Paramter Description
,enabled => 'y' --- Enabled Flag
,value_set => 'ar_varchar_150' --- Value Set Name
,default_type => ''
,default_value => ''
,required => 'y' --- Required flag ( Mandatory or not)
,enable_security => 'n'
,range => ''
,display => 'y'
,display_size => '15'
,description_size => '50'
,concatenated_description_size=> '25'
,prompt => 'path '
,token => '');
end;
How to add Concurrent program to request group
Begin
FND_PROGRAM.ADD_TO_GROUP
(program_short_name => 'XXHFTUPGITEMLDR' --- Short Name of Conc Program
,program_application => 'Harbor Freight Custom Application' --- Application Name
,request_group => 'All Inclusive GUI' --- Request group name
,group_application => 'Inventory'); --- Requst group Application Name
end;
How to delete Concurrent program & Executable
IF (FND_PROGRAM.PROGRAM_EXISTS
(program => 'XXHFTUPGITEMLDR'
,application => 'Harbor Freight Custom Application'))
THEN
FND_PROGRAM.DELETE_PROGRAM('XXHFTUPGITEMLDR', 'HFT');
--- Short Name of Conc Program , --- Application Name
FND_PROGRAM.DELETE_EXECUTABLE('XXHFTITEMLDR', 'HFT');
---- Short Name of Excutable Program , --- Application Name
END IF;
No comments:
Post a Comment