APPS.IBY_AR_UTILS dependencies on AR_INVOICE_HEADER_V

Line 511: ar_invoice_header_v.customer_trx_id%TYPE)

507:
508: END call_get_payment_info;
509:
510: FUNCTION get_order_freight_amount(p_customer_trx_id IN
511: ar_invoice_header_v.customer_trx_id%TYPE)
512: RETURN NUMBER
513: IS
514: l_freight_amount NUMBER := 0;
515:

Line 517: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

513: IS
514: l_freight_amount NUMBER := 0;
515:
516: CURSOR c_header_freight
517: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
518: IS
519: SELECT extended_amount
520: FROM ar_invoice_lines_v
521: WHERE (link_to_cust_trx_line_id IS NULL)

Line 526: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

522: AND (line_type = 'FREIGHT')
523: AND (customer_trx_id = ci_cust_trx_id);
524:
525: CURSOR c_freight_total
526: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
527: IS
528: SELECT SUM(extended_amount)
529: FROM ar_invoice_lines_v
530: WHERE

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

564: RETURN NVL(l_freight_amount,0);
565: END get_order_freight_amount;
566:
567: FUNCTION get_order_tax_amount
568: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
569: p_tax_type IN VARCHAR2)
570: RETURN NUMBER
571: IS
572: l_tax_total NUMBER := 0;

Line 575: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

571: IS
572: l_tax_total NUMBER := 0;
573:
574: CURSOR c_line_items
575: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
576: IS
577: SELECT customer_trx_line_id
578: FROM ar_invoice_lines_v
579: WHERE

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

591: RETURN l_tax_total;
592: END get_order_tax_amount;
593:
594: FUNCTION get_order_amount
595: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE)
596: RETURN NUMBER
597: IS
598: l_order_total NUMBER := 0;
599:

Line 601: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)

597: IS
598: l_order_total NUMBER := 0;
599:
600: CURSOR c_line_items
601: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
602: IS
603: SELECT extended_amount
604: FROM ar_invoice_lines_v
605: WHERE

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

614: RETURN l_order_total;
615: END get_order_amount;
616:
617: FUNCTION get_line_tax_amount
618: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
619: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
620: p_tax_type IN VARCHAR2)
621: RETURN NUMBER
622: IS

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

657:
658: END get_line_tax_amount;
659:
660: FUNCTION get_line_tax_rate
661: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
662: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
663: p_tax_type IN VARCHAR2)
664: RETURN NUMBER
665: IS