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.BEN_COLLAPSE_LIFE_EVENT dependencies on HR_UTILITY

Line 70: hr_utility.set_location('Entering '||l_proc,10);

66: l_object_version_number number(15);
67: --
68: begin
69: --
70: hr_utility.set_location('Entering '||l_proc,10);
71: --
72: -- Clear g_events table cache
73: --
74: g_events.delete;

Line 79: hr_utility.set_location('Entering after last',11);

75: --
76: open c_events;
77: --
78: l_counter := nvl(g_events.last, 0);
79: hr_utility.set_location('Entering after last',11);
80: loop
81: --
82: fetch c_events into l_events;
83: exit when c_events%notfound;

Line 94: hr_utility.set_location('Entering before assign',11);

90: l_lf_evt_ocrd_dt := l_events.lf_evt_ocrd_dt;
91: l_ntfn_dt := l_events.ntfn_dt;
92: l_object_version_number := l_events.object_version_number;
93: l_counter := l_counter + 1;
94: hr_utility.set_location('Entering before assign',11);
95: /*
96: g_events(l_counter) := l_events;
97: */
98: g_events(l_counter).ptnl_ler_for_per_id := l_ptnl_ler_for_per_id;

Line 104: hr_utility.set_location('Entering after assign',11);

100: g_events(l_counter).ptnl_ler_for_per_stat_cd := l_ptnl_ler_for_per_stat_cd;
101: g_events(l_counter).lf_evt_ocrd_dt := l_lf_evt_ocrd_dt;
102: g_events(l_counter).ntfn_dt := l_ntfn_dt;
103: g_events(l_counter).object_version_number := l_object_version_number;
104: hr_utility.set_location('Entering after assign',11);
105: /*
106: Bug 1975925
107: if g_events.exists(1) then
108: --

Line 122: hr_utility.set_location('Leaving '||l_proc,10);

118: end loop;
119: --
120: close c_events;
121: --
122: hr_utility.set_location('Leaving '||l_proc,10);
123: --
124: end build_life_event_set;
125: --
126: function included_in_events(p_ler_id in number) return date is

Line 133: hr_utility.set_location('Entering '||l_proc,10);

129: l_date date;
130: --
131: begin
132: --
133: hr_utility.set_location('Entering '||l_proc,10);
134: --
135: -- If the life event is in the set of included life events then return the
136: -- earliest life event occurred date within the set.
137: --

Line 148: hr_utility.set_location('Leaving '||l_proc,10);

144: end if;
145: --
146: end loop;
147: --
148: hr_utility.set_location('Leaving '||l_proc,10);
149: --
150: return null;
151: --
152: end included_in_events;

Line 162: hr_utility.set_location('Entering '||l_proc,10);

158: l_proc varchar2(80) := g_package||'get_first_date';
159: --
160: begin
161: --
162: hr_utility.set_location('Entering '||l_proc,10);
163: --
164: for l_count in g_included_events.first..g_included_events.last loop
165: --
166: if g_included_events(l_count).ler_id in

Line 173: hr_utility.set_location('Leaving '||l_proc,10);

169: p_events.ler5_id,p_events.ler6_id,
170: p_events.ler7_id,p_events.ler8_id,
171: p_events.ler9_id,p_events.ler10_id) then
172: --
173: hr_utility.set_location('Leaving '||l_proc,10);
174: --
175: return g_included_events(l_count).lf_evt_ocrd_dt;
176: --
177: exit;

Line 195: hr_utility.set_location('Entering '||l_proc,10);

191: l_proc varchar2(80) := g_package||'get_last_date';
192: --
193: begin
194: --
195: hr_utility.set_location('Entering '||l_proc,10);
196: --
197: for l_count in reverse g_included_events.first..g_included_events.last loop
198: --
199: if g_included_events(l_count).ler_id in

Line 206: hr_utility.set_location('Leaving '||l_proc,10);

202: p_events.ler5_id,p_events.ler6_id,
203: p_events.ler7_id,p_events.ler8_id,
204: p_events.ler9_id,p_events.ler10_id) then
205: --
206: hr_utility.set_location('Leaving '||l_proc,10);
207: --
208: return g_included_events(l_count).lf_evt_ocrd_dt;
209: exit;
210: --

Line 275: hr_utility.set_location('Entering '||l_proc,10);

271: --End 6086392
272:
273: begin
274: --
275: hr_utility.set_location('Entering '||l_proc,10);
276: --
277: -- First set operation to event collision method
278: --
279: if p_events.eval_cd = 'RL' then

Line 446: hr_utility.set_location('Backout All Future PILs ', 50);

442: open c1(g_included_events(l_count).ptnl_ler_for_per_id);
443: fetch c1 into l_per_in_ler_id, l_c1_lf_evt_ocrd_dt;
444: close c1;
445: --
446: hr_utility.set_location('Backout All Future PILs ', 50);
447: --
448: -- 5677090 Backout LE shud be called in reverse order of occurance.
449: -- Before backing out the LEs with same ocrd-dt, we shud backout all future
450: -- LEs. Lets make them 'Unprocessed'.

Line 456: hr_utility.set_location('per_in_ler_id ' || l_pil_rec.per_in_ler_id, 50);

452: --
453: open get_all_fut_pils(l_c1_lf_evt_ocrd_dt, l_per_in_ler_id);
454: loop
455: --
456: hr_utility.set_location('per_in_ler_id ' || l_pil_rec.per_in_ler_id, 50);
457: hr_utility.set_location('lf_evt_ocrd_dt ' || l_pil_rec.lf_evt_ocrd_dt, 50);
458: --
459: fetch get_all_fut_pils into l_pil_rec;
460: exit when get_all_fut_pils%notfound;

Line 457: hr_utility.set_location('lf_evt_ocrd_dt ' || l_pil_rec.lf_evt_ocrd_dt, 50);

453: open get_all_fut_pils(l_c1_lf_evt_ocrd_dt, l_per_in_ler_id);
454: loop
455: --
456: hr_utility.set_location('per_in_ler_id ' || l_pil_rec.per_in_ler_id, 50);
457: hr_utility.set_location('lf_evt_ocrd_dt ' || l_pil_rec.lf_evt_ocrd_dt, 50);
458: --
459: fetch get_all_fut_pils into l_pil_rec;
460: exit when get_all_fut_pils%notfound;
461: --

Line 582: hr_utility.set_location('Leaving '||l_proc,10);

578: p_program_update_date => sysdate);
579: --
580:
581:
582: hr_utility.set_location('Leaving '||l_proc,10);
583: --
584: end perform_collapse;
585: --
586: procedure add_to_included(p_rec in g_events_rec) is

Line 592: hr_utility.set_location('Entering '||l_proc,10);

588: l_proc varchar2(80) := g_package||'add_to_include';
589: --
590: begin
591: --
592: hr_utility.set_location('Entering '||l_proc,10);
593: --
594: -- Add record into included list. This is the list from which we will be
595: -- voiding or deleteing record from.
596: --

Line 607: hr_utility.set_location('Leaving '||l_proc,10);

603: g_included_events(1) := p_rec;
604: --
605: end if;
606: --
607: hr_utility.set_location('Leaving '||l_proc,10);
608: --
609: end add_to_included;
610: --
611: procedure add_expression(p_value in varchar2,

Line 655: hr_utility.set_location('Entering '||l_proc,10);

651: l_expression varchar2(32000);
652: --
653: begin
654: --
655: hr_utility.set_location('Entering '||l_proc,10);
656: --
657: add_expression(p_value => p_events.ler1_id,
658: p_expression => l_expression);
659: --

Line 746: hr_utility.set_location('Leaving '||l_proc,10);

742: p_expression => l_expression);
743: --
744: return l_expression;
745: --
746: hr_utility.set_location('Leaving '||l_proc,10);
747: --
748: exception
749: --
750: when all_expressions_parsed then

Line 752: hr_utility.set_location('Leaving '||l_proc,10);

748: exception
749: --
750: when all_expressions_parsed then
751: --
752: hr_utility.set_location('Leaving '||l_proc,10);
753: return l_expression;
754: --
755: end build_boolean_expression;
756: --

Line 765: hr_utility.set_location('Entering '||l_proc,10);

761: l_rows integer;
762: --
763: begin
764: --
765: hr_utility.set_location('Entering '||l_proc,10);
766: --
767: l_dynamic_sql := 'select 1 from sys.dual where '||p_expression;
768: --
769: execute immediate l_dynamic_sql into l_rows;

Line 777: hr_utility.set_location('Entering '||l_proc,10);

773: return true;
774: --
775: end if;
776: --
777: hr_utility.set_location('Entering '||l_proc,10);
778: --
779: exception
780: --
781: when no_data_found then

Line 803: hr_utility.set_location('Entering '||l_proc,10);

799: l_expression varchar2(32000);
800: --
801: begin
802: --
803: hr_utility.set_location('Entering '||l_proc,10);
804: --
805: g_included_events.delete;
806: --
807: -- Steps to build in string

Line 858: hr_utility.set_location('Leaving '||l_proc,10);

854: l_success := false;
855: --
856: end if;
857: --
858: hr_utility.set_location('Leaving '||l_proc,10);
859: --
860: return l_success;
861: --
862: end parse_and_match;

Line 887: hr_utility.set_location('Entering '||l_proc,10);

883: l_operation varchar2(30) := 'NO_MATCH';
884: --
885: begin
886: --
887: hr_utility.set_location('Entering '||l_proc,10);
888: --
889: -- Test if at least one life event was included in the set
890: --
891: --

Line 936: hr_utility.set_location('Leaving '||l_proc,10);

932: end loop;
933: --
934: close c_events;
935: --
936: hr_utility.set_location('Leaving '||l_proc,10);
937: --
938: end collapse_event;
939: --
940: -- Main routine. This performs the collapse and returns to the calling

Line 953: hr_utility.set_location('Entering '||l_proc,10);

949: l_proc varchar2(80) := g_package||'main';
950: --
951: begin
952: --
953: hr_utility.set_location('Entering '||l_proc,10);
954: --
955: -- Steps to perform process
956: --
957: -- 1) Check if we have rows in the collapse life event table

Line 968: hr_utility.set_location('Leaving '||l_proc,10);

964: p_mode => p_mode,
965: p_min_lf_evt_ocrd_dt => p_min_lf_evt_ocrd_dt,
966: p_effective_date => p_effective_date);
967: --
968: hr_utility.set_location('Leaving '||l_proc,10);
969: --
970: end main;
971: --
972: end ben_collapse_life_event;