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 921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

917: l_msg_error := to_char(13);
918: END IF;
919: l_include_event := 'N';
920: -- Calculating actual sickness days through work schedule
921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
922: ( p_assignment_id, l_days_or_hours, l_include_event,
923: p_prorate_start, p_prorate_end, l_start_time_char,
924: l_end_time_char, l_duration
925: );

Line 977: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

973: IF ( i.date_start = i.date_end ) THEN
974: l_loop_empr_days := l_loop_empr_days + 1;
975: l_duration := 0;
976: l_include_event := 'N';
977: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
978: ( p_assignment_id, l_days_or_hours, l_include_event,
979: i.date_start, i.date_end, l_start_time_char,
980: l_end_time_char, l_duration
981: );

Line 1007: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1003: -- If override element exists for the continuous absences then override the work days.
1004: IF l_cont_empr_days IS NULL THEN
1005: l_duration := 0;
1006: l_include_event := 'N';
1007: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1008: ( p_assignment_id, l_days_or_hours, l_include_event,
1009: i.date_start, i.date_end, l_start_time_char,
1010: l_end_time_char, l_duration
1011: );

Line 1041: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1037: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1038:
1039: -- Ignore public holidays if the one present in between absence start and end dates.
1040: l_include_event := 'N';
1041: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1042: ( p_assignment_id, l_days_or_hours, l_include_event,
1043: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1044: l_end_time_char, l_duration
1045: );

Line 1059: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1055: l_gen_ss_st_date := null;
1056:
1057: -- Ignore public holidays if the one present in between absence start and end dates.
1058: l_include_event := 'N';
1059: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1060: ( p_assignment_id, l_days_or_hours, l_include_event,
1061: p_prorate_start, p_prorate_end, l_start_time_char,
1062: l_end_time_char, l_duration
1063: );

Line 1073: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1069: END IF; /
1070:
1071: / pdavidra added code start - Bug no: 5277080/
1072: l_include_event := 'N';
1073: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1074: ( p_assignment_id, l_days_or_hours, l_include_event,
1075: p_prorate_start, p_prorate_end, l_start_time_char,
1076: l_end_time_char, l_duration
1077: );

Line 1120: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1116: / 5277080 start - Calculate the Social Security Start Date /
1117: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1118: loop
1119: l_include_event := 'N';
1120: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1121: ( p_assignment_id, l_days_or_hours, l_include_event,
1122: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1123: l_end_time_char, l_duration
1124: );

Line 1228: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1224: IF ( i.date_start = i.date_end ) THEN
1225: l_loop_empr_days := l_loop_empr_days + 1;
1226: l_duration := 0;
1227: l_include_event := 'N';
1228: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1229: ( p_assignment_id, l_days_or_hours, l_include_event,
1230: i.date_start, i.date_end, l_start_time_char,
1231: l_end_time_char, l_duration
1232: );

Line 1258: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1254: -- If override element exists for the continuous absences then override the work days.
1255: IF l_cont_empr_days IS NULL THEN
1256: l_duration := 0;
1257: l_include_event := 'N';
1258: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1259: ( p_assignment_id, l_days_or_hours, l_include_event,
1260: i.date_start, i.date_end, l_start_time_char,
1261: l_end_time_char, l_duration
1262: );

Line 1289: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1285: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1286: -- Calculating actual days with prorated period
1287: l_duration := 0;
1288: l_include_event := 'N';
1289: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1290: ( p_assignment_id, l_days_or_hours, l_include_event,
1291: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1292: l_end_time_char, l_duration
1293: );

Line 1320: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1316: -- Calculating actual sickness days through work schedule
1317: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1318: -- Ignore public holidays if the one present in between absence start and end dates.
1319: l_include_event := 'N';
1320: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1321: ( p_assignment_id, l_days_or_hours, l_include_event,
1322: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1323: l_end_time_char, l_duration
1324: );

