DBA Data[Home] [Help]

APPS.CN_SCA_RULES_ONLINE_GEN_PVT dependencies on CN_OBJ_PACKAGES_V

Line 4: g_package_name cn_obj_packages_v.name%TYPE;

1: PACKAGE BODY CN_SCA_RULES_ONLINE_GEN_PVT AS
2: -- $Header: cnvscagb.pls 120.6 2011/08/11 08:24:08 srguntur ship $
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

Line 279: package_spec_id cn_obj_packages_v.package_id%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;
283:

Line 507: package_name cn_obj_packages_v.name%TYPE;

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;

Line 508: package_type cn_obj_packages_v.package_type%TYPE := 'FML';

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;

Line 509: package_spec_id cn_obj_packages_v.package_id%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;

Line 510: package_body_id cn_obj_packages_v.package_id%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;

Line 511: package_spec_desc cn_obj_packages_v.description%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);

Line 512: package_body_desc cn_obj_packages_v.description%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);
516: l_module_id number(15);