DBA Data[Home] [Help]

APPS.FA_XLA_CMP_HEADER_PKG dependencies on DBMS_SQL

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

200:
201:
202: FUNCTION GenerateHeaderExtract
203: (p_extract_type IN VARCHAR2,
204: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
205:
206: l_loop_total number := 1;
207: l_level varchar2(30);
208: l_extract_type varchar2(30);

Line 211: l_array_pkg DBMS_SQL.VARCHAR2S;

207: l_level varchar2(30);
208: l_extract_type varchar2(30);
209: l_proc_name varchar2(80);
210:
211: l_array_pkg DBMS_SQL.VARCHAR2S;
212: l_BodyPkg VARCHAR2(32000);
213: l_array_body DBMS_SQL.VARCHAR2S;
214: l_procedure_name varchar2(80) := 'GenerateHeaderExtract';
215:

Line 213: l_array_body DBMS_SQL.VARCHAR2S;

209: l_proc_name varchar2(80);
210:
211: l_array_pkg DBMS_SQL.VARCHAR2S;
212: l_BodyPkg VARCHAR2(32000);
213: l_array_body DBMS_SQL.VARCHAR2S;
214: l_procedure_name varchar2(80) := 'GenerateHeaderExtract';
215:
216: invalid_mode EXCEPTION;
217: