1 PACKAGE ARP_PROCESS_BR_BATCHES AUTHID CURRENT_USER AS
2 /* $Header: ARTEBRBS.pls 120.2 2003/10/24 02:09:34 orashid arhmapss.pls $ */
3
4
5 PROCEDURE insert_batch (
6 p_form_name IN varchar2 ,
7 p_form_version IN number ,
8 p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
9 p_batch_date IN ra_batches.batch_date%TYPE ,
10 p_gl_date IN ra_batches.gl_date%TYPE ,
11 p_TYPE IN ra_batches.TYPE%TYPE ,
12 p_currency_code IN ra_batches.currency_code%TYPE ,
13 p_comments IN ra_batches.comments%TYPE ,
14 p_attribute_category IN ra_batches.attribute_category%TYPE ,
15 p_attribute1 IN ra_batches.attribute1%TYPE ,
16 p_attribute2 IN ra_batches.attribute2%TYPE ,
17 p_attribute3 IN ra_batches.attribute3%TYPE ,
18 p_attribute4 IN ra_batches.attribute4%TYPE ,
19 p_attribute5 IN ra_batches.attribute5%TYPE ,
20 p_attribute6 IN ra_batches.attribute6%TYPE ,
21 p_attribute7 IN ra_batches.attribute7%TYPE ,
22 p_attribute8 IN ra_batches.attribute8%TYPE ,
23 p_attribute9 IN ra_batches.attribute9%TYPE ,
24 p_attribute10 IN ra_batches.attribute10%TYPE ,
25 p_attribute11 IN ra_batches.attribute11%TYPE ,
26 p_attribute12 IN ra_batches.attribute12%TYPE ,
27 p_attribute13 IN ra_batches.attribute13%TYPE ,
28 p_attribute14 IN ra_batches.attribute14%TYPE ,
29 p_attribute15 IN ra_batches.attribute15%TYPE ,
30 p_issue_date IN ra_batches.issue_date%TYPE ,
31 p_maturity_date IN ra_batches.maturity_date%TYPE ,
32 p_special_instructions IN ra_batches.special_instructions%TYPE ,
33 p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34 p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35 p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36 p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37 p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38 p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39 p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40 p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41 p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42 p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43 p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44 p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45 p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46 p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47 p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48 p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49 p_name IN OUT NOCOPY ra_batches.name%TYPE );
50
51
52
53
54 PROCEDURE update_batch (
55 p_form_name IN varchar2 ,
56 p_form_version IN number ,
57 p_batch_id IN ra_batches.batch_id%TYPE ,
58 p_name IN ra_batches.name%TYPE ,
59 p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
60 p_batch_date IN ra_batches.batch_date%TYPE ,
61 p_gl_date IN ra_batches.gl_date%TYPE ,
62 p_TYPE IN ra_batches.TYPE%TYPE ,
63 p_currency_code IN ra_batches.currency_code%TYPE ,
64 p_comments IN ra_batches.comments%TYPE ,
65 p_attribute_category IN ra_batches.attribute_category%TYPE ,
66 p_attribute1 IN ra_batches.attribute1%TYPE ,
67 p_attribute2 IN ra_batches.attribute2%TYPE ,
68 p_attribute3 IN ra_batches.attribute3%TYPE ,
69 p_attribute4 IN ra_batches.attribute4%TYPE ,
70 p_attribute5 IN ra_batches.attribute5%TYPE ,
71 p_attribute6 IN ra_batches.attribute6%TYPE ,
72 p_attribute7 IN ra_batches.attribute7%TYPE ,
73 p_attribute8 IN ra_batches.attribute8%TYPE ,
74 p_attribute9 IN ra_batches.attribute9%TYPE ,
75 p_attribute10 IN ra_batches.attribute10%TYPE ,
76 p_attribute11 IN ra_batches.attribute11%TYPE ,
77 p_attribute12 IN ra_batches.attribute12%TYPE ,
78 p_attribute13 IN ra_batches.attribute13%TYPE ,
79 p_attribute14 IN ra_batches.attribute14%TYPE ,
80 p_attribute15 IN ra_batches.attribute15%TYPE ,
81 p_issue_date IN ra_batches.issue_date%TYPE ,
82 p_maturity_date IN ra_batches.maturity_date%TYPE ,
83 p_special_instructions IN ra_batches.special_instructions%TYPE ,
84 p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85 p_request_id IN ra_batches.request_id%TYPE ,
86 p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87 p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88 p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89 p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90 p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91 p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92 p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93 p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94 p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95 p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96 p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97 p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98 p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99 p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);
100
101
102
103 PROCEDURE delete_batch (
104 p_form_name IN varchar2 ,
105 p_form_version IN number ,
106 p_batch_id IN ra_batches.batch_id%TYPE ,
107 p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE);
108
109
110
111 PROCEDURE lock_compare_batch (
112 p_form_name IN varchar2 ,
113 p_form_version IN number ,
114 p_batch_id IN ra_batches.batch_id%TYPE ,
115 p_name IN ra_batches.name%TYPE ,
116 p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
117 p_batch_date IN ra_batches.batch_date%TYPE ,
118 p_gl_date IN ra_batches.gl_date%TYPE ,
119 p_TYPE IN ra_batches.TYPE%TYPE ,
120 p_currency_code IN ra_batches.currency_code%TYPE ,
121 p_comments IN ra_batches.comments%TYPE ,
122 p_attribute_category IN ra_batches.attribute_category%TYPE,
123 p_attribute1 IN ra_batches.attribute1%TYPE ,
124 p_attribute2 IN ra_batches.attribute2%TYPE ,
125 p_attribute3 IN ra_batches.attribute3%TYPE ,
126 p_attribute4 IN ra_batches.attribute4%TYPE ,
127 p_attribute5 IN ra_batches.attribute5%TYPE ,
128 p_attribute6 IN ra_batches.attribute6%TYPE ,
129 p_attribute7 IN ra_batches.attribute7%TYPE ,
130 p_attribute8 IN ra_batches.attribute8%TYPE ,
131 p_attribute9 IN ra_batches.attribute9%TYPE ,
132 p_attribute10 IN ra_batches.attribute10%TYPE ,
133 p_attribute11 IN ra_batches.attribute11%TYPE ,
134 p_attribute12 IN ra_batches.attribute12%TYPE ,
135 p_attribute13 IN ra_batches.attribute13%TYPE ,
136 p_attribute14 IN ra_batches.attribute14%TYPE ,
137 p_attribute15 IN ra_batches.attribute15%TYPE ,
138 p_issue_date IN ra_batches.issue_date%TYPE ,
139 p_maturity_date IN ra_batches.maturity_date%TYPE ,
140 p_special_instructions IN ra_batches.special_instructions%TYPE ,
141 p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142 p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143 p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144 p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145 p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146 p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147 p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148 p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149 p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150 p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151 p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152 p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153 p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154 p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155 p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );
156
157
158 PROCEDURE submit_print (
159 p_format IN varchar2 ,
160 p_BR_ID IN number ,
161 p_request_id OUT NOCOPY number );
162
163
164 PROCEDURE br_create(
165 p_call IN NUMBER ,
166 p_draft_mode IN VARCHAR2 ,
167 p_print_flag IN VARCHAR2 ,
168 p_batch_id IN RA_BATCHES.batch_id%TYPE ,
169 p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
170 p_batch_date IN RA_BATCHES.batch_date%TYPE ,
171 p_gl_date IN RA_BATCHES.gl_date%TYPE ,
172 p_issue_date IN RA_BATCHES.issue_date%TYPE ,
173 p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
174 p_currency_code IN RA_BATCHES.currency_code%TYPE ,
175 p_comments IN RA_BATCHES.comments%TYPE ,
176 p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
177 p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
178 p_attribute1 IN VARCHAR2 ,
179 p_attribute2 IN VARCHAR2 ,
180 p_attribute3 IN VARCHAR2 ,
181 p_attribute4 IN VARCHAR2 ,
182 p_attribute5 IN VARCHAR2 ,
183 p_attribute6 IN VARCHAR2 ,
184 p_attribute7 IN VARCHAR2 ,
185 p_attribute8 IN VARCHAR2 ,
186 p_attribute9 IN VARCHAR2 ,
187 p_attribute10 IN VARCHAR2 ,
188 p_attribute11 IN VARCHAR2 ,
189 p_attribute12 IN VARCHAR2 ,
190 p_attribute13 IN VARCHAR2 ,
191 p_attribute14 IN VARCHAR2 ,
192 p_attribute15 IN VARCHAR2 ,
193 p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE ,
194 p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE ,
195 p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE ,
196 p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE ,
197 p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE ,
198 p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
199 p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE ,
200 p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE ,
201 p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE ,
202 p_cust_class IN AR_LOOKUPS.lookup_code%TYPE ,
203 p_cust_category IN AR_LOOKUPS.lookup_code%TYPE ,
204 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE ,
205 p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE ,
206 p_req_id OUT NOCOPY NUMBER ,
207 p_batch_process_status OUT NOCOPY VARCHAR2 );
208
209 END ARP_PROCESS_BR_BATCHES;