eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_DELIVERY_DETAILS

Line 956: UPDATE wsh_delivery_details

952: WSH_DEBUG_SV.log(l_module_name,'p_diff_net_weight',p_diff_net_weight);
953: WSH_DEBUG_SV.log(l_module_name,'p_diff_volume',p_diff_volume);
954: END IF;
955: --
956: UPDATE wsh_delivery_details
957: SET gross_weight = NVL(gross_weight,0) - NVL(p_diff_gross_weight,0),
958: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
959: filled_volume = NVL(filled_volume,0) - NVL(p_diff_volume,0),
960: LAST_UPDATE_DATE = SYSDATE,

Line 1437: -- 2.Match the ASN/Receipt to wsh_delivery_details, where by records in wsh_delivery_details

1433: -- Pre-reqs : None.
1434: -- Function : The following actions are carried out in this API:
1435: -- 1.If the API is called from UI, the p_line_rec structure is empty.
1436: -- Derive the p_line_rec if called from UI.
1437: -- 2.Match the ASN/Receipt to wsh_delivery_details, where by records in wsh_delivery_details
1438: -- are updated, new records are created if needed.
1439: -- 3.If the original PO record is closed/cancelled, then collect the list of those
1440: -- recrods into x_po_cancel_rec and x_po_close_rec which are the OUT parameters
1441: -- which will be used in Ravi's API to later perform cancle/close action on the

Line 1509: from WSH_DELIVERY_DETAILS

1505: select src_requested_quantity2,
1506: src_requested_quantity_uom2,
1507: src_requested_quantity,
1508: src_requested_quantity_uom
1509: from WSH_DELIVERY_DETAILS
1510: where
1511: source_line_id = p_line_id and --performance
1512: po_shipment_line_id = p_line_location_id and
1513: source_code = 'PO'

Line 1522: from wsh_delivery_details

1518:
1519: Cursor c_sum_req_qty(p_line_id NUMBER,p_line_location_id NUMBER)
1520: IS
1521: select sum(requested_quantity)
1522: from wsh_delivery_details
1523: where
1524: source_line_id = p_line_id and --performance
1525: po_shipment_line_id = p_line_location_id and
1526: source_code = 'PO';

Line 1568: FROM wsh_delivery_details wdd,

1564: wdd.requested_quantity
1565: )
1566: ) wv_qty,
1567: wdd.requested_quantity requested_quantity
1568: FROM wsh_delivery_details wdd,
1569: wsh_delivery_assignments_v wda,
1570: wsh_delivery_details wdd1,
1571: wsh_new_deliveries wnd
1572: where wdd.delivery_detail_id = p_delivery_detail_id

Line 1570: wsh_delivery_details wdd1,

1566: ) wv_qty,
1567: wdd.requested_quantity requested_quantity
1568: FROM wsh_delivery_details wdd,
1569: wsh_delivery_assignments_v wda,
1570: wsh_delivery_details wdd1,
1571: wsh_new_deliveries wnd
1572: where wdd.delivery_detail_id = p_delivery_detail_id
1573: AND wdd.delivery_detail_id = wda.delivery_detail_id
1574: --AND wda.delivery_id = wnd.delivery_id

Line 1591: p_dd_assign_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_type;

1587:
1588: temp_lpn NUMBER;
1589:
1590: p_dd_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
1591: p_dd_assign_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_type;
1592:
1593: p_dd_list WSH_PO_CMG_PVT.dd_list_type;
1594: l_local_dd_rec LOCAL_DD_REC_TABLE_TYPE;
1595:

Line 2128: -- p_dd_rec.delivery_detail_id is null.Need to insert record into wsh_delivery_details.

2124: x_num_errors => l_num_errors);
2125:
2126:
2127: ELSE
2128: -- p_dd_rec.delivery_detail_id is null.Need to insert record into wsh_delivery_details.
2129: -- This is done by first populating addtional line information using
2130: -- WSH_PO_CMG_PVT.populate_additional_line_info API and then calling
2131: -- WSH_BULK_PROCESS_PVT.bulk_insert_details API to do the insert operation.
2132: --

