3:
4: G_BATCH_ID NUMBER := NULL;
5:
6: TYPE posting_batch_rec_type IS RECORD
7: (posting_batch_id cn_posting_batches.posting_batch_id%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
4: G_BATCH_ID NUMBER := NULL;
5:
6: TYPE posting_batch_rec_type IS RECORD
7: (posting_batch_id cn_posting_batches.posting_batch_id%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
5:
6: TYPE posting_batch_rec_type IS RECORD
7: (posting_batch_id cn_posting_batches.posting_batch_id%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
6: TYPE posting_batch_rec_type IS RECORD
7: (posting_batch_id cn_posting_batches.posting_batch_id%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
7: (posting_batch_id cn_posting_batches.posting_batch_id%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
8: name cn_posting_batches.name%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
9: start_date cn_posting_batches.start_date%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
10: end_date cn_posting_batches.end_date%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
11: load_status cn_posting_batches.load_status%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
12: attribute_category cn_posting_batches.attribute_category%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
13: attribute1 cn_posting_batches.attribute1%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
14: attribute2 cn_posting_batches.attribute2%TYPE := null,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
15: attribute3 cn_posting_batches.attribute3%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
16: attribute4 cn_posting_batches.attribute4%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
17: attribute5 cn_posting_batches.attribute5%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
18: attribute6 cn_posting_batches.attribute6%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
19: attribute7 cn_posting_batches.attribute7%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
20: attribute8 cn_posting_batches.attribute8%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
21: attribute9 cn_posting_batches.attribute9%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
22: attribute10 cn_posting_batches.attribute10%TYPE := nulL,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
23: attribute11 cn_posting_batches.attribute11%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
24: attribute12 cn_posting_batches.attribute12%TYPE := null,
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
32: last_updated_by cn_posting_batches.last_updated_by%TYPE := null
25: attribute13 cn_posting_batches.attribute13%TYPE := null,
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
32: last_updated_by cn_posting_batches.last_updated_by%TYPE := null
33: );
26: attribute14 cn_posting_batches.attribute14%TYPE := null,
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
32: last_updated_by cn_posting_batches.last_updated_by%TYPE := null
33: );
34:
27: attribute15 cn_posting_batches.attribute15%TYPE := null,
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
32: last_updated_by cn_posting_batches.last_updated_by%TYPE := null
33: );
34:
35: PROCEDURE Get_UID( x_posting_batch_id IN OUT NOCOPY NUMBER );
28: created_by cn_posting_batches.created_by%TYPE := null,
29: creation_date cn_posting_batches.creation_date%TYPE := null,
30: last_update_login cn_posting_batches.last_update_login%TYPE := null,
31: last_update_date cn_posting_batches.last_update_date%TYPE := null,
32: last_updated_by cn_posting_batches.last_updated_by%TYPE := null
33: );
34:
35: PROCEDURE Get_UID( x_posting_batch_id IN OUT NOCOPY NUMBER );
36: