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_PERSON_OBJECT dependencies on HR_UTILITY

Line 137: g_debug boolean := hr_utility.debug_enabled;

133: --
134: g_package varchar2(30) := 'ben_person_object.';
135: g_hash_key number := ben_hash_utility.get_hash_key;
136: g_hash_jump number := ben_hash_utility.get_hash_jump;
137: g_debug boolean := hr_utility.debug_enabled;
138: --
139: -- Set object routines
140: --
141: procedure set_object(p_rec in out NOCOPY per_all_people_f%rowtype) is

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

144: l_index pls_integer;
145: --
146: begin
147: --
148: -- hr_utility.set_location('Entering '||l_proc,10);
149: --
150: -- 1) get hash index
151: -- 2) If hash index is not used use hash index
152: -- 3) If hash index is used and correct then do nothing

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

174: end loop;
175: --
176: end if;
177: --
178: -- hr_utility.set_location('Leaving '||l_proc,10);
179: --
180: exception when NO_DATA_FOUND then
181: -- set cache entry at current index location
182: g_cache_per_rec(l_index):=p_rec;

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

189: l_index pls_integer;
190: --
191: begin
192: --
193: -- hr_utility.set_location('Entering '||l_proc,10);
194: --
195: -- 1) get hash index
196: -- 2) If hash index is not used use hash index
197: -- 3) If hash index is used and correct then do nothing

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

219: end loop;
220: --
221: end if;
222: --
223: -- hr_utility.set_location('Leaving '||l_proc,10);
224: --
225: exception when NO_DATA_FOUND then
226: -- set cache entry at current index location
227: g_cache_bnb_rec(l_index):=p_rec;

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

233: l_index pls_integer;
234: --
235: begin
236: --
237: -- hr_utility.set_location('Entering '||l_proc,10);
238: --
239: -- 1) get hash index
240: -- 2) If hash index is not used use hash index
241: -- 3) If hash index is used and correct then do nothing

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

263: end loop;
264: --
265: end if;
266: --
267: -- hr_utility.set_location('Leaving '||l_proc,10);
268: --
269: exception when NO_DATA_FOUND then
270: -- 115.23 set cache entry at current index location
271: g_cache_hsc_rec(l_index):=p_rec;

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

277: l_index pls_integer;
278: --
279: begin
280: --
281: -- hr_utility.set_location('Entering '||l_proc,10);
282: --
283: -- 1) get hash index
284: -- 2) If hash index is not used use hash index
285: -- 3) If hash index is used and correct then do nothing

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

307: end loop;
308: --
309: end if;
310: --
311: -- hr_utility.set_location('Leaving '||l_proc,10);
312: --
313: exception when NO_DATA_FOUND then
314: -- 115.23 set cache entry at current index location
315: g_cache_ass_rec(l_index):=p_rec;

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

320: l_proc varchar2(80) := g_package||'set_object benass';
321: l_index pls_integer;
322: begin
323: --
324: -- hr_utility.set_location('Entering '||l_proc,10);
325: --
326: -- 1) get hash index
327: -- 2) If hash index is not used use hash index
328: -- 3) If hash index is used and correct then do nothing

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

350: end loop;
351: --
352: end if;
353: --
354: -- hr_utility.set_location('Leaving '||l_proc,10);
355: --
356: exception when NO_DATA_FOUND then
357: -- 115.23 set cache entry at current index location
358: g_cache_benass_rec(l_index):=p_rec;

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

364: l_index pls_integer;
365: --
366: begin
367: --
368: -- hr_utility.set_location('Entering '||l_proc,10);
369: --
370: -- 1) get hash index
371: -- 2) If hash index is not used use hash index
372: -- 3) If hash index is used and correct then do nothing

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

394: end loop;
395: --
396: end if;
397: --
398: -- hr_utility.set_location('Leaving '||l_proc,10);
399: --
400: exception when NO_DATA_FOUND then
401: -- 115.23 set cache entry at current index location
402: g_cache_ast_rec(l_index):=p_rec;

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

408: l_index pls_integer;
409: --
410: begin
411: --
412: -- hr_utility.set_location('Entering '||l_proc,10);
413: --
414: -- 1) get hash index
415: -- 2) If hash index is not used use hash index
416: -- 3) If hash index is used and correct then do nothing

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

438: end loop;
439: --
440: end if;
441: --
442: -- hr_utility.set_location('Leaving '||l_proc,10);
443: --
444: exception when NO_DATA_FOUND then
445: -- 115.23 set cache entry at current index location
446: g_cache_aei_rec(l_index):=p_rec;

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

452: l_index pls_integer;
453: --
454: begin
455: --
456: -- hr_utility.set_location('Entering '||l_proc,10);
457: --
458: -- 1) get hash index
459: -- 2) If hash index is not used use hash index
460: -- 3) If hash index is used and correct then do nothing

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

482: end loop;
483: --
484: end if;
485: --
486: -- hr_utility.set_location('Leaving '||l_proc,10);
487: --
488: exception when NO_DATA_FOUND then
489: -- 115.23 set cache entry at current index location
490: g_cache_pil_rec(l_index):=p_rec;

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

496: l_index pls_integer;
497: --
498: begin
499: --
500: -- hr_utility.set_location('Entering '||l_proc,10);
501: --
502: l_index := nvl(g_cache_bal_rec.count,0)+1;
503: --
504: g_cache_bal_rec(l_index) := p_rec;

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

