34:
35: ---------------------------------------------------------------------------
36: -- DATA STRUCTURES
37: ---------------------------------------------------------------------------
38: -- OKL_ITM_CAT_RV_PRCS_V Record Spec
39: TYPE icpv_rec_type IS RECORD (
40: id NUMBER
41: ,object_version_number NUMBER
42: ,cat_id1 NUMBER
39: TYPE icpv_rec_type IS RECORD (
40: id NUMBER
41: ,object_version_number NUMBER
42: ,cat_id1 NUMBER
43: ,cat_id2 OKL_ITM_CAT_RV_PRCS_V.CAT_ID2%TYPE
44: ,term_in_months NUMBER
45: ,residual_value_percent NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
42: ,cat_id1 NUMBER
43: ,cat_id2 OKL_ITM_CAT_RV_PRCS_V.CAT_ID2%TYPE
44: ,term_in_months NUMBER
45: ,residual_value_percent NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
43: ,cat_id2 OKL_ITM_CAT_RV_PRCS_V.CAT_ID2%TYPE
44: ,term_in_months NUMBER
45: ,residual_value_percent NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
44: ,term_in_months NUMBER
45: ,residual_value_percent NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
45: ,residual_value_percent NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53: ,last_updated_by NUMBER
46: ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47: ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53: ,last_updated_by NUMBER
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
48: ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49: ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53: ,last_updated_by NUMBER
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
50: ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51: ,created_by NUMBER
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53: ,last_updated_by NUMBER
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
52: ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53: ,last_updated_by NUMBER
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
53: ,last_updated_by NUMBER
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
54: ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
55: ,last_update_login NUMBER
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
56: ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
57: ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
58: ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
59: ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
60: ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
61: ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
62: ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
63: ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71: ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
64: ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71: ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
72:
65: ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71: ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
72:
73: TYPE icpv_tbl_type IS TABLE OF icpv_rec_type INDEX BY BINARY_INTEGER;
66: ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71: ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
72:
73: TYPE icpv_tbl_type IS TABLE OF icpv_rec_type INDEX BY BINARY_INTEGER;
74:
67: ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68: ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69: ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70: ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71: ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
72:
73: TYPE icpv_tbl_type IS TABLE OF icpv_rec_type INDEX BY BINARY_INTEGER;
74:
75: -- OKL_ITM_CAT_RV_PRCS Record Spec