APPS.FA_XLA_CMP_SOURCES_PKG dependencies on DBMS_SQL

Line 1259: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS

1255:
1256: FUNCTION GenerateSourcesExtract
1257: (p_extract_type IN VARCHAR2, -- dep/trx/def
1258: p_level IN VARCHAR2, -- header/line/stg
1259: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1260:
1261:
1262: cursor c_tables (p_tables fa_char30_tbl_type,
1263: p_schemas fa_char30_tbl_type) is

Line 1447: l_array_pkg DBMS_SQL.VARCHAR2S;

1443: l_index number;
1444:
1445: l_add_tl_in_use boolean := FALSE;
1446:
1447: l_array_pkg DBMS_SQL.VARCHAR2S;
1448: l_BodyPkg VARCHAR2(32000);
1449: l_array_body DBMS_SQL.VARCHAR2S;
1450: l_procedure_name varchar2(80) := 'GenerateSourcesExtract';
1451:

Line 1449: l_array_body DBMS_SQL.VARCHAR2S;

1445: l_add_tl_in_use boolean := FALSE;
1446:
1447: l_array_pkg DBMS_SQL.VARCHAR2S;
1448: l_BodyPkg VARCHAR2(32000);
1449: l_array_body DBMS_SQL.VARCHAR2S;
1450: l_procedure_name varchar2(80) := 'GenerateSourcesExtract';
1451:
1452: invalid_mode EXCEPTION;
1453: table_not_found EXCEPTION;