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.WMS_RULE_PVT dependencies on WMS_SEARCH_ORDER_GLOBALS_PVT

Line 906: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;

902: g_first_consist_group NUMBER := 0;
903: g_last_consist_group NUMBER;
904: g_first_lpn_group NUMBER;
905: g_last_lpn_group NUMBER;
906: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;
907:
908: PROCEDURE FetchCursorRows(
909: x_return_status OUT NOCOPY VARCHAR2
910: , x_msg_count OUT NOCOPY NUMBER

Line 10782: wms_search_order_globals_pvt.insert_trace_lines(

10778:
10779: l_cur_rec := l_cur_rec + 1;
10780: END LOOP;
10781:
10782: wms_search_order_globals_pvt.insert_trace_lines(
10783: p_api_version => 1.0
10784: , p_init_msg_list => fnd_api.g_false
10785: , p_validation_level => fnd_api.g_valid_level_full
10786: , x_return_status => l_return_status

Line 10830: wms_search_order_globals_pvt.insert_trace_lines(

10826: wms_re_common_pvt.deleteinputline;
10827: END IF;
10828:
10829: IF l_debug_on THEN
10830: wms_search_order_globals_pvt.insert_trace_lines(
10831: p_api_version => 1.0
10832: , p_init_msg_list => fnd_api.g_false
10833: , p_validation_level => fnd_api.g_valid_level_full
10834: , x_return_status => l_return_status

Line 12081: wms_search_order_globals_pvt.insert_trace_lines(

12077: -- and delete input record in PL/SQL table, too
12078: wms_re_common_pvt.DeleteInputLine;
12079: END IF;
12080: IF l_debug_on THEN
12081: wms_search_order_globals_pvt.insert_trace_lines(
12082: p_api_version => 1.0
12083: ,p_init_msg_list => fnd_api.g_false
12084: ,p_validation_level => fnd_api.g_valid_level_full
12085: ,x_return_status => l_return_status

Line 13604: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;

13600: BEGIN
13601: IF (p_cursor%ISOPEN) THEN
13602:
13603: FETCH p_cursor bulk collect INTO
13604: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
13605: IF p_cursor%FOUND THEN
13606: x_return_status :=1;
13607: ELSE
13608: x_return_status :=0;

Line 15085: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;

15081: l_unit_number VARCHAR2(30);
15082: l_allowed VARCHAR2(1) := 'Y';
15083: l_serial_allowed VARCHAR2(1) := 'Y';
15084:
15085: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;
15086:
15087: l_debug NUMBER; -- 1 for debug is on , 0 for debug is off
15088: l_progress VARCHAR2(10); -- local variable to track program progress,
15089:

Line 16429: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;

16425: );
16426: close_pick_rule(l_rule_id, v_pick_cursor);
16427:
16428: /*FETCH v_pick_cursor bulk collect INTO
16429: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
16430: */
16431: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16432: LOOP
16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;

Line 16431: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT

16427:
16428: /*FETCH v_pick_cursor bulk collect INTO
16429: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
16430: */
16431: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16432: LOOP
16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
16435: END LOOP;

Line 16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;

16429: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
16430: */
16431: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16432: LOOP
16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
16435: END LOOP;
16436: gmi_reservation_util.println('fetch the rows, return rows number'
16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);

Line 16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;

16430: */
16431: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16432: LOOP
16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
16435: END LOOP;
16436: gmi_reservation_util.println('fetch the rows, return rows number'
16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
16438: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT

Line 16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);

16433: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
16435: END LOOP;
16436: gmi_reservation_util.println('fetch the rows, return rows number'
16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
16438: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16439: LOOP
16440: gmi_reservation_util.println('fetch the rows, 2nd qty '
16441: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);

Line 16438: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT

16434: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
16435: END LOOP;
16436: gmi_reservation_util.println('fetch the rows, return rows number'
16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
16438: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16439: LOOP
16440: gmi_reservation_util.println('fetch the rows, 2nd qty '
16441: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
16442: end loop;

Line 16441: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);

16437: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
16438: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
16439: LOOP
16440: gmi_reservation_util.println('fetch the rows, 2nd qty '
16441: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
16442: end loop;
16443: */
16444: END IF;
16445: EXCEPTION