132:
133:
134: FUNCTION GenerateLoadExtract
135: (p_extract_type IN VARCHAR2,
136: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
137:
138: l_array_pkg DBMS_SQL.VARCHAR2S;
139: l_BodyPkg VARCHAR2(32000);
140: l_array_body DBMS_SQL.VARCHAR2S;
134: FUNCTION GenerateLoadExtract
135: (p_extract_type IN VARCHAR2,
136: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
137:
138: l_array_pkg DBMS_SQL.VARCHAR2S;
139: l_BodyPkg VARCHAR2(32000);
140: l_array_body DBMS_SQL.VARCHAR2S;
141: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
142:
136: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
137:
138: l_array_pkg DBMS_SQL.VARCHAR2S;
139: l_BodyPkg VARCHAR2(32000);
140: l_array_body DBMS_SQL.VARCHAR2S;
141: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
142:
143: BEGIN
144: