34:
35: ---------------------------------------------------------------------------
36: -- DATA STRUCTURES
37: ---------------------------------------------------------------------------
38: -- OKL_LS_RT_FCTR_ENTS_V Record Spec
39:
40: TYPE lrfv_rec_type IS RECORD (
41: id number,
42: object_version_number number,
45: residual_value_percent number,
46: interest_rate number,
47: lease_rate_factor number,
48: created_by number,
49: creation_date okl_ls_rt_fctr_ents_v.creation_date%TYPE,
50: last_updated_by number,
51: last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
47: lease_rate_factor number,
48: created_by number,
49: creation_date okl_ls_rt_fctr_ents_v.creation_date%TYPE,
50: last_updated_by number,
51: last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
49: creation_date okl_ls_rt_fctr_ents_v.creation_date%TYPE,
50: last_updated_by number,
51: last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
50: last_updated_by number,
51: last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
51: last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
52: last_update_login number,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
53: attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
54: attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
55: attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
56: attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
57: attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
58: attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
59: attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
60: attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68: attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
61: attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68: attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
69: is_new_flag varchar2(3),
62: attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68: attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
69: is_new_flag varchar2(3),
70: rate_set_version_id number
63: attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68: attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
69: is_new_flag varchar2(3),
70: rate_set_version_id number
71: );
64: attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65: attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66: attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67: attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68: attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
69: is_new_flag varchar2(3),
70: rate_set_version_id number
71: );
72: g_miss_lrfv_rec lrfv_rec_type;