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_PUB

Line 1: PACKAGE BODY WMS_XDOCK_PEGGING_PUB AS

1: PACKAGE BODY WMS_XDOCK_PEGGING_PUB AS
2: /* $Header: WMSXDCKB.pls 120.23.12010000.1 2008/07/28 18:38:31 appldev ship $ */
3:
4:
5: -- Global constants holding the package name and package version

Line 6: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_XDOCK_PEGGING_PUB';

2: /* $Header: WMSXDCKB.pls 120.23.12010000.1 2008/07/28 18:38:31 appldev ship $ */
3:
4:
5: -- Global constants holding the package name and package version
6: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_XDOCK_PEGGING_PUB';
7: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSXDCKB.pls 120.23.12010000.1 2008/07/28 18:38:31 appldev ship $';
8:
9: -- This is the global cache table used to store the crossdock criteria records
10: -- encountered during crossdock pegging. This is defined solely in the package body

Line 88: p_module => 'WMS_XDock_Pegging_Pub',

84: IS
85: BEGIN
86: inv_mobile_helper_functions.tracelog
87: (p_err_msg => p_debug_msg,
88: p_module => 'WMS_XDock_Pegging_Pub',
89: p_level => 4);
90: END;
91:
92:

Line 589: l_action_prms.caller := 'WMS_XDOCK_PEGGING_PUB';

585:
586: -- Split the WDD line with the partial quantity allocated. The original WDD
587: -- line will retain the unallocated quantity.
588: l_detail_id_tab(1) := l_demand_line_detail_id;
589: l_action_prms.caller := 'WMS_XDOCK_PEGGING_PUB';
590: l_action_prms.action_code := 'SPLIT-LINE';
591: l_action_prms.split_quantity := l_atd_wdd_qty;
592: l_action_prms.split_quantity2 := l_atd_wdd_qty2;
593:

Line 1769: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1765: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
1766: AND poll.ship_to_organization_id = l_organization_id
1767: AND poll.quantity > NVL(poll.quantity_received, 0)
1768: AND NVL(poll.receiving_routing_id,
1769: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1770: l_inventory_item_id,
1771: poh.vendor_id)) <> 3
1772: AND NOT EXISTS (SELECT 'Invalid Destination'
1773: FROM po_distributions_all pod2

Line 1822: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1818: AND pod.po_line_id = pol.po_line_id
1819: AND pod.line_location_id = poll.line_location_id
1820: AND rsl.unit_of_measure = muom.unit_of_measure
1821: AND NVL(poll.receiving_routing_id,
1822: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1823: l_inventory_item_id,
1824: rsh.vendor_id)) <> 3
1825: AND NOT EXISTS (SELECT 'Invalid Destination'
1826: FROM po_distributions_all pod2

Line 1877: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1873: AND rsl.quantity_shipped > NVL(rsl.quantity_received, 0)
1874: AND rsh.shipment_header_id = rsl.shipment_header_id
1875: AND rsl.unit_of_measure = muom.unit_of_measure
1876: AND NVL(rsl.routing_header_id,
1877: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1878: l_inventory_item_id,
1879: rsh.vendor_id)) <> 3
1880: AND NVL(NVL(prl.destination_type_code, prl.destination_context), 'INVENTORY') NOT IN
1881: ('EXPENSE', 'SHOP FLOOR')

Line 1921: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1917: AND mip.from_organization_id = prl.source_organization_id
1918: AND mip.to_organization_id = prl.destination_organization_id
1919: AND prl.unit_meas_lookup_code = muom.unit_of_measure
1920: AND NVL(mip.routing_header_id,
1921: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1922: l_inventory_item_id,
1923: prl.vendor_id)) <> 3
1924: AND NVL(NVL(prl.destination_type_code, prl.destination_context), 'INVENTORY') NOT IN
1925: ('EXPENSE', 'SHOP FLOOR')

Line 1959: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1955: AND rsl.item_id = l_inventory_item_id
1956: AND rsl.quantity_shipped > NVL(rsl.quantity_received, 0)
1957: AND rsl.unit_of_measure = muom.unit_of_measure
1958: AND NVL(rsl.routing_header_id,
1959: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1960: l_inventory_item_id,
1961: rsh.vendor_id)) <> 3
1962: AND NVL(NVL(rsl.destination_type_code, rsl.destination_context), 'INVENTORY') NOT IN
1963: ('EXPENSE','SHOP FLOOR');

Line 2968: IF (WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip

2964: -- If we do not allow partial WIP crossdocking, that is a mix of demand being tied to
2965: -- both WIP and other non-Inventory supply sources, validate that the current demand
2966: -- it not already tied to WIP supply.
2967: IF (WMS_XDOCK_CUSTOM_APIS_PUB.g_allow_partial_wip_xdock = 'N') THEN
2968: IF (WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip
2969: (p_organization_id => l_organization_id,
2970: p_inventory_item_id => l_inventory_item_id,
2971: p_demand_type_id => l_demand_type_id,
2972: p_demand_header_id => l_demand_so_header_id,

Line 5904: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';

5900: print_debug('5.1 - Call the Create_Update_Delivery_Detail API for ' ||
5901: l_detail_info_tab.COUNT || ' crossdocked WDD records');
5902: END IF;
5903:
5904: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';
5905: l_in_rec.action_code := 'UPDATE';
5906:
5907: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
5908: (p_api_version_number => 1.0,

Line 8538: IF ((l_supply_type_id <> 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip

8534: -- reservations created for the crossdock. Only do this check if the demand line has not
8535: -- already been removed above for not lying within the crossdock window.
8536: IF (l_header_id_tb.EXISTS(j) AND l_demand_type_id <> 5) THEN
8537: IF (WMS_XDOCK_CUSTOM_APIS_PUB.g_allow_partial_wip_xdock = 'N') THEN
8538: IF ((l_supply_type_id <> 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip
8539: (p_organization_id => l_organization_id,
8540: p_inventory_item_id => l_inventory_item_id,
8541: p_demand_type_id => l_demand_type_id,
8542: p_demand_header_id => l_header_id_tb(j),

Line 8544: (l_supply_type_id = 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_non_wip

8540: p_inventory_item_id => l_inventory_item_id,
8541: p_demand_type_id => l_demand_type_id,
8542: p_demand_header_id => l_header_id_tb(j),
8543: p_demand_line_id => l_line_id_tb(j)) = 'Y') OR
8544: (l_supply_type_id = 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_non_wip
8545: (p_organization_id => l_organization_id,
8546: p_inventory_item_id => l_inventory_item_id,
8547: p_demand_type_id => l_demand_type_id,
8548: p_demand_header_id => l_header_id_tb(j),

Line 9575: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';

9571: print_debug('5.1 - Call the Create_Update_Delivery_Detail API for ' ||
9572: l_detail_info_tab.COUNT || ' crossdocked WDD records');
9573: END IF;
9574:
9575: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';
9576: l_in_rec.action_code := 'UPDATE';
9577:
9578: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
9579: (p_api_version_number => 1.0,

Line 10966: END WMS_XDOCK_PEGGING_PUB;

10962: -- {{******************** End Get_Expected_Delivery_Time ********************}}
10963: -- {{ }}
10964:
10965:
10966: END WMS_XDOCK_PEGGING_PUB;
10967: