We need to use FND_PROGRAM.PARAMETER api to create an concurrent program parameter from backend database, below is the sample script.
Creating the Concurrent Program Parameter from backend:
/**************************************************************** *PURPOSE: To Create a Concurrent Program Parameter from backend * *AUTHOR: Shailender Thallam * *****************************************************************/ -- DECLARE -- l_program_short_name VARCHAR2 (200); l_application VARCHAR2 (200); l_sequence NUMBER; l_parameter VARCHAR2 (200); l_description VARCHAR2 (200); l_enabled VARCHAR2 (200); l_value_set VARCHAR2 (200); l_default_type VARCHAR2 (200); l_default_value VARCHAR2 (200); l_required VARCHAR2 (200); l_enable_security VARCHAR2 (200); l_range VARCHAR2 (200); l_display VARCHAR2 (200); l_display_size NUMBER; l_description_size NUMBER; l_concatenated_descr_size NUMBER; l_prompt VARCHAR2 (200); l_token VARCHAR2 (200); l_cd_parameter VARCHAR2 (200); l_check VARCHAR2 (2); -- BEGIN -- l_program_short_name := 'XX_ORACLEAPPSDNA_CP'; l_application := 'CUSTOM Custom'; l_sequence := 10; l_parameter := 'Employee Name'; l_description := 'Employee Name'; l_enabled := 'Y'; l_value_set := '240 Characters'; l_default_type := NULL; l_default_value := NULL; l_required := 'N'; l_enable_security := 'N'; l_range := NULL; l_display := 'Y'; l_display_size := 50; l_description_size := 50; l_concatenated_descr_size := 50; l_prompt := 'Employee Name'; l_token := NULL; l_cd_parameter := NULL; -- --Calling API to create a Parameter for a concurrent program definition -- apps.fnd_program.parameter (program_short_name => l_program_short_name, application => l_application, SEQUENCE => l_sequence, parameter => l_parameter, description => l_description, enabled => l_enabled, value_set => l_value_set, default_type => l_default_type, DEFAULT_VALUE => l_default_value, required => l_required, enable_security => l_enable_security, RANGE => l_range, display => l_display, display_size => l_display_size, description_size => l_description_size, concatenated_description_size => l_concatenated_descr_size, prompt => l_prompt, token => l_token, cd_parameter => l_cd_parameter ); -- COMMIT; -- BEGIN -- --To check whether a parameter is assigned to a Concurrent Program or not -- SELECT 'Y' INTO l_check FROM fnd_descr_flex_column_usages WHERE descriptive_flexfield_name = '$SRS$.' || 'XX_ORACLEAPPSDNA_CP' AND end_user_column_name = 'Employee Name'; -- dbms_output.put_line ('Concurrent Program Parameter registered Successfully'); -- EXCEPTION WHEN no_data_found THEN dbms_output.put_line ('Concurrent Program Parameter Registration Failed'); END; -- END; |
View from front end application:
- The above script inserts data into FND_DESCR_FLEX_COL_USAGE_TL and FND_DESCR_FLEX_COLUMN_USAGES tables