1 PACKAGE HR_PAY_INTERFACE_PKG AS
2 /* $Header: pegpipkg.pkh 120.3 2005/12/26 22:02:42 sgelvi noship $ */
3 --
4 --
5 --
6 -- specific functionality for the oab benefit view
7 -- non split view
8 --
9 FUNCTION GET_COVERAGE_TYPE(P_OIPL_ID IN NUMBER) RETURN VARCHAR2;
10 --
11 --
12 FUNCTION eepyc_erpyc_exist
13 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
14 p_effective_start_date IN DATE,
15 p_effective_end_date IN DATE) RETURN VARCHAR2;
16 --
17 --
18 FUNCTION get_eepyc_varchar2
19 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
20 p_column_name IN VARCHAR2,
21 p_effective_start_date IN DATE,
22 p_effective_end_date IN DATE) RETURN VARCHAR2;
23 --
24 FUNCTION get_eepyc_number
25 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
26 p_column_name IN VARCHAR2,
27 p_effective_start_date IN DATE,
28 p_effective_end_date IN DATE) RETURN NUMBER;
29 --
30 FUNCTION get_eepyc_date
31 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
32 p_column_name IN VARCHAR2,
33 p_effective_start_date IN DATE,
34 p_effective_end_date IN DATE) RETURN DATE;
35 --
36 FUNCTION get_erpyc_varchar2
37 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
38 p_column_name IN VARCHAR2,
39 p_effective_start_date IN DATE,
40 p_effective_end_date IN DATE) RETURN VARCHAR2;
41 FUNCTION get_erpyc_number
42 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
43 p_column_name IN VARCHAR2,
44 p_effective_start_date IN DATE,
45 p_effective_end_date IN DATE) RETURN NUMBER;
46 FUNCTION get_erpyc_date
47 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
48 p_column_name IN VARCHAR2,
49 p_effective_start_date IN DATE,
50 p_effective_end_date IN DATE) RETURN DATE;
51
52 --
53 -- specific functionality for the oab benefit view
54 -- split views
55 --
56 --
57 FUNCTION split_eepyc_exist
58 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
59 p_effective_start_date IN DATE,
60 p_effective_end_date IN DATE) RETURN VARCHAR2;
61 --
62 FUNCTION split_erpyc_exist
63 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
64 p_effective_start_date IN DATE,
65 p_effective_end_date IN DATE) RETURN VARCHAR2;
66 --
67 FUNCTION get_split_eepyc_varchar2
68 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
69 p_column_name IN VARCHAR2,
70 p_effective_start_date IN DATE,
71 p_effective_end_date IN DATE) RETURN VARCHAR2;
72 --
73 FUNCTION get_split_eepyc_number
74 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
75 p_column_name IN VARCHAR2,
76 p_effective_start_date IN DATE,
77 p_effective_end_date IN DATE) RETURN NUMBER;
78 --
79 FUNCTION get_split_eepyc_date
80 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
81 p_column_name IN VARCHAR2,
82 p_effective_start_date IN DATE,
83 p_effective_end_date IN DATE) RETURN DATE;
84 --
85 FUNCTION get_split_erpyc_varchar2
86 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
87 p_column_name IN VARCHAR2,
88 p_effective_start_date IN DATE,
89 p_effective_end_date IN DATE) RETURN VARCHAR2;
90 FUNCTION get_split_erpyc_number
91 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
92 p_column_name IN VARCHAR2,
93 p_effective_start_date IN DATE,
94 p_effective_end_date IN DATE) RETURN NUMBER;
95 FUNCTION get_split_erpyc_date
96 (p_prtt_enrt_rslt_id IN ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE,
97 p_column_name IN VARCHAR2,
98 p_effective_start_date IN DATE,
99 p_effective_end_date IN DATE) RETURN DATE;
100
101 --
102 --
103 TYPE g_reporting_details_rec_type
104 IS RECORD (
105 reporting_name PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE
106 ,business_group_id PAY_ELEMENT_TYPES_F.BUSINESS_GROUP_ID%TYPE
107 ,payroll_id PER_ALL_ASSIGNMENTS_F.payroll_id%TYPE
108 ,legislation_code PAY_ELEMENT_TYPES_F.LEGISLATION_CODE%TYPE
109 ,element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE
110 ,effective_start_date PAY_ELEMENT_TYPES_F.EFFECTIVE_START_DATE%TYPE
111 ,effective_end_date PAY_ELEMENT_TYPES_F.EFFECTIVE_END_DATE%TYPE);
112 --
113 TYPE g_element_entry_rec_type
114 IS RECORD (
115 business_group_id PER_BUSINESS_GROUPS.business_group_id%TYPE
116 ,payroll_id PER_ALL_ASSIGNMENTS_F.payroll_id%TYPE
117 ,element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE
118 ,creator_type PAY_ELEMENT_ENTRIES_F.creator_type%TYPE
119 );
120
121 -- Global variable to set Generic extract date. It is used to allow the extract
122 -- on any given date instead of the sysdate.
123 --
124 g_payroll_extract_date date;
125 --
126 g_reporting_details_rec_var g_reporting_details_rec_type;
127 g_element_entry_rec_var g_element_entry_rec_type;
128
129 -- Global variables to indicate whether attribute1 has been set in the date
130 -- tracked table pay_element_types
131 g_ele_link_id pay_element_entries_f.element_link_id%TYPE;
132 g_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
133 g_ele_start_date pay_element_entries_f.effective_start_date%TYPE;
134 g_ele_person_id per_all_people_f.person_id%TYPE;
135
136 -- Global variable g_personal_payment_method_id used to store the payment
137 -- method of the personal_payment_method to be deleted.
138 g_personal_payment_method_id
139 pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
140 g_ppm_ass_id
141 pay_personal_payment_methods_f.assignment_id%TYPE;
142 g_ppm_start_date
143 pay_personal_payment_methods_f.effective_start_date%TYPE;
144
145 -- Global variable g_cost_allocation_id used to store the cost
146 -- allocation id of the cost allocation to be deleted.
147 g_cost_allocation_id
148 pay_cost_allocations_f.cost_allocation_id%TYPE;
149 g_asg_cost_ass_id
150 pay_cost_allocations_f.assignment_id%TYPE;
151 g_asg_cost_start_date
152 pay_cost_allocations_f.effective_start_date%TYPE;
153
154 --Procedure set_ele_var_ids is used to set the globals g_elem_link_id, and
155 --g_ele_entry_id which are used by the trigger hr_adp_ele_entry_value_brd
156 PROCEDURE set_ele_var_ids(p_ele_link_id
157 pay_element_entries_f.element_link_id%TYPE,
158 p_ele_entry_id
159 pay_element_entries_f.element_entry_id%TYPE,
160 p_ele_start_date
161 pay_element_entries_f.effective_start_date%TYPE,
162 p_ele_person_id
163 per_all_people_f.person_id%TYPE);
164
165 --
166 procedure disable_ele_entry_delete;
167 --
168 procedure disable_emp_number_update (p_old_emp_number varchar2 default null,
169 p_new_emp_number varchar2 default null);
170 --
171 procedure chk_reporting_name_uniqueness ;
172 --
173 FUNCTION get_hot_default(p_input_value_id number
174 ,p_element_link_id number)
175 RETURN VARCHAR2;
176 PRAGMA RESTRICT_REFERENCES(get_hot_default, WNPS, WNDS);
177 --
178 procedure set_extract_date(p_payroll_extract_date in date);
179 --
180 function get_extract_date return date;
181 pragma restrict_references(get_extract_date, WNDS, WNDS);
182 --
183 procedure disable_ppm_update (p_old_priority varchar2 default null,
184 p_new_priority varchar2 default null);
185 procedure disable_ppm_delete_purge;
186 --
187 procedure disable_asg_cost_delete_purge;
188 --
189 --
190 --
191 END HR_PAY_INTERFACE_PKG ;