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(
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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(
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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:
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(
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,
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;