1 package hrentmnt as
2 /* $Header: pyentmnt.pkh 120.2.12010000.1 2008/07/27 22:32:04 appldev 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 default null,
84 p_new_people_group_id number default null
85 );
86 --
87 ------------------------------------------------------------------------------
88 -- NAME --
89 -- hrentmnt.maintain_entries_asg --
90 -- --
91 -- DESCRIPTION --
92 -- Overloaded version to allow backward compatibility. --
93 ------------------------------------------------------------------------------
94 --
95 procedure maintain_entries_asg
96 (
97 p_assignment_id number,
98 p_business_group_id number,
99 p_operation varchar2,
100 p_actual_term_date date,
101 p_last_standard_date date,
102 p_final_process_date date,
103 p_dt_mode varchar2,
104 p_validation_start_date date,
105 p_validation_end_date date
106 );
107 --
108 ------------------------------------------------------------------------------
109 -- NAME --
110 -- hrentmnt.check_opmu --
111 -- --
112 -- DESCRIPTION --
113 -- Ensures that on transfer of Payroll (on the Assignment) or when a change --
114 -- causes the Payroll to change in the future that Personal Payment Methods --
115 -- have corresponding Org Pay Methods that are used by the new Payroll. --
116 -- i.e. that Personal Payment Methods are not invalidated. --
117 ------------------------------------------------------------------------------
118 --
119 procedure check_opmu
120 (
121 p_assignment_id number,
122 p_payroll_id number,
123 p_dt_mode varchar2,
124 p_validation_start_date date,
125 p_validation_end_date date
126 );
127 --
128
129 --
130 ------------------------------------------------------------------------------
131 -- NAME --
132 -- hr_entry_api.move_fpd_entries --
133 -- --
134 -- DESCRIPTION --
135 -- This procedure should be called from HR code to carry out entry changes --
136 -- when final process date is changed. --
137 -- --
138 -- PARAMETERS --
139 -- p_assignment_id - Assignemnt for which the entry changes are to --
140 -- be done. --
141 -- p_period_of_service_id - period_of_service_id of the assignment. --
142 -- p_new_final_process_date - New final process date. --
143 -- p_old_final_process_date - Old final process date.
144 ------------------------------------------------------------------------------
145 procedure move_fpd_entries
146 (
147 p_assignment_id in number
148 ,p_period_of_service_id in number
149 ,p_new_final_process_date in date
150 ,p_old_final_process_date in date
151 );
152 --
153 end hrentmnt;