Line 1335: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1331: -- Calculating actual sickness days through work schedule
1332: l_gen_ss_st_date := null;
1333: -- Ignore public holidays if the one present in between absence start and end dates.
1334: l_include_event := 'N';
1335: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1336: ( p_assignment_id, l_days_or_hours, l_include_event,
1337: p_prorate_start, p_prorate_end, l_start_time_char,
1338: l_end_time_char, l_duration
1339: );

Line 1346: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1342: /
1343:
1344: / knelli added code start/
1345: l_include_event := 'N';
1346: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1347: ( p_assignment_id, l_days_or_hours, l_include_event,
1348: p_prorate_start, p_prorate_end, l_start_time_char,
1349: l_end_time_char, l_duration
1350: );

Line 1386: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1382: / 5277080 start - Calculate the Social Security Start Date /
1383: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1384: loop
1385: l_include_event := 'N';
1386: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1387: ( p_assignment_id, l_days_or_hours, l_include_event,
1388: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1389: l_end_time_char, l_duration
1390: );

Line 1494: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1490: IF ( i.date_start = i.date_end ) THEN
1491: l_loop_empr_days := l_loop_empr_days + 1;
1492: l_duration := 0;
1493: l_include_event := 'N';
1494: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1495: ( p_assignment_id, l_days_or_hours, l_include_event,
1496: i.date_start, i.date_end, l_start_time_char,
1497: l_end_time_char, l_duration
1498: );

Line 1527: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1523: -- If override element exists for the continuous absences then override the work days.
1524: IF l_cont_empr_days IS NULL THEN
1525: l_duration := 0;
1526: l_include_event := 'N';
1527: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1528: ( p_assignment_id, l_days_or_hours, l_include_event,
1529: i.date_start, i.date_end, l_start_time_char,
1530: l_end_time_char, l_duration
1531: );

Line 1552: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1548: l_loop_empr_days := nvl(l_loop_empr_days,0) + (i.date_earned - p_abs_start_date)+1;
1549: -- Calculating actual days with prorated period
1550: l_duration := 0;
1551: l_include_event := 'N';
1552: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1553: ( p_assignment_id, l_days_or_hours, l_include_event,
1554: p_abs_start_date, i.date_earned, l_start_time_char,
1555: l_end_time_char, l_duration
1556: );

Line 1564: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1560: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1561: -- Calculating actual days with prorated period
1562: l_duration := 0;
1563: l_include_event := 'N';
1564: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1565: ( p_assignment_id, l_days_or_hours, l_include_event,
1566: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1567: l_end_time_char, l_duration
1568: );

Line 1593: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1589: -- Calculating actual sickness days through work schedule
1590: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1591: -- Ignore public holidays if the one present in between absence start and end dates.
1592: l_include_event := 'N';
1593: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1594: ( p_assignment_id, l_days_or_hours, l_include_event,
1595: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1596: l_end_time_char, l_duration
1597: );

Line 1606: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1602: -- Calculating actual sickness days through work schedule
1603: l_gen_ss_st_date := null;
1604: -- Ignore public holidays if the one present in between absence start and end dates.
1605: l_include_event := 'N';
1606: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1607: ( p_assignment_id, l_days_or_hours, l_include_event,
1608: p_prorate_start, p_prorate_end, l_start_time_char,
1609: l_end_time_char, l_duration
1610: );

Line 1617: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1613: /
1614:
1615: / knelli added code start/
1616: l_include_event := 'N';
1617: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1618: ( p_assignment_id, l_days_or_hours, l_include_event,
1619: p_prorate_start, p_prorate_end, l_start_time_char,
1620: l_end_time_char, l_duration
1621: );

Line 1657: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1653: / 5277080 start - Calculate the Social Security Start Date /
1654: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1655: loop
1656: l_include_event := 'N';
1657: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1658: ( p_assignment_id, l_days_or_hours, l_include_event,
1659: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1660: l_end_time_char, l_duration
1661: );

Line 1762: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1758:
1759: l_loop_empr_days := l_loop_empr_days + 1;
1760: l_duration := 0;
1761: l_include_event := 'N';
1762: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1763: ( p_assignment_id, l_days_or_hours, l_include_event,
1764: i.date_start, i.date_end, l_start_time_char,
1765: l_end_time_char, l_duration
1766: );

