DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_INTERFACE

Line 3835: p_Changed_Attributes IN WSH_INTERFACE.ChangedAttributeTabType

3831: END update_serial_numbers;
3832:
3833:
3834: PROCEDURE Update_Inventory_Info(
3835: p_Changed_Attributes IN WSH_INTERFACE.ChangedAttributeTabType
3836: , x_return_status OUT NOCOPY VARCHAR2)
3837: IS
3838:
3839: -- Bug 2657652 : Changed cursor to fetch selective columns instead of *

Line 3912: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;

3908: l_cons_flag VARCHAR2(1) := 'N';
3909:
3910: -- End of Consolidation of Back Order Delivery Details Enhancement
3911:
3912: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
3913: l_counter NUMBER;
3914: l_delivery_status VARCHAR2(3);
3915: l_container_instance_id NUMBER;
3916: l_number_of_shipped_details NUMBER;

Line 3969: l_overpick_rec WSH_INTERFACE.ChangedAttributeRecType;

3965: l_copy_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3966: l_details_to_delete WSH_UTIL_CORE.Id_Tab_Type;
3967: l_delete_count NUMBER := 0;
3968:
3969: l_overpick_rec WSH_INTERFACE.ChangedAttributeRecType;
3970: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;
3971: l_new_req_quantity NUMBER;
3972: -- HW OPM added qty2
3973: l_new_req_quantity2 NUMBER;

Line 7034: WSH_INTERFACE.Delete_Details(

7030:
7031:
7032: IF l_details_to_delete.count > 0 THEN
7033: --
7034: WSH_INTERFACE.Delete_Details(
7035: p_details_id => l_details_to_delete,
7036: x_return_status => l_return_status);
7037: IF l_debug_on THEN
7038: WSH_DEBUG_SV.log(l_module_name,'Delete_Details l_return_status',l_return_status);