502: l_index := nvl(g_cache_bal_rec.count,0)+1;
503: --
504: g_cache_bal_rec(l_index) := p_rec;
505: --
506: -- hr_utility.set_location('Leaving '||l_proc,10);
507: --
508: end set_object;
509: --
510: procedure set_object(p_rec in out NOCOPY per_contact_relationships%rowtype) is

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

513: l_index pls_integer;
514: --
515: begin
516: --
517: -- hr_utility.set_location('Entering '||l_proc,10);
518: --
519: l_index := nvl(g_cache_con_rec.count,0)+1;
520: --
521: g_cache_con_rec(l_index) := p_rec;

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

519: l_index := nvl(g_cache_con_rec.count,0)+1;
520: --
521: g_cache_con_rec(l_index) := p_rec;
522: --
523: -- hr_utility.set_location('Leaving '||l_proc,10);
524: --
525: end set_object;
526: --
527: procedure set_appass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

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

530: l_index pls_integer;
531: --
532: begin
533: --
534: -- hr_utility.set_location('Entering '||l_proc,10);
535: --
536: l_index := nvl(g_cache_appass_rec.count,0)+1;
537: --
538: g_cache_appass_rec(l_index) := p_rec;

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

536: l_index := nvl(g_cache_appass_rec.count,0)+1;
537: --
538: g_cache_appass_rec(l_index) := p_rec;
539: --
540: -- hr_utility.set_location('Leaving '||l_proc,10);
541: --
542: end set_appass_object;
543: --
544: procedure set_allass_object(p_rec in out NOCOPY per_all_assignments_f%rowtype) is

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

547: l_index pls_integer;
548: --
549: begin
550: --
551: -- hr_utility.set_location('Entering '||l_proc,10);
552: --
553: l_index := nvl(g_cache_allass_rec.count,0)+1;
554: --
555: g_cache_allass_rec(l_index) := p_rec;

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

553: l_index := nvl(g_cache_allass_rec.count,0)+1;
554: --
555: g_cache_allass_rec(l_index) := p_rec;
556: --
557: -- hr_utility.set_location('Leaving '||l_proc,10);
558: --
559: end set_allass_object;
560: --
561: procedure set_object(p_rec in out NOCOPY g_person_typ_info_rec) is

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

564: l_index pls_integer;
565: --
566: begin
567: --
568: -- hr_utility.set_location('Entering '||l_proc,10);
569: --
570: l_index := nvl(g_cache_typ_rec.count,0)+1;
571: --
572: g_cache_typ_rec(l_index) := p_rec;

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

570: l_index := nvl(g_cache_typ_rec.count,0)+1;
571: --
572: g_cache_typ_rec(l_index) := p_rec;
573: --
574: -- hr_utility.set_location('Leaving '||l_proc,10);
575: --
576: end set_object;
577: --
578: procedure set_object(p_rec in out NOCOPY per_periods_of_service%rowtype) is

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

581: l_index pls_integer;
582: --
583: begin
584: --
585: -- hr_utility.set_location('Entering '||l_proc,10);
586: --
587: -- 1) get hash index
588: -- 2) If hash index is not used use hash index
589: -- 3) If hash index is used and correct then do nothing

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

611: end loop;
612: --
613: end if;
614: --
615: -- hr_utility.set_location('Leaving '||l_proc,10);
616: --
617: exception when NO_DATA_FOUND then
618: -- 115.23 set cache entry at current index location
619: g_cache_pps_rec(l_index):=p_rec;

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

625: l_index pls_integer;
626: --
627: begin
628: --
629: -- hr_utility.set_location('Entering '||l_proc,10);
630: --
631: -- 1) get hash index
632: -- 2) If hash index is not used use hash index
633: -- 3) If hash index is used and correct then do nothing

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

655: end loop;
656: --
657: end if;
658: --
659: -- hr_utility.set_location('Leaving '||l_proc,10);
660: --
661: exception when NO_DATA_FOUND then
662: -- 115.23 set cache entry at current index location
663: g_cache_pad_rec(l_index):=p_rec;

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

669: l_index pls_integer;
670: --
671: begin
672: --
673: -- hr_utility.set_location('Entering '||l_proc,10);
674: --
675: -- 1) get hash index
676: -- 2) If hash index is not used use hash index
677: -- 3) If hash index is used and correct then do nothing

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

699: end loop;
700: --
701: end if;
702: --
703: -- hr_utility.set_location('Leaving '||l_proc,10);
704: --
705: exception when NO_DATA_FOUND then
706: -- 115.23 set cache entry at current index location
707: g_cache_date_rec(l_index):=p_rec;

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

713: l_index pls_integer;
714: --
715: begin
716: --
717: -- hr_utility.set_location('Entering '||l_proc,10);
718: --
719: -- 1) get hash index
720: -- 2) If hash index is not used use hash index
721: -- 3) If hash index is used and correct then do nothing

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

743: end loop;
744: --
745: end if;
746: --
747: -- hr_utility.set_location('Leaving '||l_proc,10);
748: --
749: exception when NO_DATA_FOUND then
750: -- 115.23 set cache entry at current index location
751: g_cache_bal_per_rec(l_index):=p_rec;

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

757: l_index pls_integer;
758: --
759: begin
760: --
761: -- hr_utility.set_location('Entering '||l_proc,10);
762: --
763: -- 1) get hash index
764: -- 2) If hash index is not used use hash index
765: -- 3) If hash index is used and correct then do nothing

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

787: end loop;
788: --
789: end if;
790: --
791: -- hr_utility.set_location('Leaving '||l_proc,10);
792: --
793: exception when NO_DATA_FOUND then
794: -- 115.23 set cache entry at current index location
795: g_cache_con_per_rec(l_index):=p_rec;

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

801: l_index pls_integer;
802: --
803: begin
804: --
805: -- hr_utility.set_location('Entering '||l_proc,10);
806: --
807: -- 1) get hash index
808: -- 2) If hash index is not used use hash index
809: -- 3) If hash index is used and correct then do nothing

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

831: end loop;
832: --
833: end if;
834: --
835: -- hr_utility.set_location('Leaving '||l_proc,10);
836: --
837: exception when NO_DATA_FOUND then
838: -- 115.23 set cache entry at current index location
839: g_cache_app_ass_rec(l_index):=p_rec;

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

845: l_index pls_integer;
846: --
847: begin
848: --
849: -- hr_utility.set_location('Entering '||l_proc,10);
850: --
851: -- 1) get hash index
852: -- 2) If hash index is not used use hash index
853: -- 3) If hash index is used and correct then do nothing

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

875: end loop;
876: --
877: end if;
878: --
879: -- hr_utility.set_location('Leaving '||l_proc,10);
880: --
881: exception when NO_DATA_FOUND then
882: -- 115.23 set cache entry at current index location
883: g_cache_all_ass_rec(l_index):=p_rec;

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

889: l_index pls_integer;
890: --
891: begin
892: --
893: -- hr_utility.set_location('Entering '||l_proc,10);
894: --
895: -- 1) get hash index
896: -- 2) If hash index is not used use hash index
897: -- 3) If hash index is used and correct then do nothing

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

919: end loop;
920: --
921: end if;
922: --
923: -- hr_utility.set_location('Leaving '||l_proc,10);
924: --
925: exception when NO_DATA_FOUND then
926: -- 115.23 set cache entry at current index location
927: g_cache_typ_per_rec(l_index):=p_rec;

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

933: l_index pls_integer;
934: --
935: begin
936: --
937: -- hr_utility.set_location('Entering '||l_proc,10);
938: --
939: -- 1) get hash index
940: -- 2) If hash index is not used use hash index
941: -- 3) If hash index is used and correct then do nothing

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

963: end loop;
964: --
965: end if;
966: --
967: -- hr_utility.set_location('Leaving '||l_proc,10);
968: --
969: exception when NO_DATA_FOUND then
970: -- 115.23 set cache entry at current index location
971: g_cache_fte_rec(l_index):=p_rec;

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

1015: --115.23 - comment out unneeded record
1016: --
1017: begin
1018: --
1019: -- hr_utility.set_location('Entering '||l_proc,10);
1020: --
1021: -- 1) Get record from database.
1022: -- 2) If record not found then raise error.
1023: -- 3) Pass record to set_object routine.

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

1045: --
1046: -- 115.23 - unnecessary, using NOCOPY record
1047: --p_rec := l_rec;
1048: --
1049: -- hr_utility.set_location('Leaving '||l_proc,10);
1050: --
1051: end set_ass_object;
1052: --
1053: procedure set_benass_object

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

1074: --115.23 - comment out unneeded record
1075: --
1076: begin
1077: --
1078: -- hr_utility.set_location('Entering '||l_proc,10);
1079: --
1080: -- 1) Get record from database.
1081: -- 2) If record not found then raise error.
1082: -- 3) Pass record to set_object routine.

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

1104: --
1105: -- 115.23 - unnecessary, using NOCOPY record
1106: --p_rec := l_rec;
1107: --
1108: -- hr_utility.set_location('Leaving '||l_proc,10);
1109: --
1110: end set_benass_object;
1111: --
1112: procedure set_bnb_object

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

1133: --115.23 - comment out unneeded record
1134: --
1135: begin
1136: --
1137: -- hr_utility.set_location('Entering '||l_proc,10);
1138: --
1139: -- 1) Get record from database.
1140: -- 2) If record not found then raise error.
1141: -- 3) Pass record to set_object routine.

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

1166: --
1167: -- 115.23 - unnecessary, using NOCOPY record
1168: --p_rec := l_rec;
1169: --
1170: -- hr_utility.set_location('Leaving '||l_proc,10);
1171: --
1172: end set_bnb_object;
1173: --
1174: procedure set_ast_object

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

1187: --115.23 - comment out unneeded record
1188: --
1189: begin
1190: --
1191: -- hr_utility.set_location('Entering '||l_proc,10);
1192: --
1193: -- 1) Get record from database.
1194: -- 2) If record not found then raise error.
1195: -- 3) Pass record to set_object routine.

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

1214: --
1215: -- 115.23 - unnecessary, using NOCOPY record
1216: --p_rec := l_rec;
1217: --
1218: -- hr_utility.set_location('Leaving '||l_proc,10);
1219: --
1220: end set_ast_object;
1221: --
1222: procedure set_ass_object

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

1235: --115.23 - comment out unneeded record
1236: --
1237: begin
1238: --
1239: -- hr_utility.set_location('Entering '||l_proc,10);
1240: --
1241: -- 1) Get record from database.
1242: -- 2) If record not found then raise error.
1243: -- 3) Pass record to set_object routine.

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

1262: --
1263: -- 115.23 - unnecessary, using NOCOPY record
1264: --p_rec := l_rec;
1265: --
1266: -- hr_utility.set_location('Leaving '||l_proc,10);
1267: --
1268: end set_ass_object;
1269: --
1270: procedure set_pil_object

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

1290: --115.23 - comment out unneeded record
1291: --
1292: begin
1293: --
1294: -- hr_utility.set_location('Entering '||l_proc,10);
1295: --
1296: -- 1) Get record from database.
1297: -- 2) If record not found then raise error.
1298: -- 3) Pass record to set_object routine.

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

1317: --
1318: -- 115.23 - unnecessary, using NOCOPY record
1319: --p_rec := l_rec;
1320: --
1321: -- hr_utility.set_location('Leaving '||l_proc,10);
1322: --
1323: end set_pil_object;
1324: --
1325: procedure set_con_object

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

1351: l_num_recs number := 0;
1352: --
1353: begin
1354: --
1355: -- hr_utility.set_location('Entering '||l_proc,10);
1356: --
1357: -- 1) Get record from database.
1358: -- 2) If record not found then raise error.
1359: -- 3) Pass record to set_object routine.

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

1394: set_con_per_object(p_rec => l_con_per_rec);
1395: --
1396: p_rec := l_rec;
1397: --
1398: -- hr_utility.set_location('Leaving '||l_proc,10);
1399: --
1400: end set_con_object;
1401: --
1402: procedure set_appass_object

Line 1427: g_debug := hr_utility.debug_enabled;

1423: l_num_recs number := 0;
1424: --
1425: begin
1426: --
1427: g_debug := hr_utility.debug_enabled;
1428: if g_debug then
1429: l_proc := g_package||'set_app_ass_object';
1430: hr_utility.set_location('Entering '||l_proc,10);
1431: end if;

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

1426: --
1427: g_debug := hr_utility.debug_enabled;
1428: if g_debug then
1429: l_proc := g_package||'set_app_ass_object';
1430: hr_utility.set_location('Entering '||l_proc,10);
1431: end if;
1432: --
1433: -- 1) Get record from database.
1434: -- 2) If record not found then raise error.

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

1471: --
1472: p_rec := l_rec;
1473: --
1474: if g_debug then
1475: hr_utility.set_location('Leaving '||l_proc,10);
1476: end if;
1477: --
1478: end set_appass_object;
1479: --

Line 1505: g_debug := hr_utility.debug_enabled;

1501: l_num_recs number := 0;
1502: --
1503: begin
1504: --
1505: g_debug := hr_utility.debug_enabled;
1506: if g_debug then
1507: l_proc := g_package||'set_all_ass_object';
1508: hr_utility.set_location('Entering '||l_proc,10);
1509: hr_utility.set_location('ben_per_asg_elig.g_allow_contingent_wrk '||ben_per_asg_elig.g_allow_contingent_wrk,11);

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

1504: --
1505: g_debug := hr_utility.debug_enabled;
1506: if g_debug then
1507: l_proc := g_package||'set_all_ass_object';
1508: hr_utility.set_location('Entering '||l_proc,10);
1509: hr_utility.set_location('ben_per_asg_elig.g_allow_contingent_wrk '||ben_per_asg_elig.g_allow_contingent_wrk,11);
1510: end if;
1511: --
1512: -- 1) Get record from database.

Line 1509: hr_utility.set_location('ben_per_asg_elig.g_allow_contingent_wrk '||ben_per_asg_elig.g_allow_contingent_wrk,11);

1505: g_debug := hr_utility.debug_enabled;
1506: if g_debug then
1507: l_proc := g_package||'set_all_ass_object';
1508: hr_utility.set_location('Entering '||l_proc,10);
1509: hr_utility.set_location('ben_per_asg_elig.g_allow_contingent_wrk '||ben_per_asg_elig.g_allow_contingent_wrk,11);
1510: end if;
1511: --
1512: -- 1) Get record from database.
1513: -- 2) If record not found then raise error.

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

1552: --
1553: p_rec := l_rec;
1554: --
1555: if g_debug then
1556: hr_utility.set_location('Leaving '||l_proc,10);
1557: end if;
1558: --
1559: end set_allass_object;
1560: --

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

1624: l_num_recs number := 0;
1625: --
1626: begin
1627: --
1628: -- hr_utility.set_location('Entering '||l_proc,10);
1629: --
1630: -- 1) Get record from database.
1631: -- 2) If record not found then raise error.
1632: -- 3) Pass record to set_object routine.

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

1682: set_typ_per_object(p_rec => l_typ_per_rec);
1683: --
1684: p_rec := l_rec;
1685: --
1686: -- hr_utility.set_location('Leaving '||l_proc,10);
1687: --
1688: end set_typ_object;
1689: --
1690: procedure set_bal_object

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

1705: l_num_recs number := 0;
1706: --
1707: begin
1708: --
1709: -- hr_utility.set_location('Entering '||l_proc,10);
1710: --
1711: -- 1) Get record from database.
1712: -- 2) If record not found then raise error.
1713: -- 3) Pass record to set_object routine.

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

