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_SE_ABSENCE dependencies on HR_LOC_WORK_SCHEDULE

Line 1143: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1139:
1140: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1141:
1142: --sickness pay hours calculation
1143: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1144: ( p_assignment_id, l_hours, l_include_event,
1145: greatest(p_pay_start_date,l_waiting_date+1), c_abs.date_end, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1146: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1147: l_end_time_char)),':','.'), l_wrk_duration

Line 1158: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1154: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1155: l_override_sickness_pay_hours:=-1;
1156: END IF;
1157: /* Calculating the Sick Pay days less than 14 days*/
1158: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1159: ( p_assignment_id, l_days, l_include_event,
1160: greatest(p_pay_start_date,l_waiting_date+1), c_abs.date_end, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1161: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1162: l_end_time_char)),':','.'), l_wrk_duration

Line 1186: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1182: --check whether the end period for 14 days fall within payroll period
1183: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
1184:
1185: --sickness pay hours calculation
1186: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1187: ( p_assignment_id, l_hours, l_include_event,
1188: greatest(p_pay_start_date,l_waiting_date+1), (c_abs.date_start + 14-(l_sickness_days)+1),
1189: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1190: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1202: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1198: l_override_sickness_pay_hours:=-1;
1199: END IF;
1200:
1201: /* Calculating the Sick Pay days less than 14 days*/
1202: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1203: ( p_assignment_id, l_days, l_include_event,
1204: greatest(p_pay_start_date,l_waiting_date+1), (c_abs.date_start + 14-(l_sickness_days)+1),
1205: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1206: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1218: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1214:
1215: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1216: --sickness pay hours calculation
1217:
1218: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1219: ( p_assignment_id, l_hours, l_include_event,
1220: greatest((c_abs.date_start + 14-l_sickness_days+1),p_pay_start_date) ,
1221: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1222: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1249: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1245:
1246: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1247:
1248: --sickness pay hours calculation
1249: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1250: ( p_assignment_id, l_hours, l_include_event,
1251: greatest(p_pay_start_date,l_waiting_date+1), c_abs.date_start,
1252: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1253: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1274: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1270: CLOSE csr_check_override;
1271:
1272: IF l_override_waiting_hours =-1 OR l_override_waiting_hours IS NULL THEN
1273: IF (l_waiting_date<>c_abs.date_end) THEN
1274: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1275: ( p_assignment_id, l_hours, l_include_event,
1276: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1277: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1278: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1281: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1277: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1278: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
1279: );
1280: ELSE
1281: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1282: ( p_assignment_id, l_hours, l_include_event,
1283: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1284: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1285: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 1317: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1313:
1314: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1315:
1316: --sickness pay hours calculation
1317: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1318: ( p_assignment_id, l_hours, l_include_event,
1319: greatest(p_pay_start_date,c_abs.date_start), c_abs.date_end, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1320: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1321: l_end_time_char)),':','.'), l_wrk_duration

Line 1332: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1328: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1329: l_override_sickness_pay_hours:=-1;
1330: END IF;
1331: /* Calculating the Sick Pay days less than 14 days*/
1332: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1333: ( p_assignment_id, l_days, l_include_event,
1334: greatest(p_pay_start_date,c_abs.date_start), c_abs.date_end, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1335: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1336: l_end_time_char)),':','.'), l_wrk_duration

Line 1359: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1355: --check whether the end period for 14 days fall within payroll period
1356: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
1357:
1358: --sickness pay hours calculation
1359: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1360: ( p_assignment_id, l_hours, l_include_event,
1361: greatest(p_pay_start_date,c_abs.date_start), (c_abs.date_start + 14-(l_sickness_days+1)),
1362: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1363: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_duration

Line 1373: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1369: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1370: l_override_sickness_pay_hours:=-1;
1371: END IF;
1372: /* Calculating the Sick Pay days less than 14 days*/
1373: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1374: ( p_assignment_id, l_days, l_include_event,
1375: greatest(p_pay_start_date,c_abs.date_start), (c_abs.date_start + 14-(l_sickness_days+1)),
1376: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1377: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_duration

Line 1388: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1384:
1385: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1386: --sickness pay hours calculation
1387:
1388: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1389: ( p_assignment_id, l_hours, l_include_event,
1390: greatest((c_abs.date_start + 14-l_sickness_days+1),p_pay_start_date) ,
1391: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1392: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1419: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1415:
1416: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1417:
1418: --sickness pay hours calculation
1419: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1420: ( p_assignment_id, l_hours, l_include_event,
1421: greatest(p_pay_start_date,c_abs.date_start), c_abs.date_start,
1422: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1423: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1463: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1459:
1460: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1461:
1462: --sickness pay hours calculation
1463: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1464: ( p_assignment_id, l_hours, l_include_event,
1465: greatest(p_pay_start_date,l_waiting_date+1), p_pay_end_date, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1466: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1467: l_end_time_char)),':','.'), l_wrk_duration

Line 1477: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1473: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1474: l_override_sickness_pay_hours:=-1;
1475: END IF;
1476: /* Calculating the Sick Pay days less than 14 days*/
1477: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1478: ( p_assignment_id, l_days, l_include_event,
1479: greatest(p_pay_start_date,l_waiting_date+1), p_pay_end_date, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1480: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1481: l_end_time_char)),':','.'), l_wrk_duration

Line 1506: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1502: --check whether the end period for 14 days fall within payroll period
1503: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
1504:
1505: --sickness pay hours calculation
1506: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1507: ( p_assignment_id, l_hours, l_include_event,
1508: greatest(p_pay_start_date,l_waiting_date+1), (c_abs.date_start + 14-(l_sickness_days+1+(c_abs.date_end-p_pay_end_date))),
1509: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1510: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1520: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1516: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1517: l_override_sickness_pay_hours:=-1;
1518: END IF;
1519: /* Calculating the Sick Pay days less than 14 days*/
1520: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1521: ( p_assignment_id, l_days, l_include_event,
1522: greatest(p_pay_start_date,l_waiting_date+1), (c_abs.date_start + 14-(l_sickness_days+1+(c_abs.date_end-p_pay_end_date))),
1523: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1524: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1535: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1531:
1532: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1533:
1534: --sickness pay hours calculation
1535: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1536: ( p_assignment_id, l_hours, l_include_event,
1537: greatest((l_waiting_date + 14-(l_sickness_days)),p_pay_start_date) ,
1538: p_pay_end_date,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1539: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1566: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1562:
1563: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1564:
1565: --sickness pay hours calculation
1566: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1567: ( p_assignment_id, l_hours, l_include_event,
1568: greatest(p_pay_start_date,l_waiting_date+1), p_pay_end_date,
1569: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1570: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1591: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1587: CLOSE csr_check_override;
1588:
1589: IF l_override_waiting_hours =-1 OR l_override_waiting_hours IS NULL THEN
1590: IF (l_waiting_date<>c_abs.date_end) THEN
1591: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1592: ( p_assignment_id, l_hours, l_include_event,
1593: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1594: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1595: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_duration

Line 1598: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1594: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1595: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_duration
1596: );
1597: ELSE
1598: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1599: ( p_assignment_id, l_hours, l_include_event,
1600: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1601: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1602: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 1633: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1629: CLOSE csr_check_override;
1630:
1631: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1632: --sickness pay hours calculation
1633: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1634: ( p_assignment_id, l_hours, l_include_event,
1635: greatest(p_pay_start_date,c_abs.date_start), p_pay_end_date, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1636: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1637: l_end_time_char)),':','.'), l_wrk_duration

Line 1647: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1643: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1644: l_override_sickness_pay_hours:=-1;
1645: END IF;
1646: /* Calculating the Sick Pay days less than 14 days*/
1647: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1648: ( p_assignment_id, l_days, l_include_event,
1649: greatest(p_pay_start_date,c_abs.date_start), p_pay_end_date, replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1650: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
1651: l_end_time_char)),':','.'), l_wrk_duration

Line 1672: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1668: --check whether the end period for 14 days fall within payroll period
1669: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
1670:
1671: --sickness pay hours calculation
1672: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1673: ( p_assignment_id, l_hours, l_include_event,
1674: greatest(p_pay_start_date,c_abs.date_start), (c_abs.date_start + 14-(l_sickness_days+1)),
1675: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1676: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1686: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1682: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1683: l_override_sickness_pay_hours:=-1;
1684: END IF;
1685: /* Calculating the Sick Pay days less than 14 days*/
1686: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1687: ( p_assignment_id, l_days, l_include_event,
1688: greatest(p_pay_start_date,c_abs.date_start), (c_abs.date_start + 14-(l_sickness_days+1)),
1689: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1690: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1702: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1698:
1699: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1700:
1701: --sickness pay hours calculation
1702: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1703: ( p_assignment_id, l_hours, l_include_event,
1704: greatest((c_abs.date_start + 14-l_sickness_days+1),p_pay_start_date) ,
1705: p_pay_end_date,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1706: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1733: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1729:
1730: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1731:
1732: --sickness pay hours calculation
1733: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1734: ( p_assignment_id, l_hours, l_include_event,
1735: greatest(p_pay_start_date,c_abs.date_start), p_pay_end_date,
1736: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1737: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1781: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1777: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1778: IF l_waiting_date 1779: --sickness pay hours calculation
1780:
1781: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1782: ( p_assignment_id, l_hours, l_include_event,
1783: (l_waiting_date+1),p_pay_end_date, replace(nvl(l_normal_time_start,
1784: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,
1785: l_end_time_char),':','.'), l_wrk_duration

Line 1796: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1792: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1793: l_override_sickness_pay_hours:=-1;
1794: END IF;
1795: /* Calculating the Sick Pay days less than 14 days*/
1796: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1797: ( p_assignment_id, l_days, l_include_event,
1798: (l_waiting_date+1),p_pay_end_date, replace(nvl(l_normal_time_start,
1799: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,
1800: l_end_time_char),':','.'), l_wrk_duration

Line 1824: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1820:
1821: --check whether the end period for 14 days fall within payroll period
1822: /*IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date then*/
1823: --sickness pay hours calculation
1824: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1825: ( p_assignment_id, l_hours, l_include_event,
1826: l_waiting_date+1, least((l_waiting_date + 14-(l_sickness_days+1)),p_pay_end_date),
1827: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1828: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1839: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1835: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1836: l_override_sickness_pay_hours:=-1;
1837: END IF;
1838: /* Calculating the Sick Pay days less than 14 days*/
1839: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1840: ( p_assignment_id, l_days, l_include_event,
1841: l_waiting_date+1, least((l_waiting_date + 14-(l_sickness_days+1)),p_pay_end_date),
1842: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1843: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1855: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1851: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1852: IF (l_waiting_date + 14-l_sickness_days+1)<=p_pay_end_date THEN
1853:
1854: --sickness pay hours calculation
1855: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1856: ( p_assignment_id, l_hours, l_include_event,
1857: (l_waiting_date + 14-l_sickness_days+1),
1858: p_pay_end_date,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1859: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1889: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1885: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
1886: IF l_waiting_date < p_pay_end_date THEN
1887:
1888: --sickness pay hours calculation
1889: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1890: ( p_assignment_id, l_hours, l_include_event,
1891: least(p_pay_start_date,l_waiting_date+1), p_pay_end_date,
1892: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
1893: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 1914: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1910:
1911: IF (l_override_waiting_hours =-1 OR l_override_waiting_hours IS NULL ) AND (l_waiting_date<=p_pay_end_date) THEN
1912:
1913: if (l_waiting_date<>c_abs.date_end) then
1914: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1915: ( p_assignment_id, l_hours, l_include_event,
1916: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1917: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1918: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 1921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1917: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1918: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
1919: );
1920: ELSE
1921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1922: ( p_assignment_id, l_hours, l_include_event,
1923: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
1924: nvl(l_normal_time_start,l_start_time_char)),':','.'),
1925: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 1954: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1950: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
1951: IF l_waiting_date 1952: --sickness pay hours calculation
1953:
1954: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1955: ( p_assignment_id, l_hours, l_include_event,
1956: (c_abs.date_start),p_pay_end_date, replace(nvl(l_normal_time_start,
1957: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,
1958: l_end_time_char),':','.'), l_wrk_duration

Line 1969: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1965: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
1966: l_override_sickness_pay_hours:=-1;
1967: END IF;
1968: /* Calculating the Sick Pay days less than 14 days*/
1969: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1970: ( p_assignment_id, l_days, l_include_event,
1971: (c_abs.date_start),p_pay_end_date, replace(nvl(l_normal_time_start,
1972: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,
1973: l_end_time_char),':','.'), l_wrk_duration

Line 1994: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1990:
1991: --check whether the end period for 14 days fall within payroll period
1992: /*IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date then*/
1993: --sickness pay hours calculation
1994: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1995: ( p_assignment_id, l_hours, l_include_event,
1996: c_abs.date_start, least((c_abs.date_start + 14-(l_sickness_days+1)),p_pay_end_date),
1997: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
1998: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2009: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2005: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2006: l_override_sickness_pay_hours:=-1;
2007: END IF;
2008: /* Calculating the Sick Pay days less than 14 days*/
2009: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2010: ( p_assignment_id, l_days, l_include_event,
2011: c_abs.date_start, least((c_abs.date_start + 14-(l_sickness_days+1)),p_pay_end_date),
2012: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2013: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2025: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2021: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2022: IF (l_waiting_date + 14-l_sickness_days+1)<=p_pay_end_date THEN
2023:
2024: --sickness pay hours calculation
2025: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2026: ( p_assignment_id, l_hours, l_include_event,
2027: (c_abs.date_start + 14-l_sickness_days+1),
2028: p_pay_end_date,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2029: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2059: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2055: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2056: IF l_waiting_date < p_pay_end_date THEN
2057:
2058: --sickness pay hours calculation
2059: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2060: ( p_assignment_id, l_hours, l_include_event,
2061: least(p_pay_start_date,c_abs.date_start), p_pay_end_date,
2062: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2063: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2105: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2101: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2102: /*IF l_waiting_day 2103: --sickness pay hours calculation
2104:
2105: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2106: ( p_assignment_id, l_hours, l_include_event,
2107: (l_waiting_date+1),c_abs.date_end, replace(nvl(l_normal_time_start,
2108: l_start_time_char),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2109: l_end_time_char)),':','.'), l_wrk_duration

Line 2120: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2116: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2117: l_override_sickness_pay_hours:=-1;
2118: END IF;
2119: /* Calculating the Sick Pay days less than 14 days*/
2120: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2121: ( p_assignment_id, l_days, l_include_event,
2122: (l_waiting_date+1),c_abs.date_end, replace(nvl(l_normal_time_start,
2123: l_start_time_char),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2124: l_end_time_char)),':','.'), l_wrk_duration

Line 2147: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2143:
2144: --check whether the end period for 14 days fall within payroll period
2145: /*IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date then*/
2146: --sickness pay hours calculation
2147: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2148: ( p_assignment_id, l_hours, l_include_event,
2149: l_waiting_date+1, least(l_fourteenth_date/*(l_waiting_date + 14-(l_sickness_days+1))*/,p_pay_end_date),
2150: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2151: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2162: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2158: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2159: l_override_sickness_pay_hours:=-1;
2160: END IF;
2161: /* Calculating the Sick Pay days less than 14 days*/
2162: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2163: ( p_assignment_id, l_days, l_include_event,
2164: l_waiting_date+1, least(l_fourteenth_date/*(l_waiting_date + 14-(l_sickness_days+1))*/,p_pay_end_date),
2165: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2166: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2178: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2174: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2175:
2176: /*IF (l_waiting_day + 14-l_sickness_days+1)<=p_pay_end_date THEN */
2177: --sickness pay hours calculation
2178: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2179: ( p_assignment_id, l_hours, l_include_event,
2180: (l_fourteenth_date+1/*l_waiting_date + 14-l_sickness_days+1*/),
2181: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2182: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2210: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2206: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2207: IF l_waiting_date < p_pay_end_date THEN
2208:
2209: --sickness pay hours calculation
2210: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2211: ( p_assignment_id, l_hours, l_include_event,
2212: (l_waiting_date+1), c_abs.date_end,
2213: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2214: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2234: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2230: CLOSE csr_check_override;
2231:
2232: IF (l_override_waiting_hours =-1 OR l_override_waiting_hours IS NULL) AND (l_waiting_date<=p_pay_end_date) THEN
2233: IF (l_waiting_date<>c_abs.date_end) THEN
2234: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2235: ( p_assignment_id, l_hours, l_include_event,
2236: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
2237: nvl(l_normal_time_start,l_start_time_char)),':','.'),
2238: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2242: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2238: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
2239: );
2240: ELSE
2241:
2242: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2243: ( p_assignment_id, l_hours, l_include_event,
2244: l_waiting_date, l_waiting_date, replace(nvl(c_abs.time_start,
2245: nvl(l_normal_time_start,l_start_time_char)),':','.'),
2246: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 2277: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2273: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2274: /*IF l_waiting_day 2275: --sickness pay hours calculation
2276:
2277: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2278: ( p_assignment_id, l_hours, l_include_event,
2279: (c_abs.date_start),c_abs.date_end, replace(nvl(l_normal_time_start,
2280: l_start_time_char),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2281: l_end_time_char)),':','.'), l_wrk_duration

Line 2292: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2288: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2289: l_override_sickness_pay_hours:=-1;
2290: END IF;
2291: /* Calculating the Sick Pay days less than 14 days*/
2292: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2293: ( p_assignment_id, l_days, l_include_event,
2294: (c_abs.date_start),c_abs.date_end, replace(nvl(l_normal_time_start,
2295: l_start_time_char),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2296: l_end_time_char)),':','.'), l_wrk_duration

Line 2317: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2313:
2314: --check whether the end period for 14 days fall within payroll period
2315: /*IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date then*/
2316: --sickness pay hours calculation
2317: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2318: ( p_assignment_id, l_hours, l_include_event,
2319: c_abs.date_start, least(l_fourteenth_date/*(c_abs.date_start + 14-(l_sickness_days+2))*/,p_pay_end_date),
2320: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2321: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2332: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2328: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2329: l_override_sickness_pay_hours:=-1;
2330: END IF;
2331: /* Calculating the Sick Pay days less than 14 days*/
2332: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2333: ( p_assignment_id, l_days, l_include_event,
2334: c_abs.date_start, least(l_fourteenth_date/*(c_abs.date_start + 14-(l_sickness_days+2))*/,p_pay_end_date),
2335: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2336: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2348: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2344: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2345:
2346: /*IF (l_waiting_day + 14-l_sickness_days+1)<=p_pay_end_date THEN */
2347: --sickness pay hours calculation
2348: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2349: ( p_assignment_id, l_hours, l_include_event,
2350: (l_fourteenth_date/*c_abs.date_start + 14-l_sickness_days+2*/),
2351: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2352: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2380: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2376: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2377: IF l_waiting_date < p_pay_end_date THEN
2378:
2379: --sickness pay hours calculation
2380: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2381: ( p_assignment_id, l_hours, l_include_event,
2382: (c_abs.date_start), c_abs.date_end,
2383: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2384: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2457: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2453: CLOSE csr_check_override;
2454:
2455: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2456: --sickness pay hours calculation
2457: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2458: ( p_assignment_id, l_hours, l_include_event,
2459: p_pay_start_date, c_abs.date_end, l_start_time_char,
2460: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2461: l_end_time_char)),':','.'), l_wrk_duration

Line 2469: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2465: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2466: l_override_sickness_pay_hours:=-1;
2467: END IF;
2468: /* Calculating the Sick Pay days less than 14 days*/
2469: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2470: ( p_assignment_id, l_days, l_include_event,
2471: p_pay_start_date, c_abs.date_end, l_start_time_char,
2472: replace(nvl(c_abs.time_end,nvl(l_normal_time_end,
2473: l_end_time_char)),':','.'), l_wrk_duration

Line 2495: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2491: --check whether the end period for 14 days fall within payroll period
2492: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
2493:
2494: --sickness pay hours calculation
2495: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2496: ( p_assignment_id, l_hours, l_include_event,
2497: p_pay_start_date, (c_abs.date_start + 14-l_sickness_days),
2498: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2499: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2508: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2504: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2505: l_override_sickness_pay_hours:=-1;
2506: END IF;
2507: /* Calculating the Sick Pay days less than 14 days*/
2508: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2509: ( p_assignment_id, l_days, l_include_event,
2510: p_pay_start_date, (c_abs.date_start + 14-l_sickness_days),
2511: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2512: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2523: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2519:
2520: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2521:
2522: --sickness pay hours calculation
2523: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2524: ( p_assignment_id, l_hours, l_include_event,
2525: greatest((c_abs.date_start + 14-l_sickness_days+1),p_pay_start_date) ,
2526: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2527: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2553: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2549:
2550: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2551:
2552: --sickness pay hours calculation
2553: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2554: ( p_assignment_id, l_hours, l_include_event,
2555: p_pay_start_date, c_abs.date_start,
2556: replace(nvl(l_normal_time_start,l_start_time_char),':','.'), replace(nvl(c_abs.time_end,
2557: nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2593: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2589:
2590: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2591:
2592: --sickness pay hours calculation
2593: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2594: ( p_assignment_id, l_hours, l_include_event,
2595: p_pay_start_date, p_pay_end_date, replace(nvl(l_normal_time_end,
2596: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
2597: );

Line 2604: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2600: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2601: l_override_sickness_pay_hours:=-1;
2602: END IF;
2603: /* Calculating the Sick Pay days less than 14 days*/
2604: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2605: ( p_assignment_id, l_days, l_include_event,
2606: p_pay_start_date, p_pay_end_date, replace(nvl(l_normal_time_end,
2607: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
2608: );

Line 2629: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2625: --check whether the end period for 14 days fall within payroll period
2626: IF (c_abs.date_start + 14-l_sickness_days) > p_pay_start_date THEN
2627:
2628: --sickness pay hours calculation
2629: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2630: ( p_assignment_id, l_hours, l_include_event,
2631: p_pay_start_date, (c_abs.date_start + 14-l_sickness_days),
2632: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2633: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2642: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2638: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2639: l_override_sickness_pay_hours:=-1;
2640: END IF;
2641: /* Calculating the Sick Pay days less than 14 days*/
2642: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2643: ( p_assignment_id, l_days, l_include_event,
2644: p_pay_start_date, (c_abs.date_start + 14-l_sickness_days),
2645: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2646: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2657: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2653:
2654: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2655:
2656: --sickness pay hours calculation
2657: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2658: ( p_assignment_id, l_hours, l_include_event,
2659: greatest((c_abs.date_start + 14-l_sickness_days+1),p_pay_start_date) ,
2660: c_abs.date_end,replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2661: replace(nvl(l_normal_time_end, l_end_time_char),':','.'), l_wrk_duration

Line 2687: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2683:
2684: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2685:
2686: --sickness pay hours calculation
2687: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2688: ( p_assignment_id, l_hours, l_include_event,
2689: p_pay_start_date, p_pay_end_date,
2690: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2691: replace(nvl(l_normal_time_end, l_end_time_char),':','.'), l_wrk_duration

Line 2728: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2724:
2725: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2726:
2727: --sickness pay hours calculation
2728: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2729: ( p_assignment_id, l_hours, l_include_event,
2730: c_abs.date_start, p_pay_end_date, replace(nvl(l_normal_time_end,
2731: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
2732: );

Line 2739: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2735: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2736: l_override_sickness_pay_hours:=-1;
2737: END IF;
2738: /* Calculating the Sick Pay days less than 14 days*/
2739: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2740: ( p_assignment_id, l_days, l_include_event,
2741: c_abs.date_start, p_pay_end_date, replace(nvl(l_normal_time_end,
2742: l_start_time_char),':','.'),replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration
2743: );

Line 2763: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2759:
2760: --check whether the end period for 14 days fall within payroll period
2761: /*IF (c_abs.date_start + 14-l_sickness_days) < p_pay_end_date then*/
2762: --sickness pay hours calculation
2763: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2764: ( p_assignment_id, l_hours, l_include_event,
2765: c_abs.date_start, least((c_abs.date_start + 14-l_sickness_days),
2766: p_pay_end_date),replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2767: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2776: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2772: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2773: l_override_sickness_pay_hours:=-1;
2774: END IF;
2775: /* Calculating the Sick Pay days less than 14 days*/
2776: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2777: ( p_assignment_id, l_days, l_include_event,
2778: c_abs.date_start, least((c_abs.date_start + 14-l_sickness_days),
2779: p_pay_end_date),replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2780: replace(nvl(l_normal_time_end,l_end_time_char),':','.'), l_wrk_duration

Line 2792: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2788: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2789:
2790: IF (c_abs.date_start + 14-l_sickness_days+1) < p_pay_end_date THEN
2791: --sickness pay hours calculation
2792: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2793: ( p_assignment_id, l_hours, l_include_event,
2794: c_abs.date_start + 14-l_sickness_days+1 ,
2795: p_pay_end_date,replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2796: replace(nvl(l_normal_time_end, l_end_time_char),':','.'), l_wrk_duration

Line 2823: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2819:
2820: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2821:
2822: --sickness pay hours calculation
2823: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2824: ( p_assignment_id, l_hours, l_include_event,
2825: c_abs.date_start, p_pay_end_date,
2826: replace(nvl(l_normal_time_start,l_start_time_char),':','.'),
2827: replace(nvl(l_normal_time_end, l_end_time_char),':','.'), l_wrk_duration

Line 2863: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2859:
2860: IF l_override_sickness_pay_hours = -1 OR l_override_sickness_pay_hours IS NULL THEN
2861:
2862: --sickness pay hours calculation
2863: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2864: ( p_assignment_id, l_hours, l_include_event,
2865: c_abs.date_start, c_abs.date_end, replace(nvl(c_abs.time_start,nvl(l_normal_time_end,
2866: l_start_time_char)),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration
2867: );

Line 2874: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2870: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2871: l_override_sickness_pay_hours:=-1;
2872: END IF;
2873: /* Calculating the Sick Pay days less than 14 days*/
2874: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2875: ( p_assignment_id, l_days, l_include_event,
2876: c_abs.date_start, c_abs.date_end, replace(nvl(c_abs.time_start,nvl(l_normal_time_end,
2877: l_start_time_char)),':','.'),replace(nvl(c_abs.time_end,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration
2878: );

Line 2898: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2894:
2895: --check whether the end period for 14 days fall within payroll period
2896: /*IF (c_abs.date_start + 14-l_sickness_days) < p_pay_end_date then*/
2897: --sickness pay hours calculation
2898: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2899: ( p_assignment_id, l_hours, l_include_event,
2900: c_abs.date_start, (c_abs.date_start + 14-l_sickness_days),
2901: replace(nvl(c_abs.time_start,nvl(l_normal_time_start,l_start_time_char)),':','.'),
2902: replace(nvl(c_abs.time_start,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 2911: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2907: l_sickness_pay_hours_14_below:=l_sickness_pay_hours_14_below+l_override_sickness_pay_hours;
2908: l_override_sickness_pay_hours:=-1;
2909: END IF;
2910: /* Calculating the Sick Pay days less than 14 days*/
2911: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2912: ( p_assignment_id, l_days, l_include_event,
2913: c_abs.date_start, (c_abs.date_start + 14-l_sickness_days),
2914: replace(nvl(c_abs.time_start,nvl(l_normal_time_start,l_start_time_char)),':','.'),
2915: replace(nvl(c_abs.time_start,nvl(l_normal_time_end,l_end_time_char)),':','.'), l_wrk_duration

Line 2927: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2923: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2924:
2925: /*IF (c_abs.date_start + 14-l_sickness_days+1) < p_pay_end_date THEN */
2926: --sickness pay hours calculation
2927: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2928: ( p_assignment_id, l_hours, l_include_event,
2929: c_abs.date_start + 14-l_sickness_days+1 ,c_abs.date_end,
2930: replace(nvl(c_abs.time_start,nvl(l_normal_time_start,l_start_time_char)),':','.'),
2931: replace(nvl(c_abs.time_end,nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 2957: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2953: CLOSE csr_check_override;
2954:
2955: IF l_override_sickness_days = -1 OR l_override_sickness_days IS NULL THEN
2956: --sickness pay hours calculation
2957: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2958: ( p_assignment_id, l_hours, l_include_event,
2959: c_abs.date_start, c_abs.date_end,
2960: replace(nvl(c_abs.time_start,nvl(l_normal_time_start,l_start_time_char)),':','.'),
2961: replace(nvl(c_abs.time_end,nvl(l_normal_time_end, l_end_time_char)),':','.'), l_wrk_duration

Line 3169: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3165: p_tot_waiting_day_ded:=0;
3166: p_total_sickness_deduction:=0;
3167: END IF;
3168: l_asg_hour_sal:='D';
3169: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3170: ( p_assignment_id, l_asg_hour_sal, l_include_event,
3171: l_group_start_date, p_fourteenth_date,
3172: l_start_time_char,l_end_time_char, l_wrk_duration
3173: );

Line 3388: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3384: BEGIN
3385: l_starting_date:=p_abs_start_date;
3386:
3387: WHILE (l_starting_date <= p_abs_end_date) AND l_found = false LOOP
3388: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3389: ( p_assignment_id, l_asg_hour_sal, l_include_event,
3390: l_starting_date,l_starting_date, l_start_time_char,
3391: l_end_time_char, l_duration
3392: );

Line 3440: /*l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3436: AND p_effective_date BETWEEN papf.effective_start_date
3437: AND papf.effective_end_date;*/
3438: /*get the entitlement days with public holidays and weekends*/
3439: --l_include_event:='Y';
3440: /*l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3441: ( p_assignment_id, l_asg_hour_sal, l_include_event,
3442: p_absence_start_date, p_absence_end_date,l_start_time_char,
3443: l_end_time_char, l_wrk_duration
3444: ); */

Line 3449: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3445:
3446: p_entitlement_days:=(p_absence_end_date-p_absence_start_date)+1;
3447: /*get the sickness days without public holidays and weekends*/
3448: l_include_event:='Y';
3449: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3450: ( p_assignment_id, l_asg_hour_sal, l_include_event,
3451: p_absence_start_date, p_absence_end_date,l_start_time_char,
3452: l_end_time_char, l_wrk_duration
3453: );

Line 3647: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3643: FOR csr_abs IN csr_absence_period(p_person_id,greatest(p_pay_start_date,p_abs_group_start_date),least(p_pay_end_date,p_abs_group_end_date)) LOOP
3644:
3645: l_calendar_days:=l_calendar_days+(csr_abs.date_end-csr_abs.date_start+1);
3646:
3647: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3648: ( p_assignment_id, l_days, l_include_event,
3649: csr_abs.date_start, csr_abs.date_end, replace(nvl(csr_abs.time_start,l_start_time_char),':','.'),
3650: replace(nvl(csr_abs.time_end,l_end_time_char),':','.'), l_day_duration
3651: );

Line 3655: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3651: );
3652:
3653: l_working_days:=l_working_days+l_day_duration;
3654:
3655: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3656: ( p_assignment_id, l_hours, l_include_event,
3657: csr_abs.date_start, csr_abs.date_end, replace(l_start_time_char,':','.'),
3658: replace(l_end_time_char,':','.'), l_hour_duration
3659: );