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