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.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ALL_ORGANIZATION_UNITS

Line 40: PROCEDURE bg_normal_hours (p_bg_id IN per_all_organization_units.organization_id%TYPE,

36: -- This procedure gets the Normal Workd Day Hours, Normal Hours and its Frequency defined
37: -- at the Business Group level.
38: -- -----------------------------------------------------------------------*
39:
40: PROCEDURE bg_normal_hours (p_bg_id IN per_all_organization_units.organization_id%TYPE,
41: p_bg_normal_day_hours OUT NOCOPY NUMBER,
42: p_bg_normal_hours OUT NOCOPY NUMBER,
43: p_bg_frequency OUT NOCOPY VARCHAR2)
44: IS

Line 204: FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,

200: -- Length of service calculations after evaluating the relevant entitlements.
201: -- -----------------------------------------------------------------------*
202:
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,

Line 291: p_bg_id IN per_all_organization_units.organization_id%TYPE,

287: -- -----------------------------------------------------------------------*
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:

Line 425: p_bg_id IN per_all_organization_units.organization_id%TYPE,

421: -- while calculating the LOS for French Public Sector.
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;

Line 682: FUNCTION get_gen_pub_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,

678: -- FUNCTION get_gen_pub_length_of_service
679: -- This function returns the general / public length of service for the employee
680: -- -----------------------------------------------------------------------*
681:
682: FUNCTION get_gen_pub_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
683: p_person_id IN per_all_people_f.person_id%TYPE,
684: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
685: p_los_type IN VARCHAR2,
686: p_determination_date IN DATE)

Line 779: FUNCTION get_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

775: -- FUNCTION get_grade_length_of_service
776: -- This function returns the length of service in the current grade for the employee
777: -- -----------------------------------------------------------------------*
778:
779: FUNCTION get_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
780: p_person_id IN per_all_people_f.person_id%TYPE,
781: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
782: p_determination_date IN DATE)
783: RETURN NUMBER IS

Line 892: FUNCTION get_position_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

888: -- FUNCTION get_position_length_of_service
889: -- This function returns the length of service in the current position for the employee
890: -- -----------------------------------------------------------------------*
891:
892: FUNCTION get_position_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
893: p_person_id IN per_all_people_f.person_id%TYPE,
894: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
895: p_determination_date IN DATE)
896: RETURN NUMBER IS

Line 1004: FUNCTION get_corps_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

1000: -- FUNCTION get_corps_length_of_service
1001: -- This function returns the length of service in the current position for the employee
1002: -- -----------------------------------------------------------------------*
1003:
1004: FUNCTION get_corps_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1005: p_person_id IN per_all_people_f.person_id%TYPE,
1006: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1007: p_determination_date IN DATE)
1008: RETURN NUMBER IS

Line 1120: FUNCTION get_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,

1116: -- FUNCTION get_step_length_of_service
1117: -- This function returns the length of service in the current grade step for the employee
1118: -- -----------------------------------------------------------------------*
1119:
1120: FUNCTION get_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,
1121: p_person_id IN per_all_people_f.person_id%TYPE,
1122: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1123: p_determination_date IN DATE)
1124: RETURN NUMBER IS

Line 1286: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;

1282: l_los_days NUMBER(22,3) := 0;
1283: l_los_return NUMBER(22,3);
1284: l_emp_type PER_ALL_ASSIGNMENTS_F.employee_category%TYPE;
1285: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
1286: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
1287: l_adj_service_date DATE;
1288: l_proc varchar2(60) := g_package||'get_length_of_sevice';
1289: l_exists VARCHAR2(2) := '0';
1290:

Line 1549: FUNCTION get_de_pub_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

1545: -- FUNCTION get_de_pub_length_of_service
1546: -- This function returns the length of service in Public Services for an employee
1547: -- -----------------------------------------------------------------------*
1548:
1549: FUNCTION get_de_pub_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1550: p_person_id IN per_all_people_f.person_id%TYPE,
1551: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1552: p_los_type IN VARCHAR2,
1553: p_assg_start_date IN DATE ,

Line 1664: FUNCTION get_jub_mon_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

1660: -- FUNCTION get_jub_mon_length_of_service
1661: -- This function returns the length of service for Jubilee Money for an employee
1662: -- -----------------------------------------------------------------------*
1663:
1664: FUNCTION get_jub_mon_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1665: p_person_id IN per_all_people_f.person_id%TYPE,
1666: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1667: p_los_type IN VARCHAR2,
1668: p_assg_start_date IN DATE ,

Line 1800: FUNCTION get_bda_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

1796: -- FUNCTION get_bda_length_of_service
1797: -- This function returns the length of service for BDA calculation of an employee
1798: -- -----------------------------------------------------------------------*
1799:
1800: FUNCTION get_bda_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
1801: p_person_id IN per_all_people_f.person_id%TYPE,
1802: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1803: p_los_type IN VARCHAR2,
1804: p_assg_start_date IN DATE ,

Line 2006: FUNCTION get_de_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,

2002: --
2003: -- This function return the Length of service in a Grade for an Employee - German PS
2004: --
2005:
2006: FUNCTION get_de_grade_length_of_service(p_bg_id IN per_all_organization_units.organization_id%TYPE,
2007: p_person_id IN per_all_people_f.person_id%TYPE,
2008: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2009: p_los_type IN VARCHAR2,
2010: p_assg_start_date IN DATE ,

Line 2139: FUNCTION get_de_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,

2135: -- FUNCTION get_step_length_of_service
2136: -- This function returns the length of service in the current grade step for the employee
2137: -- -----------------------------------------------------------------------*
2138:
2139: FUNCTION get_de_step_length_of_service (p_bg_id IN per_all_organization_units.organization_id%TYPE,
2140: p_person_id IN per_all_people_f.person_id%TYPE,
2141: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2142: p_los_type IN VARCHAR2,
2143: p_assg_start_date IN DATE ,

Line 2269: FUNCTION get_de_assg_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,

2265: -- FUNCTION get_de_assg_length_of_service
2266: -- This function returns the length of service in the current assignment for the employee
2267: -- -----------------------------------------------------------------------*
2268:
2269: FUNCTION get_de_assg_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
2270: p_person_id IN per_all_people_f.person_id%TYPE,
2271: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2272: p_los_type IN VARCHAR2,
2273: p_assg_start_date IN DATE ,

Line 2342: FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,

2338: -- This function returns the length of service for a person
2339: -- This is called in the Report for Period of Employment - DEPS
2340: --
2341:
2342: FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
2343: p_person_id IN per_all_people_f.person_id%TYPE,
2344: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,
2345: p_prev_job_id IN per_previous_jobs.previous_job_id%TYPE DEFAULT NULL,
2346: p_los_type IN VARCHAR2,

Line 2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;

2365: l_emp_type per_previous_jobs.employment_category%TYPE := 'x';
2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';
2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;
2368: l_person_id per_all_people_f.person_id%TYPE;
2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
2370: l_entitlement pqh_situations.entitlement_value%TYPE :=0;
2371: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;
2372: l_proc VARCHAR2(60) := g_package||'get_length_of_service';
2373: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

Line 2676: p_bg_id IN per_all_organization_units.organization_id%TYPE)

2672:
2673: END get_de_correction_factor;
2674:
2675: FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2676: p_bg_id IN per_all_organization_units.organization_id%TYPE)
2677: RETURN VARCHAR2 IS
2678:
2679: cursor csr_corps is
2680: select segment7 from hr_soft_coding_keyflex where id_flex_num in