1 PACKAGE PER_SALADMIN_UTILITY AUTHID CURRENT_USER AS
2 /* $Header: pesalutl.pkh 120.11.12010000.2 2009/12/03 09:29:52 vkodedal ship $ */
3
4 -- =============================================================================
5 -- ~Global variables:
6 -- =============================================================================
7 g_proposal_rec per_pay_proposals%ROWTYPE;
8 g_new_sal_value number;
9
10
11
12 PROCEDURE get_sal_on_basis_chg
13 (p_assignment_id in number,
14 p_new_pay_basis_id in number,
15 p_effective_date in date,
16 p_old_pay_basis_id in number,
17 p_curr_payroll_id in number);
18
19 Procedure adjust_pay_proposals
20 (
21 p_assignment_id number
22 );
23
24 /**
25 PROCEDURE get_sal_on_basis_chg
26 (p_assignment_id in number,
27 p_pay_basis_id in number);
28 **/
29 procedure insert_pay_proposal(p_assignment_id in number, p_validation_start_date in date);
30
31 function Check_GSP_Manual_Override(p_assignment_id in NUMBER, p_effective_date in DATE)
32 RETURN VARCHAR2;
33
34
35 function get_grd_max_pay(p_assignment_id in NUMBER
36 ,p_business_group_id in NUMBER
37 ,p_effective_date in date)
38 return number;
39
40 function get_grd_min_pay(p_assignment_id in NUMBER
41 ,p_business_group_id in NUMBER
42 ,p_effective_date in date)
43 return number;
44
45
46 FUNCTION get_currency_format (p_assignment_id IN NUMBER, p_change_date IN DATE)
47 RETURN VARCHAR2;
48
49
50
51 FUNCTION get_query_only
52 return VARCHAR2;
53
54 FUNCTION get_next_sal_review_date(p_assignment_id IN NUMBER,p_change_date IN DATE,p_business_group_id IN NUMBER)
55 RETURN DATE;
56
57 FUNCTION get_uom(p_pay_proposal_id IN NUMBER)
58 RETURN VARCHAR2;
59
60 Function get_previous_proposal_dt(p_assignment_id IN NUMBER,p_change_date IN DATE)
61 return date;
62
63
64
65 FUNCTION get_fte (p_assignment_id IN NUMBER, p_effective_date IN DATE)
66 RETURN NUMBER;
67
68 FUNCTION GET_ANNUALIZATION_FACTOR(p_assignment_id NUMBER,p_effective_date DATE)
69 RETURN number;
70
71 FUNCTION get_basis_currency_code (p_assignment_id IN NUMBER,p_effective_date IN DATE )
72 RETURN VARCHAR2;
73
74 FUNCTION decode_grade_ladder ( p_grade_ladder_id IN NUMBER , p_effective_date IN DATE)
75 RETURN VARCHAR2;
76
77 FUNCTION get_annual_salary (
78 p_proposed_salary IN NUMBER,
79 p_assignment_id IN NUMBER,
80 p_change_date IN DATE
81 )
82 RETURN NUMBER;
83
84
85 FUNCTION get_grade (p_assignment_id IN NUMBER,p_effective_date IN DATE )
86 RETURN VARCHAR2;
87
88 FUNCTION get_grade_currency (p_grade_id in number,p_rate_id in number,p_effective_date in date,p_business_group_id in number )
89 RETURN VARCHAR2;
90
91 FUNCTION get_pay_basis_frequency (p_assignment_id IN NUMBER,p_lookup_type IN varchar2,p_lookup_code IN varchar2,p_effective_date IN date )
92 RETURN VARCHAR2;
93
94 FUNCTION get_lookup_desc ( p_lookup_type IN VARCHAR2,p_lookup_code IN VARCHAR2)
95 RETURN VARCHAR2;
96
97 FUNCTION get_pay_annualization_factor (p_assignment_id IN NUMBER, p_effective_date IN DATE, p_annualization_factor IN NUMBER, p_pay_basis IN VARCHAR2)
98 RETURN NUMBER;
99
100 FUNCTION get_currency (p_assignment_id IN NUMBER, p_change_date IN DATE)
101 RETURN VARCHAR2;
102
103 FUNCTION get_pay_basis (p_assignment_id IN NUMBER, p_change_date IN DATE)
104 RETURN VARCHAR2;
105
106 FUNCTION get_change_amount (p_assignment_id IN NUMBER,p_proposal_id IN NUMBER,p_proposed_salary in number)
107 RETURN NUMBER;
108
109 Function get_next_sal_basis_chg_dt(p_assignment_id IN NUMBER, p_from_date IN DATE)
110 return date;
111
112 FUNCTION get_proposed_salary (p_assignment_id IN NUMBER,p_effective_date IN DATE )
113 RETURN NUMBER;
114
115 FUNCTION get_change_percent (p_assignment_id IN NUMBER,p_proposal_id IN NUMBER,p_proposed_salary in number)
116 RETURN NUMBER;
117
118 Function get_previous_salary(p_assignment_id IN NUMBER,p_proposal_id in number)
119 return number;
120
121 function get_last_payroll_dt(p_assignment_id NUMBER) RETURN date;
122
123 function get_currency_rate(
124 p_from_currency VARCHAR2,
125 p_to_currency VARCHAR2,
126 p_conversion_date DATE,
127 p_business_group_id number) return number;
128
129 FUNCTION get_fte_factor(p_assignment_id IN NUMBER
130 ,p_effective_date IN DATE)
131 return NUMBER;
132
133 Function asg_pay_proposal_starts_at(p_assignment_id IN NUMBER, p_date in date)
134 return varchar2;
135
136 Function get_initial_proposal_start(p_assignment_id IN NUMBER)
137 return date;
138
139 function get_assignment_fte(p_assignment_id number, p_effective_date date) return number;
140
141 FUNCTION get_basis_lookup (p_assignment_id IN NUMBER, p_change_date IN DATE)
142 RETURN VARCHAR2;
143
144 FUNCTION get_pay_basis_id(p_assignment_id IN NUMBER, p_from_date IN DATE)
145 RETURN NUMBER;
146
147 Function get_asg_sal_basis_end_dt(p_assignment_id IN NUMBER, p_from_date IN DATE)
148 return date;
149
150 function get_next_proposal_with_comp(p_assignment_id in number,
151 p_session_date in date)
152 return date;
153
154 ------
155 ----------called from core HR on Criteria change
156 -------
157 procedure handle_asg_crit_change
158 (p_assignment_id in number,
159 p_effective_date in date);
160
161 END PER_SALADMIN_UTILITY;
162