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