DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_INTERFACE

Line 3445: p_Changed_Attributes IN WSH_INTERFACE.ChangedAttributeTabType

3441: END update_serial_numbers;
3442:
3443:
3444: PROCEDURE Update_Inventory_Info(
3445: p_Changed_Attributes IN WSH_INTERFACE.ChangedAttributeTabType
3446: , x_return_status OUT NOCOPY VARCHAR2)
3447: IS
3448:
3449: -- Bug 2657652 : Changed cursor to fetch selective columns instead of *

Line 3520: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;

3516: l_cons_flag VARCHAR2(1) := 'N';
3517:
3518: -- End of Consolidation of Back Order Delivery Details Enhancement
3519:
3520: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
3521: l_counter NUMBER;
3522: l_delivery_status VARCHAR2(3);
3523: l_container_instance_id NUMBER;
3524: l_number_of_shipped_details NUMBER;

Line 3577: l_overpick_rec WSH_INTERFACE.ChangedAttributeRecType;

3573: l_copy_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3574: l_details_to_delete WSH_UTIL_CORE.Id_Tab_Type;
3575: l_delete_count NUMBER := 0;
3576:
3577: l_overpick_rec WSH_INTERFACE.ChangedAttributeRecType;
3578: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;
3579: l_new_req_quantity NUMBER;
3580: -- HW OPM added qty2
3581: l_new_req_quantity2 NUMBER;

Line 6333: WSH_INTERFACE.Delete_Details(

6329:
6330:
6331: IF l_details_to_delete.count > 0 THEN
6332: --
6333: WSH_INTERFACE.Delete_Details(
6334: p_details_id => l_details_to_delete,
6335: x_return_status => l_return_status);
6336: IF l_debug_on THEN
6337: WSH_DEBUG_SV.log(l_module_name,'Delete_Details l_return_status',l_return_status);