136: --| Private global constant or variable declarations |
137: --| |
138: --+==========================================================================+
139:
140: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
141:
142: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143:
144: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
570: l_IsCompiled := TRUE;
571: l_IsGenerated := TRUE;
572:
573: -- generate description functions and the call to those functions
574: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
575: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
576:
577: --
578: -- Generate Header Section
571: l_IsGenerated := TRUE;
572:
573: -- generate description functions and the call to those functions
574: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
575: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
576:
577: --
578: -- Generate Header Section
579: --
591:
592: l_IsCompiled := l_IsCompiled AND l_IsGenerated ;
593:
594: l_array_body :=
595: fa_cmp_string_pkg.ConcatTwoStrings
596: (p_array_string_1 => l_array_body
597: ,p_array_string_2 => l_array_string);
598:
599: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
595: fa_cmp_string_pkg.ConcatTwoStrings
596: (p_array_string_1 => l_array_body
597: ,p_array_string_2 => l_array_string);
598:
599: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
600:
601:
602: --
603: -- generate line sections
614: p_package_body => l_array_string);
615:
616:
617: l_array_body :=
618: fa_cmp_string_pkg.ConcatTwoStrings
619: (p_array_string_1 => l_array_body
620: ,p_array_string_2 => l_array_string);
621:
622: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
618: fa_cmp_string_pkg.ConcatTwoStrings
619: (p_array_string_1 => l_array_body
620: ,p_array_string_2 => l_array_string);
621:
622: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
623:
624: l_IsCompiled := l_IsCompiled AND l_IsGenerated;
625:
626:
640: p_package_body => l_array_string);
641:
642:
643: l_array_body :=
644: fa_cmp_string_pkg.ConcatTwoStrings
645: (p_array_string_1 => l_array_body
646: ,p_array_string_2 => l_array_string);
647:
648: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
644: fa_cmp_string_pkg.ConcatTwoStrings
645: (p_array_string_1 => l_array_body
646: ,p_array_string_2 => l_array_string);
647:
648: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
649:
650: l_IsCompiled := l_IsCompiled AND l_IsGenerated;
651:
652:
661: p_package_body => l_array_string);
662:
663:
664: l_array_body :=
665: fa_cmp_string_pkg.ConcatTwoStrings
666: (p_array_string_1 => l_array_body
667: ,p_array_string_2 => l_array_string);
668:
669: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
665: fa_cmp_string_pkg.ConcatTwoStrings
666: (p_array_string_1 => l_array_body
667: ,p_array_string_2 => l_array_string);
668:
669: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
670:
671: l_IsCompiled := l_IsCompiled AND l_IsGenerated ;
672:
673: --
679: (p_extract_type => p_extract_type,
680: p_package_body => l_array_string);
681:
682: l_array_body :=
683: fa_cmp_string_pkg.ConcatTwoStrings
684: (p_array_string_1 => l_array_body
685: ,p_array_string_2 => l_array_string);
686:
687: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
683: fa_cmp_string_pkg.ConcatTwoStrings
684: (p_array_string_1 => l_array_body
685: ,p_array_string_2 => l_array_string);
686:
687: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
688:
689: l_IsCompiled := l_IsCompiled AND l_IsGenerated ;
690:
691:
706:
707: l_IsCompiled := l_IsCompiled AND l_IsGenerated ;
708:
709: l_array_body :=
710: fa_cmp_string_pkg.ConcatTwoStrings
711: (p_array_string_1 => l_array_body
712: ,p_array_string_2 => l_array_string);
713:
714:
711: (p_array_string_1 => l_array_body
712: ,p_array_string_2 => l_array_string);
713:
714:
715: l_array_string := fa_cmp_string_pkg.g_null_varchar2s;
716:
717: p_package_body := l_array_body;
718:
719:
848: 'p_extract_type = '||p_extract_type);
849: END IF;
850:
851: l_IsCompiled := TRUE;
852: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
853: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
854:
855: l_BodyPkg := C_PACKAGE_BODY_1;
856: l_BodyPkg := REPLACE(l_BodyPkg,'$PACKAGE_NAME$' ,g_PackageName);
849: END IF;
850:
851: l_IsCompiled := TRUE;
852: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
853: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
854:
855: l_BodyPkg := C_PACKAGE_BODY_1;
856: l_BodyPkg := REPLACE(l_BodyPkg,'$PACKAGE_NAME$' ,g_PackageName);
857: l_BodyPkg := REPLACE(l_BodyPkg,'$EXTRACT_TYPE$' ,lower(p_extract_type));
864: ));
865:
866: l_BodyPkg := REPLACE(l_BodyPkg,'$PACKAGE_NAME$' ,g_PackageName);
867:
868: fa_cmp_string_pkg.CreateString
869: (p_package_text => l_BodyPkg
870: ,p_array_string => l_array_pkg);
871:
872: l_IsCompiled :=
876: ,p_package_body => l_array_body);
877:
878:
879: l_array_pkg :=
880: fa_cmp_string_pkg.ConcatTwoStrings
881: (p_array_string_1 => l_array_pkg
882: ,p_array_string_2 => l_array_body);
883:
884: fa_cmp_string_pkg.CreateString
880: fa_cmp_string_pkg.ConcatTwoStrings
881: (p_array_string_1 => l_array_pkg
882: ,p_array_string_2 => l_array_body);
883:
884: fa_cmp_string_pkg.CreateString
885: (p_package_text => l_BodyPkg
886: ,p_array_string => l_array_body);
887:
888: l_BodyPkg := C_PACKAGE_BODY_CLOSE ;
887:
888: l_BodyPkg := C_PACKAGE_BODY_CLOSE ;
889: l_BodyPkg := REPLACE(l_BodyPkg,'$PACKAGE_NAME$' ,g_PackageName);
890:
891: fa_cmp_string_pkg.CreateString
892: (p_package_text => l_BodyPkg
893: ,p_array_string => l_array_body);
894:
895: l_array_pkg :=
892: (p_package_text => l_BodyPkg
893: ,p_array_string => l_array_body);
894:
895: l_array_pkg :=
896: fa_cmp_string_pkg.ConcatTwoStrings
897: (p_array_string_1 => l_array_pkg
898: ,p_array_string_2 => l_array_body);
899:
900: p_package_body := l_array_pkg;