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_ONLINE_GEN_PVT dependencies on CN_OBJ_PROCEDURES_V

Line 205: procedure_name cn_obj_procedures_v.name%TYPE,

201: END check_create_object;
202:
203: -- initialize the procedure boilerplate
204: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
205: procedure_name cn_obj_procedures_v.name%TYPE,
206: description cn_obj_procedures_v.description%TYPE)
207: IS
208: X_userid VARCHAR2(20);
209: BEGIN

Line 206: description cn_obj_procedures_v.description%TYPE)

202:
203: -- initialize the procedure boilerplate
204: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
205: procedure_name cn_obj_procedures_v.name%TYPE,
206: description cn_obj_procedures_v.description%TYPE)
207: IS
208: X_userid VARCHAR2(20);
209: BEGIN
210: SELECT user INTO X_userid FROM sys.dual;

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

219: cn_utils.appendcr(code, '--');
220: END proc_init_boilerplate;
221:
222: -- initialize the procedure
223: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,

Line 224: description cn_obj_procedures_v.description%TYPE,

220: END proc_init_boilerplate;
221:
222: -- initialize the procedure
223: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,

Line 225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,

221:
222: -- initialize the procedure
223: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,
229: repository_id cn_obj_procedures_v.repository_id%TYPE,

Line 226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,

222: -- initialize the procedure
223: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,
229: repository_id cn_obj_procedures_v.repository_id%TYPE,
230: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 227: return_type cn_obj_procedures_v.return_type%TYPE,

223: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,
229: repository_id cn_obj_procedures_v.repository_id%TYPE,
230: spec_code IN OUT NOCOPY cn_utils.code_type,
231: body_code IN OUT NOCOPY cn_utils.code_type) IS

Line 228: package_id cn_obj_procedures_v.package_id%TYPE,

224: description cn_obj_procedures_v.description%TYPE,
225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,
229: repository_id cn_obj_procedures_v.repository_id%TYPE,
230: spec_code IN OUT NOCOPY cn_utils.code_type,
231: body_code IN OUT NOCOPY cn_utils.code_type) IS
232: BEGIN

Line 229: repository_id cn_obj_procedures_v.repository_id%TYPE,

225: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
226: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
227: return_type cn_obj_procedures_v.return_type%TYPE,
228: package_id cn_obj_procedures_v.package_id%TYPE,
229: repository_id cn_obj_procedures_v.repository_id%TYPE,
230: spec_code IN OUT NOCOPY cn_utils.code_type,
231: body_code IN OUT NOCOPY cn_utils.code_type) IS
232: BEGIN
233: -- Generate boilerplate comments

Line 276: procedure_name cn_obj_procedures_v.name%TYPE;

272: PROCEDURE get_winning_rule (spec_code IN OUT NOCOPY cn_utils.code_type,
273: body_code IN OUT NOCOPY cn_utils.code_type ,
274: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
275: IS
276: procedure_name cn_obj_procedures_v.name%TYPE;
277: procedure_desc cn_obj_procedures_v.description%TYPE;
278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
279: package_spec_id cn_obj_packages_v.package_id%TYPE;
280: x_repository_id cn_repositories.repository_id%TYPE;

Line 277: procedure_desc cn_obj_procedures_v.description%TYPE;

273: body_code IN OUT NOCOPY cn_utils.code_type ,
274: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
275: IS
276: procedure_name cn_obj_procedures_v.name%TYPE;
277: procedure_desc cn_obj_procedures_v.description%TYPE;
278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
279: package_spec_id cn_obj_packages_v.package_id%TYPE;
280: x_repository_id cn_repositories.repository_id%TYPE;
281: l_attrib_counter NUMBER := 1;

Line 278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

274: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
275: IS
276: procedure_name cn_obj_procedures_v.name%TYPE;
277: procedure_desc cn_obj_procedures_v.description%TYPE;
278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
279: package_spec_id cn_obj_packages_v.package_id%TYPE;
280: x_repository_id cn_repositories.repository_id%TYPE;
281: l_attrib_counter NUMBER := 1;
282: l_rule_counter NUMBER := 1;