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_XDOCK_PEGGING_PUB dependencies on WMS_XDOCK_PEGGING_GTMP

Line 2049: -- the wms_xdock_pegging_gtmp table.

2045: TYPE bool_tab IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
2046:
2047: -- Table indexed by inventory_item_id to keep track of which
2048: -- supply source types have already been retrieved and inserted into
2049: -- the wms_xdock_pegging_gtmp table.
2050: TYPE src_types_retrieved_tb IS TABLE OF bool_tab INDEX BY BINARY_INTEGER;
2051: l_src_types_retrieved_tb src_types_retrieved_tb;
2052:
2053: -- Index used to loop through the release table

Line 2470: FROM wms_xdock_pegging_gtmp

2466: project_id,
2467: task_id,
2468: lpn_id,
2469: wip_supply_type
2470: FROM wms_xdock_pegging_gtmp
2471: WHERE inventory_item_id = l_inventory_item_id
2472: AND xdock_source_code IN (p_po_sup, p_asn_sup, p_intreq_sup, p_intship_sup, p_rcv_sup)
2473: AND ((expected_time IS NOT NULL AND (p_past_due_time IS NULL OR
2474: expected_time > SYSDATE - p_past_due_interval)) OR

Line 2516: -- order the MOL's are encountered and inserted into wms_xdock_pegging_gtmp to

2512: -- Putting this order by first before the crossdocking goal since only
2513: -- In Receiving supply lines will have a non-null value for primary_quantity.
2514: -- For other supply types, this order by will do nothing. Doing this since the
2515: -- expected time for In Receiving lines just use SYSDATE. We do not want the
2516: -- order the MOL's are encountered and inserted into wms_xdock_pegging_gtmp to
2517: -- affect the order we consume them for crossdocking.
2518: ABS(NVL(primary_quantity, 0) - p_demand_prim_qty) ASC,
2519: DECODE (p_crossdock_goal,
2520: G_MINIMIZE_WAIT, SYSDATE - NVL(expected_time, dock_start_time),

Line 2605: -- wms_xdock_pegging_gtmp. We want to do a bulk update for this in case multiple

2601: -- This is used for allocation mode of N (Prioritize Inventory).
2602: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
2603:
2604: -- Variables used to bulk update the reservable_quantity column in the global temp table,
2605: -- wms_xdock_pegging_gtmp. We want to do a bulk update for this in case multiple
2606: -- supply lines are consumed when crossdocking a WDD record.
2607: l_supply_atr_index NUMBER;
2608: TYPE rowid_tab IS TABLE OF urowid INDEX BY BINARY_INTEGER;
2609: l_supply_rowid_tb rowid_tab;

Line 4598: INSERT INTO wms_xdock_pegging_gtmp

4594: print_debug('3.4 - Insert the available supply lines into the global temp table');
4595: END IF;
4596: BEGIN
4597: FORALL k IN 1 .. l_header_id_tb.COUNT
4598: INSERT INTO wms_xdock_pegging_gtmp
4599: (inventory_item_id,
4600: xdock_source_code,
4601: source_type_id,
4602: source_header_id,

Line 5004: -- global temp table, wms_xdock_pegging_gtmp.

5000: -- is valid for crossdocking.
5001: -- 4.3 - Crossdock the demand and supply line records.
5002: -- 4.4 - Create a crossdocked reservation tying the demand to the supply line.
5003: -- 4.5 - Bulk update the reservable_quantity for all crossdocked supply lines in the
5004: -- global temp table, wms_xdock_pegging_gtmp.
5005:
5006: -- Check if there are valid supply lines found for crossdocking.
5007: -- If none exist, move on to the next WDD record to crossdock.
5008: IF (l_shopping_basket_tb.COUNT = 0) THEN

Line 5024: -- of supply lines in wms_xdock_pegging_gtmp after the supply lines shopping basket loop,

5020: l_supply_rowid_tb.DELETE;
5021: l_supply_atr_qty_tb.DELETE;
5022:
5023: -- Define a savepoint so if an exception occurs when performing the bulk update
5024: -- of supply lines in wms_xdock_pegging_gtmp after the supply lines shopping basket loop,
5025: -- we want to rollback all crossdock changes done within the loop.
5026: SAVEPOINT Before_Supply_Loop_sp;
5027:
5028: -- Loop through the valid supply lines to crossdock the current WDD demand

Line 5476: UPDATE wms_xdock_pegging_gtmp

5472:
5473: -- Commented the below out since we will do a bulk update instead outside
5474: -- the supply lines loop
5475: /*BEGIN
5476: UPDATE wms_xdock_pegging_gtmp
5477: SET reservable_quantity = l_supply_atr_qty - l_atd_qty
5478: WHERE ROWID = l_shopping_basket_tb(l_supply_index).ROWID;
5479: EXCEPTION
5480: WHEN OTHERS THEN

Line 5841: -- global temp table, wms_xdock_pegging_gtmp.

5837: END LOOP; -- End looping through supply lines in shopping basket table
5838: l_progress := '560';
5839:
5840: -- 4.5 - Bulk update the reservable_quantity for all crossdocked supply lines in
5841: -- global temp table, wms_xdock_pegging_gtmp.
5842: -- {{
5843: -- Test that the supply lines used in wms_xdock_pegging_gtmp have the reservable
5844: -- quantities updated properly. In this way, later demand lines to be crossdocked
5845: -- can just refer to this quantity instead of calling the availability APIs again. }}

Line 5843: -- Test that the supply lines used in wms_xdock_pegging_gtmp have the reservable

5839:
5840: -- 4.5 - Bulk update the reservable_quantity for all crossdocked supply lines in
5841: -- global temp table, wms_xdock_pegging_gtmp.
5842: -- {{
5843: -- Test that the supply lines used in wms_xdock_pegging_gtmp have the reservable
5844: -- quantities updated properly. In this way, later demand lines to be crossdocked
5845: -- can just refer to this quantity instead of calling the availability APIs again. }}
5846: IF (l_supply_rowid_tb.COUNT > 0) THEN
5847: IF (l_debug = 1) THEN

Line 5853: UPDATE wms_xdock_pegging_gtmp

5849: END IF;
5850:
5851: BEGIN
5852: FORALL i IN 1 .. l_supply_rowid_tb.COUNT
5853: UPDATE wms_xdock_pegging_gtmp
5854: SET reservable_quantity = l_supply_atr_qty_tb(i)
5855: WHERE ROWID = l_supply_rowid_tb(i);
5856: EXCEPTION
5857: WHEN OTHERS THEN

Line 5891: -- 5.5 - Bug 5194761: clear the temp table wms_xdock_pegging_gtmp

5887: -- p_trolin_delivery_ids and p_del_detail_id.
5888: -- 5.4 - If allocation method is 'N', Prioritize Inventory, backorder all of the
5889: -- WDD lines that could not be allocated. Remove those entries from the
5890: -- delivery IN OUT tables: p_trolin_delivery_ids and p_del_detail_id.
5891: -- 5.5 - Bug 5194761: clear the temp table wms_xdock_pegging_gtmp
5892:
5893: -- 5.1 - For all crossdocked WDD lines, call the shipping API to update the
5894: -- released_status and move_order_line_id columns.
5895: -- {{

Line 6122: -- 5.5 - Bug 5194761: delete records from wms_xdock_pegging_gtmp

6118: END IF;
6119: END IF; -- End of: IF (l_allocation_method = G_PRIORITIZE_INVENTORY) THEN
6120: l_progress := '610';
6121:
6122: -- 5.5 - Bug 5194761: delete records from wms_xdock_pegging_gtmp
6123: DELETE wms_xdock_pegging_gtmp;
6124: IF (l_debug = 1) AND SQL%FOUND THEN
6125: print_debug('5.5 - Cleared the temp table wms_xdock_pegging_gtmp');
6126: END IF;

Line 6123: DELETE wms_xdock_pegging_gtmp;

6119: END IF; -- End of: IF (l_allocation_method = G_PRIORITIZE_INVENTORY) THEN
6120: l_progress := '610';
6121:
6122: -- 5.5 - Bug 5194761: delete records from wms_xdock_pegging_gtmp
6123: DELETE wms_xdock_pegging_gtmp;
6124: IF (l_debug = 1) AND SQL%FOUND THEN
6125: print_debug('5.5 - Cleared the temp table wms_xdock_pegging_gtmp');
6126: END IF;
6127:

Line 6125: print_debug('5.5 - Cleared the temp table wms_xdock_pegging_gtmp');

6121:
6122: -- 5.5 - Bug 5194761: delete records from wms_xdock_pegging_gtmp
6123: DELETE wms_xdock_pegging_gtmp;
6124: IF (l_debug = 1) AND SQL%FOUND THEN
6125: print_debug('5.5 - Cleared the temp table wms_xdock_pegging_gtmp');
6126: END IF;
6127:
6128: -- Standard call to commit
6129: IF fnd_api.To_Boolean(p_commit) THEN

Line 6750: -- from wms_xdock_pegging_gtmp.

6746:
6747: -- Cursor to retrieve valid demand lines for crossdocking.
6748: -- For opportunistic crossdock, only crossdockable demand lines are inserted into
6749: -- the global temp table. Therefore we want to select every single record (full table scan)
6750: -- from wms_xdock_pegging_gtmp.
6751: CURSOR get_demand_lines(p_crossdock_goal NUMBER,
6752: p_so_sched_priority NUMBER,
6753: p_so_back_priority NUMBER,
6754: p_io_sched_priority NUMBER,

Line 6778: FROM wms_xdock_pegging_gtmp

6774: project_id,
6775: task_id,
6776: lpn_id,
6777: wip_supply_type
6778: FROM wms_xdock_pegging_gtmp
6779: WHERE inventory_item_id = l_inventory_item_id
6780: ORDER BY DECODE (xdock_source_code,
6781: G_OPP_DEM_SO_SCHED, p_so_sched_priority,
6782: G_OPP_DEM_SO_BKORD, p_so_back_priority,

Line 8619: INSERT INTO wms_xdock_pegging_gtmp

8615: ' crossdockable demand lines into the global temp table');
8616: END IF;
8617: BEGIN
8618: FORALL k IN INDICES OF l_header_id_tb
8619: INSERT INTO wms_xdock_pegging_gtmp
8620: (inventory_item_id,
8621: xdock_source_code,
8622: source_type_id,
8623: source_header_id,

Line 9565: -- 5.2 - Bug 5194761: clear the temp table wms_xdock_pegging_gtmp

9561:
9562: -- Section 5: Post crossdocking logic
9563: -- 5.1 - For all crossdocked WDD lines, call the shipping API to update the
9564: -- released_status and move_order_line_id columns.
9565: -- 5.2 - Bug 5194761: clear the temp table wms_xdock_pegging_gtmp
9566: -- {{
9567: -- Make sure the shipping API to update crossdocked WDD lines is only called if necessary
9568: -- and properly updates the WDD records. }}
9569: IF (l_detail_info_tab.COUNT > 0) THEN

Line 9604: -- Bug 5194761: delete records from wms_xdock_pegging_gtmp

9600: END IF;
9601: END IF;
9602: l_progress := '550';
9603:
9604: -- Bug 5194761: delete records from wms_xdock_pegging_gtmp
9605: DELETE wms_xdock_pegging_gtmp;
9606: IF (l_debug = 1) AND SQL%FOUND THEN
9607: print_debug('5.2 - Cleared the temp table wms_xdock_pegging_gtmp');
9608: END IF;

Line 9605: DELETE wms_xdock_pegging_gtmp;

9601: END IF;
9602: l_progress := '550';
9603:
9604: -- Bug 5194761: delete records from wms_xdock_pegging_gtmp
9605: DELETE wms_xdock_pegging_gtmp;
9606: IF (l_debug = 1) AND SQL%FOUND THEN
9607: print_debug('5.2 - Cleared the temp table wms_xdock_pegging_gtmp');
9608: END IF;
9609:

Line 9607: print_debug('5.2 - Cleared the temp table wms_xdock_pegging_gtmp');

9603:
9604: -- Bug 5194761: delete records from wms_xdock_pegging_gtmp
9605: DELETE wms_xdock_pegging_gtmp;
9606: IF (l_debug = 1) AND SQL%FOUND THEN
9607: print_debug('5.2 - Cleared the temp table wms_xdock_pegging_gtmp');
9608: END IF;
9609:
9610: -- If we have reached this point, the return status should be set to success.
9611: -- This variable is reused each time we call another API but we try to continue with the