APPS.CN_ROLE_PMT_PLANS_PVT dependencies on CN_ROLE_PMT_PLANS_S

Line 368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;

364: x_loading_status OUT NOCOPY VARCHAR2
365: ) IS
366:
367: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_update';
368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;
369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;
370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS

Line 1130: SELECT cn_role_pmt_plans_s.NEXTVAL INTO l_role_pmt_plan_id

1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSE
1129:
1130: SELECT cn_role_pmt_plans_s.NEXTVAL INTO l_role_pmt_plan_id
1131: FROM dual;
1132:
1133: cn_role_pmt_plans_pkg.INSERT_ROW
1134: (