112:
113:
114: FUNCTION GenerateLineExtract
115: (p_extract_type IN VARCHAR2,
116: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
117:
118: l_loop_total number := 1;
119: l_level varchar2(30);
120: l_extract_type varchar2(30);
119: l_level varchar2(30);
120: l_extract_type varchar2(30);
121: l_proc_name varchar2(80);
122:
123: l_array_pkg DBMS_SQL.VARCHAR2S;
124: l_BodyPkg VARCHAR2(32000);
125: l_array_body DBMS_SQL.VARCHAR2S;
126: l_procedure_name varchar2(80) := 'GenerateLineExtract';
127:
121: l_proc_name varchar2(80);
122:
123: l_array_pkg DBMS_SQL.VARCHAR2S;
124: l_BodyPkg VARCHAR2(32000);
125: l_array_body DBMS_SQL.VARCHAR2S;
126: l_procedure_name varchar2(80) := 'GenerateLineExtract';
127:
128: invalid_mode EXCEPTION;
129: