APPS.RCV_BILL_UPDATING_SV dependencies on PO_LINE_LOCATIONS

Line 85: PROCEDURE ap_update_po_line_locations( X_po_line_location_id IN NUMBER,

81: END ap_update_po_distributions;
82:
83:
84:
85: PROCEDURE ap_update_po_line_locations( X_po_line_location_id IN NUMBER,
86: X_quantity_billed IN NUMBER,
87: X_uom_lookup_code IN VARCHAR2,
88: X_amount_billed IN NUMBER,
89: X_matching_basis IN VARCHAR2) IS

Line 109: po_line_locations ll,

105: INTO
106: X_po_uom,
107: X_item_id
108: FROM
109: po_line_locations ll,
110: po_lines pl
111: WHERE
112: ll.line_location_id = X_po_line_location_id AND
113: pl.po_line_id = ll.po_line_id;

Line 133: /* Update PO_LINE_LOCATIONS */

129: END IF;
130:
131: X_progress := '003';
132:
133: /* Update PO_LINE_LOCATIONS */
134: --Bug#2602981. Changed the X_po_quantity_billed to round(X_po_quantity_billed,15)
135:
136: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
137: ** Scheduled Release (SR) as well as the backing order (PPO)

Line 140: UPDATE po_line_locations_all pll

136: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
137: ** Scheduled Release (SR) as well as the backing order (PPO)
138: ** should be updated.
139: */
140: UPDATE po_line_locations_all pll
141: SET pll.quantity_billed = nvl(pll.quantity_billed,0) + X_po_quantity_billed,
142: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed
143: WHERE pll.line_location_id = X_po_line_location_id
144: OR ( pll.shipment_type = 'PLANNED'

Line 146: FROM po_line_locations pll2

142: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed
143: WHERE pll.line_location_id = X_po_line_location_id
144: OR ( pll.shipment_type = 'PLANNED'
145: AND pll.line_location_id = ( SELECT pll2.source_shipment_id
146: FROM po_line_locations pll2
147: WHERE pll2.shipment_type = 'SCHEDULED'
148: AND pll2.line_location_id = X_po_line_location_id)
149: );
150:

Line 156: po_message_s.sql_error('ap_update_po_line_locations', X_progress, sqlcode);

152:
153: EXCEPTION
154:
155: when others then
156: po_message_s.sql_error('ap_update_po_line_locations', X_progress, sqlcode);
157: raise;
158:
159: END ap_update_po_line_locations;
160:

Line 159: END ap_update_po_line_locations;

155: when others then
156: po_message_s.sql_error('ap_update_po_line_locations', X_progress, sqlcode);
157: raise;
158:
159: END ap_update_po_line_locations;
160:
161:
162:
163: PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,