APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on CN_ROLES

Line 281: l_role_id cn_roles.role_id%TYPE;

277:
278: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Plan_Assigns';
279: l_api_version CONSTANT NUMBER := 1.0;
280: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
281: l_role_id cn_roles.role_id%TYPE;
282: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
283:
284: l_temp_count NUMBER;
285: l_temp_start_date DATE;

Line 499: l_role_id cn_roles.role_id%TYPE;

495:
496: l_api_name CONSTANT VARCHAR2(30) := 'Update_Srp_Plan_Assigns';
497: l_api_version CONSTANT NUMBER := 1.0;
498: l_spa_row cn_srp_plan_assigns%ROWTYPE ;
499: l_role_id cn_roles.role_id%TYPE;
500: l_old_start_date cn_srp_plan_assigns.start_date%TYPE;
501: l_old_end_date cn_srp_plan_assigns.end_date%TYPE;
502: l_srp_plan_assigns_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
503: