APPS.IGS_PE_WF_GEN dependencies on DBMS_LOB

Line 1122: l_totalLen := DBMS_LOB.GETLENGTH(p_clob_object);

1118: -- Note same chunk size was used to create the clob.
1119: l_amount := 32767;
1120: l_offset := 1;
1121:
1122: l_totalLen := DBMS_LOB.GETLENGTH(p_clob_object);
1123: l_n_cntr :=0;
1124: WHILE l_totalLen >= l_amount LOOP
1125: DBMS_LOB.READ(p_clob_object, l_amount, l_offset, l_rawBuffer);
1126: l_c_data := l_rawBuffer;

Line 1125: DBMS_LOB.READ(p_clob_object, l_amount, l_offset, l_rawBuffer);

1121:
1122: l_totalLen := DBMS_LOB.GETLENGTH(p_clob_object);
1123: l_n_cntr :=0;
1124: WHILE l_totalLen >= l_amount LOOP
1125: DBMS_LOB.READ(p_clob_object, l_amount, l_offset, l_rawBuffer);
1126: l_c_data := l_rawBuffer;
1127: populate_table(RTRIM(l_c_data));
1128: l_totalLen := l_totalLen - l_amount;
1129: l_offset := l_offset + l_amount;

Line 1133: DBMS_LOB.READ(p_clob_object, l_totalLen, l_offset, l_rawBuffer);

1129: l_offset := l_offset + l_amount;
1130: END LOOP;
1131:
1132: IF l_totalLen > 0 THEN
1133: DBMS_LOB.READ(p_clob_object, l_totalLen, l_offset, l_rawBuffer);
1134: l_c_data := l_rawBuffer;
1135: populate_table(RTRIM(l_c_data));
1136: END IF;
1137:

Line 1243: dbms_lob.createtemporary(l_eventdata, FALSE,DBMS_LOB.CALL);

1239: CLOSE cur_inst_per;
1240:
1241: wf_event.AddParameterToList ( p_name => 'P_BULK_PROC_CONTEXT', p_value => l_c_per_org,p_parameterlist => l_wf_parameter_list_t);
1242: -- Write the clob
1243: dbms_lob.createtemporary(l_eventdata, FALSE,DBMS_LOB.CALL);
1244:
1245:
1246: FOR i IN 1..p_persons_processes.last LOOP
1247:

Line 1257: dbms_lob.writeappend(l_eventdata, length(l_str),l_str);

1253:
1254: IF LENGTH(l_str) >= (32767-15) THEN
1255: --Make a string of length 32767 , after the last person it is space.
1256: l_str:=RPAD(l_str,32767);
1257: dbms_lob.writeappend(l_eventdata, length(l_str),l_str);
1258: l_str:=NULL;
1259: END IF;
1260: END LOOP;
1261:

Line 1265: dbms_lob.writeappend(l_eventdata, length(l_str),l_str);

1261:
1262: IF LENGTH(l_str)> 0 THEN
1263: --Make a string of length 32767 , after the last person it is space.
1264: l_str:=RPAD(l_str,32767);
1265: dbms_lob.writeappend(l_eventdata, length(l_str),l_str);
1266: l_str:=NULL;
1267: END IF;
1268:
1269: --