43: g_hour_change_limit number := 0;
44: g_absence_termination_limit number := 0;
45: g_report_mode varchar2 (80);
46: g_effective_start_date date;
47: g_legal_employer_name hr_all_organization_units.name%type;
48: g_legal_employer_org_no hr_organization_information.org_information1%type;
49: g_no_hours_change_weeks number := 0;
50: /* GET PARAMETER */
51: function get_parameter (
178: org.name
179: legal_employer_name, org.location_id,
180: hoi1.org_information1
181: legal_employer_org_no
182: from hr_all_organization_units org,
183: hr_organization_information hoi1
184: where org.organization_id = p_legal_employer_id
185: and hoi1.organization_id(+) = org.organization_id
186: and hoi1.org_information_context(+) = 'NO_LEGAL_EMPLOYER_DETAILS';
194: hou_lu.name
195: local_unit_name,
196: hoi_lu.org_information1
197: local_unit_org_no, hou_lu.location_id
198: from hr_all_organization_units hou_le,
199: hr_organization_information hoi_le,
200: hr_all_organization_units hou_lu,
201: hr_organization_information hoi_lu
202: where hoi_le.organization_id = hou_le.organization_id
196: hoi_lu.org_information1
197: local_unit_org_no, hou_lu.location_id
198: from hr_all_organization_units hou_le,
199: hr_organization_information hoi_le,
200: hr_all_organization_units hou_lu,
201: hr_organization_information hoi_lu
202: where hoi_le.organization_id = hou_le.organization_id
203: and hou_le.organization_id = csr_v_legal_employer_id
204: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
313: hou_lu.name
314: local_unit_name,
315: hoi_lu.org_information1
316: local_unit_org_no, hou_lu.location_id
317: from hr_all_organization_units hou_le,
318: hr_organization_information hoi_le,
319: hr_all_organization_units hou_lu,
320: hr_organization_information hoi_lu
321: where hoi_le.organization_id = hou_le.organization_id
315: hoi_lu.org_information1
316: local_unit_org_no, hou_lu.location_id
317: from hr_all_organization_units hou_le,
318: hr_organization_information hoi_le,
319: hr_all_organization_units hou_lu,
320: hr_organization_information hoi_lu
321: where hoi_le.organization_id = hou_le.organization_id
322: and hou_le.organization_id = csr_v_legal_employer_id
323: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
329: --
330: /* Cursor to get Employee Details based on the Local Unit , Start Date
331: and End Date*/
332: cursor csr_employee_details (
333: p_local_unit hr_all_organization_units.organization_id%type,
334: p_start_date date,
335: p_end_date date
336: ) is
337: select papf.person_id person_id, paaf.assignment_id,
859: /* Cursor to get all the assignment for the person except the given assignment*/
860: cursor csr_get_all_assignments
861: (p_person_id per_all_people_f.person_id%type,
862: p_assignment_id per_all_assignments_f.assignment_id%type,
863: p_local_unit hr_all_organization_units.organization_id%type)
864: is
865: select assignment_id
866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
867: where person_id = p_person_id
872:
873: Cursor csr_get_assignment_details
874: (p_effective_date date,
875: p_assignment_id per_all_assignments_f.assignment_id%type,
876: p_local_unit hr_all_organization_units.organization_id%type)
877: is
878: select normal_hours,
879: hourly_salaried_code, hsc.segment3 position_code, frequency
880: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
898: /* Declaration for Local Variables */
899: l_ovn number;
900: l_action_info_id number;
901: l_legal_employer_id hr_organization_units.organization_id%type;
902: l_business_group_id hr_all_organization_units.business_group_id%type;
903: l_start_date date;
904: l_end_date date;
905: l_legal_employer_id hr_organization_units.organization_id%type;
906: l_effective_date date;