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_RCV_CORR_RTV_TXN_PKG dependencies on WSH_DELIVERY_DETAILS

Line 37: -- wsh_delivery_details after processing

33: -- p_matched_detail_index Index of x_matched_detail_rec on
34: -- which we need to process
35: -- the corrections.
36: -- x_update_det_rec Record that we finally use to update
37: -- wsh_delivery_details after processing
38: -- the corrections.
39: -- p_update_det_rec_idx Index of x_update_det_rec on
40: -- which we need to process
41: -- the corrections.

Line 68: -- is finally used to perform a bulk update on wsh_delivery_details

64:
65: -- COMMENT : This procedure is used to mainly assign the updated received
66: -- quantities from x_matched_detail_rec for each delivery detail
67: -- to x_update_det_rec correspondingly as this x_update_det_rec
68: -- is finally used to perform a bulk update on wsh_delivery_details
69: -- in the procedure process_corrections_and_rtv.
70: --
71: --========================================================================
72:

Line 127: from wsh_delivery_details

123: select gross_weight,
124: net_weight,
125: volume,
126: NVL(wv_frozen_flag,'Y') wv_frozen_flag
127: from wsh_delivery_details
128: where delivery_detail_id = p_delivery_detail_id;
129:
130: l_qty_ratio NUMBER;
131: l_det_gr_weight NUMBER;

Line 511: -- wsh_delivery_details after processing

507: -- p_matched_detail_index Index of x_matched_detail_rec on
508: -- which we need to process
509: -- the rtv quantities.
510: -- x_update_det_rec Record that we finally use to update
511: -- wsh_delivery_details after processing
512: -- the rtv quantities.
513: -- p_update_det_rec_idx Index of x_update_det_rec on
514: -- which we need to process
515: -- the rtv quantities.

Line 524: -- is finally used to perform a bulk update on wsh_delivery_details

520:
521: -- COMMENT : This procedure is used to mainly assign the updated returned
522: -- quantities from x_matched_detail_rec for each delivery detail
523: -- to x_update_det_rec correspondingly as this x_update_det_rec
524: -- is finally used to perform a bulk update on wsh_delivery_details
525: -- in the procedure process_corrections_and_rtv.
526: --
527: --========================================================================
528:

Line 704: -- 3. Then we perform a bulk update on wsh_delivery_details

700: -- until there is a change in the po_line_location_id and then
701: -- if this quantity <> 0 for the corresponding
702: -- po_line_location_id, then we call the procedure
703: -- Process_remaining_req_quantity.
704: -- 3. Then we perform a bulk update on wsh_delivery_details
705: -- to update the new received and returned quantities
706: -- 4. If there are any delivery details for which there was
707: -- a complete receipt correction (i.e. received quantity
708: -- becomes null or zero), then we call

Line 709: -- WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details

705: -- to update the new received and returned quantities
706: -- 4. If there are any delivery details for which there was
707: -- a complete receipt correction (i.e. received quantity
708: -- becomes null or zero), then we call
709: -- WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details
710: -- to unassign those lines from the delivery.
711: -- 5. If there were any lines for which there was a receipt
712: -- correction, we call WSH_WV_UTILS.Detail_Weight_Volume
713: -- to re-calculate the wt-vol of the lines.

Line 771: wsh_delivery_details wdd1,

767: -- This is not used any more. Was added in the beginning.
768: cursor l_del_det_fob_chk_csr(p_delivery_id NUMBER) is
769: select 'N'
770: from wsh_delivery_assignments_v wda,
771: wsh_delivery_details wdd1,
772: wsh_delivery_details wdd2
773: where wda.delivery_id = p_delivery_id
774: and wda.delivery_detail_id = wdd1.delivery_detail_id
775: and wda.delivery_detail_id = wdd2.delivery_detail_id

Line 772: wsh_delivery_details wdd2

768: cursor l_del_det_fob_chk_csr(p_delivery_id NUMBER) is
769: select 'N'
770: from wsh_delivery_assignments_v wda,
771: wsh_delivery_details wdd1,
772: wsh_delivery_details wdd2
773: where wda.delivery_id = p_delivery_id
774: and wda.delivery_detail_id = wdd1.delivery_detail_id
775: and wda.delivery_detail_id = wdd2.delivery_detail_id
776: and (wdd1.fob_code is null

Line 785: wsh_delivery_details wdd1,

781: -- This is not used any more. Was added in the beginning.
782: cursor l_del_det_fr_terms_chk_csr(p_delivery_id NUMBER) is
783: select 'N'
784: from wsh_delivery_assignments_v wda,
785: wsh_delivery_details wdd1,
786: wsh_delivery_details wdd2
787: where wda.delivery_id = p_delivery_id
788: and wda.delivery_detail_id = wdd1.delivery_detail_id
789: and wda.delivery_detail_id = wdd2.delivery_detail_id

Line 786: wsh_delivery_details wdd2

782: cursor l_del_det_fr_terms_chk_csr(p_delivery_id NUMBER) is
783: select 'N'
784: from wsh_delivery_assignments_v wda,
785: wsh_delivery_details wdd1,
786: wsh_delivery_details wdd2
787: where wda.delivery_id = p_delivery_id
788: and wda.delivery_detail_id = wdd1.delivery_detail_id
789: and wda.delivery_detail_id = wdd2.delivery_detail_id
790: and (wdd1.freight_terms_code is null

Line 799: wsh_delivery_details wdd

795: -- This is not used any more. Was added in the beginning.
796: cursor l_del_det_fr_term_fob_csr (p_delivery_id NUMBER) is
797: select wdd.freight_terms_code, wdd.fob_code
798: from wsh_delivery_assignments_v wda,
799: wsh_delivery_details wdd
800: where wda.delivery_id = p_delivery_id
801: and wda.delivery_detail_id = wdd.delivery_detail_id
802: and rownum =1;
803:

Line 1073: update wsh_delivery_details

1069: WSH_DEBUG_SV.log(l_module_name,'gross_weight_tab', l_update_det_rec.gross_weight_tab(1));
1070: WSH_DEBUG_SV.log(l_module_name,'volume_tab', l_update_det_rec.volume_tab(1));
1071: END IF;
1072: forall i in l_update_det_rec.del_det_id_tab.first..l_update_det_rec.del_det_id_tab.last
1073: update wsh_delivery_details
1074: set requested_quantity = l_update_det_rec.requested_qty_tab(i),
1075: requested_quantity2 = l_update_det_rec.requested_qty2_tab(i),
1076: shipped_quantity = l_update_det_rec.shipped_qty_tab(i),
1077: shipped_quantity2 = l_update_det_rec.shipped_qty2_tab(i),

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

1108: END IF;
1109:
1110: --
1111: -- DBI Project
1112: -- Update of wsh_delivery_details where requested_quantity/released_status
1113: -- are changed, call DBI API after the update.
1114: -- DBI API will check if DBI is installed
1115: IF l_debug_on THEN
1116: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_update_det_rec.del_det_id_tab.count);

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

1147: --
1148: -- Debug Statements
1149: --
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1152: END IF;
1153: --
1154: l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
1155: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

Line 1155: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

1151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1152: END IF;
1153: --
1154: l_unassign_action_prms.caller := wsh_util_core.C_IB_RECEIPT_PREFIX;
1155: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
1156: P_REC_OF_DETAIL_IDS => l_unassign_det_tbl,
1157: P_FROM_delivery => 'Y',
1158: P_FROM_container => 'N',
1159: x_return_status => l_return_status,

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

1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDA',SQL%ROWCOUNT);
1208: END IF;
1209:
1210: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
1211: FORALL i IN l_delete_lpn_id_tab.FIRST..l_delete_lpn_id_tab.LAST
1212: DELETE WSH_DELIVERY_DETAILS
1213: WHERE delivery_detail_id = l_delete_lpn_id_tab(i);
1214:

Line 1212: DELETE WSH_DELIVERY_DETAILS

1208: END IF;
1209:
1210: --Deleting the rows in WSH_DELIVERY_DETAILS corresponding to the selected LPNs.
1211: FORALL i IN l_delete_lpn_id_tab.FIRST..l_delete_lpn_id_tab.LAST
1212: DELETE WSH_DELIVERY_DETAILS
1213: WHERE delivery_detail_id = l_delete_lpn_id_tab(i);
1214:
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDD',SQL%ROWCOUNT);

Line 1668: from wsh_delivery_details

1664: p_source_line_id IN NUMBER) is
1665: select delivery_detail_id,
1666: requested_quantity,
1667: requested_quantity2
1668: from wsh_delivery_details
1669: where source_line_id = p_source_line_id
1670: and po_shipment_line_id = p_po_line_loc_id
1671: and released_status = 'X'
1672: and routing_req_id is null

Line 1684: from wsh_delivery_details

1680: p_source_line_id IN NUMBER) is
1681: select delivery_detail_id,
1682: requested_quantity,
1683: requested_quantity2
1684: from wsh_delivery_details
1685: where source_line_id = p_source_line_id
1686: and po_shipment_line_id = p_po_line_loc_id
1687: and ( released_status = 'X'
1688: or

Line 1701: -- This cursor is used to just get the uom stored on wsh_delivery_details

1697: 'X',1,
1698: 'L',2);
1699: --for update of requested_quantity nowait;
1700:
1701: -- This cursor is used to just get the uom stored on wsh_delivery_details
1702: -- This is not used anymore as the input record structure already has the UOMs
1703: -- passed.
1704: cursor l_del_det_uom_csr(p_po_line_loc_id NUMBER,
1705: p_source_line_id IN NUMBER) is

Line 1707: from wsh_delivery_details

1703: -- passed.
1704: cursor l_del_det_uom_csr(p_po_line_loc_id NUMBER,
1705: p_source_line_id IN NUMBER) is
1706: select requested_quantity_uom
1707: from wsh_delivery_details
1708: where source_line_id = p_source_line_id
1709: and source_code = 'PO'
1710: and po_shipment_line_id = p_po_line_loc_id;
1711:

Line 1725: from wsh_delivery_details

1721: select delivery_detail_id,
1722: requested_quantity,
1723: requested_quantity2,
1724: 'N' record_changed_flag
1725: from wsh_delivery_details
1726: where source_line_id = p_source_line_id
1727: and po_shipment_line_id = p_po_line_loc_id
1728: and released_status in ('X', 'C', 'L')
1729: and source_code = 'PO'

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

1907: --
1908: -- Debug Statements
1909: --
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1912: END IF;
1913: --
1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));

Line 1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(

1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1912: END IF;
1913: --
1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));
1916:
1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

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

1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));
1916:
1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1919: END IF;
1920:
1921: wsh_delivery_details_pkg.delete_delivery_details(
1922: p_delivery_detail_id => l_update_rec.del_det_id_tab(i),

Line 1921: wsh_delivery_details_pkg.delete_delivery_details(

1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1919: END IF;
1920:
1921: wsh_delivery_details_pkg.delete_delivery_details(
1922: p_delivery_detail_id => l_update_rec.del_det_id_tab(i),
1923: x_return_status => l_return_status);
1924: --
1925: -- Debug Statements

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

1969:
1970: IF l_update_del_det_id IS NOT NULL THEN
1971: --{
1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --
1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1977: p_delivery_detail_id => l_update_del_det_id);

Line 1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(

1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --
1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1977: p_delivery_detail_id => l_update_del_det_id);
1978: -- we need to update atmost one record.
1979: update wsh_delivery_details
1980: set requested_quantity = l_update_del_det_req_qty,

Line 1979: update wsh_delivery_details

1975: --
1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1977: p_delivery_detail_id => l_update_del_det_id);
1978: -- we need to update atmost one record.
1979: update wsh_delivery_details
1980: set requested_quantity = l_update_del_det_req_qty,
1981: requested_quantity2 = nvl(l_update_del_det_req_qty2,requested_quantity2),
1982: last_update_date = sysdate,
1983: last_updated_by = fnd_global.user_id,

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

1990: l_update_del_det_id_tab(1) := l_update_del_det_id;
1991:
1992: --
1993: -- DBI Project
1994: -- Update of wsh_delivery_details where requested_quantity/released_status
1995: -- are changed, call DBI API after the update.
1996: -- DBI API will check if DBI is installed
1997: IF l_debug_on THEN
1998: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-', l_update_del_det_id_tab.count);

Line 2146: update wsh_delivery_details

2142: --{
2143: --
2144: --
2145: FORALL i IN l_update_rec.del_det_id_tab.FIRST..l_update_rec.del_det_id_tab.LAST
2146: update wsh_delivery_details
2147: set requested_quantity = l_update_rec.requested_qty_tab(i),
2148: requested_quantity2 = l_update_rec.requested_qty2_tab(i),
2149: last_update_date = sysdate,
2150: last_updated_by = fnd_global.user_id,

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

2158: WSH_DEBUG_SV.log(l_module_name,'Number of Records updated', SQL%ROWCOUNT);
2159: END IF;
2160: --
2161: -- DBI Project
2162: -- Update of wsh_delivery_details where requested_quantity/released_status
2163: -- are changed, call DBI API after the update.
2164: -- DBI API will check if DBI is installed
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-', l_update_rec.del_det_id_tab.count);