1 PACKAGE ARP_PROCESS_BATCH AUTHID CURRENT_USER AS
2 /* $Header: ARTEBATS.pls 115.2 2002/11/15 03:36:16 anukumar ship $ */
3
4 PROCEDURE check_dup_batch_name(p_name IN varchar2,
5 p_batch_source_id IN varchar2);
6
7 PROCEDURE ar_empty_batch ( p_batch_id IN number );
8
9 PROCEDURE insert_batch(
10 p_form_name IN varchar2,
11 p_form_version IN number,
12 p_batch_rec IN ra_batches%rowtype,
13 p_batch_id OUT NOCOPY ra_batches.batch_id%type,
14 p_name IN OUT NOCOPY ra_batches.name%type);
15
16 PROCEDURE update_batch(
17 p_form_name IN varchar2,
18 p_form_version IN number,
19 p_batch_id IN ra_batches.batch_id%type,
20 p_batch_rec IN ra_batches%rowtype);
21
22
23 PROCEDURE delete_batch(p_form_name IN varchar2,
24 p_form_version IN number,
25 p_batch_id IN ra_batches.batch_id%type,
26 p_batch_rec IN ra_batches%rowtype);
27
28 PROCEDURE insert_batch_cover(
29 p_form_name IN varchar2,
30 p_form_version IN number,
31 p_batch_source_id IN ra_batches.batch_source_id%type,
32 p_batch_date IN ra_batches.batch_date%type,
33 p_gl_date IN ra_batches.gl_date%type,
34 p_status IN ra_batches.status%type,
35 p_type IN ra_batches.type%type,
36 p_currency_code IN ra_batches.currency_code%type,
37 p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
38 p_exchange_date IN ra_batches.exchange_date%type,
39 p_exchange_rate IN ra_batches.exchange_rate%type,
40 p_control_count IN ra_batches.control_count%type,
41 p_control_amount IN ra_batches.control_amount%type,
42 p_comments IN ra_batches.comments%type,
43 p_set_of_books_id IN ra_batches.set_of_books_id%type,
44 p_purged_children_flag IN ra_batches.purged_children_flag%type,
45 p_attribute_category IN ra_batches.attribute_category%type,
46 p_attribute1 IN ra_batches.attribute1%type,
47 p_attribute2 IN ra_batches.attribute2%type,
48 p_attribute3 IN ra_batches.attribute3%type,
49 p_attribute4 IN ra_batches.attribute4%type,
50 p_attribute5 IN ra_batches.attribute5%type,
51 p_attribute6 IN ra_batches.attribute6%type,
52 p_attribute7 IN ra_batches.attribute7%type,
53 p_attribute8 IN ra_batches.attribute8%type,
54 p_attribute9 IN ra_batches.attribute9%type,
55 p_attribute10 IN ra_batches.attribute10%type,
56 p_attribute11 IN ra_batches.attribute11%type,
57 p_attribute12 IN ra_batches.attribute12%type,
58 p_attribute13 IN ra_batches.attribute13%type,
59 p_attribute14 IN ra_batches.attribute14%type,
60 p_attribute15 IN ra_batches.attribute15%type,
61 p_batch_id OUT NOCOPY ra_batches.batch_id%type,
62 p_name IN OUT NOCOPY ra_batches.name%type);
63
64 PROCEDURE update_batch_cover(
65 p_form_name IN varchar2,
66 p_form_version IN number,
67 p_batch_id IN ra_batches.batch_id%type,
68 p_name IN ra_batches.name%type,
69 p_batch_source_id IN ra_batches.batch_source_id%type,
70 p_batch_date IN ra_batches.batch_date%type,
71 p_gl_date IN ra_batches.gl_date%type,
72 p_status IN ra_batches.status%type,
73 p_type IN ra_batches.type%type,
74 p_currency_code IN ra_batches.currency_code%type,
75 p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
76 p_exchange_date IN ra_batches.exchange_date%type,
77 p_exchange_rate IN ra_batches.exchange_rate%type,
78 p_control_count IN ra_batches.control_count%type,
79 p_control_amount IN ra_batches.control_amount%type,
80 p_comments IN ra_batches.comments%type,
81 p_set_of_books_id IN ra_batches.set_of_books_id%type,
82 p_purged_children_flag IN ra_batches.purged_children_flag%type,
83 p_attribute_category IN ra_batches.attribute_category%type,
84 p_attribute1 IN ra_batches.attribute1%type,
85 p_attribute2 IN ra_batches.attribute2%type,
86 p_attribute3 IN ra_batches.attribute3%type,
87 p_attribute4 IN ra_batches.attribute4%type,
88 p_attribute5 IN ra_batches.attribute5%type,
89 p_attribute6 IN ra_batches.attribute6%type,
90 p_attribute7 IN ra_batches.attribute7%type,
91 p_attribute8 IN ra_batches.attribute8%type,
92 p_attribute9 IN ra_batches.attribute9%type,
93 p_attribute10 IN ra_batches.attribute10%type,
94 p_attribute11 IN ra_batches.attribute11%type,
95 p_attribute12 IN ra_batches.attribute12%type,
96 p_attribute13 IN ra_batches.attribute13%type,
97 p_attribute14 IN ra_batches.attribute14%type,
98 p_attribute15 IN ra_batches.attribute15%type);
99
100
101 PROCEDURE delete_batch_cover(
102 p_form_name IN varchar2,
103 p_form_version IN number,
104 p_batch_id IN ra_batches.batch_id%type);
105
106
107 END ARP_PROCESS_BATCH;
[Home] [Help]