-- Define Concurrent Parameters:
-- The parameters are the placeholders for the input values to a concurrent program.
-- If the execution method of a concurrent program is Oracle Reports then each parameter is linked to the actual report parameter via the "Token" field in the parameters window
-- For PL/SQL stored procedures these parameters are passed to the program by position.
-- The parameters are the placeholders for the input values to a concurrent program.
-- If the execution method of a concurrent program is Oracle Reports then each parameter is linked to the actual report parameter via the "Token" field in the parameters window
-- For PL/SQL stored procedures these parameters are passed to the program by position.
/*=============================================
CREATE PARAMETERS TO THE CONCURRENT PROGRAM FROM BACKEND
==============================================*/
DECLARE
v_cprogram VARCHAR2 (50) := 'XX_APPS88_HRMS';
BEGIN
fnd_global.apps_initialize (user_id => 1318,
resp_id => 21623,
resp_appl_id => 660
);
fnd_program.parameter (program_short_name => v_cprogram,
application => 'Human Resources',
SEQUENCE => 10,
parameter => 'Employee Number',
enabled => 'Y',
value_set => '240 char',
display_size => 50,
description_size => 20,
concatenated_description_size => 20,
prompt => 'P_EMPLOYEE_NUM',
token => 'P_EMPLOYEE_NUM'
);
COMMIT;
DBMS_OUTPUT.put_line (' successfully created parameter for concurrent program ' || v_cprogram );
EXCEPTION
WHEN OTHERS
THEN DBMS_OUTPUT.put_line ('error out here' || SQLCODE || SQLERRM);
END;
No comments:
Post a Comment