DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_QUOTA_RULES

Line 119: -- Record Type for Revenue Classes ( CN_Quota_Rules )

115: --
116: g_miss_period_quotas_rec_tbl period_quotas_rec_tbl_type;
117:
118: --
119: -- Record Type for Revenue Classes ( CN_Quota_Rules )
120: --
121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,

Line 122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

118: --
119: -- Record Type for Revenue Classes ( CN_Quota_Rules )
120: --
121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,

Line 123: rev_class_target cn_quota_rules.target%TYPE := 0,

119: -- Record Type for Revenue Classes ( CN_Quota_Rules )
120: --
121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,

Line 124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,

120: --
121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

Line 125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,

121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,

Line 126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,

122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

Line 143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0
145:
146: );
147:

Line 144: org_id cn_quota_rules.org_id%TYPE := 0

140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0
145:
146: );
147:
148: --

Line 160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

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

Line 181: rev_class_name_old cn_quota_rules.NAME%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,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type

Line 202: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

198: --
199: TYPE trx_factor_rec_type IS RECORD (
200: trx_type cn_trx_factors.trx_type%TYPE := cn_api.g_miss_char,
201: event_factor cn_trx_factors.event_factor%TYPE := 0,
202: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
203: org_id cn_trx_factors.org_id%TYPE := 0
204: );
205:
206: --