1 PACKAGE GMF_AR_GET_PAYMENT_DETAILS AUTHID CURRENT_USER AS
2 /* $Header: gmfinrps.pls 115.1 99/07/16 04:19:21 porting shi $ */
3 PROCEDURE get_payment_details (
4 invoice_id IN OUT NUMBER,
5 start_date IN OUT DATE,
6 end_date IN OUT DATE,
7 arc_CASH_RECEIPT_ID OUT NUMBER,
8 arc_LAST_UPDATED_BY OUT NUMBER,
9 arc_LAST_UPDATE_DATE OUT DATE,
10 arc_CREATED_BY OUT NUMBER,
11 arc_CREATION_DATE OUT DATE,
12 arc_AMOUNT OUT NUMBER,
13 arc_SET_OF_BOOKS_ID OUT NUMBER,
14 arc_CURRENCY_CODE OUT VARCHAR2,
15 arc_RECEIVABLES_TRX_ID OUT NUMBER,
16 arc_PAY_FROM_CUSTOMER OUT NUMBER,
17 arc_STATUS OUT VARCHAR2,
18 arc_TYPE OUT VARCHAR2,
19 arc_RECEIPT_NUMBER OUT VARCHAR2,
20 arc_RECEIPT_DATE OUT DATE,
21 arc_MISC_PAYMENT_SOURCE OUT VARCHAR2,
22 arc_COMMENTS OUT VARCHAR2,
23 arc_DISTRIBUTION_SET_ID OUT NUMBER,
24 arc_REVERSAL_DATE OUT DATE,
25 arc_REVERSAL_CATEGORY OUT VARCHAR2,
26 arc_REVERSAL_REASON_CODE OUT VARCHAR2,
27 arc_REVERSAL_COMMENTS OUT VARCHAR2,
28 arc_EXCHANGE_RATE_TYPE OUT VARCHAR2,
29 arc_EXCHANGE_RATE OUT NUMBER,
30 arc_EXCHANGE_DATE OUT DATE,
31 arc_REMITTANCE_BANK_ACC_ID OUT NUMBER,
32 arc_CONFIRMED_FLAG OUT VARCHAR2,
33 arc_CUSTOMER_BANK_ACC_ID OUT NUMBER,
34 arc_CUSTOMER_SITE_USE_ID OUT NUMBER,
35 arc_DEPOSIT_DATE OUT DATE,
36 arc_PROGRAM_APPLICATION_ID OUT NUMBER,
37 arc_PROGRAM_ID OUT NUMBER,
38 arc_PROGRAM_UPDATE_DATE OUT DATE,
39 arc_RECEIPT_METHOD_ID OUT NUMBER,
40 arc_REQUEST_ID OUT NUMBER,
41 arc_SELECTED_FOR_FACT_FLAG OUT VARCHAR2,
42 arc_SELECTED_REMIT_BATCH_ID OUT NUMBER,
43 arc_FACTOR_DISCOUNT_AMOUNT OUT NUMBER,
44 arc_VAT_TAX_ID OUT NUMBER,
45 arr_RECEIVABLE_APPLICATION_ID OUT NUMBER,
46 arr_LAST_UPDATED_BY OUT NUMBER,
47 arr_LAST_UPDATE_DATE OUT DATE,
48 arr_CREATED_BY OUT NUMBER,
49 arr_CREATION_DATE OUT DATE,
50 arr_AMOUNT_APPLIED OUT NUMBER,
51 arr_GL_DATE OUT DATE,
52 arr_CODE_COMBINATION_ID OUT NUMBER,
53 arr_SET_OF_BOOKS_ID OUT NUMBER,
54 arr_DISPLAY OUT VARCHAR2,
55 arr_APPLY_DATE OUT DATE,
56 arr_APPLICATION_TYPE OUT VARCHAR2,
57 arr_STATUS OUT VARCHAR2,
58 arr_PAYMENT_SCHEDULE_ID OUT NUMBER,
59 arr_LAST_UPDATE_LOGIN OUT NUMBER,
60 arr_CASH_RECEIPT_ID OUT NUMBER,
61 arr_APPLIED_CUSTOMER_TRX_ID OUT NUMBER,
62 arr_APPLIED_CUST_TRX_LINE_ID OUT NUMBER,
63 arr_APPLIED_PAYMENT_SCH_ID OUT NUMBER,
64 arr_CUSTOMER_TRX_ID OUT NUMBER,
65 arr_LINE_APPLIED OUT NUMBER,
66 arr_TAX_APPLIED OUT NUMBER,
67 arr_FREIGHT_APPLIED OUT NUMBER,
68 arr_RECEIVABLES_CHARGES_APPD OUT NUMBER,
69 arr_ON_ACCOUNT_CUSTOMER OUT NUMBER,
70 arr_RECEIVABLES_TRX_ID OUT NUMBER,
71 arr_EARNED_DISCOUNT_TAKEN OUT NUMBER,
72 arr_UNEARNED_DISCOUNT_TAKEN OUT NUMBER,
73 arr_DAYS_LATE OUT NUMBER,
74 arr_APPLICATION_RULE OUT VARCHAR2,
75 arr_GL_POSTED_DATE OUT DATE,
76 arr_COMMENTS OUT VARCHAR2,
77 arr_POSTABLE OUT VARCHAR2,
78 arr_POSTING_CONTROL_ID OUT NUMBER,
79 arr_ACCTD_AMOUNT_APPLIED_FROM OUT NUMBER,
80 arr_ACCTD_AMOUNT_APPLIED_TO OUT NUMBER,
81 arr_ACCTD_EARNED_DISC_TAKEN OUT NUMBER,
82 arr_CONFIRMED_FLAG OUT VARCHAR2,
83 arr_PROGRAM_APPLICATION_ID OUT NUMBER,
84 arr_PROGRAM_ID OUT NUMBER,
85 arr_PROGRAM_UPDATE_DATE OUT DATE,
86 arr_REQUEST_ID OUT NUMBER,
87 arr_EARNED_DISCOUNT_CCID OUT NUMBER,
88 arr_UNEARNED_DISCOUNT_CCID OUT NUMBER,
89 arr_ACCTD_UNEARNED_DISC_TAKEN OUT NUMBER,
90 arr_REVERSAL_GL_DATE OUT DATE,
91 arr_REVERSAL_GL_DATE_CONTEXT OUT VARCHAR2,
92 arr_CASH_RECEIPT_HISTORY_ID OUT NUMBER,
93 row_to_fetch IN OUT NUMBER,
94 error_status OUT NUMBER);
95 END GMF_AR_GET_PAYMENT_DETAILS;