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

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

85: l_proc varchar2(72) := g_package||'update_summary_data';
86: --
87: begin
88: --
89: hr_utility.set_location('Entering'||l_proc, 10);
90: --
91: per_qh_summary_update.lock_summary_data
92: (p_chk1_checklist_item_id => p_chk1_checklist_item_id
93: ,p_chk1_object_version_number => p_chk1_object_version_number

Line 117: hr_utility.set_location(l_proc, 20);

113: --
114: l_checklist_item_id:=p_chk1_checklist_item_id;
115: l_chk_object_version_number:= p_chk1_object_version_number;
116: --
117: hr_utility.set_location(l_proc, 20);
118: --
119: if (l_checklist_item_id is null and
120: p_chk1_item_code is not null and
121: ( p_chk1_status is not null

Line 135: hr_utility.set_location(l_proc, 30);

131: <> nvl(p_chk1_status,hr_api.g_varchar2)
132: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);
136: --
137: per_checklist_items_api.cre_or_upd_checklist_items
138: (p_checklist_item_id => l_checklist_item_id
139: ,p_effective_date => p_effective_date

Line 155: hr_utility.set_location(l_proc, 40);

151: --
152: l_checklist_item_id:=p_chk2_checklist_item_id;
153: l_chk_object_version_number:= p_chk2_object_version_number;
154: --
155: hr_utility.set_location(l_proc, 40);
156: --
157: if (l_checklist_item_id is null and
158: p_chk2_item_code is not null and
159: ( p_chk2_status is not null

Line 173: hr_utility.set_location(l_proc, 50);

169: <> nvl(p_chk2_status,hr_api.g_varchar2)
170: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);
174: --
175: per_checklist_items_api.cre_or_upd_checklist_items
176: (p_checklist_item_id => l_checklist_item_id
177: ,p_effective_date => p_effective_date

Line 192: hr_utility.set_location(l_proc, 60);

188: p_chk2_object_version_number:=l_chk_object_version_number;
189: --
190: l_checklist_item_id:=p_chk3_checklist_item_id;
191: l_chk_object_version_number:= p_chk3_object_version_number;
192: hr_utility.set_location(l_proc, 60);
193: --
194: --
195: if (l_checklist_item_id is null and
196: p_chk3_item_code is not null and

Line 211: hr_utility.set_location(l_proc, 70);

207: <> nvl(p_chk3_status,hr_api.g_varchar2)
208: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);
212: --
213: per_checklist_items_api.cre_or_upd_checklist_items
214: (p_checklist_item_id => l_checklist_item_id
215: ,p_effective_date => p_effective_date

Line 231: hr_utility.set_location(l_proc, 80);

227: --
228: l_checklist_item_id:=p_chk4_checklist_item_id;
229: l_chk_object_version_number:= p_chk4_object_version_number;
230: --
231: hr_utility.set_location(l_proc, 80);
232: --
233: if (l_checklist_item_id is null and
234: p_chk4_item_code is not null and
235: ( p_chk4_status is not null

Line 249: hr_utility.set_location(l_proc, 90);

245: <> nvl(p_chk4_status,hr_api.g_varchar2)
246: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);
250: --
251: per_checklist_items_api.cre_or_upd_checklist_items
252: (p_checklist_item_id => l_checklist_item_id
253: ,p_effective_date => p_effective_date

Line 269: hr_utility.set_location(l_proc, 100);

265: --
266: l_checklist_item_id:=p_chk5_checklist_item_id;
267: l_chk_object_version_number:= p_chk5_object_version_number;
268: --
269: hr_utility.set_location(l_proc, 100);
270: --
271: if (l_checklist_item_id is null and
272: p_chk5_item_code is not null and
273: ( p_chk5_status is not null

Line 287: hr_utility.set_location(l_proc, 110);

283: <> nvl(p_chk5_status,hr_api.g_varchar2)
284: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);
288: --
289: per_checklist_items_api.cre_or_upd_checklist_items
290: (p_checklist_item_id => l_checklist_item_id
291: ,p_effective_date => p_effective_date

Line 307: hr_utility.set_location(l_proc, 120);

303: --
304: l_checklist_item_id:=p_chk6_checklist_item_id;
305: l_chk_object_version_number:= p_chk6_object_version_number;
306: --
307: hr_utility.set_location(l_proc, 120);
308: --
309: if (l_checklist_item_id is null and
310: p_chk6_item_code is not null and
311: ( p_chk6_status is not null

Line 325: hr_utility.set_location(l_proc, 130);

321: <> nvl(p_chk6_status,hr_api.g_varchar2)
322: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);
326: --
327: per_checklist_items_api.cre_or_upd_checklist_items
328: (p_checklist_item_id => l_checklist_item_id
329: ,p_effective_date => p_effective_date

Line 345: hr_utility.set_location(l_proc, 140);

341: --
342: l_checklist_item_id:=p_chk7_checklist_item_id;
343: l_chk_object_version_number:= p_chk7_object_version_number;
344: --
345: hr_utility.set_location(l_proc, 140);
346: --
347: if (l_checklist_item_id is null and
348: p_chk7_item_code is not null and
349: ( p_chk7_status is not null

Line 363: hr_utility.set_location(l_proc, 150);

359: <> nvl(p_chk7_status,hr_api.g_varchar2)
360: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);
364: --
365: per_checklist_items_api.cre_or_upd_checklist_items
366: (p_checklist_item_id => l_checklist_item_id
367: ,p_effective_date => p_effective_date

Line 383: hr_utility.set_location(l_proc, 160);

379: --
380: l_checklist_item_id:=p_chk8_checklist_item_id;
381: l_chk_object_version_number:= p_chk8_object_version_number;
382: --
383: hr_utility.set_location(l_proc, 160);
384: --
385: if (l_checklist_item_id is null and
386: p_chk8_item_code is not null and
387: ( p_chk8_status is not null

Line 401: hr_utility.set_location(l_proc, 170);

397: <> nvl(p_chk8_status,hr_api.g_varchar2)
398: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);
402: --
403: per_checklist_items_api.cre_or_upd_checklist_items
404: (p_checklist_item_id => l_checklist_item_id
405: ,p_effective_date => p_effective_date

Line 421: hr_utility.set_location(l_proc, 180);

417: --
418: l_checklist_item_id:=p_chk9_checklist_item_id;
419: l_chk_object_version_number:= p_chk9_object_version_number;
420: --
421: hr_utility.set_location(l_proc, 180);
422: --
423: if (l_checklist_item_id is null and
424: p_chk9_item_code is not null and
425: ( p_chk9_status is not null

Line 439: hr_utility.set_location(l_proc, 190);

435: <> nvl(p_chk9_status,hr_api.g_varchar2)
436: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);
440: --
441: per_checklist_items_api.cre_or_upd_checklist_items
442: (p_checklist_item_id => l_checklist_item_id
443: ,p_effective_date => p_effective_date

Line 459: hr_utility.set_location(l_proc, 200);

455: --
456: l_checklist_item_id:=p_chk10_checklist_item_id;
457: l_chk_object_version_number:= p_chk10_object_version_number;
458: --
459: hr_utility.set_location(l_proc, 200);
460: --
461: if (l_checklist_item_id is null and
462: p_chk10_item_code is not null and
463: ( p_chk10_status is not null

Line 477: hr_utility.set_location(l_proc, 210);

473: <> nvl(p_chk10_status,hr_api.g_varchar2)
474: or nvl(per_chk_shd.g_old_rec.notes,hr_api.g_varchar2)
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);
478: --
479: per_checklist_items_api.cre_or_upd_checklist_items
480: (p_checklist_item_id => l_checklist_item_id
481: ,p_effective_date => p_effective_date

Line 494: hr_utility.set_location('Leaving'||l_proc, 220);

490: end if;
491: p_chk10_checklist_item_id:=l_checklist_item_id;
492: p_chk10_object_version_number:=l_chk_object_version_number;
493: --
494: hr_utility.set_location('Leaving'||l_proc, 220);
495: --
496: end update_summary_data;
497: --
498: procedure lock_summary_data

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

519: ) is
520: l_proc varchar2(72) := g_package||'lock_summary_data';
521: begin
522: --
523: hr_utility.set_location('Entering:'|| l_proc, 10);
524: --
525: if p_chk1_checklist_item_id is not null then
526: per_chk_shd.lck
527: (p_checklist_item_id => p_chk1_checklist_item_id

Line 532: hr_utility.set_location(l_proc, 20);

528: ,p_object_version_number => p_chk1_object_version_number
529: );
530: end if;
531: --
532: hr_utility.set_location(l_proc, 20);
533: --
534: if p_chk2_checklist_item_id is not null then
535: per_chk_shd.lck
536: (p_checklist_item_id => p_chk2_checklist_item_id

Line 541: hr_utility.set_location(l_proc, 30);

537: ,p_object_version_number => p_chk2_object_version_number
538: );
539: end if;
540: --
541: hr_utility.set_location(l_proc, 30);
542: --
543: if p_chk3_checklist_item_id is not null then
544: per_chk_shd.lck
545: (p_checklist_item_id => p_chk3_checklist_item_id

Line 550: hr_utility.set_location(l_proc, 40);

546: ,p_object_version_number => p_chk3_object_version_number
547: );
548: end if;
549: --
550: hr_utility.set_location(l_proc, 40);
551: --
552: if p_chk4_checklist_item_id is not null then
553: per_chk_shd.lck
554: (p_checklist_item_id => p_chk4_checklist_item_id

Line 559: hr_utility.set_location(l_proc, 50);

555: ,p_object_version_number => p_chk4_object_version_number
556: );
557: end if;
558: --
559: hr_utility.set_location(l_proc, 50);
560: --
561: if p_chk5_checklist_item_id is not null then
562: per_chk_shd.lck
563: (p_checklist_item_id => p_chk5_checklist_item_id

Line 568: hr_utility.set_location(l_proc, 60);

564: ,p_object_version_number => p_chk5_object_version_number
565: );
566: end if;
567: --
568: hr_utility.set_location(l_proc, 60);
569: --
570: if p_chk6_checklist_item_id is not null then
571: per_chk_shd.lck
572: (p_checklist_item_id => p_chk6_checklist_item_id

Line 577: hr_utility.set_location(l_proc, 70);

573: ,p_object_version_number => p_chk6_object_version_number
574: );
575: end if;
576: --
577: hr_utility.set_location(l_proc, 70);
578: --
579: if p_chk7_checklist_item_id is not null then
580: per_chk_shd.lck
581: (p_checklist_item_id => p_chk7_checklist_item_id

Line 586: hr_utility.set_location(l_proc, 80);

582: ,p_object_version_number => p_chk7_object_version_number
583: );
584: end if;
585: --
586: hr_utility.set_location(l_proc, 80);
587: --
588: if p_chk8_checklist_item_id is not null then
589: per_chk_shd.lck
590: (p_checklist_item_id => p_chk8_checklist_item_id

Line 595: hr_utility.set_location(l_proc, 90);

591: ,p_object_version_number => p_chk8_object_version_number
592: );
593: end if;
594: --
595: hr_utility.set_location(l_proc, 90);
596: --
597: if p_chk9_checklist_item_id is not null then
598: per_chk_shd.lck
599: (p_checklist_item_id => p_chk9_checklist_item_id

Line 604: hr_utility.set_location(l_proc, 100);

600: ,p_object_version_number => p_chk9_object_version_number
601: );
602: end if;
603: --
604: hr_utility.set_location(l_proc, 100);
605: --
606: if p_chk10_checklist_item_id is not null then
607: per_chk_shd.lck
608: (p_checklist_item_id => p_chk10_checklist_item_id

Line 613: hr_utility.set_location('Leaving'||l_proc, 110);

609: ,p_object_version_number => p_chk10_object_version_number
610: );
611: end if;
612: --
613: hr_utility.set_location('Leaving'||l_proc, 110);
614: --
615: end lock_summary_data;
616: --
617: end;