[Home] [Help]
1: PACKAGE BODY hxt_time_detail AS
2: /* $Header: hxttdet.pkb 120.34.12010000.4 2008/09/24 09:50:01 sabvenug ship $ */
3: --
4: -- Global variables for package
5: -- Used for parameters received that are not changed
392: g_debug := hr_utility.debug_enabled;
393:
394: IF g_debug
395: THEN
396: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 10);
397: hr_utility.TRACE ( 'p_time_in :'
398: || TO_CHAR (p_time_in, 'DD-MON-YYYY HH24:MI:SS')
399: );
400: hr_utility.TRACE ( 'p_time_out :'
461:
462: -- g_GROUP_ID := p_GROUP_ID; -- HXT11i1
463: IF g_debug
464: THEN
465: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 20);
466: END IF;
467:
468: RETURN gen_special (p_location,
469: g_time_in,
474: );
475:
476: IF g_debug
477: THEN
478: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 30);
479: END IF;
480: -- parameters used for compatibility with this version of gen special
481: END;
482:
1306: l_proc VARCHAR2 (250);
1307: BEGIN
1308: IF g_debug
1309: THEN
1310: l_proc := 'hxt_time_detail.adjust_for_hdp_shortage';
1311: hr_utility.set_location (l_proc, 10);
1312: END IF;
1313:
1314: OPEN current_dtl (p_hours_short);
1829: l_sdp_start DATE;
1830: l_sdp_stop DATE;
1831: l_sdp_carryover DATE;
1832: l_proc VARCHAR2 (250)
1833: := 'hxt_time_detail.adjust_hours_for_premium';
1834: BEGIN
1835: FOR l_sdp_rule IN sdp_rule_cursor
1836: LOOP
1837: hxt_time_summary.time_in_dates (l_sdp_rule.start_time,
2173: deduct_prem_hours NUMBER := 0;
2174: current_dtl_row current_dtl%ROWTYPE;
2175: l_prem_adjusted BOOLEAN := FALSE;
2176: l_proc VARCHAR2 (250)
2177: := 'hxt_time_detail.adjust_hours_for_hdp';
2178: BEGIN
2179: IF g_debug
2180: THEN
2181: hr_utility.set_location (l_proc, 10);
2912: l_proc VARCHAR2 (250);
2913: BEGIN
2914: IF g_debug
2915: THEN
2916: l_proc := 'hxt_time_detail.adjust_for_hdp';
2917: hr_utility.set_location (l_proc, 10);
2918: hr_utility.TRACE ('g_hdp_id :' || g_hdp_id);
2919: END IF;
2920:
3201: l_proc VARCHAR2 (200);
3202: BEGIN
3203: IF g_debug
3204: THEN
3205: l_proc := 'hxt_time_detail.GetConsecutiveDaysWorked';
3206: hr_utility.set_location (l_proc, 10);
3207: END IF;
3208:
3209: i := 0;
3335: l_proc VARCHAR2 (200);
3336: BEGIN
3337: IF g_debug
3338: THEN
3339: l_proc := 'hxt_time_detail.ConsecutiveDaysWorked_for_SPC';
3340: hr_utility.set_location (l_proc, 10);
3341: END IF;
3342:
3343: i := 0;
3735: l_proc VARCHAR2 (200);
3736: BEGIN
3737: IF g_debug
3738: THEN
3739: l_proc := 'hxt_time_detail.adjust_abs_hrs_on_prev_days';
3740: hr_utility.set_location (l_proc, 10);
3741: hr_utility.TRACE ('c_tim_id:' || c_tim_id);
3742: hr_utility.TRACE ( 'c_date_worked :'
3743: || TO_CHAR (c_date_worked,
5138: l_proc VARCHAR2 (200);
5139: BEGIN
5140: IF g_debug
5141: THEN
5142: l_proc := 'hxt_time_detail.adjust_for_absence';
5143: hr_utility.set_location (l_proc, 10);
5144: hr_utility.TRACE ('a_ep_id:' || a_ep_id);
5145: hr_utility.TRACE ( 'a_date_worked :'
5146: || TO_CHAR (a_date_worked,
6558: l_proc VARCHAR2 (50);
6559: BEGIN
6560: IF g_debug
6561: THEN
6562: l_proc := 'HXT_TIME_DETAIL.init_for_wkl_combine_pts_cal';
6563: hr_utility.set_location (l_proc, 10);
6564: END IF;
6565:
6566: OPEN weekly_earn_category_total; --('REG');
6785: g_debug := hr_utility.debug_enabled;
6786:
6787: IF g_debug
6788: THEN
6789: l_proc := 'hxt_time_detail.use_points_to_select_rule_hrs';
6790: hr_utility.set_location (l_proc, 10);
6791: END IF;
6792:
6793: -- Populate the g_daily_earn_category plsql table with element type, hrs
10221: -- debug only --HXT115
10222: IF g_debug
10223: THEN
10224: hr_utility.TRACE ('--------------Gen Special-----------------');
10225: hr_utility.set_location ('hxt_time_detail.gen_special', 1);
10226: hr_utility.TRACE ( 'p_time_in :'
10227: || TO_CHAR (p_time_in, 'DD-MON-YYYY HH24:MI:SS')
10228: );
10229: hr_utility.TRACE ( 'p_time_out :'
10357: THEN
10358: hr_utility.TRACE ( 'summary_earning_category :'
10359: || summary_earning_category
10360: );
10361: hr_utility.set_location ('hxt_time_detail.gen_special', 2);
10362: END IF;
10363:
10364: IF summary_earning_category IS NULL
10365: THEN --- regular hours worked
10411: IF rule_type_to_pay = 'ABS'
10412: THEN
10413: IF g_debug
10414: THEN
10415: hr_utility.set_location ('hxt_time_detail.gen_special', 3);
10416: hr_utility.TRACE
10417: ('-----------Entering rule_type_to_pay = ABS------------');
10418: END IF;
10419:
10456: );
10457:
10458: IF g_debug
10459: THEN
10460: hr_utility.set_location ('hxt_time_detail.gen_special', 4);
10461: END IF;
10462:
10463: IF ERROR_CODE <> 0
10464: THEN
10482: END IF;
10483:
10484: IF g_debug
10485: THEN
10486: hr_utility.set_location ('hxt_time_detail.gen_special', 4.2);
10487: hr_utility.TRACE ( 'date_worked :'
10488: || TO_CHAR (g_date_worked, 'DD/MON/YY')
10489: );
10490: hr_utility.TRACE ('g_call_adjust_abs :' || g_call_adjust_abs);
10495: IF g_call_adjust_abs = 'Y'
10496: THEN
10497: IF g_debug
10498: THEN
10499: hr_utility.set_location ('hxt_time_detail.gen_special', 4.3);
10500: END IF;
10501:
10502: -- begin 688072
10503: IF g_ep_type IN ('WEEKLY', 'SPECIAL')
10504: THEN
10505: -- Bug 2795054
10506: IF g_debug
10507: THEN
10508: hr_utility.set_location ('hxt_time_detail.gen_special',
10509: 4.4);
10510: END IF;
10511:
10512: -- Bug 2795054
10530: IF (l_abs_in_eg IS NOT NULL)
10531: THEN
10532: IF g_debug
10533: THEN
10534: hr_utility.set_location ('hxt_time_detail.gen_special',
10535: 4.5
10536: );
10537: END IF;
10538:
10540: adjust_for_absence (g_tim_id, g_ep_id, g_date_worked);
10541:
10542: IF g_debug
10543: THEN
10544: hr_utility.set_location ('hxt_time_detail.gen_special',
10545: 5
10546: );
10547: hr_utility.TRACE ('error_code :' || ERROR_CODE);
10548: END IF;
10552: THEN
10553: IF g_debug
10554: THEN
10555: hr_utility.set_location
10556: ('hxt_time_detail.gen_special',
10557: 5.1
10558: );
10559: END IF;
10560:
10571: THEN
10572: IF g_debug
10573: THEN
10574: hr_utility.set_location
10575: ('hxt_time_detail.gen_special',
10576: 5.2
10577: );
10578: END IF;
10579:
10592: THEN
10593: IF g_debug
10594: THEN
10595: hr_utility.set_location
10596: ('hxt_time_detail.gen_special',
10597: 5.3
10598: );
10599: END IF;
10600:
10618: THEN
10619: IF g_debug
10620: THEN
10621: hr_utility.set_location
10622: ('hxt_time_detail.gen_special',
10623: 6
10624: );
10625: END IF;
10626:
10636:
10637: --SIR491 END
10638: IF g_debug
10639: THEN
10640: hr_utility.set_location ('hxt_time_detail.gen_special',
10641: 6.1
10642: );
10643: END IF;
10644: END IF;
10644: END IF;
10645:
10646: IF g_debug
10647: THEN
10648: hr_utility.set_location ('hxt_time_detail.gen_special',
10649: 6.2);
10650: END IF;
10651: END IF;
10652:
10651: END IF;
10652:
10653: IF g_debug
10654: THEN
10655: hr_utility.set_location ('hxt_time_detail.gen_special', 6.3);
10656: END IF;
10657: -- end 688072
10658: END IF;
10659: ELSE -- rule_type_to_pay <> ABS
10658: END IF;
10659: ELSE -- rule_type_to_pay <> ABS
10660: IF g_debug
10661: THEN
10662: hr_utility.set_location ('hxt_time_detail.gen_special', 7);
10663: hr_utility.TRACE
10664: ('------------rule_type_to_pay <> ABS------------');
10665: END IF;
10666:
10700: IF ERROR_CODE > l_error_return
10701: THEN
10702: IF g_debug
10703: THEN
10704: hr_utility.set_location ('hxt_time_detail.gen_special', 10);
10705: END IF;
10706:
10707: l_error_return := ERROR_CODE;
10708: hxt_util.DEBUG ( 'Loc F. Return code is '
10728: -- rules.
10729: -- Weekly set to 999 if none found.
10730: IF g_debug
10731: THEN
10732: hr_utility.set_location ('hxt_time_detail.gen_special', 11);
10733: END IF;
10734:
10735: seven_day_cal_rule := FALSE;
10736: five_day_cal_rule := FALSE;
10756: IF daily_earn_rules_cur%FOUND
10757: THEN
10758: IF g_debug
10759: THEN
10760: hr_utility.set_location ('hxt_time_detail.gen_special', 12);
10761: END IF;
10762:
10763: -- Now that we know there is at least one day rule, determine how many
10764: -- consecutive days worked. Use the rule with the highest day number
10828: IF spc_earn_rules_cur%FOUND
10829: THEN
10830: IF g_debug
10831: THEN
10832: hr_utility.set_location ('hxt_time_detail.gen_special', 13);
10833: END IF;
10834:
10835: FETCH spc_earn_rules_cur
10836: INTO special_daily_cap2, special_earning_type2,
10839: IF consecutive_days_limit <> consecutive_days_limit2
10840: THEN
10841: IF g_debug
10842: THEN
10843: hr_utility.set_location ('hxt_time_detail.gen_special',
10844: 14
10845: );
10846: END IF;
10847:
10852: IF consec_days_worked >= consecutive_days_limit
10853: THEN
10854: IF g_debug
10855: THEN
10856: hr_utility.set_location ('hxt_time_detail.gen_special',
10857: 15
10858: );
10859: END IF;
10860:
10861: consecutive_days_reached := TRUE;
10862: ELSE
10863: IF g_debug
10864: THEN
10865: hr_utility.set_location ('hxt_time_detail.gen_special',
10866: 16
10867: );
10868: END IF;
10869:
10873: IF consecutive_days_limit = 7
10874: THEN
10875: IF g_debug
10876: THEN
10877: hr_utility.set_location ('hxt_time_detail.gen_special',
10878: 17
10879: );
10880: END IF;
10881:
10883: ELSIF consecutive_days_limit = 5
10884: THEN
10885: IF g_debug
10886: THEN
10887: hr_utility.set_location ('hxt_time_detail.gen_special',
10888: 18
10889: );
10890: END IF;
10891:
10914: END IF;
10915: ELSE -- spc_earn_rules_cur NOT FOUND
10916: IF g_debug
10917: THEN
10918: hr_utility.set_location ('hxt_time_detail.gen_special', 19);
10919: END IF;
10920:
10921: special_daily_cap := 99;
10922: special_earning_type := NULL;
10925: END IF;
10926: ELSE -- daily_earn_rules_cur NOT FOUND (NO SPECIAL (DAYS) RULE)
10927: IF g_debug
10928: THEN
10929: hr_utility.set_location ('hxt_time_detail.gen_special', 20);
10930: END IF;
10931:
10932: CLOSE daily_earn_rules_cur;
10933: END IF;
10952: IF (daily_earn_rules_cur%NOTFOUND AND (g_ep_type = 'WEEKLY'))
10953: THEN
10954: IF g_debug
10955: THEN
10956: hr_utility.set_location ('hxt_time_detail.gen_special', 21);
10957: hr_utility.TRACE
10958: ('daily_earn_rules_cur NOTFOUND and EP_TYPE = WEEKLY');
10959: END IF;
10960:
10965: IF (daily_earn_rules_cur%NOTFOUND AND (g_ep_type <> 'WEEKLY'))
10966: THEN
10967: IF g_debug
10968: THEN
10969: hr_utility.set_location ('hxt_time_detail.gen_special', 22);
10970: hr_utility.TRACE
10971: ('daily_earn_rules_cur NOTFOUND and EP_TYPE<>WEEKLY');
10972: END IF;
10973:
11011: IF rule_type_to_pay <> 'DAY'
11012: THEN -- for now only HOL
11013: IF g_debug
11014: THEN
11015: hr_utility.set_location ('hxt_time_detail.gen_special', 23);
11016: END IF;
11017:
11018: CLOSE daily_earn_rules_cur; -- opened with parameter DAY
11019:
11026: IF daily_earn_rules_cur%NOTFOUND
11027: THEN
11028: IF g_debug
11029: THEN
11030: hr_utility.set_location ('hxt_time_detail.gen_special', 24);
11031: END IF;
11032:
11033: end_of_day_rules := TRUE;
11034: END IF;
11061: IF weekly_earn_rules_cur%NOTFOUND
11062: THEN
11063: IF g_debug
11064: THEN
11065: hr_utility.set_location ('hxt_time_detail.gen_special', 25);
11066: END IF;
11067:
11068: IF g_ep_type = 'WEEKLY'
11069: THEN
11068: IF g_ep_type = 'WEEKLY'
11069: THEN
11070: IF g_debug
11071: THEN
11072: hr_utility.set_location ('hxt_time_detail.gen_special', 26);
11073: END IF;
11074:
11075: fnd_message.set_name ('HXT', 'HXT_39311_WKLY_ERN_RULES_NF');
11076: ERROR_CODE :=
11085: IF ERROR_CODE > l_error_return
11086: THEN
11087: IF g_debug
11088: THEN
11089: hr_utility.set_location ('hxt_time_detail.gen_special',
11090: 27
11091: );
11092: END IF;
11093:
11098: END IF; --SIR014
11099: ELSE
11100: IF g_debug
11101: THEN
11102: hr_utility.set_location ('hxt_time_detail.gen_special', 28);
11103: END IF;
11104:
11105: weekly_rule_cap := 999;
11106: hours_paid_weekly_rule := 0;
11139: IF hours_paid_weekly_rule >= weekly_rule_cap
11140: THEN
11141: IF g_debug
11142: THEN
11143: hr_utility.set_location ('hxt_time_detail.gen_special', 29);
11144: END IF;
11145:
11146: first_weekly_cap_reached := TRUE;
11147: END IF;
11168: -- bug 2956224 fix.
11169: LOOP
11170: IF g_debug
11171: THEN
11172: hr_utility.set_location ('hxt_time_detail.gen_special', 30);
11173: END IF;
11174:
11175: IF g_ep_type = 'WEEKLY' AND rule_type_to_pay <> 'HOL'
11176: THEN
11175: IF g_ep_type = 'WEEKLY' AND rule_type_to_pay <> 'HOL'
11176: THEN
11177: IF g_debug
11178: THEN
11179: hr_utility.set_location ('hxt_time_detail.gen_special', 31);
11180: END IF;
11181:
11182: select_weekly_hours (rule_to_pay,
11183: hours_to_pay_this_rule,
11185: );
11186:
11187: IF g_debug
11188: THEN
11189: hr_utility.set_location ('hxt_time_detail.gen_special',
11190: 31.5
11191: );
11192: END IF;
11193:
11194: IF ERROR_CODE > l_error_return
11195: THEN
11196: IF g_debug
11197: THEN
11198: hr_utility.set_location ('hxt_time_detail.gen_special',
11199: 32
11200: );
11201: END IF;
11202:
11209: AND rule_type_to_pay = 'HOL'
11210: THEN
11211: IF g_debug
11212: THEN
11213: hr_utility.set_location ('hxt_time_detail.gen_special',
11214: 32.1
11215: );
11216: END IF;
11217:
11223: IF ERROR_CODE > l_error_return
11224: THEN
11225: IF g_debug
11226: THEN
11227: hr_utility.set_location ('hxt_time_detail.gen_special',
11228: 32.5
11229: );
11230: END IF;
11231:
11236: END IF;
11237: ELSE
11238: IF g_debug
11239: THEN
11240: hr_utility.set_location ('hxt_time_detail.gen_special', 33);
11241: END IF;
11242:
11243: --MHANDA Determine whether the rules to be applied use the
11244: --points counter.
11257: IF l_use_points_assigned = 'N' OR l_use_points_assigned IS NULL
11258: THEN
11259: IF g_debug
11260: THEN
11261: hr_utility.set_location ('hxt_time_detail.gen_special',
11262: 33.1
11263: );
11264: END IF;
11265:
11271: ELSIF l_use_points_assigned = 'Y'
11272: THEN
11273: IF g_debug
11274: THEN
11275: hr_utility.set_location ('hxt_time_detail.gen_special',
11276: 33.2
11277: );
11278: END IF;
11279:
11284: );
11285:
11286: IF g_debug
11287: THEN
11288: hr_utility.set_location ('hxt_time_detail.gen_special',
11289: 33.3
11290: );
11291: END IF;
11292: END IF;
11294: IF ERROR_CODE > l_error_return
11295: THEN
11296: IF g_debug
11297: THEN
11298: hr_utility.set_location ('hxt_time_detail.gen_special',
11299: 34
11300: );
11301: END IF;
11302:
11317: IF g_hours >= 0
11318: THEN
11319: IF g_debug
11320: THEN
11321: hr_utility.set_location ('hxt_time_detail.gen_special',
11322: 35
11323: );
11324: hr_utility.TRACE ( 'hours_to_pay_this_rule :'
11325: || hours_to_pay_this_rule
11349: )
11350: THEN
11351: IF g_debug
11352: THEN
11353: hr_utility.set_location ('hxt_time_detail.gen_special', 36);
11354: hr_utility.TRACE ( 'l_time_in :'
11355: || TO_CHAR (l_time_in, 'HH24:MI')
11356: );
11357: hr_utility.TRACE ( 'l_time_out:'
11428: IF ERROR_CODE <> 0
11429: THEN
11430: IF g_debug
11431: THEN
11432: hr_utility.set_location ('hxt_time_detail.gen_special',
11433: 37
11434: );
11435: END IF;
11436:
11438: THEN
11439: IF g_debug
11440: THEN
11441: hr_utility.set_location
11442: ('hxt_time_detail.gen_special',
11443: 38
11444: );
11445: END IF;
11446:
11455: END IF;
11456:
11457: IF g_debug
11458: THEN
11459: hr_utility.set_location ('hxt_time_detail.gen_special', 39);
11460: hr_utility.TRACE ( 'hours_left_to_pay :'
11461: || TO_CHAR (hours_left_to_pay)
11462: );
11463: END IF;
11481: IF l_use_points_assigned = 'N' OR l_use_points_assigned IS NULL
11482: THEN
11483: IF g_debug
11484: THEN
11485: hr_utility.set_location ('hxt_time_detail.gen_special',
11486: 39.5
11487: );
11488: END IF;
11489:
11492: END IF;
11493:
11494: IF g_debug
11495: THEN
11496: hr_utility.set_location ('hxt_time_detail.gen_special', 40);
11497: hr_utility.TRACE ( 'hours_left_to_pay :'
11498: || TO_CHAR (hours_left_to_pay)
11499: );
11500: END IF;
11511: IF hours_left_to_pay >= 0 AND ERROR_CODE = 0
11512: THEN
11513: IF g_debug
11514: THEN
11515: hr_utility.set_location ('hxt_time_detail.gen_special',
11516: 41
11517: );
11518: END IF;
11519:
11532: THEN
11533: IF g_debug
11534: THEN
11535: hr_utility.set_location
11536: ('hxt_time_detail.gen_special',
11537: 41.5
11538: );
11539: END IF;
11540:
11545: THEN
11546: IF g_debug
11547: THEN
11548: hr_utility.set_location
11549: ('hxt_time_detail.gen_special',
11550: 42
11551: );
11552: END IF;
11553:
11569: THEN
11570: IF g_debug
11571: THEN
11572: hr_utility.set_location
11573: ('hxt_time_detail.gen_special',
11574: 43
11575: );
11576: END IF;
11577:
11583: THEN
11584: IF g_debug
11585: THEN
11586: hr_utility.set_location
11587: ('hxt_time_detail.gen_special',
11588: 44
11589: );
11590: END IF;
11591:
11650: THEN
11651: IF g_debug
11652: THEN
11653: hr_utility.set_location
11654: ('hxt_time_detail.gen_special',
11655: 45
11656: );
11657: END IF;
11658:
11662: ELSIF hours_left_to_pay < 0
11663: THEN
11664: IF g_debug
11665: THEN
11666: hr_utility.set_location ('hxt_time_detail.gen_special',
11667: 46
11668: );
11669: END IF;
11670:
11672: THEN
11673: IF g_debug
11674: THEN
11675: hr_utility.set_location
11676: ('hxt_time_detail.gen_special',
11677: 47
11678: );
11679: END IF;
11680:
11694: THEN
11695: IF g_debug
11696: THEN
11697: hr_utility.set_location
11698: ('hxt_time_detail.gen_special',
11699: 48
11700: );
11701: END IF;
11702:
11708: ELSE
11709: IF g_debug
11710: THEN
11711: hr_utility.set_location
11712: ('hxt_time_detail.gen_special',
11713: 49
11714: );
11715: END IF;
11716:
11718: END IF;
11719:
11720: IF g_debug
11721: THEN
11722: hr_utility.set_location ('hxt_time_detail.gen_special',
11723: 50
11724: );
11725: END IF;
11726: END IF; --hours_left_to_pay > 0 and error_code = 0
11731: IF loop_counter > 50
11732: THEN
11733: IF g_debug
11734: THEN
11735: hr_utility.set_location ('hxt_time_detail.gen_special', 52);
11736: END IF;
11737:
11738: fnd_message.set_name ('HXT', 'HXT_39305_LOOP_LIMIT_EXC');
11739: ERROR_CODE :=
11748: IF ERROR_CODE > l_error_return
11749: THEN
11750: IF g_debug
11751: THEN
11752: hr_utility.set_location ('hxt_time_detail.gen_special',
11753: 53
11754: );
11755: END IF;
11756:
11763: END IF;
11764:
11765: IF g_debug
11766: THEN
11767: hr_utility.set_location ('hxt_time_detail.gen_special', 54);
11768: END IF;
11769: END LOOP; -- While hours_left_to_pay <> 0 AND error_code = 0
11770:
11771: CLOSE daily_earn_rules_cur;
11777: AND ERROR_CODE = 0
11778: THEN
11779: IF g_debug
11780: THEN
11781: hr_utility.set_location ('hxt_time_detail.gen_special', 54.5);
11782: END IF;
11783:
11784: l_day_total := get_daily_total;
11785:
11791: IF l_day_total > 12
11792: THEN
11793: IF g_debug
11794: THEN
11795: hr_utility.set_location ('hxt_time_detail.gen_special', 55);
11796: END IF;
11797:
11798: ERROR_CODE := adjust_for_double_time (l_day_total);
11799:
11800: IF ERROR_CODE = 0
11801: THEN
11802: IF g_debug
11803: THEN
11804: hr_utility.set_location ('hxt_time_detail.gen_special',
11805: 56
11806: );
11807: END IF;
11808:
11810: ELSIF ERROR_CODE = 1
11811: THEN
11812: IF g_debug
11813: THEN
11814: hr_utility.set_location ('hxt_time_detail.gen_special',
11815: 57
11816: );
11817: END IF;
11818:
11828: ELSIF ERROR_CODE = 2
11829: THEN
11830: IF g_debug
11831: THEN
11832: hr_utility.set_location ('hxt_time_detail.gen_special',
11833: 58
11834: );
11835: END IF;
11836:
11846: ELSIF ERROR_CODE = 3
11847: THEN
11848: IF g_debug
11849: THEN
11850: hr_utility.set_location ('hxt_time_detail.gen_special',
11851: 59
11852: );
11853: END IF;
11854:
11864: ELSIF ERROR_CODE = 4
11865: THEN
11866: IF g_debug
11867: THEN
11868: hr_utility.set_location ('hxt_time_detail.gen_special',
11869: 60
11870: );
11871: END IF;
11872:
11882: ELSIF ERROR_CODE = 5
11883: THEN
11884: IF g_debug
11885: THEN
11886: hr_utility.set_location ('hxt_time_detail.gen_special',
11887: 61
11888: );
11889: END IF;
11890:
11902: IF ERROR_CODE > l_error_return
11903: THEN
11904: IF g_debug
11905: THEN
11906: hr_utility.set_location ('hxt_time_detail.gen_special',
11907: 62
11908: );
11909: END IF;
11910:
11915: END IF;
11916:
11917: IF g_debug
11918: THEN
11919: hr_utility.set_location ('hxt_time_detail.gen_special', 63);
11920: END IF;
11921: END IF;
11922:
11923: IF g_debug
11921: END IF;
11922:
11923: IF g_debug
11924: THEN
11925: hr_utility.set_location ('hxt_time_detail.gen_special', 64);
11926: END IF;
11927: END IF;
11928:
11929: IF g_debug
11978: IF ERROR_CODE > l_error_return
11979: THEN
11980: IF g_debug
11981: THEN
11982: hr_utility.set_location ('hxt_time_detail.gen_special', 65);
11983: END IF;
11984:
11985: l_error_return := ERROR_CODE;
11986: hxt_util.DEBUG ('Loc F. Return code is ' || TO_CHAR (l_error_return));
12097: LOCATION VARCHAR2 (120) := g_location || ':DDTL';
12098: BEGIN
12099: IF g_debug
12100: THEN
12101: hr_utility.set_location ('hxt_time_detail.delete_zero_hour_details',
12102: 10
12103: );
12104: END IF;
12105:
12107: LOOP -- through detail rows and delete zero hour rows
12108: IF g_debug
12109: THEN
12110: hr_utility.set_location
12111: ('hxt_time_detail.delete_zero_hour_details',
12112: 20
12113: );
12114: END IF;
12115:
12126: -- for a day. Flat amount Day Premium should be paid only once a day.
12127: IF g_debug
12128: THEN
12129: hr_utility.set_location
12130: ('hxt_time_detail.delete_zero_hour_details',
12131: 30
12132: );
12133: END IF;
12134:
12137: END LOOP;
12138:
12139: IF g_debug
12140: THEN
12141: hr_utility.set_location ('hxt_time_detail.delete_zero_hour_details',
12142: 40
12143: );
12144: END IF;
12145:
12211: l_proc VARCHAR2 (250);
12212: BEGIN
12213: IF g_debug
12214: THEN
12215: l_proc := 'hxt_time_detail.combine_contig_chunks';
12216: hr_utility.set_location (l_proc, 10);
12217: hr_utility.TRACE ('g_id:' || g_id);
12218: END IF;
12219:
12686:
12687: BEGIN
12688: IF g_debug
12689: THEN
12690: l_proc := 'hxt_time_detail.pay';
12691: hr_utility.set_location (l_proc, 10);
12692: hr_utility.TRACE ( 'a_time_in :'
12693: || TO_CHAR (a_time_in, 'DD-MON-YYYY HH24:MI:SS')
12694: );
13270: /* Main Function */
13271: BEGIN
13272: IF g_debug
13273: THEN
13274: l_proc := 'hxt_time_detail.Overtime_Hoursoverride';
13275: hr_utility.set_location (l_proc, 10);
13276: END IF;
13277:
13278: <