eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_ABSENCE dependencies on HR_LOC_WORK_SCHEDULE

Line 948: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

944: l_msg_error := to_char(13);
945: END IF;
946: l_include_event := 'N';
947: -- Calculating actual sickness days through work schedule
948: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
949: ( p_assignment_id, l_days_or_hours, l_include_event,
950: p_prorate_start, p_prorate_end, l_start_time_char,
951: l_end_time_char, l_duration
952: );

Line 1004: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1000: IF ( i.date_start = i.date_end ) THEN
1001: l_loop_empr_days := l_loop_empr_days + 1;
1002: l_duration := 0;
1003: l_include_event := 'N';
1004: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1005: ( p_assignment_id, l_days_or_hours, l_include_event,
1006: i.date_start, i.date_end, l_start_time_char,
1007: l_end_time_char, l_duration
1008: );

Line 1034: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1030: -- If override element exists for the continuous absences then override the work days.
1031: IF l_cont_empr_days IS NULL THEN
1032: l_duration := 0;
1033: l_include_event := 'N';
1034: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1035: ( p_assignment_id, l_days_or_hours, l_include_event,
1036: i.date_start, i.date_end, l_start_time_char,
1037: l_end_time_char, l_duration
1038: );

Line 1068: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1064: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1065:
1066: -- Ignore public holidays if the one present in between absence start and end dates.
1067: l_include_event := 'N';
1068: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1069: ( p_assignment_id, l_days_or_hours, l_include_event,
1070: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1071: l_end_time_char, l_duration
1072: );

Line 1086: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1082: l_gen_ss_st_date := null;
1083:
1084: -- Ignore public holidays if the one present in between absence start and end dates.
1085: l_include_event := 'N';
1086: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1087: ( p_assignment_id, l_days_or_hours, l_include_event,
1088: p_prorate_start, p_prorate_end, l_start_time_char,
1089: l_end_time_char, l_duration
1090: );

Line 1100: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1096: END IF; /
1097:
1098: / pdavidra added code start - Bug no: 5277080/
1099: l_include_event := 'N';
1100: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1101: ( p_assignment_id, l_days_or_hours, l_include_event,
1102: p_prorate_start, p_prorate_end, l_start_time_char,
1103: l_end_time_char, l_duration
1104: );

Line 1147: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1143: / 5277080 start - Calculate the Social Security Start Date /
1144: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1145: loop
1146: l_include_event := 'N';
1147: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1148: ( p_assignment_id, l_days_or_hours, l_include_event,
1149: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1150: l_end_time_char, l_duration
1151: );

Line 1255: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1251: IF ( i.date_start = i.date_end ) THEN
1252: l_loop_empr_days := l_loop_empr_days + 1;
1253: l_duration := 0;
1254: l_include_event := 'N';
1255: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1256: ( p_assignment_id, l_days_or_hours, l_include_event,
1257: i.date_start, i.date_end, l_start_time_char,
1258: l_end_time_char, l_duration
1259: );

Line 1285: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1281: -- If override element exists for the continuous absences then override the work days.
1282: IF l_cont_empr_days IS NULL THEN
1283: l_duration := 0;
1284: l_include_event := 'N';
1285: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1286: ( p_assignment_id, l_days_or_hours, l_include_event,
1287: i.date_start, i.date_end, l_start_time_char,
1288: l_end_time_char, l_duration
1289: );

Line 1316: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1312: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1313: -- Calculating actual days with prorated period
1314: l_duration := 0;
1315: l_include_event := 'N';
1316: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1317: ( p_assignment_id, l_days_or_hours, l_include_event,
1318: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1319: l_end_time_char, l_duration
1320: );

Line 1347: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1343: -- Calculating actual sickness days through work schedule
1344: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1345: -- Ignore public holidays if the one present in between absence start and end dates.
1346: l_include_event := 'N';
1347: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1348: ( p_assignment_id, l_days_or_hours, l_include_event,
1349: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1350: l_end_time_char, l_duration
1351: );

