eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_MAINTAIN_PROPOSAL_SWI dependencies on HR_API

Line 13: ,p_change_date in date default hr_api.g_date

9: -- |------------------------< approve_salary_proposal >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE approve_salary_proposal
12: (p_pay_proposal_id in number
13: ,p_change_date in date default hr_api.g_date
14: ,p_proposed_salary_n in number default hr_api.g_number
15: ,p_object_version_number in out nocopy number
16: ,p_validate in number default hr_api.g_false_num
17: ,p_error_text out nocopy varchar2

Line 14: ,p_proposed_salary_n in number default hr_api.g_number

10: -- ----------------------------------------------------------------------------
11: PROCEDURE approve_salary_proposal
12: (p_pay_proposal_id in number
13: ,p_change_date in date default hr_api.g_date
14: ,p_proposed_salary_n in number default hr_api.g_number
15: ,p_object_version_number in out nocopy number
16: ,p_validate in number default hr_api.g_false_num
17: ,p_error_text out nocopy varchar2
18: ,p_return_status out nocopy varchar2

Line 16: ,p_validate in number default hr_api.g_false_num

12: (p_pay_proposal_id in number
13: ,p_change_date in date default hr_api.g_date
14: ,p_proposed_salary_n in number default hr_api.g_number
15: ,p_object_version_number in out nocopy number
16: ,p_validate in number default hr_api.g_false_num
17: ,p_error_text out nocopy varchar2
18: ,p_return_status out nocopy varchar2
19: ) is
20: --

Line 51: hr_api.constant_to_boolean

47: --
48: -- Convert constant values to their corresponding boolean value
49: --
50: l_validate :=
51: hr_api.constant_to_boolean
52: (p_constant_value => p_validate);
53: --
54: -- Register Surrogate ID or user key values
55: --

Line 126: (p_validate in number default hr_api.g_false_num

122: -- ----------------------------------------------------------------------------
123: -- |----------------------< cre_or_upd_salary_proposal >----------------------|
124: -- ----------------------------------------------------------------------------
125: PROCEDURE cre_or_upd_salary_proposal
126: (p_validate in number default hr_api.g_false_num
127: ,p_pay_proposal_id in out nocopy number
128: ,p_object_version_number in out nocopy number
129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number

Line 129: ,p_business_group_id in number default hr_api.g_number

125: PROCEDURE cre_or_upd_salary_proposal
126: (p_validate in number default hr_api.g_false_num
127: ,p_pay_proposal_id in out nocopy number
128: ,p_object_version_number in out nocopy number
129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date

Line 130: ,p_assignment_id in number default hr_api.g_number

126: (p_validate in number default hr_api.g_false_num
127: ,p_pay_proposal_id in out nocopy number
128: ,p_object_version_number in out nocopy number
129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2

Line 131: ,p_change_date in date default hr_api.g_date

127: ,p_pay_proposal_id in out nocopy number
128: ,p_object_version_number in out nocopy number
129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number

Line 132: ,p_comments in varchar2 default hr_api.g_varchar2

128: ,p_object_version_number in out nocopy number
129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number

Line 133: ,p_next_sal_review_date in date default hr_api.g_date

129: ,p_business_group_id in number default hr_api.g_number
130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date

Line 134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2

130: ,p_assignment_id in number default hr_api.g_number
131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number

Line 135: ,p_proposed_salary_n in number default hr_api.g_number

131: ,p_change_date in date default hr_api.g_date
132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 136: ,p_forced_ranking in number default hr_api.g_number

132: ,p_comments in varchar2 default hr_api.g_varchar2
133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 137: ,p_date_to in date default hr_api.g_date

133: ,p_next_sal_review_date in date default hr_api.g_date
134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 138: ,p_performance_review_id in number default hr_api.g_number

134: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 139: ,p_attribute_category in varchar2 default hr_api.g_varchar2

135: ,p_proposed_salary_n in number default hr_api.g_number
136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 140: ,p_attribute1 in varchar2 default hr_api.g_varchar2

136: ,p_forced_ranking in number default hr_api.g_number
137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 141: ,p_attribute2 in varchar2 default hr_api.g_varchar2

137: ,p_date_to in date default hr_api.g_date
138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 142: ,p_attribute3 in varchar2 default hr_api.g_varchar2

138: ,p_performance_review_id in number default hr_api.g_number
139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 143: ,p_attribute4 in varchar2 default hr_api.g_varchar2

139: ,p_attribute_category in varchar2 default hr_api.g_varchar2
140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 144: ,p_attribute5 in varchar2 default hr_api.g_varchar2

140: ,p_attribute1 in varchar2 default hr_api.g_varchar2
141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 145: ,p_attribute6 in varchar2 default hr_api.g_varchar2

141: ,p_attribute2 in varchar2 default hr_api.g_varchar2
142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 146: ,p_attribute7 in varchar2 default hr_api.g_varchar2

142: ,p_attribute3 in varchar2 default hr_api.g_varchar2
143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 147: ,p_attribute8 in varchar2 default hr_api.g_varchar2

143: ,p_attribute4 in varchar2 default hr_api.g_varchar2
144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 148: ,p_attribute9 in varchar2 default hr_api.g_varchar2

144: ,p_attribute5 in varchar2 default hr_api.g_varchar2
145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 149: ,p_attribute10 in varchar2 default hr_api.g_varchar2

145: ,p_attribute6 in varchar2 default hr_api.g_varchar2
146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 150: ,p_attribute11 in varchar2 default hr_api.g_varchar2

146: ,p_attribute7 in varchar2 default hr_api.g_varchar2
147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 151: ,p_attribute12 in varchar2 default hr_api.g_varchar2

147: ,p_attribute8 in varchar2 default hr_api.g_varchar2
148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 152: ,p_attribute13 in varchar2 default hr_api.g_varchar2

148: ,p_attribute9 in varchar2 default hr_api.g_varchar2
149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 153: ,p_attribute14 in varchar2 default hr_api.g_varchar2

149: ,p_attribute10 in varchar2 default hr_api.g_varchar2
150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 154: ,p_attribute15 in varchar2 default hr_api.g_varchar2

150: ,p_attribute11 in varchar2 default hr_api.g_varchar2
151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 155: ,p_attribute16 in varchar2 default hr_api.g_varchar2

151: ,p_attribute12 in varchar2 default hr_api.g_varchar2
152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 156: ,p_attribute17 in varchar2 default hr_api.g_varchar2

152: ,p_attribute13 in varchar2 default hr_api.g_varchar2
153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2

Line 157: ,p_attribute18 in varchar2 default hr_api.g_varchar2

153: ,p_attribute14 in varchar2 default hr_api.g_varchar2
154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2
161: ,p_approved in varchar2 default hr_api.g_varchar2

Line 158: ,p_attribute19 in varchar2 default hr_api.g_varchar2

154: ,p_attribute15 in varchar2 default hr_api.g_varchar2
155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2
161: ,p_approved in varchar2 default hr_api.g_varchar2
162: ,p_return_status out nocopy varchar2

Line 159: ,p_attribute20 in varchar2 default hr_api.g_varchar2

155: ,p_attribute16 in varchar2 default hr_api.g_varchar2
156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2
161: ,p_approved in varchar2 default hr_api.g_varchar2
162: ,p_return_status out nocopy varchar2
163: ) is

Line 160: ,p_multiple_components in varchar2 default hr_api.g_varchar2

156: ,p_attribute17 in varchar2 default hr_api.g_varchar2
157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2
161: ,p_approved in varchar2 default hr_api.g_varchar2
162: ,p_return_status out nocopy varchar2
163: ) is
164: --

Line 161: ,p_approved in varchar2 default hr_api.g_varchar2

157: ,p_attribute18 in varchar2 default hr_api.g_varchar2
158: ,p_attribute19 in varchar2 default hr_api.g_varchar2
159: ,p_attribute20 in varchar2 default hr_api.g_varchar2
160: ,p_multiple_components in varchar2 default hr_api.g_varchar2
161: ,p_approved in varchar2 default hr_api.g_varchar2
162: ,p_return_status out nocopy varchar2
163: ) is
164: --
165: -- Variables for API Boolean parameters

Line 197: hr_api.constant_to_boolean

193: --
194: -- Convert constant values to their corresponding boolean value
195: --
196: l_validate :=
197: hr_api.constant_to_boolean
198: (p_constant_value => p_validate);
199: --
200: -- Register Surrogate ID or user key values
201: --

Line 303: ,p_validation_strength in varchar2 default hr_api.g_varchar2

299: -- |-----------------------< delete_proposal_component >----------------------|
300: -- ----------------------------------------------------------------------------
301: PROCEDURE delete_proposal_component
302: (p_component_id in number
303: ,p_validation_strength in varchar2 default hr_api.g_varchar2
304: ,p_object_version_number in number
305: ,p_validate in number default hr_api.g_false_num
306: ,p_return_status out nocopy varchar2
307: ) is

Line 305: ,p_validate in number default hr_api.g_false_num

301: PROCEDURE delete_proposal_component
302: (p_component_id in number
303: ,p_validation_strength in varchar2 default hr_api.g_varchar2
304: ,p_object_version_number in number
305: ,p_validate in number default hr_api.g_false_num
306: ,p_return_status out nocopy varchar2
307: ) is
308: --
309: -- Variables for API Boolean parameters

Line 333: hr_api.constant_to_boolean

329: --
330: -- Convert constant values to their corresponding boolean value
331: --
332: l_validate :=
333: hr_api.constant_to_boolean
334: (p_constant_value => p_validate);
335: --
336: -- Register Surrogate ID or user key values
337: --

Line 401: ,p_validate in number default hr_api.g_false_num

397: PROCEDURE delete_salary_proposal
398: (p_pay_proposal_id in number
399: ,p_business_group_id in number
400: ,p_object_version_number in number
401: ,p_validate in number default hr_api.g_false_num
402: ,p_return_status out nocopy varchar2
403: ) is
404: --
405: -- Variables for API Boolean parameters

Line 430: hr_api.constant_to_boolean

426: --
427: -- Convert constant values to their corresponding boolean value
428: --
429: l_validate :=
430: hr_api.constant_to_boolean
431: (p_constant_value => p_validate);
432: --
433: -- Register Surrogate ID or user key values
434: --

Line 501: ,p_change_amount_n in number default hr_api.g_number

497: ,p_pay_proposal_id in number
498: ,p_business_group_id in number
499: ,p_approved in varchar2
500: ,p_component_reason in varchar2
501: ,p_change_amount_n in number default hr_api.g_number
502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 502: ,p_change_percentage in number default hr_api.g_number

498: ,p_business_group_id in number
499: ,p_approved in varchar2
500: ,p_component_reason in varchar2
501: ,p_change_amount_n in number default hr_api.g_number
502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 503: ,p_comments in varchar2 default hr_api.g_varchar2

499: ,p_approved in varchar2
500: ,p_component_reason in varchar2
501: ,p_change_amount_n in number default hr_api.g_number
502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 504: ,p_attribute_category in varchar2 default hr_api.g_varchar2

500: ,p_component_reason in varchar2
501: ,p_change_amount_n in number default hr_api.g_number
502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 505: ,p_attribute1 in varchar2 default hr_api.g_varchar2

501: ,p_change_amount_n in number default hr_api.g_number
502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 506: ,p_attribute2 in varchar2 default hr_api.g_varchar2

502: ,p_change_percentage in number default hr_api.g_number
503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 507: ,p_attribute3 in varchar2 default hr_api.g_varchar2

503: ,p_comments in varchar2 default hr_api.g_varchar2
504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 508: ,p_attribute4 in varchar2 default hr_api.g_varchar2

504: ,p_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 509: ,p_attribute5 in varchar2 default hr_api.g_varchar2

505: ,p_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 510: ,p_attribute6 in varchar2 default hr_api.g_varchar2

506: ,p_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 511: ,p_attribute7 in varchar2 default hr_api.g_varchar2

507: ,p_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 512: ,p_attribute8 in varchar2 default hr_api.g_varchar2

508: ,p_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 513: ,p_attribute9 in varchar2 default hr_api.g_varchar2

509: ,p_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 514: ,p_attribute10 in varchar2 default hr_api.g_varchar2

510: ,p_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 515: ,p_attribute11 in varchar2 default hr_api.g_varchar2

511: ,p_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 516: ,p_attribute12 in varchar2 default hr_api.g_varchar2

512: ,p_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 517: ,p_attribute13 in varchar2 default hr_api.g_varchar2

513: ,p_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 518: ,p_attribute14 in varchar2 default hr_api.g_varchar2

514: ,p_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 519: ,p_attribute15 in varchar2 default hr_api.g_varchar2

515: ,p_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 520: ,p_attribute16 in varchar2 default hr_api.g_varchar2

516: ,p_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 521: ,p_attribute17 in varchar2 default hr_api.g_varchar2

517: ,p_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2

Line 522: ,p_attribute18 in varchar2 default hr_api.g_varchar2

518: ,p_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2
526: ,p_object_version_number out nocopy number

Line 523: ,p_attribute19 in varchar2 default hr_api.g_varchar2

519: ,p_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2
526: ,p_object_version_number out nocopy number
527: ,p_validate in number default hr_api.g_false_num

Line 524: ,p_attribute20 in varchar2 default hr_api.g_varchar2

520: ,p_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2
526: ,p_object_version_number out nocopy number
527: ,p_validate in number default hr_api.g_false_num
528: ,p_return_status out nocopy varchar2

Line 525: ,p_validation_strength in varchar2 default hr_api.g_varchar2

521: ,p_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2
526: ,p_object_version_number out nocopy number
527: ,p_validate in number default hr_api.g_false_num
528: ,p_return_status out nocopy varchar2
529: ) is

Line 527: ,p_validate in number default hr_api.g_false_num

523: ,p_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_validation_strength in varchar2 default hr_api.g_varchar2
526: ,p_object_version_number out nocopy number
527: ,p_validate in number default hr_api.g_false_num
528: ,p_return_status out nocopy varchar2
529: ) is
530: --
531: -- Variables for API Boolean parameters

Line 555: hr_api.constant_to_boolean

551: --
552: -- Convert constant values to their corresponding boolean value
553: --
554: l_validate :=
555: hr_api.constant_to_boolean
556: (p_constant_value => p_validate);
557: --
558: -- Register Surrogate ID or user key values
559: --

Line 655: ,p_change_date in date default hr_api.g_date

651: PROCEDURE insert_salary_proposal
652: (p_pay_proposal_id in number
653: ,p_assignment_id in number
654: ,p_business_group_id in number
655: ,p_change_date in date default hr_api.g_date
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number

Line 656: ,p_comments in varchar2 default hr_api.g_varchar2

652: (p_pay_proposal_id in number
653: ,p_assignment_id in number
654: ,p_business_group_id in number
655: ,p_change_date in date default hr_api.g_date
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number

Line 657: ,p_next_sal_review_date in date default hr_api.g_date

653: ,p_assignment_id in number
654: ,p_business_group_id in number
655: ,p_change_date in date default hr_api.g_date
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time

Line 658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2

654: ,p_business_group_id in number
655: ,p_change_date in date default hr_api.g_date
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number

Line 659: ,p_proposed_salary_n in number default hr_api.g_number

655: ,p_change_date in date default hr_api.g_date
656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 660: ,p_forced_ranking in number default hr_api.g_number

656: ,p_comments in varchar2 default hr_api.g_varchar2
657: ,p_next_sal_review_date in date default hr_api.g_date
658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 662: ,p_performance_review_id in number default hr_api.g_number

658: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 663: ,p_attribute_category in varchar2 default hr_api.g_varchar2

659: ,p_proposed_salary_n in number default hr_api.g_number
660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 664: ,p_attribute1 in varchar2 default hr_api.g_varchar2

660: ,p_forced_ranking in number default hr_api.g_number
661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 665: ,p_attribute2 in varchar2 default hr_api.g_varchar2

661: ,p_date_to in date default hr_general.end_of_time
662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 666: ,p_attribute3 in varchar2 default hr_api.g_varchar2

662: ,p_performance_review_id in number default hr_api.g_number
663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 667: ,p_attribute4 in varchar2 default hr_api.g_varchar2

663: ,p_attribute_category in varchar2 default hr_api.g_varchar2
664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 668: ,p_attribute5 in varchar2 default hr_api.g_varchar2

664: ,p_attribute1 in varchar2 default hr_api.g_varchar2
665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 669: ,p_attribute6 in varchar2 default hr_api.g_varchar2

665: ,p_attribute2 in varchar2 default hr_api.g_varchar2
666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 670: ,p_attribute7 in varchar2 default hr_api.g_varchar2

666: ,p_attribute3 in varchar2 default hr_api.g_varchar2
667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute8 in varchar2 default hr_api.g_varchar2

667: ,p_attribute4 in varchar2 default hr_api.g_varchar2
668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute9 in varchar2 default hr_api.g_varchar2

668: ,p_attribute5 in varchar2 default hr_api.g_varchar2
669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute10 in varchar2 default hr_api.g_varchar2

669: ,p_attribute6 in varchar2 default hr_api.g_varchar2
670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute11 in varchar2 default hr_api.g_varchar2

670: ,p_attribute7 in varchar2 default hr_api.g_varchar2
671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute12 in varchar2 default hr_api.g_varchar2

671: ,p_attribute8 in varchar2 default hr_api.g_varchar2
672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute13 in varchar2 default hr_api.g_varchar2

672: ,p_attribute9 in varchar2 default hr_api.g_varchar2
673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute14 in varchar2 default hr_api.g_varchar2

673: ,p_attribute10 in varchar2 default hr_api.g_varchar2
674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute15 in varchar2 default hr_api.g_varchar2

674: ,p_attribute11 in varchar2 default hr_api.g_varchar2
675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute16 in varchar2 default hr_api.g_varchar2

675: ,p_attribute12 in varchar2 default hr_api.g_varchar2
676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 680: ,p_attribute17 in varchar2 default hr_api.g_varchar2

676: ,p_attribute13 in varchar2 default hr_api.g_varchar2
677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number

Line 681: ,p_attribute18 in varchar2 default hr_api.g_varchar2

677: ,p_attribute14 in varchar2 default hr_api.g_varchar2
678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2

Line 682: ,p_attribute19 in varchar2 default hr_api.g_varchar2

678: ,p_attribute15 in varchar2 default hr_api.g_varchar2
679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2
686: ,p_approved in varchar2 default hr_api.g_varchar2

Line 683: ,p_attribute20 in varchar2 default hr_api.g_varchar2

679: ,p_attribute16 in varchar2 default hr_api.g_varchar2
680: ,p_attribute17 in varchar2 default hr_api.g_varchar2
681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2
686: ,p_approved in varchar2 default hr_api.g_varchar2
687: ,p_validate in number default hr_api.g_false_num

Line 685: ,p_multiple_components in varchar2 default hr_api.g_varchar2

681: ,p_attribute18 in varchar2 default hr_api.g_varchar2
682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2
686: ,p_approved in varchar2 default hr_api.g_varchar2
687: ,p_validate in number default hr_api.g_false_num
688: ,p_element_entry_id in out nocopy number
689: ,p_return_status out nocopy varchar2

Line 686: ,p_approved in varchar2 default hr_api.g_varchar2

682: ,p_attribute19 in varchar2 default hr_api.g_varchar2
683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2
686: ,p_approved in varchar2 default hr_api.g_varchar2
687: ,p_validate in number default hr_api.g_false_num
688: ,p_element_entry_id in out nocopy number
689: ,p_return_status out nocopy varchar2
690: ) is

Line 687: ,p_validate in number default hr_api.g_false_num

683: ,p_attribute20 in varchar2 default hr_api.g_varchar2
684: ,p_object_version_number out nocopy number
685: ,p_multiple_components in varchar2 default hr_api.g_varchar2
686: ,p_approved in varchar2 default hr_api.g_varchar2
687: ,p_validate in number default hr_api.g_false_num
688: ,p_element_entry_id in out nocopy number
689: ,p_return_status out nocopy varchar2
690: ) is
691: --

Line 730: hr_api.constant_to_boolean

726: --
727: -- Convert constant values to their corresponding boolean value
728: --
729: l_validate :=
730: hr_api.constant_to_boolean
731: (p_constant_value => p_validate);
732: --
733: -- Register Surrogate ID or user key values
734: --

Line 842: ,p_approved in varchar2 default hr_api.g_varchar2

838: -- |-----------------------< update_proposal_component >----------------------|
839: -- ----------------------------------------------------------------------------
840: PROCEDURE update_proposal_component
841: (p_component_id in number
842: ,p_approved in varchar2 default hr_api.g_varchar2
843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2

Line 843: ,p_component_reason in varchar2 default hr_api.g_varchar2

839: -- ----------------------------------------------------------------------------
840: PROCEDURE update_proposal_component
841: (p_component_id in number
842: ,p_approved in varchar2 default hr_api.g_varchar2
843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 844: ,p_change_amount_n in number default hr_api.g_number

840: PROCEDURE update_proposal_component
841: (p_component_id in number
842: ,p_approved in varchar2 default hr_api.g_varchar2
843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 845: ,p_change_percentage in number default hr_api.g_number

841: (p_component_id in number
842: ,p_approved in varchar2 default hr_api.g_varchar2
843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 846: ,p_comments in varchar2 default hr_api.g_varchar2

842: ,p_approved in varchar2 default hr_api.g_varchar2
843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 847: ,p_attribute_category in varchar2 default hr_api.g_varchar2

843: ,p_component_reason in varchar2 default hr_api.g_varchar2
844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 848: ,p_attribute1 in varchar2 default hr_api.g_varchar2

844: ,p_change_amount_n in number default hr_api.g_number
845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 849: ,p_attribute2 in varchar2 default hr_api.g_varchar2

845: ,p_change_percentage in number default hr_api.g_number
846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 850: ,p_attribute3 in varchar2 default hr_api.g_varchar2

846: ,p_comments in varchar2 default hr_api.g_varchar2
847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 851: ,p_attribute4 in varchar2 default hr_api.g_varchar2

847: ,p_attribute_category in varchar2 default hr_api.g_varchar2
848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 852: ,p_attribute5 in varchar2 default hr_api.g_varchar2

848: ,p_attribute1 in varchar2 default hr_api.g_varchar2
849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 853: ,p_attribute6 in varchar2 default hr_api.g_varchar2

849: ,p_attribute2 in varchar2 default hr_api.g_varchar2
850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 854: ,p_attribute7 in varchar2 default hr_api.g_varchar2

850: ,p_attribute3 in varchar2 default hr_api.g_varchar2
851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 855: ,p_attribute8 in varchar2 default hr_api.g_varchar2

851: ,p_attribute4 in varchar2 default hr_api.g_varchar2
852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 856: ,p_attribute9 in varchar2 default hr_api.g_varchar2

852: ,p_attribute5 in varchar2 default hr_api.g_varchar2
853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 857: ,p_attribute10 in varchar2 default hr_api.g_varchar2

853: ,p_attribute6 in varchar2 default hr_api.g_varchar2
854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 858: ,p_attribute11 in varchar2 default hr_api.g_varchar2

854: ,p_attribute7 in varchar2 default hr_api.g_varchar2
855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 859: ,p_attribute12 in varchar2 default hr_api.g_varchar2

855: ,p_attribute8 in varchar2 default hr_api.g_varchar2
856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 860: ,p_attribute13 in varchar2 default hr_api.g_varchar2

856: ,p_attribute9 in varchar2 default hr_api.g_varchar2
857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 861: ,p_attribute14 in varchar2 default hr_api.g_varchar2

857: ,p_attribute10 in varchar2 default hr_api.g_varchar2
858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 862: ,p_attribute15 in varchar2 default hr_api.g_varchar2

858: ,p_attribute11 in varchar2 default hr_api.g_varchar2
859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 863: ,p_attribute16 in varchar2 default hr_api.g_varchar2

859: ,p_attribute12 in varchar2 default hr_api.g_varchar2
860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 864: ,p_attribute17 in varchar2 default hr_api.g_varchar2

860: ,p_attribute13 in varchar2 default hr_api.g_varchar2
861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2

Line 865: ,p_attribute18 in varchar2 default hr_api.g_varchar2

861: ,p_attribute14 in varchar2 default hr_api.g_varchar2
862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2
869: ,p_object_version_number in out nocopy number

Line 866: ,p_attribute19 in varchar2 default hr_api.g_varchar2

862: ,p_attribute15 in varchar2 default hr_api.g_varchar2
863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2
869: ,p_object_version_number in out nocopy number
870: ,p_validate in number default hr_api.g_false_num

Line 867: ,p_attribute20 in varchar2 default hr_api.g_varchar2

863: ,p_attribute16 in varchar2 default hr_api.g_varchar2
864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2
869: ,p_object_version_number in out nocopy number
870: ,p_validate in number default hr_api.g_false_num
871: ,p_return_status out nocopy varchar2

Line 868: ,p_validation_strength in varchar2 default hr_api.g_varchar2

864: ,p_attribute17 in varchar2 default hr_api.g_varchar2
865: ,p_attribute18 in varchar2 default hr_api.g_varchar2
866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2
869: ,p_object_version_number in out nocopy number
870: ,p_validate in number default hr_api.g_false_num
871: ,p_return_status out nocopy varchar2
872: ) is

Line 870: ,p_validate in number default hr_api.g_false_num

866: ,p_attribute19 in varchar2 default hr_api.g_varchar2
867: ,p_attribute20 in varchar2 default hr_api.g_varchar2
868: ,p_validation_strength in varchar2 default hr_api.g_varchar2
869: ,p_object_version_number in out nocopy number
870: ,p_validate in number default hr_api.g_false_num
871: ,p_return_status out nocopy varchar2
872: ) is
873: --
874: -- Variables for API Boolean parameters

Line 900: hr_api.constant_to_boolean

896: --
897: -- Convert constant values to their corresponding boolean value
898: --
899: l_validate :=
900: hr_api.constant_to_boolean
901: (p_constant_value => p_validate);
902: --
903: -- Register Surrogate ID or user key values
904: --

Line 994: ,p_change_date in date default hr_api.g_date

990: -- |------------------------< update_salary_proposal >------------------------|
991: -- ----------------------------------------------------------------------------
992: PROCEDURE update_salary_proposal
993: (p_pay_proposal_id in number
994: ,p_change_date in date default hr_api.g_date
995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number

Line 995: ,p_comments in varchar2 default hr_api.g_varchar2

991: -- ----------------------------------------------------------------------------
992: PROCEDURE update_salary_proposal
993: (p_pay_proposal_id in number
994: ,p_change_date in date default hr_api.g_date
995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number

Line 996: ,p_next_sal_review_date in date default hr_api.g_date

992: PROCEDURE update_salary_proposal
993: (p_pay_proposal_id in number
994: ,p_change_date in date default hr_api.g_date
995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date

Line 997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2

993: (p_pay_proposal_id in number
994: ,p_change_date in date default hr_api.g_date
995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number

Line 998: ,p_proposed_salary_n in number default hr_api.g_number

994: ,p_change_date in date default hr_api.g_date
995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 999: ,p_forced_ranking in number default hr_api.g_number

995: ,p_comments in varchar2 default hr_api.g_varchar2
996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1000: ,p_date_to in date default hr_api.g_date

996: ,p_next_sal_review_date in date default hr_api.g_date
997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_performance_review_id in number default hr_api.g_number

997: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2

998: ,p_proposed_salary_n in number default hr_api.g_number
999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2

999: ,p_forced_ranking in number default hr_api.g_number
1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1000: ,p_date_to in date default hr_api.g_date
1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1001: ,p_performance_review_id in number default hr_api.g_number
1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1002: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1003: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1004: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1005: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1006: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1007: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1008: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1009: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1010: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1011: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1012: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1013: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1014: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1015: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number

Line 1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1016: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2

Line 1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1017: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2
1025: ,p_approved in varchar2 default hr_api.g_varchar2

Line 1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1018: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2
1025: ,p_approved in varchar2 default hr_api.g_varchar2
1026: ,p_validate in number default hr_api.g_false_num

Line 1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2

1020: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2
1025: ,p_approved in varchar2 default hr_api.g_varchar2
1026: ,p_validate in number default hr_api.g_false_num
1027: ,p_return_status out nocopy varchar2
1028: ) is

Line 1025: ,p_approved in varchar2 default hr_api.g_varchar2

1021: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2
1025: ,p_approved in varchar2 default hr_api.g_varchar2
1026: ,p_validate in number default hr_api.g_false_num
1027: ,p_return_status out nocopy varchar2
1028: ) is
1029: --

Line 1026: ,p_validate in number default hr_api.g_false_num

1022: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1023: ,p_object_version_number in out nocopy number
1024: ,p_multiple_components in varchar2 default hr_api.g_varchar2
1025: ,p_approved in varchar2 default hr_api.g_varchar2
1026: ,p_validate in number default hr_api.g_false_num
1027: ,p_return_status out nocopy varchar2
1028: ) is
1029: --
1030: -- Variables for API Boolean parameters

Line 1067: hr_api.constant_to_boolean

1063: --
1064: -- Convert constant values to their corresponding boolean value
1065: --
1066: l_validate :=
1067: hr_api.constant_to_boolean
1068: (p_constant_value => p_validate);
1069: --
1070: -- Register Surrogate ID or user key values
1071: --

Line 1172: ,p_validate in number default hr_api.g_false_num

1168: procedure process_api
1169: (
1170: p_document in CLOB
1171: ,p_return_status out nocopy VARCHAR2
1172: ,p_validate in number default hr_api.g_false_num
1173: ,p_effective_date in date default null
1174: )
1175: IS
1176: l_postState VARCHAR2(2);