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

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

174: --
175: IF l_dd_id_unassigned.count > 0 then
176: --Call GRP API to unassign the dd from delivery
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
179: END IF;
180:
181: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
182:

Line 183: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(

179: END IF;
180:
181: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
182:
183: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
184: p_rec_of_detail_ids => l_dd_id_unassigned,
185: p_from_delivery => 'Y',
186: p_from_container => 'N',
187: x_return_status => l_return_status,

Line 306: -- wsh_delivery_details when PO goes for reapproval.

302: -- API name : Update_Attributes
303: -- Type : Public
304: -- Pre-reqs : None.
305: -- Function : This API update all the non-quantity attributes in
306: -- wsh_delivery_details when PO goes for reapproval.
307: -- This API internally calls Update_dd_attribues API which does the
308: -- actual update on wsh_delivery_details.
309: -- In case of PO Reapproval scenario, the p_dd_list will
310: -- be just defined, but will not have any data in it.

Line 308: -- actual update on wsh_delivery_details.

304: -- Pre-reqs : None.
305: -- Function : This API update all the non-quantity attributes in
306: -- wsh_delivery_details when PO goes for reapproval.
307: -- This API internally calls Update_dd_attribues API which does the
308: -- actual update on wsh_delivery_details.
309: -- In case of PO Reapproval scenario, the p_dd_list will
310: -- be just defined, but will not have any data in it.
311: -- In case of ASN Cancellation or Reverting the Matching
312: -- Transactions, the p_dd_list will have the set of

Line 466: -- Once p_line_rec is derived, call update_dd_attributes to update wsh_delivery_details.

462:
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Update_dd_attributes',WSH_DEBUG_SV.C_PROC_LEVEL);
465: END IF;
466: -- Once p_line_rec is derived, call update_dd_attributes to update wsh_delivery_details.
467:
468: Update_dd_attributes(
469: p_line_rec => p_line_rec,
470: p_action_prms => p_action_prms,

Line 648: WSH_DELIVERY_DETAILS WDD,

644: WDD.earliest_dropoff_date edd,
645: WDD.latest_dropoff_date ldd,
646: WDD.last_update_Date
647: FROM
648: WSH_DELIVERY_DETAILS WDD,
649: wsh_delivery_assignments_v WDA,
650: WSH_NEW_DELIVERIES WND
651: WHERE
652: WDD.Delivery_Detail_id = WDA.Delivery_Detail_id AND

Line 662: -- from wsh_delivery_details which is later used to check if any on the non-quantity attributes

658: WDD.source_line_id = p_line_id AND
659: WDD.delivery_detail_id = NVL(p_delivery_detail_id, WDD.DELIVERY_DETAIL_ID);
660:
661: -- Cursor to fetch all the attributes corresponding to the line location id, line id and header id
662: -- from wsh_delivery_details which is later used to check if any on the non-quantity attributes
663: -- have changed before doing the update on wdd.
664:
665: Cursor c_dd_info(p_line_location_id NUMBER, p_delivery_detail_id NUMBER,
666: p_header_id NUMBER,p_line_id NUMBER)

Line 669: -- select * from wsh_delivery_details

665: Cursor c_dd_info(p_line_location_id NUMBER, p_delivery_detail_id NUMBER,
666: p_header_id NUMBER,p_line_id NUMBER)
667: IS
668: -- Changed for Bug# 3330869
669: -- select * from wsh_delivery_details
670: SELECT
671: inventory_item_id,
672: delivery_detail_id,
673: source_header_id,

Line 726: FROM wsh_delivery_details

722: po_revision_number,
723: release_revision_number,
724: earliest_dropoff_date,
725: latest_dropoff_date
726: FROM wsh_delivery_details
727: WHERE source_code = 'PO'
728: AND po_shipment_line_id = p_line_location_id AND
729: source_header_id = p_header_id AND
730: source_line_id = p_line_id AND

Line 1012: update wsh_delivery_details

1008: x_num_warnings => l_num_warnings,
1009: x_num_errors => l_num_errors);
1010:
1011: END IF;
1012: update wsh_delivery_details
1013: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1014: last_update_date = SYSDATE,
1015: last_updated_by = FND_GLOBAL.USER_ID,
1016: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1042: -- it is directly updated to wsh_delivery_details without checking for any contions

1038:
1039: END IF;
1040: ELSE
1041: -- If shipping control is changed from 'Supplier' to 'Buyer' on the PO, then
1042: -- it is directly updated to wsh_delivery_details without checking for any contions
1043: -- other than line status which should be 'X'(OPEN).
1044:
1045: update wsh_delivery_details
1046: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),

Line 1045: update wsh_delivery_details

1041: -- If shipping control is changed from 'Supplier' to 'Buyer' on the PO, then
1042: -- it is directly updated to wsh_delivery_details without checking for any contions
1043: -- other than line status which should be 'X'(OPEN).
1044:
1045: update wsh_delivery_details
1046: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1047: last_update_date = SYSDATE,
1048: last_updated_by = FND_GLOBAL.USER_ID,
1049: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1446: UPDATE WSH_DELIVERY_DETAILS

1442: -- Only if any of the non-quantity attribtues are changed in the PO, the delivery details
1443: -- is updated.
1444: -- If only quantity is changed, then this is taken care in Update_quantity API.
1445:
1446: UPDATE WSH_DELIVERY_DETAILS
1447: SET
1448: source_header_id = p_line_rec.header_id(p_line_rec_index),
1449: source_blanket_reference_id=p_line_rec.source_blanket_reference_id(p_line_rec_index),
1450: source_line_id=p_line_rec.line_id(p_line_rec_index),

Line 1713: -- WSH_DELIVERY_DETAILS table.

1709: -- For every Line_location_id passed by PO, check the total
1710: -- source quantity against the passed quantity.
1711: -- - If no records found for the line_location_id, it is a
1712: -- case of new record to be inserted in the
1713: -- WSH_DELIVERY_DETAILS table.
1714: -- - If records are found, then check if it a case of
1715: -- Incrementing the quantity or decrementing the quantity.
1716: -- - If the case is INCREMENT, then the additional qty is updated on to
1717: -- the open delivery detail.If no open delivery detail is found, then

Line 1718: -- a new record is inserted into wsh_delivery_details for the

1714: -- - If records are found, then check if it a case of
1715: -- Incrementing the quantity or decrementing the quantity.
1716: -- - If the case is INCREMENT, then the additional qty is updated on to
1717: -- the open delivery detail.If no open delivery detail is found, then
1718: -- a new record is inserted into wsh_delivery_details for the
1719: -- additional quantity.
1720: -- - In case of DECREMENT in the qty, the changes are first applied to
1721: -- lines with null routing request id.
1722: -- If no such lines are found, then the changes are applied to line

Line 1775: from WSH_DELIVERY_DETAILS

1771: --HACMS {
1772: requested_quantity_uom,
1773: inventory_item_id
1774: --HACMS }
1775: from WSH_DELIVERY_DETAILS
1776: where po_shipment_line_id = p_line_location_id and
1777: source_code = 'PO' AND
1778: source_header_id = p_header_id AND
1779: source_line_id = p_line_id AND

Line 1786: FROM wsh_delivery_details

1782: --Cursor to get the count of lines with null routing request id in wdd.
1783:
1784: Cursor c_dd_count_with_null_rr(p_line_location_id NUMBER,p_header_id NUMBER,p_line_id NUMBER) is
1785: SELECT count(*)
1786: FROM wsh_delivery_details
1787: WHERE released_status = 'X' and
1788: source_code = 'PO' AND
1789: source_header_id = p_header_id AND
1790: source_line_id = p_line_id AND

Line 1806: from WSH_DELIVERY_DETAILS

1802: requested_quantity_uom ,
1803: inventory_item_id,
1804: --HACMS }
1805: last_update_date
1806: from WSH_DELIVERY_DETAILS
1807: where released_status = 'X' and
1808: source_code = 'PO' AND
1809: source_header_id = p_header_id AND
1810: source_line_id = p_line_id AND

Line 1828: wsh_delivery_details

1824: requested_quantity_uom qty_uom,
1825: inventory_item_id,
1826: last_update_date
1827: from
1828: wsh_delivery_details
1829: where released_status = 'X' and
1830: source_code = 'PO' AND
1831: source_header_id = p_header_id AND
1832: source_line_id = p_line_id AND

Line 1848: wsh_delivery_details

1844: requested_quantity_uom qty_uom,
1845: last_update_date
1846: --HACMS }
1847: from
1848: wsh_delivery_details
1849: where released_status = 'X' and
1850: source_code = 'PO' AND
1851: source_header_id = p_header_id AND
1852: source_line_id = p_line_id AND

Line 1879: wsh_delivery_details wdd,

1875: wnd.ultimate_dropoff_location_id del_location,
1876: --HACMS }
1877: wdd.last_update_date
1878: from
1879: wsh_delivery_details wdd,
1880: wsh_delivery_assignments_v wda,
1881: wsh_new_deliveries wnd
1882: where wdd.released_status = 'X' and
1883: WDD.source_code = 'PO' AND

