APPS.CN_ROLE_PLANS_PUB dependencies on CN_ROLE_PLANS_S

Line 473: tmp_start_date cn_role_plans.start_date%TYPE;

469: x_loading_status OUT NOCOPY VARCHAR2
470: )
471: IS
472: l_api_name CONSTANT VARCHAR2 (30) := 'check_valid_update';
473: tmp_start_date cn_role_plans.start_date%TYPE;
474: tmp_end_date cn_role_plans.end_date%TYPE;
475:
476: -- CHANTHON: Adding ORG_ID.. This cursor is used to check for whether the
477: -- role id already exists for another role_plan_id. If it does then the date overlap is

Line 1395: SELECT cn_role_plans_s.NEXTVAL

1391: IF (x_return_status <> fnd_api.g_ret_sts_success)
1392: THEN
1393: RAISE fnd_api.g_exc_error;
1394: ELSE
1395: SELECT cn_role_plans_s.NEXTVAL
1396: INTO l_role_plan_id
1397: FROM DUAL;
1398:
1399: -- CHANTHON: Setting the role plan id out param