APPS.AP_INVOICE_PAYMENTS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1: PACKAGE BODY AP_INVOICE_PAYMENTS_PKG AS

1: PACKAGE BODY AP_INVOICE_PAYMENTS_PKG AS
2: /* $Header: apiinpab.pls 120.3 2005/09/20 20:15:55 rlandows noship $ */
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_code%TYPE, --4552701
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_code%TYPE, --4552701
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:

Line 37: FROM ap_invoice_payments_all aip,

33: aip.invoice_payment_type,
34: iby.payment_method_name, --4552701
35: ac.payment_method_code, --4552701
36: iby.payment_method_name
37: FROM ap_invoice_payments_all aip,
38: ap_checks_all ac,
39: ap_invoices_all ai,
40: iby_payment_methods_vl iby
41: WHERE aip.invoice_id = l_invoice_id

Line 91: l_paid_by := AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(

87: EXIT WHEN payment_cursor%NOTFOUND;
88:
89: IF (payment_cursor%ROWCOUNT = 1) THEN
90:
91: l_paid_by := AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(
92: l_payment_record);
93:
94: ELSIF (payment_cursor%ROWCOUNT > 1) THEN
95: -----------------------------------------------------------

Line 137: l_paid_by := AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(

133: LOOP
134: FETCH payment_cursor INTO l_payment_record;
135: EXIT WHEN payment_cursor%NOTFOUND;
136:
137: l_paid_by := AP_INVOICE_PAYMENTS_PKG.CONCAT_DOCUMENT_NUM_TYPE(
138: l_payment_record);
139:
140: IF (l_paid_by_list IS NOT NULL) THEN
141: l_paid_by_list := l_paid_by_list || ', ';

Line 294: FROM ap_invoice_payments_all

290: BEGIN
291:
292: SELECT NVL(MAX(accounting_date), SYSDATE-9000)
293: INTO gl_date
294: FROM ap_invoice_payments_all
295: WHERE check_id = l_check_id;
296:
297: RETURN gl_date;
298:

Line 301: END AP_INVOICE_PAYMENTS_PKG;

297: RETURN gl_date;
298:
299: END get_max_gl_date;
300:
301: END AP_INVOICE_PAYMENTS_PKG;