Line 1897: FROM wsh_delivery_details

1893: -- belonging to the same po line location id.
1894:
1895: CURSOR c_ship_from_count(p_line_location_id NUMBER,p_header_id NUMBER,p_line_id NUMBER) is
1896: SELECT count(distinct(ship_from_location_id))
1897: FROM wsh_delivery_details
1898: WHERE released_status = 'X' and
1899: source_code = 'PO' AND
1900: source_header_id = p_header_id AND
1901: source_line_id = p_line_id AND

Line 2334: Update wsh_delivery_details

2330: x_num_errors => l_num_errors);
2331:
2332: END IF;
2333:
2334: Update wsh_delivery_details
2335: set
2336: requested_quantity = l_requested_qty,
2337: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom), --HACMS
2338: cancelled_quantity = nvl(cancelled_quantity,0) + nvl(l_cancelled_qty,0), --HACMS

Line 2358: WSH_DEBUG_SV.log(l_module_name,'Line Updated in wsh_delivery_details',sql%rowcount);

2354: last_update_date = v_lines_without_rr.last_update_date;
2355:
2356:
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.log(l_module_name,'Line Updated in wsh_delivery_details',sql%rowcount);
2359: END IF;
2360:
2361: IF SQL%ROWCOUNT <> 1 THEN
2362: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_CHANGED');

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

2365: END IF;
2366:
2367: --
2368: -- DBI Project
2369: -- Update of wsh_delivery_details where requested_quantity/released_status
2370: -- are changed, call DBI API after the update.
2371: -- This API will also check for DBI Installed or not
2372: IF l_debug_on THEN
2373: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',v_lines_without_rr.delivery_detail_id);

Line 2640: Update wsh_delivery_details

2636:
2637: END IF;
2638: --HACMS }
2639:
2640: Update wsh_delivery_details
2641: set
2642: requested_quantity = l_requested_qty,
2643: --HACMS {
2644: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom),

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

2675: END IF;
2676:
2677: --
2678: -- DBI Project
2679: -- Update of wsh_delivery_details where requested_quantity/released_status
2680: -- are changed, call DBI API after the update.
2681: -- This API will also check for DBI Installed or not
2682: IF l_debug_on THEN
2683: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',v_lines_with_rr.delivery_detail_id);

Line 2886: UPDATE WSH_DELIVERY_DETAILS

2882: END IF;
2883: END IF;
2884: --HACMS }
2885:
2886: UPDATE WSH_DELIVERY_DETAILS
2887: SET
2888: requested_quantity = l_requested_qty + l_qty_to_change,
2889: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom), --HACMS
2890: last_update_date = SYSDATE,

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

2913: l_update_flag := TRUE;
2914:
2915: --
2916: -- DBI Project
2917: -- Update of wsh_delivery_details where requested_quantity/released_status
2918: -- are changed, call DBI API after the update.
2919: -- This API will also check for DBI Installed or not
2920: IF l_debug_on THEN
2921: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_delivery_detail_id);

Line 3083: -- Call WSH_BULK_PROCESS_PVT.bulk_insert_details() to insert the record into wsh_delivery_details.

3079: IF l_debug_on THEN
3080: WSH_DEBUG_SV.log(l_module_name,' l_action_prms.org_id', l_action_prms.org_id);
3081: END IF;
3082: --
3083: -- Call WSH_BULK_PROCESS_PVT.bulk_insert_details() to insert the record into wsh_delivery_details.
3084: WSH_BULK_PROCESS_PVT.bulk_insert_details (
3085: P_line_rec => P_line_rec,
3086: p_index => i,
3087: p_action_prms => l_action_prms,

Line 3155: Update wsh_delivery_details

3151: x_num_errors => l_num_errors);
3152:
3153: END IF;
3154:
3155: Update wsh_delivery_details
3156: set requested_quantity = l_qty_to_change,
3157: requested_quantity_uom = p_line_rec.requested_quantity_uom(i),
3158: picked_quantity = decode(l_pick_qty,null,picked_quantity,l_pick_qty) ,
3159: last_update_date = SYSDATE,

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

3178: RAISE FND_API.G_EXC_ERROR;
3179: END IF;
3180: --
3181: -- DBI Project
3182: -- Update of wsh_delivery_details where requested_quantity/released_status
3183: -- are changed, call DBI API after the update.
3184: -- This API will also check for DBI Installed or not
3185: IF l_debug_on THEN
3186: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',v_lines.delivery_detail_id);

Line 3225: Update wsh_delivery_details

3221: OR l_update_flag --- increment from asn/receipt
3222: THEN
3223: FORALL i in 1..p_line_rec.po_shipment_line_id.COUNT
3224:
3225: Update wsh_delivery_details
3226: Set src_requested_quantity = nvl(p_line_rec.ordered_quantity(i),src_requested_quantity),
3227: src_requested_quantity_uom = nvl(p_line_rec.order_quantity_uom(i),src_requested_quantity_uom),
3228: --HACMS
3229: -- HW OPMCONV - No need to use OPM precision. Use current INV which is 5

Line 3402: wsh_delivery_details wdd,

3398: wdd.requested_quantity2,
3399: wda.delivery_id,
3400: wdd.last_update_date
3401: FROM
3402: wsh_delivery_details wdd,
3403: wsh_delivery_assignments_v wda
3404: WHERE
3405: wdd.source_header_id = NVL(p_header_id,wdd.source_header_id) AND
3406: wdd.delivery_detail_id = wda.delivery_detail_id AND

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

3520: --
3521: -- Debug Statements
3522: --
3523: IF l_debug_on THEN
3524: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
3525: END IF;
3526:
3527: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
3528:

Line 3529: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(

3525: END IF;
3526:
3527: l_action_prms.caller := wsh_util_core.C_IB_PO_PREFIX;
3528:
3529: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
3530: p_rec_of_detail_ids => dd_ids_tab_for_unassign,
3531: p_from_delivery => 'Y',
3532: p_from_container => 'N',
3533: x_return_status => l_return_status,

Line 3552: wsh_delivery_details

3548: IF p_action_prms.action_code = 'CANCEL_PO' THEN
3549: --update the status of the selected lines to 'D' (Cancel).
3550: FORALL i IN dd_ids_tab.FIRST..dd_ids_tab.LAST
3551: UPDATE
3552: wsh_delivery_details
3553: SET
3554: requested_quantity = 0,
3555: requested_quantity2 = 0,
3556: cancelled_quantity = req_qty_tab(i),

Line 3572: UPDATE wsh_delivery_details

3568: --update the status of the selected lines to 'L' (Close).
3569: p_action_prms.action_code = 'FINAL_CLOSE' OR
3570: p_action_prms.action_code = 'CLOSE_PO_FOR_RECEIVING' THEN
3571: FORALL i IN dd_ids_tab.FIRST..dd_ids_tab.LAST
3572: UPDATE wsh_delivery_details
3573: SET released_status = 'L',
3574: last_update_date = SYSDATE,
3575: last_updated_by = FND_GLOBAL.USER_ID,
3576: last_update_login = FND_GLOBAL.LOGIN_ID

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

3581: END IF;
3582: --
3583: -- Above 2 update conditions would populate the table of ids for DBI
3584: -- DBI Project
3585: -- Update of wsh_delivery_details where requested_quantity/released_status
3586: -- are changed, call DBI API after the update.
3587: -- DBI API will check if DBI is installed
3588: IF l_debug_on THEN
3589: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 3731: UPDATE wsh_delivery_details

3727:
3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3729:
3730: FORALL i IN p_line_rec.header_id.FIRST..p_line_rec.header_id.LAST
3731: UPDATE wsh_delivery_details
3732: SET released_status = 'X'
3733: WHERE
3734: released_status = 'L' AND
3735: received_quantity IS NULL AND

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

3744: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project
3745:
3746: --
3747: -- DBI Project
3748: -- Update of wsh_delivery_details where requested_quantity/released_status
3749: -- are changed, call DBI API after the update.
3750: -- DBI API will check if DBI is installed
3751: IF l_debug_on THEN
3752: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 4255: -- into wsh_delivery_details, the Bulk_insert API can me made use

4251: -- Type : Private
4252: -- Pre-reqs : None.
4253: -- Function : This API is used to populate the p_additional_line_info record
4254: -- structure.Once this record structure is populated, during insert
4255: -- into wsh_delivery_details, the Bulk_insert API can me made use
4256: -- of .
4257: -- Parameters :
4258: -- IN OUT:
4259: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type DEFAULT NULL

Line 4331: (p_flexfield_name => 'WSH_DELIVERY_DETAILS',

4327: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FLEXFIELD_UTILS.GET_DFF_DEFAULTS',WSH_DEBUG_SV.C_PROC_LEVEL);
4328: END IF;
4329: --
4330: WSH_FLEXFIELD_UTILS.Get_DFF_Defaults
4331: (p_flexfield_name => 'WSH_DELIVERY_DETAILS',
4332: p_default_values => l_dff_attribute,
4333: p_default_context => l_dff_context,
4334: p_update_flag => l_dff_update_flag,
4335: x_return_status => l_return_status);