1441:
1442: FUNCTION GenerateSourcesExtract
1443: (p_extract_type IN VARCHAR2, -- dep/trx/def
1444: p_level IN VARCHAR2, -- header/line/stg
1445: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
1446:
1447:
1448: cursor c_tables (p_tables fa_char30_tbl_type,
1449: p_schemas fa_char30_tbl_type) is
1632: l_index number;
1633:
1634: l_add_tl_in_use boolean := FALSE;
1635:
1636: l_array_pkg DBMS_SQL.VARCHAR2S;
1637: l_BodyPkg VARCHAR2(32000);
1638: l_array_body DBMS_SQL.VARCHAR2S;
1639: l_procedure_name varchar2(80) := 'GenerateSourcesExtract';
1640:
1634: l_add_tl_in_use boolean := FALSE;
1635:
1636: l_array_pkg DBMS_SQL.VARCHAR2S;
1637: l_BodyPkg VARCHAR2(32000);
1638: l_array_body DBMS_SQL.VARCHAR2S;
1639: l_procedure_name varchar2(80) := 'GenerateSourcesExtract';
1640:
1641: invalid_mode EXCEPTION;
1642: table_not_found EXCEPTION;