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.INV_PICK_RELEASE_PUB dependencies on WSH_INTERFACE

Line 8: all_del_det_bo_tbl WSH_INTERFACE.ChangedAttributeTabType;

4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Pick_Release_PUB';
6:
7: is_debug BOOLEAN := NULL;
8: all_del_det_bo_tbl WSH_INTERFACE.ChangedAttributeTabType;
9: g_org_grouping_rule_id NUMBER;
10: g_organization_id NUMBER;
11: g_print_mode VARCHAR2(1);
12:

Line 90: back_order_det_tbl IN WSH_INTERFACE.ChangedAttributeTabType) IS

86: -- Now avoided multiple splits by storing back order details and do only once.
87:
88: PROCEDURE Store_smc_bo_details
89: (x_return_status OUT NOCOPY VARCHAR2,
90: back_order_det_tbl IN WSH_INTERFACE.ChangedAttributeTabType) IS
91: l_delivery_detail_id NUMBER;
92: l_new_cycle_count_quantity NUMBER:=0;
93: l_old_cycle_count_quantity NUMBER:=0;
94:

Line 157: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;

153: x_msg_count OUT NOCOPY NUMBER
154: ) IS
155: l_api_name VARCHAR2(100):='Backorder_SMC_DETAILS';
156: l_delivery_detail_id NUMBER;
157: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
158: l_del_index INTEGER;
159:
160: BEGIN
161: x_return_status := fnd_api.g_ret_sts_success;

Line 190: WSH_INTERFACE.Update_Shipping_Attributes

186: print_debug('Delivery detail'|| l_shipping_attr(1).delivery_detail_id,
187: 'INV_PICK_RELEASE_PUB');
188: end if;
189:
190: WSH_INTERFACE.Update_Shipping_Attributes
191: (p_source_code => 'INV',
192: p_changed_attributes => l_shipping_attr,
193: x_return_status => x_return_status
194: );

Line 783: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;

779: l_detail_rec_count NUMBER := 0;
780: l_reservation_exists NUMBER := 0; --BUG13604664
781:
782: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
783: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
784: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
785: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
786: l_action_flag VARCHAR2(1);
787: l_quantity NUMBER;

Line 784: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;

780: l_reservation_exists NUMBER := 0; --BUG13604664
781:
782: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
783: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
784: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
785: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
786: l_action_flag VARCHAR2(1);
787: l_quantity NUMBER;
788: -- HW INVCONV Added Qty2 variables

Line 931: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

927:
928: -- Variables used to call the Shipping API to update a WDD line during partial or zero
929: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
930: -- primarily to update the released_status and to null out the move_order_line_id.
931: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
932: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
933: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
934:
935: -- Variables used to call the Shipping API to split a WDD line during partial

Line 932: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

928: -- Variables used to call the Shipping API to update a WDD line during partial or zero
929: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
930: -- primarily to update the released_status and to null out the move_order_line_id.
931: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
932: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
933: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
934:
935: -- Variables used to call the Shipping API to split a WDD line during partial
936: -- allocation for allocation mode of N (Prioritize Inventory).

Line 933: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

929: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
930: -- primarily to update the released_status and to null out the move_order_line_id.
931: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
932: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
933: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
934:
935: -- Variables used to call the Shipping API to split a WDD line during partial
936: -- allocation for allocation mode of N (Prioritize Inventory).
937: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;

Line 2050: WSH_INTERFACE.Update_Shipping_Attributes

2046: l_shipping_attr(1).subinventory := l_mo_line.from_subinventory_code;
2047: l_shipping_attr(1).locator_id := l_mo_line.from_locator_id;
2048:
2049:
2050: WSH_INTERFACE.Update_Shipping_Attributes
2051: (p_source_code => 'INV',
2052: p_changed_attributes => l_shipping_attr,
2053: x_return_status => l_api_return_status
2054: );

Line 2431: --WSH_INTERFACE.Update_Shipping_Attributes

2427:
2428: l_smc_backorder_det_tbl.DELETE;
2429:
2430:
2431: --WSH_INTERFACE.Update_Shipping_Attributes
2432: --(p_source_code => 'INV',
2433: --p_changed_attributes => l_shipping_attr,
2434: --x_return_status => l_api_return_status
2435: --);

Line 2656: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of

2652: l_in_rec.action_code := 'UPDATE';
2653:
2654: ELSE
2655:
2656: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2657: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2658: -- in order to properly NULL out the move_order_line_id value.
2659:
2660: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;

Line 2657: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL

2653:
2654: ELSE
2655:
2656: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2657: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2658: -- in order to properly NULL out the move_order_line_id value.
2659:
2660: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;
2661:

Line 2668: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

2664: l_in_rec.action_code := 'UPDATE';
2665:
2666: END IF;
2667:
2668: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
2669: (p_api_version_number => 1.0,
2670: p_init_msg_list => fnd_api.g_false,
2671: p_commit => fnd_api.g_false,
2672: x_return_status => l_api_return_status,

Line 2708: WSH_INTERFACE_GRP.Delivery_Detail_Action

2704: (l_quantity - NVL(l_quantity_delivered,0)) - l_transaction_quantity;
2705: l_action_prms.split_quantity2 :=
2706: (l_quantity2 - NVL(l_quantity2_delivered,0)) - l_transaction_quantity2;
2707:
2708: WSH_INTERFACE_GRP.Delivery_Detail_Action
2709: (p_api_version_number => 1.0,
2710: p_init_msg_list => fnd_api.g_false,
2711: p_commit => fnd_api.g_false,
2712: x_return_status => l_api_return_status,

Line 2743: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of

2739: -- value in the corresponding WDD record (original one) in p_wsh_release_table
2740: l_detail_info_tab(1).delivery_detail_id := l_split_delivery_detail_id;
2741: l_detail_info_tab(1).released_status :=
2742: p_wsh_release_table(l_wdd_index_tbl(l_delivery_detail_id)).released_status;
2743: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2744: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2745: -- in order to properly NULL out the move_order_line_id value.
2746: --l_detail_info_tab(1).move_order_line_id := NULL;
2747: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;

Line 2744: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL

2740: l_detail_info_tab(1).delivery_detail_id := l_split_delivery_detail_id;
2741: l_detail_info_tab(1).released_status :=
2742: p_wsh_release_table(l_wdd_index_tbl(l_delivery_detail_id)).released_status;
2743: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2744: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2745: -- in order to properly NULL out the move_order_line_id value.
2746: --l_detail_info_tab(1).move_order_line_id := NULL;
2747: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;
2748:

Line 2765: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

2761:
2762:
2763: l_in_rec.action_code := 'UPDATE';
2764:
2765: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
2766: (p_api_version_number => 1.0,
2767: p_init_msg_list => fnd_api.g_false,
2768: p_commit => fnd_api.g_false,
2769: x_return_status => l_api_return_status,

Line 2897: WSH_INTERFACE.Update_Shipping_Attributes

2893:
2894: l_shipping_attr(1).subinventory := l_mo_line.from_subinventory_code;
2895: l_shipping_attr(1).locator_id := l_mo_line.from_locator_id;
2896:
2897: WSH_INTERFACE.Update_Shipping_Attributes
2898: (p_source_code => 'INV',
2899: p_changed_attributes => l_shipping_attr,
2900: x_return_status => l_api_return_status
2901: );