eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_UTILS dependencies on CN_OBJ_PACKAGES_V

Line 534: package_name cn_obj_packages_v.name%TYPE,

530: --end clob
531:
532: PROCEDURE pkg_init_boilerplate (
533: code IN OUT NOCOPY cn_utils.code_type,
534: package_name cn_obj_packages_v.name%TYPE,
535: description cn_obj_packages_v.description%TYPE,
536: object_type VARCHAR2) IS
537:
538: X_userid VARCHAR2(20);

Line 535: description cn_obj_packages_v.description%TYPE,

531:
532: PROCEDURE pkg_init_boilerplate (
533: code IN OUT NOCOPY cn_utils.code_type,
534: package_name cn_obj_packages_v.name%TYPE,
535: description cn_obj_packages_v.description%TYPE,
536: object_type VARCHAR2) IS
537:
538: X_userid VARCHAR2(20);
539:

Line 577: package_name cn_obj_packages_v.name%TYPE,

573:
574: --for clob
575: PROCEDURE pkg_init_boilerplate (
576: code IN OUT NOCOPY cn_utils.clob_code_type,
577: package_name cn_obj_packages_v.name%TYPE,
578: description cn_obj_packages_v.description%TYPE,
579: object_type VARCHAR2) IS
580: X_userid VARCHAR2(20);
581:

Line 578: description cn_obj_packages_v.description%TYPE,

574: --for clob
575: PROCEDURE pkg_init_boilerplate (
576: code IN OUT NOCOPY cn_utils.clob_code_type,
577: package_name cn_obj_packages_v.name%TYPE,
578: description cn_obj_packages_v.description%TYPE,
579: object_type VARCHAR2) IS
580: X_userid VARCHAR2(20);
581:
582: BEGIN

Line 620: object_type cn_obj_packages_v.object_type%TYPE) IS

616:
617:
618: PROCEDURE pkg_end_boilerplate (
619: code IN OUT NOCOPY cn_utils.code_type,
620: object_type cn_obj_packages_v.object_type%TYPE) IS
621:
622: BEGIN
623: cn_utils.appendcr(code, 'END &' || 'PACKAGE_NAME;');
624: cn_utils.appendcr(code, '/');

Line 650: object_type cn_obj_packages_v.object_type%TYPE) IS

646:
647: --for clob
648: PROCEDURE pkg_end_boilerplate (
649: code IN OUT NOCOPY cn_utils.clob_code_type,
650: object_type cn_obj_packages_v.object_type%TYPE) IS
651:
652: BEGIN
653: cn_utils.appendcr(code, 'END &' || 'PACKAGE_NAME;');
654: cn_utils.appendcr(code, '/');

Line 680: package_name cn_obj_packages_v.name%TYPE,

676: --end clob
677:
678: PROCEDURE pkg_init (
679: module_id cn_modules.module_id%TYPE,
680: package_name cn_obj_packages_v.name%TYPE,
681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

Line 682: package_type cn_obj_packages_v.package_type%TYPE,

678: PROCEDURE pkg_init (
679: module_id cn_modules.module_id%TYPE,
680: package_name cn_obj_packages_v.name%TYPE,
681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
685: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
686: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

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

679: module_id cn_modules.module_id%TYPE,
680: package_name cn_obj_packages_v.name%TYPE,
681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
685: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
686: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
687:

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

680: package_name cn_obj_packages_v.name%TYPE,
681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
685: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
686: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
687:
688: spec_code IN OUT NOCOPY cn_utils.code_type,

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

681: package_org_append VARCHAR2,
682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
685: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
686: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
687:
688: spec_code IN OUT NOCOPY cn_utils.code_type,
689: body_code IN OUT NOCOPY cn_utils.code_type) IS

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

682: package_type cn_obj_packages_v.package_type%TYPE,
683: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
684: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
685: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
686: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
687:
688: spec_code IN OUT NOCOPY cn_utils.code_type,
689: body_code IN OUT NOCOPY cn_utils.code_type) IS
690:

