[Home] [Help]
81: stages.
82:
83: 28-Jul-2004 bmanyam 115.30 Bug 3761038. Split UNIONed queryies into 2.
84: Search Text "PERFNEW".
85: 05-Aug-2005 mmudigon 115.31 Bug 4518047. Removed hr_utility
86: statements at lines 305,306 and
87: 307
88: */
89: --------------------------------------------------------------------------------
207: l_prev_index PLS_INTEGER;
208: --
209: BEGIN
210: --
211: hr_utility.set_location ('Entering '||l_package,10);
212: hr_utility.set_location ('p_old_val '||p_old_val,10);
213: hr_utility.set_location ('p_new_val '||p_new_val,10);
214:
215: --
208: --
209: BEGIN
210: --
211: hr_utility.set_location ('Entering '||l_package,10);
212: hr_utility.set_location ('p_old_val '||p_old_val,10);
213: hr_utility.set_location ('p_new_val '||p_new_val,10);
214:
215: --
216: -- Steps to do process
209: BEGIN
210: --
211: hr_utility.set_location ('Entering '||l_package,10);
212: hr_utility.set_location ('p_old_val '||p_old_val,10);
213: hr_utility.set_location ('p_new_val '||p_new_val,10);
214:
215: --
216: -- Steps to do process
217: --
227: --
228: IF NOT g_cache_pgm_los_el_rec.EXISTS(l_index) THEN
229: --
230: -- Lets store the hash value in this index
231: hr_utility.set_location ('raise ndf ',10);
232: --
233: RAISE NO_DATA_FOUND;
234: --
235: ELSE
251: --
252: IF NOT g_cache_pgm_los_el_rec.EXISTS(l_index) THEN
253: --
254: -- Lets store the hash value in the index
255: hr_utility.set_location ('raise ndf ',20);
256: --
257: RAISE NO_DATA_FOUND;
258: --
259: ELSE
278: --
279: IF p_old_val IS NOT NULL
280: AND p_new_val IS NOT NULL THEN
281: --
282: hr_utility.set_location ('raise ndf ',30);
283: RAISE NO_DATA_FOUND;
284: --
285: END IF;
286:
285: END IF;
286:
287: p_rec := g_cache_pgm_los_el_rec(l_index);
288: --
289: hr_utility.set_location ('Leaving '||l_package,10);
290: --
291: EXCEPTION
292: --
293: WHEN NO_DATA_FOUND THEN
408: l_not_hash_found BOOLEAN;
409: --
410: BEGIN
411: --
412: -- hr_utility.set_location ('Entering '||l_package,10);
413: --
414: -- Steps to do process
415: --
416: -- 1) Try and get value from cache
479: --
480: END IF;
481: p_rec := g_cache_pl_los_el_rec(l_index);
482: --
483: -- hr_utility.set_location ('Leaving '||l_package,10);
484: --
485: EXCEPTION
486: --
487: WHEN NO_DATA_FOUND THEN
598: l_not_hash_found BOOLEAN;
599: --
600: BEGIN
601: --
602: -- hr_utility.set_location ('Entering '||l_package,10);
603: --
604: -- Steps to do process
605: --
606: -- 1) Try and get value from cache
670: END IF;
671:
672: p_rec := g_cache_oipl_los_el_rec(l_index);
673: --
674: -- hr_utility.set_location ('Leaving '||l_package,10);
675: --
676: EXCEPTION
677: --
678: WHEN NO_DATA_FOUND THEN
793: l_not_hash_found BOOLEAN;
794: --
795: BEGIN
796: --
797: -- hr_utility.set_location ('Entering '||l_package,10);
798: --
799: -- Steps to do process
800: --
801: -- 1) Try and get value from cache
864: --
865: END IF;
866: p_rec := g_cache_plip_los_el_rec(l_index);
867: --
868: -- hr_utility.set_location ('Leaving '||l_package,10);
869: --
870: EXCEPTION
871: --
872: WHEN NO_DATA_FOUND THEN
982: l_not_hash_found BOOLEAN;
983: --
984: BEGIN
985: --
986: -- hr_utility.set_location ('Entering '||l_package,10);
987: --
988: -- Steps to do process
989: --
990: -- 1) Try and get value from cache
1053: --
1054: END IF;
1055: p_rec := g_cache_ptip_los_el_rec(l_index);
1056: --
1057: -- hr_utility.set_location ('Leaving '||l_package,10);
1058: --
1059: EXCEPTION
1060: --
1061: WHEN NO_DATA_FOUND THEN
1098: l_package VARCHAR2(80) := g_package || '.get_los_elig';
1099: --
1100: BEGIN
1101: --
1102: -- hr_utility.set_location ('Entering '||l_package,10);
1103: --
1104: -- Derive which data type we are dealing with
1105: --
1106: IF p_pgm_id IS NOT NULL THEN
1149: ,p_rec => p_rec);
1150: --
1151: END IF;
1152: --
1153: -- hr_utility.set_location ('Leaving '||l_package,10);
1154: --
1155: END get_los_elig;
1156: --
1157: PROCEDURE get_los_stated(
1182: l_not_hash_found BOOLEAN;
1183: --
1184: BEGIN
1185: --
1186: -- hr_utility.set_location ('Entering '||l_package,10);
1187: --
1188: -- Steps to do process
1189: --
1190: -- 1) Try and get value from cache
1247: END IF;
1248: --
1249: p_rec := g_cache_stated_los_rec(l_index);
1250: --
1251: -- hr_utility.set_location ('Leaving '||l_package,10);
1252: --
1253: EXCEPTION
1254: --
1255: WHEN NO_DATA_FOUND THEN
1443: l_c2notfound BOOLEAN;
1444: --
1445: BEGIN
1446: --
1447: -- hr_utility.set_location ('Entering '||l_package,10);
1448: --
1449: -- Steps to do process
1450: --
1451: -- 1) Try and get value from cache
1522: END IF;
1523: --
1524: p_rec := g_cache_pgm_los_rt_rec(l_index);
1525: --
1526: -- hr_utility.set_location ('Leaving '||l_package,10);
1527: --
1528: EXCEPTION
1529: --
1530: WHEN NO_DATA_FOUND THEN
1747:
1748: --
1749: BEGIN
1750: --
1751: -- hr_utility.set_location ('Entering '||l_package,10);
1752: --
1753: -- Steps to do process
1754: --
1755: -- 1) Try and get value from cache
2060: l_c2notfound BOOLEAN;
2061: --
2062: BEGIN
2063: --
2064: -- hr_utility.set_location ('Entering '||l_package,10);
2065: --
2066: -- Steps to do process
2067: --
2068: -- 1) Try and get value from cache
2139: END IF;
2140: --
2141: p_rec := g_cache_oipl_los_rt_rec(l_index);
2142: --
2143: -- hr_utility.set_location ('Leaving '||l_package,10);
2144: --
2145: EXCEPTION
2146: --
2147: WHEN NO_DATA_FOUND THEN
2361: l_c2notfound BOOLEAN;
2362: --
2363: BEGIN
2364: --
2365: -- hr_utility.set_location ('Entering '||l_package,10);
2366: --
2367: -- Steps to do process
2368: --
2369: -- 1) Try and get value from cache
2440: END IF;
2441: --
2442: p_rec := g_cache_plip_los_rt_rec(l_index);
2443: --
2444: -- hr_utility.set_location ('Leaving '||l_package,10);
2445: --
2446: EXCEPTION
2447: --
2448: WHEN NO_DATA_FOUND THEN
2660: l_c2notfound BOOLEAN;
2661: --
2662: BEGIN
2663: --
2664: -- hr_utility.set_location ('Entering '||l_package,10);
2665: --
2666: -- Steps to do process
2667: --
2668: -- 1) Try and get value from cache
2739: END IF;
2740: --
2741: p_rec := g_cache_ptip_los_rt_rec(l_index);
2742: --
2743: -- hr_utility.set_location ('Leaving '||l_package,10);
2744: --
2745: EXCEPTION
2746: --
2747: WHEN NO_DATA_FOUND THEN
2959: l_c2notfound BOOLEAN;
2960: --
2961: BEGIN
2962: --
2963: -- hr_utility.set_location ('Entering '||l_package,10);
2964: --
2965: -- Steps to do process
2966: --
2967: -- 1) Try and get value from cache
3038: END IF;
3039: --
3040: p_rec := g_cache_oiplip_los_rt_rec(l_index);
3041: --
3042: -- hr_utility.set_location ('Leaving '||l_package,10);
3043: --
3044: EXCEPTION
3045: --
3046: WHEN NO_DATA_FOUND THEN
3101: l_package VARCHAR2(80) := g_package || '.get_los_rate';
3102: --
3103: BEGIN
3104: --
3105: -- hr_utility.set_location ('Entering '||l_package,10);
3106: --
3107: -- Derive which data type we are dealing with
3108: --
3109: IF p_pgm_id IS NOT NULL THEN
3161: ,p_rec => p_rec);
3162: --
3163: END IF;
3164: --
3165: -- hr_utility.set_location ('Leaving '||l_package,10);
3166: --
3167: END get_los_rate;
3168: --
3169: PROCEDURE get_age_pgm_elig(
3252: l_not_hash_found BOOLEAN;
3253: --
3254: BEGIN
3255: --
3256: -- hr_utility.set_location ('Entering '||l_package,10);
3257: --
3258: -- Steps to do process
3259: --
3260: -- 1) Try and get value from cache
3324: END IF;
3325:
3326: p_rec := g_cache_pgm_age_el_rec(l_index);
3327: --
3328: -- hr_utility.set_location ('Leaving '||l_package,10);
3329: --
3330: EXCEPTION
3331: --
3332: WHEN NO_DATA_FOUND THEN
3437: l_not_hash_found BOOLEAN;
3438: --
3439: BEGIN
3440: --
3441: -- hr_utility.set_location ('Entering '||l_package,10);
3442: --
3443: -- Steps to do process
3444: --
3445: -- 1) Try and get value from cache
3508: --
3509: END IF;
3510: p_rec := g_cache_pl_age_el_rec(l_index);
3511: --
3512: -- hr_utility.set_location ('Leaving '||l_package,10);
3513: --
3514: EXCEPTION
3515: --
3516: WHEN NO_DATA_FOUND THEN
3621: l_not_hash_found BOOLEAN;
3622: --
3623: BEGIN
3624: --
3625: -- hr_utility.set_location ('Entering '||l_package,10);
3626: --
3627: -- Steps to do process
3628: --
3629: -- 1) Try and get value from cache
3692: --
3693: END IF;
3694: p_rec := g_cache_oipl_age_el_rec(l_index);
3695: --
3696: -- hr_utility.set_location ('Leaving '||l_package,10);
3697: --
3698: EXCEPTION
3699: --
3700: WHEN NO_DATA_FOUND THEN
3805: l_not_hash_found BOOLEAN;
3806: --
3807: BEGIN
3808: --
3809: -- hr_utility.set_location ('Entering '||l_package,10);
3810: --
3811: -- Steps to do process
3812: --
3813: -- 1) Try and get value from cache
3876: --
3877: END IF;
3878: p_rec := g_cache_plip_age_el_rec(l_index);
3879: --
3880: -- hr_utility.set_location ('Leaving '||l_package,10);
3881: --
3882: EXCEPTION
3883: --
3884: WHEN NO_DATA_FOUND THEN
3989: l_not_hash_found BOOLEAN;
3990: --
3991: BEGIN
3992: --
3993: -- hr_utility.set_location ('Entering '||l_package,10);
3994: --
3995: -- Steps to do process
3996: --
3997: -- 1) Try and get value from cache
4060: --
4061: END IF;
4062: p_rec := g_cache_ptip_age_el_rec(l_index);
4063: --
4064: -- hr_utility.set_location ('Leaving '||l_package,10);
4065: --
4066: EXCEPTION
4067: --
4068: WHEN NO_DATA_FOUND THEN
4113: l_not_hash_found BOOLEAN;
4114: --
4115: BEGIN
4116: --
4117: -- hr_utility.set_location ('Entering '||l_package,10);
4118: --
4119: -- Steps to do process
4120: --
4121: -- 1) Try and get value from cache
4178: END IF;
4179: --
4180: p_rec := g_cache_stated_age_rec(l_index);
4181: --
4182: -- hr_utility.set_location ('Leaving '||l_package,10);
4183: --
4184: EXCEPTION
4185: --
4186: WHEN NO_DATA_FOUND THEN
4220: l_package VARCHAR2(80) := g_package || '.get_age_elig';
4221: --
4222: BEGIN
4223: --
4224: -- hr_utility.set_location ('Entering '||l_package,10);
4225: --
4226: -- Derive which data type we are dealing with
4227: --
4228: IF p_pgm_id IS NOT NULL THEN
4271: ,p_rec => p_rec);
4272: --
4273: END IF;
4274: --
4275: -- hr_utility.set_location ('Leaving '||l_package,10);
4276: --
4277: END get_age_elig;
4278: --
4279: PROCEDURE get_age_pgm_rate(
4443: l_c2notfound BOOLEAN;
4444: --
4445: BEGIN
4446: --
4447: -- hr_utility.set_location ('Entering '||l_package,10);
4448: --
4449: -- Steps to do process
4450: --
4451: -- 1) Try and get value from cache
4522: END IF;
4523: --
4524: p_rec := g_cache_pgm_age_rt_rec(l_index);
4525: --
4526: -- hr_utility.set_location ('Leaving '||l_package,10);
4527: --
4528: EXCEPTION
4529: --
4530: WHEN NO_DATA_FOUND THEN
4736: l_c2notfound BOOLEAN;
4737: --
4738: BEGIN
4739: --
4740: -- hr_utility.set_location ('Entering '||l_package,10);
4741: --
4742: -- Steps to do process
4743: --
4744: -- 1) Try and get value from cache
4815: END IF;
4816: --
4817: p_rec := g_cache_pl_age_rt_rec(l_index);
4818: --
4819: -- hr_utility.set_location ('Leaving '||l_package,10);
4820: --
4821: EXCEPTION
4822: --
4823: WHEN NO_DATA_FOUND THEN
5044: l_c2notfound BOOLEAN;
5045: --
5046: BEGIN
5047: --
5048: -- hr_utility.set_location ('Entering '||l_package,10);
5049: --
5050: -- Steps to do process
5051: --
5052: -- 1) Try and get value from cache
5123: END IF;
5124: --
5125: p_rec := g_cache_oipl_age_rt_rec(l_index);
5126: --
5127: -- hr_utility.set_location ('Leaving '||l_package,10);
5128: --
5129: EXCEPTION
5130: --
5131: WHEN NO_DATA_FOUND THEN
5341: l_c2notfound BOOLEAN;
5342: --
5343: BEGIN
5344: --
5345: -- hr_utility.set_location ('Entering '||l_package,10);
5346: --
5347: -- Steps to do process
5348: --
5349: -- 1) Try and get value from cache
5420: END IF;
5421: --
5422: p_rec := g_cache_plip_age_rt_rec(l_index);
5423: --
5424: -- hr_utility.set_location ('Leaving '||l_package,10);
5425: --
5426: EXCEPTION
5427: --
5428: WHEN NO_DATA_FOUND THEN
5634: l_c2notfound BOOLEAN;
5635: --
5636: BEGIN
5637: --
5638: -- hr_utility.set_location ('Entering '||l_package,10);
5639: --
5640: -- Steps to do process
5641: --
5642: -- 1) Try and get value from cache
5713: END IF;
5714: --
5715: p_rec := g_cache_ptip_age_rt_rec(l_index);
5716: --
5717: -- hr_utility.set_location ('Leaving '||l_package,10);
5718: --
5719: EXCEPTION
5720: --
5721: WHEN NO_DATA_FOUND THEN
5927: l_c2notfound BOOLEAN;
5928: --
5929: BEGIN
5930: --
5931: -- hr_utility.set_location ('Entering '||l_package,10);
5932: --
5933: -- Steps to do process
5934: --
5935: -- 1) Try and get value from cache
6006: END IF;
6007: --
6008: p_rec := g_cache_oiplip_age_rt_rec(l_index);
6009: --
6010: -- hr_utility.set_location ('Leaving '||l_package,10);
6011: --
6012: EXCEPTION
6013: --
6014: WHEN NO_DATA_FOUND THEN
6069: l_package VARCHAR2(80) := g_package || '.get_age_rate';
6070: --
6071: BEGIN
6072: --
6073: -- hr_utility.set_location ('Entering '||l_package,10);
6074: --
6075: -- Derive which data type we are dealing with
6076: --
6077: IF p_pgm_id IS NOT NULL THEN
6129: ,p_rec => p_rec);
6130: --
6131: END IF;
6132: --
6133: -- hr_utility.set_location ('Leaving '||l_package,10);
6134: --
6135: END get_age_rate;
6136: --
6137: PROCEDURE get_comp_pgm_elig(
6224: l_not_hash_found BOOLEAN;
6225: --
6226: BEGIN
6227: --
6228: -- hr_utility.set_location ('Entering '||l_package,10);
6229: --
6230: -- Steps to do process
6231: --
6232: -- 1) Try and get value from cache
6296: END IF;
6297:
6298: p_rec := g_cache_pgm_clf_el_rec(l_index);
6299: --
6300: -- hr_utility.set_location ('Leaving '||l_package,10);
6301: --
6302: EXCEPTION
6303: --
6304: WHEN NO_DATA_FOUND THEN
6413: l_not_hash_found BOOLEAN;
6414: --
6415: BEGIN
6416: --
6417: -- hr_utility.set_location ('Entering '||l_package,10);
6418: --
6419: -- Steps to do process
6420: --
6421: -- 1) Try and get value from cache
6484: --
6485: END IF;
6486: p_rec := g_cache_pl_clf_el_rec(l_index);
6487: --
6488: -- hr_utility.set_location ('Leaving '||l_package,10);
6489: --
6490: EXCEPTION
6491: --
6492: WHEN NO_DATA_FOUND THEN
6601: l_not_hash_found BOOLEAN;
6602: --
6603: BEGIN
6604: --
6605: -- hr_utility.set_location ('Entering '||l_package,10);
6606: --
6607: -- Steps to do process
6608: --
6609: -- 1) Try and get value from cache
6672: --
6673: END IF;
6674: p_rec := g_cache_oipl_clf_el_rec(l_index);
6675: --
6676: -- hr_utility.set_location ('Leaving '||l_package,10);
6677: --
6678: EXCEPTION
6679: --
6680: WHEN NO_DATA_FOUND THEN
6789: l_not_hash_found BOOLEAN;
6790: --
6791: BEGIN
6792: --
6793: -- hr_utility.set_location ('Entering '||l_package,10);
6794: --
6795: -- Steps to do process
6796: --
6797: -- 1) Try and get value from cache
6860: --
6861: END IF;
6862: p_rec := g_cache_plip_clf_el_rec(l_index);
6863: --
6864: -- hr_utility.set_location ('Leaving '||l_package,10);
6865: --
6866: EXCEPTION
6867: --
6868: WHEN NO_DATA_FOUND THEN
6977: l_not_hash_found BOOLEAN;
6978: --
6979: BEGIN
6980: --
6981: -- hr_utility.set_location ('Entering '||l_package,10);
6982: --
6983: -- Steps to do process
6984: --
6985: -- 1) Try and get value from cache
7048: --
7049: END IF;
7050: p_rec := g_cache_ptip_clf_el_rec(l_index);
7051: --
7052: -- hr_utility.set_location ('Leaving '||l_package,10);
7053: --
7054: EXCEPTION
7055: --
7056: WHEN NO_DATA_FOUND THEN
7090: l_package VARCHAR2(80) := g_package || '.get_comp_elig';
7091: --
7092: BEGIN
7093: --
7094: -- hr_utility.set_location ('Entering '||l_package,10);
7095: --
7096: -- Derive which data type we are dealing with
7097: --
7098: IF p_pgm_id IS NOT NULL THEN
7141: ,p_rec => p_rec);
7142: --
7143: END IF;
7144: --
7145: -- hr_utility.set_location ('Leaving '||l_package,10);
7146: --
7147: END get_comp_elig;
7148: --
7149: PROCEDURE get_comp_pgm_rate(
7321: l_c2notfound BOOLEAN;
7322: --
7323: BEGIN
7324: --
7325: -- hr_utility.set_location ('Entering '||l_package,10);
7326: --
7327: -- Steps to do process
7328: --
7329: -- 1) Try and get value from cache
7400: END IF;
7401: --
7402: p_rec := g_cache_pgm_clf_rt_rec(l_index);
7403: --
7404: -- hr_utility.set_location ('Leaving '||l_package,10);
7405: --
7406: EXCEPTION
7407: --
7408: WHEN NO_DATA_FOUND THEN
7622: l_c2notfound BOOLEAN;
7623: --
7624: BEGIN
7625: --
7626: -- hr_utility.set_location ('Entering '||l_package,10);
7627: --
7628: -- Steps to do process
7629: --
7630: -- 1) Try and get value from cache
7701: END IF;
7702: --
7703: p_rec := g_cache_pl_clf_rt_rec(l_index);
7704: --
7705: -- hr_utility.set_location ('Leaving '||l_package,10);
7706: --
7707: EXCEPTION
7708: --
7709: WHEN NO_DATA_FOUND THEN
7939: l_c2notfound BOOLEAN;
7940: --
7941: BEGIN
7942: --
7943: -- hr_utility.set_location ('Entering '||l_package,10);
7944: --
7945: -- Steps to do process
7946: --
7947: -- 1) Try and get value from cache
8018: END IF;
8019: --
8020: p_rec := g_cache_oipl_clf_rt_rec(l_index);
8021: --
8022: -- hr_utility.set_location ('Leaving '||l_package,10);
8023: --
8024: EXCEPTION
8025: --
8026: WHEN NO_DATA_FOUND THEN
8242: l_c2notfound BOOLEAN;
8243: --
8244: BEGIN
8245: --
8246: -- hr_utility.set_location ('Entering '||l_package,10);
8247: --
8248: -- Steps to do process
8249: --
8250: -- 1) Try and get value from cache
8321: END IF;
8322: --
8323: p_rec := g_cache_plip_clf_rt_rec(l_index);
8324: --
8325: -- hr_utility.set_location ('Leaving '||l_package,10);
8326: --
8327: EXCEPTION
8328: --
8329: WHEN NO_DATA_FOUND THEN
8543: l_c2notfound BOOLEAN;
8544: --
8545: BEGIN
8546: --
8547: -- hr_utility.set_location ('Entering '||l_package,10);
8548: --
8549: -- Steps to do process
8550: --
8551: -- 1) Try and get value from cache
8622: END IF;
8623: --
8624: p_rec := g_cache_ptip_clf_rt_rec(l_index);
8625: --
8626: -- hr_utility.set_location ('Leaving '||l_package,10);
8627: --
8628: EXCEPTION
8629: --
8630: WHEN NO_DATA_FOUND THEN
8844: l_c2notfound BOOLEAN;
8845: --
8846: BEGIN
8847: --
8848: -- hr_utility.set_location ('Entering '||l_package,10);
8849: --
8850: -- Steps to do process
8851: --
8852: -- 1) Try and get value from cache
8923: END IF;
8924: --
8925: p_rec := g_cache_oiplip_clf_rt_rec(l_index);
8926: --
8927: -- hr_utility.set_location ('Leaving '||l_package,10);
8928: --
8929: EXCEPTION
8930: --
8931: WHEN NO_DATA_FOUND THEN
8986: l_package VARCHAR2(80) := g_package || '.get_comp_rate';
8987: --
8988: BEGIN
8989: --
8990: -- hr_utility.set_location ('Entering '||l_package,10);
8991: --
8992: -- Derive which data type we are dealing with
8993: --
8994: IF p_pgm_id IS NOT NULL THEN
9046: ,p_rec => p_rec);
9047: --
9048: END IF;
9049: --
9050: -- hr_utility.set_location ('Leaving '||l_package,10);
9051: --
9052: END get_comp_rate;
9053: --
9054: PROCEDURE get_comb_pgm_elig(
9132: l_not_hash_found BOOLEAN;
9133: --
9134: BEGIN
9135: --
9136: -- hr_utility.set_location ('Entering '||l_package,10);
9137: --
9138: -- Steps to do process
9139: --
9140: -- 1) Try and get value from cache
9204: END IF;
9205:
9206: p_rec := g_cache_pgm_cla_el_rec(l_index);
9207: --
9208: -- hr_utility.set_location ('Leaving '||l_package,10);
9209: --
9210: EXCEPTION
9211: --
9212: WHEN NO_DATA_FOUND THEN
9313: l_not_hash_found BOOLEAN;
9314: --
9315: BEGIN
9316: --
9317: -- hr_utility.set_location ('Entering '||l_package,10);
9318: --
9319: -- Steps to do process
9320: --
9321: -- 1) Try and get value from cache
9384: --
9385: END IF;
9386: p_rec := g_cache_pl_cla_el_rec(l_index);
9387: --
9388: -- hr_utility.set_location ('Leaving '||l_package,10);
9389: --
9390: EXCEPTION
9391: --
9392: WHEN NO_DATA_FOUND THEN
9493: l_not_hash_found BOOLEAN;
9494: --
9495: BEGIN
9496: --
9497: -- hr_utility.set_location ('Entering '||l_package,10);
9498: --
9499: -- Steps to do process
9500: --
9501: -- 1) Try and get value from cache
9564: --
9565: END IF;
9566: p_rec := g_cache_oipl_cla_el_rec(l_index);
9567: --
9568: -- hr_utility.set_location ('Leaving '||l_package,10);
9569: --
9570: EXCEPTION
9571: --
9572: WHEN NO_DATA_FOUND THEN
9673: l_not_hash_found BOOLEAN;
9674: --
9675: BEGIN
9676: --
9677: -- hr_utility.set_location ('Entering '||l_package,10);
9678: --
9679: -- Steps to do process
9680: --
9681: -- 1) Try and get value from cache
9744: --
9745: END IF;
9746: p_rec := g_cache_plip_cla_el_rec(l_index);
9747: --
9748: -- hr_utility.set_location ('Leaving '||l_package,10);
9749: --
9750: EXCEPTION
9751: --
9752: WHEN NO_DATA_FOUND THEN
9853: l_not_hash_found BOOLEAN;
9854: --
9855: BEGIN
9856: --
9857: -- hr_utility.set_location ('Entering '||l_package,10);
9858: --
9859: -- Steps to do process
9860: --
9861: -- 1) Try and get value from cache
9924: --
9925: END IF;
9926: p_rec := g_cache_ptip_cla_el_rec(l_index);
9927: --
9928: -- hr_utility.set_location ('Leaving '||l_package,10);
9929: --
9930: EXCEPTION
9931: --
9932: WHEN NO_DATA_FOUND THEN
9966: l_package VARCHAR2(80) := g_package || '.get_comb_elig';
9967: --
9968: BEGIN
9969: --
9970: -- hr_utility.set_location ('Entering '||l_package,10);
9971: --
9972: -- Derive which data type we are dealing with
9973: --
9974: IF p_pgm_id IS NOT NULL THEN
10017: ,p_rec => p_rec);
10018: --
10019: END IF;
10020: --
10021: -- hr_utility.set_location ('Leaving '||l_package,10);
10022: --
10023: END get_comb_elig;
10024: --
10025: PROCEDURE get_comb_pgm_rate(
10179: l_c2notfound BOOLEAN;
10180: --
10181: BEGIN
10182: --
10183: -- hr_utility.set_location ('Entering '||l_package,10);
10184: --
10185: -- Steps to do process
10186: --
10187: -- 1) Try and get value from cache
10258: END IF;
10259: --
10260: p_rec := g_cache_pgm_cla_rt_rec(l_index);
10261: --
10262: -- hr_utility.set_location ('Leaving '||l_package,10);
10263: --
10264: EXCEPTION
10265: --
10266: WHEN NO_DATA_FOUND THEN
10462: l_c2notfound BOOLEAN;
10463: --
10464: BEGIN
10465: --
10466: -- hr_utility.set_location ('Entering '||l_package,10);
10467: --
10468: -- Steps to do process
10469: --
10470: -- 1) Try and get value from cache
10541: END IF;
10542: --
10543: p_rec := g_cache_pl_cla_rt_rec(l_index);
10544: --
10545: -- hr_utility.set_location ('Leaving '||l_package,10);
10546: --
10547: EXCEPTION
10548: --
10549: WHEN NO_DATA_FOUND THEN
10761: l_c2notfound BOOLEAN;
10762: --
10763: BEGIN
10764: --
10765: -- hr_utility.set_location ('Entering '||l_package,10);
10766: --
10767: -- Steps to do process
10768: --
10769: -- 1) Try and get value from cache
10840: END IF;
10841: --
10842: p_rec := g_cache_oipl_cla_rt_rec(l_index);
10843: --
10844: -- hr_utility.set_location ('Leaving '||l_package,10);
10845: --
10846: EXCEPTION
10847: --
10848: WHEN NO_DATA_FOUND THEN
11045: l_c2notfound BOOLEAN;
11046: --
11047: BEGIN
11048: --
11049: -- hr_utility.set_location ('Entering '||l_package,10);
11050: --
11051: -- Steps to do process
11052: --
11053: -- 1) Try and get value from cache
11124: END IF;
11125: --
11126: p_rec := g_cache_plip_cla_rt_rec(l_index);
11127: --
11128: -- hr_utility.set_location ('Leaving '||l_package,10);
11129: --
11130: EXCEPTION
11131: --
11132: WHEN NO_DATA_FOUND THEN
11328: l_c2notfound BOOLEAN;
11329: --
11330: BEGIN
11331: --
11332: -- hr_utility.set_location ('Entering '||l_package,10);
11333: --
11334: -- Steps to do process
11335: --
11336: -- 1) Try and get value from cache
11407: END IF;
11408: --
11409: p_rec := g_cache_ptip_cla_rt_rec(l_index);
11410: --
11411: -- hr_utility.set_location ('Leaving '||l_package,10);
11412: --
11413: EXCEPTION
11414: --
11415: WHEN NO_DATA_FOUND THEN
11611: l_c2notfound BOOLEAN;
11612: --
11613: BEGIN
11614: --
11615: -- hr_utility.set_location ('Entering '||l_package,10);
11616: --
11617: -- Steps to do process
11618: --
11619: -- 1) Try and get value from cache
11690: END IF;
11691: --
11692: p_rec := g_cache_oiplip_cla_rt_rec(l_index);
11693: --
11694: -- hr_utility.set_location ('Leaving '||l_package,10);
11695: --
11696: EXCEPTION
11697: --
11698: WHEN NO_DATA_FOUND THEN
11753: l_package VARCHAR2(80) := g_package || '.get_comb_rate';
11754: --
11755: BEGIN
11756: --
11757: -- hr_utility.set_location ('Entering '||l_package,10);
11758: --
11759: -- Derive which data type we are dealing with
11760: --
11761: IF p_pgm_id IS NOT NULL THEN
11813: ,p_rec => p_rec);
11814: --
11815: END IF;
11816: --
11817: -- hr_utility.set_location ('Leaving '||l_package,10);
11818: --
11819: END get_comb_rate;
11820: --
11821: PROCEDURE get_pct_pgm_elig(
11901: l_not_hash_found BOOLEAN;
11902: --
11903: BEGIN
11904: --
11905: -- hr_utility.set_location ('Entering '||l_package,10);
11906: --
11907: -- Steps to do process
11908: --
11909: -- 1) Try and get value from cache
11973: END IF;
11974:
11975: p_rec := g_cache_pgm_pff_el_rec(l_index);
11976: --
11977: -- hr_utility.set_location ('Leaving '||l_package,10);
11978: --
11979: EXCEPTION
11980: --
11981: WHEN NO_DATA_FOUND THEN
12085: l_not_hash_found BOOLEAN;
12086: --
12087: BEGIN
12088: --
12089: -- hr_utility.set_location ('Entering '||l_package,10);
12090: --
12091: -- Steps to do process
12092: --
12093: -- 1) Try and get value from cache
12156: --
12157: END IF;
12158: p_rec := g_cache_pl_pff_el_rec(l_index);
12159: --
12160: -- hr_utility.set_location ('Leaving '||l_package,10);
12161: --
12162: EXCEPTION
12163: --
12164: WHEN NO_DATA_FOUND THEN
12267: l_not_hash_found BOOLEAN;
12268: --
12269: BEGIN
12270: --
12271: -- hr_utility.set_location ('Entering '||l_package,10);
12272: --
12273: -- Steps to do process
12274: --
12275: -- 1) Try and get value from cache
12338: --
12339: END IF;
12340: p_rec := g_cache_oipl_pff_el_rec(l_index);
12341: --
12342: -- hr_utility.set_location ('Leaving '||l_package,10);
12343: --
12344: EXCEPTION
12345: --
12346: WHEN NO_DATA_FOUND THEN
12449: l_not_hash_found BOOLEAN;
12450: --
12451: BEGIN
12452: --
12453: -- hr_utility.set_location ('Entering '||l_package,10);
12454: --
12455: -- Steps to do process
12456: --
12457: -- 1) Try and get value from cache
12520: --
12521: END IF;
12522: p_rec := g_cache_plip_pff_el_rec(l_index);
12523: --
12524: -- hr_utility.set_location ('Leaving '||l_package,10);
12525: --
12526: EXCEPTION
12527: --
12528: WHEN NO_DATA_FOUND THEN
12631: l_not_hash_found BOOLEAN;
12632: --
12633: BEGIN
12634: --
12635: -- hr_utility.set_location ('Entering '||l_package,10);
12636: --
12637: -- Steps to do process
12638: --
12639: -- 1) Try and get value from cache
12702: --
12703: END IF;
12704: p_rec := g_cache_ptip_pff_el_rec(l_index);
12705: --
12706: -- hr_utility.set_location ('Leaving '||l_package,10);
12707: --
12708: EXCEPTION
12709: --
12710: WHEN NO_DATA_FOUND THEN
12744: l_package VARCHAR2(80) := g_package || '.get_pct_elig';
12745: --
12746: BEGIN
12747: --
12748: -- hr_utility.set_location ('Entering '||l_package,10);
12749: --
12750: -- Derive which data type we are dealing with
12751: --
12752: IF p_pgm_id IS NOT NULL THEN
12795: ,p_rec => p_rec);
12796: --
12797: END IF;
12798: --
12799: -- hr_utility.set_location ('Leaving '||l_package,10);
12800: --
12801: END get_pct_elig;
12802: --
12803: PROCEDURE get_pct_pgm_rate(
12931: l_c2notfound BOOLEAN;
12932: --
12933: BEGIN
12934: --
12935: -- hr_utility.set_location ('Entering '||l_package,10);
12936: --
12937: -- Steps to do process
12938: --
12939: -- 1) Try and get value from cache
13010: END IF;
13011: --
13012: p_rec := g_cache_pgm_pff_rt_rec(l_index);
13013: --
13014: -- hr_utility.set_location ('Leaving '||l_package,10);
13015: --
13016: EXCEPTION
13017: --
13018: WHEN NO_DATA_FOUND THEN
13188: l_c2notfound BOOLEAN;
13189: --
13190: BEGIN
13191: --
13192: -- hr_utility.set_location ('Entering '||l_package,10);
13193: --
13194: -- Steps to do process
13195: --
13196: -- 1) Try and get value from cache
13267: END IF;
13268: --
13269: p_rec := g_cache_pl_pff_rt_rec(l_index);
13270: --
13271: -- hr_utility.set_location ('Leaving '||l_package,10);
13272: --
13273: EXCEPTION
13274: --
13275: WHEN NO_DATA_FOUND THEN
13461: l_c2notfound BOOLEAN;
13462: --
13463: BEGIN
13464: --
13465: -- hr_utility.set_location ('Entering '||l_package,10);
13466: --
13467: -- Steps to do process
13468: --
13469: -- 1) Try and get value from cache
13540: END IF;
13541: --
13542: p_rec := g_cache_oipl_pff_rt_rec(l_index);
13543: --
13544: -- hr_utility.set_location ('Leaving '||l_package,10);
13545: --
13546: EXCEPTION
13547: --
13548: WHEN NO_DATA_FOUND THEN
13720: l_c2notfound BOOLEAN;
13721: --
13722: BEGIN
13723: --
13724: -- hr_utility.set_location ('Entering '||l_package,10);
13725: --
13726: -- Steps to do process
13727: --
13728: -- 1) Try and get value from cache
13799: END IF;
13800: --
13801: p_rec := g_cache_plip_pff_rt_rec(l_index);
13802: --
13803: -- hr_utility.set_location ('Leaving '||l_package,10);
13804: --
13805: EXCEPTION
13806: --
13807: WHEN NO_DATA_FOUND THEN
13977: l_c2notfound BOOLEAN;
13978: --
13979: BEGIN
13980: --
13981: -- hr_utility.set_location ('Entering '||l_package,10);
13982: --
13983: -- Steps to do process
13984: --
13985: -- 1) Try and get value from cache
14056: END IF;
14057: --
14058: p_rec := g_cache_ptip_pff_rt_rec(l_index);
14059: --
14060: -- hr_utility.set_location ('Leaving '||l_package,10);
14061: --
14062: EXCEPTION
14063: --
14064: WHEN NO_DATA_FOUND THEN
14234: l_c2notfound BOOLEAN;
14235: --
14236: BEGIN
14237: --
14238: -- hr_utility.set_location ('Entering '||l_package,10);
14239: --
14240: -- Steps to do process
14241: --
14242: -- 1) Try and get value from cache
14313: END IF;
14314: --
14315: p_rec := g_cache_oiplip_pff_rt_rec(l_index);
14316: --
14317: -- hr_utility.set_location ('Leaving '||l_package,10);
14318: --
14319: EXCEPTION
14320: --
14321: WHEN NO_DATA_FOUND THEN
14376: l_package VARCHAR2(80) := g_package || '.get_pct_rate';
14377: --
14378: BEGIN
14379: --
14380: -- hr_utility.set_location ('Entering '||l_package,10);
14381: --
14382: -- Derive which data type we are dealing with
14383: --
14384: IF p_pgm_id IS NOT NULL THEN
14436: ,p_rec => p_rec);
14437: --
14438: END IF;
14439: --
14440: -- hr_utility.set_location ('Leaving '||l_package,10);
14441: --
14442: END get_pct_rate;
14443: --
14444: PROCEDURE get_hours_pgm_elig(
14529: l_not_hash_found BOOLEAN;
14530: --
14531: BEGIN
14532: --
14533: -- hr_utility.set_location ('Entering '||l_package,10);
14534: --
14535: -- Steps to do process
14536: --
14537: -- 1) Try and get value from cache
14601: END IF;
14602:
14603: p_rec := g_cache_pgm_hwf_el_rec(l_index);
14604: --
14605: -- hr_utility.set_location ('Leaving '||l_package,10);
14606: --
14607: EXCEPTION
14608: --
14609: WHEN NO_DATA_FOUND THEN
14717: l_not_hash_found BOOLEAN;
14718: --
14719: BEGIN
14720: --
14721: -- hr_utility.set_location ('Entering '||l_package,10);
14722: --
14723: -- Steps to do process
14724: --
14725: -- 1) Try and get value from cache
14788: --
14789: END IF;
14790: p_rec := g_cache_pl_hwf_el_rec(l_index);
14791: --
14792: -- hr_utility.set_location ('Leaving '||l_package,10);
14793: --
14794: EXCEPTION
14795: --
14796: WHEN NO_DATA_FOUND THEN
14904: l_not_hash_found BOOLEAN;
14905: --
14906: BEGIN
14907: --
14908: -- hr_utility.set_location ('Entering '||l_package,10);
14909: --
14910: -- Steps to do process
14911: --
14912: -- 1) Try and get value from cache
14975: --
14976: END IF;
14977: p_rec := g_cache_oipl_hwf_el_rec(l_index);
14978: --
14979: -- hr_utility.set_location ('Leaving '||l_package,10);
14980: --
14981: EXCEPTION
14982: --
14983: WHEN NO_DATA_FOUND THEN
15091: l_not_hash_found BOOLEAN;
15092: --
15093: BEGIN
15094: --
15095: -- hr_utility.set_location ('Entering '||l_package,10);
15096: --
15097: -- Steps to do process
15098: --
15099: -- 1) Try and get value from cache
15162: --
15163: END IF;
15164: p_rec := g_cache_plip_hwf_el_rec(l_index);
15165: --
15166: -- hr_utility.set_location ('Leaving '||l_package,10);
15167: --
15168: EXCEPTION
15169: --
15170: WHEN NO_DATA_FOUND THEN
15278: l_not_hash_found BOOLEAN;
15279: --
15280: BEGIN
15281: --
15282: -- hr_utility.set_location ('Entering '||l_package,10);
15283: --
15284: -- Steps to do process
15285: --
15286: -- 1) Try and get value from cache
15349: --
15350: END IF;
15351: p_rec := g_cache_ptip_hwf_el_rec(l_index);
15352: --
15353: -- hr_utility.set_location ('Leaving '||l_package,10);
15354: --
15355: EXCEPTION
15356: --
15357: WHEN NO_DATA_FOUND THEN
15391: l_package VARCHAR2(80) := g_package || '.get_hours_elig';
15392: --
15393: BEGIN
15394: --
15395: -- hr_utility.set_location ('Entering '||l_package,10);
15396: --
15397: -- Derive which data type we are dealing with
15398: --
15399: IF p_pgm_id IS NOT NULL THEN
15442: ,p_rec => p_rec);
15443: --
15444: END IF;
15445: --
15446: -- hr_utility.set_location ('Leaving '||l_package,10);
15447: --
15448: END get_hours_elig;
15449: --
15450: PROCEDURE get_hours_pgm_rate(
15618: l_c2notfound BOOLEAN;
15619: --
15620: BEGIN
15621: --
15622: -- hr_utility.set_location ('Entering '||l_package,10);
15623: --
15624: -- Steps to do process
15625: --
15626: -- 1) Try and get value from cache
15697: END IF;
15698: --
15699: p_rec := g_cache_pgm_hwf_rt_rec(l_index);
15700: --
15701: -- hr_utility.set_location ('Leaving '||l_package,10);
15702: --
15703: EXCEPTION
15704: --
15705: WHEN NO_DATA_FOUND THEN
15915: l_c2notfound BOOLEAN;
15916: --
15917: BEGIN
15918: --
15919: -- hr_utility.set_location ('Entering '||l_package,10);
15920: --
15921: -- Steps to do process
15922: --
15923: -- 1) Try and get value from cache
15994: END IF;
15995: --
15996: p_rec := g_cache_pl_hwf_rt_rec(l_index);
15997: --
15998: -- hr_utility.set_location ('Leaving '||l_package,10);
15999: --
16000: EXCEPTION
16001: --
16002: WHEN NO_DATA_FOUND THEN
16228: l_c2notfound BOOLEAN;
16229: --
16230: BEGIN
16231: --
16232: -- hr_utility.set_location ('Entering '||l_package,10);
16233: --
16234: -- Steps to do process
16235: --
16236: -- 1) Try and get value from cache
16307: END IF;
16308: --
16309: p_rec := g_cache_oipl_hwf_rt_rec(l_index);
16310: --
16311: -- hr_utility.set_location ('Leaving '||l_package,10);
16312: --
16313: EXCEPTION
16314: --
16315: WHEN NO_DATA_FOUND THEN
16527: l_c2notfound BOOLEAN;
16528: --
16529: BEGIN
16530: --
16531: -- hr_utility.set_location ('Entering '||l_package,10);
16532: --
16533: -- Steps to do process
16534: --
16535: -- 1) Try and get value from cache
16606: END IF;
16607: --
16608: p_rec := g_cache_plip_hwf_rt_rec(l_index);
16609: --
16610: -- hr_utility.set_location ('Leaving '||l_package,10);
16611: --
16612: EXCEPTION
16613: --
16614: WHEN NO_DATA_FOUND THEN
16824: l_c2notfound BOOLEAN;
16825: --
16826: BEGIN
16827: --
16828: -- hr_utility.set_location ('Entering '||l_package,10);
16829: --
16830: -- Steps to do process
16831: --
16832: -- 1) Try and get value from cache
16903: END IF;
16904: --
16905: p_rec := g_cache_ptip_hwf_rt_rec(l_index);
16906: --
16907: -- hr_utility.set_location ('Leaving '||l_package,10);
16908: --
16909: EXCEPTION
16910: --
16911: WHEN NO_DATA_FOUND THEN
17121: l_c2notfound BOOLEAN;
17122: --
17123: BEGIN
17124: --
17125: -- hr_utility.set_location ('Entering '||l_package,10);
17126: --
17127: -- Steps to do process
17128: --
17129: -- 1) Try and get value from cache
17200: END IF;
17201: --
17202: p_rec := g_cache_oiplip_hwf_rt_rec(l_index);
17203: --
17204: -- hr_utility.set_location ('Leaving '||l_package,10);
17205: --
17206: EXCEPTION
17207: --
17208: WHEN NO_DATA_FOUND THEN
17263: l_package VARCHAR2(80) := g_package || '.get_hours_rate';
17264: --
17265: BEGIN
17266: --
17267: -- hr_utility.set_location ('Entering '||l_package,10);
17268: --
17269: -- Derive which data type we are dealing with
17270: --
17271: IF p_pgm_id IS NOT NULL THEN
17323: ,p_rec => p_rec);
17324: --
17325: END IF;
17326: --
17327: -- hr_utility.set_location ('Leaving '||l_package,10);
17328: --
17329: END get_hours_rate;
17330: --
17331: PROCEDURE clear_down_cache IS
17333: l_package VARCHAR2(80) := g_package || '.clear_down_cache';
17334: --
17335: BEGIN
17336: --
17337: -- hr_utility.set_location ('Entering '||l_package,10);
17338: --
17339: -- Clear down all caches
17340: --
17341: g_cache_pl_los_el_rec.delete;
17406: g_cache_oiplip_hwf_rt_rec.delete;
17407: g_cache_ptip_hwf_rt_rec.delete;
17408: g_cache_pgm_hwf_rt_rec.delete;
17409: --
17410: -- hr_utility.set_location ('Leaving '||l_package,10);
17411: --
17412: END clear_down_cache;
17413: --
17414: END ben_derive_part_and_rate_cache;