[Home] [Help]
9: function count_employees
10: (p_organization_id in hr_organization_units.organization_id%type,
11: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
12: p_time_period_id in per_time_periods.time_period_id%type,
13: p_location_id in per_all_assignments_f.location_id%type,
14: p_emp_cat_code in per_all_people_f.per_information7%type,
15: p_work_time_code in per_all_people_f.per_information8%type,
16: p_sex in per_all_people_f.sex%type,
17: p_survey_date in date)
22: cursor emp_count
23: (c_organization_id hr_organization_units.organization_id%type,
24: c_payroll_id pay_all_payrolls_f.payroll_id%type,
25: c_time_period_id per_time_periods.time_period_id%type,
26: c_location_id per_all_assignments_f.location_id%type,
27: c_emp_cat_code per_all_people_f.per_information7%type,
28: c_work_time_code per_all_people_f.per_information8%type,
29: c_sex per_all_people_f.sex%type,
30: c_survey_date date)
74: function count_employees_using_balance
75: (p_organization_id in hr_organization_units.organization_id%type,
76: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
77: p_time_period_id in per_time_periods.time_period_id%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
78: p_location_id in per_all_assignments_f.location_id%type,
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
83: p_week_frequency in per_all_assignments_f.frequency%type,
84: p_survey_date in date)
85: return number is
86:
79: p_emp_cat_code in per_all_people_f.per_information7%type,
80: p_work_time_code in per_all_people_f.per_information8%type,
81: p_sex in per_all_people_f.sex%type,
82: p_week_hours in per_all_assignments_f.normal_hours%type,
83: p_week_frequency in per_all_assignments_f.frequency%type,
84: p_survey_date in date)
85: return number is
86:
87: v_defined_balance_id pay_defined_balances.defined_balance_id%type;
95: cursor emp_balance
96: (c_organization_id hr_organization_units.organization_id%type,
97: c_payroll_id pay_all_payrolls_f.payroll_id%type,
98: c_time_period_id per_time_periods.time_period_id%type,
99: c_location_id per_all_assignments_f.location_id%type,
100: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
101: c_sex per_all_people_f.sex%type,
102: c_survey_date date) is
103:
195: function sum_balances
196: (p_organization_id in hr_organization_units.organization_id%type,
197: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
198: p_time_period_id in per_time_periods.time_period_id%type,
199: p_location_id in per_all_assignments_f.location_id%type,
200: p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
201: p_sex in per_all_people_f.sex%type,
202: p_survey_date in date)
203: return number is
208: cursor emp_balance
209: (c_organization_id hr_organization_units.organization_id%type,
210: c_payroll_id pay_all_payrolls_f.payroll_id%type,
211: c_time_period_id per_time_periods.time_period_id%type,
212: c_location_id per_all_assignments_f.location_id%type,
213: c_defined_balance_id pay_defined_balances.defined_balance_id%type,
214: c_sex per_all_people_f.sex%type,
215: c_survey_date date) is
216:
317: -- Date and Assignment.
318: ------------------------------------------------------------------------
319: function ordinary_time_payout
320: (p_regular_payment_date in per_time_periods.regular_payment_date%type,
321: p_assignment_id in per_all_assignments_f.assignment_id%type)
322: return number is
323:
324: v_payout number(20,5) := 0;
325:
340: -- equal to W, but differs from the Payroll Frequency, then call
341: -- convert_hours.
342: ------------------------------------------------------------------------
343: function hours_worked
344: (p_assignment_id in per_all_assignments_f.assignment_id%type,
345: p_payroll_frequency in pay_all_payrolls_f.period_type%type)
346: return number is
347:
348: v_hours_worked number(20,5) := 0;
347:
348: v_hours_worked number(20,5) := 0;
349:
350: cursor standard_conditions
351: (c_assignment_id per_all_assignments_f.assignment_id%type) is
352:
353: select paa.normal_hours,
354: paa.frequency frequency_code, -- to pass to convert_hours
355: hl.meaning frequency -- to compare to payroll_frequency
385: -- the Payroll Frequency. This function assumes there are 52 weeks per
386: -- year.
387: ------------------------------------------------------------------------
388: function convert_hours
389: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
390: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
391: p_assignment_frequency in per_all_assignments_f.frequency%type)
392: return number is
393:
387: ------------------------------------------------------------------------
388: function convert_hours
389: (p_assignment_hours in per_all_assignments_f.normal_hours%type,
390: p_payroll_frequency in pay_all_payrolls_f.period_type%type,
391: p_assignment_frequency in per_all_assignments_f.frequency%type)
392: return number is
393:
394: v_converted_hours number(20,5) := 0;
395: v_number_per_year per_time_period_types.number_per_fiscal_year%type := 52;