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_COMPETENCE_ELEMENT_SWI dependencies on HR_API

Line 33: ,p_competence_type in varchar2 default hr_api.g_varchar2

29: -- ----------------------------------------------------------------------------
30: PROCEDURE copy_competencies
31: (p_activity_version_from in number
32: ,p_activity_version_to in number
33: ,p_competence_type in varchar2 default hr_api.g_varchar2
34: ,p_validate in number default hr_api.g_false_num
35: ,p_return_status out nocopy varchar2
36: );
37: -- ----------------------------------------------------------------------------

Line 34: ,p_validate in number default hr_api.g_false_num

30: PROCEDURE copy_competencies
31: (p_activity_version_from in number
32: ,p_activity_version_to in number
33: ,p_competence_type in varchar2 default hr_api.g_varchar2
34: ,p_validate in number default hr_api.g_false_num
35: ,p_return_status out nocopy varchar2
36: );
37: -- ----------------------------------------------------------------------------
38: -- |-----------------------< create_competence_element >----------------------|

Line 61: (p_validate in number default hr_api.g_false_num

57: --
58: -- {End of comments}
59: -- ----------------------------------------------------------------------------
60: PROCEDURE create_competence_element
61: (p_validate in number default hr_api.g_false_num
62: ,p_competence_element_id in number
63: ,p_object_version_number out nocopy number
64: ,p_type in varchar2
65: ,p_business_group_id in number default null

Line 148: (p_validate in number default hr_api.g_false_num

144: --
145: -- {End of comments}
146: -- ----------------------------------------------------------------------------
147: PROCEDURE delete_competence_element
148: (p_validate in number default hr_api.g_false_num
149: ,p_competence_element_id in number
150: ,p_object_version_number in number
151: ,p_return_status out nocopy varchar2
152: );

Line 189: ,p_validate in number default hr_api.g_false_num

185: ,p_next_certification_date in date
186: ,p_source_of_proficiency_level in varchar2
187: ,p_comments in varchar2
188: ,p_effective_date in date
189: ,p_validate in number default hr_api.g_false_num
190: ,p_competence_created out nocopy number
191: ,p_return_status out nocopy varchar2
192: );
193: -- ----------------------------------------------------------------------------

Line 222: ,p_competence_id in number default hr_api.g_number

218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_competence_element
220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number

Line 223: ,p_proficiency_level_id in number default hr_api.g_number

219: PROCEDURE update_competence_element
220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2

Line 224: ,p_high_proficiency_level_id in number default hr_api.g_number

220: (p_competence_element_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date

Line 225: ,p_weighting_level_id in number default hr_api.g_number

221: ,p_object_version_number in out nocopy number
222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date

Line 226: ,p_rating_level_id in number default hr_api.g_number

222: ,p_competence_id in number default hr_api.g_number
223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2

Line 227: ,p_mandatory in varchar2 default hr_api.g_varchar2

223: ,p_proficiency_level_id in number default hr_api.g_number
224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2

Line 228: ,p_effective_date_from in date default hr_api.g_date

224: ,p_high_proficiency_level_id in number default hr_api.g_number
225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number

Line 229: ,p_effective_date_to in date default hr_api.g_date

225: ,p_weighting_level_id in number default hr_api.g_number
226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2

Line 230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2

226: ,p_rating_level_id in number default hr_api.g_number
227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number

Line 231: ,p_competence_type in varchar2 default hr_api.g_varchar2

227: ,p_mandatory in varchar2 default hr_api.g_varchar2
228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2

Line 232: ,p_normal_elapse_duration in number default hr_api.g_number

228: ,p_effective_date_from in date default hr_api.g_date
229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number

Line 233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2

229: ,p_effective_date_to in date default hr_api.g_date
230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date

Line 234: ,p_sequence_number in number default hr_api.g_number

230: ,p_group_competence_type in varchar2 default hr_api.g_varchar2
231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2

Line 235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2

231: ,p_competence_type in varchar2 default hr_api.g_varchar2
232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date

Line 236: ,p_line_score in number default hr_api.g_number

232: ,p_normal_elapse_duration in number default hr_api.g_number
233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2

Line 237: ,p_certification_date in date default hr_api.g_date

233: ,p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2
234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 238: ,p_certification_method in varchar2 default hr_api.g_varchar2

234: ,p_sequence_number in number default hr_api.g_number
235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 239: ,p_next_certification_date in date default hr_api.g_date

235: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 240: ,p_comments in varchar2 default hr_api.g_varchar2

236: ,p_line_score in number default hr_api.g_number
237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute_category in varchar2 default hr_api.g_varchar2

237: ,p_certification_date in date default hr_api.g_date
238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute1 in varchar2 default hr_api.g_varchar2

238: ,p_certification_method in varchar2 default hr_api.g_varchar2
239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute2 in varchar2 default hr_api.g_varchar2

239: ,p_next_certification_date in date default hr_api.g_date
240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute3 in varchar2 default hr_api.g_varchar2

240: ,p_comments in varchar2 default hr_api.g_varchar2
241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute4 in varchar2 default hr_api.g_varchar2

241: ,p_attribute_category in varchar2 default hr_api.g_varchar2
242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute5 in varchar2 default hr_api.g_varchar2

242: ,p_attribute1 in varchar2 default hr_api.g_varchar2
243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute6 in varchar2 default hr_api.g_varchar2

243: ,p_attribute2 in varchar2 default hr_api.g_varchar2
244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute7 in varchar2 default hr_api.g_varchar2

244: ,p_attribute3 in varchar2 default hr_api.g_varchar2
245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute8 in varchar2 default hr_api.g_varchar2

245: ,p_attribute4 in varchar2 default hr_api.g_varchar2
246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute9 in varchar2 default hr_api.g_varchar2

246: ,p_attribute5 in varchar2 default hr_api.g_varchar2
247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute10 in varchar2 default hr_api.g_varchar2

247: ,p_attribute6 in varchar2 default hr_api.g_varchar2
248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute11 in varchar2 default hr_api.g_varchar2

248: ,p_attribute7 in varchar2 default hr_api.g_varchar2
249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute12 in varchar2 default hr_api.g_varchar2

249: ,p_attribute8 in varchar2 default hr_api.g_varchar2
250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute13 in varchar2 default hr_api.g_varchar2

250: ,p_attribute9 in varchar2 default hr_api.g_varchar2
251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute14 in varchar2 default hr_api.g_varchar2

251: ,p_attribute10 in varchar2 default hr_api.g_varchar2
252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute15 in varchar2 default hr_api.g_varchar2

252: ,p_attribute11 in varchar2 default hr_api.g_varchar2
253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute16 in varchar2 default hr_api.g_varchar2

253: ,p_attribute12 in varchar2 default hr_api.g_varchar2
254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute17 in varchar2 default hr_api.g_varchar2

254: ,p_attribute13 in varchar2 default hr_api.g_varchar2
255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date

Line 259: ,p_attribute18 in varchar2 default hr_api.g_varchar2

255: ,p_attribute14 in varchar2 default hr_api.g_varchar2
256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num

Line 260: ,p_attribute19 in varchar2 default hr_api.g_varchar2

256: ,p_attribute15 in varchar2 default hr_api.g_varchar2
257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number

Line 261: ,p_attribute20 in varchar2 default hr_api.g_varchar2

257: ,p_attribute16 in varchar2 default hr_api.g_varchar2
258: ,p_attribute17 in varchar2 default hr_api.g_varchar2
259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2

Line 263: ,p_validate in number default hr_api.g_false_num

259: ,p_attribute18 in varchar2 default hr_api.g_varchar2
260: ,p_attribute19 in varchar2 default hr_api.g_varchar2
261: ,p_attribute20 in varchar2 default hr_api.g_varchar2
262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number

Line 266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction

262: ,p_effective_date in date
263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number
268: ,p_status in varchar2 default null
269: );
270: -- ----------------------------------------------------------------------------

Line 267: ,p_appr_line_score in number default hr_api.g_number

263: ,p_validate in number default hr_api.g_false_num
264: ,p_party_id in number
265: ,p_return_status out nocopy varchar2
266: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction
267: ,p_appr_line_score in number default hr_api.g_number
268: ,p_status in varchar2 default null
269: );
270: -- ----------------------------------------------------------------------------
271: -- |------------------------< update_delivered_dates >------------------------|

Line 299: ,p_validate in number default hr_api.g_false_num

295: ,p_old_start_date in date
296: ,p_start_date in date
297: ,p_old_end_date in date
298: ,p_end_date in date
299: ,p_validate in number default hr_api.g_false_num
300: ,p_return_status out nocopy varchar2
301: );
302: -- ----------------------------------------------------------------------------
303: -- |---------------------< update_personal_comp_element >---------------------|

