DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_MARK_EVENTS_PKG

Line 126: cn_mark_events_pkg.log_event

122: CLOSE dates;
123: ELSE
124: CLOSE dates;
125:
126: cn_mark_events_pkg.log_event
127: ( p_event_name => 'CHANGE_CP_HIER_ADD',
128: p_object_name => l_group_name,
129: p_object_id => p_group_id,
130: p_start_date => l_start_date,

Line 136: cn_mark_events_pkg.mark_notify_salesreps

132: p_end_date => l_end_date,
133: p_end_date_old => NULL,
134: x_event_log_id => l_event_log_id,
135: p_org_id => o.org_id);
136: cn_mark_events_pkg.mark_notify_salesreps
137: ( p_salesrep_id => NULL,
138: p_comp_group_id => p_group_id,
139: p_period_id => null,
140: p_start_date => l_start_date,

Line 161: cn_mark_events_pkg.mark_notify_salesreps

157: l_srp.salesrep_id := srp_period.salesrep_id;
158: l_srp.group_id := srp_period.comp_group_id;
159: i := i + 1;
160: END IF;
161: cn_mark_events_pkg.mark_notify_salesreps
162: ( p_salesrep_id => srp_period.salesrep_id,
163: p_comp_group_id => srp_period.comp_group_id,
164: p_period_id => srp_period.period_id,
165: p_start_date => srp_period.start_date,

Line 183: cn_mark_events_pkg.mark_notify_team

179: if srp_tm_rec.end_date = l_max_date then
180: srp_tm_rec.end_date := null;
181: end if;
182:
183: cn_mark_events_pkg.mark_notify_team
184: (P_TEAM_ID => srp_tm_rec.team_id ,
185: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
186: P_TEAM_NAME => srp_tm_rec.name,
187: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 214: cn_mark_events_pkg.mark_notify_salesreps

210:
211: IF (l_srp_tbl.COUNT > 0) THEN
212: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
213: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
214: cn_mark_events_pkg.mark_notify_salesreps
215: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
216: p_comp_group_id => l_srp_tbl(i).group_id,
217: p_period_id => prd.period_id,
218: p_start_date => prd.start_date,

Line 236: cn_mark_events_pkg.mark_notify_team

232: if srp_tm_rec.end_date = l_max_date then
233: srp_tm_rec.end_date := null;
234: end if;
235:
236: cn_mark_events_pkg.mark_notify_team
237: (P_TEAM_ID => srp_tm_rec.team_id ,
238: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
239: P_TEAM_NAME => srp_tm_rec.name,
240: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 371: cn_mark_events_pkg.log_event

367: CLOSE dates;
368: ELSE
369: CLOSE dates;
370:
371: cn_mark_events_pkg.log_event
372: ( p_event_name => 'CHANGE_CP_HIER_DELETE',
373: p_object_name => l_group_name,
374: p_object_id => p_group_id,
375: p_start_date => l_start_date,

Line 393: cn_mark_events_pkg.mark_notify_salesreps

389: l_srp.group_id := srp_period.comp_group_id;
390: i := i + 1;
391: END IF;
392:
393: cn_mark_events_pkg.mark_notify_salesreps
394: ( p_salesrep_id => srp_period.salesrep_id,
395: p_comp_group_id => srp_period.comp_group_id,
396: p_period_id => srp_period.period_id,
397: p_start_date => srp_period.start_date,

Line 415: cn_mark_events_pkg.mark_notify_team

411: if srp_tm_rec.end_date = l_max_date then
412: srp_tm_rec.end_date := null;
413: end if;
414:
415: cn_mark_events_pkg.mark_notify_team
416: (P_TEAM_ID => srp_tm_rec.team_id ,
417: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
418: P_TEAM_NAME => srp_tm_rec.name,
419: P_START_DATE_ACTIVE => srp_tm_rec.start_date,

Line 446: cn_mark_events_pkg.mark_notify_salesreps

442:
443: IF (l_srp_tbl.COUNT > 0) THEN
444: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
445: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
446: cn_mark_events_pkg.mark_notify_salesreps
447: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
448: p_comp_group_id => l_srp_tbl(i).group_id,
449: p_period_id => prd.period_id,
450: p_start_date => prd.start_date,

Line 469: cn_mark_events_pkg.mark_notify_team

465: if srp_tm_rec.end_date = l_max_date then
466: srp_tm_rec.end_date := null;
467: end if;
468:
469: cn_mark_events_pkg.mark_notify_team
470: (P_TEAM_ID => srp_tm_rec.team_id ,
471: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
472: P_TEAM_NAME => srp_tm_rec.name,
473: P_START_DATE_ACTIVE => srp_tm_rec.start_date,