APPS.CN_DIM_HIERARCHIES_T2 dependencies on CN_MARK_EVENTS_PKG

Line 54: IF cn_mark_events_pkg.check_cls_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN

50: from cn_head_hierarchies headHier -- MOAC
51: where head_hierarchy_id = :new.header_dim_hierarchy_id
52: AND headHier.org_id = :new.org_id;
53:
54: IF cn_mark_events_pkg.check_cls_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN
55: cn_mark_events_pkg.mark_event_cls_hier
56: ('CHANGE_CLS_HIER_DATE', x_head_name,
57: :new.dim_hierarchy_id, :NEW.header_dim_hierarchy_id,
58: :new.start_date, :old.start_date,

Line 55: cn_mark_events_pkg.mark_event_cls_hier

51: where head_hierarchy_id = :new.header_dim_hierarchy_id
52: AND headHier.org_id = :new.org_id;
53:
54: IF cn_mark_events_pkg.check_cls_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN
55: cn_mark_events_pkg.mark_event_cls_hier
56: ('CHANGE_CLS_HIER_DATE', x_head_name,
57: :new.dim_hierarchy_id, :NEW.header_dim_hierarchy_id,
58: :new.start_date, :old.start_date,
59: :new.end_date, :old.end_date,:new.org_id);

Line 61: ELSIF cn_mark_events_pkg.check_rev_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN

57: :new.dim_hierarchy_id, :NEW.header_dim_hierarchy_id,
58: :new.start_date, :old.start_date,
59: :new.end_date, :old.end_date,:new.org_id);
60:
61: ELSIF cn_mark_events_pkg.check_rev_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN
62: cn_mark_events_pkg.mark_event_rc_hier
63: ('CHANGE_RC_HIER_DATE', x_head_name,
64: :new.dim_hierarchy_id,:NEW.header_dim_hierarchy_id,
65: :new.start_date, :old.start_date,

Line 62: cn_mark_events_pkg.mark_event_rc_hier

58: :new.start_date, :old.start_date,
59: :new.end_date, :old.end_date,:new.org_id);
60:
61: ELSIF cn_mark_events_pkg.check_rev_hier(:new.header_dim_hierarchy_id,:new.org_id) = 1 THEN
62: cn_mark_events_pkg.mark_event_rc_hier
63: ('CHANGE_RC_HIER_DATE', x_head_name,
64: :new.dim_hierarchy_id,:NEW.header_dim_hierarchy_id,
65: :new.start_date, :old.start_date,
66: :new.end_date, :old.end_date,:new.org_id);