1: PACKAGE ARP_TBAT_PKG AUTHID CURRENT_USER 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:
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,
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 );
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,
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);
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
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);
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);
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:
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,
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:
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 );
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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);
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:
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:
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:
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;
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;