APPS.PO_AUTOSOURCE_SV dependencies on PO_REQ_DIST_INTERFACE

Line 4455: -- PO_REQ_DIST_INTERFACE.

4451: --Name: process_req_qty
4452: --Pre-reqs:
4453: -- None.
4454: --Modifies:
4455: -- PO_REQ_DIST_INTERFACE.
4456: --Locks:
4457: -- None.
4458: --Function:
4459: -- This procedure applies the order modifiers on the line level quantity

Line 4625: UPDATE PO_REQ_DIST_INTERFACE prdi

4621: IF ((p_multi_dist_flag = 'Y')
4622: AND (p_req_dist_sequence_id IS NOT NULL)
4623: AND ((l_temp_quantity <> x_quantity) OR p_uom_conversion_rate IS NOT NULL)) THEN
4624:
4625: UPDATE PO_REQ_DIST_INTERFACE prdi
4626: SET prdi.quantity = round((prdi.quantity *p_uom_conversion_rate)*
4627: (1 + (x_quantity - l_temp_quantity) / l_temp_quantity)
4628: , 18)
4629: WHERE prdi.dist_sequence_id = p_req_dist_sequence_id

Line 4674: UPDATE PO_REQ_DIST_INTERFACE prdi

4670: IF (p_multi_dist_flag = 'Y'
4671: AND (p_req_dist_sequence_id IS NOT NULL)
4672: AND (l_adjust is NOT NULL )) THEN
4673:
4674: UPDATE PO_REQ_DIST_INTERFACE prdi
4675: SET prdi.quantity = round((prdi.quantity + l_adjust), 18)
4676: WHERE prdi.request_id = p_request_id
4677: AND prdi.quantity is not null
4678: AND prdi.dist_sequence_id = p_req_dist_sequence_id

Line 4681: FROM PO_REQ_DIST_INTERFACE

4677: AND prdi.quantity is not null
4678: AND prdi.dist_sequence_id = p_req_dist_sequence_id
4679: AND distribution_number =
4680: (SELECT MAX(distribution_number)
4681: FROM PO_REQ_DIST_INTERFACE
4682: WHERE prdi.request_id = p_request_id
4683: AND prdi.dist_sequence_id = p_req_dist_sequence_id);
4684:
4685: END IF;