[Home] [Help]
85: END ap_update_po_distributions;
86:
87:
88:
89: PROCEDURE ap_update_po_line_locations( X_po_line_location_id IN NUMBER,
90: X_quantity_billed IN NUMBER,
91: X_uom_lookup_code IN VARCHAR2,
92: X_amount_billed IN NUMBER,
93: X_matching_basis IN VARCHAR2) IS
109: INTO
110: X_po_uom,
111: X_item_id
112: FROM
113: po_line_locations ll,
114: po_lines pl
115: WHERE
116: ll.line_location_id = X_po_line_location_id AND
117: pl.po_line_id = ll.po_line_id;
133: END IF;
134:
135: X_progress := '003';
136:
137: /* Update PO_LINE_LOCATIONS */
138: --Bug#2602981. Changed the X_po_quantity_billed to round(X_po_quantity_billed,15)
139:
140: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
141: ** Scheduled Release (SR) as well as the backing order (PPO)
141: ** Scheduled Release (SR) as well as the backing order (PPO)
142: ** should be updated.
143: */
144: --Bug 12886371. Added the updation of who columns
145: UPDATE po_line_locations_all pll
146: SET pll.quantity_billed = nvl(pll.quantity_billed,0) + X_po_quantity_billed,
147: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed,
148: pll.last_updated_by = fnd_global.user_id,
149: pll.last_update_date=sysdate,
150: pll.last_update_login=fnd_global.login_id
151: WHERE pll.line_location_id = X_po_line_location_id
152: OR ( pll.shipment_type = 'PLANNED'
153: AND pll.line_location_id = ( SELECT pll2.source_shipment_id
154: FROM po_line_locations pll2
155: WHERE pll2.shipment_type = 'SCHEDULED'
156: AND pll2.line_location_id = X_po_line_location_id)
157: );
158:
160:
161: EXCEPTION
162:
163: when others then
164: po_message_s.sql_error('ap_update_po_line_locations', X_progress, sqlcode);
165: raise;
166:
167: END ap_update_po_line_locations;
168:
163: when others then
164: po_message_s.sql_error('ap_update_po_line_locations', X_progress, sqlcode);
165: raise;
166:
167: END ap_update_po_line_locations;
168:
169:
170:
171: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,