DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_QUOTA_RULE_UPLIFTS

Line 157: -- User Defined Record For Uplift Factors ( CN_QUOTA_RULE_UPLIFTS )

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,

Line 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,

Line 162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

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,

Line 165: attribute_category cn_quota_rule_uplifts.attribute_category%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,

Line 166: attribute1 cn_quota_rule_uplifts.attribute1%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,

Line 167: attribute2 cn_quota_rule_uplifts.attribute2%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,

Line 168: attribute3 cn_quota_rule_uplifts.attribute3%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,

Line 169: attribute4 cn_quota_rule_uplifts.attribute4%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,

Line 170: attribute5 cn_quota_rule_uplifts.attribute5%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,

Line 171: attribute6 cn_quota_rule_uplifts.attribute6%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,

Line 172: attribute7 cn_quota_rule_uplifts.attribute7%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,

Line 173: attribute8 cn_quota_rule_uplifts.attribute8%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,

Line 174: attribute9 cn_quota_rule_uplifts.attribute9%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,

Line 175: attribute10 cn_quota_rule_uplifts.attribute10%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,

Line 176: attribute11 cn_quota_rule_uplifts.attribute11%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,

Line 177: attribute12 cn_quota_rule_uplifts.attribute12%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,

Line 178: attribute13 cn_quota_rule_uplifts.attribute13%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,

Line 179: attribute14 cn_quota_rule_uplifts.attribute14%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,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

Line 180: attribute15 cn_quota_rule_uplifts.attribute15%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,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,

Line 182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,

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: );

Line 183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

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:

Line 184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,

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: --

Line 185: object_version_number cn_quota_rule_uplifts.object_version_number%type

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.