APPS.CN_ROLE_PLANS_T dependencies on CN_API

Line 14: l_role_name := cn_api.get_role_name(:OLD.role_id);

10: -- for deleting and inserting, pass in the start_date and end_date
11: -- as old_start_date and old_end_date
12:
13: IF DELETING THEN
14: l_role_name := cn_api.get_role_name(:OLD.role_id);
15: cn_mark_events_pkg.mark_event_role_plans(
16: 'CHANGE_SRP_ROLE_PLAN' -- event name
17: , l_role_name -- object name
18: , :OLD.role_id -- object id

Line 26: l_role_name := cn_api.get_role_name(:NEW.role_id);

22: , :OLD.end_date -- end date old
23: , :OLD.org_id
24: );
25: ELSIF INSERTING THEN
26: l_role_name := cn_api.get_role_name(:NEW.role_id);
27: cn_mark_events_pkg.mark_event_role_plans(
28: 'CHANGE_SRP_ROLE_PLAN' -- event name
29: , l_role_name -- object name
30: , :NEW.role_id -- object id

Line 41: l_role_name := cn_api.get_role_name(:OLD.role_id);

37: ELSE
38: -- If update role_id, comp_plan_id then mark event CHANGE_SRP_ROLE_PLAN
39: -- If update start_date or end_date then mark event CHANGE_SRP_ROLE_PLAN_DATE
40: IF (:NEW.role_id <> :OLD.role_id) OR(:NEW.comp_plan_id <> :OLD.comp_plan_id) THEN
41: l_role_name := cn_api.get_role_name(:OLD.role_id);
42: cn_mark_events_pkg.mark_event_role_plans(
43: 'CHANGE_SRP_ROLE_PLAN' -- event name
44: , l_role_name -- object name
45: , :OLD.role_id -- object id

Line 60: l_role_name := cn_api.get_role_name(:OLD.role_id);

56: OR (:NEW.end_date IS NOT NULL AND :OLD.end_date IS NULL)
57: OR (:NEW.end_date IS NULL AND :OLD.end_date IS NOT NULL) THEN
58: -- dbms_output.put_line('[cn_role_plans_t] fire for updating' ||
59: -- ' event:CHANGE_SRP_ROLE_PLAN_DATE');
60: l_role_name := cn_api.get_role_name(:OLD.role_id);
61: cn_mark_events_pkg.mark_event_role_plans(
62: 'CHANGE_SRP_ROLE_PLAN_DATE' -- event name
63: , l_role_name -- object name
64: , :OLD.role_id -- object id