DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on WMS_CONTAINER_PUB

Line 799: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

795: AND organization_id = p_organization_id;
796: l_return_status VARCHAR2(300);
797: l_msg_count NUMBER;
798: l_msg_data VARCHAR2(300);
799: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
800: l_temp_bool BOOLEAN;
801: l_prefix VARCHAR2(30);
802: l_quantity NUMBER;
803: l_from_number NUMBER;

Line 904: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

900: -- Get the outermost LPN ID for this record if necessary
901: IF (p_parent_lpn_id IS NOT NULL) THEN
902: --Bug2935754 starts
903: /*
904: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
905: ( p_api_version => 1.0,
906: x_return_status => l_return_status,
907: x_msg_count => l_msg_count,
908: x_msg_data => l_msg_data,

Line 1085: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

1081: l_item_standard_uom VARCHAR2(3);
1082: l_return_status VARCHAR2(300);
1083: l_msg_count NUMBER;
1084: l_msg_data VARCHAR2(300);
1085: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1086: l_employee_id NUMBER;
1087:
1088: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1089: BEGIN

Line 1122: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

1118: -- Get the outermost LPN ID for this record if necessary
1119: IF (p_parent_lpn_id IS NOT NULL) THEN
1120: --Bug2935754 starts
1121: /*
1122: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
1123: ( p_api_version => 1.0,
1124: x_return_status => l_return_status,
1125: x_msg_count => l_msg_count,
1126: x_msg_data => l_msg_data,

Line 1400: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

1396: l_outermost_lpn_id NUMBER;
1397: l_return_status VARCHAR2(300);
1398: l_msg_count NUMBER;
1399: l_msg_data VARCHAR2(300);
1400: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1401: l_approval_status NUMBER:= -1;
1402: l_lot_expiration_date Date; /* Added by 8199582 */
1403: l_process_enabled_flag VARCHAR2(1);
1404:

Line 1556: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

1552: -- Get the outermost LPN ID if necessary
1553: IF (p_parent_lpn_id IS NOT NULL) THEN
1554: --Bug2935754 starts
1555: /*
1556: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
1557: ( p_api_version => 1.0,
1558: x_return_status => l_return_status,
1559: x_msg_count => l_msg_count,
1560: x_msg_data => l_msg_data,