DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_PUB dependencies on CN_COMP_PLANS

Line 21: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS

17: * @rep:product CN
18: * @rep:displayname Role to Compensation Plan Assignment
19: * @rep:lifecycle active
20: * @rep:compatibility S
21: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
22: */
23:
24: --
25: -- User defined Record Type

Line 33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,

29: TYPE role_plan_rec_type IS RECORD
30: (
31: role_name cn_roles.name%TYPE := cn_api.G_MISS_CHAR,
32: role_id cn_role_plans.role_id%TYPE := NULL,
33: comp_plan_name cn_comp_plans.name%TYPE := cn_api.G_MISS_CHAR,
34: comp_plan_id cn_role_plans.comp_plan_id%TYPE := NULL,
35: start_date cn_role_plans.start_date%TYPE := cn_api.G_MISS_DATE,
36: end_date cn_role_plans.end_date%TYPE := cn_api.G_MISS_DATE,
37: attribute_category cn_role_plans.attribute_category%TYPE := cn_api.G_MISS_CHAR,

Line 105: -- 6. Comp_plan_name must exist in cn_comp_plans already.

101: -- 2. Comp plan name can not be missing or null.
102: -- 3. Start_date can not be missing or null.
103: -- 4. Start_date <= end_date, if end_date is not null.
104: -- 5. Role name must exist in cn_roles already.
105: -- 6. Comp_plan_name must exist in cn_comp_plans already.
106: -- 7. Date range (start_date, en_date) of the assignment must be
107: -- within the date range (start_date, end_date) of the comp plan.
108: -- 8. No comp plan overlap for the any same sales role.
109: -- In other words, you can not have more than one comp plan for

Line 174: -- 8. New comp plan name must exist in cn_comp_plans already.

170: -- 3. New comp plan name can not be null.
171: -- 4. New start date can not be null.
172: -- 5. New start date <= new end date if new end date is not null.
173: -- 6. New role_name must exist in cn_roles already.
174: -- 8. New comp plan name must exist in cn_comp_plans already.
175: -- 9. The new date range (start_date, end_date) of the assignment must be
176: -- within the date range (start_date, end_date) of the comp plan.
177: -- 10. No comp plan overlap for the any same sales role.
178: -- In other words, you can not have more than one comp plan for