APPS.POA_SUPPERF_POPULATE_PKG dependencies on POA_SUPPERF_API_PKG

Line 61: AND poa_supperf_api_pkg.get_last_trx_date(pll.line_location_id)

57: AND pol.matching_basis = 'QUANTITY'
58: AND NVL(pll.approved_flag, 'N') = 'Y'
59: AND pol.item_id IS NOT NULL
60: AND pll.po_release_id = por.po_release_id(+) /* FPI */
61: AND poa_supperf_api_pkg.get_last_trx_date(pll.line_location_id)
62: BETWEEN p_start_date AND p_end_date;
63:
64: v_c_info C_EXTRACT%ROWTYPE;
65: v_quantity_rejected NUMBER;

Line 101: v_primary_uom := poa_supperf_api_pkg.get_primary_uom(

97: v_date_dimension := NVL(v_c_info.expected_date,
98: v_c_info.creation_date);
99:
100:
101: v_primary_uom := poa_supperf_api_pkg.get_primary_uom(
102: v_c_info.item_id,
103: v_c_info.org_id
104: );
105:

Line 117: v_avg_price := poa_supperf_api_pkg.get_avg_price(

113: );
114:
115:
116: x_progress := '004';
117: v_avg_price := poa_supperf_api_pkg.get_avg_price(
118: v_c_info.line_location_id,
119: v_c_info.price_override
120: );
121: x_progress := '005';

Line 137: poa_supperf_api_pkg.get_receipt_date(

133: x_progress := '007';
134: else
135: x_progress := '008';
136: v_receipt_date :=
137: poa_supperf_api_pkg.get_receipt_date(
138: v_c_info.line_location_id
139: );
140:
141: x_progress := '009';

Line 143: poa_supperf_api_pkg.get_rcv_txn_qty(

139: );
140:
141: x_progress := '009';
142: v_quantity_received :=
143: poa_supperf_api_pkg.get_rcv_txn_qty(
144: v_c_info.line_location_id,
145: 'RECEIVE'
146: );
147:

Line 150: poa_supperf_api_pkg.get_rcv_txn_qty(

146: );
147:
148: x_progress := '010';
149: v_quantity_rejected :=
150: poa_supperf_api_pkg.get_rcv_txn_qty(
151: v_c_info.line_location_id,
152: 'REJECT'
153: );
154: -- should watch out for null receipts

Line 155: v_num_receipts := poa_supperf_api_pkg.get_num_receipts(

151: v_c_info.line_location_id,
152: 'REJECT'
153: );
154: -- should watch out for null receipts
155: v_num_receipts := poa_supperf_api_pkg.get_num_receipts(
156: v_c_info.line_location_id
157: );
158:
159: x_progress := '011';

Line 164: poa_supperf_api_pkg.get_quantity_past_due(

160: if (v_c_info.shipping_control='BUYER') then
161: v_quantity_past_due := 0;
162: else
163: v_quantity_past_due :=
164: poa_supperf_api_pkg.get_quantity_past_due(
165: (v_c_info.quantity -
166: v_c_info.quantity_cancelled) *
167: v_uom_rate,
168: v_quantity_received,

Line 193: poa_supperf_api_pkg.get_quantity_purchased(

189: v_quantity_ordered := v_c_info.quantity * v_uom_rate;
190:
191: x_progress := '015';
192: v_quantity_purchased :=
193: poa_supperf_api_pkg.get_quantity_purchased(
194: v_c_info.quantity * v_uom_rate,
195: v_c_info.quantity_billed * v_uom_rate,
196: v_c_info.quantity_cancelled * v_uom_rate,
197: nvl(v_quantity_received,

Line 198: poa_supperf_api_pkg.get_rcv_txn_qty(

194: v_c_info.quantity * v_uom_rate,
195: v_c_info.quantity_billed * v_uom_rate,
196: v_c_info.quantity_cancelled * v_uom_rate,
197: nvl(v_quantity_received,
198: poa_supperf_api_pkg.get_rcv_txn_qty(
199: v_c_info.line_location_id,
200: 'RECEIVE'
201: )),
202: v_c_info.cancel_flag,

Line 208: poa_supperf_api_pkg.get_total_amount(

204: );
205:
206: x_progress := '016';
207: v_total_amount :=
208: poa_supperf_api_pkg.get_total_amount(
209: v_c_info.line_location_id,
210: v_c_info.cancel_flag,
211: v_c_info.closed_code,
212: v_c_info.price_override

Line 243: poa_supperf_api_pkg.get_quantity_late(

239: v_quantity_received_early := 0;
240: else
241: x_progress := '019';
242: v_quantity_received_late :=
243: poa_supperf_api_pkg.get_quantity_late(
244: v_c_info.line_location_id,
245: v_c_info.expected_date,
246: v_c_info.days_late_receipt_allowed
247: );

Line 250: poa_supperf_api_pkg.get_quantity_early(

246: v_c_info.days_late_receipt_allowed
247: );
248: x_progress := '020';
249: v_quantity_received_early :=
250: poa_supperf_api_pkg.get_quantity_early(
251: v_c_info.line_location_id,
252: v_c_info.expected_date,
253: v_c_info.days_early_receipt_allowed
254: );