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.29.12020000.4 2013/03/29 03:59:42 raminoch 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.29.12020000.4 2013/03/29 03:59:42 raminoch 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.29.12020000.4 2013/03/29 03:59:42 raminoch 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 98: p_module => 'WMS_XDock_Pegging_Pub',

94: IS
95: BEGIN
96: inv_mobile_helper_functions.tracelog
97: (p_err_msg => p_debug_msg,
98: p_module => 'WMS_XDock_Pegging_Pub',
99: p_level => 4);
100: END;
101:
102:

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

600:
601: -- Split the WDD line with the partial quantity allocated. The original WDD
602: -- line will retain the unallocated quantity.
603: l_detail_id_tab(1) := l_demand_line_detail_id;
604: l_action_prms.caller := 'WMS_XDOCK_PEGGING_PUB';
605: l_action_prms.action_code := 'SPLIT-LINE';
606: l_action_prms.split_quantity := l_atd_wdd_qty;
607: l_action_prms.split_quantity2 := l_atd_wdd_qty2;
608:

Line 1794: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1790: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
1791: AND poll.ship_to_organization_id = l_organization_id
1792: AND poll.quantity > NVL(poll.quantity_received, 0)
1793: AND NVL(poll.receiving_routing_id,
1794: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1795: l_inventory_item_id,
1796: poh.vendor_id)) <> 3
1797: AND NOT EXISTS (SELECT 'Invalid Destination'
1798: FROM po_distributions_all pod2

Line 1847: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1843: AND pod.po_line_id = pol.po_line_id
1844: AND pod.line_location_id = poll.line_location_id
1845: AND rsl.unit_of_measure = muom.unit_of_measure
1846: AND NVL(poll.receiving_routing_id,
1847: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1848: l_inventory_item_id,
1849: rsh.vendor_id)) <> 3
1850: AND NOT EXISTS (SELECT 'Invalid Destination'
1851: FROM po_distributions_all pod2

Line 1902: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1898: AND rsl.quantity_shipped > NVL(rsl.quantity_received, 0)
1899: AND rsh.shipment_header_id = rsl.shipment_header_id
1900: AND rsl.unit_of_measure = muom.unit_of_measure
1901: AND NVL(rsl.routing_header_id,
1902: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1903: l_inventory_item_id,
1904: rsh.vendor_id)) <> 3
1905: AND NVL(NVL(prl.destination_type_code, prl.destination_context), 'INVENTORY') NOT IN
1906: ('EXPENSE', 'SHOP FLOOR')

Line 1946: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1942: AND mip.from_organization_id = prl.source_organization_id
1943: AND mip.to_organization_id = prl.destination_organization_id
1944: AND prl.unit_meas_lookup_code = muom.unit_of_measure
1945: AND NVL(mip.routing_header_id,
1946: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1947: l_inventory_item_id,
1948: prl.vendor_id)) <> 3
1949: AND NVL(NVL(prl.destination_type_code, prl.destination_context), 'INVENTORY') NOT IN
1950: ('EXPENSE', 'SHOP FLOOR')

Line 1984: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,

1980: AND rsl.item_id = l_inventory_item_id
1981: AND rsl.quantity_shipped > NVL(rsl.quantity_received, 0)
1982: AND rsl.unit_of_measure = muom.unit_of_measure
1983: AND NVL(rsl.routing_header_id,
1984: WMS_Xdock_Pegging_Pub.get_default_routing_id(l_organization_id,
1985: l_inventory_item_id,
1986: rsh.vendor_id)) <> 3
1987: AND NVL(NVL(rsl.destination_type_code, rsl.destination_context), 'INVENTORY') NOT IN
1988: ('EXPENSE','SHOP FLOOR');

Line 3033: IF (WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip

3029: -- If we do not allow partial WIP crossdocking, that is a mix of demand being tied to
3030: -- both WIP and other non-Inventory supply sources, validate that the current demand
3031: -- it not already tied to WIP supply.
3032: IF (WMS_XDOCK_CUSTOM_APIS_PUB.g_allow_partial_wip_xdock = 'N') THEN
3033: IF (WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip
3034: (p_organization_id => l_organization_id,
3035: p_inventory_item_id => l_inventory_item_id,
3036: p_demand_type_id => l_demand_type_id,
3037: p_demand_header_id => l_demand_so_header_id,

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

6070: print_debug('5.1 - Call the Create_Update_Delivery_Detail API for ' ||
6071: l_detail_info_tab.COUNT || ' crossdocked WDD records');
6072: END IF;
6073:
6074: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';
6075: l_in_rec.action_code := 'UPDATE';
6076:
6077: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
6078: (p_api_version_number => 1.0,

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

8721: -- reservations created for the crossdock. Only do this check if the demand line has not
8722: -- already been removed above for not lying within the crossdock window.
8723: IF (l_header_id_tb.EXISTS(j) AND l_demand_type_id <> 5) THEN
8724: IF (WMS_XDOCK_CUSTOM_APIS_PUB.g_allow_partial_wip_xdock = 'N') THEN
8725: IF ((l_supply_type_id <> 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_wip
8726: (p_organization_id => l_organization_id,
8727: p_inventory_item_id => l_inventory_item_id,
8728: p_demand_type_id => l_demand_type_id,
8729: p_demand_header_id => l_header_id_tb(j),

Line 8731: (l_supply_type_id = 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_non_wip

8727: p_inventory_item_id => l_inventory_item_id,
8728: p_demand_type_id => l_demand_type_id,
8729: p_demand_header_id => l_header_id_tb(j),
8730: p_demand_line_id => l_line_id_tb(j)) = 'Y') OR
8731: (l_supply_type_id = 5 AND WMS_XDOCK_PEGGING_PUB.is_demand_tied_to_non_wip
8732: (p_organization_id => l_organization_id,
8733: p_inventory_item_id => l_inventory_item_id,
8734: p_demand_type_id => l_demand_type_id,
8735: p_demand_header_id => l_header_id_tb(j),

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

9766: print_debug('5.1 - Call the Create_Update_Delivery_Detail API for ' ||
9767: l_detail_info_tab.COUNT || ' crossdocked WDD records');
9768: END IF;
9769:
9770: l_in_rec.caller := 'WMS_XDOCK_PEGGING_PUB';
9771: l_in_rec.action_code := 'UPDATE';
9772:
9773: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
9774: (p_api_version_number => 1.0,

Line 11161: END WMS_XDOCK_PEGGING_PUB;

11157: -- {{******************** End Get_Expected_Delivery_Time ********************}}
11158: -- {{ }}
11159:
11160:
11161: END WMS_XDOCK_PEGGING_PUB;
11162: