eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CHANGE_REQUEST_PUB dependencies on DBMS_LOB

Line 771: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then

767: -- Call Before Logic Hook
768: --
769: g_corv_rec := p_corv_rec;
770: --
771: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
773: l_clob := p_corv_rec.CHANGE_TEXT;
774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

Line 772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);

768: --
769: g_corv_rec := p_corv_rec;
770: --
771: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
773: l_clob := p_corv_rec.CHANGE_TEXT;
774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

Line 774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);

770: --
771: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
773: l_clob := p_corv_rec.CHANGE_TEXT;
774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));

Line 775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

771: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
773: l_clob := p_corv_rec.CHANGE_TEXT;
774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

Line 776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

772: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
773: l_clob := p_corv_rec.CHANGE_TEXT;
774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
780: DBMS_LOB.CLOSE(l_clob);

Line 778: amount => dbms_lob.getlength(l_clob));

774: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
780: DBMS_LOB.CLOSE(l_clob);
781: DBMS_LOB.freetemporary(l_clob);
782: end if;

Line 779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

775: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
780: DBMS_LOB.CLOSE(l_clob);
781: DBMS_LOB.freetemporary(l_clob);
782: end if;
783: --

Line 780: DBMS_LOB.CLOSE(l_clob);

776: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
780: DBMS_LOB.CLOSE(l_clob);
781: DBMS_LOB.freetemporary(l_clob);
782: end if;
783: --
784: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');

Line 781: DBMS_LOB.freetemporary(l_clob);

777: src_lob => l_clob,
778: amount => dbms_lob.getlength(l_clob));
779: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
780: DBMS_LOB.CLOSE(l_clob);
781: DBMS_LOB.freetemporary(l_clob);
782: end if;
783: --
784: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
785: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 925: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then

921: -- Call Before Logic Hook
922: --
923: g_corv_rec := p_corv_rec;
924: --
925: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
927: l_clob := p_corv_rec.CHANGE_TEXT;
928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

Line 926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);

922: --
923: g_corv_rec := p_corv_rec;
924: --
925: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
927: l_clob := p_corv_rec.CHANGE_TEXT;
928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

Line 928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);

924: --
925: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
927: l_clob := p_corv_rec.CHANGE_TEXT;
928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));

Line 929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

925: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
927: l_clob := p_corv_rec.CHANGE_TEXT;
928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

Line 930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

926: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
927: l_clob := p_corv_rec.CHANGE_TEXT;
928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
934: DBMS_LOB.CLOSE(l_clob);

Line 932: amount => dbms_lob.getlength(l_clob));

928: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
934: DBMS_LOB.CLOSE(l_clob);
935: DBMS_LOB.freetemporary(l_clob);
936: end if;

Line 933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

929: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
934: DBMS_LOB.CLOSE(l_clob);
935: DBMS_LOB.freetemporary(l_clob);
936: end if;
937: --

Line 934: DBMS_LOB.CLOSE(l_clob);

930: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
934: DBMS_LOB.CLOSE(l_clob);
935: DBMS_LOB.freetemporary(l_clob);
936: end if;
937: --
938: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');

Line 935: DBMS_LOB.freetemporary(l_clob);

931: src_lob => l_clob,
932: amount => dbms_lob.getlength(l_clob));
933: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
934: DBMS_LOB.CLOSE(l_clob);
935: DBMS_LOB.freetemporary(l_clob);
936: end if;
937: --
938: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
939: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1212: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then

1208: -- Call Before Logic Hook
1209: --
1210: g_corv_rec := p_corv_rec;
1211: --
1212: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
1214: l_clob := p_corv_rec.CHANGE_TEXT;
1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

Line 1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);

1209: --
1210: g_corv_rec := p_corv_rec;
1211: --
1212: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
1214: l_clob := p_corv_rec.CHANGE_TEXT;
1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

Line 1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);

1211: --
1212: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
1214: l_clob := p_corv_rec.CHANGE_TEXT;
1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));

Line 1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);

1212: if (dbms_lob.istemporary(p_corv_rec.CHANGE_TEXT) = 1) then
1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
1214: l_clob := p_corv_rec.CHANGE_TEXT;
1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

Line 1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,

1213: DBMS_LOB.CREATETEMPORARY(g_corv_rec.CHANGE_TEXT,FALSE,DBMS_LOB.CALL);
1214: l_clob := p_corv_rec.CHANGE_TEXT;
1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
1221: DBMS_LOB.CLOSE(l_clob);

Line 1219: amount => dbms_lob.getlength(l_clob));

1215: DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
1221: DBMS_LOB.CLOSE(l_clob);
1222: DBMS_LOB.freetemporary(l_clob);
1223: end if;

Line 1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);

1216: DBMS_LOB.OPEN(g_corv_rec.CHANGE_TEXT, DBMS_LOB.LOB_READWRITE);
1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
1221: DBMS_LOB.CLOSE(l_clob);
1222: DBMS_LOB.freetemporary(l_clob);
1223: end if;
1224: --

Line 1221: DBMS_LOB.CLOSE(l_clob);

1217: DBMS_LOB.COPY(dest_lob => g_corv_rec.CHANGE_TEXT,
1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
1221: DBMS_LOB.CLOSE(l_clob);
1222: DBMS_LOB.freetemporary(l_clob);
1223: end if;
1224: --
1225: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');

Line 1222: DBMS_LOB.freetemporary(l_clob);

1218: src_lob => l_clob,
1219: amount => dbms_lob.getlength(l_clob));
1220: DBMS_LOB.CLOSE(g_corv_rec.CHANGE_TEXT);
1221: DBMS_LOB.CLOSE(l_clob);
1222: DBMS_LOB.freetemporary(l_clob);
1223: end if;
1224: --
1225: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN