APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on DBMS_LOB

Line 7002: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);

6998: OPEN old_clob_cur(old_refer_rec.rowid);
6999: FETCH old_clob_cur INTO l_old_clob_data;
7000:
7001: -- open the CLOB and write the LONG data to it
7002: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7003: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7004: dbms_lob.close(l_old_clob_data);
7005: CLOSE old_clob_cur;
7006:

Line 7003: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);

6999: FETCH old_clob_cur INTO l_old_clob_data;
7000:
7001: -- open the CLOB and write the LONG data to it
7002: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7003: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7004: dbms_lob.close(l_old_clob_data);
7005: CLOSE old_clob_cur;
7006:
7007: EXCEPTION

Line 7004: dbms_lob.close(l_old_clob_data);

7000:
7001: -- open the CLOB and write the LONG data to it
7002: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7003: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7004: dbms_lob.close(l_old_clob_data);
7005: CLOSE old_clob_cur;
7006:
7007: EXCEPTION
7008: WHEN OTHERS THEN

Line 7047: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);

7043: OPEN old_clob_cur(old_refer_rec.rowid);
7044: FETCH old_clob_cur INTO l_old_clob_data;
7045:
7046: -- open the CLOB and write the LONG data to it
7047: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7048: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7049: dbms_lob.close(l_old_clob_data);
7050: CLOSE old_clob_cur;
7051:

Line 7048: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);

7044: FETCH old_clob_cur INTO l_old_clob_data;
7045:
7046: -- open the CLOB and write the LONG data to it
7047: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7048: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7049: dbms_lob.close(l_old_clob_data);
7050: CLOSE old_clob_cur;
7051:
7052: EXCEPTION

Line 7049: dbms_lob.close(l_old_clob_data);

7045:
7046: -- open the CLOB and write the LONG data to it
7047: dbms_lob.open(l_old_clob_data, dbms_lob.lob_readwrite);
7048: dbms_lob.write(l_old_clob_data, LENGTH(new_ireference_rec.statement), 1, new_ireference_rec.statement);
7049: dbms_lob.close(l_old_clob_data);
7050: CLOSE old_clob_cur;
7051:
7052: EXCEPTION
7053: WHEN OTHERS THEN