1744: end if;
1745: --
1746: set_bal_per_object(p_rec => l_bal_per_rec);
1747: --
1748: -- hr_utility.set_location('Leaving '||l_proc,10);
1749: --
1750: end set_bal_object;
1751: --
1752: procedure set_pad_object

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

1771: --115.23 - comment out unneeded record
1772: --
1773: begin
1774: --
1775: -- hr_utility.set_location('Entering '||l_proc,10);
1776: --
1777: -- 1) Get record from database.
1778: -- 2) If record not found then raise error.
1779: -- 3) Pass record to set_object routine.

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

1798: --
1799: -- 115.23 - unnecessary, using NOCOPY record
1800: --p_rec := l_rec;
1801: --
1802: -- hr_utility.set_location('Leaving '||l_proc,10);
1803: --
1804: end set_pad_object;
1805: --
1806: procedure set_hsc_object

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

1818: --115.23 - comment out unneeded record
1819: --
1820: begin
1821: --
1822: -- hr_utility.set_location('Entering '||l_proc,10);
1823: --
1824: -- 1) Get record from database.
1825: -- 2) If record not found then raise error.
1826: -- 3) Pass record to set_object routine.

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

1845: --
1846: -- 115.23 - unnecessary, using NOCOPY record
1847: --p_rec := l_rec;
1848: --
1849: -- hr_utility.set_location('Leaving '||l_proc,10);
1850: --
1851: end set_hsc_object;
1852: --
1853: procedure set_per_object(p_person_id in number,

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

1870: --l_rec per_all_people_f%rowtype;
1871: --115.23 altered to use NOCOPY record
1872: begin
1873: --
1874: -- hr_utility.set_location('Entering '||l_proc,10);
1875: --
1876: -- 1) Get record from database.
1877: -- 2) If record not found then raise error.
1878: -- 3) Pass record to set_object routine.

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

1916: end loop;
1917: --
1918: end if;
1919: --
1920: -- hr_utility.set_location('Leaving '||l_proc,10);
1921: --
1922: --
1923: --115.23 - altered to use NOCOPY record
1924: --p_rec := l_rec;

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

1922: --
1923: --115.23 - altered to use NOCOPY record
1924: --p_rec := l_rec;
1925: --
1926: -- hr_utility.set_location('Leaving '||l_proc,10);
1927: --
1928: exception when NO_DATA_FOUND then
1929: -- set cache entry at current index location
1930: g_cache_per_rec(l_index):=p_rec;

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

1951: --115.23 - comment out unneeded record
1952: --
1953: begin
1954: --
1955: -- hr_utility.set_location('Entering '||l_proc,10);
1956: --
1957: -- 1) Get record from database.
1958: -- 2) If record not found then raise error.
1959: -- 3) Pass record to set_object routine.

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

1992: end loop;
1993: --
1994: end if;
1995: --
1996: -- hr_utility.set_location('Leaving '||l_proc,10);
1997: --
1998: --
1999: --115.23 - altered to use NOCOPY record
2000: --p_rec := l_rec;

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

1998: --
1999: --115.23 - altered to use NOCOPY record
2000: --p_rec := l_rec;
2001: --
2002: -- hr_utility.set_location('Leaving '||l_proc,10);
2003: --
2004: exception when NO_DATA_FOUND then
2005: -- set cache entry at current index location
2006: g_cache_pps_rec(l_index):=p_rec;

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

2032: --l_rec g_person_date_info_rec;
2033: --
2034: begin
2035: --
2036: -- hr_utility.set_location('Entering '||l_proc,10);
2037: --
2038: -- 1) Get record from database.
2039: -- 2) If record not found then raise error.
2040: -- 3) Pass record to set_object routine.

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

2084: end loop;
2085: --
2086: end if;
2087: --
2088: -- hr_utility.set_location('Leaving '||l_proc,10);
2089: --
2090: exception when NO_DATA_FOUND then
2091: -- 115.23 set cache entry at current index location
2092: g_cache_date_rec(l_index):=p_rec;

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

2143: --l_rec g_person_fte_info_rec;
2144: --
2145: begin
2146: --
2147: -- hr_utility.set_location('Entering '||l_proc,10);
2148: --
2149: -- 1) Get record from database.
2150: -- 2) If record not found then raise error.
2151: -- 3) Pass record to set_object routine.

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

2166: close c2;
2167: --115.23 - altered to use NOCOPY record
2168: --p_rec := l_rec;
2169: --
2170: -- hr_utility.set_location('Leaving '||l_proc,10);
2171: --
2172: l_index := mod(p_assignment_id,g_hash_key);
2173: --
2174: -- 115.23 check for cache entry at current index. if none exists the NO_DATA_FOUND expection will fire

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

2189: end loop;
2190: --
2191: end if;
2192: --
2193: -- hr_utility.set_location('Leaving '||l_proc,10);
2194: --
2195: exception when NO_DATA_FOUND then
2196: -- 115.23 set cache entry at current index location
2197: g_cache_fte_rec(l_index):=p_rec;

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

2210: l_effective_date date;
2211: --
2212: begin
2213: --
2214: -- hr_utility.set_location('Entering '||l_proc,10);
2215: --
2216: if g_cache_last_per_rec.person_id = p_person_id then
2217: --
2218: p_rec := g_cache_last_per_rec;

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

