FND_PROGRAM : Register Concurrent Program via API ~ Oracle Apps Knowledge Sharing

Thursday, May 5, 2011

FND_PROGRAM : Register Concurrent Program via API

Test Instance: R12.1.1

Script:

/* Formatted on 2011/05/05 11:38 (Formatter Plus v4.8.5) */

DECLARE

v_program VARCHAR2 (200);

v_application VARCHAR2 (200);

v_enabled VARCHAR2 (200);

v_short_name VARCHAR2 (200);

v_description VARCHAR2 (200);

v_executable_short_name VARCHAR2 (200);

v_executable_application VARCHAR2 (200);

v_execution_options VARCHAR2 (200);

v_priority NUMBER;

v_save_output VARCHAR2 (200);

v_print VARCHAR2 (200);

v_cols NUMBER;

v_rows NUMBER;

v_style VARCHAR2 (200);

v_style_required VARCHAR2 (200);

v_printer VARCHAR2 (200);

v_request_type VARCHAR2 (200);

v_request_type_application VARCHAR2 (200);

v_use_in_srs VARCHAR2 (200);

v_allow_disabled_values VARCHAR2 (200);

v_run_alone VARCHAR2 (200);

v_output_type VARCHAR2 (200);

v_enable_trace VARCHAR2 (200);

v_restart VARCHAR2 (200);

v_nls_compliant VARCHAR2 (200);

v_icon_name VARCHAR2 (200);

v_language_code VARCHAR2 (200);

v_mls_function_short_name VARCHAR2 (200);

v_mls_function_application VARCHAR2 (200);

v_incrementor VARCHAR2 (200);

v_refresh_portlet VARCHAR2 (200);

v_check VARCHAR2 (2);

BEGIN

v_program := 'Concurrent program for testing SHAREORACLEAPPS';

v_application := 'Payables';

v_enabled := 'Y';

v_short_name := 'XX_SHAREORACLEAPPS';

v_description := 'Shareoracleapps Test Program';

v_executable_short_name := 'XX_SHAREORACLEAPPS';

v_executable_application := 'Msisol Payables';

v_execution_options := NULL;

v_priority := NULL;

v_save_output := 'Y';

v_print := 'Y';

v_cols := NULL;

v_rows := NULL;

v_style := NULL;

v_style_required := 'N';

v_printer := NULL;

v_request_type := NULL;

v_request_type_application := NULL;

v_use_in_srs := 'Y';

v_allow_disabled_values := 'N';

v_run_alone := 'N';

v_output_type := 'TEXT';

v_enable_trace := 'N';

v_restart := 'Y';

v_nls_compliant := 'Y';

v_icon_name := NULL;

v_language_code := 'US';

v_mls_function_short_name := NULL;

v_mls_function_application := NULL;

v_incrementor := NULL;

v_refresh_portlet := NULL;

apps.fnd_program.REGISTER

(program => v_program,

application => v_application,

enabled => v_enabled,

short_name => v_short_name,

description => v_description,

executable_short_name => v_executable_short_name,

executable_application => v_executable_application,

execution_options => v_execution_options,

priority => v_priority,

save_output => v_save_output,

PRINT => v_print,

cols => v_cols,

ROWS => v_rows,

style => v_style,

style_required => v_style_required,

printer => v_printer,

request_type => v_request_type,

request_type_application => v_request_type_application,

use_in_srs => v_use_in_srs,

allow_disabled_values => v_allow_disabled_values,

run_alone => v_run_alone,

output_type => v_output_type,

enable_trace => v_enable_trace,

restart => v_restart,

nls_compliant => v_nls_compliant,

icon_name => v_icon_name,

language_code => v_language_code,

mls_function_short_name => v_mls_function_short_name,

mls_function_application => v_mls_function_application,

incrementor => v_incrementor,

refresh_portlet => v_refresh_portlet

);

COMMIT;

BEGIN

SELECT 'Y'

INTO v_check

FROM fnd_concurrent_programs

WHERE concurrent_program_name = 'XX_SHAREORACLEAPPS';

EXCEPTION

WHEN NO_DATA_FOUND

THEN

DBMS_OUTPUT.put_line ('Concurrent Program Registration Failed');

END;

Do you think this Article is useful?

1 Responses to “FND_PROGRAM : Register Concurrent Program via API”

Rahul said... July 3, 2014 at 3:54 AM Do you have one that registers it with parameters (value sets and default values etc)

Oracle Apps Knowledge Sharing

Thursday, May 5, 2011