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

Line 2666: -- Procedure : API to create Purchase Order line in wsh_delivery_details.Api does.

2662: -- Start of comments
2663: -- API name : Create_PO
2664: -- Type : Private
2665: -- Pre-reqs : None.
2666: -- Procedure : API to create Purchase Order line in wsh_delivery_details.Api does.
2667: -- 1.Get the attributes of PO line from Purchase Order.
2668: -- 2.Populate additional line information.
2669: -- 3.Create the PO line in wsh_delivery_details.
2670: --

Line 2669: -- 3.Create the PO line in wsh_delivery_details.

2665: -- Pre-reqs : None.
2666: -- Procedure : API to create Purchase Order line in wsh_delivery_details.Api does.
2667: -- 1.Get the attributes of PO line from Purchase Order.
2668: -- 2.Populate additional line information.
2669: -- 3.Create the PO line in wsh_delivery_details.
2670: --
2671: -- Parameters :
2672: -- IN:
2673: -- p_po_line_location_id IN PO Line location Id.

Line 2771: --Create the PO line in wsh_delivery_details.

2767: l_line_rec.request_date(l_index):=p_detail_att.date_requested;
2768: l_additional_line_info_rec.earliest_dropoff_date(l_index):=p_detail_att.earliest_dropoff_date;
2769: l_additional_line_info_rec.latest_dropoff_date(l_index):=p_detail_att.latest_dropoff_date;
2770:
2771: --Create the PO line in wsh_delivery_details.
2772: WSH_BULK_PROCESS_PVT.bulk_insert_details (
2773: P_line_rec => l_line_rec,
2774: p_index => l_index,
2775: p_action_prms => l_action_prms,

Line 3797: UPDATE wsh_delivery_details

3793: WSH_DEBUG_SV.log(l_module_name,'l_latest_pickup_date',l_latest_pickup_date);
3794: END IF;
3795:
3796: --Update the first line of p_detail_att
3797: UPDATE wsh_delivery_details
3798: SET requested_quantity = p_detail_att.requested_quantity,
3799: requested_quantity2 = decode(p_detail_att.requested_quantity2,0,NULL,p_detail_att.requested_quantity2),
3800: picked_quantity = l_picked_quantity,
3801: picked_quantity2 = l_picked_quantity2,

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

3818: x_new_detail_ids(x_new_detail_ids.count + 1) := l_first_detail_id;
3819:
3820: --
3821: -- DBI Project
3822: -- Update of wsh_delivery_details where requested_quantity/released_status
3823: -- are changed, call DBI API after the update.
3824: -- DBI API will check if DBI is installed
3825: IF l_debug_on THEN
3826: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',x_new_detail_ids.count);

Line 3872: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

3868: WSH_DEBUG_SV.log(l_module_name,'l_item_quantity2',l_item_quantity2);
3869: END IF;
3870:
3871: --Split the first detail line already updated with routing request attributes.
3872: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (
3873: p_from_detail_id => l_first_detail_id,
3874: p_req_quantity => l_item_quantity,
3875: p_req_quantity2 => l_item_quantity2,
3876: p_unassign_flag => 'Y',

Line 3893: UPDATE wsh_delivery_details

3889: x_num_warnings => l_num_warnings,
3890: x_num_errors => l_num_errors);
3891:
3892: --Update the new line create because of split, to nullify the update on original line.
3893: UPDATE wsh_delivery_details
3894: SET ship_from_location_id = -1,
3895: ignore_for_planning = 'Y',
3896: routing_req_id = null,
3897: picked_quantity = null,

Line 3908: UPDATE wsh_delivery_details

3904: END IF; --}
3905:
3906:
3907: --Update the first line with Weight/Volume attributes.
3908: UPDATE wsh_delivery_details
3909: SET net_weight = nvl(p_detail_att.weight,net_weight),
3910: gross_weight = nvl(p_detail_att.weight,gross_weight),
3911: weight_uom_code = nvl(p_detail_att.weight_uom,weight_uom_code),
3912: volume = nvl(p_detail_att.volume,volume),

Line 3932: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (

3928: IF l_debug_on THEN
3929: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_detail_ids(l_index));
3930: END IF;
3931:
3932: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (
3933: p_delivery_detail_id => p_detail_ids(l_index),
3934: x_return_status => l_return_status);
3935:
3936: IF l_debug_on THEN

Line 3998: -- 4.Un assign the detail lines by calling api WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details

3994: -- Procedure : API to Unassigned detail lines from delivery. Api does
3995: -- 1.Get the line status and delivery_id of all the detail lines for input routing request id.
3996: -- 2.If any one of line is not open then error out.
3997: -- 3.Unplan the delivery associate with the lines.
3998: -- 4.Un assign the detail lines by calling api WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details
3999: --
4000: -- Parameters :
4001: -- IN:
4002: -- p_routing_req_id IN Routing Request id

Line 4017: FROM wsh_delivery_details wdd,

4013:
4014: -- Select released_status and associated delivery for unplaning and un assigning.
4015: CURSOR unassign_del_csr IS
4016: SELECT wdd.delivery_detail_id,wdd.released_status,wda.delivery_id
4017: FROM wsh_delivery_details wdd,
4018: wsh_delivery_assignments_v wda
4019: WHERE routing_req_id = p_routing_req_id
4020: AND wdd.delivery_detail_id = wda.delivery_detail_id
4021: ORDER BY wda.delivery_id;

Line 4088: --Call WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details with caller 'WSH_IP' for un assiginig details.

4084: END IF;
4085:
4086:
4087: l_action_prms.caller:='WSH_IB';
4088: --Call WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details with caller 'WSH_IP' for un assiginig details.
4089: IF (l_detail_ids.count > 0 ) THEN
4090: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4091: p_rec_of_detail_ids => l_detail_ids,
4092: p_from_delivery => 'Y',

Line 4090: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(

4086:
4087: l_action_prms.caller:='WSH_IB';
4088: --Call WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details with caller 'WSH_IP' for un assiginig details.
4089: IF (l_detail_ids.count > 0 ) THEN
4090: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details(
4091: p_rec_of_detail_ids => l_detail_ids,
4092: p_from_delivery => 'Y',
4093: p_from_container => 'N',
4094: p_action_prms => l_action_prms,

Line 4204: FROM wsh_delivery_details wdd,

4200: wdd.source_line_number,
4201: wdd.po_shipment_line_number,
4202: wdd.source_blanket_reference_num,
4203: wda.delivery_id
4204: FROM wsh_delivery_details wdd,
4205: wsh_delivery_assignments_v wda
4206: WHERE wdd.delivery_detail_id = p_detail_id
4207: AND wdd.delivery_detail_id = wda.delivery_detail_id;
4208:

Line 4873: FROM wsh_delivery_details

4869: date_requested,
4870: earliest_dropoff_date,
4871: latest_dropoff_date,
4872: shipping_control
4873: FROM wsh_delivery_details
4874: WHERE org_id=p_org_id
4875: AND source_header_number = p_po_header_number
4876: AND source_line_number = p_po_line_number
4877: AND po_shipment_line_number = p_po_shipment_number

Line 4911: FROM wsh_delivery_details

4907: nvl(net_weight,0) net_weight,
4908: nvl(gross_weight,0) gross_weight,
4909: nvl(volume,0) volume,
4910: wv_frozen_flag
4911: FROM wsh_delivery_details
4912: WHERE org_id=p_org_id
4913: AND source_header_number = p_po_header_number
4914: AND source_line_number = p_po_line_number
4915: AND po_shipment_line_number = p_po_shipment_number

Line 5367: --Collect the line attributes for creating new line in wsh_delivery_details.

5363: p_return_status => l_return_status,
5364: x_num_warnings => l_num_warnings,
5365: x_num_errors => l_num_errors);
5366:
5367: --Collect the line attributes for creating new line in wsh_delivery_details.
5368: l_detail_att.source_header_number := p_line.po_header_number(l_line_index);
5369: l_detail_att.inventory_item_id := l_po_not_found_detail.inventory_item_id;
5370: l_detail_att.requested_quantity_uom := l_po_not_found_detail.requested_quantity_uom;
5371: l_detail_att.requested_quantity_uom2 := l_po_not_found_detail.requested_quantity_uom2;