APPS.BSC_UPDATE_UTIL dependencies on DBMS_LOB

Line 740: h_clob_length := dbms_lob.getlength(x_sql);

736: h_str_length number;
737:
738: BEGIN
739: h_str_length := 16000;
740: h_clob_length := dbms_lob.getlength(x_sql);
741: h_sql_tbl.delete;
742: h_i := 0;
743: h_offset := 1;
744: loop

Line 746: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);

742: h_i := 0;
743: h_offset := 1;
744: loop
745: h_i := h_i + 1;
746: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);
747: h_offset := h_offset + h_str_length;
748: exit when h_offset > h_clob_length;
749: end loop;
750:

Line 942: h_clob_length := dbms_lob.getlength(x_sql);

938:
939: BEGIN
940:
941: h_str_length := 16000;
942: h_clob_length := dbms_lob.getlength(x_sql);
943: h_sql_tbl.delete;
944: h_i := 0;
945: h_offset := 1;
946: loop

Line 948: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);

944: h_i := 0;
945: h_offset := 1;
946: loop
947: h_i := h_i + 1;
948: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);
949: h_offset := h_offset + h_str_length;
950: exit when h_offset > h_clob_length;
951: end loop;
952:

Line 1451: h_clob_length := dbms_lob.getlength(x_sql);

1447:
1448: BEGIN
1449:
1450: h_str_length := 16000;
1451: h_clob_length := dbms_lob.getlength(x_sql);
1452: h_sql_tbl.delete;
1453: h_i := 0;
1454: h_offset := 1;
1455: loop

Line 1457: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);

1453: h_i := 0;
1454: h_offset := 1;
1455: loop
1456: h_i := h_i + 1;
1457: h_sql_tbl(h_i) := dbms_lob.substr(x_sql, h_str_length, h_offset);
1458: h_offset := h_offset + h_str_length;
1459: exit when h_offset > h_clob_length;
1460: end loop;
1461: