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.MRP_PO_RESCHEDULE dependencies on PO_TBL_NUMBER

Line 13: g_po_header_ids po_tbl_number;

9: l_debug varchar2(30) := 'Y';
10: g_dblink VARCHAR2(129);
11:
12: g_po_numbers po_tbl_varchar100;
13: g_po_header_ids po_tbl_number;
14: g_po_line_ids po_tbl_number;
15: g_line_location_ids po_tbl_number;
16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;

Line 14: g_po_line_ids po_tbl_number;

10: g_dblink VARCHAR2(129);
11:
12: g_po_numbers po_tbl_varchar100;
13: g_po_header_ids po_tbl_number;
14: g_po_line_ids po_tbl_number;
15: g_line_location_ids po_tbl_number;
16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;
18: g_promise_dates po_tbl_date;

Line 15: g_line_location_ids po_tbl_number;

11:
12: g_po_numbers po_tbl_varchar100;
13: g_po_header_ids po_tbl_number;
14: g_po_line_ids po_tbl_number;
15: g_line_location_ids po_tbl_number;
16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;
18: g_promise_dates po_tbl_date;
19: g_uoms po_tbl_varchar30;

Line 16: g_distribution_ids po_tbl_number;

12: g_po_numbers po_tbl_varchar100;
13: g_po_header_ids po_tbl_number;
14: g_po_line_ids po_tbl_number;
15: g_line_location_ids po_tbl_number;
16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;
18: g_promise_dates po_tbl_date;
19: g_uoms po_tbl_varchar30;
20: g_operating_units po_tbl_number;

Line 17: g_qtys po_tbl_number;

13: g_po_header_ids po_tbl_number;
14: g_po_line_ids po_tbl_number;
15: g_line_location_ids po_tbl_number;
16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;
18: g_promise_dates po_tbl_date;
19: g_uoms po_tbl_varchar30;
20: g_operating_units po_tbl_number;
21: g_current_rec NUMBER := 1;

Line 20: g_operating_units po_tbl_number;

16: g_distribution_ids po_tbl_number;
17: g_qtys po_tbl_number;
18: g_promise_dates po_tbl_date;
19: g_uoms po_tbl_varchar30;
20: g_operating_units po_tbl_number;
21: g_current_rec NUMBER := 1;
22: g_current_org_id NUMBER := NULL;
23:
24: l_dblink VARCHAR2(129);

Line 57: PROCEDURE debug_number_tbl( p_msg IN VARCHAR2, p_tbl IN po_tbl_number ) IS

53: WHEN OTHERS THEN
54: RAISE;
55: END debug_message;
56:
57: PROCEDURE debug_number_tbl( p_msg IN VARCHAR2, p_tbl IN po_tbl_number ) IS
58: i NUMBER;
59: BEGIN
60: debug_message(p_msg || ' number of changes: ' || p_tbl.COUNT() );
61: FOR i IN 1..p_tbl.COUNT() LOOP

Line 268: g_po_header_ids := po_tbl_number();

264: debug_message('p_dblink' || p_dblink ||'l_dblink ' || l_dblink);
265:
266: g_dblink := l_dblink;
267: g_current_rec := 1;
268: g_po_header_ids := po_tbl_number();
269: g_line_location_ids := po_tbl_number();
270: g_distribution_ids := po_tbl_number();
271: g_qtys := po_tbl_number();
272: g_promise_dates := po_tbl_date();

Line 269: g_line_location_ids := po_tbl_number();

265:
266: g_dblink := l_dblink;
267: g_current_rec := 1;
268: g_po_header_ids := po_tbl_number();
269: g_line_location_ids := po_tbl_number();
270: g_distribution_ids := po_tbl_number();
271: g_qtys := po_tbl_number();
272: g_promise_dates := po_tbl_date();
273: g_uoms := po_tbl_varchar30();

Line 270: g_distribution_ids := po_tbl_number();

266: g_dblink := l_dblink;
267: g_current_rec := 1;
268: g_po_header_ids := po_tbl_number();
269: g_line_location_ids := po_tbl_number();
270: g_distribution_ids := po_tbl_number();
271: g_qtys := po_tbl_number();
272: g_promise_dates := po_tbl_date();
273: g_uoms := po_tbl_varchar30();
274: g_operating_units := po_tbl_number();

Line 271: g_qtys := po_tbl_number();

267: g_current_rec := 1;
268: g_po_header_ids := po_tbl_number();
269: g_line_location_ids := po_tbl_number();
270: g_distribution_ids := po_tbl_number();
271: g_qtys := po_tbl_number();
272: g_promise_dates := po_tbl_date();
273: g_uoms := po_tbl_varchar30();
274: g_operating_units := po_tbl_number();
275:

Line 274: g_operating_units := po_tbl_number();

270: g_distribution_ids := po_tbl_number();
271: g_qtys := po_tbl_number();
272: g_promise_dates := po_tbl_date();
273: g_uoms := po_tbl_varchar30();
274: g_operating_units := po_tbl_number();
275:
276: IF( l_dblink IS NOT NULL ) THEN
277: debug_message('Get data from dblink ' || l_dblink);
278: transfer_to_temp_table( l_dblink, l_instance_id, p_batch_id );

Line 395: x_po_line_ids OUT nocopy po_tbl_number,

