48: (
49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
49: ROLE_PLAN_ID CN_ROLE_PLANS.ROLE_PLAN_ID%TYPE := CN_API.G_MISS_ID,
50: ROLE_ID CN_ROLE_PLANS.ROLE_ID%TYPE := CN_API.G_MISS_ID,
51: COMP_PLAN_ID CN_ROLE_PLANS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
52: NAME CN_ROLES.NAME%TYPE := FND_API.G_MISS_CHAR,
53: DESCRIPTION CN_ROLES.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
54: START_DATE CN_ROLE_PLANS.START_DATE%TYPE := FND_API.G_MISS_DATE,
55: END_DATE CN_ROLE_PLANS.END_DATE%TYPE := FND_API.G_MISS_DATE,
56: OBJECT_VERSION_NUMBER CN_ROLE_PLANS.OBJECT_VERSION_NUMBER%TYPE := NULL
57: ) ;
63: TYPE srp_plan_assign_rec_type IS RECORD
64: (srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE,
65: salesrep_id CN_SRP_PLAN_ASSIGNS.SALESREP_ID%TYPE,
66: role_id CN_SRP_PLAN_ASSIGNS.ROLE_ID%TYPE,
67: role_name CN_ROLES.NAME%TYPE,
68: salesrep_name CN_SALESREPS.NAME%TYPE,
69: employee_number CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
70: start_date CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
71: end_date CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE);