1 PACKAGE PER_HU_ABS_REP_ARCHIVE_PKG AUTHID CURRENT_USER AS
2 /* $Header: pehuarep.pkh 115.3 2004/05/10 23:52:40 srjanard noship $ */
3 --
4 FUNCTION get_parameter(
5 p_parameter_string IN VARCHAR2
6 ,p_token IN VARCHAR2
7 ) RETURN VARCHAR2;
8 --------------------------------------------------------------------------------
9 FUNCTION get_abs_rep_parameter(
10 p_actid IN NUMBER
11 ) RETURN VARCHAR2;
12 --------------------------------------------------------------------------------
13 PROCEDURE get_all_parameters(
14 p_payroll_action_id IN NUMBER
15 ,p_business_group_id OUT NOCOPY NUMBER
16 ,p_effective_date OUT NOCOPY DATE
17 ,p_reporting_date OUT NOCOPY DATE
18 ,p_payroll_id OUT NOCOPY NUMBER
19 ,p_assignment_set_id OUT NOCOPY NUMBER
20 ,p_employee_id OUT NOCOPY NUMBER
21 );
22 --------------------------------------------------------------------------------
23 PROCEDURE range_code(
24 p_actid IN NUMBER
25 ,sqlstr OUT NOCOPY VARCHAR2);
26 --------------------------------------------------------------------------------
27 PROCEDURE action_creation_code(
28 p_actid IN NUMBER
29 ,stperson IN NUMBER
30 ,endperson IN NUMBER
31 ,chunk IN NUMBER);
32 --------------------------------------------------------------------------------
33 FUNCTION get_children_info(
34 p_assignment_id IN NUMBER
35 ,p_business_group_id IN NUMBER
36 ,p_start_date IN DATE
37 ,p_end_date IN DATE
38 ,p_no_child_less_16 OUT NOCOPY NUMBER
39 ,p_no_child_16 OUT NOCOPY NUMBER
40 ,p_child_dob1 OUT NOCOPY DATE
41 ,p_child_dob2 OUT NOCOPY DATE
42 ,p_child_dob3 OUT NOCOPY DATE
43 ) RETURN NUMBER;
44 --------------------------------------------------------------------------------
45 FUNCTION get_payroll_Period (
46 p_payroll_id IN NUMBER
47 ,p_calculation_date IN DATE
48 ,p_accrual_frequency OUT NOCOPY VARCHAR2
49 ,p_accrual_multiplier OUT NOCOPY NUMBER
50 ) RETURN NUMBER;
51 --------------------------------------------------------------------------------
52 FUNCTION working_day_count (
53 p_assignment_id IN NUMBER
54 ,p_business_group_id IN NUMBER
55 ,p_start_date IN DATE
56 ,p_end_date IN DATE
57 ) RETURN NUMBER;
58 --------------------------------------------------------------------------------
59 FUNCTION get_person_dob (
60 p_assignment_id IN NUMBER
61 ,p_calculation_date IN DATE
62 ) RETURN DATE;
63 --------------------------------------------------------------------------------
64 FUNCTION get_prev_emp_sickness_leave(
65 p_assignment_id IN NUMBER
66 ,p_business_group_id IN NUMBER
67 ,p_termination_year IN VARCHAR2
68 ,p_prev_emp OUT NOCOPY VARCHAR2
69 )RETURN NUMBER;
70 --------------------------------------------------------------------------------
71 FUNCTION get_disability(
72 p_assignment_id IN NUMBER
73 ,p_business_group_id IN NUMBER
74 ,p_period_start_date IN DATE
75 ,p_period_end_date IN DATE
76 ) RETURN NUMBER;
77 --------------------------------------------------------------------------------
78 FUNCTION get_job_info(
79 p_assignment_id IN NUMBER
80 ,p_business_group_id IN NUMBER
81 ,p_period_start_date IN DATE
82 ,p_period_end_date IN DATE
83 ) RETURN NUMBER;
84 --------------------------------------------------------------------------------
85 FUNCTION chk_entry_in_accrual_plan(
86 p_entry_val IN VARCHAR2
87 ,p_message OUT NOCOPY VARCHAR2
88 ) RETURN VARCHAR2;
89 --------------------------------------------------------------------------------
90 END PER_HU_ABS_REP_ARCHIVE_PKG;