PACKAGE: APPS.ARP_TBAT_PKG

Source

1 PACKAGE ARP_TBAT_PKG AS
2 /* $Header: ARTIBATS.pls 120.4 2005/10/30 04:27:19 appldev ship $ */
3 
4 procedure insert_p(
5                     p_batch_rec   IN ra_batches%rowtype,
6                     p_batch_id   OUT NOCOPY ra_batches.batch_id%type,
7                     p_name       OUT NOCOPY ra_batches.name%type
8                   );
9 
10 PROCEDURE fetch_p( p_batch_rec  OUT NOCOPY ra_batches%rowtype,
11                    p_batch_id    IN ra_batches.batch_id%type );
12 
13 
14 PROCEDURE update_p( p_batch_rec IN ra_batches%rowtype,
15                     p_batch_id  IN ra_batches.batch_id%type);
16 
17 PROCEDURE update_f_bs_id( p_batch_rec IN ra_batches%rowtype,
18                           p_batch_source_id
19                                 IN ra_batch_sources.batch_source_id%type);
20 
21 procedure delete_p( p_batch_id  IN ra_batches.batch_id%type);
22 
23 procedure delete_f_bs_id( p_batch_source_id IN
24                              ra_batches.batch_source_id%type);
25 
26 PROCEDURE lock_p( p_batch_id 	IN ra_batches.batch_id%type );
27 
28 PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
29                         p_batch_id IN ra_batches.batch_id%type );
30 
31 PROCEDURE lock_compare_p( p_batch_rec IN ra_batches%rowtype,
32                           p_batch_id IN ra_batches.batch_id%type );
33 
34 PROCEDURE lock_compare_cover(
35   p_form_name              IN varchar2,
36   p_form_version           IN number,
37   p_batch_id               IN ra_batches.batch_id%type,
38   p_name                   IN ra_batches.name%type,
39   p_batch_source_id        IN ra_batches.batch_source_id%type,
40   p_batch_date             IN ra_batches.batch_date%type,
41   p_gl_date                IN ra_batches.gl_date%type,
42   p_status                 IN ra_batches.status%type,
43   p_type                   IN ra_batches.type%type,
44   p_currency_code          IN ra_batches.currency_code%type,
45   p_exchange_rate_type     IN ra_batches.exchange_rate_type%type,
46   p_exchange_date          IN ra_batches.exchange_date%type,
47   p_exchange_rate          IN ra_batches.exchange_rate%type,
48   p_control_count          IN ra_batches.control_count%type,
49   p_control_amount         IN ra_batches.control_amount%type,
50   p_comments               IN ra_batches.comments%type,
51   p_set_of_books_id        IN ra_batches.set_of_books_id%type,
52   p_purged_children_flag   IN ra_batches.purged_children_flag%type,
53   p_attribute_category     IN ra_batches.attribute_category%type,
54   p_attribute1             IN ra_batches.attribute1%type,
55   p_attribute2             IN ra_batches.attribute2%type,
56   p_attribute3             IN ra_batches.attribute3%type,
57   p_attribute4             IN ra_batches.attribute4%type,
58   p_attribute5             IN ra_batches.attribute5%type,
59   p_attribute6             IN ra_batches.attribute6%type,
60   p_attribute7             IN ra_batches.attribute7%type,
61   p_attribute8             IN ra_batches.attribute8%type,
62   p_attribute9             IN ra_batches.attribute9%type,
63   p_attribute10            IN ra_batches.attribute10%type,
64   p_attribute11            IN ra_batches.attribute11%type,
65   p_attribute12            IN ra_batches.attribute12%type,
66   p_attribute13            IN ra_batches.attribute13%type,
67   p_attribute14            IN ra_batches.attribute14%type,
68   p_attribute15            IN ra_batches.attribute15%type);
69 
70 PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype);
71 
72 
73 PROCEDURE display_batch(  p_batch_id IN ra_batches.batch_id%type);
74 
75 PROCEDURE display_batch_rec( p_batch_rec ra_batches%rowtype );
76 
77 END ARP_TBAT_PKG;