2250: p_rec := g_cache_last_per_rec;
2251: --
2252: end if;
2253: --
2254: -- hr_utility.set_location('Leaving '||l_proc,10);
2255: --
2256: exception
2257: --
2258: when no_data_found then

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

2293: --
2294: --
2295: begin
2296: --
2297: -- hr_utility.set_location('Entering '||l_proc,10);
2298: --
2299: if g_cache_last_bnb_rec.bnfts_bal_id = p_bnfts_bal_id then
2300: --
2301: p_rec := g_cache_last_bnb_rec;

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

2333: p_rec := g_cache_last_bnb_rec;
2334: --
2335: end if;
2336: --
2337: -- hr_utility.set_location('Leaving '||l_proc,10);
2338: --
2339: exception
2340: --
2341: when no_data_found then

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

2370: --l_rec hr_soft_coding_keyflex%rowtype;
2371: --
2372: begin
2373: --
2374: -- hr_utility.set_location('Entering '||l_proc,10);
2375: --
2376: if g_cache_last_hsc_rec.soft_coding_keyflex_id = p_soft_coding_keyflex_id then
2377: --
2378: p_rec := g_cache_last_hsc_rec;

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

2440: --
2441: --
2442: begin
2443: --
2444: -- hr_utility.set_location('Entering '||l_proc,10);
2445: --
2446: if g_cache_last_ass_rec.person_id = p_person_id and
2447: g_cache_last_ass_rec.assignment_id = p_assignment_id and
2448: g_cache_last_ass_rec.object_version_number = p_rec.object_version_number then

Line 2451: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 441);

2447: g_cache_last_ass_rec.assignment_id = p_assignment_id and
2448: g_cache_last_ass_rec.object_version_number = p_rec.object_version_number then
2449: --
2450: p_rec := g_cache_last_ass_rec;
2451: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 441);
2452: return;
2453: --
2454: end if;
2455: --

Line 2471: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 442);

2467: g_cache_ass_rec(l_index).object_version_number = p_rec.object_version_number then
2468: --
2469: g_cache_last_ass_rec := g_cache_ass_rec(l_index);
2470: p_rec := g_cache_last_ass_rec;
2471: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 442);
2472: --
2473: else
2474: --
2475: -- We need to loop through all the hashed indexes

Line 2490: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 443);

2486: end loop;
2487: --
2488: g_cache_last_ass_rec := g_cache_ass_rec(l_index);
2489: p_rec := g_cache_last_ass_rec;
2490: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 443);
2491: --
2492: end if;
2493: exception
2494: --

Line 2513: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 444);

2509: l_env.effective_date),*/
2510: p_rec => p_rec);
2511: --
2512: g_cache_last_ass_rec := p_rec;
2513: hr_utility.set_location('assignment_id '||p_rec.assignment_id, 444);
2514: --p_rec := l_rec;
2515: --
2516: end get_object;
2517: --ud changes end

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

2530: --
2531: --
2532: begin
2533: --
2534: -- hr_utility.set_location('Entering '||l_proc,10);
2535: --
2536: if g_cache_last_ass_rec.person_id = p_person_id then
2537: --
2538: p_rec := g_cache_last_ass_rec;

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

2608: l_effective_date date;
2609: --
2610: begin
2611: --
2612: -- hr_utility.set_location('Entering '||l_proc,10);
2613: --
2614: if g_cache_last_benass_rec.person_id = p_person_id then
2615: --
2616: p_rec := g_cache_last_benass_rec;

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

2682: l_rec per_assignment_status_types%rowtype;
2683: --
2684: begin
2685: --
2686: -- hr_utility.set_location('Entering '||l_proc,10);
2687: --
2688: if g_cache_last_ast_rec.assignment_status_type_id = p_assignment_status_type_id then
2689: --
2690: p_rec := g_cache_last_ast_rec;

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

2743: --l_rec per_assignment_extra_info%rowtype;
2744: --
2745: begin
2746: --
2747: -- hr_utility.set_location('Entering '||l_proc,10);
2748: --
2749: if g_cache_last_aei_rec.assignment_id = p_assignment_id then
2750: --
2751: p_rec := g_cache_last_aei_rec;

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

2809: --
2810: --
2811: begin
2812: --
2813: -- hr_utility.set_location('Entering '||l_proc,10);
2814: --
2815: if g_cache_last_pil_rec.person_id = p_person_id then
2816: --
2817: p_rec := g_cache_last_pil_rec;

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

2887: --
2888: --
2889: begin
2890: --
2891: -- hr_utility.set_location('Entering '||l_proc,10);
2892: --
2893: if g_cache_last_pad_rec.person_id = p_person_id then
2894: --
2895: p_rec := g_cache_last_pad_rec;

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

2963: --
2964: --
2965: begin
2966: --
2967: -- hr_utility.set_location('Entering '||l_proc,10);
2968: --
2969: if g_cache_last_pps_rec.person_id = p_person_id then
2970: --
2971: p_rec := g_cache_last_pps_rec;

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