Line 1362: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1358: -- Calculating actual sickness days through work schedule
1359: l_gen_ss_st_date := null;
1360: -- Ignore public holidays if the one present in between absence start and end dates.
1361: l_include_event := 'N';
1362: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1363: ( p_assignment_id, l_days_or_hours, l_include_event,
1364: p_prorate_start, p_prorate_end, l_start_time_char,
1365: l_end_time_char, l_duration
1366: );

Line 1373: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1369: /
1370:
1371: / knelli added code start/
1372: l_include_event := 'N';
1373: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1374: ( p_assignment_id, l_days_or_hours, l_include_event,
1375: p_prorate_start, p_prorate_end, l_start_time_char,
1376: l_end_time_char, l_duration
1377: );

Line 1413: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1409: / 5277080 start - Calculate the Social Security Start Date /
1410: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1411: loop
1412: l_include_event := 'N';
1413: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1414: ( p_assignment_id, l_days_or_hours, l_include_event,
1415: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1416: l_end_time_char, l_duration
1417: );

Line 1521: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1517: IF ( i.date_start = i.date_end ) THEN
1518: l_loop_empr_days := l_loop_empr_days + 1;
1519: l_duration := 0;
1520: l_include_event := 'N';
1521: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1522: ( p_assignment_id, l_days_or_hours, l_include_event,
1523: i.date_start, i.date_end, l_start_time_char,
1524: l_end_time_char, l_duration
1525: );

Line 1554: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1550: -- If override element exists for the continuous absences then override the work days.
1551: IF l_cont_empr_days IS NULL THEN
1552: l_duration := 0;
1553: l_include_event := 'N';
1554: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1555: ( p_assignment_id, l_days_or_hours, l_include_event,
1556: i.date_start, i.date_end, l_start_time_char,
1557: l_end_time_char, l_duration
1558: );

Line 1579: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1575: l_loop_empr_days := nvl(l_loop_empr_days,0) + (i.date_earned - p_abs_start_date)+1;
1576: -- Calculating actual days with prorated period
1577: l_duration := 0;
1578: l_include_event := 'N';
1579: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1580: ( p_assignment_id, l_days_or_hours, l_include_event,
1581: p_abs_start_date, i.date_earned, l_start_time_char,
1582: l_end_time_char, l_duration
1583: );

Line 1591: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1587: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1588: -- Calculating actual days with prorated period
1589: l_duration := 0;
1590: l_include_event := 'N';
1591: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1592: ( p_assignment_id, l_days_or_hours, l_include_event,
1593: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1594: l_end_time_char, l_duration
1595: );

Line 1620: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1616: -- Calculating actual sickness days through work schedule
1617: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1618: -- Ignore public holidays if the one present in between absence start and end dates.
1619: l_include_event := 'N';
1620: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1621: ( p_assignment_id, l_days_or_hours, l_include_event,
1622: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1623: l_end_time_char, l_duration
1624: );

Line 1633: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1629: -- Calculating actual sickness days through work schedule
1630: l_gen_ss_st_date := null;
1631: -- Ignore public holidays if the one present in between absence start and end dates.
1632: l_include_event := 'N';
1633: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1634: ( p_assignment_id, l_days_or_hours, l_include_event,
1635: p_prorate_start, p_prorate_end, l_start_time_char,
1636: l_end_time_char, l_duration
1637: );

Line 1644: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1640: /
1641:
1642: / knelli added code start/
1643: l_include_event := 'N';
1644: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1645: ( p_assignment_id, l_days_or_hours, l_include_event,
1646: p_prorate_start, p_prorate_end, l_start_time_char,
1647: l_end_time_char, l_duration
1648: );

Line 1684: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1680: / 5277080 start - Calculate the Social Security Start Date /
1681: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1682: loop
1683: l_include_event := 'N';
1684: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1685: ( p_assignment_id, l_days_or_hours, l_include_event,
1686: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1687: l_end_time_char, l_duration
1688: );

