DBA Data[Home] [Help]

APPS.CN_CLASSIFICATION_GEN dependencies on CN_OBJ_PACKAGES_V

Line 515: package_name cn_obj_packages_v.name%TYPE,

511:
512:
513: PROCEDURE pkg_init_boilerplate (
514: code IN OUT NOCOPY cn_utils.code_type,
515: package_name cn_obj_packages_v.name%TYPE,
516: description cn_obj_packages_v.description%TYPE,
517: object_type VARCHAR2) IS
518:
519: X_userid VARCHAR2(20);

Line 516: description cn_obj_packages_v.description%TYPE,

512:
513: PROCEDURE pkg_init_boilerplate (
514: code IN OUT NOCOPY cn_utils.code_type,
515: package_name cn_obj_packages_v.name%TYPE,
516: description cn_obj_packages_v.description%TYPE,
517: object_type VARCHAR2) IS
518:
519: X_userid VARCHAR2(20);
520:

Line 579: package_name cn_obj_packages_v.name%TYPE,

575: END create_object;
576:
577: PROCEDURE file_header (
578: module_id cn_modules.module_id%TYPE,
579: package_name cn_obj_packages_v.name%TYPE,
580: package_type cn_obj_packages_v.package_type%TYPE,
581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

Line 580: package_type cn_obj_packages_v.package_type%TYPE,

576:
577: PROCEDURE file_header (
578: module_id cn_modules.module_id%TYPE,
579: package_name cn_obj_packages_v.name%TYPE,
580: package_type cn_obj_packages_v.package_type%TYPE,
581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

Line 582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

578: module_id cn_modules.module_id%TYPE,
579: package_name cn_obj_packages_v.name%TYPE,
580: package_type cn_obj_packages_v.package_type%TYPE,
581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
586:

Line 583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

579: package_name cn_obj_packages_v.name%TYPE,
580: package_type cn_obj_packages_v.package_type%TYPE,
581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
586:
587: spec_code IN OUT NOCOPY cn_utils.clob_code_type,

Line 584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

580: package_type cn_obj_packages_v.package_type%TYPE,
581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
586:
587: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
588: body_code IN OUT NOCOPY cn_utils.clob_code_type,

Line 585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

581:
582: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
583: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
584: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
585: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
586:
587: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
588: body_code IN OUT NOCOPY cn_utils.clob_code_type,
589: x_org_id cn_rulesets.org_id%TYPE) IS

Line 646: package_name cn_obj_packages_v.name%TYPE,

642: END file_header;
643:
644: PROCEDURE package_header (
645: code IN OUT NOCOPY cn_utils.clob_code_type,
646: package_name cn_obj_packages_v.name%TYPE,
647: description cn_obj_packages_v.description%TYPE,
648: object_type VARCHAR2,
649: x_org_id cn_rules.org_id%TYPE) IS
650:

Line 647: description cn_obj_packages_v.description%TYPE,

643:
644: PROCEDURE package_header (
645: code IN OUT NOCOPY cn_utils.clob_code_type,
646: package_name cn_obj_packages_v.name%TYPE,
647: description cn_obj_packages_v.description%TYPE,
648: object_type VARCHAR2,
649: x_org_id cn_rules.org_id%TYPE) IS
650:
651: X_userid VARCHAR2(20);

Line 1625: package_name cn_obj_packages_v.name%TYPE

1621: x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
1622: x_org_id_in cn_rulesets.org_id% TYPE) RETURN BOOLEAN IS
1623:
1624: -- Declare and initialize procedure variables AE 01-10-96
1625: package_name cn_obj_packages_v.name%TYPE
1626: := 'cn_clsfn' || '_' || ABS(x_ruleset_id_in);
1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';
1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;

Line 1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';

1623:
1624: -- Declare and initialize procedure variables AE 01-10-96
1625: package_name cn_obj_packages_v.name%TYPE
1626: := 'cn_clsfn' || '_' || ABS(x_ruleset_id_in);
1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';
1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;
1630: package_body_id cn_obj_packages_v.package_id%TYPE;
1631: package_spec_desc cn_obj_packages_v.description%TYPE;

Line 1629: package_spec_id cn_obj_packages_v.package_id%TYPE;

1625: package_name cn_obj_packages_v.name%TYPE
1626: := 'cn_clsfn' || '_' || ABS(x_ruleset_id_in);
1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';
1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;
1630: package_body_id cn_obj_packages_v.package_id%TYPE;
1631: package_spec_desc cn_obj_packages_v.description%TYPE;
1632: package_body_desc cn_obj_packages_v.description%TYPE;
1633:

Line 1630: package_body_id cn_obj_packages_v.package_id%TYPE;

1626: := 'cn_clsfn' || '_' || ABS(x_ruleset_id_in);
1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';
1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;
1630: package_body_id cn_obj_packages_v.package_id%TYPE;
1631: package_spec_desc cn_obj_packages_v.description%TYPE;
1632: package_body_desc cn_obj_packages_v.description%TYPE;
1633:
1634: x_repository_id cn_repositories.repository_id%TYPE

Line 1631: package_spec_desc cn_obj_packages_v.description%TYPE;

1627: package_type cn_obj_packages_v.package_type%TYPE := 'CLS';
1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;
1630: package_body_id cn_obj_packages_v.package_id%TYPE;
1631: package_spec_desc cn_obj_packages_v.description%TYPE;
1632: package_body_desc cn_obj_packages_v.description%TYPE;
1633:
1634: x_repository_id cn_repositories.repository_id%TYPE
1635: := cn_utils.get_repository(x_module_id,x_org_id_in);

Line 1632: package_body_desc cn_obj_packages_v.description%TYPE;

1628:
1629: package_spec_id cn_obj_packages_v.package_id%TYPE;
1630: package_body_id cn_obj_packages_v.package_id%TYPE;
1631: package_spec_desc cn_obj_packages_v.description%TYPE;
1632: package_body_desc cn_obj_packages_v.description%TYPE;
1633:
1634: x_repository_id cn_repositories.repository_id%TYPE
1635: := cn_utils.get_repository(x_module_id,x_org_id_in);
1636: x_event_id cn_events.event_id%TYPE