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
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;
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,
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,
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,
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,
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
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
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
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;
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;
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;