APPS.FA_XLA_CMP_CREATE_PKG dependencies on DBMS_SQL

Line 279: p_package_text IN DBMS_SQL.VARCHAR2S

275: --+==========================================================================+
276:
277: FUNCTION CreateBodyPackage (p_package_name IN VARCHAR2,
278: p_package_type IN VARCHAR2,
279: p_package_text IN DBMS_SQL.VARCHAR2S
280: )
281: RETURN BOOLEAN IS
282:
283: l_lb INTEGER ;

Line 559: p_package_text IN DBMS_SQL.VARCHAR2S

555: --| function called with package_text not null |
556: --+==========================================================================+
557:
558: FUNCTION CreateBodyPackage( p_package_name IN VARCHAR2,
559: p_package_text IN DBMS_SQL.VARCHAR2S
560: )
561: RETURN BOOLEAN IS
562:
563: l_package_text DBMS_SQL.VARCHAR2S;

Line 563: l_package_text DBMS_SQL.VARCHAR2S;

559: p_package_text IN DBMS_SQL.VARCHAR2S
560: )
561: RETURN BOOLEAN IS
562:
563: l_package_text DBMS_SQL.VARCHAR2S;
564: l_created_flag BOOLEAN := FALSE;
565: l_IsValid BOOLEAN := TRUE;
566: l_procedure_name varchar2(80) := 'CreateBodyPackage';
567:

Line 701: p_ddl_text IN DBMS_SQL.VARCHAR2S

697:
698:
699: FUNCTION execute_ddl
700: (
701: p_ddl_text IN DBMS_SQL.VARCHAR2S
702: )
703: RETURN BOOLEAN IS
704:
705: l_lb INTEGER ;

Line 790: l_dml_text DBMS_SQL.VARCHAR2S;

786: l_ub INTEGER ;
787: l_return_value BOOLEAN;
788: compilation_fails EXCEPTION;
789: package_locked EXCEPTION;
790: l_dml_text DBMS_SQL.VARCHAR2S;
791: l_procedure_name varchar2(80) := 'execute_dml';
792: l_fatal_error_message_text VARCHAR2(100);
793:
794: BEGIN

Line 859: l_ddl_text DBMS_SQL.VARCHAR2S;

855: l_cur_position INTEGER;
856: l_next_cr_position INTEGER;
857: l_text_length INTEGER;
858: l_additional_sql_stmt VARCHAR2(2000);
859: l_ddl_text DBMS_SQL.VARCHAR2S;
860: l_procedure_name varchar2(80) := 'push_database_object';
861:
862: le_table_not_exists EXCEPTION;
863: le_compilation_fails EXCEPTION;