APPS.FA_XLA_CMP_EXTRACT_PKG dependencies on DBMS_SQL

Line 552: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

548:
549: FUNCTION GeneratePrivateProcedures
550: (p_package_name IN VARCHAR2
551: ,p_extract_type IN VARCHAR2
552: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
553: RETURN BOOLEAN IS
554:
555: l_IsCompiled BOOLEAN;
556: l_IsGenerated BOOLEAN;

Line 558: l_array_body DBMS_SQL.VARCHAR2S;

554:
555: l_IsCompiled BOOLEAN;
556: l_IsGenerated BOOLEAN;
557:
558: l_array_body DBMS_SQL.VARCHAR2S;
559: l_array_string DBMS_SQL.VARCHAR2S;
560: l_procedure_name varchar2(80) := 'GeneratePrivateProcedures';
561:
562: BEGIN

Line 559: l_array_string DBMS_SQL.VARCHAR2S;

555: l_IsCompiled BOOLEAN;
556: l_IsGenerated BOOLEAN;
557:
558: l_array_body DBMS_SQL.VARCHAR2S;
559: l_array_string DBMS_SQL.VARCHAR2S;
560: l_procedure_name varchar2(80) := 'GeneratePrivateProcedures';
561:
562: BEGIN
563:

Line 760: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

756:
757: FUNCTION GenerateBody
758: (p_package_name IN VARCHAR2
759: ,p_extract_type IN VARCHAR2
760: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
761: RETURN BOOLEAN IS
762:
763: l_IsCompiled BOOLEAN;
764: l_procedure_name varchar2(80) := 'GenerateBody';

Line 828: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)

824: +--------------------------------------------------------------*/
825:
826: FUNCTION GenerateBodyPackage
827: (p_extract_type IN VARCHAR2
828: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
829: RETURN BOOLEAN IS
830:
831: l_array_pkg DBMS_SQL.VARCHAR2S;
832: l_BodyPkg VARCHAR2(32000);

Line 831: l_array_pkg DBMS_SQL.VARCHAR2S;

827: (p_extract_type IN VARCHAR2
828: ,p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S)
829: RETURN BOOLEAN IS
830:
831: l_array_pkg DBMS_SQL.VARCHAR2S;
832: l_BodyPkg VARCHAR2(32000);
833: l_array_body DBMS_SQL.VARCHAR2S;
834: l_IsCompiled BOOLEAN;
835: l_procedure_name varchar2(80) := 'GenerateBodyPackage';

Line 833: l_array_body DBMS_SQL.VARCHAR2S;

829: RETURN BOOLEAN IS
830:
831: l_array_pkg DBMS_SQL.VARCHAR2S;
832: l_BodyPkg VARCHAR2(32000);
833: l_array_body DBMS_SQL.VARCHAR2S;
834: l_IsCompiled BOOLEAN;
835: l_procedure_name varchar2(80) := 'GenerateBodyPackage';
836:
837: BEGIN

Line 941: l_Package DBMS_SQL.VARCHAR2S;

937: FUNCTION CreateBodyPackage
938: (p_extract_type IN VARCHAR2)
939: RETURN BOOLEAN IS
940:
941: l_Package DBMS_SQL.VARCHAR2S;
942: l_PackageName VARCHAR2(30);
943: l_ProductRuleName VARCHAR2(80);
944: l_ProductRuleVersion VARCHAR2(30);
945: