2: /* $Header: ARBRRMAS.pls 120.2 2003/10/24 02:09:32 orashid ship $*/
3:
4: PROCEDURE create_remit_batch (
5: p_api_version IN NUMBER ,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT NOCOPY VARCHAR2 ,
10: x_msg_count OUT NOCOPY NUMBER ,
3:
4: PROCEDURE create_remit_batch (
5: p_api_version IN NUMBER ,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT NOCOPY VARCHAR2 ,
10: x_msg_count OUT NOCOPY NUMBER ,
11: x_msg_data OUT NOCOPY VARCHAR2 ,
4: PROCEDURE create_remit_batch (
5: p_api_version IN NUMBER ,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT NOCOPY VARCHAR2 ,
10: x_msg_count OUT NOCOPY NUMBER ,
11: x_msg_data OUT NOCOPY VARCHAR2 ,
12: p_batch_date IN AR_BATCHES.batch_date%TYPE,
68: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE);
69:
70: PROCEDURE select_and_assign_br_to_remit(
71: p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2 ,
76: x_msg_count OUT NOCOPY NUMBER ,
69:
70: PROCEDURE select_and_assign_br_to_remit(
71: p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2 ,
76: x_msg_count OUT NOCOPY NUMBER ,
77: x_msg_data OUT NOCOPY VARCHAR2 ,
70: PROCEDURE select_and_assign_br_to_remit(
71: p_api_version IN NUMBER ,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2 ,
76: x_msg_count OUT NOCOPY NUMBER ,
77: x_msg_data OUT NOCOPY VARCHAR2 ,
78: p_batch_id IN AR_BATCHES.batch_id%TYPE,
132: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE);
133:
134: PROCEDURE add_or_rm_br_to_remit (
135: p_api_version IN number,
136: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
137: p_commit IN varchar2 := FND_API.G_FALSE,
138: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY varchar2,
140: x_msg_count OUT NOCOPY number,
133:
134: PROCEDURE add_or_rm_br_to_remit (
135: p_api_version IN number,
136: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
137: p_commit IN varchar2 := FND_API.G_FALSE,
138: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY varchar2,
140: x_msg_count OUT NOCOPY number,
141: x_msg_data OUT NOCOPY varchar2,
134: PROCEDURE add_or_rm_br_to_remit (
135: p_api_version IN number,
136: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
137: p_commit IN varchar2 := FND_API.G_FALSE,
138: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY varchar2,
140: x_msg_count OUT NOCOPY number,
141: x_msg_data OUT NOCOPY varchar2,
142: p_batch_id IN AR_BATCHES.batch_id%TYPE,
193: p_drawee_order IN varchar2);
194:
195: PROCEDURE create_remit_batch_conc_req (
196: p_api_version IN number,
197: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
198: p_commit IN varchar2 := FND_API.G_FALSE,
199: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
200: x_return_status OUT NOCOPY varchar2,
201: x_msg_count OUT NOCOPY number,
194:
195: PROCEDURE create_remit_batch_conc_req (
196: p_api_version IN number,
197: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
198: p_commit IN varchar2 := FND_API.G_FALSE,
199: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
200: x_return_status OUT NOCOPY varchar2,
201: x_msg_count OUT NOCOPY number,
202: x_msg_data OUT NOCOPY varchar2,
195: PROCEDURE create_remit_batch_conc_req (
196: p_api_version IN number,
197: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
198: p_commit IN varchar2 := FND_API.G_FALSE,
199: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
200: x_return_status OUT NOCOPY varchar2,
201: x_msg_count OUT NOCOPY number,
202: x_msg_data OUT NOCOPY varchar2,
203: p_create_flag IN varchar2,
242:
243:
244: PROCEDURE maintain_remit_batch_conc_req (
245: p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2 ,
250: x_msg_count OUT NOCOPY NUMBER ,
243:
244: PROCEDURE maintain_remit_batch_conc_req (
245: p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2 ,
250: x_msg_count OUT NOCOPY NUMBER ,
251: x_msg_data OUT NOCOPY VARCHAR2 ,
244: PROCEDURE maintain_remit_batch_conc_req (
245: p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: x_return_status OUT NOCOPY VARCHAR2 ,
250: x_msg_count OUT NOCOPY NUMBER ,
251: x_msg_data OUT NOCOPY VARCHAR2 ,
252: p_approve_flag IN varchar2,
263:
264:
265: PROCEDURE update_batch_status (
266: p_api_version IN NUMBER ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2 ,
271: x_msg_count OUT NOCOPY NUMBER ,
264:
265: PROCEDURE update_batch_status (
266: p_api_version IN NUMBER ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2 ,
271: x_msg_count OUT NOCOPY NUMBER ,
272: x_msg_data OUT NOCOPY VARCHAR2 ,
265: PROCEDURE update_batch_status (
266: p_api_version IN NUMBER ,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2 ,
271: x_msg_count OUT NOCOPY NUMBER ,
272: x_msg_data OUT NOCOPY VARCHAR2 ,
273: p_batch_id IN AR_BATCHES.batch_id%TYPE,