Line 1789: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1785:
1786: l_loop_empr_days := l_loop_empr_days + 1;
1787: l_duration := 0;
1788: l_include_event := 'N';
1789: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1790: ( p_assignment_id, l_days_or_hours, l_include_event,
1791: i.date_start, i.date_end, l_start_time_char,
1792: l_end_time_char, l_duration
1793: );

Line 1821: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1817: -- If override element exists for the continuous absences then override the work days.
1818: IF l_cont_empr_days IS NULL THEN
1819: l_duration := 0;
1820: l_include_event := 'N';
1821: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1822: ( p_assignment_id, l_days_or_hours, l_include_event,
1823: i.date_start, i.date_end, l_start_time_char,
1824: l_end_time_char, l_duration
1825: );

Line 1846: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1842: l_loop_empr_days := nvl(l_loop_empr_days,0) + (i.date_earned - p_abs_start_date)+1;
1843: -- Calculating actual days with prorated period
1844: l_duration := 0;
1845: l_include_event := 'N';
1846: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1847: ( p_assignment_id, l_days_or_hours, l_include_event,
1848: p_abs_start_date, i.date_earned, l_start_time_char,
1849: l_end_time_char, l_duration
1850: );

Line 1858: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1854: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1855: -- Calculating actual days with prorated period
1856: l_duration := 0;
1857: l_include_event := 'N';
1858: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1859: ( p_assignment_id, l_days_or_hours, l_include_event,
1860: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1861: l_end_time_char, l_duration
1862: );

Line 1871: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1867: END LOOP;
1868:
1869: / knelli added code start /
1870: l_include_event := 'N';
1871: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1872: ( p_assignment_id, l_days_or_hours, l_include_event,
1873: p_prorate_start, p_prorate_end, l_start_time_char,
1874: l_end_time_char, l_duration
1875: );

Line 1901: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1897: -- Calculating actual sickness days through work schedule
1898: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1899: -- Ignore public holidays if the one present in between absence start and end dates.
1900: l_include_event := 'N';
1901: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1902: ( p_assignment_id, l_days_or_hours, l_include_event,
1903: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1904: l_end_time_char, l_duration
1905: );

Line 1914: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1910: -- Calculating actual sickness days through work schedule
1911: l_gen_ss_st_date := null;
1912: -- Ignore public holidays if the one present in between absence start and end dates.
1913: l_include_event := 'N';
1914: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1915: ( p_assignment_id, l_days_or_hours, l_include_event,
1916: p_prorate_start, p_prorate_end, l_start_time_char,
1917: l_end_time_char, l_duration
1918: );

Line 1956: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1952: / 5277080 start - Calculate the Social Security Start Date/
1953: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1954: loop
1955: l_include_event := 'N';
1956: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1957: ( p_assignment_id, l_days_or_hours, l_include_event,
1958: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1959: l_end_time_char, l_duration
1960: );

Line 2090: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2086: -- dakhuran changes for bug 15845713 ends
2087:
2088: -- Ignore public holidays if the one present in between absence start and end dates.
2089: l_include_event := 'N';
2090: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2091: ( p_assignment_id, l_days_or_hours, l_include_event,
2092: p_prorate_start, l_emp_end_date, l_start_time_char,
2093: l_end_time_char, l_duration
2094: );

Line 2279: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2275: of payroll start date to get the last 4 weeks worked days*/
2276: /* condition added by pdavidra for Bug 5330188*/
2277: /*5475038 IF (l_abs_reason = 'Work Accident') AND
2278: ( (p_abs_start_date - p_abs_min_gap) < l_dateofjoin ) THEN
2279: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2280: ( p_assignment_id, l_days_or_hours, l_include_event,
2281: l_dateofjoin, (p_abs_start_date-1), l_start_time_char,
2282: l_end_time_char, l_duration
2283: );

Line 2286: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2282: l_end_time_char, l_duration
2283: );
2284: ELSE
2285: / pdavidra - bug 5330066 - redused the start date parameter by 1/
2286: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2287: ( p_assignment_id, l_days_or_hours, l_include_event,
2288: (p_abs_start_date - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
2289: l_end_time_char, l_duration
2290: );

Line 2292: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2288: (p_abs_start_date - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
2289: l_end_time_char, l_duration
2290: );
2291: END IF; */
2292: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2293: ( p_assignment_id, l_days_or_hours, l_include_event,
2294: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
2295: l_end_time_char, l_duration
2296: );

Line 2665: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2661: l_msg_error := to_char(13);
2662: END IF;
2663: l_include_event := 'N';
2664: -- Calculating actual sickness days through work schedule
2665: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2666: ( p_assignment_id, l_days_or_hours, l_include_event,
2667: p_prorate_start, p_prorate_end, l_start_time_char,
2668: l_end_time_char, l_duration
2669: );

Line 2870: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2866: IF ( i.date_start = i.date_end ) THEN
2867: l_duration := 0;
2868: l_include_event := 'N';
2869:
2870: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2871: ( p_assignment_id, l_days_or_hours, l_include_event,
2872: i.date_start, i.date_end, l_start_time_char,
2873: l_end_time_char, l_duration
2874: );

Line 2902: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2898: IF l_cont_empr_days IS NULL THEN
2899: l_duration := 0;
2900: l_include_event := 'N';
2901:
2902: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2903: ( p_assignment_id, l_days_or_hours, l_include_event,
2904: i.date_start, i.date_end, l_start_time_char,
2905: l_end_time_char, l_duration
2906: );

Line 2919: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2915:
2916: -- Calculation of actual working days present with the current absence.
2917: -- Ignore public holidays if the one present in between absence start and end dates.
2918: l_include_event := 'N';
2919: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2920: ( p_assignment_id, l_days_or_hours, l_include_event,
2921: p_prorate_start, p_prorate_end, l_start_time_char,
2922: l_end_time_char, l_duration
2923: );

Line 3001: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2997: IF ( i.date_start = i.date_end ) THEN
2998: l_duration := 0;
2999: l_include_event := 'N';
3000:
3001: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3002: ( p_assignment_id, l_days_or_hours, l_include_event,
3003: i.date_start, i.date_end, l_start_time_char,
3004: l_end_time_char, l_duration
3005: );

Line 3032: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3028:
3029: l_duration := 0;
3030: l_include_event := 'N';
3031:
3032: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3033: ( p_assignment_id, l_days_or_hours, l_include_event,
3034: i.date_start, i.date_end, l_start_time_char,
3035: l_end_time_char, l_duration
3036: );

Line 3062: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3058: -- Calculating actual days with prorated period
3059: l_duration := 0;
3060: l_include_event := 'N';
3061:
3062: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3063: ( p_assignment_id, l_days_or_hours, l_include_event,
3064: (l_prev_paydate+1), i.date_earned, l_start_time_char,
3065: l_end_time_char, l_duration
3066: );

Line 3077: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3073: -- Calculation of actual working days present with the current absence.
3074: -- Ignore public holidays if the one present in between absence start and end dates.
3075: l_include_event := 'N';
3076:
3077: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3078: ( p_assignment_id, l_days_or_hours, l_include_event,
3079: p_prorate_start, p_prorate_end, l_start_time_char,
3080: l_end_time_char, l_duration
3081: );

Line 3158: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3154: IF ( i.date_start = i.date_end ) THEN
3155: l_duration := 0;
3156: l_include_event := 'N';
3157:
3158: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3159: ( p_assignment_id, l_days_or_hours, l_include_event,
3160: i.date_start, i.date_end, l_start_time_char,
3161: l_end_time_char, l_duration
3162: );

Line 3189: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3185:
3186: l_duration := 0;
3187: l_include_event := 'N';
3188:
3189: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3190: ( p_assignment_id, l_days_or_hours, l_include_event,
3191: i.date_start, i.date_end, l_start_time_char,
3192: l_end_time_char, l_duration
3193: );

Line 3213: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3209: -- Calculating actual days with prorated period
3210: l_duration := 0;
3211: l_include_event := 'N';
3212:
3213: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3214: ( p_assignment_id, l_days_or_hours, l_include_event,
3215: p_abs_start_date, i.date_earned, l_start_time_char,
3216: l_end_time_char, l_duration
3217: );

Line 3226: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3222: l_include_event := 'N';
3223:
3224: / knelli bug 5261106 added check/
3225: IF p_abs_end_date NOT BETWEEN l_prev_paydate+1 AND i.date_earned THEN
3226: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3227: ( p_assignment_id, l_days_or_hours, l_include_event,
3228: (l_prev_paydate+1), i.date_earned, l_start_time_char,
3229: l_end_time_char, l_duration
3230: );

Line 3241: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3237:
3238: -- Calculation of actual working days present with the current absence.
3239: -- Ignore public holidays if the one present in between absence start and end dates.
3240: l_include_event := 'N';
3241: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3242: ( p_assignment_id, l_days_or_hours, l_include_event,
3243: p_prorate_start, p_prorate_end, l_start_time_char,
3244: l_end_time_char, l_duration
3245: );

Line 3323: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3319: IF ( i.date_start = i.date_end ) THEN
3320: l_duration := 0;
3321: l_include_event := 'N';
3322:
3323: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3324: ( p_assignment_id, l_days_or_hours, l_include_event,
3325: i.date_start, i.date_end, l_start_time_char,
3326: l_end_time_char, l_duration
3327: );

Line 3354: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3350:
3351: l_duration := 0;
3352: l_include_event := 'N';
3353:
3354: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3355: ( p_assignment_id, l_days_or_hours, l_include_event,
3356: i.date_start, i.date_end, l_start_time_char,
3357: l_end_time_char, l_duration
3358: );

Line 3379: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3375: -- Calculating actual days with prorated period
3376: l_duration := 0;
3377: l_include_event := 'N';
3378:
3379: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3380: ( p_assignment_id, l_days_or_hours, l_include_event,
3381: p_abs_start_date, i.date_earned, l_start_time_char,
3382: l_end_time_char, l_duration
3383: );

Line 3392: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3388: -- Calculating actual days with prorated period
3389: l_duration := 0;
3390: l_include_event := 'N';
3391:
3392: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3393: ( p_assignment_id, l_days_or_hours, l_include_event,
3394: (l_prev_paydate+1), i.date_earned, l_start_time_char,
3395: l_end_time_char, l_duration
3396: );

Line 3406: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3402: END LOOP;
3403:
3404: / knelli call work schedule /
3405: l_include_event := 'N';
3406: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3407: ( p_assignment_id, l_days_or_hours, l_include_event,
3408: p_prorate_start, p_prorate_end, l_start_time_char,
3409: l_end_time_char, l_duration
3410: );

Line 3488: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3484: -- Calculation of actual working days present with the current absence.
3485: -- Ignore public holidays if the one present in between absence start and end dates.
3486: l_include_event := 'N';
3487:
3488: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3489: ( p_assignment_id, l_days_or_hours, l_include_event,
3490: p_prorate_start, p_prorate_end, l_start_time_char,
3491: l_end_time_char, l_duration
3492: );

Line 3528: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3524: l_empr_days := ( p_abs_child_emp_days_limit - curr_year_cms_emp_days );
3525: l_gen_ss_st_date := p_prorate_start + nvl(l_empr_days,0) ;
3526: LOOP
3527: l_include_event := 'N';
3528: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3529: ( p_assignment_id, l_days_or_hours, l_include_event,
3530: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
3531: l_end_time_char, l_duration );
3532: IF l_duration = (l_empr_days +1) THEN

