DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on WMS_CONTAINER_PUB

Line 689: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

685: AND organization_id = p_organization_id;
686: l_return_status VARCHAR2(300);
687: l_msg_count NUMBER;
688: l_msg_data VARCHAR2(300);
689: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
690: l_temp_bool BOOLEAN;
691: l_prefix VARCHAR2(30);
692: l_quantity NUMBER;
693: l_from_number NUMBER;

Line 791: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

787: -- Get the outermost LPN ID for this record if necessary
788: IF (p_parent_lpn_id IS NOT NULL) THEN
789: --Bug2935754 starts
790: /*
791: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
792: ( p_api_version => 1.0,
793: x_return_status => l_return_status,
794: x_msg_count => l_msg_count,
795: x_msg_data => l_msg_data,

Line 939: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

935: l_item_standard_uom VARCHAR2(3);
936: l_return_status VARCHAR2(300);
937: l_msg_count NUMBER;
938: l_msg_data VARCHAR2(300);
939: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
940: l_employee_id NUMBER;
941:
942: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
943: BEGIN

Line 973: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

969: -- Get the outermost LPN ID for this record if necessary
970: IF (p_parent_lpn_id IS NOT NULL) THEN
971: --Bug2935754 starts
972: /*
973: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
974: ( p_api_version => 1.0,
975: x_return_status => l_return_status,
976: x_msg_count => l_msg_count,
977: x_msg_data => l_msg_data,

Line 1227: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

1223: l_outermost_lpn_id NUMBER;
1224: l_return_status VARCHAR2(300);
1225: l_msg_count NUMBER;
1226: l_msg_data VARCHAR2(300);
1227: l_lpn_list WMS_Container_PUB.LPN_Table_Type;
1228: l_approval_status NUMBER:= -1;
1229:
1230: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1231: BEGIN

Line 1357: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN

1353: -- Get the outermost LPN ID if necessary
1354: IF (p_parent_lpn_id IS NOT NULL) THEN
1355: --Bug2935754 starts
1356: /*
1357: WMS_CONTAINER_PUB.GET_OUTERMOST_LPN
1358: ( p_api_version => 1.0,
1359: x_return_status => l_return_status,
1360: x_msg_count => l_msg_count,
1361: x_msg_data => l_msg_data,