APPS.CN_API dependencies on CN_ROLE_PLANS

Line 1301: ) RETURN cn_role_plans.role_plan_id%TYPE IS

1297: p_comp_plan_name IN VARCHAR2,
1298: p_start_date IN DATE,
1299: p_end_date IN DATE,
1300: p_org_id IN NUMBER
1301: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1302:
1303: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,

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

1299: p_end_date IN DATE,
1300: p_org_id IN NUMBER
1301: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1302:
1303: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,
1306: l_end_date cn_role_plans.end_date%TYPE) IS
1307: SELECT role_plan_id

Line 1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,

1300: p_org_id IN NUMBER
1301: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1302:
1303: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,
1306: l_end_date cn_role_plans.end_date%TYPE) IS
1307: SELECT role_plan_id
1308: FROM cn_role_plans

Line 1305: l_start_date cn_role_plans.start_date%TYPE,

1301: ) RETURN cn_role_plans.role_plan_id%TYPE IS
1302:
1303: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,
1306: l_end_date cn_role_plans.end_date%TYPE) IS
1307: SELECT role_plan_id
1308: FROM cn_role_plans
1309: WHERE role_id = l_role_id AND

Line 1306: l_end_date cn_role_plans.end_date%TYPE) IS

1302:
1303: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,
1306: l_end_date cn_role_plans.end_date%TYPE) IS
1307: SELECT role_plan_id
1308: FROM cn_role_plans
1309: WHERE role_id = l_role_id AND
1310: comp_plan_id = l_comp_plan_id AND

Line 1308: FROM cn_role_plans

1304: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE,
1305: l_start_date cn_role_plans.start_date%TYPE,
1306: l_end_date cn_role_plans.end_date%TYPE) IS
1307: SELECT role_plan_id
1308: FROM cn_role_plans
1309: WHERE role_id = l_role_id AND
1310: comp_plan_id = l_comp_plan_id AND
1311: start_date = l_start_date AND
1312: ((end_date = l_end_date) OR

Line 1316: l_role_id cn_role_plans.role_id%TYPE;

1312: ((end_date = l_end_date) OR
1313: (end_date IS NULL AND l_end_date IS NULL));
1314:
1315: l_rec l_cur%ROWTYPE;
1316: l_role_id cn_role_plans.role_id%TYPE;
1317: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1318:
1319: BEGIN
1320:

Line 1317: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;

1313: (end_date IS NULL AND l_end_date IS NULL));
1314:
1315: l_rec l_cur%ROWTYPE;
1316: l_role_id cn_role_plans.role_id%TYPE;
1317: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1318:
1319: BEGIN
1320:
1321: l_role_id := cn_api.get_role_id(p_role_name);