PACKAGE: APPS.ARP_CR_BATCHES_PKG

Source

1 PACKAGE ARP_CR_BATCHES_PKG AS
2 /* $Header: ARRIBATS.pls 120.4 2003/10/24 19:44:37 orashid ship $*/
3 PROCEDURE set_to_dummy( p_bat_rec OUT NOCOPY ar_batches%rowtype);
4 PROCEDURE insert_p( p_bat_rec    IN ar_batches%ROWTYPE,
5         p_row_id OUT NOCOPY VARCHAR2,
6         p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE );
7 PROCEDURE insert_p( p_bat_rec    IN ar_batches%ROWTYPE,
8         p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE );
9 PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE,
10                     p_batch_id IN
11                            ar_batches.batch_id%TYPE);
12 
13 PROCEDURE update_p( p_bat_rec    IN ar_batches%ROWTYPE );
14 
15 PROCEDURE delete_p(
16 	p_bat_id IN ar_batches.batch_id%TYPE );
17 
18 PROCEDURE lock_p(
19         p_row_id        VARCHAR2,
20         p_set_of_books_id  ar_batches.set_of_books_id%TYPE,
21         p_batch_id  ar_batches.batch_id%TYPE,
22         p_batch_applied_status  ar_batches.batch_applied_status%TYPE,
23         p_batch_date  ar_batches.batch_date%TYPE,
24         p_batch_source_id  ar_batches.batch_source_id%TYPE,
25         p_comments  ar_batches.comments%TYPE,
26         p_control_amount  ar_batches.control_amount%TYPE,
27         p_control_count  ar_batches.control_count%TYPE,
28         p_exchange_date  ar_batches.exchange_date%TYPE,
29         p_exchange_rate  ar_batches.exchange_rate%TYPE,
30         p_exchange_rate_type  ar_batches.exchange_rate_type%TYPE,
31         p_lockbox_batch_name  ar_batches.lockbox_batch_name%TYPE,
32         p_media_reference  ar_batches.media_reference%TYPE,
33         p_operation_request_id  ar_batches.operation_request_id%TYPE,
34         p_receipt_class_id  ar_batches.receipt_class_id%TYPE,
35         p_receipt_method_id  ar_batches.receipt_method_id%TYPE,
36         p_remit_method_code  ar_batches.remit_method_code%TYPE,
37         p_remittance_bank_account_id  ar_batches.remit_bank_acct_use_id%type,
38         p_remittance_bank_branch_id  ar_batches.remittance_bank_branch_id%TYPE,
39         p_attribute_category  ar_batches.attribute_category%TYPE,
40         p_attribute1  ar_batches.attribute1%TYPE,
41         p_attribute2  ar_batches.attribute2%TYPE,
42         p_attribute3  ar_batches.attribute3%TYPE,
43         p_attribute4  ar_batches.attribute4%TYPE,
44         p_attribute5  ar_batches.attribute5%TYPE,
45         p_attribute6  ar_batches.attribute6%TYPE,
46         p_attribute7  ar_batches.attribute7%TYPE,
47         p_attribute8  ar_batches.attribute8%TYPE,
48         p_attribute9  ar_batches.attribute9%TYPE,
49         p_attribute10  ar_batches.attribute10%TYPE,
50         p_attribute11  ar_batches.attribute11%TYPE,
51         p_attribute12  ar_batches.attribute12%TYPE,
52         p_attribute13  ar_batches.attribute13%TYPE,
53         p_attribute14  ar_batches.attribute14%TYPE,
54         p_attribute15  ar_batches.attribute15%TYPE,
55         p_request_id  ar_batches.request_id%TYPE,
56         p_transmission_id  ar_batches.transmission_id%TYPE,
57         p_bank_deposit_number  ar_batches.bank_deposit_number%TYPE );
58 
59 
60 PROCEDURE nowaitlock_p(
61 	p_bat_id IN ar_batches.batch_id%TYPE );
62 
63 PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,
64                    p_batch_rec OUT NOCOPY ar_batches%ROWTYPE );
65 PROCEDURE lock_fetch_p(
66                    p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE );
67 
68 PROCEDURE nowaitlock_fetch_p(
69                    p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE );
70 
71 END  ARP_CR_BATCHES_PKG;
72 --