[Home] [Help]
PACKAGE: APPS.CE_AUTO_BANK_REC
Source
1 PACKAGE CE_AUTO_BANK_REC AS
2 /*$Header: ceabrdrs.pls 120.10 2008/01/23 13:19:01 kbabu ship $ */
3
4 --
5 -- GLOBAL variables
6 --
7 -- From CE_SYSTEM_PARAMETERS
8 --
9 G_rowid VARCHAR2(100);
10 G_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
11 G_set_of_books_id CE_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
12 G_create_misc_flag VARCHAR2(1);
13 G_cashbook_begin_date CE_SYSTEM_PARAMETERS.cashbook_begin_date%TYPE;
14 G_show_cleared_flag CE_SYSTEM_PARAMETERS.show_cleared_flag%TYPE;
15 G_show_void_payment_flag CE_SYSTEM_PARAMETERS.show_void_payment_flag%TYPE;
16 G_cr_vat_tax_code VARCHAR2(50);
17 G_dr_vat_tax_code VARCHAR2(50);
18 G_lines_per_commit CE_SYSTEM_PARAMETERS.lines_per_commit%TYPE;
19 G_functional_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
20 G_sob_short_name VARCHAR2(100);
21 G_account_period_type VARCHAR2(100);
22 G_user_exchange_rate_type VARCHAR2(100);
23
24 -- FROM CE_BANK_ACCOUNTS
25 /* bug 4914608 system parameters move to acct and uses
26 move variable to ceabrmas.pls
27 G_amount_tolerance NUMBER;
28 G_percent_tolerance NUMBER;*/
29
30 G_differences_account VARCHAR2(30);
31 --G_foreign_difference_handling VARCHAR2(30);
32
33 G_open_interface_flag VARCHAR2(1);
34 G_interface_purge_flag VARCHAR2(1);
35 G_interface_archive_flag VARCHAR2(1);
36 G_line_autocreation_flag VARCHAR2(1);
37 G_ap_matching_order VARCHAR2(10);
38 G_ap_matching_order2 VARCHAR2(10);-- FOR SEPA ER 6700007
39 G_ar_matching_order VARCHAR2(10);
40 G_exchange_rate_type VARCHAR2(30);
41 G_exchange_rate_date VARCHAR2(10);
42 G_float_handling_flag VARCHAR2(1);
43 G_open_interface_float_status VARCHAR2(30);
44 G_open_interface_clear_status VARCHAR2(30);
45 G_open_interface_matching_code VARCHAR2(30);
46
47 -- FROM CE_BANK_ACCT_USES_ALL
48
49 G_receivables_trx_id NUMBER(15);
50 G_receivables_trx_dsp VARCHAR2(100);
51
52
53 --
54 -- Passed as parameters
55 --
56 G_option FND_LOOKUP_VALUES.lookup_code%TYPE;
57 G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
58 G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
59 G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
60 G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
61 G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
62 G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
63 G_gl_date CE_SYSTEM_PARAMETERS.cashbook_begin_date%TYPE;
64 G_gl_date_original CE_SYSTEM_PARAMETERS.cashbook_begin_date%TYPE;
65 G_payment_method_id NUMBER;
66 G_nsf_handling FND_LOOKUP_VALUES.lookup_code%TYPE;
67 G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
68 G_debug_path VARCHAR(100);
69 G_debug_file VARCHAR(100);
70 G_payment_method_name AR_RECEIPT_METHODS.name%TYPE;
71 G_intra_day_flag VARCHAR2(1);
72 G_ce_debug_flag VARCHAR2(1); /* Bug 3364143 added this variable */
73 G_org_id NUMBER;
74 G_legal_entity_id NUMBER;
75
76 -- bug 4436028 BAT
77
78 G_CE_DIFFERENCES_ACCOUNT VARCHAR2(30);
79 G_CASHFLOW_EXCHANGE_RATE_TYPE VARCHAR2(30);
80 G_AUTHORIZATION_BAT VARCHAR2(30);
81
82 -- bug 4572139
83 G_BSC_EXCHANGE_DATE_TYPE VARCHAR2(10);
84 G_BAT_EXCHANGE_DATE_TYPE VARCHAR2(10);
85
86 --
87 -- Tables storing the open and future enterable periods of ap and ar
88 --
89 TYPE period_type IS TABLE OF GL_PERIOD_STATUSES.period_name%TYPE
90 INDEX BY BINARY_INTEGER;
91 TYPE date_type IS TABLE OF GL_PERIOD_STATUSES.start_date%TYPE
92 INDEX BY BINARY_INTEGER;
93
94 --
95 -- Profile options
96 --
97 G_sequence_numbering VARCHAR2(1);
98 G_inverse_rate VARCHAR2(1);
99 --
100 -- Misc needed stuff
101 --
102 G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
103
104 /* $Header: ceabrdrs.pls 120.10 2008/01/23 13:19:01 kbabu ship $ */
105
106 FUNCTION find_gl_period (p_date DATE, p_app_id NUMBER) RETURN BOOLEAN;
107
108 FUNCTION spec_revision RETURN VARCHAR2;
109
110 FUNCTION body_revision RETURN VARCHAR2;
111
112 PROCEDURE statement ( errbuf OUT NOCOPY VARCHAR2,
113 retcode OUT NOCOPY NUMBER,
114 p_option VARCHAR2,
115 p_bank_branch_id NUMBER,
116 p_bank_account_id NUMBER,
117 p_statement_number_from VARCHAR2,
118 p_statement_number_to VARCHAR2,
119 p_statement_date_from VARCHAR2,
120 p_statement_date_to VARCHAR2,
121 p_gl_date VARCHAR2,
122 p_org_id VARCHAR2 DEFAULT NULL,
123 p_legal_entity_id VARCHAR2 DEFAULT NULL,
124 p_receivables_trx_id NUMBER,
125 p_payment_method_id NUMBER,
126 p_nsf_handling VARCHAR2,
127 p_display_debug VARCHAR2,
128 p_debug_path VARCHAR2,
129 p_debug_file VARCHAR2,
130 p_intra_day_flag VARCHAR2 DEFAULT 'N');
131
132 PROCEDURE set_parameters (p_option VARCHAR2,
133 p_bank_branch_id NUMBER,
134 p_bank_account_id NUMBER,
135 p_statement_number_from VARCHAR2,
136 p_statement_number_to VARCHAR2,
137 p_statement_date_from VARCHAR2,
138 p_statement_date_to VARCHAR2,
139 p_gl_date VARCHAR2,
140 p_receivables_trx_id NUMBER,
141 p_payment_method_id NUMBER,
142 p_nsf_handling VARCHAR2,
143 p_display_debug VARCHAR2,
144 p_debug_path VARCHAR2,
145 p_debug_file VARCHAR2,
146 p_intra_day_flag VARCHAR2,
147 p_org_id NUMBER,
148 p_legal_entity_id NUMBER);
149
150 PROCEDURE show_parameters;
151
152 END CE_AUTO_BANK_REC;