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