3041: --
3042: --
3043: begin
3044: --
3045: -- hr_utility.set_location('Entering '||l_proc,10);
3046: --
3047: if g_cache_last_bal_rec.person_id = p_person_id and
3048: g_cache_last_bal_rec.bnfts_bal_id = p_bnfts_bal_id and
3049: nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3055: hr_utility.set_location('g_cache_last_bal_rec '||l_proc,10);

3051: between g_cache_last_bal_rec.effective_start_date
3052: and g_cache_last_bal_rec.effective_end_date then
3053: --
3054: p_rec := g_cache_last_bal_rec;
3055: hr_utility.set_location('g_cache_last_bal_rec '||l_proc,10);
3056: return;
3057: --
3058: end if;
3059: -- 1) Get hashed index

Line 3096: hr_utility.set_location('Before get_bal_per_object '||l_proc,10);

3092: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3093: p_effective_date)
3094: );
3095: --
3096: hr_utility.set_location('Before get_bal_per_object '||l_proc,10);
3097: get_bal_per_object
3098: (p_person_id => p_person_id,
3099: p_bnfts_bal_id => p_bnfts_bal_id,
3100: p_effective_date => l_effective_date,

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

3101: p_rec => p_rec);
3102: --
3103: g_cache_last_bal_rec := p_rec;
3104: --
3105: -- hr_utility.set_location('Leaving '||l_proc,10);
3106: --
3107: exception
3108: --
3109: when no_data_found then

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

3145: --
3146: --
3147: begin
3148: --
3149: -- hr_utility.set_location('Entering '||l_proc,10);
3150: --
3151: BEGIN
3152: if g_cache_last_con_rec(1).person_id = p_person_id then
3153: --115.23 no need for for loop, just make the assignment

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

3209: end if;
3210: --
3211: --p_rec := l_rec;
3212: --
3213: -- hr_utility.set_location('Leaving '||l_proc,10);
3214: --
3215: exception
3216: --
3217: when no_data_found then

Line 3250: g_debug := hr_utility.debug_enabled;

3246: --
3247: --
3248: begin
3249: --
3250: g_debug := hr_utility.debug_enabled;
3251: if g_debug then
3252: l_proc := g_package||'set_typ_object';
3253: hr_utility.set_location('Entering '||l_proc,10);
3254: end if;

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

3249: --
3250: g_debug := hr_utility.debug_enabled;
3251: if g_debug then
3252: l_proc := g_package||'set_typ_object';
3253: hr_utility.set_location('Entering '||l_proc,10);
3254: end if;
3255: --
3256: begin
3257: if g_cache_last_appass_rec(1).person_id = p_person_id then

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

3313: --115.23 no need
3314: --p_rec := l_rec;
3315: --
3316: if g_debug then
3317: hr_utility.set_location('Leaving '||l_proc,10);
3318: end if;
3319: --
3320: exception
3321: --

Line 3355: g_debug := hr_utility.debug_enabled;

3351: --
3352: --
3353: begin
3354: --
3355: g_debug := hr_utility.debug_enabled;
3356: if g_debug then
3357: l_proc := g_package||'get_allass_object ass';
3358: hr_utility.set_location('Entering '||l_proc,10);
3359: end if;

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

3354: --
3355: g_debug := hr_utility.debug_enabled;
3356: if g_debug then
3357: l_proc := g_package||'get_allass_object ass';
3358: hr_utility.set_location('Entering '||l_proc,10);
3359: end if;
3360: --
3361: begin
3362: if g_cache_last_allass_rec(1).person_id = p_person_id then

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

3423: --115.23 no need
3424: --p_rec := l_rec;
3425: --
3426: if g_debug then
3427: hr_utility.set_location('Leaving '||l_proc,10);
3428: end if;
3429: --
3430: exception
3431: --

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

3461: --
3462: --
3463: begin
3464: --
3465: -- hr_utility.set_location('Entering '||l_proc,10);
3466: --
3467: begin
3468: --
3469: if g_cache_last_typ_rec(1).person_id = p_person_id then

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

3525: end if;
3526: --115.23 unnecessary
3527: --p_rec := l_rec;
3528: --
3529: -- hr_utility.set_location('Leaving '||l_proc,10);
3530: --
3531: exception
3532: --
3533: when no_data_found then

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

3565: l_end_index pls_integer;
3566: --
3567: begin
3568: --
3569: -- hr_utility.set_location('Entering '||l_proc,10);
3570: --
3571: -- 1) Get hashed index
3572: -- 2) If hashed index is correct person_id then return pps
3573: -- 3) If hashed index is not correct person_id then check next index

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

3623: end loop;
3624: --
3625: end if;
3626: --
3627: -- hr_utility.set_location('Leaving '||l_proc,10);
3628: --
3629: exception
3630: --
3631: when no_data_found then

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

3652: --
3653: --
3654: begin
3655: --
3656: -- hr_utility.set_location('Entering '||l_proc,10);
3657: --
3658: if g_cache_last_date_rec.person_id = p_person_id then
3659: --
3660: p_rec := g_cache_last_date_rec;

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

3729: --
3730: --
3731: begin
3732: --
3733: -- hr_utility.set_location('Entering '||l_proc,10);
3734: --
3735: if g_cache_last_fte_rec.assignment_id = p_assignment_id then
3736: --
3737: p_rec := g_cache_last_fte_rec;

Line 3907: hr_utility.set_location('Entering '||l_proc,679);

