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 950: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;

946: g_first_consist_group NUMBER := 0;
947: g_last_consist_group NUMBER;
948: g_first_lpn_group NUMBER;
949: g_last_lpn_group NUMBER;
950: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;
951:
952: PROCEDURE FetchCursorRows(
953: x_return_status OUT NOCOPY VARCHAR2
954: , x_msg_count OUT NOCOPY NUMBER

Line 13317: wms_search_order_globals_pvt.insert_trace_lines(

13313:
13314: l_cur_rec := l_cur_rec + 1;
13315: END LOOP;
13316:
13317: wms_search_order_globals_pvt.insert_trace_lines(
13318: p_api_version => 1.0
13319: , p_init_msg_list => fnd_api.g_false
13320: , p_validation_level => fnd_api.g_valid_level_full
13321: , x_return_status => l_return_status

Line 13413: wms_search_order_globals_pvt.insert_trace_lines(

13409: -- end of 8744417
13410: END IF; --}
13411:
13412: IF l_debug_on THEN
13413: wms_search_order_globals_pvt.insert_trace_lines(
13414: p_api_version => 1.0
13415: , p_init_msg_list => fnd_api.g_false
13416: , p_validation_level => fnd_api.g_valid_level_full
13417: , x_return_status => l_return_status

Line 14682: wms_search_order_globals_pvt.insert_trace_lines(

14678: -- and delete input record in PL/SQL table, too
14679: wms_re_common_pvt.DeleteInputLine;
14680: END IF;
14681: IF l_debug_on THEN
14682: wms_search_order_globals_pvt.insert_trace_lines(
14683: p_api_version => 1.0
14684: ,p_init_msg_list => fnd_api.g_false
14685: ,p_validation_level => fnd_api.g_valid_level_full
14686: ,x_return_status => l_return_status

Line 16245: l_available_inv_tbl WMS_SEARCH_ORDER_GLOBALS_PVT.available_inventory_tbl;

16241: x_return_status OUT NOCOPY NUMBER) IS
16242:
16243: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
16244:
16245: l_available_inv_tbl WMS_SEARCH_ORDER_GLOBALS_PVT.available_inventory_tbl;
16246: l_count number ;
16247:
16248:
16249: BEGIN

Line 16262: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN

16258: ELSE
16259: x_return_status :=0;
16260: END IF;
16261:
16262: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
16263:
16264: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
16265:
16266: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP

Line 16264: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;

16260: END IF;
16261:
16262: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
16263:
16264: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
16265:
16266: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
16267: l_count := l_count + 1 ;
16268: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;

Line 16268: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;

16264: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
16265:
16266: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
16267: l_count := l_count + 1 ;
16268: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
16269: END LOOP ;
16270:
16271: ELSE
16272: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;

Line 16272: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;

16268: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
16269: END LOOP ;
16270:
16271: ELSE
16272: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;
16273: END IF ;
16274: ELSE
16275: x_return_status:=0;
16276: END IF;

Line 17743: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;

17739: l_unit_number VARCHAR2(30);
17740: l_allowed VARCHAR2(1) := 'Y';
17741: l_serial_allowed VARCHAR2(1) := 'Y';
17742:
17743: g_trace_recs wms_search_order_globals_pvt.pre_suggestions_record_tbl;
17744:
17745: l_debug NUMBER; -- 1 for debug is on , 0 for debug is off
17746: l_progress VARCHAR2(10); -- local variable to track program progress,
17747:

Line 19071: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;

19067: );
19068: close_pick_rule(l_rule_id, v_pick_cursor);
19069:
19070: /*FETCH v_pick_cursor bulk collect INTO
19071: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
19072: */
19073: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19074: LOOP
19075: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;

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

19069:
19070: /*FETCH v_pick_cursor bulk collect INTO
19071: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
19072: */
19073: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19074: LOOP
19075: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
19076: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
19077: END LOOP;

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

19071: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl;
19072: */
19073: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19074: LOOP
19075: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
19076: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
19077: END LOOP;
19078: gmi_reservation_util.println('fetch the rows, return rows number'
19079: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);

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

19072: */
19073: /*FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19074: LOOP
19075: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
19076: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
19077: END LOOP;
19078: gmi_reservation_util.println('fetch the rows, return rows number'
19079: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
19080: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT

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

19075: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).organization_id := p_organization_id;
19076: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
19077: END LOOP;
19078: gmi_reservation_util.println('fetch the rows, return rows number'
19079: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
19080: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19081: LOOP
19082: gmi_reservation_util.println('fetch the rows, 2nd qty '
19083: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);

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

19076: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).inventory_item_id := p_inventory_item_id;
19077: END LOOP;
19078: gmi_reservation_util.println('fetch the rows, return rows number'
19079: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
19080: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19081: LOOP
19082: gmi_reservation_util.println('fetch the rows, 2nd qty '
19083: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
19084: end loop;

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

19079: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
19080: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
19081: LOOP
19082: gmi_reservation_util.println('fetch the rows, 2nd qty '
19083: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
19084: end loop;
19085: */
19086: END IF;
19087: EXCEPTION