APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_DELIVERY_DETAILS_INV

Line 432: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

428: l_bo_qty2 NUMBER ;
429: l_unassign_dds WSH_UTIL_CORE.Id_Tab_Type ;
430: l_unassign_dds_tmp WSH_UTIL_CORE.Id_Tab_Type ; -- bug 7460785
431: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
432: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
433:
434: invalid_source_code EXCEPTION; /*Bug 2096052- added for OKE */
435: no_backorder_full EXCEPTION; /*Bug 2399729- added for third party warehouse shipment line */
436: l_backorder_all VARCHAR2(1) := 'N'; /* Bug 2399729 */

Line 519: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

515: l_msg_count NUMBER;
516: l_msg_data VARCHAR2(32767);
517: e_return_excp EXCEPTION;
518: -- K LPN CONV. rv
519: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
520: --
521: --
522: l_unassign_dd_flag VARCHAR2(1) := 'N';
523: l_planned_flag VARCHAR2(1); -- bug# 6908504 (replenishment project)

Line 733: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */

729:
730: END IF;
731:
732: /*Bug 5525314 moved up the open cursor c_detail
733: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */
734: /* H integration: 940/945 look up source code before unassigning wrudge*/
735: OPEN c_detail(l_bo_detail_id );
736: FETCH c_detail INTO l_detail_rec;
737: CLOSE c_detail;

Line 756: WSH_DELIVERY_DETAILS_INV.Get_item_information

752: IF l_detail_rec.released_status = 'Y' THEN
753: -- call this API only if line is staged, so we can test lot
754: -- divisibility.
755:
756: WSH_DELIVERY_DETAILS_INV.Get_item_information
757: (
758: p_organization_id => l_detail_rec.organization_id,
759: p_inventory_item_id => l_detail_rec.inventory_item_id,
760: x_mtl_system_items_rec => l_item_info,

Line 872: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(

868: -- then mark it as deleted.
869: l_delete_dds( l_delete_dds.count+1 ) := l_detail_ids(i);
870: END IF;
871: -- bug 1672188: unreserve if the detail is reserved
872: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(
873: p_detail_id => l_detail_rec.delivery_detail_id,
874: p_source_code => l_detail_rec.source_code,
875: p_released_status => l_detail_rec.released_status,
876: p_pickable_flag => l_detail_rec.pickable_flag,

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

1088: --
1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1096: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1096: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1097: p_inventory_item_id => l_detail_rec.inventory_item_id,
1098: p_organization_id => l_detail_rec.organization_id,
1099: p_subinventory => l_detail_rec.subinventory,

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

1116: --
1117: -- Debug Statements
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1121: END IF;
1122: --
1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1124: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(

1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1121: END IF;
1122: --
1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1124: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1125: p_serial_number_code => l_inv_controls_rec.serial_code,
1126: p_serial_number => l_detail_rec.serial_number,
1127: p_transaction_temp_id => l_detail_rec.transaction_temp_id,