Line 3674: /* 5475038 l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3670: /* pgopal - Bug 5393827 and 5349713 fix - taking the absence start date instead
3671: of payroll start date to get the last 4 weeks worked days*/
3672:
3673: /* knelli changed date_start parameter, reduced date by 1 */
3674: /* 5475038 l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3675: ( p_assignment_id, l_days_or_hours, l_include_event,
3676: ((p_abs_start_date) - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
3677: l_end_time_char, l_duration
3678: );*/

Line 3679: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3675: ( p_assignment_id, l_days_or_hours, l_include_event,
3676: ((p_abs_start_date) - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
3677: l_end_time_char, l_duration
3678: );*/
3679: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3680: ( p_assignment_id, l_days_or_hours, l_include_event,
3681: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
3682: l_end_time_char, l_duration );
3683: -- Calculating actual number of absence days in the previous 4 weeks (payroll) periods.

Line 4091: for hr_loc_work_schedule.calc_sch_based_dur */

4087:
4088: /* BUG Fix 5346832 : Start
4089: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
4090: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4091: for hr_loc_work_schedule.calc_sch_based_dur */
4092:
4093: /*
4094: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4095: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 4094: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4090: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4091: for hr_loc_work_schedule.calc_sch_based_dur */
4092:
4093: /*
4094: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4095: ( p_assignment_id, l_days_or_hours, l_include_event,
4096: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4097: l_end_time_char, l_duration
4098: );

Line 4100: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4096: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4097: l_end_time_char, l_duration
4098: );
4099: */
4100: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4101: ( p_assignment_id, l_days_or_hours, l_include_event,
4102: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
4103: l_end_time_char, l_duration
4104: );

Line 4179: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4175:
4176:
4177: l_include_event := 'N';
4178: -- Calculating actual sickness days through work schedule
4179: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4180: ( p_assignment_id, l_days_or_hours, l_include_event,
4181: p_prorate_start, p_prorate_end, l_start_time_char,
4182: l_end_time_char, l_duration
4183: );

Line 4557: for hr_loc_work_schedule.calc_sch_based_dur */

4553:
4554: /* BUG Fix 5346832 : Start
4555: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
4556: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4557: for hr_loc_work_schedule.calc_sch_based_dur */
4558:
4559: /*
4560: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4561: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 4560: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4556: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4557: for hr_loc_work_schedule.calc_sch_based_dur */
4558:
4559: /*
4560: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4561: ( p_assignment_id, l_days_or_hours, l_include_event,
4562: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4563: l_end_time_char, l_duration
4564: );

Line 4566: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4562: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4563: l_end_time_char, l_duration
4564: );
4565: */
4566: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4567: ( p_assignment_id, l_days_or_hours, l_include_event,
4568: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
4569: l_end_time_char, l_duration
4570: );

Line 4651: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4647:
4648:
4649: l_include_event := 'N';
4650: -- Calculating actual sickness days through work schedule
4651: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4652: ( p_assignment_id, l_days_or_hours, l_include_event,
4653: p_prorate_start, p_prorate_end, l_start_time_char,
4654: l_end_time_char, l_duration
4655: );

Line 5022: for hr_loc_work_schedule.calc_sch_based_dur */

5018:
5019: /* BUG Fix 5346832 : Start
5020: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
5021: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5022: for hr_loc_work_schedule.calc_sch_based_dur */
5023:
5024: /*
5025: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5026: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 5025: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5021: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5022: for hr_loc_work_schedule.calc_sch_based_dur */
5023:
5024: /*
5025: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5026: ( p_assignment_id, l_days_or_hours, l_include_event,
5027: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
5028: l_end_time_char, l_duration
5029: );

Line 5032: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5028: l_end_time_char, l_duration
5029: );
5030: */
5031:
5032: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5033: ( p_assignment_id, l_days_or_hours, l_include_event,
5034: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
5035: l_end_time_char, l_duration
5036: );

Line 5112: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5108:
5109:
5110: l_include_event := 'N';
5111: -- Calculating actual sickness days through work schedule
5112: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5113: ( p_assignment_id, l_days_or_hours, l_include_event,
5114: p_prorate_start, p_prorate_end, l_start_time_char,
5115: l_end_time_char, l_duration
5116: );

Line 5493: for hr_loc_work_schedule.calc_sch_based_dur */

5489:
5490: /* BUG Fix 5346832 : Start
5491: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
5492: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5493: for hr_loc_work_schedule.calc_sch_based_dur */
5494:
5495: /*
5496: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5497: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 5496: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5492: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5493: for hr_loc_work_schedule.calc_sch_based_dur */
5494:
5495: /*
5496: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5497: ( p_assignment_id, l_days_or_hours, l_include_event,
5498: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
5499: l_end_time_char, l_duration
5500: );

Line 5503: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5499: l_end_time_char, l_duration
5500: );
5501: */
5502:
5503: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5504: ( p_assignment_id, l_days_or_hours, l_include_event,
5505: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
5506: l_end_time_char, l_duration
5507: );

Line 5587: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5583:
5584:
5585: l_include_event := 'N';
5586: -- Calculating actual sickness days through work schedule
5587: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5588: ( p_assignment_id, l_days_or_hours, l_include_event,
5589: p_prorate_start, p_prorate_end, l_start_time_char,
5590: l_end_time_char, l_duration
5591: );

Line 6011: for hr_loc_work_schedule.calc_sch_based_dur */

6007:
6008: /* BUG Fix 5346832 : Start
6009: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
6010: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6011: for hr_loc_work_schedule.calc_sch_based_dur */
6012:
6013: /*
6014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6015: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 6014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6010: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6011: for hr_loc_work_schedule.calc_sch_based_dur */
6012:
6013: /*
6014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6015: ( p_assignment_id, l_days_or_hours, l_include_event,
6016: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
6017: l_end_time_char, l_duration
6018: );

Line 6021: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6017: l_end_time_char, l_duration
6018: );
6019: */
6020:
6021: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6022: ( p_assignment_id, l_days_or_hours, l_include_event,
6023: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
6024: l_end_time_char, l_duration
6025: );

Line 6103: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6099: p_ss_daily_rate := p_adopt_rate;
6100:
6101: l_include_event := 'N';
6102: -- Calculating actual sickness days through work schedule
6103: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6104: ( p_assignment_id, l_days_or_hours, l_include_event,
6105: p_prorate_start, p_prorate_end, l_start_time_char,
6106: l_end_time_char, l_duration
6107: );

Line 6545: for hr_loc_work_schedule.calc_sch_based_dur */

6541:
6542: /* BUG Fix 5346832 : Start
6543: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
6544: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6545: for hr_loc_work_schedule.calc_sch_based_dur */
6546:
6547: /*
6548: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6549: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 6548: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6544: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6545: for hr_loc_work_schedule.calc_sch_based_dur */
6546:
6547: /*
6548: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6549: ( p_assignment_id, l_days_or_hours, l_include_event,
6550: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
6551: l_end_time_char, l_duration
6552: );

Line 6555: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6551: l_end_time_char, l_duration
6552: );
6553: */
6554:
6555: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6556: ( p_assignment_id, l_days_or_hours, l_include_event,
6557: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
6558: l_end_time_char, l_duration
6559: );

Line 6636: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6632: p_ss_daily_rate := p_adopt_rate;
6633:
6634: l_include_event := 'N';
6635: -- Calculating actual sickness days through work schedule
6636: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6637: ( p_assignment_id, l_days_or_hours, l_include_event,
6638: p_prorate_start, p_prorate_end, l_start_time_char,
6639: l_end_time_char, l_duration
6640: );