3903: between paf.effective_start_date
3904: and paf.effective_end_date;
3905: begin
3906:
3907: hr_utility.set_location('Entering '||l_proc,679);
3908: --
3909: -- 1) Get record from database.
3910: -- 2) If record not found then raise error.
3911: -- 3) Pass record to set_object routine.

Line 3917: hr_utility.set_location('Entering '||l_proc,680);

3913: open c1;
3914: --
3915: fetch c1 into p_rec;
3916: if c1%notfound then
3917: hr_utility.set_location('Entering '||l_proc,680);
3918: l_found := FALSE;
3919: --
3920: end if;
3921: --

Line 3925: hr_utility.set_location('Entering '||l_proc,681);

3921: --
3922: close c1;
3923: --
3924: if l_found then
3925: hr_utility.set_location('Entering '||l_proc,681);
3926: set_object(p_rec => p_rec);
3927: end if;
3928: end set_ass_object;
3929:

Line 3945: hr_utility.set_location('Entering '||l_proc,670);

3941: --
3942: --
3943: begin
3944: --
3945: hr_utility.set_location('Entering '||l_proc,670);
3946: --
3947: if g_cache_last_ass_rec.person_id = p_person_id and
3948: g_cache_last_ass_rec.assignment_id = p_assignment_id then
3949: --

Line 3950: hr_utility.set_location('Entering '||l_proc,671);

3946: --
3947: if g_cache_last_ass_rec.person_id = p_person_id and
3948: g_cache_last_ass_rec.assignment_id = p_assignment_id then
3949: --
3950: hr_utility.set_location('Entering '||l_proc,671);
3951: p_rec := g_cache_last_ass_rec;
3952: return;
3953: --
3954: end if;

Line 3963: hr_utility.set_location('Entering '||l_proc,672);

3959: -- 4) Repest 3 until correct person_id found, if not found raise error.
3960: --
3961: -- Get hashed index value
3962: --
3963: hr_utility.set_location('Entering '||l_proc,672);
3964: l_index := mod(p_person_id,g_hash_key);
3965: --
3966: if g_cache_ass_rec(l_index).person_id = p_person_id and
3967: g_cache_ass_rec(l_index).assignment_id = p_assignment_id then

Line 3968: hr_utility.set_location('Entering '||l_proc,673);

3964: l_index := mod(p_person_id,g_hash_key);
3965: --
3966: if g_cache_ass_rec(l_index).person_id = p_person_id and
3967: g_cache_ass_rec(l_index).assignment_id = p_assignment_id then
3968: hr_utility.set_location('Entering '||l_proc,673);
3969: g_cache_last_ass_rec := g_cache_ass_rec(l_index);
3970: p_rec := g_cache_last_ass_rec;
3971: --
3972: else

Line 3977: hr_utility.set_location('Entering '||l_proc,674);

3973: --
3974: -- We need to loop through all the hashed indexes
3975: -- if none exists at current index the NO_DATA_FOUND expection will fire
3976: --
3977: hr_utility.set_location('Entering '||l_proc,674);
3978: l_index := l_index+g_hash_jump;
3979: while (g_cache_ass_rec(l_index).person_id <> p_person_id or
3980: g_cache_ass_rec(l_index).assignment_id <> p_assignment_id) loop
3981: --

Line 3983: hr_utility.set_location('Entering '||l_proc,675);

3979: while (g_cache_ass_rec(l_index).person_id <> p_person_id or
3980: g_cache_ass_rec(l_index).assignment_id <> p_assignment_id) loop
3981: --
3982: l_index := l_index+g_hash_jump;
3983: hr_utility.set_location('Entering '||l_proc,675);
3984: --
3985: end loop;
3986: --
3987: hr_utility.set_location('Entering '||l_proc,676);

Line 3987: hr_utility.set_location('Entering '||l_proc,676);

3983: hr_utility.set_location('Entering '||l_proc,675);
3984: --
3985: end loop;
3986: --
3987: hr_utility.set_location('Entering '||l_proc,676);
3988: g_cache_last_ass_rec := g_cache_ass_rec(l_index);
3989: p_rec := g_cache_last_ass_rec;
3990: --
3991: end if;

Line 3995: hr_utility.set_location('Entering '||l_proc,677);

3991: end if;
3992: exception
3993: --
3994: when no_data_found then
3995: hr_utility.set_location('Entering '||l_proc,677);
3996: ben_env_object.get(p_rec => l_env);
3997: --
3998: -- FONM
3999: --

Line 4005: hr_utility.set_location('Entering '||l_proc,678);

4001: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
4002: nvl(l_env.lf_evt_ocrd_dt,l_env.effective_date))
4003: );
4004: --
4005: hr_utility.set_location('Entering '||l_proc,678);
4006: set_ass_object(p_person_id => p_person_id,
4007: p_assignment_id => p_assignment_id,
4008: p_business_group_id => l_env.business_group_id,
4009: p_effective_date => l_effective_date,

Line 4012: hr_utility.set_location('Entering '||l_proc,682);

4008: p_business_group_id => l_env.business_group_id,
4009: p_effective_date => l_effective_date,
4010: p_rec => p_rec);
4011: --
4012: hr_utility.set_location('Entering '||l_proc,682);
4013: g_cache_last_ass_rec := p_rec;
4014: end get_assgn_object;
4015: /*End Enh: 13478736*/
4016: --