Line 2207: -- Updating wsh_delivery_assignments_v after the insert into wsh_delivery_details.

2203: WSH_DEBUG_SV.logmsg(l_module_name,'updating WDA');
2204: WSH_DEBUG_SV.log(l_module_name,'p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i))',p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i)));
2205: END IF;
2206:
2207: -- Updating wsh_delivery_assignments_v after the insert into wsh_delivery_details.
2208:
2209: update wsh_delivery_assignments_v
2210: set delivery_id = p_dd_rec.delivery_id_tab(i),
2211: last_update_date = SYSDATE,

Line 2344: -- will be cosolidated and a single record will be inserted into wsh_delivery_details

2340: -- set the released status to 'L'-Closed if transaction type is Receipt
2341: -- and received qty is not null.
2342: -- Calculates the remaining qty to see if the case is that of a partial shipment/receipt
2343: -- All the remaining quantities for a particular po_line_location_id
2344: -- will be cosolidated and a single record will be inserted into wsh_delivery_details
2345: -- in case if there are no open delivery_details present for the same.
2346:
2347: IF p_dd_rec.transaction_type = 'ASN' THEN
2348: --{

Line 2470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);

2466: --
2467: -- Debug Statements
2468: --
2469: IF l_debug_on THEN
2470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);
2471: END IF;
2472: --
2473: -- Calling WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD() to create new delivery detail
2474: -- from old.

Line 2473: -- Calling WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD() to create new delivery detail

