1 package pay_nz_qes_pkg AUTHID CURRENT_USER as
2 /* $Header: pynzqes.pkh 115.4 2003/05/30 08:27:36 puchil ship $ */
3
4 function count_employees
5 (p_organization_id in hr_organization_units.organization_id%type,
6 p_payroll_id in pay_all_payrolls_f.payroll_id%type,
7 p_time_period_id in per_time_periods.time_period_id%type,
8 p_location_id in per_all_assignments_f.location_id%type,
9 p_emp_cat_code in per_all_people_f.per_information7%type,
10 p_work_time_code in per_all_people_f.per_information8%type,
11 p_sex in per_all_people_f.sex%type,
12 p_survey_date in date)
13 return number;
14
15 function count_employees_using_balance
16 (p_organization_id in hr_organization_units.organization_id%type,
17 p_payroll_id in pay_all_payrolls_f.payroll_id%type,
18 p_time_period_id in per_time_periods.time_period_id%type,
19 p_location_id in per_all_assignments_f.location_id%type,
20 p_emp_cat_code in per_all_people_f.per_information7%type,
21 p_work_time_code in per_all_people_f.per_information8%type,
22 p_sex in per_all_people_f.sex%type,
23 p_week_hours in per_all_assignments_f.normal_hours%type,
24 p_week_frequency in per_all_assignments_f.frequency%type,
25 p_survey_date in date)
26 return number;
27
28 function sum_balances
29 (p_organization_id in hr_organization_units.organization_id%type,
30 p_payroll_id in pay_all_payrolls_f.payroll_id%type,
31 p_time_period_id in per_time_periods.time_period_id%type,
32 p_location_id in per_all_assignments_f.location_id%type,
33 p_defined_balance_id in pay_defined_balances.defined_balance_id%type,
34 p_sex in per_all_people_f.sex%type,
35 p_survey_date in date)
36 return number;
37
38 function id_for_defined_balance
39 (p_balance_name in pay_balance_types.balance_name%type,
40 p_balance_dimension in pay_balance_dimensions.database_item_suffix%type)
41 return pay_balance_types.balance_type_id%type;
42
43 function ordinary_time_payout
44 (p_regular_payment_date in per_time_periods.regular_payment_date%type,
45 p_assignment_id in per_all_assignments_f.assignment_id%type)
46 return number;
47
48 function hours_worked
49 (p_assignment_id in per_all_assignments_f.assignment_id%type,
50 p_payroll_frequency in pay_all_payrolls_f.period_type%type)
51 return number;
52
53 function convert_hours
54 (p_assignment_hours in per_all_assignments_f.normal_hours%type,
55 p_payroll_frequency in pay_all_payrolls_f.period_type%type,
56 p_assignment_frequency in per_all_assignments_f.frequency%type)
57 return number;
58
59 function no_periods_per_year
60 (p_period_type in per_time_period_types.period_type%type)
61 return number;
62 end pay_nz_qes_pkg;