Line 1794: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1790: -- If override element exists for the continuous absences then override the work days.
1791: IF l_cont_empr_days IS NULL THEN
1792: l_duration := 0;
1793: l_include_event := 'N';
1794: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1795: ( p_assignment_id, l_days_or_hours, l_include_event,
1796: i.date_start, i.date_end, l_start_time_char,
1797: l_end_time_char, l_duration
1798: );

Line 1819: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1815: l_loop_empr_days := nvl(l_loop_empr_days,0) + (i.date_earned - p_abs_start_date)+1;
1816: -- Calculating actual days with prorated period
1817: l_duration := 0;
1818: l_include_event := 'N';
1819: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1820: ( p_assignment_id, l_days_or_hours, l_include_event,
1821: p_abs_start_date, i.date_earned, l_start_time_char,
1822: l_end_time_char, l_duration
1823: );

Line 1831: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1827: l_loop_empr_days := nvl(l_loop_empr_days,0) + ( i.date_earned - l_prev_paydate);
1828: -- Calculating actual days with prorated period
1829: l_duration := 0;
1830: l_include_event := 'N';
1831: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1832: ( p_assignment_id, l_days_or_hours, l_include_event,
1833: (l_prev_paydate+1), i.date_earned, l_start_time_char,
1834: l_end_time_char, l_duration
1835: );

Line 1844: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1840: END LOOP;
1841:
1842: / knelli added code start /
1843: l_include_event := 'N';
1844: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1845: ( p_assignment_id, l_days_or_hours, l_include_event,
1846: p_prorate_start, p_prorate_end, l_start_time_char,
1847: l_end_time_char, l_duration
1848: );

Line 1874: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1870: -- Calculating actual sickness days through work schedule
1871: l_gen_ss_st_date := p_prorate_start + (p_abs_cal_days - l_loop_empr_days);
1872: -- Ignore public holidays if the one present in between absence start and end dates.
1873: l_include_event := 'N';
1874: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1875: ( p_assignment_id, l_days_or_hours, l_include_event,
1876: p_prorate_start, (l_gen_ss_st_date - 1), l_start_time_char,
1877: l_end_time_char, l_duration
1878: );

Line 1887: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1883: -- Calculating actual sickness days through work schedule
1884: l_gen_ss_st_date := null;
1885: -- Ignore public holidays if the one present in between absence start and end dates.
1886: l_include_event := 'N';
1887: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1888: ( p_assignment_id, l_days_or_hours, l_include_event,
1889: p_prorate_start, p_prorate_end, l_start_time_char,
1890: l_end_time_char, l_duration
1891: );

Line 1929: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

1925: / 5277080 start - Calculate the Social Security Start Date/
1926: l_gen_ss_st_date := p_prorate_start + l_empr_days ;
1927: loop
1928: l_include_event := 'N';
1929: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
1930: ( p_assignment_id, l_days_or_hours, l_include_event,
1931: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
1932: l_end_time_char, l_duration
1933: );

Line 2046: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2042: END IF;
2043:
2044: -- Ignore public holidays if the one present in between absence start and end dates.
2045: l_include_event := 'N';
2046: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2047: ( p_assignment_id, l_days_or_hours, l_include_event,
2048: p_prorate_start, l_emp_end_date, l_start_time_char,
2049: l_end_time_char, l_duration
2050: );

Line 2235: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2231: of payroll start date to get the last 4 weeks worked days*/
2232: /* condition added by pdavidra for Bug 5330188*/
2233: /*5475038 IF (l_abs_reason = 'Work Accident') AND
2234: ( (p_abs_start_date - p_abs_min_gap) < l_dateofjoin ) THEN
2235: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2236: ( p_assignment_id, l_days_or_hours, l_include_event,
2237: l_dateofjoin, (p_abs_start_date-1), l_start_time_char,
2238: l_end_time_char, l_duration
2239: );

Line 2242: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2238: l_end_time_char, l_duration
2239: );
2240: ELSE
2241: / pdavidra - bug 5330066 - redused the start date parameter by 1/
2242: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2243: ( p_assignment_id, l_days_or_hours, l_include_event,
2244: (p_abs_start_date - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
2245: l_end_time_char, l_duration
2246: );

Line 2248: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2244: (p_abs_start_date - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
2245: l_end_time_char, l_duration
2246: );
2247: END IF; */
2248: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2249: ( p_assignment_id, l_days_or_hours, l_include_event,
2250: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
2251: l_end_time_char, l_duration
2252: );

