APPS.ZPB_AW_STATUS dependencies on DBMS_LOB

Line 23: l_length := DBMS_LOB.GETLENGTH(p_sql);

19: l_pos INTEGER;
20: l_length INTEGER;
21: l_count INTEGER;
22: BEGIN
23: l_length := DBMS_LOB.GETLENGTH(p_sql);
24: l_pos := 1;
25: l_count := 0;
26: l_members := null;
27: while (l_pos <= l_length) loop

Line 28: l_text(l_count) := DBMS_LOB.SUBSTR(p_sql, 150, l_pos);

24: l_pos := 1;
25: l_count := 0;
26: l_members := null;
27: while (l_pos <= l_length) loop
28: l_text(l_count) := DBMS_LOB.SUBSTR(p_sql, 150, l_pos);
29: l_count := l_count+1;
30: l_pos := l_pos+150;
31: end loop;
32:

Line 142: DBMS_LOB.WRITEAPPEND(l_sql_statement,

138: l_dimension := each.dimension_name;
139: l_sql_statement := each.status_sql;
140: else
141: l_dimension := each.dimension_name;
142: DBMS_LOB.WRITEAPPEND(l_sql_statement,
143: length(each.status_sql),
144: each.status_sql);
145: end if;
146: end loop;

Line 228: i := DBMS_LOB.INSTR(p_sql, l_excView);

224: l_excCol := zpb_metadata_names.get_exception_column;
225: l_excViewLen := length(l_excView);
226: l_excColLen := length(l_excCol);
227:
228: i := DBMS_LOB.INSTR(p_sql, l_excView);
229: loop
230: exit when i = 0;
231: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newView||DBMS_LOB.SUBSTR(p_sql, i+l_excViewLen);
232: i := DBMS_LOB.INSTR(p_sql, l_excView, i);

Line 231: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newView||DBMS_LOB.SUBSTR(p_sql, i+l_excViewLen);

227:
228: i := DBMS_LOB.INSTR(p_sql, l_excView);
229: loop
230: exit when i = 0;
231: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newView||DBMS_LOB.SUBSTR(p_sql, i+l_excViewLen);
232: i := DBMS_LOB.INSTR(p_sql, l_excView, i);
233: end loop;
234:
235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);

Line 232: i := DBMS_LOB.INSTR(p_sql, l_excView, i);

228: i := DBMS_LOB.INSTR(p_sql, l_excView);
229: loop
230: exit when i = 0;
231: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newView||DBMS_LOB.SUBSTR(p_sql, i+l_excViewLen);
232: i := DBMS_LOB.INSTR(p_sql, l_excView, i);
233: end loop;
234:
235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);
236: loop

Line 235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);

231: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newView||DBMS_LOB.SUBSTR(p_sql, i+l_excViewLen);
232: i := DBMS_LOB.INSTR(p_sql, l_excView, i);
233: end loop;
234:
235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);
236: loop
237: exit when i = 0;
238: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newCol||DBMS_LOB.SUBSTR(p_sql, i+l_excColLen);
239: i := DBMS_LOB.INSTR(p_sql, l_excCol, i);

Line 238: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newCol||DBMS_LOB.SUBSTR(p_sql, i+l_excColLen);

234:
235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);
236: loop
237: exit when i = 0;
238: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newCol||DBMS_LOB.SUBSTR(p_sql, i+l_excColLen);
239: i := DBMS_LOB.INSTR(p_sql, l_excCol, i);
240: end loop;
241:
242: end REPLACE_EXCEPTION_OBJS;

Line 239: i := DBMS_LOB.INSTR(p_sql, l_excCol, i);

235: i:= DBMS_LOB.INSTR(p_sql, l_excCol);
236: loop
237: exit when i = 0;
238: p_sql := DBMS_LOB.SUBSTR(p_sql, 1, i-1)||p_newCol||DBMS_LOB.SUBSTR(p_sql, i+l_excColLen);
239: i := DBMS_LOB.INSTR(p_sql, l_excCol, i);
240: end loop;
241:
242: end REPLACE_EXCEPTION_OBJS;
243:

Line 326: DBMS_LOB.WRITEAPPEND(l_sql_statement,

322: l_dimension := each.dimension_name;
323: l_sql_statement := each.status_sql;
324: else
325: l_dimension := each.dimension_name;
326: DBMS_LOB.WRITEAPPEND(l_sql_statement,
327: length(each.status_sql),
328: each.status_sql);
329: end if;
330: end loop;