Line 721: package_name cn_obj_packages_v.name%TYPE,

717: END pkg_init;
718:
719:
720: PROCEDURE pkg_end (
721: package_name cn_obj_packages_v.name%TYPE,
722: package_spec_id cn_obj_packages_v.package_id%TYPE,
723: package_body_id cn_obj_packages_v.package_id%TYPE,
724: spec_code IN OUT NOCOPY cn_utils.code_type,
725: body_code IN OUT NOCOPY cn_utils.code_type) IS

Line 722: package_spec_id cn_obj_packages_v.package_id%TYPE,

718:
719:
720: PROCEDURE pkg_end (
721: package_name cn_obj_packages_v.name%TYPE,
722: package_spec_id cn_obj_packages_v.package_id%TYPE,
723: package_body_id cn_obj_packages_v.package_id%TYPE,
724: spec_code IN OUT NOCOPY cn_utils.code_type,
725: body_code IN OUT NOCOPY cn_utils.code_type) IS
726:

Line 723: package_body_id cn_obj_packages_v.package_id%TYPE,

719:
720: PROCEDURE pkg_end (
721: package_name cn_obj_packages_v.name%TYPE,
722: package_spec_id cn_obj_packages_v.package_id%TYPE,
723: package_body_id cn_obj_packages_v.package_id%TYPE,
724: spec_code IN OUT NOCOPY cn_utils.code_type,
725: body_code IN OUT NOCOPY cn_utils.code_type) IS
726:
727: BEGIN

Line 738: package_name cn_obj_packages_v.name%TYPE,

734: END pkg_end;
735:
736: --for clob
737: PROCEDURE pkg_end (
738: package_name cn_obj_packages_v.name%TYPE,
739: package_spec_id cn_obj_packages_v.package_id%TYPE,
740: package_body_id cn_obj_packages_v.package_id%TYPE,
741: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
742: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS

Line 739: package_spec_id cn_obj_packages_v.package_id%TYPE,

735:
736: --for clob
737: PROCEDURE pkg_end (
738: package_name cn_obj_packages_v.name%TYPE,
739: package_spec_id cn_obj_packages_v.package_id%TYPE,
740: package_body_id cn_obj_packages_v.package_id%TYPE,
741: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
742: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
743:

Line 740: package_body_id cn_obj_packages_v.package_id%TYPE,

736: --for clob
737: PROCEDURE pkg_end (
738: package_name cn_obj_packages_v.name%TYPE,
739: package_spec_id cn_obj_packages_v.package_id%TYPE,
740: package_body_id cn_obj_packages_v.package_id%TYPE,
741: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
742: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
743:
744: BEGIN

Line 757: package_name cn_obj_packages_v.name%TYPE,

753:
754:
755: -- overloaded for use in formula generation
756: PROCEDURE pkg_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
757: package_name cn_obj_packages_v.name%TYPE,
758: description cn_obj_packages_v.description%TYPE,
759: object_type VARCHAR2,
760: package_flag VARCHAR2 ) IS
761:

Line 758: description cn_obj_packages_v.description%TYPE,

754:
755: -- overloaded for use in formula generation
756: PROCEDURE pkg_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
757: package_name cn_obj_packages_v.name%TYPE,
758: description cn_obj_packages_v.description%TYPE,
759: object_type VARCHAR2,
760: package_flag VARCHAR2 ) IS
761:
762: X_userid VARCHAR2(20);

Line 796: package_name cn_obj_packages_v.name%TYPE,

792: --for clob
793:
794: -- overloaded for use in formula generation
795: PROCEDURE pkg_init_boilerplate (code IN OUT NOCOPY cn_utils.clob_code_type,
796: package_name cn_obj_packages_v.name%TYPE,
797: description cn_obj_packages_v.description%TYPE,
798: object_type VARCHAR2,
799: package_flag VARCHAR2 ) IS
800:

Line 797: description cn_obj_packages_v.description%TYPE,

793:
794: -- overloaded for use in formula generation
795: PROCEDURE pkg_init_boilerplate (code IN OUT NOCOPY cn_utils.clob_code_type,
796: package_name cn_obj_packages_v.name%TYPE,
797: description cn_obj_packages_v.description%TYPE,
798: object_type VARCHAR2,
799: package_flag VARCHAR2 ) IS
800:
801: X_userid VARCHAR2(20);

Line 837: package_name cn_obj_packages_v.name%TYPE,

833:
834: -- overloaded for use in formula generation, adding package_flag = 'FORMULA'
835: PROCEDURE pkg_init (
836: module_id cn_modules.module_id%TYPE,
837: package_name cn_obj_packages_v.name%TYPE,
838: package_org_append VARCHAR2,
839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

Line 839: package_type cn_obj_packages_v.package_type%TYPE,

835: PROCEDURE pkg_init (
836: module_id cn_modules.module_id%TYPE,
837: package_name cn_obj_packages_v.name%TYPE,
838: package_org_append VARCHAR2,
839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
842: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
843: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

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

837: package_name cn_obj_packages_v.name%TYPE,
838: package_org_append VARCHAR2,
839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
842: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
843: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
844: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
845: spec_code IN OUT NOCOPY cn_utils.code_type,

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

838: package_org_append VARCHAR2,
839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
842: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
843: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
844: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
845: spec_code IN OUT NOCOPY cn_utils.code_type,
846: body_code IN OUT NOCOPY cn_utils.code_type) IS

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

839: package_type cn_obj_packages_v.package_type%TYPE,
840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
842: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
843: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
844: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
845: spec_code IN OUT NOCOPY cn_utils.code_type,
846: body_code IN OUT NOCOPY cn_utils.code_type) IS
847:

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

840: package_flag VARCHAR2,
841: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
842: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
843: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
844: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
845: spec_code IN OUT NOCOPY cn_utils.code_type,
846: body_code IN OUT NOCOPY cn_utils.code_type) IS
847:
848: x_rowid ROWID;

Line 880: package_name cn_obj_packages_v.name%TYPE,

876: --for clob
877: -- overloaded for use in formula generation, adding package_flag = 'FORMULA'
878: PROCEDURE pkg_init (
879: module_id cn_modules.module_id%TYPE,
880: package_name cn_obj_packages_v.name%TYPE,
881: package_org_append VARCHAR2,
882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

Line 882: package_type cn_obj_packages_v.package_type%TYPE,

878: PROCEDURE pkg_init (
879: module_id cn_modules.module_id%TYPE,
880: package_name cn_obj_packages_v.name%TYPE,
881: package_org_append VARCHAR2,
882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
885: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
886: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

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

880: package_name cn_obj_packages_v.name%TYPE,
881: package_org_append VARCHAR2,
882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
885: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
886: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
887: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
888: spec_code IN OUT NOCOPY cn_utils.clob_code_type,

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

881: package_org_append VARCHAR2,
882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
885: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
886: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
887: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
888: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
889: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS

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

882: package_type cn_obj_packages_v.package_type%TYPE,
883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
885: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
886: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
887: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
888: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
889: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
890:

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

883: package_flag VARCHAR2,
884: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
885: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
886: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
887: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
888: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
889: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
890:
891: x_rowid ROWID;

Line 923: package_name cn_obj_packages_v.name%TYPE,

919:
920:
921: -- overloaded procedure used for formula generation
922: PROCEDURE pkg_end_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
923: package_name cn_obj_packages_v.name%TYPE,
924: object_type cn_obj_packages_v.object_type%TYPE) IS
925:
926: BEGIN
927: cn_utils.appendcr(code, 'END ' || package_name || ' ;');

Line 924: object_type cn_obj_packages_v.object_type%TYPE) IS

920:
921: -- overloaded procedure used for formula generation
922: PROCEDURE pkg_end_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
923: package_name cn_obj_packages_v.name%TYPE,
924: object_type cn_obj_packages_v.object_type%TYPE) IS
925:
926: BEGIN
927: cn_utils.appendcr(code, 'END ' || package_name || ' ;');
928: cn_utils.appendcr(code);

Line 933: package_name cn_obj_packages_v.name%TYPE,

929: END pkg_end_boilerplate;
930:
931: --for clob
932: PROCEDURE pkg_end_boilerplate (code IN OUT NOCOPY cn_utils.clob_code_type,
933: package_name cn_obj_packages_v.name%TYPE,
934: object_type cn_obj_packages_v.object_type%TYPE) IS
935:
936: BEGIN
937: cn_utils.appendcr(code, 'END ' || package_name || ' ;');

Line 934: object_type cn_obj_packages_v.object_type%TYPE) IS

930:
931: --for clob
932: PROCEDURE pkg_end_boilerplate (code IN OUT NOCOPY cn_utils.clob_code_type,
933: package_name cn_obj_packages_v.name%TYPE,
934: object_type cn_obj_packages_v.object_type%TYPE) IS
935:
936: BEGIN
937: cn_utils.appendcr(code, 'END ' || package_name || ' ;');
938: cn_utils.appendcr(code);

Line 943: PROCEDURE pkg_end (package_name cn_obj_packages_v.name%TYPE,

939: END pkg_end_boilerplate;
940: --end clob
941:
942: -- overloaded procedure for use in formula generation
943: PROCEDURE pkg_end (package_name cn_obj_packages_v.name%TYPE,
944: spec_code IN OUT NOCOPY cn_utils.code_type,
945: body_code IN OUT NOCOPY cn_utils.code_type) IS
946:
947: BEGIN

Line 957: PROCEDURE pkg_end (package_name cn_obj_packages_v.name%TYPE,

953: END pkg_end;
954:
955: --for clob
956: -- overloaded procedure for use in formula generation
957: PROCEDURE pkg_end (package_name cn_obj_packages_v.name%TYPE,
958: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
959: body_code IN OUT NOCOPY cn_utils.clob_code_type) IS
960:
961: BEGIN

Line 1410: X_statement_text cn_obj_packages_v.statement_text%TYPE;

1406: PROCEDURE gen_create_subprogram (
1407: X_object_id cn_objects.object_id%TYPE,
1408: code IN OUT NOCOPY cn_utils.code_type) IS
1409:
1410: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1411: BEGIN
1412: cn_debug.print_msg('gen_create_subprogram>>', 1);
1413:
1414: SELECT statement_text

Line 1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;

1436: X_object_id cn_objects.object_id%TYPE,
1437: dump_to_file VARCHAR2,
1438: code IN OUT NOCOPY cn_utils.code_type) IS
1439:
1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1441: X_object_type cn_obj_packages_v.object_type%TYPE;
1442: X_name cn_obj_packages_v.name%TYPE;
1443: X_description cn_obj_packages_v.description%TYPE;
1444:

Line 1441: X_object_type cn_obj_packages_v.object_type%TYPE;

1437: dump_to_file VARCHAR2,
1438: code IN OUT NOCOPY cn_utils.code_type) IS
1439:
1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1441: X_object_type cn_obj_packages_v.object_type%TYPE;
1442: X_name cn_obj_packages_v.name%TYPE;
1443: X_description cn_obj_packages_v.description%TYPE;
1444:
1445: BEGIN

Line 1442: X_name cn_obj_packages_v.name%TYPE;

1438: code IN OUT NOCOPY cn_utils.code_type) IS
1439:
1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1441: X_object_type cn_obj_packages_v.object_type%TYPE;
1442: X_name cn_obj_packages_v.name%TYPE;
1443: X_description cn_obj_packages_v.description%TYPE;
1444:
1445: BEGIN
1446: cn_debug.print_msg('gen_create_package>>', 1);

Line 1443: X_description cn_obj_packages_v.description%TYPE;

1439:
1440: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1441: X_object_type cn_obj_packages_v.object_type%TYPE;
1442: X_name cn_obj_packages_v.name%TYPE;
1443: X_description cn_obj_packages_v.description%TYPE;
1444:
1445: BEGIN
1446: cn_debug.print_msg('gen_create_package>>', 1);
1447: