APPS.POS_AP_INVOICE_PAYMENTS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1: PACKAGE BODY POS_AP_INVOICE_PAYMENTS_PKG AS

1: PACKAGE BODY POS_AP_INVOICE_PAYMENTS_PKG AS
2: /* $Header: POSAPPAB.pls 115.0 2001/06/18 18:42:23 pkm ship $ */
3:
4: -----------------------------------------------------------------------
5: -- Declare record type used to hold records returned from generic cursor

Line 13: gl_date ap_invoice_payments.accounting_date%TYPE,

9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_lookup_code%TYPE,
17: method_trans ap_lookup_codes.displayed_field%TYPE);

Line 14: type ap_invoice_payments.invoice_payment_type%TYPE,

10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_lookup_code%TYPE,
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:

Line 38: FROM ap_invoice_payments_all aip, --ap_invoice_payments

34: aip.invoice_payment_type,
35: alc1.displayed_field,
36: ac.payment_method_lookup_code,
37: alc2.displayed_field
38: FROM ap_invoice_payments_all aip, --ap_invoice_payments
39: ap_checks_all ac, --ap_checks
40: ap_invoices_all ai, --ap_invoices
41: ap_lookup_codes alc1,
42: ap_lookup_codes alc2

Line 101: l_paid_by := POS_AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(

97: LOOP
98: FETCH payment_cursor INTO l_payment_record;
99: EXIT WHEN payment_cursor%NOTFOUND;
100:
101: l_paid_by := POS_AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(
102: l_payment_record);
103:
104: IF (l_paid_by_list IS NOT NULL) THEN
105: l_paid_by_list := l_paid_by_list || ', ';

Line 118: END POS_AP_INVOICE_PAYMENTS_PKG;

114: RETURN(l_paid_by_list);
115:
116: END get_paid_by_list;
117:
118: END POS_AP_INVOICE_PAYMENTS_PKG;