Line 2621: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2617: l_msg_error := to_char(13);
2618: END IF;
2619: l_include_event := 'N';
2620: -- Calculating actual sickness days through work schedule
2621: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2622: ( p_assignment_id, l_days_or_hours, l_include_event,
2623: p_prorate_start, p_prorate_end, l_start_time_char,
2624: l_end_time_char, l_duration
2625: );

Line 2790: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2786: IF ( i.date_start = i.date_end ) THEN
2787: l_duration := 0;
2788: l_include_event := 'N';
2789:
2790: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2791: ( p_assignment_id, l_days_or_hours, l_include_event,
2792: i.date_start, i.date_end, l_start_time_char,
2793: l_end_time_char, l_duration
2794: );

Line 2822: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2818: IF l_cont_empr_days IS NULL THEN
2819: l_duration := 0;
2820: l_include_event := 'N';
2821:
2822: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2823: ( p_assignment_id, l_days_or_hours, l_include_event,
2824: i.date_start, i.date_end, l_start_time_char,
2825: l_end_time_char, l_duration
2826: );

Line 2839: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2835:
2836: -- Calculation of actual working days present with the current absence.
2837: -- Ignore public holidays if the one present in between absence start and end dates.
2838: l_include_event := 'N';
2839: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2840: ( p_assignment_id, l_days_or_hours, l_include_event,
2841: p_prorate_start, p_prorate_end, l_start_time_char,
2842: l_end_time_char, l_duration
2843: );

Line 2921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2917: IF ( i.date_start = i.date_end ) THEN
2918: l_duration := 0;
2919: l_include_event := 'N';
2920:
2921: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2922: ( p_assignment_id, l_days_or_hours, l_include_event,
2923: i.date_start, i.date_end, l_start_time_char,
2924: l_end_time_char, l_duration
2925: );

Line 2952: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2948:
2949: l_duration := 0;
2950: l_include_event := 'N';
2951:
2952: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2953: ( p_assignment_id, l_days_or_hours, l_include_event,
2954: i.date_start, i.date_end, l_start_time_char,
2955: l_end_time_char, l_duration
2956: );

Line 2982: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2978: -- Calculating actual days with prorated period
2979: l_duration := 0;
2980: l_include_event := 'N';
2981:
2982: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2983: ( p_assignment_id, l_days_or_hours, l_include_event,
2984: (l_prev_paydate+1), i.date_earned, l_start_time_char,
2985: l_end_time_char, l_duration
2986: );

Line 2997: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

2993: -- Calculation of actual working days present with the current absence.
2994: -- Ignore public holidays if the one present in between absence start and end dates.
2995: l_include_event := 'N';
2996:
2997: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
2998: ( p_assignment_id, l_days_or_hours, l_include_event,
2999: p_prorate_start, p_prorate_end, l_start_time_char,
3000: l_end_time_char, l_duration
3001: );

Line 3078: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3074: IF ( i.date_start = i.date_end ) THEN
3075: l_duration := 0;
3076: l_include_event := 'N';
3077:
3078: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3079: ( p_assignment_id, l_days_or_hours, l_include_event,
3080: i.date_start, i.date_end, l_start_time_char,
3081: l_end_time_char, l_duration
3082: );

Line 3109: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3105:
3106: l_duration := 0;
3107: l_include_event := 'N';
3108:
3109: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3110: ( p_assignment_id, l_days_or_hours, l_include_event,
3111: i.date_start, i.date_end, l_start_time_char,
3112: l_end_time_char, l_duration
3113: );

Line 3133: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3129: -- Calculating actual days with prorated period
3130: l_duration := 0;
3131: l_include_event := 'N';
3132:
3133: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3134: ( p_assignment_id, l_days_or_hours, l_include_event,
3135: p_abs_start_date, i.date_earned, l_start_time_char,
3136: l_end_time_char, l_duration
3137: );

Line 3146: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3142: l_include_event := 'N';
3143:
3144: / knelli bug 5261106 added check/
3145: IF p_abs_end_date NOT BETWEEN l_prev_paydate+1 AND i.date_earned THEN
3146: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3147: ( p_assignment_id, l_days_or_hours, l_include_event,
3148: (l_prev_paydate+1), i.date_earned, l_start_time_char,
3149: l_end_time_char, l_duration
3150: );

Line 3161: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3157:
3158: -- Calculation of actual working days present with the current absence.
3159: -- Ignore public holidays if the one present in between absence start and end dates.
3160: l_include_event := 'N';
3161: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3162: ( p_assignment_id, l_days_or_hours, l_include_event,
3163: p_prorate_start, p_prorate_end, l_start_time_char,
3164: l_end_time_char, l_duration
3165: );

Line 3243: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3239: IF ( i.date_start = i.date_end ) THEN
3240: l_duration := 0;
3241: l_include_event := 'N';
3242:
3243: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3244: ( p_assignment_id, l_days_or_hours, l_include_event,
3245: i.date_start, i.date_end, l_start_time_char,
3246: l_end_time_char, l_duration
3247: );

Line 3274: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3270:
3271: l_duration := 0;
3272: l_include_event := 'N';
3273:
3274: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3275: ( p_assignment_id, l_days_or_hours, l_include_event,
3276: i.date_start, i.date_end, l_start_time_char,
3277: l_end_time_char, l_duration
3278: );

Line 3299: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3295: -- Calculating actual days with prorated period
3296: l_duration := 0;
3297: l_include_event := 'N';
3298:
3299: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3300: ( p_assignment_id, l_days_or_hours, l_include_event,
3301: p_abs_start_date, i.date_earned, l_start_time_char,
3302: l_end_time_char, l_duration
3303: );

Line 3312: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3308: -- Calculating actual days with prorated period
3309: l_duration := 0;
3310: l_include_event := 'N';
3311:
3312: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3313: ( p_assignment_id, l_days_or_hours, l_include_event,
3314: (l_prev_paydate+1), i.date_earned, l_start_time_char,
3315: l_end_time_char, l_duration
3316: );

Line 3326: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3322: END LOOP;
3323:
3324: / knelli call work schedule /
3325: l_include_event := 'N';
3326: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3327: ( p_assignment_id, l_days_or_hours, l_include_event,
3328: p_prorate_start, p_prorate_end, l_start_time_char,
3329: l_end_time_char, l_duration
3330: );

Line 3408: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3404: -- Calculation of actual working days present with the current absence.
3405: -- Ignore public holidays if the one present in between absence start and end dates.
3406: l_include_event := 'N';
3407:
3408: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3409: ( p_assignment_id, l_days_or_hours, l_include_event,
3410: p_prorate_start, p_prorate_end, l_start_time_char,
3411: l_end_time_char, l_duration
3412: );

Line 3448: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3444: l_empr_days := ( p_abs_child_emp_days_limit - curr_year_cms_emp_days );
3445: l_gen_ss_st_date := p_prorate_start + nvl(l_empr_days,0) ;
3446: LOOP
3447: l_include_event := 'N';
3448: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3449: ( p_assignment_id, l_days_or_hours, l_include_event,
3450: p_prorate_start, l_gen_ss_st_date, l_start_time_char,
3451: l_end_time_char, l_duration );
3452: IF l_duration = (l_empr_days +1) THEN

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

3590: /* pgopal - Bug 5393827 and 5349713 fix - taking the absence start date instead
3591: of payroll start date to get the last 4 weeks worked days*/
3592:
3593: /* knelli changed date_start parameter, reduced date by 1 */
3594: /* 5475038 l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3595: ( p_assignment_id, l_days_or_hours, l_include_event,
3596: ((p_abs_start_date) - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
3597: l_end_time_char, l_duration
3598: );*/

Line 3599: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

3595: ( p_assignment_id, l_days_or_hours, l_include_event,
3596: ((p_abs_start_date) - p_abs_min_gap), (p_abs_start_date-1), l_start_time_char,
3597: l_end_time_char, l_duration
3598: );*/
3599: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
3600: ( p_assignment_id, l_days_or_hours, l_include_event,
3601: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
3602: l_end_time_char, l_duration );
3603: -- Calculating actual number of absence days in the previous 4 weeks (payroll) periods.

Line 4011: for hr_loc_work_schedule.calc_sch_based_dur */

4007:
4008: /* BUG Fix 5346832 : Start
4009: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
4010: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4011: for hr_loc_work_schedule.calc_sch_based_dur */
4012:
4013: /*
4014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4015: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 4014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4010: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4011: for hr_loc_work_schedule.calc_sch_based_dur */
4012:
4013: /*
4014: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4015: ( p_assignment_id, l_days_or_hours, l_include_event,
4016: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4017: l_end_time_char, l_duration
4018: );

Line 4020: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4016: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4017: l_end_time_char, l_duration
4018: );
4019: */
4020: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4021: ( p_assignment_id, l_days_or_hours, l_include_event,
4022: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
4023: l_end_time_char, l_duration
4024: );

Line 4099: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4095:
4096:
4097: l_include_event := 'N';
4098: -- Calculating actual sickness days through work schedule
4099: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4100: ( p_assignment_id, l_days_or_hours, l_include_event,
4101: p_prorate_start, p_prorate_end, l_start_time_char,
4102: l_end_time_char, l_duration
4103: );

Line 4476: for hr_loc_work_schedule.calc_sch_based_dur */

4472:
4473: /* BUG Fix 5346832 : Start
4474: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
4475: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4476: for hr_loc_work_schedule.calc_sch_based_dur */
4477:
4478: /*
4479: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4480: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 4479: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4475: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4476: for hr_loc_work_schedule.calc_sch_based_dur */
4477:
4478: /*
4479: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4480: ( p_assignment_id, l_days_or_hours, l_include_event,
4481: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4482: l_end_time_char, l_duration
4483: );

Line 4485: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4481: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4482: l_end_time_char, l_duration
4483: );
4484: */
4485: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4486: ( p_assignment_id, l_days_or_hours, l_include_event,
4487: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
4488: l_end_time_char, l_duration
4489: );

Line 4570: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4566:
4567:
4568: l_include_event := 'N';
4569: -- Calculating actual sickness days through work schedule
4570: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4571: ( p_assignment_id, l_days_or_hours, l_include_event,
4572: p_prorate_start, p_prorate_end, l_start_time_char,
4573: l_end_time_char, l_duration
4574: );

Line 4940: for hr_loc_work_schedule.calc_sch_based_dur */

4936:
4937: /* BUG Fix 5346832 : Start
4938: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
4939: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4940: for hr_loc_work_schedule.calc_sch_based_dur */
4941:
4942: /*
4943: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4944: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 4943: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4939: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
4940: for hr_loc_work_schedule.calc_sch_based_dur */
4941:
4942: /*
4943: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4944: ( p_assignment_id, l_days_or_hours, l_include_event,
4945: ((l_initial_abs_st_date) - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
4946: l_end_time_char, l_duration
4947: );

Line 4950: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

4946: l_end_time_char, l_duration
4947: );
4948: */
4949:
4950: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
4951: ( p_assignment_id, l_days_or_hours, l_include_event,
4952: greatest(l_dateofjoin,((l_initial_abs_pay_stdt) - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
4953: l_end_time_char, l_duration
4954: );

Line 5030: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5026:
5027:
5028: l_include_event := 'N';
5029: -- Calculating actual sickness days through work schedule
5030: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5031: ( p_assignment_id, l_days_or_hours, l_include_event,
5032: p_prorate_start, p_prorate_end, l_start_time_char,
5033: l_end_time_char, l_duration
5034: );

Line 5410: for hr_loc_work_schedule.calc_sch_based_dur */

5406:
5407: /* BUG Fix 5346832 : Start
5408: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
5409: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5410: for hr_loc_work_schedule.calc_sch_based_dur */
5411:
5412: /*
5413: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5414: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 5413: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5409: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5410: for hr_loc_work_schedule.calc_sch_based_dur */
5411:
5412: /*
5413: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5414: ( p_assignment_id, l_days_or_hours, l_include_event,
5415: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
5416: l_end_time_char, l_duration
5417: );

Line 5420: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5416: l_end_time_char, l_duration
5417: );
5418: */
5419:
5420: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5421: ( p_assignment_id, l_days_or_hours, l_include_event,
5422: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
5423: l_end_time_char, l_duration
5424: );

Line 5504: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5500:
5501:
5502: l_include_event := 'N';
5503: -- Calculating actual sickness days through work schedule
5504: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5505: ( p_assignment_id, l_days_or_hours, l_include_event,
5506: p_prorate_start, p_prorate_end, l_start_time_char,
5507: l_end_time_char, l_duration
5508: );

Line 5927: for hr_loc_work_schedule.calc_sch_based_dur */

5923:
5924: /* BUG Fix 5346832 : Start
5925: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
5926: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5927: for hr_loc_work_schedule.calc_sch_based_dur */
5928:
5929: /*
5930: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5931: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 5930: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5926: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
5927: for hr_loc_work_schedule.calc_sch_based_dur */
5928:
5929: /*
5930: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5931: ( p_assignment_id, l_days_or_hours, l_include_event,
5932: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
5933: l_end_time_char, l_duration
5934: );

Line 5937: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

5933: l_end_time_char, l_duration
5934: );
5935: */
5936:
5937: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
5938: ( p_assignment_id, l_days_or_hours, l_include_event,
5939: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
5940: l_end_time_char, l_duration
5941: );

Line 6019: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6015: p_ss_daily_rate := p_adopt_rate;
6016:
6017: l_include_event := 'N';
6018: -- Calculating actual sickness days through work schedule
6019: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6020: ( p_assignment_id, l_days_or_hours, l_include_event,
6021: p_prorate_start, p_prorate_end, l_start_time_char,
6022: l_end_time_char, l_duration
6023: );

Line 6460: for hr_loc_work_schedule.calc_sch_based_dur */

6456:
6457: /* BUG Fix 5346832 : Start
6458: Changing the start date from (l_initial_abs_st_date - p_abs_min_gap)
6459: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6460: for hr_loc_work_schedule.calc_sch_based_dur */
6461:
6462: /*
6463: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6464: ( p_assignment_id, l_days_or_hours, l_include_event,

Line 6463: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6459: to greatest(l_dateofjoin,(l_initial_abs_st_date - p_abs_min_gap))
6460: for hr_loc_work_schedule.calc_sch_based_dur */
6461:
6462: /*
6463: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6464: ( p_assignment_id, l_days_or_hours, l_include_event,
6465: (l_initial_abs_st_date - p_abs_min_gap), (l_initial_abs_st_date-1), l_start_time_char,
6466: l_end_time_char, l_duration
6467: );

Line 6470: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6466: l_end_time_char, l_duration
6467: );
6468: */
6469:
6470: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6471: ( p_assignment_id, l_days_or_hours, l_include_event,
6472: greatest(l_dateofjoin,(l_initial_abs_pay_stdt - p_abs_min_gap)), (l_initial_abs_pay_stdt-1), l_start_time_char,
6473: l_end_time_char, l_duration
6474: );

Line 6551: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur

6547: p_ss_daily_rate := p_adopt_rate;
6548:
6549: l_include_event := 'N';
6550: -- Calculating actual sickness days through work schedule
6551: l_wrk_schd_return := hr_loc_work_schedule.calc_sch_based_dur
6552: ( p_assignment_id, l_days_or_hours, l_include_event,
6553: p_prorate_start, p_prorate_end, l_start_time_char,
6554: l_end_time_char, l_duration
6555: );