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.XDP_INTERFACES_PUB_W dependencies on DBMS_LOB

Line 884: l_index := dbms_lob.INSTR(p_inStr,p_delimiter,p_start_index);

880: AS
881: l_index NUMBER;
882: l_first_str VARCHAR2(32000);
883: BEGIN
884: l_index := dbms_lob.INSTR(p_inStr,p_delimiter,p_start_index);
885: IF l_index = 0 THEN
886: l_first_str := dbms_lob.substr(p_inStr);
887: p_start_index := dbms_lob.GETLENGTH(p_instr);
888: ELSE

Line 886: l_first_str := dbms_lob.substr(p_inStr);

882: l_first_str VARCHAR2(32000);
883: BEGIN
884: l_index := dbms_lob.INSTR(p_inStr,p_delimiter,p_start_index);
885: IF l_index = 0 THEN
886: l_first_str := dbms_lob.substr(p_inStr);
887: p_start_index := dbms_lob.GETLENGTH(p_instr);
888: ELSE
889: l_first_str := dbms_lob.substr(p_inStr,l_index-p_start_index,p_start_index);
890: p_start_index := l_index+length(p_delimiter);

Line 887: p_start_index := dbms_lob.GETLENGTH(p_instr);

883: BEGIN
884: l_index := dbms_lob.INSTR(p_inStr,p_delimiter,p_start_index);
885: IF l_index = 0 THEN
886: l_first_str := dbms_lob.substr(p_inStr);
887: p_start_index := dbms_lob.GETLENGTH(p_instr);
888: ELSE
889: l_first_str := dbms_lob.substr(p_inStr,l_index-p_start_index,p_start_index);
890: p_start_index := l_index+length(p_delimiter);
891: END IF;

Line 889: l_first_str := dbms_lob.substr(p_inStr,l_index-p_start_index,p_start_index);

885: IF l_index = 0 THEN
886: l_first_str := dbms_lob.substr(p_inStr);
887: p_start_index := dbms_lob.GETLENGTH(p_instr);
888: ELSE
889: l_first_str := dbms_lob.substr(p_inStr,l_index-p_start_index,p_start_index);
890: p_start_index := l_index+length(p_delimiter);
891: END IF;
892:
893: IF length(l_first_str)=0 THEN

Line 1217: dbms_lob.createtemporary(lg_order_param_clob,true);

1213: x_order_param OUT NOCOPY CLOB,
1214: x_line_param OUT NOCOPY CLOB
1215: ) AS
1216: BEGIN
1217: dbms_lob.createtemporary(lg_order_param_clob,true);
1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);

Line 1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);

1214: x_line_param OUT NOCOPY CLOB
1215: ) AS
1216: BEGIN
1217: dbms_lob.createtemporary(lg_order_param_clob,true);
1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);
1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);

Line 1219: dbms_lob.createtemporary(lg_line_clob,true);

1215: ) AS
1216: BEGIN
1217: dbms_lob.createtemporary(lg_order_param_clob,true);
1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);
1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);
1223: x_line := lg_line_clob;

Line 1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);

1216: BEGIN
1217: dbms_lob.createtemporary(lg_order_param_clob,true);
1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);
1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);
1223: x_line := lg_line_clob;
1224: x_order_param := lg_order_param_clob;

Line 1221: dbms_lob.createtemporary(lg_line_param_clob,true);

1217: dbms_lob.createtemporary(lg_order_param_clob,true);
1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);
1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);
1223: x_line := lg_line_clob;
1224: x_order_param := lg_order_param_clob;
1225: x_line_param := lg_line_param_clob;

Line 1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);

1218: dbms_lob.open(lg_order_param_clob,dbms_lob.lob_readwrite);
1219: dbms_lob.createtemporary(lg_line_clob,true);
1220: dbms_lob.open(lg_line_clob,dbms_lob.lob_readwrite);
1221: dbms_lob.createtemporary(lg_line_param_clob,true);
1222: dbms_lob.open(lg_line_param_clob,dbms_lob.lob_readwrite);
1223: x_line := lg_line_clob;
1224: x_order_param := lg_order_param_clob;
1225: x_line_param := lg_line_param_clob;
1226: END GET_CLOBS;

Line 1230: dbms_lob.freetemporary(lg_order_param_clob);

1226: END GET_CLOBS;
1227:
1228: PROCEDURE FREE_CLOBS AS
1229: BEGIN
1230: dbms_lob.freetemporary(lg_order_param_clob);
1231: dbms_lob.freetemporary(lg_line_clob);
1232: dbms_lob.freetemporary(lg_line_param_clob);
1233: END FREE_CLOBS;
1234:

Line 1231: dbms_lob.freetemporary(lg_line_clob);

1227:
1228: PROCEDURE FREE_CLOBS AS
1229: BEGIN
1230: dbms_lob.freetemporary(lg_order_param_clob);
1231: dbms_lob.freetemporary(lg_line_clob);
1232: dbms_lob.freetemporary(lg_line_param_clob);
1233: END FREE_CLOBS;
1234:
1235: PROCEDURE PROCESS_ORDER(

Line 1232: dbms_lob.freetemporary(lg_line_param_clob);

1228: PROCEDURE FREE_CLOBS AS
1229: BEGIN
1230: dbms_lob.freetemporary(lg_order_param_clob);
1231: dbms_lob.freetemporary(lg_line_clob);
1232: dbms_lob.freetemporary(lg_line_param_clob);
1233: END FREE_CLOBS;
1234:
1235: PROCEDURE PROCESS_ORDER(
1236: p_api_version VARCHAR2

Line 1266: l_clob_length := DBMS_LOB.GETLENGTH(p_order_params);

1262: BEGIN
1263: l_encoded_str := p_order_header;
1264: ddp_order_header := create_order(l_encoded_str);
1265: l_pointer := 1;
1266: l_clob_length := DBMS_LOB.GETLENGTH(p_order_params);
1267: IF l_clob_length > 0 THEN
1268: l_index := 1;
1269: LOOP
1270: ddp_order_param_list(l_pointer) := get_order_param(p_order_params,l_index);

Line 1279: l_clob_length := DBMS_LOB.GETLENGTH(p_order_line_params);

1275: END LOOP;
1276: END IF;
1277:
1278: l_pointer := 1;
1279: l_clob_length := DBMS_LOB.GETLENGTH(p_order_line_params);
1280: IF l_clob_length > 0 THEN
1281: l_index := 1;
1282: LOOP
1283: ddp_line_param_list(l_pointer) := get_order_line_param(p_order_line_params,l_index);

Line 1292: l_clob_length := DBMS_LOB.GETLENGTH(p_order_line);

1288: END LOOP;
1289: END IF;
1290:
1291: l_pointer := 1;
1292: l_clob_length := DBMS_LOB.GETLENGTH(p_order_line);
1293: IF l_clob_length > 0 THEN
1294: l_index := 1;
1295: LOOP
1296: ddp_order_line_list(l_pointer) := get_order_line(p_order_line,l_index);