Line 328: ,p_proficiency_level_id in number default hr_api.g_number

324: -- ----------------------------------------------------------------------------
325: PROCEDURE update_personal_comp_element
326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date

Line 329: ,p_effective_date_from in date default hr_api.g_date

325: PROCEDURE update_personal_comp_element
326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2

Line 330: ,p_effective_date_to in date default hr_api.g_date

326: (p_competence_element_id in number
327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date

Line 331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2

327: ,p_object_version_number in out nocopy number
328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2

Line 332: ,p_certification_date in date default hr_api.g_date

328: ,p_proficiency_level_id in number default hr_api.g_number
329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 333: ,p_certification_method in varchar2 default hr_api.g_varchar2

329: ,p_effective_date_from in date default hr_api.g_date
330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 334: ,p_next_certification_date in date default hr_api.g_date

330: ,p_effective_date_to in date default hr_api.g_date
331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 335: ,p_comments in varchar2 default hr_api.g_varchar2

331: ,p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2
332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 336: ,p_attribute_category in varchar2 default hr_api.g_varchar2

332: ,p_certification_date in date default hr_api.g_date
333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 337: ,p_attribute1 in varchar2 default hr_api.g_varchar2

333: ,p_certification_method in varchar2 default hr_api.g_varchar2
334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 338: ,p_attribute2 in varchar2 default hr_api.g_varchar2

334: ,p_next_certification_date in date default hr_api.g_date
335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 339: ,p_attribute3 in varchar2 default hr_api.g_varchar2

335: ,p_comments in varchar2 default hr_api.g_varchar2
336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 340: ,p_attribute4 in varchar2 default hr_api.g_varchar2

336: ,p_attribute_category in varchar2 default hr_api.g_varchar2
337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 341: ,p_attribute5 in varchar2 default hr_api.g_varchar2

337: ,p_attribute1 in varchar2 default hr_api.g_varchar2
338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 342: ,p_attribute6 in varchar2 default hr_api.g_varchar2

338: ,p_attribute2 in varchar2 default hr_api.g_varchar2
339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 343: ,p_attribute7 in varchar2 default hr_api.g_varchar2

339: ,p_attribute3 in varchar2 default hr_api.g_varchar2
340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 344: ,p_attribute8 in varchar2 default hr_api.g_varchar2

340: ,p_attribute4 in varchar2 default hr_api.g_varchar2
341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 345: ,p_attribute9 in varchar2 default hr_api.g_varchar2

341: ,p_attribute5 in varchar2 default hr_api.g_varchar2
342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 346: ,p_attribute10 in varchar2 default hr_api.g_varchar2

342: ,p_attribute6 in varchar2 default hr_api.g_varchar2
343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 347: ,p_attribute11 in varchar2 default hr_api.g_varchar2

343: ,p_attribute7 in varchar2 default hr_api.g_varchar2
344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute12 in varchar2 default hr_api.g_varchar2

344: ,p_attribute8 in varchar2 default hr_api.g_varchar2
345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 349: ,p_attribute13 in varchar2 default hr_api.g_varchar2

345: ,p_attribute9 in varchar2 default hr_api.g_varchar2
346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 350: ,p_attribute14 in varchar2 default hr_api.g_varchar2

346: ,p_attribute10 in varchar2 default hr_api.g_varchar2
347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 351: ,p_attribute15 in varchar2 default hr_api.g_varchar2

347: ,p_attribute11 in varchar2 default hr_api.g_varchar2
348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 352: ,p_attribute16 in varchar2 default hr_api.g_varchar2

348: ,p_attribute12 in varchar2 default hr_api.g_varchar2
349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 353: ,p_attribute17 in varchar2 default hr_api.g_varchar2

349: ,p_attribute13 in varchar2 default hr_api.g_varchar2
350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date

Line 354: ,p_attribute18 in varchar2 default hr_api.g_varchar2

350: ,p_attribute14 in varchar2 default hr_api.g_varchar2
351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num

Line 355: ,p_attribute19 in varchar2 default hr_api.g_varchar2

351: ,p_attribute15 in varchar2 default hr_api.g_varchar2
352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number

Line 356: ,p_attribute20 in varchar2 default hr_api.g_varchar2

352: ,p_attribute16 in varchar2 default hr_api.g_varchar2
353: ,p_attribute17 in varchar2 default hr_api.g_varchar2
354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number
360: ,p_ins_comp_id out nocopy number

Line 358: ,p_validate in number default hr_api.g_false_num

354: ,p_attribute18 in varchar2 default hr_api.g_varchar2
355: ,p_attribute19 in varchar2 default hr_api.g_varchar2
356: ,p_attribute20 in varchar2 default hr_api.g_varchar2
357: ,p_effective_date in date
358: ,p_validate in number default hr_api.g_false_num
359: ,p_ins_ovn out nocopy number
360: ,p_ins_comp_id out nocopy number
361: ,p_return_status out nocopy varchar2
362: );

Line 371: -- table (hr_api_transaction_step_id) to the base table

367: -- {Start of comments}
368: --
369: -- Description:
370: -- This procedure is responsible for commiting data from transaction
371: -- table (hr_api_transaction_step_id) to the base table
372: --
373: -- Parameters:
374: -- p_document is the document having the data that needs to be committed
375: -- p_return_status is the return status after committing the date. In case of

Line 389: ,p_validate in number default hr_api.g_false_num

385:
386: Procedure process_api
387: ( p_document in CLOB
388: ,p_return_status out nocopy VARCHAR2
389: ,p_validate in number default hr_api.g_false_num
390: ,p_effective_date in date default null
391: );
392:
393: