1: PACKAGE BODY CN_SCA_RULES_ONLINE_GEN_PVT AS
2: -- $Header: cnvscagb.pls 120.4 2006/03/31 04:24:58 rrshetty noship $
3:
4: g_package_name cn_obj_packages_v.name%TYPE;
5: g_org_id cn_sca_credit_rules.org_id%TYPE;
6:
7: PROCEDURE get_min ( p_min IN OUT NOCOPY number, p_max number) IS
8: BEGIN
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;
283:
503:
504: FUNCTION create_sca_rules_online_dyn
505: (x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
506: RETURN BOOLEAN IS
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
504: FUNCTION create_sca_rules_online_dyn
505: (x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
506: RETURN BOOLEAN IS
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
512: package_body_desc cn_obj_packages_v.description%TYPE;
505: (x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
506: RETURN BOOLEAN IS
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
512: package_body_desc cn_obj_packages_v.description%TYPE;
513: spec_code cn_utils.code_type;
506: RETURN BOOLEAN IS
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
512: package_body_desc cn_obj_packages_v.description%TYPE;
513: spec_code cn_utils.code_type;
514: body_code cn_utils.code_type;
507: package_name cn_obj_packages_v.name%TYPE;
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
512: package_body_desc cn_obj_packages_v.description%TYPE;
513: spec_code cn_utils.code_type;
514: body_code cn_utils.code_type;
515: dummy NUMBER(7);
508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
509: package_spec_id cn_obj_packages_v.package_id%TYPE;
510: package_body_id cn_obj_packages_v.package_id%TYPE;
511: package_spec_desc cn_obj_packages_v.description%TYPE;
512: package_body_desc cn_obj_packages_v.description%TYPE;
513: spec_code cn_utils.code_type;
514: body_code cn_utils.code_type;
515: dummy NUMBER(7);
516: l_module_id number(15);