[Home] [Help]
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 (
175: org.name
176: legal_employer_name, org.location_id,
177: hoi1.org_information1
178: legal_employer_org_no
179: from hr_all_organization_units org,
180: hr_organization_information hoi1
181: where org.organization_id = p_legal_employer_id
182: and hoi1.organization_id(+) = org.organization_id
183: and hoi1.org_information_context(+) = 'NO_LEGAL_EMPLOYER_DETAILS';
191: hou_lu.name
192: local_unit_name,
193: hoi_lu.org_information1
194: local_unit_org_no, hou_lu.location_id
195: from hr_all_organization_units hou_le,
196: hr_organization_information hoi_le,
197: hr_all_organization_units hou_lu,
198: hr_organization_information hoi_lu
199: where hoi_le.organization_id = hou_le.organization_id
193: hoi_lu.org_information1
194: local_unit_org_no, hou_lu.location_id
195: from hr_all_organization_units hou_le,
196: hr_organization_information hoi_le,
197: hr_all_organization_units hou_lu,
198: hr_organization_information hoi_lu
199: where hoi_le.organization_id = hou_le.organization_id
200: and hou_le.organization_id = csr_v_legal_employer_id
201: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
309: hou_lu.name
310: local_unit_name,
311: hoi_lu.org_information1
312: local_unit_org_no, hou_lu.location_id
313: from hr_all_organization_units hou_le,
314: hr_organization_information hoi_le,
315: hr_all_organization_units hou_lu,
316: hr_organization_information hoi_lu
317: where hoi_le.organization_id = hou_le.organization_id
311: hoi_lu.org_information1
312: local_unit_org_no, hou_lu.location_id
313: from hr_all_organization_units hou_le,
314: hr_organization_information hoi_le,
315: hr_all_organization_units hou_lu,
316: hr_organization_information hoi_lu
317: where hoi_le.organization_id = hou_le.organization_id
318: and hou_le.organization_id = csr_v_legal_employer_id
319: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
325: --
326: /* Cursor to get Employee Details based on the Local Unit , Start Date
327: and End Date*/
328: cursor csr_employee_details (
329: p_local_unit hr_all_organization_units.organization_id%type,
330: p_start_date date,
331: p_end_date date
332: ) is
333: select papf.person_id person_id, paaf.assignment_id,
683: /* Cursor to get all the assignment for the person except the given assignment*/
684: cursor csr_get_all_assignments
685: (p_person_id per_all_people_f.person_id%type,
686: p_assignment_id per_all_assignments_f.assignment_id%type,
687: p_local_unit hr_all_organization_units.organization_id%type)
688: is
689: select assignment_id
690: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
691: where person_id = p_person_id
696:
697: Cursor csr_get_assignment_details
698: (p_effective_date date,
699: p_assignment_id per_all_assignments_f.assignment_id%type,
700: p_local_unit hr_all_organization_units.organization_id%type)
701: is
702: select normal_hours,
703: hourly_salaried_code, hsc.segment3 position_code, frequency
704: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
722: /* Declaration for Local Variables */
723: l_ovn number;
724: l_action_info_id number;
725: l_legal_employer_id hr_organization_units.organization_id%type;
726: l_business_group_id hr_all_organization_units.business_group_id%type;
727: l_start_date date;
728: l_end_date date;
729: l_legal_employer_id hr_organization_units.organization_id%type;
730: l_effective_date date;