34:
35: ---------------------------------------------------------------------------
36: -- DATA STRUCTURES
37: ---------------------------------------------------------------------------
38: -- OKL_LS_RT_FCTR_SETS_V Record Spec
39:
40: TYPE lrtv_rec_type IS RECORD (
41: id number,
42: object_version_number number,
39:
40: TYPE lrtv_rec_type IS RECORD (
41: id number,
42: object_version_number number,
43: sfwt_flag okl_ls_rt_fctr_sets_v.sfwt_flag%TYPE,
44: try_id number,
45: pdt_id number,
46: rate number,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
43: sfwt_flag okl_ls_rt_fctr_sets_v.sfwt_flag%TYPE,
44: try_id number,
45: pdt_id number,
46: rate number,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
44: try_id number,
45: pdt_id number,
46: rate number,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
45: pdt_id number,
46: rate number,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
46: rate number,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
47: frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
48: arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49: start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
50: end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51: name okl_ls_rt_fctr_sets_v.name%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
52: description okl_ls_rt_fctr_sets_v.description%TYPE,
53: created_by number,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
54: creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
55: last_updated_by number := okl_api.g_miss_num,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
56: last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
57: last_update_login number,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
58: attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
59: attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
60: attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
61: attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
62: attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
63: attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
64: attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
65: attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
66: attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
67: attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
68: attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
76: currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
69: attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
76: currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
77: lrs_type_code okl_ls_rt_fctr_sets_v.lrs_type_code%TYPE,
70: attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71: attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
76: currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
77: lrs_type_code okl_ls_rt_fctr_sets_v.lrs_type_code%TYPE,
78: end_of_term_id number,
72: attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
76: currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
77: lrs_type_code okl_ls_rt_fctr_sets_v.lrs_type_code%TYPE,
78: end_of_term_id number,
79: orig_rate_set_id number
80: );
73: attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74: sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75: org_id number,
76: currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
77: lrs_type_code okl_ls_rt_fctr_sets_v.lrs_type_code%TYPE,
78: end_of_term_id number,
79: orig_rate_set_id number
80: );
81: