APPS.CN_HIERARCHY_EDGES_T2 dependencies on CN_MARK_EVENTS_PKG

Line 125: IF cn_mark_events_pkg.check_cls_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN

121: END IF;
122:
123: -- marking event here
124: FOR l_dim IN l_dim_hier_csr LOOP
125: IF cn_mark_events_pkg.check_cls_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN
126: cn_mark_events_pkg.mark_event_cls_hier
127: ('CHANGE_CLS_HIER', l_dim.name,
128: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
129: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);

Line 126: cn_mark_events_pkg.mark_event_cls_hier

122:
123: -- marking event here
124: FOR l_dim IN l_dim_hier_csr LOOP
125: IF cn_mark_events_pkg.check_cls_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN
126: cn_mark_events_pkg.mark_event_cls_hier
127: ('CHANGE_CLS_HIER', l_dim.name,
128: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
129: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);
130: ELSIF cn_mark_events_pkg.check_rev_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN

Line 130: ELSIF cn_mark_events_pkg.check_rev_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN

126: cn_mark_events_pkg.mark_event_cls_hier
127: ('CHANGE_CLS_HIER', l_dim.name,
128: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
129: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);
130: ELSIF cn_mark_events_pkg.check_rev_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN
131: cn_mark_events_pkg.mark_event_rc_hier
132: ('CHANGE_RC_HIER', l_dim.name,
133: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
134: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);

Line 131: cn_mark_events_pkg.mark_event_rc_hier

127: ('CHANGE_CLS_HIER', l_dim.name,
128: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
129: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);
130: ELSIF cn_mark_events_pkg.check_rev_hier(l_dim.head_hierarchy_id,l_dim.org_id) = 1 THEN
131: cn_mark_events_pkg.mark_event_rc_hier
132: ('CHANGE_RC_HIER', l_dim.name,
133: :old.dim_hierarchy_id, l_dim.head_hierarchy_id,
134: NULL, l_dim.start_date, NULL, l_dim.end_date,l_dim.org_id);
135: END IF;