APPS.WSH_BULK_PROCESS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 716: FROM wsh_delivery_details

712:
713: --Cursor checks for PO data in WSH.
714: CURSOR c_po_exists(p_header_id NUMBER,p_blanket_ref_id NUMBER) is
715: SELECT '1'
716: FROM wsh_delivery_details
717: WHERE source_header_id = p_header_id
718: AND source_code = 'PO'
719: AND (
720: (p_blanket_ref_id is NULL AND

Line 3145: (p_flexfield_name => 'WSH_DELIVERY_DETAILS',

3141: l_tp_is_installed := 'N';
3142: END IF;
3143:
3144: WSH_FLEXFIELD_UTILS.Get_DFF_Defaults
3145: (p_flexfield_name => 'WSH_DELIVERY_DETAILS',
3146: p_default_values => l_dff_attribute,
3147: p_default_context => l_dff_context,
3148: p_update_flag => l_dff_update_flag,
3149: x_return_status => l_return_status);

Line 3775: -- wsh_delivery_details and wsh_delivery_assignments_v

3771: -- and ready to use to store additional
3772: -- information for line record.
3773: -- x_return_status return status
3774: -- COMMENT : This procedure will bulk insert the records into tables
3775: -- wsh_delivery_details and wsh_delivery_assignments_v
3776: --========================================================================
3777:
3778:
3779: PROCEDURE bulk_insert_details (

Line 3888: INSERT INTO wsh_delivery_details(

3884: END IF;
3885:
3886:
3887: FORALL i in l_first..l_last
3888: INSERT INTO wsh_delivery_details(
3889: source_code,
3890: source_header_id,
3891: source_line_id,
3892: customer_id,

Line 4155: wsh_delivery_details_s.nextval,

4151: p_line_rec.source_line_number(i),
4152: decode (p_additional_line_info_rec.source_code, 'OKE' ,
4153: nvl (p_line_rec.inspection_flag(i), 'N') , 'N' ),
4154: p_additional_line_info_rec.released_status(i),
4155: wsh_delivery_details_s.nextval,
4156: 'N',
4157: p_line_rec.gross_weight(i),
4158: p_line_rec.seal_code(i),
4159: p_line_rec.end_item_unit_number(i),

Line 4241: -- Insert of wsh_delivery_details, call DBI API after the insert.

4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END IF;
4239:
4240: -- DBI Project
4241: -- Insert of wsh_delivery_details, call DBI API after the insert.
4242: -- This API will also check for DBI Installed or not
4243: IF l_debug_on THEN
4244: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail count-',l_detail_tab.count);
4245: END IF;

Line 4370: DELETE FROM WSH_DELIVERY_DETAILS

4366: l_first := l_invalid_ids.FIRST; --always 1
4367: l_count := l_invalid_ids.COUNT;
4368:
4369: FORALL i IN l_first..l_count
4370: DELETE FROM WSH_DELIVERY_DETAILS
4371: WHERE delivery_detail_id = l_invalid_ids(i);
4372: --put debug message for the rowcount
4373:
4374: END IF;

Line 4425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT',WSH_DEBUG_SV.C_PROC_LEVEL);

4421:
4422: --OTM R12 calling delivery detail splitter if records exist, l_tab_index incremented
4423: IF (l_gc3_is_installed = 'Y' AND l_tab_index > 1) THEN
4424: IF l_debug_on THEN
4425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT',WSH_DEBUG_SV.C_PROC_LEVEL);
4426: END IF;
4427:
4428: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
4429: p_detail_tab => l_delivery_detail_tab,

Line 4428: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

4424: IF l_debug_on THEN
4425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT',WSH_DEBUG_SV.C_PROC_LEVEL);
4426: END IF;
4427:
4428: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
4429: p_detail_tab => l_delivery_detail_tab,
4430: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
4431: x_return_status => l_return_status);
4432:

Line 4434: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT',l_return_status);

4430: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
4431: x_return_status => l_return_status);
4432:
4433: IF l_debug_on THEN
4434: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT',l_return_status);
4435: END IF;
4436: -- we will not fail based on l_return_status here because
4437: -- we do not want to stop the flow
4438: -- if the detail doesn't split, it will be caught later in