1 PACKAGE ARP_RW_BATCHES_PKG AS
2 /* $Header: ARERBATS.pls 120.3 2006/06/30 20:14:53 salladi ship $ */
3 --
4 PROCEDURE insert_manual_batch(
5 p_row_id IN OUT NOCOPY VARCHAR2,
6 p_batch_type IN VARCHAR2,
7 p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
8 p_batch_source_id IN ar_batches.batch_source_id%TYPE,
9 p_batch_date IN ar_batches.batch_date%TYPE,
10 p_currency_code IN ar_batches.currency_code%TYPE,
11 p_name IN OUT NOCOPY ar_batches.name%TYPE,
12 p_comments IN ar_batches.comments%TYPE,
13 p_control_amount IN ar_batches.control_amount%TYPE,
14 p_control_count IN ar_batches.control_count%TYPE,
15 p_deposit_date IN ar_batches.deposit_date%TYPE,
16 p_exchange_date IN ar_batches.exchange_date%TYPE,
17 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
18 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
19 p_gl_date IN ar_batches.gl_date%TYPE,
20 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
21 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
22 p_remittance_bank_account_id
23 IN ar_batches.remit_bank_acct_use_id%TYPE,
24 p_remittance_bank_branch_id
25 IN ar_batches.remittance_bank_branch_id%TYPE,
26 p_attribute_category IN ar_batches.attribute_category%TYPE,
27 p_attribute1 IN ar_batches.attribute1%TYPE,
28 p_attribute2 IN ar_batches.attribute2%TYPE,
29 p_attribute3 IN ar_batches.attribute3%TYPE,
30 p_attribute4 IN ar_batches.attribute4%TYPE,
31 p_attribute5 IN ar_batches.attribute5%TYPE,
32 p_attribute6 IN ar_batches.attribute6%TYPE,
33 p_attribute7 IN ar_batches.attribute7%TYPE,
34 p_attribute8 IN ar_batches.attribute8%TYPE,
35 p_attribute9 IN ar_batches.attribute9%TYPE,
36 p_attribute10 IN ar_batches.attribute10%TYPE,
37 p_attribute11 IN ar_batches.attribute11%TYPE,
38 p_attribute12 IN ar_batches.attribute12%TYPE,
39 p_attribute13 IN ar_batches.attribute13%TYPE,
40 p_attribute14 IN ar_batches.attribute14%TYPE,
41 p_attribute15 IN ar_batches.attribute15%TYPE,
42 p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
43 p_module_name IN VARCHAR2,
44 p_module_version IN VARCHAR2 );
45 --
46 PROCEDURE insert_auto_batch(
47 p_row_id IN OUT NOCOPY VARCHAR2,
48 p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
49 p_batch_date IN ar_batches.batch_date%TYPE,
50 p_currency_code IN ar_batches.currency_code%TYPE,
51 p_name IN OUT NOCOPY ar_batches.name%TYPE,
52 p_comments IN ar_batches.comments%TYPE,
53 p_exchange_date IN ar_batches.exchange_date%TYPE,
54 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
55 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
56 p_gl_date IN ar_batches.gl_date%TYPE,
57 p_media_reference IN ar_batches.media_reference%TYPE,
58 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
59 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
60 p_attribute_category IN ar_batches.attribute_category%TYPE,
61 p_attribute1 IN ar_batches.attribute1%TYPE,
62 p_attribute2 IN ar_batches.attribute2%TYPE,
63 p_attribute3 IN ar_batches.attribute3%TYPE,
64 p_attribute4 IN ar_batches.attribute4%TYPE,
65 p_attribute5 IN ar_batches.attribute5%TYPE,
66 p_attribute6 IN ar_batches.attribute6%TYPE,
67 p_attribute7 IN ar_batches.attribute7%TYPE,
68 p_attribute8 IN ar_batches.attribute8%TYPE,
69 p_attribute9 IN ar_batches.attribute9%TYPE,
70 p_attribute10 IN ar_batches.attribute10%TYPE,
71 p_attribute11 IN ar_batches.attribute11%TYPE,
72 p_attribute12 IN ar_batches.attribute12%TYPE,
73 p_attribute13 IN ar_batches.attribute13%TYPE,
74 p_attribute14 IN ar_batches.attribute14%TYPE,
75 p_attribute15 IN ar_batches.attribute15%TYPE,
76 p_call_conc_req IN VARCHAR2,
77 p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
78 p_request_id OUT NOCOPY ar_batches.request_id%TYPE,
79 p_module_name IN VARCHAR2,
80 p_module_version IN VARCHAR2,
81 p_bank_account_low IN VARCHAR2,
82 p_bank_account_high IN VARCHAR2 );
83 --
84 PROCEDURE insert_remit_batch(
85 p_row_id IN OUT NOCOPY VARCHAR2,
86 p_batch_id IN OUT NOCOPY ar_batches.batch_id%TYPE,
87 p_batch_date IN ar_batches.batch_date%TYPE,
88 p_currency_code IN ar_batches.currency_code%TYPE,
89 p_name IN OUT NOCOPY ar_batches.name%TYPE,
90 p_comments IN ar_batches.comments%TYPE,
91 p_exchange_date IN ar_batches.exchange_date%TYPE,
92 p_exchange_rate IN ar_batches.exchange_rate%TYPE,
93 p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
94 p_gl_date IN ar_batches.gl_date%TYPE,
95 p_media_reference IN ar_batches.media_reference%TYPE,
96 p_remit_method_code IN ar_batches.remit_method_code%TYPE,
97 p_receipt_class_id IN ar_batches.receipt_class_id%TYPE,
98 p_receipt_method_id IN ar_batches.receipt_method_id%TYPE,
99 p_remittance_bank_account_id
100 IN ar_batches.remit_bank_acct_use_id%TYPE,
101 p_remittance_bank_branch_id
102 IN ar_batches.remittance_bank_branch_id%TYPE,
103 p_bank_deposit_number IN ar_batches.bank_deposit_number%TYPE,
104 p_attribute_category IN ar_batches.attribute_category%TYPE,
105 p_attribute1 IN ar_batches.attribute1%TYPE,
106 p_attribute2 IN ar_batches.attribute2%TYPE,
107 p_attribute3 IN ar_batches.attribute3%TYPE,
108 p_attribute4 IN ar_batches.attribute4%TYPE,
109 p_attribute5 IN ar_batches.attribute5%TYPE,
110 p_attribute6 IN ar_batches.attribute6%TYPE,
111 p_attribute7 IN ar_batches.attribute7%TYPE,
112 p_attribute8 IN ar_batches.attribute8%TYPE,
113 p_attribute9 IN ar_batches.attribute9%TYPE,
114 p_attribute10 IN ar_batches.attribute10%TYPE,
115 p_attribute11 IN ar_batches.attribute11%TYPE,
116 p_attribute12 IN ar_batches.attribute12%TYPE,
117 p_attribute13 IN ar_batches.attribute13%TYPE,
118 p_attribute14 IN ar_batches.attribute14%TYPE,
119 p_attribute15 IN ar_batches.attribute15%TYPE,
120 p_auto_creation IN VARCHAR2,
121 p_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
122 p_module_name IN VARCHAR2,
123 p_module_version IN VARCHAR2 );
124 --
125 PROCEDURE delete_batch(
126 p_batch_id IN ar_batches.batch_id%TYPE );
127 --
128
129 /*Bug3030995*/
130
131
132
133 PROCEDURE default_batch_source_pay_mthds(p_batch_source_name IN OUT NOCOPY ar_batch_sources.name%TYPE,
134 p_batch_date IN ar_batch_sources.start_date_active%TYPE,
135 p_batch_source_id IN OUT NOCOPY ar_batch_sources.batch_source_id%TYPE,
136 p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%TYPE,
137 p_rec_class_id OUT NOCOPY ar_receipt_classes.receipt_class_id%TYPE,
138 p_rec_class_name OUT NOCOPY ar_receipt_classes.name%TYPE,
139 p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,
140 p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
141 p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,
142 p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
143 p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
144 p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
145 p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
146 p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
147 p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
148 p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,
149 p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
150 p_meaning OUT NOCOPY ar_lookups.meaning%TYPE);
151
152
153
154 END ARP_RW_BATCHES_PKG;