2: /* $Header: OKLSDRVS.pls 120.0 2007/03/13 21:17:36 pjgomes noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_DISB_RULE_VENDOR_SITES Record Spec
7: TYPE drv_rec_type IS RECORD (
8: disb_rule_vendor_site_id NUMBER
9: ,object_version_number NUMBER
10: ,disb_rule_id NUMBER
9: ,object_version_number NUMBER
10: ,disb_rule_id NUMBER
11: ,vendor_id NUMBER
12: ,vendor_site_id NUMBER
13: ,start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE
14: ,end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE
15: ,invoice_seq_start NUMBER
16: ,invoice_seq_end NUMBER
17: ,next_inv_seq NUMBER
10: ,disb_rule_id NUMBER
11: ,vendor_id NUMBER
12: ,vendor_site_id NUMBER
13: ,start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE
14: ,end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE
15: ,invoice_seq_start NUMBER
16: ,invoice_seq_end NUMBER
17: ,next_inv_seq NUMBER
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
14: ,end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE
15: ,invoice_seq_start NUMBER
16: ,invoice_seq_end NUMBER
17: ,next_inv_seq NUMBER
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
15: ,invoice_seq_start NUMBER
16: ,invoice_seq_end NUMBER
17: ,next_inv_seq NUMBER
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
16: ,invoice_seq_end NUMBER
17: ,next_inv_seq NUMBER
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
17: ,next_inv_seq NUMBER
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
18: ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
19: ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
20: ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
21: ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
22: ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
23: ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
24: ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
25: ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
26: ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
27: ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
35: ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
28: ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
35: ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
36: ,last_updated_by NUMBER
29: ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30: ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
35: ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
36: ,last_updated_by NUMBER
37: ,last_update_date OKL_DISB_RULE_VENDOR_SITES.LAST_UPDATE_DATE%TYPE
31: ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32: ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
35: ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
36: ,last_updated_by NUMBER
37: ,last_update_date OKL_DISB_RULE_VENDOR_SITES.LAST_UPDATE_DATE%TYPE
38: ,last_update_login NUMBER);
39: G_MISS_drv_rec drv_rec_type;
33: ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34: ,created_by NUMBER
35: ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
36: ,last_updated_by NUMBER
37: ,last_update_date OKL_DISB_RULE_VENDOR_SITES.LAST_UPDATE_DATE%TYPE
38: ,last_update_login NUMBER);
39: G_MISS_drv_rec drv_rec_type;
40: TYPE drv_tbl_type IS TABLE OF drv_rec_type
41: INDEX BY BINARY_INTEGER;