2: /* $Header: OKLSDRAS.pls 120.2 2007/04/30 22:58:00 cklee noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_DISB_RULES_V Record Spec
7: TYPE drav_rec_type IS RECORD (
8: disb_rule_id NUMBER
9: ,object_version_number NUMBER
10: ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
6: -- OKL_DISB_RULES_V Record Spec
7: TYPE drav_rec_type IS RECORD (
8: disb_rule_id NUMBER
9: ,object_version_number NUMBER
10: ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
11: ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
7: TYPE drav_rec_type IS RECORD (
8: disb_rule_id NUMBER
9: ,object_version_number NUMBER
10: ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
11: ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
9: ,object_version_number NUMBER
10: ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
11: ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
10: ,sfwt_flag OKL_DISB_RULES_V.SFWT_FLAG%TYPE
11: ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
18: ,fee_percent NUMBER
11: ,rule_name OKL_DISB_RULES_V.RULE_NAME%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
18: ,fee_percent NUMBER
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
12: ,org_id NUMBER
13: ,start_date OKL_DISB_RULES_V.START_DATE%TYPE
14: ,end_date OKL_DISB_RULES_V.END_DATE%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
18: ,fee_percent NUMBER
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
15: ,fee_option OKL_DISB_RULES_V.FEE_OPTION%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
18: ,fee_percent NUMBER
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
16: ,fee_basis OKL_DISB_RULES_V.FEE_BASIS%TYPE
17: ,fee_amount NUMBER
18: ,fee_percent NUMBER
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
18: ,fee_percent NUMBER
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
19: ,consolidate_by_due_date OKL_DISB_RULES_V.CONSOLIDATE_BY_DUE_DATE%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
20: ,frequency OKL_DISB_RULES_V.FREQUENCY%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
21: ,day_of_month NUMBER
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
22: ,scheduled_month OKL_DISB_RULES_V.SCHEDULED_MONTH%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
23: ,consolidate_strm_type OKL_DISB_RULES_V.CONSOLIDATE_STRM_TYPE%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
24: ,description OKL_DISB_RULES_V.DESCRIPTION%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
25: ,attribute_category OKL_DISB_RULES_V.ATTRIBUTE_CATEGORY%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
26: ,attribute1 OKL_DISB_RULES_V.ATTRIBUTE1%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
27: ,attribute2 OKL_DISB_RULES_V.ATTRIBUTE2%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
28: ,attribute3 OKL_DISB_RULES_V.ATTRIBUTE3%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
29: ,attribute4 OKL_DISB_RULES_V.ATTRIBUTE4%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
30: ,attribute5 OKL_DISB_RULES_V.ATTRIBUTE5%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
31: ,attribute6 OKL_DISB_RULES_V.ATTRIBUTE6%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
32: ,attribute7 OKL_DISB_RULES_V.ATTRIBUTE7%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
33: ,attribute8 OKL_DISB_RULES_V.ATTRIBUTE8%TYPE
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
34: ,attribute9 OKL_DISB_RULES_V.ATTRIBUTE9%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
42: ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
35: ,attribute10 OKL_DISB_RULES_V.ATTRIBUTE10%TYPE
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
42: ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
43: ,last_updated_by NUMBER
36: ,attribute11 OKL_DISB_RULES_V.ATTRIBUTE11%TYPE
37: ,attribute12 OKL_DISB_RULES_V.ATTRIBUTE12%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
42: ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
43: ,last_updated_by NUMBER
44: ,last_update_date OKL_DISB_RULES_V.LAST_UPDATE_DATE%TYPE
38: ,attribute13 OKL_DISB_RULES_V.ATTRIBUTE13%TYPE
39: ,attribute14 OKL_DISB_RULES_V.ATTRIBUTE14%TYPE
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
42: ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
43: ,last_updated_by NUMBER
44: ,last_update_date OKL_DISB_RULES_V.LAST_UPDATE_DATE%TYPE
45: ,last_update_login NUMBER);
46: G_MISS_drav_rec drav_rec_type;
40: ,attribute15 OKL_DISB_RULES_V.ATTRIBUTE15%TYPE
41: ,created_by NUMBER
42: ,creation_date OKL_DISB_RULES_V.CREATION_DATE%TYPE
43: ,last_updated_by NUMBER
44: ,last_update_date OKL_DISB_RULES_V.LAST_UPDATE_DATE%TYPE
45: ,last_update_login NUMBER);
46: G_MISS_drav_rec drav_rec_type;
47: TYPE drav_tbl_type IS TABLE OF drav_rec_type
48: INDEX BY BINARY_INTEGER;