APPS.PO_AUTOSOURCE_SV dependencies on PO_REQ_DIST_INTERFACE

Line 4483: -- PO_REQ_DIST_INTERFACE.

4479: --Name: process_req_qty
4480: --Pre-reqs:
4481: -- None.
4482: --Modifies:
4483: -- PO_REQ_DIST_INTERFACE.
4484: --Locks:
4485: -- None.
4486: --Function:
4487: -- This procedure applies the order modifiers on the line level quantity

Line 4659: UPDATE PO_REQ_DIST_INTERFACE prdi

4655: IF ((p_multi_dist_flag = 'Y')
4656: AND (p_req_dist_sequence_id IS NOT NULL)
4657: AND ((l_temp_quantity <> x_quantity) OR p_uom_conversion_rate IS NOT NULL)) THEN
4658:
4659: UPDATE PO_REQ_DIST_INTERFACE prdi
4660: SET prdi.quantity = round((prdi.quantity *p_uom_conversion_rate)*
4661: (1 + (x_quantity - l_temp_quantity) / l_temp_quantity)
4662: , 18)
4663: WHERE prdi.dist_sequence_id = p_req_dist_sequence_id

Line 4712: UPDATE PO_REQ_DIST_INTERFACE prdi

4708: IF (p_multi_dist_flag = 'Y'
4709: AND (p_req_dist_sequence_id IS NOT NULL)
4710: AND (l_adjust is NOT NULL )) THEN
4711:
4712: UPDATE PO_REQ_DIST_INTERFACE prdi
4713: SET prdi.quantity = round((prdi.quantity + l_adjust), 18)
4714: WHERE prdi.request_id = p_request_id
4715: AND prdi.quantity is not null
4716: AND prdi.dist_sequence_id = p_req_dist_sequence_id

Line 4719: FROM PO_REQ_DIST_INTERFACE

4715: AND prdi.quantity is not null
4716: AND prdi.dist_sequence_id = p_req_dist_sequence_id
4717: AND distribution_number =
4718: (SELECT MAX(distribution_number)
4719: FROM PO_REQ_DIST_INTERFACE
4720: WHERE prdi.request_id = p_request_id
4721: AND prdi.dist_sequence_id = p_req_dist_sequence_id);
4722:
4723: END IF;