2469: IF l_debug_on THEN
2470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);
2471: END IF;
2472: --
2473: -- Calling WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD() to create new delivery detail
2474: -- from old.
2475:
2476: WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD(
2477: p_delivery_detail_rec => p_dd_info,

Line 2476: WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD(

2472: --
2473: -- Calling WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD() to create new delivery detail
2474: -- from old.
2475:
2476: WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD(
2477: p_delivery_detail_rec => p_dd_info,
2478: --p_delivery_detail_id => p_dd_rec.del_detail_id_tab(k),
2479: p_delivery_detail_id => p_dd_rec.parent_delivery_detail_id_tab(p_dd_rec.child_index_tab(k)),
2480: x_row_id => x_row_id,

Line 2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);

2515: --
2516: -- Debug Statements
2517: --
2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
2523: p_delivery_assignments_info => p_dd_assign_info,

Line 2522: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(

2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
2523: p_delivery_assignments_info => p_dd_assign_info,
2524: x_rowid => x_rowid,
2525: x_delivery_assignment_id => x_delivery_assignment_id,
2526: x_return_status => l_return_status);

Line 2589: -- record at the end into wsh_delivery_details.

2585: --Check if remaining quantity is greater than zero.
2586:
2587: IF nvl(l_remaining_qty,0) > 0 THEN
2588: -- Consolidate all the open quantities agains the same po line location to insert one
2589: -- record at the end into wsh_delivery_details.
2590: --{
2591: IF l_debug_on THEN
2592: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Consolidate_qty',WSH_DEBUG_SV.C_PROC_LEVEL);
2593: END IF;

Line 3288: update wsh_delivery_details

3284: -- Bulk updating all the delivery_detail records using the l_update_dd_rec which was populated in the
3285: -- main loop above.
3286:
3287: FORALL i in 1..l_update_dd_rec.delivery_detail_id.COUNT
3288: update wsh_delivery_details
3289: set requested_quantity = l_update_dd_rec.requested_quantity(i),
3290: shipped_quantity = l_update_dd_rec.shipped_quantity(i),
3291: returned_quantity = l_update_dd_rec.returned_quantity(i),
3292: received_quantity = l_update_dd_rec.received_quantity(i),

Line 3329: -- Update of wsh_delivery_details where requested_quantity/released_status

3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: --
3328: -- DBI Project
3329: -- Update of wsh_delivery_details where requested_quantity/released_status
3330: -- are changed, call DBI API after the update.
3331: -- This API will also check for DBI Installed or not
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API. delivery details count l_detail_tab : ',l_detail_tab.count);

Line 3512: -- Call Reapprove_PO API to insert new record into wsh_delivery_details

3508: OR l_sli_qty_cache.COUNT > 0 THEN
3509: --{
3510: l_action_prms.action_code := p_dd_rec.transaction_type;
3511:
3512: -- Call Reapprove_PO API to insert new record into wsh_delivery_details
3513: -- for the consolidated qty.
3514: -- When this API is called with p_line_rec.consolidated_qty duly populated,
3515: -- we set the case as increment in the REAPPROVE_PO API.
3516: -- The Update_quantity API checks if there are any open delivery details record

Line 3775: WSH_DELIVERY_DETAILS WDD,

3771: Wdd.delivery_detail_id,
3772: Wda.parent_delivery_detail_id,
3773: wdd.po_shipment_line_id
3774: FROM
3775: WSH_DELIVERY_DETAILS WDD,
3776: wsh_delivery_assignments_v WDA,
3777: WSH_NEW_DELIVERIES WND
3778: WHERE wdd.delivery_detail_id = wda.delivery_detail_id and
3779: wdd.line_direction not in ('O','IO') and

Line 3878: -- Updating the all the records in wsh_delivery_details

3874: IF l_debug_on THEN
3875: WSH_DEBUG_SV.logmsg(l_module_name,'updating WDD');
3876: END IF;
3877: --
3878: -- Updating the all the records in wsh_delivery_details
3879: -- corresponding to the shipment_header_id that is being passed
3880: -- for cancellation.
3881:
3882: UPDATE WSH_DELIVERY_DETAILS

Line 3882: UPDATE WSH_DELIVERY_DETAILS

3878: -- Updating the all the records in wsh_delivery_details
3879: -- corresponding to the shipment_header_id that is being passed
3880: -- for cancellation.
3881:
3882: UPDATE WSH_DELIVERY_DETAILS
3883: SET released_status = 'X',
3884: Shipped_quantity = NULL,
3885: received_quantity = NULL,
3886: shipped_quantity2 = NULL,

Line 3893: from wsh_delivery_details wdd,

3889: LAST_UPDATE_DATE = SYSDATE,
3890: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3892: where delivery_detail_id in (select wdd.delivery_detail_id
3893: from wsh_delivery_details wdd,
3894: wsh_delivery_assignments_v wda,
3895: wsh_new_deliveries wnd
3896: where wdd.delivery_detail_id = wda.delivery_detail_id
3897: and wda.delivery_id = wnd.delivery_id

Line 3904: -- Update of wsh_delivery_details where requested_quantity/released_status

3900: and released_status = 'C'
3901: returning delivery_detail_id,po_shipment_line_id,ship_from_location_id, picked_quantity
3902: BULK COLLECT INTO l_dd_list.delivery_detail_id,l_dd_list.po_shipment_line_id,l_sf_locn_id_tbl, l_picked_qty_tbl;
3903: -- DBI Project
3904: -- Update of wsh_delivery_details where requested_quantity/released_status
3905: -- are changed, call DBI API after the update.
3906: -- This API will also check for DBI Installed or not
3907: FOR i in 1..l_dd_list.delivery_detail_id.count LOOP
3908: l_detail_tab(i) := l_dd_list.delivery_detail_id(i) ;

Line 4013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

4009:
4010: IF l_dd_unassigned_tbl.COUNT > 0 THEN
4011:
4012: IF l_debug_on THEN
4013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4014: END IF;
4015:
4016: l_unassign_action_prms := p_action_prms;
4017: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;

Line 4020: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(

4016: l_unassign_action_prms := p_action_prms;
4017: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4018: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4019:
4020: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
4021: p_rec_of_detail_ids => l_dd_unassigned_tbl,
4022: p_from_delivery => 'Y',
4023: p_from_container => 'N',
4024: x_return_status => l_return_status,

Line 4261: wsh_delivery_details wdd,

4257: cursor c_get_open_dds(p_del_id NUMBER) IS
4258: SELECT
4259: wdd.delivery_detail_id
4260: FROM
4261: wsh_delivery_details wdd,
4262: wsh_delivery_assignments_v wda
4263: WHERE
4264: wdd.delivery_detail_id = wda.delivery_detail_id AND
4265: wda.delivery_id = p_del_id AND

Line 4273: wsh_delivery_details wdd,

4269: cursor c_get_open_closed_dds(v_del_id NUMBER) IS
4270: SELECT
4271: wdd.delivery_detail_id, nvl(wdd.container_flag,'N') container_flag
4272: FROM
4273: wsh_delivery_details wdd,
4274: wsh_delivery_assignments_v wda
4275: WHERE
4276: wdd.delivery_detail_id = wda.delivery_detail_id AND
4277: wda.delivery_id = v_del_id AND

Line 4286: wsh_delivery_details wdd,

4282: cursor c_get_shipped_dds(p_shipment_header_id NUMBER) IS
4283: SELECT
4284: wdd.delivery_detail_id, nvl(wdd.container_flag,'N') container_flag
4285: FROM
4286: wsh_delivery_details wdd,
4287: wsh_delivery_assignments_v wda,
4288: wsh_new_deliveries wnd
4289: WHERE
4290: wdd.delivery_detail_id = wda.delivery_detail_id AND

Line 4297: FROM wsh_delivery_details wdd1,

4293: wdd.released_status in ( 'C')
4294: and not exists
4295: (
4296: SELECT 1
4297: FROM wsh_delivery_details wdd1,
4298: wsh_delivery_assignments_v wda1
4299: WHERE wdd1.delivery_detail_id = wda1.delivery_detail_id
4300: AND wda1.delivery_id = wnd.delivery_id
4301: AND wdd1.released_status in ( 'L')

Line 4433: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.

4429: IF l_debug_on THEN
4430: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After delete LPN from WDA',SQL%ROWCOUNT);
4431: END IF;
4432:
4433: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
4434: FORALL i IN lpn_ids_tab.FIRST..lpn_ids_tab.LAST
4435: DELETE WSH_DELIVERY_DETAILS
4436: WHERE delivery_detail_id = lpn_ids_tab(i);
4437:

Line 4435: DELETE WSH_DELIVERY_DETAILS

4431: END IF;
4432:
4433: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
4434: FORALL i IN lpn_ids_tab.FIRST..lpn_ids_tab.LAST
4435: DELETE WSH_DELIVERY_DETAILS
4436: WHERE delivery_detail_id = lpn_ids_tab(i);
4437:
4438: IF l_debug_on THEN
4439: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After delete LPN from WDD',SQL%ROWCOUNT);

Line 4467: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS

4463: -- respective deliveries.
4464: IF dd_ids_tab.count > 0 THEN
4465: --{
4466: IF l_debug_on THEN
4467: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS
4468: _ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4469: END IF;
4470:
4471: l_unassign_action_prms := p_action_prms;

Line 4475: --Call API WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details.

4471: l_unassign_action_prms := p_action_prms;
4472: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4473: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4474:
4475: --Call API WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details.
4476: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4477: P_REC_OF_DETAIL_IDS => dd_ids_tab,
4478: P_FROM_delivery => 'Y',
4479: P_FROM_container => 'N',

Line 4476: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

4472: --l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
4473: l_unassign_action_prms.caller := wsh_util_core.C_IB_ASN_PREFIX;
4474:
4475: --Call API WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details.
4476: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4477: P_REC_OF_DETAIL_IDS => dd_ids_tab,
4478: P_FROM_delivery => 'Y',
4479: P_FROM_container => 'N',
4480: x_return_status => l_return_status,

Line 7026: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

7022:
7023: CURSOR lpn_csr(p_delivery_detail_id IN NUMBER)
7024: IS
7025: SELECT parent_delivery_detail_id, wdd.last_update_date
7026: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
7027: WHERE wda.delivery_detail_id = p_delivery_detail_id
7028: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id;
7029: --
7030: l_lpn_id NUMBER;