80: );
81:
82: TYPE lrtv_tbl_type IS TABLE OF lrtv_rec_type INDEX BY BINARY_INTEGER;
83:
84: -- OKL_LS_RT_FCTR_SETS_B Record Spec
85:
86: TYPE lrt_rec_type IS RECORD (
87: id number,
88: object_version_number number,
85:
86: TYPE lrt_rec_type IS RECORD (
87: id number,
88: object_version_number number,
89: name okl_ls_rt_fctr_sets_b.name%TYPE,
90: arrears_yn okl_ls_rt_fctr_sets_b.arrears_yn%TYPE,
91: start_date okl_ls_rt_fctr_sets_b.start_date%TYPE,
92: end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93: pdt_id number,
86: TYPE lrt_rec_type IS RECORD (
87: id number,
88: object_version_number number,
89: name okl_ls_rt_fctr_sets_b.name%TYPE,
90: arrears_yn okl_ls_rt_fctr_sets_b.arrears_yn%TYPE,
91: start_date okl_ls_rt_fctr_sets_b.start_date%TYPE,
92: end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93: pdt_id number,
94: rate number,
87: id number,
88: object_version_number number,
89: name okl_ls_rt_fctr_sets_b.name%TYPE,
90: arrears_yn okl_ls_rt_fctr_sets_b.arrears_yn%TYPE,
91: start_date okl_ls_rt_fctr_sets_b.start_date%TYPE,
92: end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93: pdt_id number,
94: rate number,
95: try_id number,
88: object_version_number number,
89: name okl_ls_rt_fctr_sets_b.name%TYPE,
90: arrears_yn okl_ls_rt_fctr_sets_b.arrears_yn%TYPE,
91: start_date okl_ls_rt_fctr_sets_b.start_date%TYPE,
92: end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93: pdt_id number,
94: rate number,
95: try_id number,
96: frq_code okl_ls_rt_fctr_sets_b.frq_code%TYPE,
92: end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93: pdt_id number,
94: rate number,
95: try_id number,
96: frq_code okl_ls_rt_fctr_sets_b.frq_code%TYPE,
97: created_by number,
98: creation_date okl_ls_rt_fctr_sets_b.creation_date%TYPE,
99: last_updated_by number,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
94: rate number,
95: try_id number,
96: frq_code okl_ls_rt_fctr_sets_b.frq_code%TYPE,
97: created_by number,
98: creation_date okl_ls_rt_fctr_sets_b.creation_date%TYPE,
99: last_updated_by number,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
96: frq_code okl_ls_rt_fctr_sets_b.frq_code%TYPE,
97: created_by number,
98: creation_date okl_ls_rt_fctr_sets_b.creation_date%TYPE,
99: last_updated_by number,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
98: creation_date okl_ls_rt_fctr_sets_b.creation_date%TYPE,
99: last_updated_by number,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
99: last_updated_by number,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
100: last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
101: last_update_login number,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
102: attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
103: attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
104: attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
105: attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
106: attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
107: attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
108: attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
109: attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
110: attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
111: attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
112: attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
120: currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
113: attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
120: currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
121: lrs_type_code okl_ls_rt_fctr_sets_b.lrs_type_code%TYPE,
114: attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115: attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
120: currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
121: lrs_type_code okl_ls_rt_fctr_sets_b.lrs_type_code%TYPE,
122: end_of_term_id number,
116: attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
120: currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
121: lrs_type_code okl_ls_rt_fctr_sets_b.lrs_type_code%TYPE,
122: end_of_term_id number,
123: orig_rate_set_id number
124: );
117: attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118: sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119: org_id number,
120: currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
121: lrs_type_code okl_ls_rt_fctr_sets_b.lrs_type_code%TYPE,
122: end_of_term_id number,
123: orig_rate_set_id number
124: );
125: