[Home] [Help]
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' BEN_CWB_CUSTOM_PERSON_V2_PKG.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: --
12:
13: -- --------------------------------------------------------------------------
31:
32: begin
33: --
34: if g_debug then
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
37: --
38: -- Customer can override p_years_employed here
39: return p_years_employed;
38: -- Customer can override p_years_employed here
39: return p_years_employed;
40: --
41: if g_debug then
42: hr_utility.set_location(' Leaving:'|| l_proc, 99);
43: end if;
44: --
45:
46: exception
44: --
45:
46: exception
47: when others then
48: hr_utility.set_location('Exception in '|| l_proc, 99);
49: raise;
50:
51: end;
52: -- --------------------------------------------------------------------------
69: --
70: begin
71: --
72: if g_debug then
73: hr_utility.set_location('Entering:'|| l_proc, 10);
74: end if;
75: --
76: -- Customer can override p_years_in_job here
77: return p_years_in_job;
76: -- Customer can override p_years_in_job here
77: return p_years_in_job;
78: --
79: if g_debug then
80: hr_utility.set_location(' Leaving:'|| l_proc, 99);
81: end if;
82: --
83:
84: exception
82: --
83:
84: exception
85: when others then
86: hr_utility.set_location('Exception in '|| l_proc, 99);
87: raise;
88:
89: end;
90: -- --------------------------------------------------------------------------
107: --
108: begin
109: --
110: if g_debug then
111: hr_utility.set_location('Entering:'|| l_proc, 10);
112: end if;
113: --
114: -- Customer can override p_years_in_position here
115: return p_years_in_position;
114: -- Customer can override p_years_in_position here
115: return p_years_in_position;
116: --
117: if g_debug then
118: hr_utility.set_location(' Leaving:'|| l_proc, 99);
119: end if;
120: --
121:
122: exception
120: --
121:
122: exception
123: when others then
124: hr_utility.set_location('Exception in '|| l_proc, 99);
125: raise;
126:
127: end;
128: -- --------------------------------------------------------------------------
145: --
146: begin
147: --
148: if g_debug then
149: hr_utility.set_location('Entering:'|| l_proc, 10);
150: end if;
151: --
152: -- Customer can override p_years_in_grade here
153: return p_years_in_grade;
152: -- Customer can override p_years_in_grade here
153: return p_years_in_grade;
154: --
155: if g_debug then
156: hr_utility.set_location(' Leaving:'|| l_proc, 99);
157: end if;
158: --
159:
160: exception
158: --
159:
160: exception
161: when others then
162: hr_utility.set_location('Exception in '|| l_proc, 99);
163: raise;
164:
165: end;
166: -- --------------------------------------------------------------------------
183: --
184: begin
185: --
186: if g_debug then
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: end if;
189: --
190: -- Customer can override p_base_salary here
191: return p_base_salary;
190: -- Customer can override p_base_salary here
191: return p_base_salary;
192: --
193: if g_debug then
194: hr_utility.set_location(' Leaving:'|| l_proc, 99);
195: end if;
196: --
197:
198: exception
196: --
197:
198: exception
199: when others then
200: hr_utility.set_location('Exception in '|| l_proc, 99);
201: raise;
202:
203: end;
204: -- --------------------------------------------------------------------------
221: --
222: begin
223: --
224: if g_debug then
225: hr_utility.set_location('Entering:'|| l_proc, 10);
226: end if;
227: --
228: -- Customer can override p_job_id here
229: return p_job_id;
228: -- Customer can override p_job_id here
229: return p_job_id;
230: --
231: if g_debug then
232: hr_utility.set_location(' Leaving:'|| l_proc, 99);
233: end if;
234: --
235:
236: exception
234: --
235:
236: exception
237: when others then
238: hr_utility.set_location('Exception in '|| l_proc, 99);
239: raise;
240:
241: end;
242: -- --------------------------------------------------------------------------
259: --
260: begin
261: --
262: if g_debug then
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: end if;
265: --
266: -- Customer can override p_grade_id here
267: return p_grade_id;
266: -- Customer can override p_grade_id here
267: return p_grade_id;
268: --
269: if g_debug then
270: hr_utility.set_location(' Leaving:'|| l_proc, 99);
271: end if;
272: --
273:
274: exception
272: --
273:
274: exception
275: when others then
276: hr_utility.set_location('Exception in '|| l_proc, 99);
277: raise;
278:
279: end;
280: -- --------------------------------------------------------------------------
297: --
298: begin
299: --
300: if g_debug then
301: hr_utility.set_location('Entering:'|| l_proc, 10);
302: end if;
303: --
304: -- Customer can override p_position_id here
305: return p_position_id;
304: -- Customer can override p_position_id here
305: return p_position_id;
306: --
307: if g_debug then
308: hr_utility.set_location(' Leaving:'|| l_proc, 99);
309: end if;
310: --
311:
312: exception
310: --
311:
312: exception
313: when others then
314: hr_utility.set_location('Exception in '|| l_proc, 99);
315: raise;
316:
317: end;
318: -- --------------------------------------------------------------------------
335: --
336: begin
337: --
338: if g_debug then
339: hr_utility.set_location('Entering:'|| l_proc, 10);
340: end if;
341: --
342: -- Customer can override p_people_group_id here
343: return p_people_group_id;
342: -- Customer can override p_people_group_id here
343: return p_people_group_id;
344: --
345: if g_debug then
346: hr_utility.set_location(' Leaving:'|| l_proc, 99);
347: end if;
348: --
349:
350: exception
348: --
349:
350: exception
351: when others then
352: hr_utility.set_location('Exception in '|| l_proc, 99);
353: raise;
354:
355: end;
356: -- --------------------------------------------------------------------------
373: --
374: begin
375: --
376: if g_debug then
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: end if;
379: --
380: -- Customer can override p_soft_coding_keyflex_id here
381: return p_soft_coding_keyflex_id;
380: -- Customer can override p_soft_coding_keyflex_id here
381: return p_soft_coding_keyflex_id;
382: --
383: if g_debug then
384: hr_utility.set_location(' Leaving:'|| l_proc, 99);
385: end if;
386: --
387:
388: exception
386: --
387:
388: exception
389: when others then
390: hr_utility.set_location('Exception in '|| l_proc, 99);
391: raise;
392:
393: end;
394: -- --------------------------------------------------------------------------
411: --
412: begin
413: --
414: if g_debug then
415: hr_utility.set_location('Entering:'|| l_proc, 10);
416: end if;
417: --
418: -- Customer can override p_location_id here
419: return p_location_id;
418: -- Customer can override p_location_id here
419: return p_location_id;
420: --
421: if g_debug then
422: hr_utility.set_location(' Leaving:'|| l_proc, 99);
423: end if;
424: --
425:
426: exception
424: --
425:
426: exception
427: when others then
428: hr_utility.set_location('Exception in '|| l_proc, 99);
429: raise;
430:
431: end;
432: -- --------------------------------------------------------------------------
449: --
450: begin
451: --
452: if g_debug then
453: hr_utility.set_location('Entering:'|| l_proc, 10);
454: end if;
455: --
456: -- Customer can override p_pay_rate_id here
457: return p_pay_rate_id;
456: -- Customer can override p_pay_rate_id here
457: return p_pay_rate_id;
458: --
459: if g_debug then
460: hr_utility.set_location(' Leaving:'|| l_proc, 99);
461: end if;
462: --
463:
464: exception
462: --
463:
464: exception
465: when others then
466: hr_utility.set_location('Exception in '|| l_proc, 99);
467: raise;
468:
469: end;
470: -- --------------------------------------------------------------------------
487: --
488: begin
489: --
490: if g_debug then
491: hr_utility.set_location('Entering:'|| l_proc, 10);
492: end if;
493: --
494: -- Customer can override p_assignment_status_type_id here
495: return p_assignment_status_type_id;
494: -- Customer can override p_assignment_status_type_id here
495: return p_assignment_status_type_id;
496: --
497: if g_debug then
498: hr_utility.set_location(' Leaving:'|| l_proc, 99);
499: end if;
500: --
501:
502: exception
500: --
501:
502: exception
503: when others then
504: hr_utility.set_location('Exception in '|| l_proc, 99);
505: raise;
506:
507: end;
508: -- --------------------------------------------------------------------------
525: --
526: begin
527: --
528: if g_debug then
529: hr_utility.set_location('Entering:'|| l_proc, 10);
530: end if;
531: --
532: -- Customer can override p_grade_annulization_factor here
533: return p_grade_annulization_factor;
532: -- Customer can override p_grade_annulization_factor here
533: return p_grade_annulization_factor;
534: --
535: if g_debug then
536: hr_utility.set_location(' Leaving:'|| l_proc, 99);
537: end if;
538: --
539:
540: exception
538: --
539:
540: exception
541: when others then
542: hr_utility.set_location('Exception in '|| l_proc, 99);
543: raise;
544:
545: end;
546: -- --------------------------------------------------------------------------
563: --
564: begin
565: --
566: if g_debug then
567: hr_utility.set_location('Entering:'|| l_proc, 10);
568: end if;
569: --
570: -- Customer can override p_pay_annulization_factor here
571: return p_pay_annulization_factor;
570: -- Customer can override p_pay_annulization_factor here
571: return p_pay_annulization_factor;
572: --
573: if g_debug then
574: hr_utility.set_location(' Leaving:'|| l_proc, 99);
575: end if;
576: --
577:
578: exception
576: --
577:
578: exception
579: when others then
580: hr_utility.set_location('Exception in '|| l_proc, 99);
581: raise;
582:
583: end;
584: -- --------------------------------------------------------------------------
601: --
602: begin
603: --
604: if g_debug then
605: hr_utility.set_location('Entering:'|| l_proc, 10);
606: end if;
607: --
608: -- Customer can override p_grd_min_val here
609: return p_grd_min_val;
608: -- Customer can override p_grd_min_val here
609: return p_grd_min_val;
610: --
611: if g_debug then
612: hr_utility.set_location(' Leaving:'|| l_proc, 99);
613: end if;
614: --
615:
616: exception
614: --
615:
616: exception
617: when others then
618: hr_utility.set_location('Exception in '|| l_proc, 99);
619: raise;
620:
621: end;
622: -- --------------------------------------------------------------------------
639: --
640: begin
641: --
642: if g_debug then
643: hr_utility.set_location('Entering:'|| l_proc, 10);
644: end if;
645: --
646: -- Customer can override p_grd_max_val here
647: return p_grd_max_val;
646: -- Customer can override p_grd_max_val here
647: return p_grd_max_val;
648: --
649: if g_debug then
650: hr_utility.set_location(' Leaving:'|| l_proc, 99);
651: end if;
652: --
653:
654: exception
652: --
653:
654: exception
655: when others then
656: hr_utility.set_location('Exception in '|| l_proc, 99);
657: raise;
658:
659: end;
660: -- --------------------------------------------------------------------------
677: --
678: begin
679: --
680: if g_debug then
681: hr_utility.set_location('Entering:'|| l_proc, 10);
682: end if;
683: --
684: -- Customer can override p_grd_mid_point here
685: return p_grd_mid_point;
684: -- Customer can override p_grd_mid_point here
685: return p_grd_mid_point;
686: --
687: if g_debug then
688: hr_utility.set_location(' Leaving:'|| l_proc, 99);
689: end if;
690: --
691:
692: exception
690: --
691:
692: exception
693: when others then
694: hr_utility.set_location('Exception in '|| l_proc, 99);
695: raise;
696:
697: end;
698: -- --------------------------------------------------------------------------
715: --
716: begin
717: --
718: if g_debug then
719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: end if;
721: --
722: -- Customer can override p_fte_factor here
723: return p_fte_factor;
722: -- Customer can override p_fte_factor here
723: return p_fte_factor;
724: --
725: if g_debug then
726: hr_utility.set_location(' Leaving:'|| l_proc, 99);
727: end if;
728: --
729:
730: exception
728: --
729:
730: exception
731: when others then
732: hr_utility.set_location('Exception in '|| l_proc, 99);
733: raise;
734:
735: end;
736: -- --------------------------------------------------------------------------
753: --
754: begin
755: --
756: if g_debug then
757: hr_utility.set_location('Entering:'|| l_proc, 10);
758: end if;
759: --
760: -- Customer can override p_grd_pct_in_range here
761: return p_grd_pct_in_range;
760: -- Customer can override p_grd_pct_in_range here
761: return p_grd_pct_in_range;
762: --
763: if g_debug then
764: hr_utility.set_location(' Leaving:'|| l_proc, 99);
765: end if;
766: --
767:
768: exception
766: --
767:
768: exception
769: when others then
770: hr_utility.set_location('Exception in '|| l_proc, 99);
771: raise;
772:
773: end;
774: -- --------------------------------------------------------------------------
791: --
792: begin
793: --
794: if g_debug then
795: hr_utility.set_location('Entering:'|| l_proc, 10);
796: end if;
797: --
798: -- Customer can override p_salary_1_year_ago here
799: return p_salary_1_year_ago;
798: -- Customer can override p_salary_1_year_ago here
799: return p_salary_1_year_ago;
800: --
801: if g_debug then
802: hr_utility.set_location(' Leaving:'|| l_proc, 99);
803: end if;
804: --
805:
806: exception
804: --
805:
806: exception
807: when others then
808: hr_utility.set_location('Exception in '|| l_proc, 99);
809: raise;
810:
811: end;
812: -- --------------------------------------------------------------------------
829: --
830: begin
831: --
832: if g_debug then
833: hr_utility.set_location('Entering:'|| l_proc, 10);
834: end if;
835: --
836: -- Customer can override p_salary_1_year_ago_ann_fctr here
837: return p_salary_1_year_ago_ann_fctr;
836: -- Customer can override p_salary_1_year_ago_ann_fctr here
837: return p_salary_1_year_ago_ann_fctr;
838: --
839: if g_debug then
840: hr_utility.set_location(' Leaving:'|| l_proc, 99);
841: end if;
842: --
843:
844: exception
842: --
843:
844: exception
845: when others then
846: hr_utility.set_location('Exception in '|| l_proc, 99);
847: raise;
848:
849: end;
850: -- --------------------------------------------------------------------------
867: --
868: begin
869: --
870: if g_debug then
871: hr_utility.set_location('Entering:'|| l_proc, 10);
872: end if;
873: --
874: -- Customer can override p_salary_1_year_ago_ann_fctr here
875: return p_salary_2_year_ago;
874: -- Customer can override p_salary_1_year_ago_ann_fctr here
875: return p_salary_2_year_ago;
876: --
877: if g_debug then
878: hr_utility.set_location(' Leaving:'|| l_proc, 99);
879: end if;
880: --
881:
882: exception
880: --
881:
882: exception
883: when others then
884: hr_utility.set_location('Exception in '|| l_proc, 99);
885: raise;
886:
887: end;
888: -- --------------------------------------------------------------------------
905: --
906: begin
907: --
908: if g_debug then
909: hr_utility.set_location('Entering:'|| l_proc, 10);
910: end if;
911: --
912: -- Customer can override p_salary_2_year_ago_ann_fctr here
913: return p_salary_2_year_ago_ann_fctr;
912: -- Customer can override p_salary_2_year_ago_ann_fctr here
913: return p_salary_2_year_ago_ann_fctr;
914: --
915: if g_debug then
916: hr_utility.set_location(' Leaving:'|| l_proc, 99);
917: end if;
918: --
919:
920: exception
918: --
919:
920: exception
921: when others then
922: hr_utility.set_location('Exception in '|| l_proc, 99);
923: raise;
924:
925: end;
926: -- --------------------------------------------------------------------------
943: --
944: begin
945: --
946: if g_debug then
947: hr_utility.set_location('Entering:'|| l_proc, 10);
948: end if;
949: --
950: -- Customer can override p_salary_3_year_ago here
951: return p_salary_3_year_ago;
950: -- Customer can override p_salary_3_year_ago here
951: return p_salary_3_year_ago;
952: --
953: if g_debug then
954: hr_utility.set_location(' Leaving:'|| l_proc, 99);
955: end if;
956: --
957:
958: exception
956: --
957:
958: exception
959: when others then
960: hr_utility.set_location('Exception in '|| l_proc, 99);
961: raise;
962:
963: end;
964: -- --------------------------------------------------------------------------
981: --
982: begin
983: --
984: if g_debug then
985: hr_utility.set_location('Entering:'|| l_proc, 10);
986: end if;
987: --
988: -- Customer can override p_salary_3_year_ago_ann_fctr here
989: return p_salary_3_year_ago_ann_fctr;
988: -- Customer can override p_salary_3_year_ago_ann_fctr here
989: return p_salary_3_year_ago_ann_fctr;
990: --
991: if g_debug then
992: hr_utility.set_location(' Leaving:'|| l_proc, 99);
993: end if;
994: --
995:
996: exception
994: --
995:
996: exception
997: when others then
998: hr_utility.set_location('Exception in '|| l_proc, 99);
999: raise;
1000:
1001: end;
1002: -- --------------------------------------------------------------------------
1019: --
1020: begin
1021: --
1022: if g_debug then
1023: hr_utility.set_location('Entering:'|| l_proc, 10);
1024: end if;
1025: --
1026: -- Customer can override p_salary_4_year_ago here
1027: return p_salary_4_year_ago;
1026: -- Customer can override p_salary_4_year_ago here
1027: return p_salary_4_year_ago;
1028: --
1029: if g_debug then
1030: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1031: end if;
1032: --
1033:
1034: exception
1032: --
1033:
1034: exception
1035: when others then
1036: hr_utility.set_location('Exception in '|| l_proc, 99);
1037: raise;
1038:
1039: end;
1040: -- --------------------------------------------------------------------------
1057: --
1058: begin
1059: --
1060: if g_debug then
1061: hr_utility.set_location('Entering:'|| l_proc, 10);
1062: end if;
1063: --
1064: -- Customer can override p_salary_4_year_ago_ann_fctr here
1065: return p_salary_4_year_ago_ann_fctr;
1064: -- Customer can override p_salary_4_year_ago_ann_fctr here
1065: return p_salary_4_year_ago_ann_fctr;
1066: --
1067: if g_debug then
1068: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1069: end if;
1070: --
1071:
1072: exception
1070: --
1071:
1072: exception
1073: when others then
1074: hr_utility.set_location('Exception in '|| l_proc, 99);
1075: raise;
1076:
1077: end;
1078: -- --------------------------------------------------------------------------
1095: --
1096: begin
1097: --
1098: if g_debug then
1099: hr_utility.set_location('Entering:'|| l_proc, 10);
1100: end if;
1101: --
1102: -- Customer can override p_salary_5_year_ago here
1103: return p_salary_5_year_ago;
1102: -- Customer can override p_salary_5_year_ago here
1103: return p_salary_5_year_ago;
1104: --
1105: if g_debug then
1106: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1107: end if;
1108: --
1109:
1110: exception
1108: --
1109:
1110: exception
1111: when others then
1112: hr_utility.set_location('Exception in '|| l_proc, 99);
1113: raise;
1114:
1115: end;
1116: -- --------------------------------------------------------------------------
1133: --
1134: begin
1135: --
1136: if g_debug then
1137: hr_utility.set_location('Entering:'|| l_proc, 10);
1138: end if;
1139: --
1140: -- Customer can override p_salary_5_year_ago_ann_fctr here
1141: return p_salary_5_year_ago_ann_fctr;
1140: -- Customer can override p_salary_5_year_ago_ann_fctr here
1141: return p_salary_5_year_ago_ann_fctr;
1142: --
1143: if g_debug then
1144: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1145: end if;
1146: --
1147:
1148: exception
1146: --
1147:
1148: exception
1149: when others then
1150: hr_utility.set_location('Exception in '|| l_proc, 99);
1151: raise;
1152:
1153: end;
1154: -- --------------------------------------------------------------------------
1171: --
1172: begin
1173: --
1174: if g_debug then
1175: hr_utility.set_location('Entering:'|| l_proc, 10);
1176: end if;
1177: --
1178: -- Customer can override p_prev_sal here
1179: return p_prev_sal;
1178: -- Customer can override p_prev_sal here
1179: return p_prev_sal;
1180: --
1181: if g_debug then
1182: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1183: end if;
1184: --
1185:
1186: exception
1184: --
1185:
1186: exception
1187: when others then
1188: hr_utility.set_location('Exception in '|| l_proc, 99);
1189: raise;
1190:
1191: end;
1192: -- --------------------------------------------------------------------------
1209: --
1210: begin
1211: --
1212: if g_debug then
1213: hr_utility.set_location('Entering:'|| l_proc, 10);
1214: end if;
1215: --
1216: -- Customer can override p_prev_sal_ann_fctr here
1217: return p_prev_sal_ann_fctr;
1216: -- Customer can override p_prev_sal_ann_fctr here
1217: return p_prev_sal_ann_fctr;
1218: --
1219: if g_debug then
1220: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1221: end if;
1222: --
1223:
1224: exception
1222: --
1223:
1224: exception
1225: when others then
1226: hr_utility.set_location('Exception in '|| l_proc, 99);
1227: raise;
1228:
1229: end;
1230: ---- --------------------------------------------------------------------------
1247: --
1248: begin
1249: --
1250: if g_debug then
1251: hr_utility.set_location('Entering:'|| l_proc, 10);
1252: end if;
1253: --
1254: -- Customer can override p_mkt_annualization_factor here
1255: return p_mkt_annualization_factor;
1254: -- Customer can override p_mkt_annualization_factor here
1255: return p_mkt_annualization_factor;
1256: --
1257: if g_debug then
1258: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1259: end if;
1260: --
1261:
1262: exception
1260: --
1261:
1262: exception
1263: when others then
1264: hr_utility.set_location('Exception in '|| l_proc, 99);
1265: raise;
1266:
1267: end;
1268: --------------------------------------------------------------------------
1285: --
1286: begin
1287: --
1288: if g_debug then
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: end if;
1291: --
1292: -- Customer can override p_mkt_min_salary here
1293: return p_mkt_min_salary;
1292: -- Customer can override p_mkt_min_salary here
1293: return p_mkt_min_salary;
1294: --
1295: if g_debug then
1296: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1297: end if;
1298: --
1299:
1300: exception
1298: --
1299:
1300: exception
1301: when others then
1302: hr_utility.set_location('Exception in '|| l_proc, 99);
1303: raise;
1304:
1305: end;
1306: --------------------------------------------------------------------------
1323: --
1324: begin
1325: --
1326: if g_debug then
1327: hr_utility.set_location('Entering:'|| l_proc, 10);
1328: end if;
1329: --
1330: -- Customer can override p_mkt_25pct_salary here
1331: return p_mkt_25pct_salary;
1330: -- Customer can override p_mkt_25pct_salary here
1331: return p_mkt_25pct_salary;
1332: --
1333: if g_debug then
1334: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1335: end if;
1336: --
1337:
1338: exception
1336: --
1337:
1338: exception
1339: when others then
1340: hr_utility.set_location('Exception in '|| l_proc, 99);
1341: raise;
1342:
1343: end;
1344: --------------------------------------------------------------------------
1361: --
1362: begin
1363: --
1364: if g_debug then
1365: hr_utility.set_location('Entering:'|| l_proc, 10);
1366: end if;
1367: --
1368: -- Customer can override p_mkt_mid_salary here
1369: return p_mkt_mid_salary;
1368: -- Customer can override p_mkt_mid_salary here
1369: return p_mkt_mid_salary;
1370: --
1371: if g_debug then
1372: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1373: end if;
1374: --
1375:
1376: exception
1374: --
1375:
1376: exception
1377: when others then
1378: hr_utility.set_location('Exception in '|| l_proc, 99);
1379: raise;
1380:
1381: end;
1382: --------------------------------------------------------------------------
1399: --
1400: begin
1401: --
1402: if g_debug then
1403: hr_utility.set_location('Entering:'|| l_proc, 10);
1404: end if;
1405: --
1406: -- Customer can override p_mkt_75pct_salary here
1407: return p_mkt_75pct_salary;
1406: -- Customer can override p_mkt_75pct_salary here
1407: return p_mkt_75pct_salary;
1408: --
1409: if g_debug then
1410: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1411: end if;
1412: --
1413:
1414: exception
1412: --
1413:
1414: exception
1415: when others then
1416: hr_utility.set_location('Exception in '|| l_proc, 99);
1417: raise;
1418:
1419: end;
1420:
1439: --
1440: begin
1441: --
1442: if g_debug then
1443: hr_utility.set_location('Entering:'|| l_proc, 10);
1444: end if;
1445: --
1446: -- Customer can override p_mkt_max_salary here
1447: return p_mkt_max_salary;
1446: -- Customer can override p_mkt_max_salary here
1447: return p_mkt_max_salary;
1448: --
1449: if g_debug then
1450: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1451: end if;
1452: --
1453:
1454: exception
1452: --
1453:
1454: exception
1455: when others then
1456: hr_utility.set_location('Exception in '|| l_proc, 99);
1457: raise;
1458:
1459: end;
1460:
1479: --
1480: begin
1481: --
1482: if g_debug then
1483: hr_utility.set_location('Entering:'|| l_proc, 10);
1484: end if;
1485: --
1486: -- Customer can override p_mkt_emp_pct_in_range here
1487: return p_mkt_emp_pct_in_range;
1486: -- Customer can override p_mkt_emp_pct_in_range here
1487: return p_mkt_emp_pct_in_range;
1488: --
1489: if g_debug then
1490: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1491: end if;
1492: --
1493:
1494: exception
1492: --
1493:
1494: exception
1495: when others then
1496: hr_utility.set_location('Exception in '|| l_proc, 99);
1497: raise;
1498:
1499: end;
1500:
1518: --
1519: begin
1520: --
1521: if g_debug then
1522: hr_utility.set_location('Entering:'|| l_proc, 10);
1523: end if;
1524: --
1525: -- Customer can override p_mkt_emp_comparatio here
1526: return p_mkt_emp_comparatio;
1525: -- Customer can override p_mkt_emp_comparatio here
1526: return p_mkt_emp_comparatio;
1527: --
1528: if g_debug then
1529: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1530: end if;
1531: --
1532:
1533: exception
1531: --
1532:
1533: exception
1534: when others then
1535: hr_utility.set_location('Exception in '|| l_proc, 99);
1536: raise;
1537:
1538: end;
1539:
1557: --
1558: begin
1559: --
1560: if g_debug then
1561: hr_utility.set_location('Entering:'|| l_proc, 10);
1562: end if;
1563: --
1564: -- Customer can override p_mkt_survey_id here
1565:
1565:
1566: return p_mkt_survey_id;
1567: --
1568: if g_debug then
1569: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1570: end if;
1571: --
1572:
1573: exception
1571: --
1572:
1573: exception
1574: when others then
1575: hr_utility.set_location('Exception in '|| l_proc, 99);
1576: raise;
1577:
1578: end;
1579: ----
1598:
1599: begin
1600: --
1601: if g_debug then
1602: hr_utility.set_location('Entering:'|| l_proc, 10);
1603: end if;
1604: --
1605: -- Customer can override p_grd_comparatio here
1606: return p_grd_comparatio;
1605: -- Customer can override p_grd_comparatio here
1606: return p_grd_comparatio;
1607: --
1608: if g_debug then
1609: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1610: end if;
1611: --
1612:
1613: exception
1611: --
1612:
1613: exception
1614: when others then
1615: hr_utility.set_location('Exception in '|| l_proc, 99);
1616: raise;
1617:
1618: end;
1619:
1638:
1639: begin
1640: --
1641: if g_debug then
1642: hr_utility.set_location('Entering:'|| l_proc, 10);
1643: end if;
1644: --
1645: -- Customer can override p_normal_hours here
1646: return p_normal_hours;
1645: -- Customer can override p_normal_hours here
1646: return p_normal_hours;
1647: --
1648: if g_debug then
1649: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1650: end if;
1651: --
1652:
1653: exception
1651: --
1652:
1653: exception
1654: when others then
1655: hr_utility.set_location('Exception in '|| l_proc, 99);
1656: raise;
1657:
1658: end;
1659:
1677: --
1678: begin
1679: --
1680: if g_debug then
1681: hr_utility.set_location('Entering:'|| l_proc, 10);
1682: end if;
1683: --
1684: -- Customer can override p_performance_rating_date here
1685: return p_performance_rating_date;
1684: -- Customer can override p_performance_rating_date here
1685: return p_performance_rating_date;
1686: --
1687: if g_debug then
1688: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1689: end if;
1690: --
1691:
1692: exception
1690: --
1691:
1692: exception
1693: when others then
1694: hr_utility.set_location('Exception in '|| l_proc, 99);
1695: raise;
1696:
1697: end;
1698:
1717:
1718: begin
1719: --
1720: if g_debug then
1721: hr_utility.set_location('Entering:'|| l_proc, 10);
1722: end if;
1723: --
1724: -- Customer can override p_start_date here
1725: return p_start_date;
1724: -- Customer can override p_start_date here
1725: return p_start_date;
1726: --
1727: if g_debug then
1728: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1729: end if;
1730: --
1731:
1732: exception
1730: --
1731:
1732: exception
1733: when others then
1734: hr_utility.set_location('Exception in '|| l_proc, 99);
1735: raise;
1736:
1737: end;
1738:
1757:
1758: begin
1759: --
1760: if g_debug then
1761: hr_utility.set_location('Entering:'|| l_proc, 10);
1762: end if;
1763: --
1764: -- Customer can override p_original_start_date here
1765: return p_original_start_date;
1764: -- Customer can override p_original_start_date here
1765: return p_original_start_date;
1766: --
1767: if g_debug then
1768: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1769: end if;
1770: --
1771:
1772: exception
1770: --
1771:
1772: exception
1773: when others then
1774: hr_utility.set_location('Exception in '|| l_proc, 99);
1775: raise;
1776:
1777: end;
1778:
1796: --
1797: begin
1798: --
1799: if g_debug then
1800: hr_utility.set_location('Entering:'|| l_proc, 10);
1801: end if;
1802: --
1803: -- Customer can override p_adjusted_svc_date here
1804: return p_adjusted_svc_date;
1803: -- Customer can override p_adjusted_svc_date here
1804: return p_adjusted_svc_date;
1805: --
1806: if g_debug then
1807: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1808: end if;
1809: --
1810:
1811: exception
1809: --
1810:
1811: exception
1812: when others then
1813: hr_utility.set_location('Exception in '|| l_proc, 99);
1814: raise;
1815:
1816: end;
1817:
1835: --
1836: begin
1837: --
1838: if g_debug then
1839: hr_utility.set_location('Entering:'|| l_proc, 10);
1840: end if;
1841: --
1842: -- Customer can override p_prev_sal_chg_date here
1843: return p_prev_sal_chg_date;
1842: -- Customer can override p_prev_sal_chg_date here
1843: return p_prev_sal_chg_date;
1844: --
1845: if g_debug then
1846: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1847: end if;
1848: --
1849:
1850: exception
1848: --
1849:
1850: exception
1851: when others then
1852: hr_utility.set_location('Exception in '|| l_proc, 99);
1853: raise;
1854:
1855: end;
1856: --------------------------------------------------------------------------
1874:
1875: begin
1876: --
1877: if g_debug then
1878: hr_utility.set_location('Entering:'|| l_proc, 10);
1879: end if;
1880: --
1881: -- Customer can override p_feedback_date here
1882: return p_feedback_date;
1881: -- Customer can override p_feedback_date here
1882: return p_feedback_date;
1883: --
1884: if g_debug then
1885: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1886: end if;
1887: --
1888:
1889: exception
1887: --
1888:
1889: exception
1890: when others then
1891: hr_utility.set_location('Exception in '|| l_proc, 99);
1892: raise;
1893:
1894: end;
1895:
1913: --
1914: begin
1915: --
1916: if g_debug then
1917: hr_utility.set_location('Entering:'|| l_proc, 10);
1918: end if;
1919: --
1920: -- Customer can override p_base_salary_change_date here
1921: return p_base_salary_change_date;
1920: -- Customer can override p_base_salary_change_date here
1921: return p_base_salary_change_date;
1922: --
1923: if g_debug then
1924: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1925: end if;
1926: --
1927:
1928: exception
1926: --
1927:
1928: exception
1929: when others then
1930: hr_utility.set_location('Exception in '|| l_proc, 99);
1931: raise;
1932:
1933: end;
1934:
1952:
1953: begin
1954: --
1955: if g_debug then
1956: hr_utility.set_location('Entering:'|| l_proc, 10);
1957: end if;
1958: --
1959: -- Customer can override p_full_name here
1960: return p_full_name;
1959: -- Customer can override p_full_name here
1960: return p_full_name;
1961: --
1962: if g_debug then
1963: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1964: end if;
1965: --
1966:
1967: exception
1965: --
1966:
1967: exception
1968: when others then
1969: hr_utility.set_location('Exception in '|| l_proc, 99);
1970: raise;
1971:
1972: end;
1973: --
1990: --
1991: begin
1992: --
1993: if g_debug then
1994: hr_utility.set_location('Entering:'|| l_proc, 10);
1995: end if;
1996: --
1997: -- Customer can override p_brief_name here
1998: return p_brief_name;
1997: -- Customer can override p_brief_name here
1998: return p_brief_name;
1999: --
2000: if g_debug then
2001: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2002: end if;
2003: --
2004:
2005: exception
2003: --
2004:
2005: exception
2006: when others then
2007: hr_utility.set_location('Exception in '|| l_proc, 99);
2008: raise;
2009:
2010: end;
2011: -- --------------------------------------------------------------------------
2027: --
2028: begin
2029: --
2030: if g_debug then
2031: hr_utility.set_location('Entering:'|| l_proc, 10);
2032: end if;
2033: --
2034: -- Customer can override p_supervisor_full_name here
2035: return p_supervisor_full_name;
2034: -- Customer can override p_supervisor_full_name here
2035: return p_supervisor_full_name;
2036: --
2037: if g_debug then
2038: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2039: end if;
2040: --
2041:
2042: exception
2040: --
2041:
2042: exception
2043: when others then
2044: hr_utility.set_location('Exception in '|| l_proc, 99);
2045: raise;
2046:
2047: end;
2048: -- --------------------------------------------------------------------------
2064: --
2065: begin
2066: --
2067: if g_debug then
2068: hr_utility.set_location('Entering:'|| l_proc, 10);
2069: end if;
2070: --
2071: -- Customer can override p_supervisor_brief_name here
2072: return p_supervisor_brief_name;
2071: -- Customer can override p_supervisor_brief_name here
2072: return p_supervisor_brief_name;
2073: --
2074: if g_debug then
2075: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2076: end if;
2077: --
2078:
2079: exception
2077: --
2078:
2079: exception
2080: when others then
2081: hr_utility.set_location('Exception in '|| l_proc, 99);
2082: raise;
2083:
2084: end;
2085: -- --------------------------------------------------------------------------
2101: --
2102: begin
2103: --
2104: if g_debug then
2105: hr_utility.set_location('Entering:'|| l_proc, 10);
2106: end if;
2107: --
2108: -- Customer can override p_supervisor_custom_name here
2109: return p_supervisor_custom_name;
2108: -- Customer can override p_supervisor_custom_name here
2109: return p_supervisor_custom_name;
2110: --
2111: if g_debug then
2112: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2113: end if;
2114: --
2115:
2116: exception
2114: --
2115:
2116: exception
2117: when others then
2118: hr_utility.set_location('Exception in '|| l_proc, 99);
2119: raise;
2120:
2121: end;
2122: -- --------------------------------------------------------------------------
2138: --
2139: begin
2140: --
2141: if g_debug then
2142: hr_utility.set_location('Entering:'|| l_proc, 10);
2143: end if;
2144: --
2145: -- Customer can override p_payroll_name here
2146: return p_payroll_name;
2145: -- Customer can override p_payroll_name here
2146: return p_payroll_name;
2147: --
2148: if g_debug then
2149: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2150: end if;
2151: --
2152:
2153: exception
2151: --
2152:
2153: exception
2154: when others then
2155: hr_utility.set_location('Exception in '|| l_proc, 99);
2156: raise;
2157:
2158: end;
2159: -- --------------------------------------------------------------------------
2176:
2177: begin
2178: --
2179: if g_debug then
2180: hr_utility.set_location('Entering:'|| l_proc, 10);
2181: end if;
2182: --
2183: -- Customer can override p_performance_rating here
2184: return p_performance_rating;
2183: -- Customer can override p_performance_rating here
2184: return p_performance_rating;
2185: --
2186: if g_debug then
2187: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2188: end if;
2189: --
2190:
2191: exception
2189: --
2190:
2191: exception
2192: when others then
2193: hr_utility.set_location('Exception in '|| l_proc, 99);
2194: raise;
2195:
2196: end;
2197: -- --------------------------------------------------------------------------
2213: --
2214: begin
2215: --
2216: if g_debug then
2217: hr_utility.set_location('Entering:'|| l_proc, 10);
2218: end if;
2219: --
2220: -- Customer can override p_performance_rating_type here
2221: return p_performance_rating_type;
2220: -- Customer can override p_performance_rating_type here
2221: return p_performance_rating_type;
2222: --
2223: if g_debug then
2224: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2225: end if;
2226: --
2227:
2228: exception
2226: --
2227:
2228: exception
2229: when others then
2230: hr_utility.set_location('Exception in '|| l_proc, 99);
2231: raise;
2232:
2233: end;
2234: -- --------------------------------------------------------------------------
2250: --
2251: begin
2252: --
2253: if g_debug then
2254: hr_utility.set_location('Entering:'|| l_proc, 10);
2255: end if;
2256: --
2257: -- Customer can override p_frequency here
2258: return p_frequency;
2257: -- Customer can override p_frequency here
2258: return p_frequency;
2259: --
2260: if g_debug then
2261: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2262: end if;
2263: --
2264:
2265: exception
2263: --
2264:
2265: exception
2266: when others then
2267: hr_utility.set_location('Exception in '|| l_proc, 99);
2268: raise;
2269:
2270: end;
2271: -- --------------------------------------------------------------------------
2287: --
2288: begin
2289: --
2290: if g_debug then
2291: hr_utility.set_location('Entering:'|| l_proc, 10);
2292: end if;
2293: --
2294: -- Customer can override p_grd_quartile here
2295: return p_grd_quartile;
2294: -- Customer can override p_grd_quartile here
2295: return p_grd_quartile;
2296: --
2297: if g_debug then
2298: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2299: end if;
2300: --
2301:
2302: exception
2300: --
2301:
2302: exception
2303: when others then
2304: hr_utility.set_location('Exception in '|| l_proc, 99);
2305: raise;
2306:
2307: end;
2308: -- --------------------------------------------------------------------------
2324: --
2325: begin
2326: --
2327: if g_debug then
2328: hr_utility.set_location('Entering:'|| l_proc, 10);
2329: end if;
2330: --
2331: -- Customer can override p_emp_category here
2332: return p_emp_category;
2331: -- Customer can override p_emp_category here
2332: return p_emp_category;
2333: --
2334: if g_debug then
2335: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2336: end if;
2337: --
2338:
2339: exception
2337: --
2338:
2339: exception
2340: when others then
2341: hr_utility.set_location('Exception in '|| l_proc, 99);
2342: raise;
2343:
2344: end;
2345: -- --------------------------------------------------------------------------
2361: --
2362: begin
2363: --
2364: if g_debug then
2365: hr_utility.set_location('Entering:'|| l_proc, 10);
2366: end if;
2367: --
2368: -- Customer can override p_change_reason here
2369: return p_change_reason;
2368: -- Customer can override p_change_reason here
2369: return p_change_reason;
2370: --
2371: if g_debug then
2372: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2373: end if;
2374: --
2375:
2376: exception
2374: --
2375:
2376: exception
2377: when others then
2378: hr_utility.set_location('Exception in '|| l_proc, 99);
2379: raise;
2380:
2381: end;
2382: -- --------------------------------------------------------------------------
2398: --
2399: begin
2400: --
2401: if g_debug then
2402: hr_utility.set_location('Entering:'|| l_proc, 10);
2403: end if;
2404: --
2405: -- Customer can override p_email_address here
2406: return p_email_address;
2405: -- Customer can override p_email_address here
2406: return p_email_address;
2407: --
2408: if g_debug then
2409: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2410: end if;
2411: --
2412:
2413: exception
2411: --
2412:
2413: exception
2414: when others then
2415: hr_utility.set_location('Exception in '|| l_proc, 99);
2416: raise;
2417:
2418: end;
2419: -- --------------------------------------------------------------------------
2435: --
2436: begin
2437: --
2438: if g_debug then
2439: hr_utility.set_location('Entering:'|| l_proc, 10);
2440: end if;
2441: --
2442: -- Customer can override p_base_salary_frequency here
2443: return p_base_salary_frequency;
2442: -- Customer can override p_base_salary_frequency here
2443: return p_base_salary_frequency;
2444: --
2445: if g_debug then
2446: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2447: end if;
2448: --
2449:
2450: exception
2448: --
2449:
2450: exception
2451: when others then
2452: hr_utility.set_location('Exception in '|| l_proc, 99);
2453: raise;
2454:
2455: end;
2456: -- --------------------------------------------------------------------------
2472: --
2473: begin
2474: --
2475: if g_debug then
2476: hr_utility.set_location('Entering:'|| l_proc, 10);
2477: end if;
2478: --
2479: -- Customer can override p_post_process_stat_cd here
2480: return p_post_process_stat_cd;
2479: -- Customer can override p_post_process_stat_cd here
2480: return p_post_process_stat_cd;
2481: --
2482: if g_debug then
2483: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2484: end if;
2485: --
2486:
2487: exception
2485: --
2486:
2487: exception
2488: when others then
2489: hr_utility.set_location('Exception in '|| l_proc, 99);
2490: raise;
2491:
2492: end;
2493: -- --------------------------------------------------------------------------
2509: --
2510: begin
2511: --
2512: if g_debug then
2513: hr_utility.set_location('Entering:'|| l_proc, 10);
2514: end if;
2515: --
2516: -- Customer can override p_feedback_rating here
2517: return p_feedback_rating;
2516: -- Customer can override p_feedback_rating here
2517: return p_feedback_rating;
2518: --
2519: if g_debug then
2520: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2521: end if;
2522: --
2523:
2524: exception
2522: --
2523:
2524: exception
2525: when others then
2526: hr_utility.set_location('Exception in '|| l_proc, 99);
2527: raise;
2528:
2529: end;
2530: -- --------------------------------------------------------------------------
2546: --
2547: begin
2548: --
2549: if g_debug then
2550: hr_utility.set_location('Entering:'|| l_proc, 10);
2551: end if;
2552: --
2553: -- Customer can override p_feedback_comments here
2554: return p_feedback_comments;
2553: -- Customer can override p_feedback_comments here
2554: return p_feedback_comments;
2555: --
2556: if g_debug then
2557: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2558: end if;
2559: --
2560:
2561: exception
2559: --
2560:
2561: exception
2562: when others then
2563: hr_utility.set_location('Exception in '|| l_proc, 99);
2564: raise;
2565:
2566: end;
2567: -- --------------------------------------------------------------------------
2583: --
2584: begin
2585: --
2586: if g_debug then
2587: hr_utility.set_location('Entering:'|| l_proc, 10);
2588: end if;
2589: --
2590: -- Customer can override p_people_group_name here
2591: return p_people_group_name;
2590: -- Customer can override p_people_group_name here
2591: return p_people_group_name;
2592: --
2593: if g_debug then
2594: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2595: end if;
2596: --
2597:
2598: exception
2596: --
2597:
2598: exception
2599: when others then
2600: hr_utility.set_location('Exception in '|| l_proc, 99);
2601: raise;
2602:
2603: end;
2604: -- --------------------------------------------------------------------------
2620: --
2621: begin
2622: --
2623: if g_debug then
2624: hr_utility.set_location('Entering:'|| l_proc, 10);
2625: end if;
2626: --
2627: -- Customer can override p_people_group_segment1 here
2628: return p_people_group_segment1;
2627: -- Customer can override p_people_group_segment1 here
2628: return p_people_group_segment1;
2629: --
2630: if g_debug then
2631: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2632: end if;
2633: --
2634:
2635: exception
2633: --
2634:
2635: exception
2636: when others then
2637: hr_utility.set_location('Exception in '|| l_proc, 99);
2638: raise;
2639:
2640: end;
2641: -- --------------------------------------------------------------------------
2657: --
2658: begin
2659: --
2660: if g_debug then
2661: hr_utility.set_location('Entering:'|| l_proc, 10);
2662: end if;
2663: --
2664: -- Customer can override p_people_group_segment2 here
2665: return p_people_group_segment2;
2664: -- Customer can override p_people_group_segment2 here
2665: return p_people_group_segment2;
2666: --
2667: if g_debug then
2668: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2669: end if;
2670: --
2671:
2672: exception
2670: --
2671:
2672: exception
2673: when others then
2674: hr_utility.set_location('Exception in '|| l_proc, 99);
2675: raise;
2676:
2677: end;
2678: -- --------------------------------------------------------------------------
2694: --
2695: begin
2696: --
2697: if g_debug then
2698: hr_utility.set_location('Entering:'|| l_proc, 10);
2699: end if;
2700: --
2701: -- Customer can override p_people_group_segment3 here
2702: return p_people_group_segment3;
2701: -- Customer can override p_people_group_segment3 here
2702: return p_people_group_segment3;
2703: --
2704: if g_debug then
2705: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2706: end if;
2707: --
2708:
2709: exception
2707: --
2708:
2709: exception
2710: when others then
2711: hr_utility.set_location('Exception in '|| l_proc, 99);
2712: raise;
2713:
2714: end;
2715: -- --------------------------------------------------------------------------
2731: --
2732: begin
2733: --
2734: if g_debug then
2735: hr_utility.set_location('Entering:'|| l_proc, 10);
2736: end if;
2737: --
2738: -- Customer can override p_people_group_segment4 here
2739: return p_people_group_segment4;
2738: -- Customer can override p_people_group_segment4 here
2739: return p_people_group_segment4;
2740: --
2741: if g_debug then
2742: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2743: end if;
2744: --
2745:
2746: exception
2744: --
2745:
2746: exception
2747: when others then
2748: hr_utility.set_location('Exception in '|| l_proc, 99);
2749: raise;
2750:
2751: end;
2752: -- --------------------------------------------------------------------------
2768: --
2769: begin
2770: --
2771: if g_debug then
2772: hr_utility.set_location('Entering:'|| l_proc, 10);
2773: end if;
2774: --
2775: -- Customer can override p_people_group_segment5 here
2776: return p_people_group_segment5;
2775: -- Customer can override p_people_group_segment5 here
2776: return p_people_group_segment5;
2777: --
2778: if g_debug then
2779: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2780: end if;
2781: --
2782:
2783: exception
2781: --
2782:
2783: exception
2784: when others then
2785: hr_utility.set_location('Exception in '|| l_proc, 99);
2786: raise;
2787:
2788: end;
2789: -- --------------------------------------------------------------------------
2805: --
2806: begin
2807: --
2808: if g_debug then
2809: hr_utility.set_location('Entering:'|| l_proc, 10);
2810: end if;
2811: --
2812: -- Customer can override p_people_group_segment6 here
2813: return p_people_group_segment6;
2812: -- Customer can override p_people_group_segment6 here
2813: return p_people_group_segment6;
2814: --
2815: if g_debug then
2816: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2817: end if;
2818: --
2819:
2820: exception
2818: --
2819:
2820: exception
2821: when others then
2822: hr_utility.set_location('Exception in '|| l_proc, 99);
2823: raise;
2824:
2825: end;
2826: -- --------------------------------------------------------------------------
2842: --
2843: begin
2844: --
2845: if g_debug then
2846: hr_utility.set_location('Entering:'|| l_proc, 10);
2847: end if;
2848: --
2849: -- Customer can override p_people_group_segment7 here
2850: return p_people_group_segment7;
2849: -- Customer can override p_people_group_segment7 here
2850: return p_people_group_segment7;
2851: --
2852: if g_debug then
2853: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2854: end if;
2855: --
2856:
2857: exception
2855: --
2856:
2857: exception
2858: when others then
2859: hr_utility.set_location('Exception in '|| l_proc, 99);
2860: raise;
2861:
2862: end;
2863: -- --------------------------------------------------------------------------
2879: --
2880: begin
2881: --
2882: if g_debug then
2883: hr_utility.set_location('Entering:'|| l_proc, 10);
2884: end if;
2885: --
2886: -- Customer can override p_people_group_segment8 here
2887: return p_people_group_segment8;
2886: -- Customer can override p_people_group_segment8 here
2887: return p_people_group_segment8;
2888: --
2889: if g_debug then
2890: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2891: end if;
2892: --
2893:
2894: exception
2892: --
2893:
2894: exception
2895: when others then
2896: hr_utility.set_location('Exception in '|| l_proc, 99);
2897: raise;
2898:
2899: end;
2900: -- --------------------------------------------------------------------------
2916: --
2917: begin
2918: --
2919: if g_debug then
2920: hr_utility.set_location('Entering:'|| l_proc, 10);
2921: end if;
2922: --
2923: -- Customer can override p_people_group_segment9 here
2924: return p_people_group_segment9;
2923: -- Customer can override p_people_group_segment9 here
2924: return p_people_group_segment9;
2925: --
2926: if g_debug then
2927: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2928: end if;
2929: --
2930:
2931: exception
2929: --
2930:
2931: exception
2932: when others then
2933: hr_utility.set_location('Exception in '|| l_proc, 99);
2934: raise;
2935:
2936: end;
2937: -- --------------------------------------------------------------------------
2953: --
2954: begin
2955: --
2956: if g_debug then
2957: hr_utility.set_location('Entering:'|| l_proc, 10);
2958: end if;
2959: --
2960: -- Customer can override p_people_group_segment10 here
2961: return p_people_group_segment10;
2960: -- Customer can override p_people_group_segment10 here
2961: return p_people_group_segment10;
2962: --
2963: if g_debug then
2964: hr_utility.set_location(' Leaving:'|| l_proc, 99);
2965: end if;
2966: --
2967:
2968: exception
2966: --
2967:
2968: exception
2969: when others then
2970: hr_utility.set_location('Exception in '|| l_proc, 99);
2971: raise;
2972:
2973: end;
2974: -- --------------------------------------------------------------------------
2990: --
2991: begin
2992: --
2993: if g_debug then
2994: hr_utility.set_location('Entering:'|| l_proc, 10);
2995: end if;
2996: --
2997: -- Customer can override p_people_group_segment11 here
2998: return p_people_group_segment11;
2997: -- Customer can override p_people_group_segment11 here
2998: return p_people_group_segment11;
2999: --
3000: if g_debug then
3001: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3002: end if;
3003: --
3004:
3005: exception
3003: --
3004:
3005: exception
3006: when others then
3007: hr_utility.set_location('Exception in '|| l_proc, 99);
3008: raise;
3009:
3010: end;
3011:
3029: --
3030: begin
3031: --
3032: if g_debug then
3033: hr_utility.set_location('Entering:'|| l_proc, 10);
3034: end if;
3035: --
3036: -- Customer can override p_ass_attribute_category here
3037: return p_ass_attribute_category;
3036: -- Customer can override p_ass_attribute_category here
3037: return p_ass_attribute_category;
3038: --
3039: if g_debug then
3040: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3041: end if;
3042: --
3043:
3044: exception
3042: --
3043:
3044: exception
3045: when others then
3046: hr_utility.set_location('Exception in '|| l_proc, 99);
3047: raise;
3048:
3049: end;
3050: -- --------------------------------------------------------------------------
3066: --
3067: begin
3068: --
3069: if g_debug then
3070: hr_utility.set_location('Entering:'|| l_proc, 10);
3071: end if;
3072: --
3073: -- Customer can override p_ass_attribute1 here
3074: return p_ass_attribute1;
3073: -- Customer can override p_ass_attribute1 here
3074: return p_ass_attribute1;
3075: --
3076: if g_debug then
3077: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3078: end if;
3079: --
3080:
3081: exception
3079: --
3080:
3081: exception
3082: when others then
3083: hr_utility.set_location('Exception in '|| l_proc, 99);
3084: raise;
3085:
3086: end;
3087: -- --------------------------------------------------------------------------
3103: --
3104: begin
3105: --
3106: if g_debug then
3107: hr_utility.set_location('Entering:'|| l_proc, 10);
3108: end if;
3109: --
3110: -- Customer can override p_ass_attribute2 here
3111: return p_ass_attribute2;
3110: -- Customer can override p_ass_attribute2 here
3111: return p_ass_attribute2;
3112: --
3113: if g_debug then
3114: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3115: end if;
3116: --
3117:
3118: exception
3116: --
3117:
3118: exception
3119: when others then
3120: hr_utility.set_location('Exception in '|| l_proc, 99);
3121: raise;
3122:
3123: end;
3124: -- --------------------------------------------------------------------------
3140: --
3141: begin
3142: --
3143: if g_debug then
3144: hr_utility.set_location('Entering:'|| l_proc, 10);
3145: end if;
3146: --
3147: -- Customer can override p_ass_attribute3 here
3148: return p_ass_attribute3;
3147: -- Customer can override p_ass_attribute3 here
3148: return p_ass_attribute3;
3149: --
3150: if g_debug then
3151: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3152: end if;
3153: --
3154:
3155: exception
3153: --
3154:
3155: exception
3156: when others then
3157: hr_utility.set_location('Exception in '|| l_proc, 99);
3158: raise;
3159:
3160: end;
3161: -- --------------------------------------------------------------------------
3177: --
3178: begin
3179: --
3180: if g_debug then
3181: hr_utility.set_location('Entering:'|| l_proc, 10);
3182: end if;
3183: --
3184: -- Customer can override p_ass_attribute4 here
3185: return p_ass_attribute4;
3184: -- Customer can override p_ass_attribute4 here
3185: return p_ass_attribute4;
3186: --
3187: if g_debug then
3188: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3189: end if;
3190: --
3191:
3192: exception
3190: --
3191:
3192: exception
3193: when others then
3194: hr_utility.set_location('Exception in '|| l_proc, 99);
3195: raise;
3196:
3197: end;
3198: -- --------------------------------------------------------------------------
3214: --
3215: begin
3216: --
3217: if g_debug then
3218: hr_utility.set_location('Entering:'|| l_proc, 10);
3219: end if;
3220: --
3221: -- Customer can override p_ass_attribute5 here
3222: return p_ass_attribute5;
3221: -- Customer can override p_ass_attribute5 here
3222: return p_ass_attribute5;
3223: --
3224: if g_debug then
3225: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3226: end if;
3227: --
3228:
3229: exception
3227: --
3228:
3229: exception
3230: when others then
3231: hr_utility.set_location('Exception in '|| l_proc, 99);
3232: raise;
3233:
3234: end;
3235: -- --------------------------------------------------------------------------
3251: --
3252: begin
3253: --
3254: if g_debug then
3255: hr_utility.set_location('Entering:'|| l_proc, 10);
3256: end if;
3257: --
3258: -- Customer can override p_ass_attribute6 here
3259: return p_ass_attribute6;
3258: -- Customer can override p_ass_attribute6 here
3259: return p_ass_attribute6;
3260: --
3261: if g_debug then
3262: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3263: end if;
3264: --
3265:
3266: exception
3264: --
3265:
3266: exception
3267: when others then
3268: hr_utility.set_location('Exception in '|| l_proc, 99);
3269: raise;
3270:
3271: end;
3272: -- --------------------------------------------------------------------------
3288: --
3289: begin
3290: --
3291: if g_debug then
3292: hr_utility.set_location('Entering:'|| l_proc, 10);
3293: end if;
3294: --
3295: -- Customer can override p_ass_attribute7 here
3296: return p_ass_attribute7;
3295: -- Customer can override p_ass_attribute7 here
3296: return p_ass_attribute7;
3297: --
3298: if g_debug then
3299: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3300: end if;
3301: --
3302:
3303: exception
3301: --
3302:
3303: exception
3304: when others then
3305: hr_utility.set_location('Exception in '|| l_proc, 99);
3306: raise;
3307:
3308: end;
3309: -- --------------------------------------------------------------------------
3325: --
3326: begin
3327: --
3328: if g_debug then
3329: hr_utility.set_location('Entering:'|| l_proc, 10);
3330: end if;
3331: --
3332: -- Customer can override p_ass_attribute8 here
3333: return p_ass_attribute8;
3332: -- Customer can override p_ass_attribute8 here
3333: return p_ass_attribute8;
3334: --
3335: if g_debug then
3336: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3337: end if;
3338: --
3339:
3340: exception
3338: --
3339:
3340: exception
3341: when others then
3342: hr_utility.set_location('Exception in '|| l_proc, 99);
3343: raise;
3344:
3345: end;
3346: -- --------------------------------------------------------------------------
3362: --
3363: begin
3364: --
3365: if g_debug then
3366: hr_utility.set_location('Entering:'|| l_proc, 10);
3367: end if;
3368: --
3369: -- Customer can override p_ass_attribute9 here
3370: return p_ass_attribute9;
3369: -- Customer can override p_ass_attribute9 here
3370: return p_ass_attribute9;
3371: --
3372: if g_debug then
3373: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3374: end if;
3375: --
3376:
3377: exception
3375: --
3376:
3377: exception
3378: when others then
3379: hr_utility.set_location('Exception in '|| l_proc, 99);
3380: raise;
3381:
3382: end;
3383: -- --------------------------------------------------------------------------
3399: --
3400: begin
3401: --
3402: if g_debug then
3403: hr_utility.set_location('Entering:'|| l_proc, 10);
3404: end if;
3405: --
3406: -- Customer can override p_ass_attribute10 here
3407: return p_ass_attribute10;
3406: -- Customer can override p_ass_attribute10 here
3407: return p_ass_attribute10;
3408: --
3409: if g_debug then
3410: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3411: end if;
3412: --
3413:
3414: exception
3412: --
3413:
3414: exception
3415: when others then
3416: hr_utility.set_location('Exception in '|| l_proc, 99);
3417: raise;
3418:
3419: end;
3420: -- --------------------------------------------------------------------------
3436: --
3437: begin
3438: --
3439: if g_debug then
3440: hr_utility.set_location('Entering:'|| l_proc, 10);
3441: end if;
3442: --
3443: -- Customer can override p_ass_attribute11 here
3444: return p_ass_attribute11;
3443: -- Customer can override p_ass_attribute11 here
3444: return p_ass_attribute11;
3445: --
3446: if g_debug then
3447: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3448: end if;
3449: --
3450:
3451: exception
3449: --
3450:
3451: exception
3452: when others then
3453: hr_utility.set_location('Exception in '|| l_proc, 99);
3454: raise;
3455:
3456: end;
3457: -- --------------------------------------------------------------------------
3474:
3475: begin
3476: --
3477: if g_debug then
3478: hr_utility.set_location('Entering:'|| l_proc, 10);
3479: end if;
3480: --
3481: -- Customer can override p_ass_attribute12 here
3482: return p_ass_attribute12;
3481: -- Customer can override p_ass_attribute12 here
3482: return p_ass_attribute12;
3483: --
3484: if g_debug then
3485: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3486: end if;
3487: --
3488:
3489: exception
3487: --
3488:
3489: exception
3490: when others then
3491: hr_utility.set_location('Exception in '|| l_proc, 99);
3492: raise;
3493:
3494: end;
3495: -- --------------------------------------------------------------------------
3511: --
3512: begin
3513: --
3514: if g_debug then
3515: hr_utility.set_location('Entering:'|| l_proc, 10);
3516: end if;
3517: --
3518: -- Customer can override p_ass_attribute13 here
3519: return p_ass_attribute13;
3518: -- Customer can override p_ass_attribute13 here
3519: return p_ass_attribute13;
3520: --
3521: if g_debug then
3522: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3523: end if;
3524: --
3525:
3526: exception
3524: --
3525:
3526: exception
3527: when others then
3528: hr_utility.set_location('Exception in '|| l_proc, 99);
3529: raise;
3530:
3531: end;
3532: -- --------------------------------------------------------------------------
3548: --
3549: begin
3550: --
3551: if g_debug then
3552: hr_utility.set_location('Entering:'|| l_proc, 10);
3553: end if;
3554: --
3555: -- Customer can override p_ass_attribute14 here
3556: return p_ass_attribute14;
3555: -- Customer can override p_ass_attribute14 here
3556: return p_ass_attribute14;
3557: --
3558: if g_debug then
3559: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3560: end if;
3561: --
3562:
3563: exception
3561: --
3562:
3563: exception
3564: when others then
3565: hr_utility.set_location('Exception in '|| l_proc, 99);
3566: raise;
3567:
3568: end;
3569: -- --------------------------------------------------------------------------
3585: --
3586: begin
3587: --
3588: if g_debug then
3589: hr_utility.set_location('Entering:'|| l_proc, 10);
3590: end if;
3591: --
3592: -- Customer can override p_ass_attribute15 here
3593: return p_ass_attribute15;
3592: -- Customer can override p_ass_attribute15 here
3593: return p_ass_attribute15;
3594: --
3595: if g_debug then
3596: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3597: end if;
3598: --
3599:
3600: exception
3598: --
3599:
3600: exception
3601: when others then
3602: hr_utility.set_location('Exception in '|| l_proc, 99);
3603: raise;
3604:
3605: end;
3606: -- --------------------------------------------------------------------------
3622: --
3623: begin
3624: --
3625: if g_debug then
3626: hr_utility.set_location('Entering:'|| l_proc, 10);
3627: end if;
3628: --
3629: -- Customer can override p_ass_attribute16 here
3630: return p_ass_attribute16;
3629: -- Customer can override p_ass_attribute16 here
3630: return p_ass_attribute16;
3631: --
3632: if g_debug then
3633: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3634: end if;
3635: --
3636:
3637: exception
3635: --
3636:
3637: exception
3638: when others then
3639: hr_utility.set_location('Exception in '|| l_proc, 99);
3640: raise;
3641:
3642: end;
3643: -- --------------------------------------------------------------------------
3659: --
3660: begin
3661: --
3662: if g_debug then
3663: hr_utility.set_location('Entering:'|| l_proc, 10);
3664: end if;
3665: --
3666: -- Customer can override p_ass_attribute17 here
3667: return p_ass_attribute17;
3666: -- Customer can override p_ass_attribute17 here
3667: return p_ass_attribute17;
3668: --
3669: if g_debug then
3670: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3671: end if;
3672: --
3673:
3674: exception
3672: --
3673:
3674: exception
3675: when others then
3676: hr_utility.set_location('Exception in '|| l_proc, 99);
3677: raise;
3678:
3679: end;
3680: -- --------------------------------------------------------------------------
3696: --
3697: begin
3698: --
3699: if g_debug then
3700: hr_utility.set_location('Entering:'|| l_proc, 10);
3701: end if;
3702: --
3703: -- Customer can override p_ass_attribute18 here
3704: return p_ass_attribute18;
3703: -- Customer can override p_ass_attribute18 here
3704: return p_ass_attribute18;
3705: --
3706: if g_debug then
3707: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3708: end if;
3709: --
3710:
3711: exception
3709: --
3710:
3711: exception
3712: when others then
3713: hr_utility.set_location('Exception in '|| l_proc, 99);
3714: raise;
3715:
3716: end;
3717: -- --------------------------------------------------------------------------
3733: --
3734: begin
3735: --
3736: if g_debug then
3737: hr_utility.set_location('Entering:'|| l_proc, 10);
3738: end if;
3739: --
3740: -- Customer can override p_ass_attribute19 here
3741: return p_ass_attribute19;
3740: -- Customer can override p_ass_attribute19 here
3741: return p_ass_attribute19;
3742: --
3743: if g_debug then
3744: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3745: end if;
3746: --
3747:
3748: exception
3746: --
3747:
3748: exception
3749: when others then
3750: hr_utility.set_location('Exception in '|| l_proc, 99);
3751: raise;
3752:
3753: end;
3754:
3771: --
3772: begin
3773: --
3774: if g_debug then
3775: hr_utility.set_location('Entering:'|| l_proc, 10);
3776: end if;
3777: --
3778: -- Customer can override p_ass_attribute20 here
3779: return p_ass_attribute20;
3778: -- Customer can override p_ass_attribute20 here
3779: return p_ass_attribute20;
3780: --
3781: if g_debug then
3782: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3783: end if;
3784: --
3785:
3786: exception
3784: --
3785:
3786: exception
3787: when others then
3788: hr_utility.set_location('Exception in '|| l_proc, 99);
3789: raise;
3790:
3791: end;
3792:
3809: --
3810: begin
3811: --
3812: if g_debug then
3813: hr_utility.set_location('Entering:'|| l_proc, 10);
3814: end if;
3815: --
3816: -- Customer can override p_ass_attribute21 here
3817: return p_ass_attribute21;
3816: -- Customer can override p_ass_attribute21 here
3817: return p_ass_attribute21;
3818: --
3819: if g_debug then
3820: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3821: end if;
3822: --
3823:
3824: exception
3822: --
3823:
3824: exception
3825: when others then
3826: hr_utility.set_location('Exception in '|| l_proc, 99);
3827: raise;
3828:
3829: end;
3830:
3847: --
3848: begin
3849: --
3850: if g_debug then
3851: hr_utility.set_location('Entering:'|| l_proc, 10);
3852: end if;
3853: --
3854: -- Customer can override p_ass_attribute22 here
3855: return p_ass_attribute22;
3854: -- Customer can override p_ass_attribute22 here
3855: return p_ass_attribute22;
3856: --
3857: if g_debug then
3858: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3859: end if;
3860: --
3861:
3862: exception
3860: --
3861:
3862: exception
3863: when others then
3864: hr_utility.set_location('Exception in '|| l_proc, 99);
3865: raise;
3866:
3867: end;
3868: -- --------------------------------------------------------------------------
3884: --
3885: begin
3886: --
3887: if g_debug then
3888: hr_utility.set_location('Entering:'|| l_proc, 10);
3889: end if;
3890: --
3891: -- Customer can override p_ass_attribute23 here
3892: return p_ass_attribute23;
3891: -- Customer can override p_ass_attribute23 here
3892: return p_ass_attribute23;
3893: --
3894: if g_debug then
3895: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3896: end if;
3897: --
3898:
3899: exception
3897: --
3898:
3899: exception
3900: when others then
3901: hr_utility.set_location('Exception in '|| l_proc, 99);
3902: raise;
3903:
3904: end;
3905: -- --------------------------------------------------------------------------
3921: --
3922: begin
3923: --
3924: if g_debug then
3925: hr_utility.set_location('Entering:'|| l_proc, 10);
3926: end if;
3927: --
3928: -- Customer can override p_ass_attribute24 here
3929: return p_ass_attribute24;
3928: -- Customer can override p_ass_attribute24 here
3929: return p_ass_attribute24;
3930: --
3931: if g_debug then
3932: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3933: end if;
3934: --
3935:
3936: exception
3934: --
3935:
3936: exception
3937: when others then
3938: hr_utility.set_location('Exception in '|| l_proc, 99);
3939: raise;
3940:
3941: end;
3942: -- --------------------------------------------------------------------------
3958: --
3959: begin
3960: --
3961: if g_debug then
3962: hr_utility.set_location('Entering:'|| l_proc, 10);
3963: end if;
3964: --
3965: -- Customer can override p_ass_attribute25 here
3966: return p_ass_attribute25;
3965: -- Customer can override p_ass_attribute25 here
3966: return p_ass_attribute25;
3967: --
3968: if g_debug then
3969: hr_utility.set_location(' Leaving:'|| l_proc, 99);
3970: end if;
3971: --
3972:
3973: exception
3971: --
3972:
3973: exception
3974: when others then
3975: hr_utility.set_location('Exception in '|| l_proc, 99);
3976: raise;
3977:
3978: end;
3979: -- --------------------------------------------------------------------------
3995: --
3996: begin
3997: --
3998: if g_debug then
3999: hr_utility.set_location('Entering:'|| l_proc, 10);
4000: end if;
4001: --
4002: -- Customer can override p_ass_attribute26 here
4003: return p_ass_attribute26;
4002: -- Customer can override p_ass_attribute26 here
4003: return p_ass_attribute26;
4004: --
4005: if g_debug then
4006: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4007: end if;
4008: --
4009:
4010: exception
4008: --
4009:
4010: exception
4011: when others then
4012: hr_utility.set_location('Exception in '|| l_proc, 99);
4013: raise;
4014:
4015: end;
4016: -- --------------------------------------------------------------------------
4032: --
4033: begin
4034: --
4035: if g_debug then
4036: hr_utility.set_location('Entering:'|| l_proc, 10);
4037: end if;
4038: --
4039: -- Customer can override p_ass_attribute27 here
4040: return p_ass_attribute27;
4039: -- Customer can override p_ass_attribute27 here
4040: return p_ass_attribute27;
4041: --
4042: if g_debug then
4043: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4044: end if;
4045: --
4046:
4047: exception
4045: --
4046:
4047: exception
4048: when others then
4049: hr_utility.set_location('Exception in '|| l_proc, 99);
4050: raise;
4051:
4052: end;
4053: -- --------------------------------------------------------------------------
4069: --
4070: begin
4071: --
4072: if g_debug then
4073: hr_utility.set_location('Entering:'|| l_proc, 10);
4074: end if;
4075: --
4076: -- Customer can override p_ass_attribute28 here
4077: return p_ass_attribute28;
4076: -- Customer can override p_ass_attribute28 here
4077: return p_ass_attribute28;
4078: --
4079: if g_debug then
4080: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4081: end if;
4082: --
4083:
4084: exception
4082: --
4083:
4084: exception
4085: when others then
4086: hr_utility.set_location('Exception in '|| l_proc, 99);
4087: raise;
4088:
4089: end;
4090: -- --------------------------------------------------------------------------
4106: --
4107: begin
4108: --
4109: if g_debug then
4110: hr_utility.set_location('Entering:'|| l_proc, 10);
4111: end if;
4112: --
4113: -- Customer can override p_ass_attribute29 here
4114: return p_ass_attribute29;
4113: -- Customer can override p_ass_attribute29 here
4114: return p_ass_attribute29;
4115: --
4116: if g_debug then
4117: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4118: end if;
4119: --
4120:
4121: exception
4119: --
4120:
4121: exception
4122: when others then
4123: hr_utility.set_location('Exception in '|| l_proc, 99);
4124: raise;
4125:
4126: end;
4127:
4145:
4146: begin
4147: --
4148: if g_debug then
4149: hr_utility.set_location('Entering:'|| l_proc, 10);
4150: end if;
4151: --
4152: -- Customer can override p_ass_attribute30 here
4153: return p_ass_attribute30;
4152: -- Customer can override p_ass_attribute30 here
4153: return p_ass_attribute30;
4154: --
4155: if g_debug then
4156: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4157: end if;
4158: --
4159:
4160: exception
4158: --
4159:
4160: exception
4161: when others then
4162: hr_utility.set_location('Exception in '|| l_proc, 99);
4163: raise;
4164:
4165: end;
4166: -- --------------------------------------------------------------------------
4183:
4184: begin
4185: --
4186: if g_debug then
4187: hr_utility.set_location('Entering:'|| l_proc, 10);
4188: end if;
4189: --
4190: -- Customer can override p_ws_comments here
4191: return p_ws_comments;
4190: -- Customer can override p_ws_comments here
4191: return p_ws_comments;
4192: --
4193: if g_debug then
4194: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4195: end if;
4196: --
4197:
4198: exception
4196: --
4197:
4198: exception
4199: when others then
4200: hr_utility.set_location('Exception in '|| l_proc, 99);
4201: raise;
4202:
4203: end;
4204:
4223: --
4224: begin
4225: --
4226: if g_debug then
4227: hr_utility.set_location('Entering:'|| l_proc, 10);
4228: end if;
4229: --
4230: -- Customer can override p_cpi_attribute_category here
4231: return p_cpi_attribute_category;
4230: -- Customer can override p_cpi_attribute_category here
4231: return p_cpi_attribute_category;
4232: --
4233: if g_debug then
4234: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4235: end if;
4236: --
4237:
4238: exception
4236: --
4237:
4238: exception
4239: when others then
4240: hr_utility.set_location('Exception in '|| l_proc, 99);
4241: raise;
4242:
4243: end;
4244:
4261: --
4262: begin
4263: --
4264: if g_debug then
4265: hr_utility.set_location('Entering:'|| l_proc, 10);
4266: end if;
4267: --
4268: -- Customer can override p_cpi_attribute1 here
4269: return p_cpi_attribute1;
4268: -- Customer can override p_cpi_attribute1 here
4269: return p_cpi_attribute1;
4270: --
4271: if g_debug then
4272: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4273: end if;
4274: --
4275:
4276: exception
4274: --
4275:
4276: exception
4277: when others then
4278: hr_utility.set_location('Exception in '|| l_proc, 99);
4279: raise;
4280:
4281: end;
4282: -- --------------------------------------------------------------------------
4298: --
4299: begin
4300: --
4301: if g_debug then
4302: hr_utility.set_location('Entering:'|| l_proc, 10);
4303: end if;
4304: --
4305: -- Customer can override p_cpi_attribute2 here
4306: return p_cpi_attribute2;
4305: -- Customer can override p_cpi_attribute2 here
4306: return p_cpi_attribute2;
4307: --
4308: if g_debug then
4309: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4310: end if;
4311: --
4312:
4313: exception
4311: --
4312:
4313: exception
4314: when others then
4315: hr_utility.set_location('Exception in '|| l_proc, 99);
4316: raise;
4317:
4318: end;
4319: -- --------------------------------------------------------------------------
4335: --
4336: begin
4337: --
4338: if g_debug then
4339: hr_utility.set_location('Entering:'|| l_proc, 10);
4340: end if;
4341: --
4342: -- Customer can override p_cpi_attribute3 here
4343: return p_cpi_attribute3;
4342: -- Customer can override p_cpi_attribute3 here
4343: return p_cpi_attribute3;
4344: --
4345: if g_debug then
4346: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4347: end if;
4348: --
4349:
4350: exception
4348: --
4349:
4350: exception
4351: when others then
4352: hr_utility.set_location('Exception in '|| l_proc, 99);
4353: raise;
4354:
4355: end;
4356: -- --------------------------------------------------------------------------
4372: --
4373: begin
4374: --
4375: if g_debug then
4376: hr_utility.set_location('Entering:'|| l_proc, 10);
4377: end if;
4378: --
4379: -- Customer can override p_cpi_attribute4 here
4380: return p_cpi_attribute4;
4379: -- Customer can override p_cpi_attribute4 here
4380: return p_cpi_attribute4;
4381: --
4382: if g_debug then
4383: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4384: end if;
4385: --
4386:
4387: exception
4385: --
4386:
4387: exception
4388: when others then
4389: hr_utility.set_location('Exception in '|| l_proc, 99);
4390: raise;
4391:
4392: end;
4393: -- --------------------------------------------------------------------------
4409: --
4410: begin
4411: --
4412: if g_debug then
4413: hr_utility.set_location('Entering:'|| l_proc, 10);
4414: end if;
4415: --
4416: -- Customer can override p_cpi_attribute5 here
4417: return p_cpi_attribute5;
4416: -- Customer can override p_cpi_attribute5 here
4417: return p_cpi_attribute5;
4418: --
4419: if g_debug then
4420: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4421: end if;
4422: --
4423:
4424: exception
4422: --
4423:
4424: exception
4425: when others then
4426: hr_utility.set_location('Exception in '|| l_proc, 99);
4427: raise;
4428:
4429: end;
4430: -- --------------------------------------------------------------------------
4446: --
4447: begin
4448: --
4449: if g_debug then
4450: hr_utility.set_location('Entering:'|| l_proc, 10);
4451: end if;
4452: --
4453: -- Customer can override p_cpi_attribute6 here
4454: return p_cpi_attribute6;
4453: -- Customer can override p_cpi_attribute6 here
4454: return p_cpi_attribute6;
4455: --
4456: if g_debug then
4457: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4458: end if;
4459: --
4460:
4461: exception
4459: --
4460:
4461: exception
4462: when others then
4463: hr_utility.set_location('Exception in '|| l_proc, 99);
4464: raise;
4465:
4466: end;
4467: -- --------------------------------------------------------------------------
4483: --
4484: begin
4485: --
4486: if g_debug then
4487: hr_utility.set_location('Entering:'|| l_proc, 10);
4488: end if;
4489: --
4490: -- Customer can override p_cpi_attribute7 here
4491: return p_cpi_attribute7;
4490: -- Customer can override p_cpi_attribute7 here
4491: return p_cpi_attribute7;
4492: --
4493: if g_debug then
4494: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4495: end if;
4496: --
4497:
4498: exception
4496: --
4497:
4498: exception
4499: when others then
4500: hr_utility.set_location('Exception in '|| l_proc, 99);
4501: raise;
4502:
4503: end;
4504: -- --------------------------------------------------------------------------
4520: --
4521: begin
4522: --
4523: if g_debug then
4524: hr_utility.set_location('Entering:'|| l_proc, 10);
4525: end if;
4526: --
4527: -- Customer can override p_cpi_attribute8 here
4528: return p_cpi_attribute8;
4527: -- Customer can override p_cpi_attribute8 here
4528: return p_cpi_attribute8;
4529: --
4530: if g_debug then
4531: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4532: end if;
4533: --
4534:
4535: exception
4533: --
4534:
4535: exception
4536: when others then
4537: hr_utility.set_location('Exception in '|| l_proc, 99);
4538: raise;
4539:
4540: end;
4541: -- --------------------------------------------------------------------------
4557: --
4558: begin
4559: --
4560: if g_debug then
4561: hr_utility.set_location('Entering:'|| l_proc, 10);
4562: end if;
4563: --
4564: -- Customer can override p_cpi_attribute9 here
4565: return p_cpi_attribute9;
4564: -- Customer can override p_cpi_attribute9 here
4565: return p_cpi_attribute9;
4566: --
4567: if g_debug then
4568: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4569: end if;
4570: --
4571:
4572: exception
4570: --
4571:
4572: exception
4573: when others then
4574: hr_utility.set_location('Exception in '|| l_proc, 99);
4575: raise;
4576:
4577: end;
4578: -- --------------------------------------------------------------------------
4594: --
4595: begin
4596: --
4597: if g_debug then
4598: hr_utility.set_location('Entering:'|| l_proc, 10);
4599: end if;
4600: --
4601: -- Customer can override p_cpi_attribute10 here
4602: return p_cpi_attribute10;
4601: -- Customer can override p_cpi_attribute10 here
4602: return p_cpi_attribute10;
4603: --
4604: if g_debug then
4605: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4606: end if;
4607: --
4608:
4609: exception
4607: --
4608:
4609: exception
4610: when others then
4611: hr_utility.set_location('Exception in '|| l_proc, 99);
4612: raise;
4613:
4614: end;
4615: -- --------------------------------------------------------------------------
4631: --
4632: begin
4633: --
4634: if g_debug then
4635: hr_utility.set_location('Entering:'|| l_proc, 10);
4636: end if;
4637: --
4638: -- Customer can override p_cpi_attribute11 here
4639: return p_cpi_attribute11;
4638: -- Customer can override p_cpi_attribute11 here
4639: return p_cpi_attribute11;
4640: --
4641: if g_debug then
4642: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4643: end if;
4644: --
4645:
4646: exception
4644: --
4645:
4646: exception
4647: when others then
4648: hr_utility.set_location('Exception in '|| l_proc, 99);
4649: raise;
4650:
4651: end;
4652: -- --------------------------------------------------------------------------
4669:
4670: begin
4671: --
4672: if g_debug then
4673: hr_utility.set_location('Entering:'|| l_proc, 10);
4674: end if;
4675: --
4676: -- Customer can override p_cpi_attribute12 here
4677: return p_cpi_attribute12;
4676: -- Customer can override p_cpi_attribute12 here
4677: return p_cpi_attribute12;
4678: --
4679: if g_debug then
4680: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4681: end if;
4682: --
4683:
4684: exception
4682: --
4683:
4684: exception
4685: when others then
4686: hr_utility.set_location('Exception in '|| l_proc, 99);
4687: raise;
4688:
4689: end;
4690: -- --------------------------------------------------------------------------
4706: --
4707: begin
4708: --
4709: if g_debug then
4710: hr_utility.set_location('Entering:'|| l_proc, 10);
4711: end if;
4712: --
4713: -- Customer can override p_cpi_attribute13 here
4714: return p_cpi_attribute13;
4713: -- Customer can override p_cpi_attribute13 here
4714: return p_cpi_attribute13;
4715: --
4716: if g_debug then
4717: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4718: end if;
4719: --
4720:
4721: exception
4719: --
4720:
4721: exception
4722: when others then
4723: hr_utility.set_location('Exception in '|| l_proc, 99);
4724: raise;
4725:
4726: end;
4727: -- --------------------------------------------------------------------------
4743: --
4744: begin
4745: --
4746: if g_debug then
4747: hr_utility.set_location('Entering:'|| l_proc, 10);
4748: end if;
4749: --
4750: -- Customer can override p_cpi_attribute14 here
4751: return p_cpi_attribute14;
4750: -- Customer can override p_cpi_attribute14 here
4751: return p_cpi_attribute14;
4752: --
4753: if g_debug then
4754: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4755: end if;
4756: --
4757:
4758: exception
4756: --
4757:
4758: exception
4759: when others then
4760: hr_utility.set_location('Exception in '|| l_proc, 99);
4761: raise;
4762:
4763: end;
4764: -- --------------------------------------------------------------------------
4780: --
4781: begin
4782: --
4783: if g_debug then
4784: hr_utility.set_location('Entering:'|| l_proc, 10);
4785: end if;
4786: --
4787: -- Customer can override p_cpi_attribute15 here
4788: return p_cpi_attribute15;
4787: -- Customer can override p_cpi_attribute15 here
4788: return p_cpi_attribute15;
4789: --
4790: if g_debug then
4791: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4792: end if;
4793: --
4794:
4795: exception
4793: --
4794:
4795: exception
4796: when others then
4797: hr_utility.set_location('Exception in '|| l_proc, 99);
4798: raise;
4799:
4800: end;
4801: -- --------------------------------------------------------------------------
4817: --
4818: begin
4819: --
4820: if g_debug then
4821: hr_utility.set_location('Entering:'|| l_proc, 10);
4822: end if;
4823: --
4824: -- Customer can override p_cpi_attribute16 here
4825: return p_cpi_attribute16;
4824: -- Customer can override p_cpi_attribute16 here
4825: return p_cpi_attribute16;
4826: --
4827: if g_debug then
4828: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4829: end if;
4830: --
4831:
4832: exception
4830: --
4831:
4832: exception
4833: when others then
4834: hr_utility.set_location('Exception in '|| l_proc, 99);
4835: raise;
4836:
4837: end;
4838: -- --------------------------------------------------------------------------
4854: --
4855: begin
4856: --
4857: if g_debug then
4858: hr_utility.set_location('Entering:'|| l_proc, 10);
4859: end if;
4860: --
4861: -- Customer can override p_cpi_attribute17 here
4862: return p_cpi_attribute17;
4861: -- Customer can override p_cpi_attribute17 here
4862: return p_cpi_attribute17;
4863: --
4864: if g_debug then
4865: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4866: end if;
4867: --
4868:
4869: exception
4867: --
4868:
4869: exception
4870: when others then
4871: hr_utility.set_location('Exception in '|| l_proc, 99);
4872: raise;
4873:
4874: end;
4875: -- --------------------------------------------------------------------------
4891: --
4892: begin
4893: --
4894: if g_debug then
4895: hr_utility.set_location('Entering:'|| l_proc, 10);
4896: end if;
4897: --
4898: -- Customer can override p_cpi_attribute18 here
4899: return p_cpi_attribute18;
4898: -- Customer can override p_cpi_attribute18 here
4899: return p_cpi_attribute18;
4900: --
4901: if g_debug then
4902: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4903: end if;
4904: --
4905:
4906: exception
4904: --
4905:
4906: exception
4907: when others then
4908: hr_utility.set_location('Exception in '|| l_proc, 99);
4909: raise;
4910:
4911: end;
4912: -- --------------------------------------------------------------------------
4928: --
4929: begin
4930: --
4931: if g_debug then
4932: hr_utility.set_location('Entering:'|| l_proc, 10);
4933: end if;
4934: --
4935: -- Customer can override p_cpi_attribute19 here
4936: return p_cpi_attribute19;
4935: -- Customer can override p_cpi_attribute19 here
4936: return p_cpi_attribute19;
4937: --
4938: if g_debug then
4939: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4940: end if;
4941: --
4942:
4943: exception
4941: --
4942:
4943: exception
4944: when others then
4945: hr_utility.set_location('Exception in '|| l_proc, 99);
4946: raise;
4947:
4948: end;
4949:
4966: --
4967: begin
4968: --
4969: if g_debug then
4970: hr_utility.set_location('Entering:'|| l_proc, 10);
4971: end if;
4972: --
4973: -- Customer can override p_cpi_attribute20 here
4974: return p_cpi_attribute20;
4973: -- Customer can override p_cpi_attribute20 here
4974: return p_cpi_attribute20;
4975: --
4976: if g_debug then
4977: hr_utility.set_location(' Leaving:'|| l_proc, 99);
4978: end if;
4979: --
4980:
4981: exception
4979: --
4980:
4981: exception
4982: when others then
4983: hr_utility.set_location('Exception in '|| l_proc, 99);
4984: raise;
4985:
4986: end;
4987:
5004: --
5005: begin
5006: --
5007: if g_debug then
5008: hr_utility.set_location('Entering:'|| l_proc, 10);
5009: end if;
5010: --
5011: -- Customer can override p_cpi_attribute21 here
5012: return p_cpi_attribute21;
5011: -- Customer can override p_cpi_attribute21 here
5012: return p_cpi_attribute21;
5013: --
5014: if g_debug then
5015: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5016: end if;
5017: --
5018:
5019: exception
5017: --
5018:
5019: exception
5020: when others then
5021: hr_utility.set_location('Exception in '|| l_proc, 99);
5022: raise;
5023:
5024: end;
5025:
5042: --
5043: begin
5044: --
5045: if g_debug then
5046: hr_utility.set_location('Entering:'|| l_proc, 10);
5047: end if;
5048: --
5049: -- Customer can override p_cpi_attribute22 here
5050: return p_cpi_attribute22;
5049: -- Customer can override p_cpi_attribute22 here
5050: return p_cpi_attribute22;
5051: --
5052: if g_debug then
5053: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5054: end if;
5055: --
5056:
5057: exception
5055: --
5056:
5057: exception
5058: when others then
5059: hr_utility.set_location('Exception in '|| l_proc, 99);
5060: raise;
5061:
5062: end;
5063: -- --------------------------------------------------------------------------
5079: --
5080: begin
5081: --
5082: if g_debug then
5083: hr_utility.set_location('Entering:'|| l_proc, 10);
5084: end if;
5085: --
5086: -- Customer can override p_cpi_attribute23 here
5087: return p_cpi_attribute23;
5086: -- Customer can override p_cpi_attribute23 here
5087: return p_cpi_attribute23;
5088: --
5089: if g_debug then
5090: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5091: end if;
5092: --
5093:
5094: exception
5092: --
5093:
5094: exception
5095: when others then
5096: hr_utility.set_location('Exception in '|| l_proc, 99);
5097: raise;
5098:
5099: end;
5100: -- --------------------------------------------------------------------------
5116: --
5117: begin
5118: --
5119: if g_debug then
5120: hr_utility.set_location('Entering:'|| l_proc, 10);
5121: end if;
5122: --
5123: -- Customer can override p_cpi_attribute24 here
5124: return p_cpi_attribute24;
5123: -- Customer can override p_cpi_attribute24 here
5124: return p_cpi_attribute24;
5125: --
5126: if g_debug then
5127: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5128: end if;
5129: --
5130:
5131: exception
5129: --
5130:
5131: exception
5132: when others then
5133: hr_utility.set_location('Exception in '|| l_proc, 99);
5134: raise;
5135:
5136: end;
5137: -- --------------------------------------------------------------------------
5153: --
5154: begin
5155: --
5156: if g_debug then
5157: hr_utility.set_location('Entering:'|| l_proc, 10);
5158: end if;
5159: --
5160: -- Customer can override p_cpi_attribute25 here
5161: return p_cpi_attribute25;
5160: -- Customer can override p_cpi_attribute25 here
5161: return p_cpi_attribute25;
5162: --
5163: if g_debug then
5164: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5165: end if;
5166: --
5167:
5168: exception
5166: --
5167:
5168: exception
5169: when others then
5170: hr_utility.set_location('Exception in '|| l_proc, 99);
5171: raise;
5172:
5173: end;
5174: -- --------------------------------------------------------------------------
5190: --
5191: begin
5192: --
5193: if g_debug then
5194: hr_utility.set_location('Entering:'|| l_proc, 10);
5195: end if;
5196: --
5197: -- Customer can override p_cpi_attribute26 here
5198: return p_cpi_attribute26;
5197: -- Customer can override p_cpi_attribute26 here
5198: return p_cpi_attribute26;
5199: --
5200: if g_debug then
5201: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5202: end if;
5203: --
5204:
5205: exception
5203: --
5204:
5205: exception
5206: when others then
5207: hr_utility.set_location('Exception in '|| l_proc, 99);
5208: raise;
5209:
5210: end;
5211: -- --------------------------------------------------------------------------
5227: --
5228: begin
5229: --
5230: if g_debug then
5231: hr_utility.set_location('Entering:'|| l_proc, 10);
5232: end if;
5233: --
5234: -- Customer can override p_cpi_attribute27 here
5235: return p_cpi_attribute27;
5234: -- Customer can override p_cpi_attribute27 here
5235: return p_cpi_attribute27;
5236: --
5237: if g_debug then
5238: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5239: end if;
5240: --
5241:
5242: exception
5240: --
5241:
5242: exception
5243: when others then
5244: hr_utility.set_location('Exception in '|| l_proc, 99);
5245: raise;
5246:
5247: end;
5248: -- --------------------------------------------------------------------------
5264: --
5265: begin
5266: --
5267: if g_debug then
5268: hr_utility.set_location('Entering:'|| l_proc, 10);
5269: end if;
5270: --
5271: -- Customer can override p_cpi_attribute28 here
5272: return p_cpi_attribute28;
5271: -- Customer can override p_cpi_attribute28 here
5272: return p_cpi_attribute28;
5273: --
5274: if g_debug then
5275: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5276: end if;
5277: --
5278:
5279: exception
5277: --
5278:
5279: exception
5280: when others then
5281: hr_utility.set_location('Exception in '|| l_proc, 99);
5282: raise;
5283:
5284: end;
5285: -- --------------------------------------------------------------------------
5301: --
5302: begin
5303: --
5304: if g_debug then
5305: hr_utility.set_location('Entering:'|| l_proc, 10);
5306: end if;
5307: --
5308: -- Customer can override p_cpi_attribute29 here
5309: return p_cpi_attribute29;
5308: -- Customer can override p_cpi_attribute29 here
5309: return p_cpi_attribute29;
5310: --
5311: if g_debug then
5312: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5313: end if;
5314: --
5315:
5316: exception
5314: --
5315:
5316: exception
5317: when others then
5318: hr_utility.set_location('Exception in '|| l_proc, 99);
5319: raise;
5320:
5321: end;
5322:
5340:
5341: begin
5342: --
5343: if g_debug then
5344: hr_utility.set_location('Entering:'|| l_proc, 10);
5345: end if;
5346: --
5347: -- Customer can override p_cpi_attribute30 here
5348: return p_cpi_attribute30;
5347: -- Customer can override p_cpi_attribute30 here
5348: return p_cpi_attribute30;
5349: --
5350: if g_debug then
5351: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5352: end if;
5353: --
5354:
5355: exception
5353: --
5354:
5355: exception
5356: when others then
5357: hr_utility.set_location('Exception in '|| l_proc, 99);
5358: raise;
5359:
5360: end;
5361:
5378: --
5379: begin
5380: --
5381: if g_debug then
5382: hr_utility.set_location('Entering:'|| l_proc, 10);
5383: end if;
5384: --
5385: -- Customer can override p_grd_quintile here
5386: return p_grd_quintile;
5385: -- Customer can override p_grd_quintile here
5386: return p_grd_quintile;
5387: --
5388: if g_debug then
5389: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5390: end if;
5391: --
5392:
5393: exception
5391: --
5392:
5393: exception
5394: when others then
5395: hr_utility.set_location('Exception in '|| l_proc, 99);
5396: raise;
5397:
5398: end;
5399: -- --------------------------------------------------------------------------
5415: --
5416: begin
5417: --
5418: if g_debug then
5419: hr_utility.set_location('Entering:'|| l_proc, 10);
5420: end if;
5421: --
5422: -- Customer can override p_grd_decile here
5423: return p_grd_decile;
5422: -- Customer can override p_grd_decile here
5423: return p_grd_decile;
5424: --
5425: if g_debug then
5426: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5427: end if;
5428: --
5429:
5430: exception
5428: --
5429:
5430: exception
5431: when others then
5432: hr_utility.set_location('Exception in '|| l_proc, 99);
5433: raise;
5434:
5435: end;
5436: -- --------------------------------------------------------------------------
5453:
5454: begin
5455: --
5456: if g_debug then
5457: hr_utility.set_location('Entering:'|| l_proc, 10);
5458: end if;
5459: --
5460: -- Customer can override p_grade_rate_frequency here
5461: return p_grade_rate_frequency;
5460: -- Customer can override p_grade_rate_frequency here
5461: return p_grade_rate_frequency;
5462: --
5463: if g_debug then
5464: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5465: end if;
5466: --
5467:
5468: exception
5466: --
5467:
5468: exception
5469: when others then
5470: hr_utility.set_location('Exception in '|| l_proc, 99);
5471: raise;
5472:
5473: end;
5474: -- --------------------------------------------------------------------------
5490: --
5491: begin
5492: --
5493: if g_debug then
5494: hr_utility.set_location('Entering:'|| l_proc, 10);
5495: end if;
5496: --
5497: -- Customer can override p_base_salary_currency here
5498: return p_base_salary_currency;
5497: -- Customer can override p_base_salary_currency here
5498: return p_base_salary_currency;
5499: --
5500: if g_debug then
5501: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5502: end if;
5503: --
5504:
5505: exception
5503: --
5504:
5505: exception
5506: when others then
5507: hr_utility.set_location('Exception in '|| l_proc, 99);
5508: raise;
5509:
5510: end;
5511: -- --------------------------------------------------------------------------
5527: --
5528: begin
5529: --
5530: if g_debug then
5531: hr_utility.set_location('Entering:'|| l_proc, 10);
5532: end if;
5533: --
5534: -- Customer can override p_salary_1_year_ago_frequency here
5535: return p_salary_1_year_ago_frequency;
5534: -- Customer can override p_salary_1_year_ago_frequency here
5535: return p_salary_1_year_ago_frequency;
5536: --
5537: if g_debug then
5538: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5539: end if;
5540: --
5541:
5542: exception
5540: --
5541:
5542: exception
5543: when others then
5544: hr_utility.set_location('Exception in '|| l_proc, 99);
5545: raise;
5546:
5547: end;
5548: -- --------------------------------------------------------------------------
5564: --
5565: begin
5566: --
5567: if g_debug then
5568: hr_utility.set_location('Entering:'|| l_proc, 10);
5569: end if;
5570: --
5571: -- Customer can override p_salary_1_year_ago_currency here
5572: return p_salary_1_year_ago_currency;
5571: -- Customer can override p_salary_1_year_ago_currency here
5572: return p_salary_1_year_ago_currency;
5573: --
5574: if g_debug then
5575: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5576: end if;
5577: --
5578:
5579: exception
5577: --
5578:
5579: exception
5580: when others then
5581: hr_utility.set_location('Exception in '|| l_proc, 99);
5582: raise;
5583:
5584: end;
5585: -- --------------------------------------------------------------------------
5602:
5603: begin
5604: --
5605: if g_debug then
5606: hr_utility.set_location('Entering:'|| l_proc, 10);
5607: end if;
5608: --
5609: -- Customer can override p_salary_2_year_ago_frequency here
5610: return p_salary_2_year_ago_frequency;
5609: -- Customer can override p_salary_2_year_ago_frequency here
5610: return p_salary_2_year_ago_frequency;
5611: --
5612: if g_debug then
5613: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5614: end if;
5615: --
5616:
5617: exception
5615: --
5616:
5617: exception
5618: when others then
5619: hr_utility.set_location('Exception in '|| l_proc, 99);
5620: raise;
5621:
5622: end;
5623: -- --------------------------------------------------------------------------
5640:
5641: begin
5642: --
5643: if g_debug then
5644: hr_utility.set_location('Entering:'|| l_proc, 10);
5645: end if;
5646: --
5647: -- Customer can override p_salary_2_year_ago_currency here
5648: return p_salary_2_year_ago_currency;
5647: -- Customer can override p_salary_2_year_ago_currency here
5648: return p_salary_2_year_ago_currency;
5649: --
5650: if g_debug then
5651: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5652: end if;
5653: --
5654:
5655: exception
5653: --
5654:
5655: exception
5656: when others then
5657: hr_utility.set_location('Exception in '|| l_proc, 99);
5658: raise;
5659:
5660: end;
5661: -- --------------------------------------------------------------------------
5677: --
5678: begin
5679: --
5680: if g_debug then
5681: hr_utility.set_location('Entering:'|| l_proc, 10);
5682: end if;
5683: --
5684: -- Customer can override p_salary_3_year_ago_currency here
5685: return p_salary_3_year_ago_currency;
5684: -- Customer can override p_salary_3_year_ago_currency here
5685: return p_salary_3_year_ago_currency;
5686: --
5687: if g_debug then
5688: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5689: end if;
5690: --
5691:
5692: exception
5690: --
5691:
5692: exception
5693: when others then
5694: hr_utility.set_location('Exception in '|| l_proc, 99);
5695: raise;
5696:
5697: end;
5698: -- --------------------------------------------------------------------------
5715:
5716: begin
5717: --
5718: if g_debug then
5719: hr_utility.set_location('Entering:'|| l_proc, 10);
5720: end if;
5721: --
5722: -- Customer can override p_salary_3_year_ago_frequency here
5723: return p_salary_3_year_ago_frequency;
5722: -- Customer can override p_salary_3_year_ago_frequency here
5723: return p_salary_3_year_ago_frequency;
5724: --
5725: if g_debug then
5726: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5727: end if;
5728: --
5729:
5730: exception
5728: --
5729:
5730: exception
5731: when others then
5732: hr_utility.set_location('Exception in '|| l_proc, 99);
5733: raise;
5734:
5735: end;
5736: -- --------------------------------------------------------------------------
5752: --
5753: begin
5754: --
5755: if g_debug then
5756: hr_utility.set_location('Entering:'|| l_proc, 10);
5757: end if;
5758: --
5759: -- Customer can override p_salary_4_year_ago_frequency here
5760: return p_salary_4_year_ago_frequency;
5759: -- Customer can override p_salary_4_year_ago_frequency here
5760: return p_salary_4_year_ago_frequency;
5761: --
5762: if g_debug then
5763: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5764: end if;
5765: --
5766:
5767: exception
5765: --
5766:
5767: exception
5768: when others then
5769: hr_utility.set_location('Exception in '|| l_proc, 99);
5770: raise;
5771:
5772: end;
5773: -- --------------------------------------------------------------------------
5789: --
5790: begin
5791: --
5792: if g_debug then
5793: hr_utility.set_location('Entering:'|| l_proc, 10);
5794: end if;
5795: --
5796: -- Customer can override p_salary_4_year_ago_currency here
5797: return p_salary_4_year_ago_currency;
5796: -- Customer can override p_salary_4_year_ago_currency here
5797: return p_salary_4_year_ago_currency;
5798: --
5799: if g_debug then
5800: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5801: end if;
5802: --
5803:
5804: exception
5802: --
5803:
5804: exception
5805: when others then
5806: hr_utility.set_location('Exception in '|| l_proc, 99);
5807: raise;
5808:
5809: end;
5810: -- --------------------------------------------------------------------------
5827:
5828: begin
5829: --
5830: if g_debug then
5831: hr_utility.set_location('Entering:'|| l_proc, 10);
5832: end if;
5833: --
5834: -- Customer can override p_salary_5_year_ago_frequency here
5835: return p_salary_5_year_ago_frequency;
5834: -- Customer can override p_salary_5_year_ago_frequency here
5835: return p_salary_5_year_ago_frequency;
5836: --
5837: if g_debug then
5838: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5839: end if;
5840: --
5841:
5842: exception
5840: --
5841:
5842: exception
5843: when others then
5844: hr_utility.set_location('Exception in '|| l_proc, 99);
5845: raise;
5846:
5847: end;
5848: -- --------------------------------------------------------------------------
5865:
5866: begin
5867: --
5868: if g_debug then
5869: hr_utility.set_location('Entering:'|| l_proc, 10);
5870: end if;
5871: --
5872: -- Customer can override p_salary_5_year_ago_currency here
5873: return p_salary_5_year_ago_currency;
5872: -- Customer can override p_salary_5_year_ago_currency here
5873: return p_salary_5_year_ago_currency;
5874: --
5875: if g_debug then
5876: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5877: end if;
5878: --
5879:
5880: exception
5878: --
5879:
5880: exception
5881: when others then
5882: hr_utility.set_location('Exception in '|| l_proc, 99);
5883: raise;
5884:
5885: end;
5886: -- --------------------------------------------------------------------------
5903:
5904: begin
5905: --
5906: if g_debug then
5907: hr_utility.set_location('Entering:'|| l_proc, 10);
5908: end if;
5909: --
5910: -- Customer can override p_prev_sal_frequency here
5911: return p_prev_sal_frequency;
5910: -- Customer can override p_prev_sal_frequency here
5911: return p_prev_sal_frequency;
5912: --
5913: if g_debug then
5914: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5915: end if;
5916: --
5917:
5918: exception
5916: --
5917:
5918: exception
5919: when others then
5920: hr_utility.set_location('Exception in '|| l_proc, 99);
5921: raise;
5922:
5923: end;
5924: -- --------------------------------------------------------------------------
5941:
5942: begin
5943: --
5944: if g_debug then
5945: hr_utility.set_location('Entering:'|| l_proc, 10);
5946: end if;
5947: --
5948: -- Customer can override p_prev_sal_currency here
5949: return p_prev_sal_currency;
5948: -- Customer can override p_prev_sal_currency here
5949: return p_prev_sal_currency;
5950: --
5951: if g_debug then
5952: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5953: end if;
5954: --
5955:
5956: exception
5954: --
5955:
5956: exception
5957: when others then
5958: hr_utility.set_location('Exception in '|| l_proc, 99);
5959: raise;
5960:
5961: end;
5962: -- --------------------------------------------------------------------------
5979:
5980: begin
5981: --
5982: if g_debug then
5983: hr_utility.set_location('Entering:'|| l_proc, 10);
5984: end if;
5985: --
5986: -- Customer can override p_prev_sal_chg_rsn here
5987: return p_prev_sal_chg_rsn;
5986: -- Customer can override p_prev_sal_chg_rsn here
5987: return p_prev_sal_chg_rsn;
5988: --
5989: if g_debug then
5990: hr_utility.set_location(' Leaving:'|| l_proc, 99);
5991: end if;
5992: --
5993:
5994: exception
5992: --
5993:
5994: exception
5995: when others then
5996: hr_utility.set_location('Exception in '|| l_proc, 99);
5997: raise;
5998:
5999: end;
6000: -- --------------------------------------------------------------------------
6016: --
6017: begin
6018: --
6019: if g_debug then
6020: hr_utility.set_location('Entering:'|| l_proc, 10);
6021: end if;
6022: --
6023: -- Customer can override p_mkt_currency here
6024: return p_mkt_currency;
6023: -- Customer can override p_mkt_currency here
6024: return p_mkt_currency;
6025: --
6026: if g_debug then
6027: hr_utility.set_location(' Leaving:'|| l_proc, 99);
6028: end if;
6029: --
6030:
6031: exception
6029: --
6030:
6031: exception
6032: when others then
6033: hr_utility.set_location('Exception in '|| l_proc, 99);
6034: raise;
6035:
6036: end;
6037: -- --------------------------------------------------------------------------
6054:
6055: begin
6056: --
6057: if g_debug then
6058: hr_utility.set_location('Entering:'|| l_proc, 10);
6059: end if;
6060: --
6061: -- Customer can override p_mkt_frequency here
6062: return p_mkt_frequency;
6061: -- Customer can override p_mkt_frequency here
6062: return p_mkt_frequency;
6063: --
6064: if g_debug then
6065: hr_utility.set_location(' Leaving:'|| l_proc, 99);
6066: end if;
6067: --
6068:
6069: exception
6067: --
6068:
6069: exception
6070: when others then
6071: hr_utility.set_location('Exception in '|| l_proc, 99);
6072: raise;
6073:
6074: end;
6075: -- --------------------------------------------------------------------------
6091: --
6092: begin
6093: --
6094: if g_debug then
6095: hr_utility.set_location('Entering:'|| l_proc, 10);
6096: end if;
6097: --
6098: -- Customer can override p_mkt_emp_quartile here
6099: return p_mkt_emp_quartile;
6098: -- Customer can override p_mkt_emp_quartile here
6099: return p_mkt_emp_quartile;
6100: --
6101: if g_debug then
6102: hr_utility.set_location(' Leaving:'|| l_proc, 99);
6103: end if;
6104: --
6105:
6106: exception
6104: --
6105:
6106: exception
6107: when others then
6108: hr_utility.set_location('Exception in '|| l_proc, 99);
6109: raise;
6110:
6111: end;
6112: