APPS.XLA_CMP_CREATE_PKG dependencies on DBMS_SQL

Line 458: , p_package_text IN DBMS_SQL.VARCHAR2S

454: --+==========================================================================+
455: FUNCTION CreateBodyPackage ( p_product_rule_name IN VARCHAR2
456: , p_package_name IN VARCHAR2
457: , p_package_type IN VARCHAR2
458: , p_package_text IN DBMS_SQL.VARCHAR2S
459: )
460: RETURN BOOLEAN
461: IS
462: --

Line 858: , p_package_text IN DBMS_SQL.VARCHAR2S

854: --+==========================================================================+
855:
856: FUNCTION CreateBodyPackage( p_product_rule_name IN VARCHAR2
857: , p_package_name IN VARCHAR2
858: , p_package_text IN DBMS_SQL.VARCHAR2S
859: )
860: RETURN BOOLEAN
861: IS
862: --

Line 863: l_package_text DBMS_SQL.VARCHAR2S;

859: )
860: RETURN BOOLEAN
861: IS
862: --
863: l_package_text DBMS_SQL.VARCHAR2S;
864: l_created_flag BOOLEAN := FALSE;
865: l_IsValid BOOLEAN := TRUE;
866: l_log_module VARCHAR2(240);
867: --

Line 1022: p_ddl_text IN DBMS_SQL.VARCHAR2S

1018:
1019:
1020: FUNCTION execute_ddl
1021: (
1022: p_ddl_text IN DBMS_SQL.VARCHAR2S
1023: )
1024: RETURN BOOLEAN
1025: IS
1026: l_lb INTEGER ;

Line 1150: l_dml_text DBMS_SQL.VARCHAR2S;

1146: l_ub INTEGER ;
1147: l_return_value BOOLEAN;
1148: compilation_fails EXCEPTION;
1149: package_locked EXCEPTION;
1150: l_dml_text DBMS_SQL.VARCHAR2S;
1151: l_log_module VARCHAR2(2000);
1152: l_fatal_error_message_text VARCHAR2(100);
1153: l_msg_mode VARCHAR2(1);
1154:

Line 1238: l_ddl_text DBMS_SQL.VARCHAR2S;

1234: l_cur_position INTEGER;
1235: l_next_cr_position INTEGER;
1236: l_text_length INTEGER;
1237: l_additional_sql_stmt VARCHAR2(2000);
1238: l_ddl_text DBMS_SQL.VARCHAR2S;
1239: l_log_module VARCHAR2 (2000);
1240:
1241: le_table_not_exists EXCEPTION;
1242: le_compilation_fails EXCEPTION;