DBA Data[Home] [Help]

APPS.HR_AMEUTIL_SS dependencies on HR_API_TRANSACTIONS

Line 5: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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

Line 58: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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

Line 63: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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

Line 88: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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)

Line 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;

Line 179: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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)

Line 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)

Line 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)