[Home] [Help]
PACKAGE: APPS.ARP_CONFIRMATION
Source
1 PACKAGE ARP_CONFIRMATION AS
2 /* $Header: ARRECNFS.pls 120.3 2005/07/26 15:26:36 naneja ship $ */
3
4 ----------------------- Data types -----------------------------
5
6 TYPE MaxDatesType IS RECORD
7 ( max_trx_date DATE,
8 max_gl_date DATE,
9 cnf_date DATE,
10 cnf_gl_date DATE,
11 max_ra_apply_date DATE,
12 max_ra_gl_date DATE);
13
14 TYPE id_arr IS TABLE OF NUMBER(15);
15 TYPE num_arr IS TABLE OF NUMBER;
16 TYPE var_arr1 IS TABLE OF VARCHAR2(1);
17 TYPE var_arr20 IS TABLE OF VARCHAR2(20);
18 TYPE var_arr30 IS TABLE OF VARCHAR2(30);
19 TYPE var_arr150 IS TABLE OF VARCHAR2(150);
20 TYPE var_arr240 IS TABLE OF VARCHAR2(240);
21 TYPE date_arr IS TABLE OF DATE;
22
23 TYPE new_con_data IS RECORD
24 ( l_old_rec_app_id id_arr,
25 l_new_rec_app_id id_arr,
26 l_acctd_amount_applied_from num_arr,
27 l_amount_applied num_arr,
28 l_application_rule var_arr30,
29 l_application_type var_arr20,
30 l_apply_date date_arr,
31 l_code_combination_id id_arr,
32 l_created_by id_arr,
33 l_creation_date date_arr,
34 l_display var_arr1,
35 l_gl_date date_arr,
36 l_last_updated_by id_arr,
37 l_last_update_date date_arr,
38 l_payment_schedule_id id_arr,
39 l_set_of_books_id id_arr,
40 l_status var_arr30,
41 l_acctd_amount_applied_to num_arr,
42 l_acctd_earned_discount_tkn num_arr,
43 l_acctd_unearned_discount_tkn num_arr,
44 l_applied_customer_trx_id id_arr,
45 l_applied_customer_trx_line_id id_arr,
46 l_applied_payment_schedule_id id_arr,
47 l_cash_receipt_id id_arr,
48 l_comments var_arr240,
49 l_confirmed_flag var_arr1,
50 l_customer_trx_id id_arr,
51 l_days_late num_arr,
52 l_earned_discount_taken num_arr,
53 l_freight_applied num_arr,
54 l_gl_posted_date date_arr,
55 l_last_update_login num_arr,
56 l_line_applied num_arr,
57 l_on_account_customer num_arr,
58 l_postable var_arr1,
59 l_posting_control_id id_arr,
60 l_cash_receipt_history_id id_arr,
61 l_program_application_id id_arr,
62 l_program_id id_arr,
63 l_program_update_date date_arr,
64 l_receivables_charges_applied num_arr,
65 l_receivables_trx_id id_arr,
66 l_request_id id_arr,
67 l_tax_applied num_arr,
68 l_unearned_discount_taken num_arr,
69 l_unearned_discount_ccid id_arr,
70 l_earned_discount_ccid id_arr,
71 l_ussgl_transaction_code var_arr30,
72 l_attribute_category var_arr30,
73 l_attribute1 var_arr150,
74 l_attribute2 var_arr150,
75 l_attribute3 var_arr150,
76 l_attribute4 var_arr150,
77 l_attribute5 var_arr150,
78 l_attribute6 var_arr150,
79 l_attribute7 var_arr150,
80 l_attribute8 var_arr150,
81 l_attribute9 var_arr150,
82 l_attribute10 var_arr150,
83 l_attribute11 var_arr150,
84 l_attribute12 var_arr150,
85 l_attribute13 var_arr150,
86 l_attribute14 var_arr150,
87 l_attribute15 var_arr150,
88 l_ussgl_transaction_code_cntxt var_arr30,
89 l_reversal_gl_date date_arr,
90 l_org_id id_arr
91 );
92 ------------------ Public functions/procedures -------------------
93
94 PROCEDURE confirm(
95 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
96 p_confirm_gl_date IN DATE,
97 p_confirm_date IN DATE,
98 p_module_name IN VARCHAR2,
99 p_module_version IN VARCHAR2 );
100
101 PROCEDURE unconfirm(
102 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
103 p_confirm_gl_date IN DATE,
104 p_confirm_date IN DATE,
105 p_module_name IN VARCHAR2,
106 p_module_version IN VARCHAR2 );
107
108 /* Bug fix 872506 */
109 PROCEDURE confirm_batch(
110 p_batch_id IN NUMBER,
111 p_confirm_gl_date IN DATE,
112 p_confirm_date IN DATE,
113 p_num_rec_confirmed OUT NOCOPY NUMBER,
114 p_num_rec_error OUT NOCOPY NUMBER);
115
116 PROCEDURE confirm_receipt(
117 p_cr_id IN NUMBER,
118 p_confirm_gl_date IN DATE,
119 p_confirm_date IN DATE);
120 /* End bug fix 872506 */
121 ----------------- Private functions/procedures ------------------
122
123 PROCEDURE do_confirm(
124 p_cr_rec IN ar_cash_receipts%ROWTYPE,
125 p_confirm_gl_date IN DATE,
126 p_confirm_date IN DATE,
127 p_acctd_amount IN NUMBER);
128
129 PROCEDURE do_unconfirm(
130 p_cr_rec IN ar_cash_receipts%ROWTYPE,
131 p_confirm_gl_date IN DATE,
132 p_confirm_date IN DATE,
133 p_acctd_amount IN NUMBER,
134 p_batch_id
135 IN ar_payment_schedules.selected_for_receipt_batch_id%TYPE);
136
137 PROCEDURE update_cr_history_confirm(
138 p_cr_rec IN ar_cash_receipts%ROWTYPE,
139 p_confirm_gl_date IN DATE,
140 p_confirm_date IN DATE,
141 p_acctd_amount IN NUMBER,
142 p_receipt_clearing_ccid IN
143 ar_receipt_method_accounts.receipt_clearing_ccid%TYPE);
144
145 PROCEDURE update_cr_history_unconfirm(
146 p_cr_rec IN ar_cash_receipts%ROWTYPE,
147 p_confirm_gl_date IN DATE,
148 p_confirm_date IN DATE,
149 p_acctd_amount IN NUMBER,
150 p_batch_id OUT NOCOPY ar_cash_receipt_history.batch_id%TYPE,
151 p_crh_id_rev OUT NOCOPY
152 ar_cash_receipt_history.cash_receipt_history_id%TYPE
153 );
154
155 PROCEDURE confirm_update_ps_rec(
156 p_cr_rec ar_cash_receipts%ROWTYPE,
157 p_closed_date DATE,
158 p_closed_gl_date DATE);
159
160 PROCEDURE modify_update_ra_rec(
161 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
162 p_amount_applied IN NUMBER,
163 p_acctd_amount_applied IN NUMBER,
164 p_confirm_gl_date IN DATE,
165 p_confirm_date IN DATE);
166
167 PROCEDURE create_matching_unapp_records(
168 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
169 p_app_id IN ar_receivable_applications.receivable_application_id%TYPE);
170
171 PROCEDURE get_receipt_clearing_ccid(
172 p_cr_rec IN ar_cash_receipts%ROWTYPE,
173 p_receipt_clearing_ccid OUT NOCOPY
174 ar_receipt_method_accounts.receipt_clearing_ccid%TYPE);
175
176 PROCEDURE reverse_application_to_ps(
177 p_ra_id IN
178 ar_receivable_applications.receivable_application_id%TYPE,
179 p_confirm_gl_date IN DATE,
180 p_confirm_date IN DATE,
181 p_batch_id IN
182 ar_payment_schedules.selected_for_receipt_batch_id%TYPE
183 );
184
185 PROCEDURE reverse_ra_recs(
186 p_cr_rec IN ar_cash_receipts%ROWTYPE,
187 p_confirm_gl_date IN DATE,
188 p_confirm_date IN DATE
189 );
190
191 PROCEDURE unconfirm_update_ps_rec(
192 p_cr_rec ar_cash_receipts%ROWTYPE,
193 p_closed_date DATE,
194 p_closed_gl_date DATE
195 );
196
197 PROCEDURE validate_in_parameters(
198 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
199 p_confirm_gl_date IN DATE,
200 p_confirm_date IN DATE,
201 p_module_name IN VARCHAR2);
202
203 PROCEDURE get_application_flags(
204 p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
205 p_ao_flag OUT NOCOPY ra_cust_trx_types.allow_overapplication_flag%TYPE,
206 p_nao_flag OUT NOCOPY ra_cust_trx_types.natural_application_only_flag%TYPE,
207 p_creation_sign OUT NOCOPY ra_cust_trx_types.creation_sign%TYPE);
208
209 PROCEDURE handle_max_dates(
210 p_max_dates IN OUT NOCOPY MaxDatesType,
211 p_gl_date IN DATE,
212 p_apply_date IN DATE,
213 p_confirm_date IN DATE,
214 p_confirm_gl_date IN DATE );
215
216 END ARP_CONFIRMATION;