eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on CN_MARK_EVENTS_PKG

Line 139: cn_mark_events_pkg.log_event

135: CLOSE group_name;
136: ELSE
137: CLOSE group_name;
138:
139: cn_mark_events_pkg.log_event
140: ( p_event_name => 'CHANGE_CP_HIER_DATE',
141: p_object_name => l_group_name,
142: p_object_id => g_group_id,
143: p_start_date => p_start_date_active,

Line 175: cn_mark_events_pkg.mark_notify_salesreps

171: p_org_id => o.org_id,
172: x_srp => l_srp_tbl);
173:
174: IF (l_srp_tbl.COUNT > 0) THEN
175: cn_mark_events_pkg.mark_notify_salesreps
176: ( p_salesrep_id => NULL,
177: p_comp_group_id => l_srp.group_id,
178: p_period_id => null,
179: p_start_date => l_srp.start_date,

Line 192: cn_mark_events_pkg.mark_notify_salesreps

188: p_org_id => o.org_id);
189:
190: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
191: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
192: cn_mark_events_pkg.mark_notify_salesreps
193: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
194: p_comp_group_id => l_srp_tbl(i).group_id,
195: p_period_id => prd.period_id,
196: p_start_date => prd.start_date,

Line 215: cn_mark_events_pkg.mark_notify_team

211: if srp_gp_tm_rec.end_date = l_max_date then
212: srp_gp_tm_rec.end_date := NULL;
213: end if;
214:
215: cn_mark_events_pkg.mark_notify_team
216: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
217: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
218: P_TEAM_NAME => srp_gp_tm_rec.name,
219: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 253: cn_mark_events_pkg.mark_notify_salesreps

