APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_MARK_EVENTS_PKG

Line 816: cn_mark_events_pkg.mark_notify_salesreps

812: l_revert_to_state := 'NCALC';
813: l_action := 'SOURCE_CLS';
814: END IF;
815:
816: cn_mark_events_pkg.mark_notify_salesreps
817: (p_salesrep_id => p_salesrep_id,
818: p_org_id => l_org_id,
819: p_comp_group_id => p_group_id,
820: p_period_id => null,

Line 846: cn_mark_events_pkg.mark_notify_salesreps

842: END IF;
843:
844: -- for each period active for this salesrep, call mark_notify_salesrep
845: FOR prd IN periods(p_salesrep_id, p_start_date, p_end_date) LOOP
846: cn_mark_events_pkg.mark_notify_salesreps
847: (p_salesrep_id => p_salesrep_id,
848: p_org_id => l_org_id,
849: p_comp_group_id => p_group_id,
850: p_period_id => prd.period_id,

Line 886: cn_mark_events_pkg.mark_notify_salesreps

882: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
883: FOR prd IN periods(l_srp_tbl(i).salesrep_id,
884: l_srp_tbl(i).start_date,
885: l_srp_tbl(i).end_date) LOOP
886: cn_mark_events_pkg.mark_notify_salesreps
887: (p_salesrep_id => l_srp_tbl(i).salesrep_id,
888: p_org_id => l_org_id,
889: p_comp_group_id => l_srp_tbl(i).group_id,
890: p_period_id => prd.period_id,

Line 1231: cn_mark_events_pkg.mark_notify_team

1227: else
1228: l_team_event_name := 'CHANGE_TEAM_DEL_REP';
1229: end if;
1230:
1231: cn_mark_events_pkg.mark_notify_team
1232: (P_TEAM_ID => l_team_id,
1233: P_TEAM_EVENT_NAME => l_team_event_name,
1234: P_TEAM_NAME => l_team_name,
1235: P_START_DATE_ACTIVE => l_date_range_action_tbl(i).start_date,

Line 1261: cn_mark_events_pkg.log_event

1257: ELSE
1258: l_event_name := 'CHANGE_CP_ADD_MGR';
1259: END IF;
1260:
1261: cn_mark_events_pkg.log_event
1262: (p_event_name => l_event_name,
1263: p_object_name => NULL,
1264: p_object_id => p_role_relate_id,
1265: p_start_date => p_start_date_active,

Line 1289: cn_mark_events_pkg.mark_notify_team

1285: if srp_tm_rec.end_date = l_max_date then
1286: srp_tm_rec.end_date := null;
1287: end if;
1288:
1289: cn_mark_events_pkg.mark_notify_team
1290: (P_TEAM_ID => srp_tm_rec.team_id ,
1291: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
1292: P_TEAM_NAME => srp_tm_rec.name,
1293: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 1663: cn_mark_events_pkg.mark_notify_team

1659: if l_date_range_action_tbl(i).action_flag = 'I' THEN
1660:
1661: l_team_event_name := 'CHANGE_TEAM_ADD_REP';
1662:
1663: cn_mark_events_pkg.mark_notify_team
1664: (P_TEAM_ID => g_team_id,
1665: P_TEAM_EVENT_NAME => l_team_event_name,
1666: P_TEAM_NAME => g_team_name,
1667: P_START_DATE_ACTIVE => l_date_range_action_tbl(i).start_date,

Line 1709: cn_mark_events_pkg.mark_notify_team

1705: if srp_tm_rec.end_date = l_max_date then
1706: srp_tm_rec.end_date := null;
1707: end if;
1708:
1709: cn_mark_events_pkg.mark_notify_team
1710: (P_TEAM_ID => srp_tm_rec.team_id ,
1711: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
1712: P_TEAM_NAME => srp_tm_rec.name,
1713: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 1746: cn_mark_events_pkg.mark_notify_team

1742: if srp_tm_rec.end_date = l_max_date then
1743: srp_tm_rec.end_date := null;
1744: end if;
1745:
1746: cn_mark_events_pkg.mark_notify_team
1747: (P_TEAM_ID => srp_tm_rec.team_id ,
1748: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
1749: P_TEAM_NAME => srp_tm_rec.name,
1750: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 2046: cn_mark_events_pkg.mark_notify_team

2042: else
2043: l_team_event_name := 'CHANGE_TEAM_DEL_REP';
2044: end if;
2045:
2046: cn_mark_events_pkg.mark_notify_team
2047: (P_TEAM_ID => l_team_id,
2048: P_TEAM_EVENT_NAME => l_team_event_name,
2049: P_TEAM_NAME => l_team_name,
2050: P_START_DATE_ACTIVE => l_date_range_action_tbl(i).start_date,

Line 2077: cn_mark_events_pkg.log_event

2073: ELSE
2074: l_event_name := 'CHANGE_CP_DELETE_MGR';
2075: END IF;
2076:
2077: cn_mark_events_pkg.log_event
2078: (p_event_name => l_event_name,
2079: p_object_name => NULL,
2080: p_object_id => p_role_relate_id,
2081: p_start_date => NULL,

Line 2106: cn_mark_events_pkg.mark_notify_team

2102: if srp_tm_rec.end_date = l_max_date then
2103: srp_tm_rec.end_date := null;
2104: end if;
2105:
2106: cn_mark_events_pkg.mark_notify_team
2107: (P_TEAM_ID => srp_tm_rec.team_id ,
2108: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
2109: P_TEAM_NAME => srp_tm_rec.name,
2110: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 2372: cn_mark_events_pkg.mark_notify_team

2368: if l_date_range_action_tbl(i).action_flag = 'D' THEN
2369:
2370: l_team_event_name := 'CHANGE_TEAM_DEL_REP';
2371:
2372: cn_mark_events_pkg.mark_notify_team
2373: (P_TEAM_ID => g_team_id,
2374: P_TEAM_EVENT_NAME => l_team_event_name,
2375: P_TEAM_NAME => g_team_name,
2376: P_START_DATE_ACTIVE => l_date_range_action_tbl(i).start_date,

Line 2417: cn_mark_events_pkg.log_event

2413: else
2414: l_res_start_date := p_start_date_active;
2415: end if;
2416: -- end of code addition
2417: cn_mark_events_pkg.log_event
2418: (p_event_name => l_event_name,
2419: p_object_name => NULL,
2420: p_object_id => p_role_relate_id,
2421: p_start_date => l_res_start_date,--parameter changed for bug 6914823

Line 2456: cn_mark_events_pkg.mark_notify_team

2452: if srp_tm_rec.end_date = l_max_date then
2453: srp_tm_rec.end_date := null;
2454: end if;
2455:
2456: cn_mark_events_pkg.mark_notify_team
2457: (P_TEAM_ID => srp_tm_rec.team_id ,
2458: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
2459: P_TEAM_NAME => srp_tm_rec.name,
2460: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 2498: cn_mark_events_pkg.mark_notify_team

2494: if srp_tm_rec.end_date = l_max_date then
2495: srp_tm_rec.end_date := null;
2496: end if;
2497:
2498: cn_mark_events_pkg.mark_notify_team
2499: (P_TEAM_ID => srp_tm_rec.team_id ,
2500: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
2501: P_TEAM_NAME => srp_tm_rec.name,
2502: P_START_DATE_ACTIVE => srp_tm_rec.start_date,