[Home] [Help]
2128:
2129: BEGIN /* Check ASGMPE */
2130:
2131: select 1 INTO l_asg_info_changes
2132: from dual
2133: where exists (
2134: SELECT 1
2135: FROM per_assignments_f ASG,
2136: per_assignment_status_types AST,
2156:
2157: BEGIN /* EEVMPE check - maybe pick*/
2158:
2159: select 1 INTO l_eev_info_changes
2160: from dual
2161: where exists (
2162: SELECT 1
2163: FROM pay_element_entry_values_f EEV
2164: WHERE EEV.element_entry_id = p_ele_entry_id
2201:
2202: BEGIN /* ASGMPS changes */
2203:
2204: select 1 INTO l_asg_info_changes
2205: from dual
2206: where exists (
2207: SELECT 1
2208: FROM per_assignments_f ASG,
2209: per_assignment_status_types AST,
2224:
2225: BEGIN /* EEVMPE changes ASGMPS */
2226:
2227: select 1 INTO l_eev_info_changes
2228: from dual
2229: where exists (
2230: SELECT 1
2231: FROM pay_element_entry_values_f EEV
2232: WHERE EEV.element_entry_id = p_ele_entry_id
2271: hr_utility.set_location('calculate_period_earnings', 58);
2272: hr_utility.trace('Check for EEVMPE changes nevertheless');
2273:
2274: select 1 INTO l_eev_info_changes
2275: from dual
2276: where exists (
2277: SELECT 1
2278: FROM pay_element_entry_values_f EEV
2279: WHERE EEV.element_entry_id = p_ele_entry_id
3519:
3520: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3521: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3522: INTO p_duration
3523: FROM DUAL;
3524: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3525: hr_utility.trace('Start p_duration ' || p_duration);
3526:
3527: --
3530: hr_utility.trace('l_end_time ' || l_end_time);
3531: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3532: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3533: INTO p_duration
3534: FROM DUAL;
3535: --hr_utility.trace('p_end_duration ' || p_end_duration);
3536: hr_utility.trace('End p_duration ' || p_duration);
3537: --
3538: -- Get between full day hours
3537: --
3538: -- Get between full day hours
3539: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3540: INTO p_duration
3541: FROM DUAL;
3542: ELSE
3543: -- Start and End on same day
3544: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3545: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
3549:
3550: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3551: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3552: INTO p_duration
3553: FROM DUAL;
3554: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);
3555:
3556: END IF;
3557: END IF;