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

Line 50: DBMS_LOB.OPEN(l_id_list,DBMS_LOB.LOB_READONLY);

46: ,l_purge_set_submit_datetime
47: ,l_orders_per_commit;
48:
49: IF nvl(l_count_selected,0) <> 0 THEN
50: DBMS_LOB.OPEN(l_id_list,DBMS_LOB.LOB_READONLY);
51: l_length := DBMS_LOB.GETLENGTH(l_id_list);
52: oe_debug_pub.add('Lenght of the LOB : '||to_char(l_length));
53:
54: FOR I IN 1..l_count_selected LOOP

Line 51: l_length := DBMS_LOB.GETLENGTH(l_id_list);

47: ,l_orders_per_commit;
48:
49: IF nvl(l_count_selected,0) <> 0 THEN
50: DBMS_LOB.OPEN(l_id_list,DBMS_LOB.LOB_READONLY);
51: l_length := DBMS_LOB.GETLENGTH(l_id_list);
52: oe_debug_pub.add('Lenght of the LOB : '||to_char(l_length));
53:
54: FOR I IN 1..l_count_selected LOOP
55: l_position := DBMS_LOB.INSTR(l_id_list,l_separator,l_start_from,1);

Line 55: l_position := DBMS_LOB.INSTR(l_id_list,l_separator,l_start_from,1);

51: l_length := DBMS_LOB.GETLENGTH(l_id_list);
52: oe_debug_pub.add('Lenght of the LOB : '||to_char(l_length));
53:
54: FOR I IN 1..l_count_selected LOOP
55: l_position := DBMS_LOB.INSTR(l_id_list,l_separator,l_start_from,1);
56: IF l_position <> 0 THEN
57: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_position - l_start_from),l_start_from));
58: ELSE
59: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_length - l_start_from + 1),l_start_from));

Line 57: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_position - l_start_from),l_start_from));

53:
54: FOR I IN 1..l_count_selected LOOP
55: l_position := DBMS_LOB.INSTR(l_id_list,l_separator,l_start_from,1);
56: IF l_position <> 0 THEN
57: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_position - l_start_from),l_start_from));
58: ELSE
59: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_length - l_start_from + 1),l_start_from));
60: END IF;
61: l_selected_ids_tbl(I) := l_header_id;

Line 59: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_length - l_start_from + 1),l_start_from));

55: l_position := DBMS_LOB.INSTR(l_id_list,l_separator,l_start_from,1);
56: IF l_position <> 0 THEN
57: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_position - l_start_from),l_start_from));
58: ELSE
59: l_header_id := to_number(DBMS_LOB.SUBSTR(l_id_list,(l_length - l_start_from + 1),l_start_from));
60: END IF;
61: l_selected_ids_tbl(I) := l_header_id;
62: oe_debug_pub.add('Header id : '||to_char(l_header_id));
63: l_start_from := l_position + 1;

Line 66: DBMS_LOB.CLOSE(l_id_list);

62: oe_debug_pub.add('Header id : '||to_char(l_header_id));
63: l_start_from := l_position + 1;
64: END LOOP;
65:
66: DBMS_LOB.CLOSE(l_id_list);
67:
68: oe_debug_pub.add('Selected Ids : '||l_char_id_list);
69: END IF;
70:

Line 1257: DBMS_LOB.OPEN(l_selected_ids,DBMS_LOB.LOB_READWRITE);

1253: INTO l_selected_ids
1254: FROM OE_PURGE_SETS
1255: WHERE PURGE_SET_ID = l_purge_set_id;
1256:
1257: DBMS_LOB.OPEN(l_selected_ids,DBMS_LOB.LOB_READWRITE);
1258:
1259: FOR I IN 1 .. p_count_selected
1260: LOOP
1261: IF (length(l_buffer) + length(p_selected_ids(I))) > l_amount THEN

Line 1264: DBMS_LOB.WRITE(l_selected_ids,l_amount,l_position,l_buffer);

1260: LOOP
1261: IF (length(l_buffer) + length(p_selected_ids(I))) > l_amount THEN
1262: oe_debug_pub.add('Reached the limit : '||to_char(length(l_buffer)));
1263: l_amount := length(l_buffer);
1264: DBMS_LOB.WRITE(l_selected_ids,l_amount,l_position,l_buffer);
1265: l_buffer := '';
1266: l_position := l_position + l_amount;
1267: END IF;
1268:

Line 1279: DBMS_LOB.WRITE(l_selected_ids,l_amount,l_position,l_buffer);

1275: END LOOP;
1276:
1277: oe_debug_pub.add('Length : '||to_char(length(l_buffer)));
1278: l_amount := length(l_buffer);
1279: DBMS_LOB.WRITE(l_selected_ids,l_amount,l_position,l_buffer);
1280: DBMS_LOB.CLOSE(l_selected_ids);
1281:
1282: oe_debug_pub.add('Value : '||l_buffer);
1283:

Line 1280: DBMS_LOB.CLOSE(l_selected_ids);

1276:
1277: oe_debug_pub.add('Length : '||to_char(length(l_buffer)));
1278: l_amount := length(l_buffer);
1279: DBMS_LOB.WRITE(l_selected_ids,l_amount,l_position,l_buffer);
1280: DBMS_LOB.CLOSE(l_selected_ids);
1281:
1282: oe_debug_pub.add('Value : '||l_buffer);
1283:
1284: END IF;