1 package PER_VIEWS_PKG AUTHID CURRENT_USER as
2 /* $Header: peronvew.pkh 120.2 2007/10/11 11:31:42 asgugupt noship $ */
3
4 /* ==========================================================================
5 FUNCTION NAME : per_get_grade_step
6 DESCRIPTION : Function to get the Grade Step from the Grade Step
7 Placement Information.
8 ========================================================================*/
9 function PER_GET_GRADE_STEP
10 ( p_grade_spine_id NUMBER,
11 p_step_id NUMBER,
12 p_parent_spine_id NUMBER,
13 p_effective_start_date DATE
14 )
15 return number ;
16 pragma restrict_references(PER_GET_GRADE_STEP, WNDS, WNPS);
17
18
19 /* ==========================================================================
20 FUNCTION NAME : per_calc_comparatio
21 DESCRIPTION : Function to Calculate the Salary Comparatio for a given
22 assignment.
23 ========================================================================*/
24 function PER_CALC_COMPARATIO
25 ( p_assignment_id NUMBER,
26 p_change_date DATE,
27 p_actual_salary NUMBER,
28 p_element_entry_id NUMBER,
29 p_normal_hours NUMBER,
30 p_org_working_hours NUMBER,
31 p_pos_working_hours NUMBER,
32 p_org_frequency VARCHAR2,
33 p_pos_frequency VARCHAR2,
34 p_number_per_fiscal_year NUMBER,
35 p_grade_id NUMBER,
36 p_rate_id NUMBER,
37 p_pay_basis VARCHAR2,
38 p_rate_basis VARCHAR2,
39 p_business_group_id NUMBER
40 )
41 return number ;
42 --changes for bug 5945278 starts here
43 --pragma restrict_references(PER_CALC_COMPARATIO, WNDS, WNPS);
44 --changes for bug 5945278 ends here
45 /* ========================================================================
46 FUNCTION NAME : per_get_parent_org
47 DESCRIPTION : Function to get the Parent Organization of a given
48 Organization in the specified hierarchy version.
49 ========================================================================*/
50 function PER_GET_PARENT_ORG
51 ( p_org_child number,
52 p_level number,
53 p_business_group_id number,
54 p_org_structure_version_id number
55 )
56 return number ;
57 pragma restrict_references(PER_GET_PARENT_ORG, WNDS, WNPS);
58
59 /* ========================================================================
60 FUNCTION NAME : per_get_effective_end_date
61 DESCRIPTION : Function to get the effective end date of an assignment
62 from the assignment history view.
63 ========================================================================*/
64 function PER_GET_EFFECTIVE_END_DATE
65 ( p_assignment_id number,
66 p_effective_start_date date
67 )
68 return date ;
69 --pragma restrict_references(PER_GET_EFFECTIVE_END_DATE, WNDS, WNPS);
70
71 /* ========================================================================
72 FUNCTION NAME : per_get_organization_employees
73 DESCRIPTION : Function to get the number of employees working in the
74 specified organization.
75 ========================================================================*/
76 function PER_GET_ORGANIZATION_EMPLOYEES
77 ( p_organization_id number
78 )
79 return number ;
80 pragma restrict_references(PER_GET_ORGANIZATION_EMPLOYEES,WNDS,WNPS) ;
81
82 /* ========================================================================
83 FUNCTION NAME : per_get_element_accrual
84 DESCRIPTION : Function to get the accrued value of a particular element
85 of an accrual plan for an assignment.
86 ========================================================================*/
87 FUNCTION per_get_element_accrual
88 ( P_assignment_id number,
89 P_calculation_date date,
90 P_input_value_id number,
91 P_plan_id number DEFAULT NULL,
92 P_plan_category varchar2 DEFAULT NULL)
93 RETURN Number;
94 pragma restrict_references(per_get_element_accrual, WNDS, WNPS);
95
96 /* ========================================================================
97 FUNCTION NAME : per_get_accrual
98 DESCRIPTION : Function to get the current accrued balance value for an
99 assignment.
100 ========================================================================*/
101 FUNCTION per_get_accrual
102 ( P_assignment_id number,
103 P_calculation_date date,
104 P_plan_id number DEFAULT NULL,
105 P_plan_category varchar2 DEFAULT NULL)
106 RETURN Number;
107 pragma restrict_references(per_get_accrual, WNDS, WNPS);
108
109 /* ========================================================================
110 PROCEDURE NAME : per_accrual_calc_detail
111 DESCRIPTION : Procedure called by all the accrual functions to
112 calculate accrual dates and value for an assignment.
113 ========================================================================*/
114 PROCEDURE per_accrual_calc_detail
115 (P_assignment_id IN number,
116 P_calculation_date IN OUT NOCOPY date,
117 P_plan_id IN number DEFAULT NULL,
118 P_plan_category IN varchar2 DEFAULT NULL,
119 P_mode IN varchar2 DEFAULT 'N',
120 P_accrual OUT NOCOPY number,
121 P_payroll_id IN OUT NOCOPY number,
122 P_first_period_start IN OUT NOCOPY date,
123 P_first_period_end IN OUT NOCOPY date,
124 P_last_period_start IN OUT NOCOPY date,
125 P_last_period_end IN OUT NOCOPY date,
126 P_cont_service_date OUT NOCOPY date,
127 P_start_date OUT NOCOPY date,
128 P_end_date OUT NOCOPY date,
129 P_current_ceiling OUT NOCOPY number,
130 P_current_carry_over OUT NOCOPY number);
131 pragma restrict_references(per_accrual_calc_detail, WNDS, WNPS);
132
133 /* ========================================================================
134 PROCEDURE NAME : per_get_accrual_for_plan
135 DESCRIPTION : Procedure called by the accrual functions to calculate
136 tha accrued value for a particular plan.
137 ========================================================================*/
138 PROCEDURE per_get_accrual_for_plan
139 ( p_plan_id Number,
140 p_first_p_start_date date,
141 p_first_p_end_date date,
142 p_first_calc_P_number number,
143 p_accrual_calc_p_end_date date,
144 P_accrual_calc_P_number number,
145 P_number_of_periods number,
146 P_payroll_id number,
147 P_assignment_id number,
148 P_plan_ele_type_id number,
149 P_continuous_service_date date,
150 P_Plan_accrual OUT NOCOPY number,
151 P_current_ceiling OUT NOCOPY number,
152 P_current_carry_over OUT NOCOPY number );
153 pragma restrict_references(per_get_accrual_for_plan, WNDS, WNPS);
154
155 /* ========================================================================
156 FUNCTION NAME : per_get_working_days
157 DESCRIPTION : Function to get the number of working days between the
158 dates in the given range.
159 ========================================================================*/
160 FUNCTION per_get_working_days
161 ( P_start_date date,
162 P_end_date date )
163 RETURN NUMBER;
164 pragma restrict_references(per_get_working_days, WNDS, WNPS);
165
166 /* ========================================================================
167 FUNCTION NAME : per_get_net_accrual
168 DESCRIPTION : Function to get the total accrured balance for a given
169 assignment.
170 ========================================================================*/
171 FUNCTION per_get_net_accrual
172 ( P_assignment_id number,
173 P_calculation_date date,
174 P_plan_id number default null,
175 P_plan_category Varchar2 default null)
176 RETURN NUMBER;
177 pragma restrict_references(per_get_net_accrual, WNDS, WNPS);
178
179 /* ========================================================================
180 PROCEDURE NAME : per_net_accruals
181 DESCRIPTION : Procedure called by the PER_NET_ACCRUALS function to
182 calculate the total accrued balance.
183 ========================================================================*/
184 PROCEDURE per_net_accruals
185 (P_assignment_id IN number,
186 P_calculation_date IN OUT NOCOPY date,
187 P_plan_id IN number DEFAULT NULL,
188 P_plan_category IN varchar2 DEFAULT NULL,
189 P_mode IN varchar2 DEFAULT 'N',
190 P_accrual IN OUT NOCOPY number,
191 P_net_accrual OUT NOCOPY number,
192 P_payroll_id IN OUT NOCOPY number,
193 P_first_period_start IN OUT NOCOPY date,
194 P_first_period_end IN OUT NOCOPY date,
195 P_last_period_start IN OUT NOCOPY date,
196 P_last_period_end IN OUT NOCOPY date,
197 P_cont_service_date OUT NOCOPY date,
198 P_start_date IN OUT NOCOPY date,
199 P_end_date IN OUT NOCOPY date,
200 P_current_ceiling OUT NOCOPY number,
201 P_current_carry_over OUT NOCOPY number);
202 pragma restrict_references(per_net_accruals, WNDS, WNPS);
203 --
204 end PER_VIEWS_PKG ;