[Home] [Help]
PACKAGE: APPS.HRENTMNT
Source
1 package hrentmnt AUTHID CURRENT_USER as
2 /* $Header: pyentmnt.pkh 120.3 2011/12/20 14:53:37 asnell ship $ */
3 --
4 type t_date_table is table of date
5 index by binary_integer;
6 --
7 ------------------------------------------------------------------------------
8 -- NAME --
9 -- hrentmnt.check_payroll_changes_asg --
10 -- --
11 -- DESCRIPTION --
12 -- Makes sure that payroll exists for the lifetime of the assignment that --
13 -- uses it and also makes sure that no assignment actions are orphaned by a --
14 -- change in payroll. --
15 ------------------------------------------------------------------------------
16 --
17 procedure check_payroll_changes_asg
18 (
19 p_assignment_id number,
20 p_payroll_id number,
21 p_dt_mode varchar2,
22 p_validation_start_date date,
23 p_validation_end_date date
24 );
25 --
26 ------------------------------------------------------------------------------
27 -- NAME --
28 -- hrentmnt.maintain_entries_el --
29 -- --
30 -- DESCRIPTION --
31 -- Creates element entries on creation of a standard element link. --
32 ------------------------------------------------------------------------------
33 --
34 procedure maintain_entries_el
35 (
36 p_business_group_id number,
37 p_element_link_id number,
38 p_element_type_id number,
39 p_effective_start_date date,
40 p_effective_end_date date,
41 p_payroll_id number,
42 p_link_to_all_payrolls_flag varchar2,
43 p_job_id number,
44 p_grade_id number,
45 p_position_id number,
46 p_organization_id number,
47 p_location_id number,
48 p_pay_basis_id number,
49 p_employment_category varchar2,
50 p_people_group_id number,
51 p_assignment_id number default null
52 );
53 --
54 ------------------------------------------------------------------------------
55 -- NAME --
56 -- hrentmnt.maintain_entries_asg --
57 -- --
58 -- DESCRIPTION --
59 -- This forms the interface into the procedures that maintain element --
60 -- entries when affected by various events ie. --
61 -- --
62 -- CHANGE_PQC : changes in personal qualifying conditions. --
63 -- CNCL_TERM : a termination is cancelled. --
64 -- CNCL_HIRE : the hiring of a person is cancelled. --
65 -- ASG_CRITERIA : assignment criteria has chnaged. --
66 ------------------------------------------------------------------------------
67 --
68 procedure maintain_entries_asg
69 (
70 p_assignment_id number,
71 p_old_payroll_id number,
72 p_new_payroll_id number,
73 p_business_group_id number,
74 p_operation varchar2,
75 p_actual_term_date date,
76 p_last_standard_date date,
77 p_final_process_date date,
78 p_dt_mode varchar2,
79 p_validation_start_date date,
80 p_validation_end_date date,
81 p_entries_changed in out nocopy varchar2,
82 p_old_hire_date date default null,
83 p_old_people_group_id number ,
84 p_new_people_group_id number ,
85 p_old_organization_id number ,
86 p_new_organization_id number ,
87 p_old_job_id number default null,
88 p_new_job_id number default null,
89 p_new_position_id number default null,
90 p_old_position_id number default null,
91 p_new_location_id number default null,
92 p_old_location_id number default null,
93 p_new_grade_id number default null,
94 p_old_grade_id number default null,
95 p_new_pay_basis_id number default null,
96 p_old_pay_basis_id number default null,
97 p_old_employment_category varchar2 default null,
98 p_new_employment_category varchar2 default null
99 );
100 ------------------------------------------------------------------------------
101 -- NAME --
102 -- hrentmnt.maintain_entries_asg --
103 -- --
104 -- DESCRIPTION --
105 -- This forms the interface into the procedures that maintain element --
106 -- entries when affected by various events ie. --
107 -- --
108 -- CHANGE_PQC : changes in personal qualifying conditions. --
109 -- CNCL_TERM : a termination is cancelled. --
110 -- CNCL_HIRE : the hiring of a person is cancelled. --
111 -- ASG_CRITERIA : assignment criteria has chnaged. --
112 ------------------------------------------------------------------------------
113 --
114 procedure maintain_entries_asg
115 (
116 p_assignment_id number,
117 p_old_payroll_id number,
118 p_new_payroll_id number,
119 p_business_group_id number,
120 p_operation varchar2,
121 p_actual_term_date date,
122 p_last_standard_date date,
123 p_final_process_date date,
124 p_dt_mode varchar2,
125 p_validation_start_date date,
126 p_validation_end_date date,
127 p_entries_changed in out nocopy varchar2,
128 p_old_hire_date date default null,
129 p_old_people_group_id number default null,
130 p_new_people_group_id number default null
131 );
132 --
133 ------------------------------------------------------------------------------
134 -- NAME --
135 -- hrentmnt.maintain_entries_asg --
136 -- --
137 -- DESCRIPTION --
138 -- Overloaded version to allow backward compatibility. --
139 ------------------------------------------------------------------------------
140 --
141 procedure maintain_entries_asg
142 (
143 p_assignment_id number,
144 p_business_group_id number,
145 p_operation varchar2,
146 p_actual_term_date date,
147 p_last_standard_date date,
148 p_final_process_date date,
149 p_dt_mode varchar2,
150 p_validation_start_date date,
151 p_validation_end_date date
152 );
153 --
154 ------------------------------------------------------------------------------
155 -- NAME --
156 -- hrentmnt.check_opmu --
157 -- --
158 -- DESCRIPTION --
159 -- Ensures that on transfer of Payroll (on the Assignment) or when a change --
160 -- causes the Payroll to change in the future that Personal Payment Methods --
161 -- have corresponding Org Pay Methods that are used by the new Payroll. --
162 -- i.e. that Personal Payment Methods are not invalidated. --
163 ------------------------------------------------------------------------------
164 --
165 procedure check_opmu
166 (
167 p_assignment_id number,
168 p_payroll_id number,
169 p_dt_mode varchar2,
170 p_validation_start_date date,
171 p_validation_end_date date
172 );
173 --
174
175 --
176 ------------------------------------------------------------------------------
177 -- NAME --
178 -- hr_entry_api.move_fpd_entries --
179 -- --
180 -- DESCRIPTION --
181 -- This procedure should be called from HR code to carry out entry changes --
182 -- when final process date is changed. --
183 -- --
184 -- PARAMETERS --
185 -- p_assignment_id - Assignemnt for which the entry changes are to --
186 -- be done. --
187 -- p_period_of_service_id - period_of_service_id of the assignment. --
188 -- p_new_final_process_date - New final process date. --
189 -- p_old_final_process_date - Old final process date.
190 ------------------------------------------------------------------------------
191 procedure move_fpd_entries
192 (
193 p_assignment_id in number
194 ,p_period_of_service_id in number
195 ,p_new_final_process_date in date
196 ,p_old_final_process_date in date
197 );
198 --
199 end hrentmnt;