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 772: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;

768: -- processed.
769: l_detail_rec_count NUMBER := 0;
770:
771: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
772: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
773: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
774: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
775: l_action_flag VARCHAR2(1);
776: l_quantity NUMBER;

Line 773: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;

769: l_detail_rec_count NUMBER := 0;
770:
771: l_mo_line_tbl INV_Move_Order_Pub.Trolin_Tbl_Type := p_mo_line_tbl;
772: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
773: l_smc_backorder_det_tbl WSH_INTERFACE.ChangedAttributeTabType;
774: l_shipset_smc_backorder_rec WSH_INTEGRATION.BackorderRecType;
775: l_action_flag VARCHAR2(1);
776: l_quantity NUMBER;
777: -- HW INVCONV Added Qty2 variables

Line 920: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

916:
917: -- Variables used to call the Shipping API to update a WDD line during partial or zero
918: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
919: -- primarily to update the released_status and to null out the move_order_line_id.
920: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
921: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
922: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
923:
924: -- Variables used to call the Shipping API to split a WDD line during partial

Line 921: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

917: -- Variables used to call the Shipping API to update a WDD line during partial or zero
918: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
919: -- primarily to update the released_status and to null out the move_order_line_id.
920: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
921: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
922: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
923:
924: -- Variables used to call the Shipping API to split a WDD line during partial
925: -- allocation for allocation mode of N (Prioritize Inventory).

Line 922: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

918: -- allocation for allocation mode of N (Prioritize Inventory). This will be used
919: -- primarily to update the released_status and to null out the move_order_line_id.
920: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
921: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
922: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
923:
924: -- Variables used to call the Shipping API to split a WDD line during partial
925: -- allocation for allocation mode of N (Prioritize Inventory).
926: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;

Line 1962: WSH_INTERFACE.Update_Shipping_Attributes

1958: l_shipping_attr(1).subinventory := l_mo_line.from_subinventory_code;
1959: l_shipping_attr(1).locator_id := l_mo_line.from_locator_id;
1960:
1961:
1962: WSH_INTERFACE.Update_Shipping_Attributes
1963: (p_source_code => 'INV',
1964: p_changed_attributes => l_shipping_attr,
1965: x_return_status => l_api_return_status
1966: );

Line 2342: --WSH_INTERFACE.Update_Shipping_Attributes

2338:
2339: l_smc_backorder_det_tbl.DELETE;
2340:
2341:
2342: --WSH_INTERFACE.Update_Shipping_Attributes
2343: --(p_source_code => 'INV',
2344: --p_changed_attributes => l_shipping_attr,
2345: --x_return_status => l_api_return_status
2346: --);

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

2541: l_in_rec.action_code := 'UPDATE';
2542:
2543: ELSE
2544:
2545: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2546: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2547: -- in order to properly NULL out the move_order_line_id value.
2548:
2549: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;

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

2542:
2543: ELSE
2544:
2545: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2546: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2547: -- in order to properly NULL out the move_order_line_id value.
2548:
2549: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;
2550:

Line 2557: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

2553: l_in_rec.action_code := 'UPDATE';
2554:
2555: END IF;
2556:
2557: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
2558: (p_api_version_number => 1.0,
2559: p_init_msg_list => fnd_api.g_false,
2560: p_commit => fnd_api.g_false,
2561: x_return_status => l_api_return_status,

Line 2597: WSH_INTERFACE_GRP.Delivery_Detail_Action

2593: (l_quantity - NVL(l_quantity_delivered,0)) - l_transaction_quantity;
2594: l_action_prms.split_quantity2 :=
2595: (l_quantity2 - NVL(l_quantity2_delivered,0)) - l_transaction_quantity2;
2596:
2597: WSH_INTERFACE_GRP.Delivery_Detail_Action
2598: (p_api_version_number => 1.0,
2599: p_init_msg_list => fnd_api.g_false,
2600: p_commit => fnd_api.g_false,
2601: x_return_status => l_api_return_status,

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

2628: -- value in the corresponding WDD record (original one) in p_wsh_release_table
2629: l_detail_info_tab(1).delivery_detail_id := l_split_delivery_detail_id;
2630: l_detail_info_tab(1).released_status :=
2631: p_wsh_release_table(l_wdd_index_tbl(l_delivery_detail_id)).released_status;
2632: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2633: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2634: -- in order to properly NULL out the move_order_line_id value.
2635: --l_detail_info_tab(1).move_order_line_id := NULL;
2636: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;

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

2629: l_detail_info_tab(1).delivery_detail_id := l_split_delivery_detail_id;
2630: l_detail_info_tab(1).released_status :=
2631: p_wsh_release_table(l_wdd_index_tbl(l_delivery_detail_id)).released_status;
2632: -- When calling the Shipping package WSH_INTERFACE_EXT_GRP instead of
2633: -- WSH_INTERFACE_GRP, we have to pass a G_MISS_NUM value instead of NULL
2634: -- in order to properly NULL out the move_order_line_id value.
2635: --l_detail_info_tab(1).move_order_line_id := NULL;
2636: l_detail_info_tab(1).move_order_line_id := fnd_api.g_miss_num;
2637:

Line 2654: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail

2650:
2651:
2652: l_in_rec.action_code := 'UPDATE';
2653:
2654: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
2655: (p_api_version_number => 1.0,
2656: p_init_msg_list => fnd_api.g_false,
2657: p_commit => fnd_api.g_false,
2658: x_return_status => l_api_return_status,

Line 2752: WSH_INTERFACE.Update_Shipping_Attributes

2748: l_shipping_attr(1).cycle_count_quantity2 := (l_quantity2 - l_transaction_quantity2);
2749: l_shipping_attr(1).subinventory := l_mo_line.from_subinventory_code;
2750: l_shipping_attr(1).locator_id := l_mo_line.from_locator_id;
2751:
2752: WSH_INTERFACE.Update_Shipping_Attributes
2753: (p_source_code => 'INV',
2754: p_changed_attributes => l_shipping_attr,
2755: x_return_status => l_api_return_status
2756: );