1: PACKAGE HR_AMEUTIL_SS AUTHID CURRENT_USER AS
2: /* $Header: hrameutlss.pkh 120.0.12010000.3 2008/08/18 12:50:58 schowdhu ship $ */
3:
4: function get_item_type
5: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
6: return varchar2;
7:
8: function get_item_key
9: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
5: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
6: return varchar2;
7:
8: function get_item_key
9: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
10: return varchar2;
11:
12: function get_process_name
13: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
9: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
10: return varchar2;
11:
12: function get_process_name
13: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
14: return varchar2 ;
15:
16: FUNCTION get_requestor_person_id
17: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
13: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
14: return varchar2 ;
15:
16: FUNCTION get_requestor_person_id
17: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
18: return number;
19:
20: FUNCTION get_selected_person_id
21: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
17: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
18: return number;
19:
20: FUNCTION get_selected_person_id
21: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
22: return varchar2;
23:
24: function get_sel_person_assignment_id
25: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
21: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
22: return varchar2;
23:
24: function get_sel_person_assignment_id
25: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
26: return number;
27:
28: FUNCTION get_payrate_step_id
29: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
25: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
26: return number;
27:
28: FUNCTION get_payrate_step_id
29: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
30: return number ;
31:
32: FUNCTION isChangePay
33: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
29: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
30: return number ;
31:
32: FUNCTION isChangePay
33: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
34: return varchar2;
35:
36: FUNCTION get_assignment_step_id
37: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
33: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
34: return varchar2;
35:
36: FUNCTION get_assignment_step_id
37: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
38: return number;
39:
40: FUNCTION isAssignmentChange
41: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
37: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
38: return number;
39:
40: FUNCTION isAssignmentChange
41: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
42: return varchar2;
43:
44: FUNCTION get_supeversior_Chg_step_id
45: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
41: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
42: return varchar2;
43:
44: FUNCTION get_supeversior_Chg_step_id
45: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
46: return number;
47:
48: FUNCTION isSupervisorChange
49: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
45: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
46: return number;
47:
48: FUNCTION isSupervisorChange
49: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
50: return varchar2;
51:
52: FUNCTION get_termination_step_id
53: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
49: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
50: return varchar2;
51:
52: FUNCTION get_termination_step_id
53: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
54: return number;
55:
56:
57: FUNCTION isTermination
54: return number;
55:
56:
57: FUNCTION isTermination
58: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
59: return varchar2;
60:
61:
62: FUNCTION get_loa_step_id
59: return varchar2;
60:
61:
62: FUNCTION get_loa_step_id
63: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
64: return number ;
65:
66: FUNCTION get_length_of_service
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
63: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
64: return number ;
65:
66: FUNCTION get_length_of_service
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
68: return number;
69:
70: FUNCTION get_salary_percent_change
71: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
68: return number;
69:
70: FUNCTION get_salary_percent_change
71: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
72: return number ;
73:
74: FUNCTION get_salary_amount_change
75: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
72: return number ;
73:
74: FUNCTION get_salary_amount_change
75: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
76: return varchar2;
77:
78: FUNCTION get_transaction_init_date
79: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
75: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
76: return varchar2;
77:
78: FUNCTION get_transaction_init_date
79: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
80: return varchar2;
81:
82: FUNCTION get_transaction_effective_date
83: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
79: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
80: return varchar2;
81:
82: FUNCTION get_transaction_effective_date
83: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
84: return varchar2 ;
85:
86:
87: FUNCTION get_sel_person_prop_sup_id
84: return varchar2 ;
85:
86:
87: FUNCTION get_sel_person_prop_sup_id
88: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
89: return varchar2;
90:
91: FUNCTION get_proposed_job_id
92: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
88: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
89: return varchar2;
90:
91: FUNCTION get_proposed_job_id
92: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
93: return varchar2;
94:
95: FUNCTION get_proposed_position_id
96: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
92: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
93: return varchar2;
94:
95: FUNCTION get_proposed_position_id
96: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
97: return varchar2;
98:
99: FUNCTION get_proposed_grade_id
100: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
96: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
97: return varchar2;
98:
99: FUNCTION get_proposed_grade_id
100: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
101: return varchar2;
102:
103: FUNCTION get_proposed_location_id
104: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
100: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
101: return varchar2;
102:
103: FUNCTION get_proposed_location_id
104: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
105: return varchar2;
106:
107: FUNCTION get_appraisal_type
108: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
104: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
105: return varchar2;
106:
107: FUNCTION get_appraisal_type
108: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
109: return varchar2 ;
110:
111: FUNCTION get_overall_appraisal_rating
112: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
108: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
109: return varchar2 ;
110:
111: FUNCTION get_overall_appraisal_rating
112: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
113: return number;
114:
115: FUNCTION isLOAChange
116: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
112: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
113: return number;
114:
115: FUNCTION isLOAChange
116: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
117: return varchar2;
118:
119: FUNCTION get_absence_type_id
120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
116: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
117: return varchar2;
118:
119: FUNCTION get_absence_type_id
120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
121: return number;
122:
123: FUNCTION get_proposed_payroll_id
124: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
121: return number;
122:
123: FUNCTION get_proposed_payroll_id
124: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
125: return varchar2;
126:
127: FUNCTION get_proposed_salary_basis
128: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
124: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
125: return varchar2;
126:
127: FUNCTION get_proposed_salary_basis
128: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
129: return varchar2 ;
130:
131: FUNCTION get_asg_change_reason
132: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
128: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
129: return varchar2 ;
130:
131: FUNCTION get_asg_change_reason
132: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
133: return varchar2;
134:
135: FUNCTION get_leaving_reason
136: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
132: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
133: return varchar2;
134:
135: FUNCTION get_leaving_reason
136: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
137: return varchar2 ;
138:
139: FUNCTION get_assignment_category
140: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
136: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
137: return varchar2 ;
138:
139: FUNCTION get_assignment_category
140: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
141: return varchar2;
142:
143: FUNCTION get_basic_details_step_id
144: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
140: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
141: return varchar2;
142:
143: FUNCTION get_basic_details_step_id
144: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
145: return number;
146:
147: FUNCTION isPersonDetailsChange
148: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
144: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
145: return number;
146:
147: FUNCTION isPersonDetailsChange
148: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
149: return varchar2;
150:
151: FUNCTION get_person_address_step_id
152: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
148: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
149: return varchar2;
150:
151: FUNCTION get_person_address_step_id
152: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
153: return number;
154:
155: FUNCTION isPersonAddressChange
156: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
152: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
153: return number;
154:
155: FUNCTION isPersonAddressChange
156: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
157: return varchar2 ;
158:
159: FUNCTION get_person_contact_step_id
160: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
156: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
157: return varchar2 ;
158:
159: FUNCTION get_person_contact_step_id
160: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
161: return number;
162:
163: FUNCTION isPersonContactChange
164: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
160: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
161: return number;
162:
163: FUNCTION isPersonContactChange
164: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
165: return varchar2;
166:
167: FUNCTION get_caed_step_id
168: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
164: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
165: return varchar2;
166:
167: FUNCTION get_caed_step_id
168: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
169: return number;
170:
171: FUNCTION isReleaseInformation
172: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
168: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
169: return number;
170:
171: FUNCTION isReleaseInformation
172: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
173: return varchar2;
174:
175: FUNCTION get_paybasis_id
176: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
172: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
173: return varchar2;
174:
175: FUNCTION get_paybasis_id
176: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
177: return number;
178: FUNCTION getRequestorPositionId
179: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
180: return number;
175: FUNCTION get_paybasis_id
176: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
177: return number;
178: FUNCTION getRequestorPositionId
179: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
180: return number;
181:
182: FUNCTION get_payroll_con_user_name
183: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
179: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
180: return number;
181:
182: FUNCTION get_payroll_con_user_name
183: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
184: return varchar2;
185:
186: FUNCTION isMidPayPayPeriodChange
187: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
183: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
184: return varchar2;
185:
186: FUNCTION isMidPayPayPeriodChange
187: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
188: return varchar2 ;
189:
190: FUNCTION is_new_change_pay
191: (p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE)