APPS.FA_XLA_CMP_CREATE_PKG dependencies on DBMS_SQL

Line 278: p_package_text IN DBMS_SQL.VARCHAR2S

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

Line 548: p_package_text IN DBMS_SQL.VARCHAR2S

544: --| function called with package_text not null |
545: --+==========================================================================+
546:
547: FUNCTION CreateBodyPackage( p_package_name IN VARCHAR2,
548: p_package_text IN DBMS_SQL.VARCHAR2S
549: )
550: RETURN BOOLEAN IS
551:
552: l_package_text DBMS_SQL.VARCHAR2S;

Line 552: l_package_text DBMS_SQL.VARCHAR2S;

548: p_package_text IN DBMS_SQL.VARCHAR2S
549: )
550: RETURN BOOLEAN IS
551:
552: l_package_text DBMS_SQL.VARCHAR2S;
553: l_created_flag BOOLEAN := FALSE;
554: l_IsValid BOOLEAN := TRUE;
555: l_procedure_name varchar2(80) := 'CreateBodyPackage';
556:

Line 690: p_ddl_text IN DBMS_SQL.VARCHAR2S

686:
687:
688: FUNCTION execute_ddl
689: (
690: p_ddl_text IN DBMS_SQL.VARCHAR2S
691: )
692: RETURN BOOLEAN IS
693:
694: l_lb INTEGER ;

Line 778: l_dml_text DBMS_SQL.VARCHAR2S;

774: l_ub INTEGER ;
775: l_return_value BOOLEAN;
776: compilation_fails EXCEPTION;
777: package_locked EXCEPTION;
778: l_dml_text DBMS_SQL.VARCHAR2S;
779: l_procedure_name varchar2(80) := 'execute_dml';
780: l_fatal_error_message_text VARCHAR2(100);
781:
782: BEGIN

Line 847: l_ddl_text DBMS_SQL.VARCHAR2S;

843: l_cur_position INTEGER;
844: l_next_cr_position INTEGER;
845: l_text_length INTEGER;
846: l_additional_sql_stmt VARCHAR2(2000);
847: l_ddl_text DBMS_SQL.VARCHAR2S;
848: l_procedure_name varchar2(80) := 'push_database_object';
849:
850: le_table_not_exists EXCEPTION;
851: le_compilation_fails EXCEPTION;