DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_T dependencies on CN_MARK_EVENTS_PKG

Line 15: cn_mark_events_pkg.mark_event_role_plans(

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
19: , NULL -- start date

Line 27: cn_mark_events_pkg.mark_event_role_plans(

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
31: , NULL -- start date

Line 42: cn_mark_events_pkg.mark_event_role_plans(

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
46: , :NEW.start_date -- start date

Line 61: cn_mark_events_pkg.mark_event_role_plans(

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
65: , :NEW.start_date -- start date