249: p_org_id => o.org_id,
250: x_srp => l_srp_tbl);
251:
252: IF (l_srp_tbl.COUNT > 0) THEN
253: cn_mark_events_pkg.mark_notify_salesreps
254: ( p_salesrep_id => NULL,
255: p_comp_group_id => l_srp.group_id,
256: p_period_id => null,
257: p_start_date => l_srp.start_date,

Line 271: cn_mark_events_pkg.mark_notify_salesreps

267:
268: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
269: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
270:
271: cn_mark_events_pkg.mark_notify_salesreps
272: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
273: p_comp_group_id => l_srp_tbl(i).group_id,
274: p_period_id => prd.period_id,
275: p_start_date => prd.start_date,

Line 294: cn_mark_events_pkg.mark_notify_team

290: if srp_gp_tm_rec.end_date = l_max_date then
291: srp_gp_tm_rec.end_date := NULL;
292: end if;
293:
294: cn_mark_events_pkg.mark_notify_team
295: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
296: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
297: P_TEAM_NAME => srp_gp_tm_rec.name,
298: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 431: cn_mark_events_pkg.log_event

427: CLOSE group_name;
428: ELSE
429: CLOSE group_name;
430:
431: cn_mark_events_pkg.log_event
432: ( p_event_name => 'CHANGE_CP_HIER_DELETE',
433: p_object_name => l_group_name,
434: p_object_id => l_group_id,
435: p_start_date => NULL,

Line 442: cn_mark_events_pkg.mark_notify_salesreps

438: p_end_date_old => l_end_date,
439: x_event_log_id => l_event_log_id,
440: p_org_id => o.org_id);
441:
442: cn_mark_events_pkg.mark_notify_salesreps
443: ( p_salesrep_id => NULL,
444: p_comp_group_id => l_group_id,
445: p_period_id => null,
446: p_start_date => l_start_date,

Line 464: cn_mark_events_pkg.mark_notify_team

460: if srp_gp_tm_rec.end_date = l_max_date then
461: srp_gp_tm_rec.end_date := null;
462: end if;
463:
464: cn_mark_events_pkg.mark_notify_team
465: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
466: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
467: P_TEAM_NAME => srp_gp_tm_rec.name,
468: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 496: cn_mark_events_pkg.mark_notify_salesreps

492:
493: IF (l_srp_tbl.COUNT > 0) THEN
494: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
495: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
496: cn_mark_events_pkg.mark_notify_salesreps
497: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
498: p_comp_group_id => l_srp_tbl(i).group_id,
499: p_period_id => prd.period_id,
500: p_start_date => prd.start_date,

Line 519: cn_mark_events_pkg.mark_notify_team

515: if srp_gp_tm_rec.end_date = l_max_date then
516: srp_gp_tm_rec.end_date := null;
517: end if;
518:
519: cn_mark_events_pkg.mark_notify_team
520: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
521: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_DEL_REP',
522: P_TEAM_NAME => srp_gp_tm_rec.name,
523: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 655: cn_mark_events_pkg.log_event

651: CLOSE group_name;
652: ELSE
653: CLOSE group_name;
654:
655: cn_mark_events_pkg.log_event
656: ( p_event_name => 'CHANGE_CP_HIER_ADD',
657: p_object_name => l_group_name,
658: p_object_id => p_group_id,
659: p_start_date => p_start_date_active,

Line 666: cn_mark_events_pkg.mark_notify_salesreps

662: p_end_date_old => NULL,
663: x_event_log_id => l_event_log_id,
664: p_org_id => o.org_id);
665:
666: cn_mark_events_pkg.mark_notify_salesreps
667: ( p_salesrep_id => NULL,
668: p_comp_group_id => p_group_id,
669: p_period_id => null,
670: p_start_date => p_start_date_active,

Line 688: cn_mark_events_pkg.mark_notify_team

684: if srp_gp_tm_rec.end_date = l_max_date then
685: srp_gp_tm_rec.end_date := null;
686: end if;
687:
688: cn_mark_events_pkg.mark_notify_team
689: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
690: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
691: P_TEAM_NAME => srp_gp_tm_rec.name,
692: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 721: cn_mark_events_pkg.mark_notify_salesreps

717:
718: IF (l_srp_tbl.COUNT > 0) THEN
719: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
720: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
721: cn_mark_events_pkg.mark_notify_salesreps
722: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
723: p_comp_group_id => l_srp_tbl(i).group_id,
724: p_period_id => prd.period_id,
725: p_start_date => prd.start_date,

Line 744: cn_mark_events_pkg.mark_notify_team

740: if srp_gp_tm_rec.end_date = l_max_date then
741: srp_gp_tm_rec.end_date := null;
742: end if;
743:
744: cn_mark_events_pkg.mark_notify_team
745: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
746: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
747: P_TEAM_NAME => srp_gp_tm_rec.name,
748: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 853: cn_mark_events_pkg.mark_notify_salesreps

849: -- loop through orgs
850: FOR o IN get_orgs LOOP
851: mo_global.set_policy_context('S', o.org_id);
852:
853: cn_mark_events_pkg.mark_notify_salesreps
854: ( p_salesrep_id => NULL,
855: p_comp_group_id => g_group_id,
856: p_period_id => null,
857: p_start_date => p_start_date_active,

Line 895: cn_mark_events_pkg.mark_notify_salesreps

891:
892: IF (l_srp_tbl.COUNT > 0) THEN
893: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
894: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
895: cn_mark_events_pkg.mark_notify_salesreps
896: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
897: p_comp_group_id => l_srp_tbl(i).group_id,
898: p_period_id => prd.period_id,
899: p_start_date => prd.start_date,

Line 918: cn_mark_events_pkg.mark_notify_team

914: if srp_gp_tm_rec.end_date = l_max_date then
915: srp_gp_tm_rec.end_date := null;
916: end if;
917:
918: cn_mark_events_pkg.mark_notify_team
919: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
920: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
921: P_TEAM_NAME => srp_gp_tm_rec.name,
922: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,

Line 958: cn_mark_events_pkg.mark_notify_salesreps

954:
955: IF (l_srp_tbl.COUNT > 0) THEN
956: FOR i IN l_srp_tbl.first..l_srp_tbl.last LOOP
957: FOR prd IN periods(l_srp_tbl(i).salesrep_id, l_srp_tbl(i).start_date, l_srp_tbl(i).end_date) LOOP
958: cn_mark_events_pkg.mark_notify_salesreps
959: ( p_salesrep_id => l_srp_tbl(i).salesrep_id,
960: p_comp_group_id => l_srp_tbl(i).group_id,
961: p_period_id => prd.period_id,
962: p_start_date => prd.start_date,

Line 981: cn_mark_events_pkg.mark_notify_team

977: if srp_gp_tm_rec.end_date = l_max_date then
978: srp_gp_tm_rec.end_date := null;
979: end if;
980:
981: cn_mark_events_pkg.mark_notify_team
982: (P_TEAM_ID => srp_gp_tm_rec.team_id ,
983: P_TEAM_EVENT_NAME => 'CHANGE_TEAM_ADD_REP',
984: P_TEAM_NAME => srp_gp_tm_rec.name,
985: P_START_DATE_ACTIVE => srp_gp_tm_rec.start_date,