1 PACKAGE PER_SSHR_CHANGE_PAY AUTHID CURRENT_USER as
2 /* $Header: pepypshr.pkh 120.14.12010000.2 2010/01/12 10:39:17 vkodedal ship $ */
3 --
4 --
5 Procedure get_pay_transaction
6 (p_item_type in varchar2,
7 p_item_key in varchar2,
8 p_activity_id in number,
9 p_login_person_id in number,
10 p_api_name in varchar2,
11 p_effective_date_option in varchar2 default null,
12 p_transaction_id out nocopy number,
13 p_transaction_step_id out nocopy number,
14 p_update_mode out nocopy boolean);
15 --
16 Procedure get_transaction_step
17 (p_item_type in varchar2,
18 p_item_key in varchar2,
19 p_activity_id in number,
20 p_login_person_id in number,
21 p_api_name in varchar2,
22 p_transaction_id out nocopy number,
23 p_transaction_step_id out nocopy number,
24 p_update_mode out nocopy varchar2,
25 p_effective_date_option in varchar2);
26 --
27 Procedure process_pay_api(
28 p_validate in varchar2,
29 p_transaction_step_id in number,
30 p_effective_date in date default null,
31 p_new_hire_flag in varchar2 default null,
32 p_item_key in varchar2 default null,
33 p_item_type in varchar2 default null,
34 p_assignment_id in varchar2 default null);
35 --
36 Procedure process_api(
37 p_validate in boolean default false,
38 p_transaction_step_id in number,
39 p_effective_date in varchar2 default null);
40 --
41 PROCEDURE delete_transaction(p_assgn_id IN number,
42 p_effective_dt IN date,
43 p_transaction_id IN number,
44 p_transaction_step_id IN number,
45 p_item_key IN varchar2,
46 p_item_type IN varchar2,
47 p_next_change_date in date,
48 p_changedt_curr IN date,
49 p_changedt_last IN date default Null,
50 p_failed_to_delete IN OUT NOCOPY varchar2,
51 p_busgroup_id IN number);
52 --
53 Function update_component_transaction(
54 p_pay_transaction_id Number,
55 p_ASSIGNMENT_ID Number,
56 p_change_date date,
57 p_prior_proposed_salary Number default NUll,
58 p_prior_proposal_id Number default NUll,
59 p_prior_transaction_id Number default NUll,
60 p_prior_pay_basis_id Number default NUll,
61 p_update_prior varchar2 default 'N',
62 p_xchg_rate in Number
63 ) return Number;
64 --
65 Procedure update_transaction(
66 p_assgn_id IN number,
67 p_transaction_id IN Number,
68 p_changedate_curr IN date,
69 p_last_change_date IN date,
70 p_busgroup_id IN number);
71 --
72 procedure rollback_transactions(p_assignment_id in Number,
73 p_item_type in varchar2,
74 p_item_key in varchar2,
75 p_status OUT NOCOPY varchar2);
76 --
77 PROCEDURE check_Salary_Basis_Change
78 ( p_assignment_id in NUMBER
79 , p_effective_date in DATE
80 , p_item_key in varchar2
81 , p_allow_change_date out NOCOPY varchar2
82 , p_allow_basis_change out NOCOPY varchar2);
83 --
84 PROCEDURE create_salary_basis_chg_step
85 (p_item_type in varchar2 ,
86 p_item_key in varchar2 ,
87 p_activity_id in number ,
88 P_ASSIGNMENT_ID IN NUMBER ,
89 P_PAY_BASIS_ID IN NUMBER ,
90 P_DATETRACK_UPDATE_MODE IN VARCHAR2 ,
91 P_EFFECTIVE_DATE IN DATE ,
92 P_EFFECTIVE_DATE_OPTION IN VARCHAR2 ,
93 P_LOGIN_PERSON_ID IN NUMBER ,
94 P_APPROVER_ID IN NUMBER default null,
95 P_SAVE_MODE IN VARCHAR2 default null) ;
96 --
97 PROCEDURE get_create_date(p_assignment_id in NUMBER
98 ,p_effective_date in date
99 ,p_transaction_id in NUMBER
100 ,p_create_date out NOCOPY date
101 ,p_default_salary_basis_id out NOCOPY number
102 ,p_allow_basis_change out NOCOPY varchar2
103 ,p_min_create_date out NOCOPY date
104 ,p_allow_date_change out NOCOPY varchar2
105 ,p_allow_create out NOCOPY varchar2
106 ,p_status out NOCOPY NUMBER
107 ,p_basis_default_date out NOCOPY date
108 ,p_basis_default_min_date out NOCOPY date
109 ,p_orig_salary_basis_id out NOCOPY number);
110 --
111 PROCEDURE get_update_param
112 ( p_assignment_id in Number
113 , p_transaction_id in Number
114 , p_current_date in Date
115 , p_previous_date in Date
116 , p_proposal_exists in Varchar2
117 , p_allow_basis_change out NOCOPY varchar2
118 , p_min_update_date out NOCOPY date
119 , p_allow_date_change out NOCOPY varchar2
120 , p_status out NOCOPY Number
121 , p_basis_default_date out NOCOPY date
122 , p_basis_default_min_date out NOCOPY date
123 , p_orig_basis_id out NOCOPY Number);
124 --
125 Procedure get_Create_Date_old(p_assignment_id in NUMBER
126 ,p_effective_date in date
127 ,p_transaction_id in NUMBER
128 ,p_create_date out NOCOPY date
129 ,p_default_salary_basis_id out NOCOPY number
130 ,p_allow_basis_change out NOCOPY varchar2
131 ,p_min_create_date out NOCOPY date
132 ,p_allow_date_change out NOCOPY varchar2
133 ,p_allow_create out NOCOPY varchar2);
134
135 ----12-Jan-2009 vkodedal Bug#9023204 added new proc process_new_hire
136 procedure process_new_hire(
137 p_transaction_step_id in number,
138 p_item_key in varchar2 default null,
139 p_item_type in varchar2 default null);
140 --
141 Function get_payroll_period(p_payroll_id in NUMBER)
142 RETURN VARCHAR2;
143 --
144 FUNCTION get_comp_flex(p_dff_name in varchar2)
145 return VARCHAR2;
146 --
147 FUNCTION get_fte_factor(p_assignment_id IN NUMBER
148 ,p_effective_date IN DATE
149 ,p_transaction_id IN NUMBER)
150 return NUMBER;
151 --
152 function Check_GSP_Manual_Override(p_assignment_id in NUMBER
153 ,p_effective_date in DATE
154 ,p_transaction_id in NUMBER)
155 RETURN VARCHAR2;
156 --
157 --
158 END;