APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_DELIVERY_DETAILS_INV

Line 443: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

439: l_bo_qty2 NUMBER ;
440: l_unassign_dds WSH_UTIL_CORE.Id_Tab_Type ;
441: l_unassign_dds_tmp WSH_UTIL_CORE.Id_Tab_Type ; -- bug 7460785
442: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
443: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
444:
445: invalid_source_code EXCEPTION; /*Bug 2096052- added for OKE */
446: no_backorder_full EXCEPTION; /*Bug 2399729- added for third party warehouse shipment line */
447: l_backorder_all VARCHAR2(1) := 'N'; /* Bug 2399729 */

Line 536: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

532: l_msg_count NUMBER;
533: l_msg_data VARCHAR2(32767);
534: e_return_excp EXCEPTION;
535: -- K LPN CONV. rv
536: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
537: --
538: --
539: l_unassign_dd_flag VARCHAR2(1) := 'N';
540: l_planned_flag VARCHAR2(1); -- bug# 6908504 (replenishment project)

Line 808: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */

804:
805: END IF;
806:
807: /*Bug 5525314 moved up the open cursor c_detail
808: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */
809: /* H integration: 940/945 look up source code before unassigning wrudge*/
810: OPEN c_detail(l_bo_detail_id );
811: FETCH c_detail INTO l_detail_rec;
812: CLOSE c_detail;

Line 831: WSH_DELIVERY_DETAILS_INV.Get_item_information

827: IF l_detail_rec.released_status = 'Y' THEN
828: -- call this API only if line is staged, so we can test lot
829: -- divisibility.
830:
831: WSH_DELIVERY_DETAILS_INV.Get_item_information
832: (
833: p_organization_id => l_detail_rec.organization_id,
834: p_inventory_item_id => l_detail_rec.inventory_item_id,
835: x_mtl_system_items_rec => l_item_info,

Line 977: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(

973: -- then mark it as deleted.
974: l_delete_dds( l_delete_dds.count+1 ) := l_detail_ids(i);
975: END IF;
976: -- bug 1672188: unreserve if the detail is reserved
977: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(
978: p_detail_id => l_detail_rec.delivery_detail_id,
979: p_source_code => l_detail_rec.source_code,
980: p_released_status => l_detail_rec.released_status,
981: p_pickable_flag => l_detail_rec.pickable_flag,

Line 1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

1235: --
1236: -- Debug Statements
1237: --
1238: IF l_debug_on THEN
1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1240: END IF;
1241: --
1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1243: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1238: IF l_debug_on THEN
1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1240: END IF;
1241: --
1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1243: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1244: p_inventory_item_id => l_detail_rec.inventory_item_id,
1245: p_organization_id => l_detail_rec.organization_id,
1246: p_subinventory => l_detail_rec.subinventory,

Line 1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

1263: --
1264: -- Debug Statements
1265: --
1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: --
1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1271: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(

1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: --
1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1271: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1272: p_serial_number_code => l_inv_controls_rec.serial_code,
1273: p_serial_number => l_detail_rec.serial_number,
1274: p_transaction_temp_id => l_detail_rec.transaction_temp_id,