eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_OBJ_PROCEDURES_V

Line 304: procedure_name cn_obj_procedures_v.name%TYPE,

300: END pkg_init;
301: --
302: -- initialize the procedure boilerplate
303: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
304: procedure_name cn_obj_procedures_v.name%TYPE,
305: description cn_obj_procedures_v.description%TYPE)
306: IS
307: X_userid VARCHAR2(20);
308: BEGIN

Line 305: description cn_obj_procedures_v.description%TYPE)

301: --
302: -- initialize the procedure boilerplate
303: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
304: procedure_name cn_obj_procedures_v.name%TYPE,
305: description cn_obj_procedures_v.description%TYPE)
306: IS
307: X_userid VARCHAR2(20);
308: BEGIN
309: SELECT user INTO X_userid FROM sys.dual;

Line 322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,

318: cn_utils.appendcr(code, '--');
319: END proc_init_boilerplate;
320:
321: -- initialize the procedure
322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,

Line 323: description cn_obj_procedures_v.description%TYPE,

319: END proc_init_boilerplate;
320:
321: -- initialize the procedure
322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,

Line 324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,

320:
321: -- initialize the procedure
322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,
328: repository_id cn_obj_procedures_v.repository_id%TYPE,

Line 325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,

321: -- initialize the procedure
322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,
328: repository_id cn_obj_procedures_v.repository_id%TYPE,
329: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 326: return_type cn_obj_procedures_v.return_type%TYPE,

322: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,
328: repository_id cn_obj_procedures_v.repository_id%TYPE,
329: spec_code IN OUT NOCOPY cn_utils.code_type,
330: body_code IN OUT NOCOPY cn_utils.code_type) IS

Line 327: package_id cn_obj_procedures_v.package_id%TYPE,

323: description cn_obj_procedures_v.description%TYPE,
324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,
328: repository_id cn_obj_procedures_v.repository_id%TYPE,
329: spec_code IN OUT NOCOPY cn_utils.code_type,
330: body_code IN OUT NOCOPY cn_utils.code_type) IS
331: BEGIN

Line 328: repository_id cn_obj_procedures_v.repository_id%TYPE,

324: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
325: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
326: return_type cn_obj_procedures_v.return_type%TYPE,
327: package_id cn_obj_procedures_v.package_id%TYPE,
328: repository_id cn_obj_procedures_v.repository_id%TYPE,
329: spec_code IN OUT NOCOPY cn_utils.code_type,
330: body_code IN OUT NOCOPY cn_utils.code_type) IS
331: BEGIN
332: -- Generate boilerplate comments

Line 376: procedure_name cn_obj_procedures_v.name%TYPE;

372: spec_code IN OUT NOCOPY cn_utils.code_type,
373: body_code IN OUT NOCOPY cn_utils.code_type ,
374: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE) IS
375: --
376: procedure_name cn_obj_procedures_v.name%TYPE;
377: procedure_desc cn_obj_procedures_v.description%TYPE;
378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
379: package_spec_id cn_obj_packages_v.package_id%TYPE;
380: x_repository_id cn_repositories.repository_id%TYPE;

Line 377: procedure_desc cn_obj_procedures_v.description%TYPE;

373: body_code IN OUT NOCOPY cn_utils.code_type ,
374: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE) IS
375: --
376: procedure_name cn_obj_procedures_v.name%TYPE;
377: procedure_desc cn_obj_procedures_v.description%TYPE;
378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
379: package_spec_id cn_obj_packages_v.package_id%TYPE;
380: x_repository_id cn_repositories.repository_id%TYPE;
381: l_attr_counter NUMBER := 1;

Line 378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

374: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE) IS
375: --
376: procedure_name cn_obj_procedures_v.name%TYPE;
377: procedure_desc cn_obj_procedures_v.description%TYPE;
378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
379: package_spec_id cn_obj_packages_v.package_id%TYPE;
380: x_repository_id cn_repositories.repository_id%TYPE;
381: l_attr_counter NUMBER := 1;
382: l_rule_counter NUMBER := 1;