APPS.CN_API dependencies on CN_ROLE_PLANS

Line 1323: ) RETURN cn_role_plans.role_plan_id%TYPE IS

1319: p_comp_plan_name IN VARCHAR2,
1320: p_start_date IN DATE,
1321: p_end_date IN DATE,
1322: p_org_id IN NUMBER
1323: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1324:
1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,

Line 1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,

1321: p_end_date IN DATE,
1322: p_org_id IN NUMBER
1323: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1324:
1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,
1328: l_end_date cn_role_plans.end_date%TYPE) IS
1329: SELECT role_plan_id

Line 1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,

1322: p_org_id IN NUMBER
1323: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1324:
1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,
1328: l_end_date cn_role_plans.end_date%TYPE) IS
1329: SELECT role_plan_id
1330: FROM cn_role_plans

Line 1327: l_start_date cn_role_plans.start_date%TYPE,

1323: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1324:
1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,
1328: l_end_date cn_role_plans.end_date%TYPE) IS
1329: SELECT role_plan_id
1330: FROM cn_role_plans
1331: WHERE role_id = l_role_id AND

Line 1328: l_end_date cn_role_plans.end_date%TYPE) IS

1324:
1325: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,
1328: l_end_date cn_role_plans.end_date%TYPE) IS
1329: SELECT role_plan_id
1330: FROM cn_role_plans
1331: WHERE role_id = l_role_id AND
1332: comp_plan_id = l_comp_plan_id AND

Line 1330: FROM cn_role_plans

1326: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1327: l_start_date cn_role_plans.start_date%TYPE,
1328: l_end_date cn_role_plans.end_date%TYPE) IS
1329: SELECT role_plan_id
1330: FROM cn_role_plans
1331: WHERE role_id = l_role_id AND
1332: comp_plan_id = l_comp_plan_id AND
1333: start_date = l_start_date AND
1334: ((end_date = l_end_date) OR

Line 1338: l_role_id cn_role_plans.role_id%TYPE;

1334: ((end_date = l_end_date) OR
1335: (end_date IS NULL AND l_end_date IS NULL));
1336:
1337: l_rec l_cur%ROWTYPE;
1338: l_role_id cn_role_plans.role_id%TYPE;
1339: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1340:
1341: BEGIN
1342:

Line 1339: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;

1335: (end_date IS NULL AND l_end_date IS NULL));
1336:
1337: l_rec l_cur%ROWTYPE;
1338: l_role_id cn_role_plans.role_id%TYPE;
1339: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1340:
1341: BEGIN
1342:
1343: l_role_id := cn_api.get_role_id(p_role_name);