[Home] [Help]
203:
204: FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,
205: p_person_id IN per_all_people_f.person_id%TYPE,
206: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
207: p_los_type IN hr_lookups.lookup_code%TYPE,
208: p_start_date IN DATE,
209: p_end_date IN DATE
210: )
211: RETURN NUMBER IS
288:
289: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,
290: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
291: p_bg_id IN per_all_organization_units.organization_id%TYPE,
292: p_los_type IN hr_lookups.lookup_code%TYPE,
293: p_start_date IN DATE,
294: p_end_date IN DATE)
295:
296: RETURN NUMBER IS
422: -- -----------------------------------------------------------------------*
423:
424: FUNCTION get_length_previous_employment(p_person_id IN per_all_people_f.person_id%TYPE,
425: p_bg_id IN per_all_organization_units.organization_id%TYPE,
426: p_los_type IN hr_lookups.lookup_code%TYPE,
427: p_previous_job_id IN per_previous_jobs.previous_job_id%TYPE
428: ) RETURN NUMBER IS
429: l_prev_emp_period NUMBER(22,3) := 0;
430: l_temp_duration NUMBER(22,3) := 0;
586: -- -----------------------------------------------------------------------*
587:
588:
589: FUNCTION get_correction_factor ( p_person_id IN per_all_people_f.person_id%TYPE,
590: p_los_type IN hr_lookups.lookup_code%TYPE,
591: p_effective_date IN DATE)
592: RETURN NUMBER IS
593:
594: l_correct_days NUMBER(22,3) := 0;
622: -- -----------------------------------------------------------------------*
623: FUNCTION get_military_service_period (p_bg_id IN hr_all_organization_units.organization_id%TYPE,
624: p_person_id IN per_all_people_f.person_id%TYPE,
625: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
626: p_los_type IN hr_lookups.lookup_code%TYPE,
627: p_start_date IN DATE,
628: p_end_date IN DATE)
629: RETURN NUMBER IS
630:
1368: hr_api.mandatory_arg_error(p_api_name => l_proc,
1369: p_argument => 'p_los_type',
1370: p_argument_value => p_los_type);
1371: ELSE
1372: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,
1373: p_lookup_type => 'FR_PQH_LENGTH_OF_SERVICE_TYPE',
1374: p_lookup_code => p_los_type) THEN
1375: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1376: fnd_message.set_token('VALUE',p_los_type);
1382: hr_api.mandatory_arg_error(p_api_name => l_proc,
1383: p_argument => 'p_return_units',
1384: p_argument_value => p_return_units);
1385: ELSE
1386: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,
1387: p_lookup_type => 'QUALIFYING_UNITS',
1388: p_lookup_code => p_return_units) THEN
1389: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1390: fnd_message.set_token('VALUE',p_return_units);
1465: -- This Function returns the military service duration for an employee
1466: --
1467: FUNCTION get_de_military_service_period(p_bg_id IN hr_all_organization_units.organization_id%TYPE,
1468: p_person_id IN per_all_people_f.person_id%TYPE,
1469: p_los_type IN hr_lookups.lookup_code%TYPE,
1470: p_start_date IN DATE,
1471: p_end_date IN DATE)
1472: RETURN VARCHAR2 IS
1473:
2479: hr_api.mandatory_arg_error(p_api_name => l_proc,
2480: p_argument => 'Length of Service Type',
2481: p_argument_value => p_los_type);
2482: ELSE
2483: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_end_date,
2484: p_lookup_type => 'FR_PQH_LENGTH_OF_SERVICE_TYPE',
2485: p_lookup_code => p_los_type) THEN
2486: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2487: fnd_message.set_token('VALUE',p_los_type);
2647:
2648: END get_length_of_service;
2649:
2650: FUNCTION get_de_correction_factor(p_person_id IN per_all_people_f.person_id%TYPE,
2651: p_los_type IN hr_lookups.lookup_code%TYPE,
2652: p_effective_date IN DATE)
2653: RETURN VARCHAR2 IS
2654:
2655: CURSOR c_correction_factor IS