391: FUNCTION get_next_record (
392: x_po_header_id OUT nocopy NUMBER,
393: x_po_number OUT nocopy VARCHAR2,
394: x_operating_unit OUT nocopy NUMBER,
395: x_po_line_ids OUT nocopy po_tbl_number,
396: x_line_location_ids OUT nocopy po_tbl_number,
397: x_distribution_ids OUT nocopy po_tbl_number,
398: x_qtys OUT nocopy po_tbl_number,
399: x_promise_dates OUT nocopy po_tbl_date,

Line 396: x_line_location_ids OUT nocopy po_tbl_number,

392: x_po_header_id OUT nocopy NUMBER,
393: x_po_number OUT nocopy VARCHAR2,
394: x_operating_unit OUT nocopy NUMBER,
395: x_po_line_ids OUT nocopy po_tbl_number,
396: x_line_location_ids OUT nocopy po_tbl_number,
397: x_distribution_ids OUT nocopy po_tbl_number,
398: x_qtys OUT nocopy po_tbl_number,
399: x_promise_dates OUT nocopy po_tbl_date,
400: x_uoms OUT nocopy po_tbl_varchar30

Line 397: x_distribution_ids OUT nocopy po_tbl_number,

393: x_po_number OUT nocopy VARCHAR2,
394: x_operating_unit OUT nocopy NUMBER,
395: x_po_line_ids OUT nocopy po_tbl_number,
396: x_line_location_ids OUT nocopy po_tbl_number,
397: x_distribution_ids OUT nocopy po_tbl_number,
398: x_qtys OUT nocopy po_tbl_number,
399: x_promise_dates OUT nocopy po_tbl_date,
400: x_uoms OUT nocopy po_tbl_varchar30
401: ) RETURN BOOLEAN IS

Line 398: x_qtys OUT nocopy po_tbl_number,

394: x_operating_unit OUT nocopy NUMBER,
395: x_po_line_ids OUT nocopy po_tbl_number,
396: x_line_location_ids OUT nocopy po_tbl_number,
397: x_distribution_ids OUT nocopy po_tbl_number,
398: x_qtys OUT nocopy po_tbl_number,
399: x_promise_dates OUT nocopy po_tbl_date,
400: x_uoms OUT nocopy po_tbl_varchar30
401: ) RETURN BOOLEAN IS
402: /*

Line 447: x_po_line_ids := po_tbl_number();

443:
444: END LOOP;
445: ***********/
446:
447: x_po_line_ids := po_tbl_number();
448: x_line_location_ids := po_tbl_number();
449: x_distribution_ids := po_tbl_number();
450: x_qtys := po_tbl_number();
451: x_promise_dates := po_tbl_date();

Line 448: x_line_location_ids := po_tbl_number();

444: END LOOP;
445: ***********/
446:
447: x_po_line_ids := po_tbl_number();
448: x_line_location_ids := po_tbl_number();
449: x_distribution_ids := po_tbl_number();
450: x_qtys := po_tbl_number();
451: x_promise_dates := po_tbl_date();
452: x_uoms := po_tbl_varchar30();

Line 449: x_distribution_ids := po_tbl_number();

445: ***********/
446:
447: x_po_line_ids := po_tbl_number();
448: x_line_location_ids := po_tbl_number();
449: x_distribution_ids := po_tbl_number();
450: x_qtys := po_tbl_number();
451: x_promise_dates := po_tbl_date();
452: x_uoms := po_tbl_varchar30();
453:

Line 450: x_qtys := po_tbl_number();

446:
447: x_po_line_ids := po_tbl_number();
448: x_line_location_ids := po_tbl_number();
449: x_distribution_ids := po_tbl_number();
450: x_qtys := po_tbl_number();
451: x_promise_dates := po_tbl_date();
452: x_uoms := po_tbl_varchar30();
453:
454: IF( g_distribution_ids(l_starting_rec) IS NOT NULL ) THEN

Line 823: l_po_line_ids po_tbl_number;

819:
820: l_po_return_status VARCHAR2(1);
821: l_po_api_errors PO_API_ERRORS_REC_TYPE;
822:
823: l_po_line_ids po_tbl_number;
824: l_line_location_ids po_tbl_number;
825: l_distribution_ids po_tbl_number;
826: l_qtys po_tbl_number;
827: l_promise_dates po_tbl_date;

Line 824: l_line_location_ids po_tbl_number;

820: l_po_return_status VARCHAR2(1);
821: l_po_api_errors PO_API_ERRORS_REC_TYPE;
822:
823: l_po_line_ids po_tbl_number;
824: l_line_location_ids po_tbl_number;
825: l_distribution_ids po_tbl_number;
826: l_qtys po_tbl_number;
827: l_promise_dates po_tbl_date;
828: l_uoms po_tbl_varchar30;

Line 825: l_distribution_ids po_tbl_number;

821: l_po_api_errors PO_API_ERRORS_REC_TYPE;
822:
823: l_po_line_ids po_tbl_number;
824: l_line_location_ids po_tbl_number;
825: l_distribution_ids po_tbl_number;
826: l_qtys po_tbl_number;
827: l_promise_dates po_tbl_date;
828: l_uoms po_tbl_varchar30;
829:

Line 826: l_qtys po_tbl_number;

822:
823: l_po_line_ids po_tbl_number;
824: l_line_location_ids po_tbl_number;
825: l_distribution_ids po_tbl_number;
826: l_qtys po_tbl_number;
827: l_promise_dates po_tbl_date;
828: l_uoms po_tbl_varchar30;
829:
830: l_po_line_changes po_lines_rec_type;