153:
154: g_miss_revenue_class_rec_tbl revenue_class_rec_tbl_type;
155:
156: --
157: -- User Defined Record For Uplift Factors ( CN_QUOTA_RULE_UPLIFTS )
158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
157: -- User Defined Record For Uplift Factors ( CN_QUOTA_RULE_UPLIFTS )
158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );
187:
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );
187:
188: --
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );
187:
188: --
189: -- User defined Quota Rule Uplift Record Table Type.