APPS.IBY_AR_UTILS dependencies on AR_INVOICE_HEADER_V

Line 134: ar_invoice_header_v.customer_trx_id%TYPE)

130:
131: END call_get_payment_info;
132:
133: FUNCTION get_order_freight_amount(p_customer_trx_id IN
134: ar_invoice_header_v.customer_trx_id%TYPE)
135: RETURN NUMBER
136: IS
137: l_freight_amount NUMBER := 0;
138:

Line 140: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

136: IS
137: l_freight_amount NUMBER := 0;
138:
139: CURSOR c_header_freight
140: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
141: IS
142: SELECT extended_amount
143: FROM ar_invoice_lines_v
144: WHERE (link_to_cust_trx_line_id IS NULL)

Line 149: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

145: AND (line_type = 'FREIGHT')
146: AND (customer_trx_id = ci_cust_trx_id);
147:
148: CURSOR c_freight_total
149: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
150: IS
151: SELECT SUM(extended_amount)
152: FROM ar_invoice_lines_v
153: WHERE

Line 191: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,

187: RETURN NVL(l_freight_amount,0);
188: END get_order_freight_amount;
189:
190: FUNCTION get_order_tax_amount
191: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
192: p_tax_type IN VARCHAR2)
193: RETURN NUMBER
194: IS
195: l_tax_total NUMBER := 0;

Line 198: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

194: IS
195: l_tax_total NUMBER := 0;
196:
197: CURSOR c_line_items
198: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
199: IS
200: SELECT customer_trx_line_id
201: FROM ar_invoice_lines_v
202: WHERE

Line 218: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE)

214: RETURN l_tax_total;
215: END get_order_tax_amount;
216:
217: FUNCTION get_order_amount
218: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE)
219: RETURN NUMBER
220: IS
221: l_order_total NUMBER := 0;
222:

Line 224: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

220: IS
221: l_order_total NUMBER := 0;
222:
223: CURSOR c_line_items
224: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
225: IS
226: SELECT extended_amount
227: FROM ar_invoice_lines_v
228: WHERE

Line 241: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,

237: RETURN l_order_total;
238: END get_order_amount;
239:
240: FUNCTION get_line_tax_amount
241: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
242: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
243: p_tax_type IN VARCHAR2)
244: RETURN NUMBER
245: IS

Line 284: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,

280:
281: END get_line_tax_amount;
282:
283: FUNCTION get_line_tax_rate
284: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
285: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
286: p_tax_type IN VARCHAR2)
287: RETURN NUMBER
288: IS