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.PER_CEO_UPD dependencies on PER_CEO_SHD

Line 55: (p_rec in out nocopy per_ceo_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_ceo_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: per_ceo_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_ceo_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_comp_element_outcomes Row
69: --
70: update per_comp_element_outcomes

Line 122: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

118: ,information20 = p_rec.information20
119: ,object_version_number = p_rec.object_version_number
120: where comp_element_outcome_id = p_rec.comp_element_outcome_id;
121: --
122: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception

Line 129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated

Line 130: per_ceo_shd.constraint_error

126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

Line 134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated

Line 135: per_ceo_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

Line 139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

Line 140: per_ceo_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;

Line 143: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;
146: --
147: -- ----------------------------------------------------------------------------

Line 180: (p_rec in per_ceo_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_update
180: (p_rec in per_ceo_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --

Line 225: ,p_rec in per_ceo_shd.g_rec_type

221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update
224: (p_effective_date in date
225: ,p_rec in per_ceo_shd.g_rec_type
226: ) is
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --

Line 333: => per_ceo_shd.g_old_rec.competence_element_id

329: => p_rec.information19
330: ,p_information20
331: => p_rec.information20
332: ,p_competence_element_id_o
333: => per_ceo_shd.g_old_rec.competence_element_id
334: ,p_outcome_id_o
335: => per_ceo_shd.g_old_rec.outcome_id
336: ,p_date_from_o
337: => per_ceo_shd.g_old_rec.date_from

Line 335: => per_ceo_shd.g_old_rec.outcome_id

331: => p_rec.information20
332: ,p_competence_element_id_o
333: => per_ceo_shd.g_old_rec.competence_element_id
334: ,p_outcome_id_o
335: => per_ceo_shd.g_old_rec.outcome_id
336: ,p_date_from_o
337: => per_ceo_shd.g_old_rec.date_from
338: ,p_date_to_o
339: => per_ceo_shd.g_old_rec.date_to

Line 337: => per_ceo_shd.g_old_rec.date_from

333: => per_ceo_shd.g_old_rec.competence_element_id
334: ,p_outcome_id_o
335: => per_ceo_shd.g_old_rec.outcome_id
336: ,p_date_from_o
337: => per_ceo_shd.g_old_rec.date_from
338: ,p_date_to_o
339: => per_ceo_shd.g_old_rec.date_to
340: ,p_object_version_number_o
341: => per_ceo_shd.g_old_rec.object_version_number

Line 339: => per_ceo_shd.g_old_rec.date_to

335: => per_ceo_shd.g_old_rec.outcome_id
336: ,p_date_from_o
337: => per_ceo_shd.g_old_rec.date_from
338: ,p_date_to_o
339: => per_ceo_shd.g_old_rec.date_to
340: ,p_object_version_number_o
341: => per_ceo_shd.g_old_rec.object_version_number
342: ,p_attribute_category_o
343: => per_ceo_shd.g_old_rec.attribute_category

Line 341: => per_ceo_shd.g_old_rec.object_version_number

337: => per_ceo_shd.g_old_rec.date_from
338: ,p_date_to_o
339: => per_ceo_shd.g_old_rec.date_to
340: ,p_object_version_number_o
341: => per_ceo_shd.g_old_rec.object_version_number
342: ,p_attribute_category_o
343: => per_ceo_shd.g_old_rec.attribute_category
344: ,p_attribute1_o
345: => per_ceo_shd.g_old_rec.attribute1

Line 343: => per_ceo_shd.g_old_rec.attribute_category

339: => per_ceo_shd.g_old_rec.date_to
340: ,p_object_version_number_o
341: => per_ceo_shd.g_old_rec.object_version_number
342: ,p_attribute_category_o
343: => per_ceo_shd.g_old_rec.attribute_category
344: ,p_attribute1_o
345: => per_ceo_shd.g_old_rec.attribute1
346: ,p_attribute2_o
347: => per_ceo_shd.g_old_rec.attribute2

Line 345: => per_ceo_shd.g_old_rec.attribute1

341: => per_ceo_shd.g_old_rec.object_version_number
342: ,p_attribute_category_o
343: => per_ceo_shd.g_old_rec.attribute_category
344: ,p_attribute1_o
345: => per_ceo_shd.g_old_rec.attribute1
346: ,p_attribute2_o
347: => per_ceo_shd.g_old_rec.attribute2
348: ,p_attribute3_o
349: => per_ceo_shd.g_old_rec.attribute3

Line 347: => per_ceo_shd.g_old_rec.attribute2

343: => per_ceo_shd.g_old_rec.attribute_category
344: ,p_attribute1_o
345: => per_ceo_shd.g_old_rec.attribute1
346: ,p_attribute2_o
347: => per_ceo_shd.g_old_rec.attribute2
348: ,p_attribute3_o
349: => per_ceo_shd.g_old_rec.attribute3
350: ,p_attribute4_o
351: => per_ceo_shd.g_old_rec.attribute4

Line 349: => per_ceo_shd.g_old_rec.attribute3

345: => per_ceo_shd.g_old_rec.attribute1
346: ,p_attribute2_o
347: => per_ceo_shd.g_old_rec.attribute2
348: ,p_attribute3_o
349: => per_ceo_shd.g_old_rec.attribute3
350: ,p_attribute4_o
351: => per_ceo_shd.g_old_rec.attribute4
352: ,p_attribute5_o
353: => per_ceo_shd.g_old_rec.attribute5

Line 351: => per_ceo_shd.g_old_rec.attribute4

347: => per_ceo_shd.g_old_rec.attribute2
348: ,p_attribute3_o
349: => per_ceo_shd.g_old_rec.attribute3
350: ,p_attribute4_o
351: => per_ceo_shd.g_old_rec.attribute4
352: ,p_attribute5_o
353: => per_ceo_shd.g_old_rec.attribute5
354: ,p_attribute6_o
355: => per_ceo_shd.g_old_rec.attribute6

Line 353: => per_ceo_shd.g_old_rec.attribute5

349: => per_ceo_shd.g_old_rec.attribute3
350: ,p_attribute4_o
351: => per_ceo_shd.g_old_rec.attribute4
352: ,p_attribute5_o
353: => per_ceo_shd.g_old_rec.attribute5
354: ,p_attribute6_o
355: => per_ceo_shd.g_old_rec.attribute6
356: ,p_attribute7_o
357: => per_ceo_shd.g_old_rec.attribute7

Line 355: => per_ceo_shd.g_old_rec.attribute6

351: => per_ceo_shd.g_old_rec.attribute4
352: ,p_attribute5_o
353: => per_ceo_shd.g_old_rec.attribute5
354: ,p_attribute6_o
355: => per_ceo_shd.g_old_rec.attribute6
356: ,p_attribute7_o
357: => per_ceo_shd.g_old_rec.attribute7
358: ,p_attribute8_o
359: => per_ceo_shd.g_old_rec.attribute8

Line 357: => per_ceo_shd.g_old_rec.attribute7

353: => per_ceo_shd.g_old_rec.attribute5
354: ,p_attribute6_o
355: => per_ceo_shd.g_old_rec.attribute6
356: ,p_attribute7_o
357: => per_ceo_shd.g_old_rec.attribute7
358: ,p_attribute8_o
359: => per_ceo_shd.g_old_rec.attribute8
360: ,p_attribute9_o
361: => per_ceo_shd.g_old_rec.attribute9

Line 359: => per_ceo_shd.g_old_rec.attribute8

355: => per_ceo_shd.g_old_rec.attribute6
356: ,p_attribute7_o
357: => per_ceo_shd.g_old_rec.attribute7
358: ,p_attribute8_o
359: => per_ceo_shd.g_old_rec.attribute8
360: ,p_attribute9_o
361: => per_ceo_shd.g_old_rec.attribute9
362: ,p_attribute10_o
363: => per_ceo_shd.g_old_rec.attribute10

Line 361: => per_ceo_shd.g_old_rec.attribute9

357: => per_ceo_shd.g_old_rec.attribute7
358: ,p_attribute8_o
359: => per_ceo_shd.g_old_rec.attribute8
360: ,p_attribute9_o
361: => per_ceo_shd.g_old_rec.attribute9
362: ,p_attribute10_o
363: => per_ceo_shd.g_old_rec.attribute10
364: ,p_attribute11_o
365: => per_ceo_shd.g_old_rec.attribute11

Line 363: => per_ceo_shd.g_old_rec.attribute10

359: => per_ceo_shd.g_old_rec.attribute8
360: ,p_attribute9_o
361: => per_ceo_shd.g_old_rec.attribute9
362: ,p_attribute10_o
363: => per_ceo_shd.g_old_rec.attribute10
364: ,p_attribute11_o
365: => per_ceo_shd.g_old_rec.attribute11
366: ,p_attribute12_o
367: => per_ceo_shd.g_old_rec.attribute12

Line 365: => per_ceo_shd.g_old_rec.attribute11

361: => per_ceo_shd.g_old_rec.attribute9
362: ,p_attribute10_o
363: => per_ceo_shd.g_old_rec.attribute10
364: ,p_attribute11_o
365: => per_ceo_shd.g_old_rec.attribute11
366: ,p_attribute12_o
367: => per_ceo_shd.g_old_rec.attribute12
368: ,p_attribute13_o
369: => per_ceo_shd.g_old_rec.attribute13

Line 367: => per_ceo_shd.g_old_rec.attribute12

363: => per_ceo_shd.g_old_rec.attribute10
364: ,p_attribute11_o
365: => per_ceo_shd.g_old_rec.attribute11
366: ,p_attribute12_o
367: => per_ceo_shd.g_old_rec.attribute12
368: ,p_attribute13_o
369: => per_ceo_shd.g_old_rec.attribute13
370: ,p_attribute14_o
371: => per_ceo_shd.g_old_rec.attribute14

Line 369: => per_ceo_shd.g_old_rec.attribute13

365: => per_ceo_shd.g_old_rec.attribute11
366: ,p_attribute12_o
367: => per_ceo_shd.g_old_rec.attribute12
368: ,p_attribute13_o
369: => per_ceo_shd.g_old_rec.attribute13
370: ,p_attribute14_o
371: => per_ceo_shd.g_old_rec.attribute14
372: ,p_attribute15_o
373: => per_ceo_shd.g_old_rec.attribute15

Line 371: => per_ceo_shd.g_old_rec.attribute14

367: => per_ceo_shd.g_old_rec.attribute12
368: ,p_attribute13_o
369: => per_ceo_shd.g_old_rec.attribute13
370: ,p_attribute14_o
371: => per_ceo_shd.g_old_rec.attribute14
372: ,p_attribute15_o
373: => per_ceo_shd.g_old_rec.attribute15
374: ,p_attribute16_o
375: => per_ceo_shd.g_old_rec.attribute16

Line 373: => per_ceo_shd.g_old_rec.attribute15

369: => per_ceo_shd.g_old_rec.attribute13
370: ,p_attribute14_o
371: => per_ceo_shd.g_old_rec.attribute14
372: ,p_attribute15_o
373: => per_ceo_shd.g_old_rec.attribute15
374: ,p_attribute16_o
375: => per_ceo_shd.g_old_rec.attribute16
376: ,p_attribute17_o
377: => per_ceo_shd.g_old_rec.attribute17

Line 375: => per_ceo_shd.g_old_rec.attribute16

371: => per_ceo_shd.g_old_rec.attribute14
372: ,p_attribute15_o
373: => per_ceo_shd.g_old_rec.attribute15
374: ,p_attribute16_o
375: => per_ceo_shd.g_old_rec.attribute16
376: ,p_attribute17_o
377: => per_ceo_shd.g_old_rec.attribute17
378: ,p_attribute18_o
379: => per_ceo_shd.g_old_rec.attribute18

Line 377: => per_ceo_shd.g_old_rec.attribute17

373: => per_ceo_shd.g_old_rec.attribute15
374: ,p_attribute16_o
375: => per_ceo_shd.g_old_rec.attribute16
376: ,p_attribute17_o
377: => per_ceo_shd.g_old_rec.attribute17
378: ,p_attribute18_o
379: => per_ceo_shd.g_old_rec.attribute18
380: ,p_attribute19_o
381: => per_ceo_shd.g_old_rec.attribute19

Line 379: => per_ceo_shd.g_old_rec.attribute18

375: => per_ceo_shd.g_old_rec.attribute16
376: ,p_attribute17_o
377: => per_ceo_shd.g_old_rec.attribute17
378: ,p_attribute18_o
379: => per_ceo_shd.g_old_rec.attribute18
380: ,p_attribute19_o
381: => per_ceo_shd.g_old_rec.attribute19
382: ,p_attribute20_o
383: => per_ceo_shd.g_old_rec.attribute20

Line 381: => per_ceo_shd.g_old_rec.attribute19

377: => per_ceo_shd.g_old_rec.attribute17
378: ,p_attribute18_o
379: => per_ceo_shd.g_old_rec.attribute18
380: ,p_attribute19_o
381: => per_ceo_shd.g_old_rec.attribute19
382: ,p_attribute20_o
383: => per_ceo_shd.g_old_rec.attribute20
384: ,p_information_category_o
385: => per_ceo_shd.g_old_rec.information_category

Line 383: => per_ceo_shd.g_old_rec.attribute20

379: => per_ceo_shd.g_old_rec.attribute18
380: ,p_attribute19_o
381: => per_ceo_shd.g_old_rec.attribute19
382: ,p_attribute20_o
383: => per_ceo_shd.g_old_rec.attribute20
384: ,p_information_category_o
385: => per_ceo_shd.g_old_rec.information_category
386: ,p_information1_o
387: => per_ceo_shd.g_old_rec.information1

Line 385: => per_ceo_shd.g_old_rec.information_category

381: => per_ceo_shd.g_old_rec.attribute19
382: ,p_attribute20_o
383: => per_ceo_shd.g_old_rec.attribute20
384: ,p_information_category_o
385: => per_ceo_shd.g_old_rec.information_category
386: ,p_information1_o
387: => per_ceo_shd.g_old_rec.information1
388: ,p_information2_o
389: => per_ceo_shd.g_old_rec.information2

Line 387: => per_ceo_shd.g_old_rec.information1

383: => per_ceo_shd.g_old_rec.attribute20
384: ,p_information_category_o
385: => per_ceo_shd.g_old_rec.information_category
386: ,p_information1_o
387: => per_ceo_shd.g_old_rec.information1
388: ,p_information2_o
389: => per_ceo_shd.g_old_rec.information2
390: ,p_information3_o
391: => per_ceo_shd.g_old_rec.information3

Line 389: => per_ceo_shd.g_old_rec.information2

385: => per_ceo_shd.g_old_rec.information_category
386: ,p_information1_o
387: => per_ceo_shd.g_old_rec.information1
388: ,p_information2_o
389: => per_ceo_shd.g_old_rec.information2
390: ,p_information3_o
391: => per_ceo_shd.g_old_rec.information3
392: ,p_information4_o
393: => per_ceo_shd.g_old_rec.information4

Line 391: => per_ceo_shd.g_old_rec.information3

387: => per_ceo_shd.g_old_rec.information1
388: ,p_information2_o
389: => per_ceo_shd.g_old_rec.information2
390: ,p_information3_o
391: => per_ceo_shd.g_old_rec.information3
392: ,p_information4_o
393: => per_ceo_shd.g_old_rec.information4
394: ,p_information5_o
395: => per_ceo_shd.g_old_rec.information5

Line 393: => per_ceo_shd.g_old_rec.information4

389: => per_ceo_shd.g_old_rec.information2
390: ,p_information3_o
391: => per_ceo_shd.g_old_rec.information3
392: ,p_information4_o
393: => per_ceo_shd.g_old_rec.information4
394: ,p_information5_o
395: => per_ceo_shd.g_old_rec.information5
396: ,p_information6_o
397: => per_ceo_shd.g_old_rec.information6

Line 395: => per_ceo_shd.g_old_rec.information5

391: => per_ceo_shd.g_old_rec.information3
392: ,p_information4_o
393: => per_ceo_shd.g_old_rec.information4
394: ,p_information5_o
395: => per_ceo_shd.g_old_rec.information5
396: ,p_information6_o
397: => per_ceo_shd.g_old_rec.information6
398: ,p_information7_o
399: => per_ceo_shd.g_old_rec.information7

Line 397: => per_ceo_shd.g_old_rec.information6

393: => per_ceo_shd.g_old_rec.information4
394: ,p_information5_o
395: => per_ceo_shd.g_old_rec.information5
396: ,p_information6_o
397: => per_ceo_shd.g_old_rec.information6
398: ,p_information7_o
399: => per_ceo_shd.g_old_rec.information7
400: ,p_information8_o
401: => per_ceo_shd.g_old_rec.information8

Line 399: => per_ceo_shd.g_old_rec.information7

395: => per_ceo_shd.g_old_rec.information5
396: ,p_information6_o
397: => per_ceo_shd.g_old_rec.information6
398: ,p_information7_o
399: => per_ceo_shd.g_old_rec.information7
400: ,p_information8_o
401: => per_ceo_shd.g_old_rec.information8
402: ,p_information9_o
403: => per_ceo_shd.g_old_rec.information9

Line 401: => per_ceo_shd.g_old_rec.information8

397: => per_ceo_shd.g_old_rec.information6
398: ,p_information7_o
399: => per_ceo_shd.g_old_rec.information7
400: ,p_information8_o
401: => per_ceo_shd.g_old_rec.information8
402: ,p_information9_o
403: => per_ceo_shd.g_old_rec.information9
404: ,p_information10_o
405: => per_ceo_shd.g_old_rec.information10

Line 403: => per_ceo_shd.g_old_rec.information9

399: => per_ceo_shd.g_old_rec.information7
400: ,p_information8_o
401: => per_ceo_shd.g_old_rec.information8
402: ,p_information9_o
403: => per_ceo_shd.g_old_rec.information9
404: ,p_information10_o
405: => per_ceo_shd.g_old_rec.information10
406: ,p_information11_o
407: => per_ceo_shd.g_old_rec.information11

Line 405: => per_ceo_shd.g_old_rec.information10

401: => per_ceo_shd.g_old_rec.information8
402: ,p_information9_o
403: => per_ceo_shd.g_old_rec.information9
404: ,p_information10_o
405: => per_ceo_shd.g_old_rec.information10
406: ,p_information11_o
407: => per_ceo_shd.g_old_rec.information11
408: ,p_information12_o
409: => per_ceo_shd.g_old_rec.information12

Line 407: => per_ceo_shd.g_old_rec.information11

403: => per_ceo_shd.g_old_rec.information9
404: ,p_information10_o
405: => per_ceo_shd.g_old_rec.information10
406: ,p_information11_o
407: => per_ceo_shd.g_old_rec.information11
408: ,p_information12_o
409: => per_ceo_shd.g_old_rec.information12
410: ,p_information13_o
411: => per_ceo_shd.g_old_rec.information13

Line 409: => per_ceo_shd.g_old_rec.information12

405: => per_ceo_shd.g_old_rec.information10
406: ,p_information11_o
407: => per_ceo_shd.g_old_rec.information11
408: ,p_information12_o
409: => per_ceo_shd.g_old_rec.information12
410: ,p_information13_o
411: => per_ceo_shd.g_old_rec.information13
412: ,p_information14_o
413: => per_ceo_shd.g_old_rec.information14

Line 411: => per_ceo_shd.g_old_rec.information13

407: => per_ceo_shd.g_old_rec.information11
408: ,p_information12_o
409: => per_ceo_shd.g_old_rec.information12
410: ,p_information13_o
411: => per_ceo_shd.g_old_rec.information13
412: ,p_information14_o
413: => per_ceo_shd.g_old_rec.information14
414: ,p_information15_o
415: => per_ceo_shd.g_old_rec.information15

Line 413: => per_ceo_shd.g_old_rec.information14

409: => per_ceo_shd.g_old_rec.information12
410: ,p_information13_o
411: => per_ceo_shd.g_old_rec.information13
412: ,p_information14_o
413: => per_ceo_shd.g_old_rec.information14
414: ,p_information15_o
415: => per_ceo_shd.g_old_rec.information15
416: ,p_information16_o
417: => per_ceo_shd.g_old_rec.information16

Line 415: => per_ceo_shd.g_old_rec.information15

411: => per_ceo_shd.g_old_rec.information13
412: ,p_information14_o
413: => per_ceo_shd.g_old_rec.information14
414: ,p_information15_o
415: => per_ceo_shd.g_old_rec.information15
416: ,p_information16_o
417: => per_ceo_shd.g_old_rec.information16
418: ,p_information17_o
419: => per_ceo_shd.g_old_rec.information17

Line 417: => per_ceo_shd.g_old_rec.information16

413: => per_ceo_shd.g_old_rec.information14
414: ,p_information15_o
415: => per_ceo_shd.g_old_rec.information15
416: ,p_information16_o
417: => per_ceo_shd.g_old_rec.information16
418: ,p_information17_o
419: => per_ceo_shd.g_old_rec.information17
420: ,p_information18_o
421: => per_ceo_shd.g_old_rec.information18

Line 419: => per_ceo_shd.g_old_rec.information17

415: => per_ceo_shd.g_old_rec.information15
416: ,p_information16_o
417: => per_ceo_shd.g_old_rec.information16
418: ,p_information17_o
419: => per_ceo_shd.g_old_rec.information17
420: ,p_information18_o
421: => per_ceo_shd.g_old_rec.information18
422: ,p_information19_o
423: => per_ceo_shd.g_old_rec.information19

Line 421: => per_ceo_shd.g_old_rec.information18

417: => per_ceo_shd.g_old_rec.information16
418: ,p_information17_o
419: => per_ceo_shd.g_old_rec.information17
420: ,p_information18_o
421: => per_ceo_shd.g_old_rec.information18
422: ,p_information19_o
423: => per_ceo_shd.g_old_rec.information19
424: ,p_information20_o
425: => per_ceo_shd.g_old_rec.information20

Line 423: => per_ceo_shd.g_old_rec.information19

419: => per_ceo_shd.g_old_rec.information17
420: ,p_information18_o
421: => per_ceo_shd.g_old_rec.information18
422: ,p_information19_o
423: => per_ceo_shd.g_old_rec.information19
424: ,p_information20_o
425: => per_ceo_shd.g_old_rec.information20
426: );
427: --

Line 425: => per_ceo_shd.g_old_rec.information20

421: => per_ceo_shd.g_old_rec.information18
422: ,p_information19_o
423: => per_ceo_shd.g_old_rec.information19
424: ,p_information20_o
425: => per_ceo_shd.g_old_rec.information20
426: );
427: --
428: exception
429: --

Line 485: (p_rec in out nocopy per_ceo_shd.g_rec_type

481: --
482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure convert_defs
485: (p_rec in out nocopy per_ceo_shd.g_rec_type
486: ) is
487: --
488: Begin
489: --

Line 497: per_ceo_shd.g_old_rec.competence_element_id;

493: -- is being used then we must set to the 'current' argument value.
494: --
495: If (p_rec.competence_element_id = hr_api.g_number) then
496: p_rec.competence_element_id :=
497: per_ceo_shd.g_old_rec.competence_element_id;
498: End If;
499: If (p_rec.outcome_id = hr_api.g_number) then
500: p_rec.outcome_id :=
501: per_ceo_shd.g_old_rec.outcome_id;

Line 501: per_ceo_shd.g_old_rec.outcome_id;

497: per_ceo_shd.g_old_rec.competence_element_id;
498: End If;
499: If (p_rec.outcome_id = hr_api.g_number) then
500: p_rec.outcome_id :=
501: per_ceo_shd.g_old_rec.outcome_id;
502: End If;
503: If (p_rec.date_from = hr_api.g_date) then
504: p_rec.date_from :=
505: per_ceo_shd.g_old_rec.date_from;

Line 505: per_ceo_shd.g_old_rec.date_from;

501: per_ceo_shd.g_old_rec.outcome_id;
502: End If;
503: If (p_rec.date_from = hr_api.g_date) then
504: p_rec.date_from :=
505: per_ceo_shd.g_old_rec.date_from;
506: End If;
507: If (p_rec.date_to = hr_api.g_date) then
508: p_rec.date_to :=
509: per_ceo_shd.g_old_rec.date_to;

Line 509: per_ceo_shd.g_old_rec.date_to;

505: per_ceo_shd.g_old_rec.date_from;
506: End If;
507: If (p_rec.date_to = hr_api.g_date) then
508: p_rec.date_to :=
509: per_ceo_shd.g_old_rec.date_to;
510: End If;
511: If (p_rec.attribute_category = hr_api.g_varchar2) then
512: p_rec.attribute_category :=
513: per_ceo_shd.g_old_rec.attribute_category;

Line 513: per_ceo_shd.g_old_rec.attribute_category;

509: per_ceo_shd.g_old_rec.date_to;
510: End If;
511: If (p_rec.attribute_category = hr_api.g_varchar2) then
512: p_rec.attribute_category :=
513: per_ceo_shd.g_old_rec.attribute_category;
514: End If;
515: If (p_rec.attribute1 = hr_api.g_varchar2) then
516: p_rec.attribute1 :=
517: per_ceo_shd.g_old_rec.attribute1;

Line 517: per_ceo_shd.g_old_rec.attribute1;

513: per_ceo_shd.g_old_rec.attribute_category;
514: End If;
515: If (p_rec.attribute1 = hr_api.g_varchar2) then
516: p_rec.attribute1 :=
517: per_ceo_shd.g_old_rec.attribute1;
518: End If;
519: If (p_rec.attribute2 = hr_api.g_varchar2) then
520: p_rec.attribute2 :=
521: per_ceo_shd.g_old_rec.attribute2;

Line 521: per_ceo_shd.g_old_rec.attribute2;

517: per_ceo_shd.g_old_rec.attribute1;
518: End If;
519: If (p_rec.attribute2 = hr_api.g_varchar2) then
520: p_rec.attribute2 :=
521: per_ceo_shd.g_old_rec.attribute2;
522: End If;
523: If (p_rec.attribute3 = hr_api.g_varchar2) then
524: p_rec.attribute3 :=
525: per_ceo_shd.g_old_rec.attribute3;

Line 525: per_ceo_shd.g_old_rec.attribute3;

521: per_ceo_shd.g_old_rec.attribute2;
522: End If;
523: If (p_rec.attribute3 = hr_api.g_varchar2) then
524: p_rec.attribute3 :=
525: per_ceo_shd.g_old_rec.attribute3;
526: End If;
527: If (p_rec.attribute4 = hr_api.g_varchar2) then
528: p_rec.attribute4 :=
529: per_ceo_shd.g_old_rec.attribute4;

Line 529: per_ceo_shd.g_old_rec.attribute4;

525: per_ceo_shd.g_old_rec.attribute3;
526: End If;
527: If (p_rec.attribute4 = hr_api.g_varchar2) then
528: p_rec.attribute4 :=
529: per_ceo_shd.g_old_rec.attribute4;
530: End If;
531: If (p_rec.attribute5 = hr_api.g_varchar2) then
532: p_rec.attribute5 :=
533: per_ceo_shd.g_old_rec.attribute5;

Line 533: per_ceo_shd.g_old_rec.attribute5;

529: per_ceo_shd.g_old_rec.attribute4;
530: End If;
531: If (p_rec.attribute5 = hr_api.g_varchar2) then
532: p_rec.attribute5 :=
533: per_ceo_shd.g_old_rec.attribute5;
534: End If;
535: If (p_rec.attribute6 = hr_api.g_varchar2) then
536: p_rec.attribute6 :=
537: per_ceo_shd.g_old_rec.attribute6;

Line 537: per_ceo_shd.g_old_rec.attribute6;

533: per_ceo_shd.g_old_rec.attribute5;
534: End If;
535: If (p_rec.attribute6 = hr_api.g_varchar2) then
536: p_rec.attribute6 :=
537: per_ceo_shd.g_old_rec.attribute6;
538: End If;
539: If (p_rec.attribute7 = hr_api.g_varchar2) then
540: p_rec.attribute7 :=
541: per_ceo_shd.g_old_rec.attribute7;

Line 541: per_ceo_shd.g_old_rec.attribute7;

537: per_ceo_shd.g_old_rec.attribute6;
538: End If;
539: If (p_rec.attribute7 = hr_api.g_varchar2) then
540: p_rec.attribute7 :=
541: per_ceo_shd.g_old_rec.attribute7;
542: End If;
543: If (p_rec.attribute8 = hr_api.g_varchar2) then
544: p_rec.attribute8 :=
545: per_ceo_shd.g_old_rec.attribute8;

Line 545: per_ceo_shd.g_old_rec.attribute8;

541: per_ceo_shd.g_old_rec.attribute7;
542: End If;
543: If (p_rec.attribute8 = hr_api.g_varchar2) then
544: p_rec.attribute8 :=
545: per_ceo_shd.g_old_rec.attribute8;
546: End If;
547: If (p_rec.attribute9 = hr_api.g_varchar2) then
548: p_rec.attribute9 :=
549: per_ceo_shd.g_old_rec.attribute9;

Line 549: per_ceo_shd.g_old_rec.attribute9;

545: per_ceo_shd.g_old_rec.attribute8;
546: End If;
547: If (p_rec.attribute9 = hr_api.g_varchar2) then
548: p_rec.attribute9 :=
549: per_ceo_shd.g_old_rec.attribute9;
550: End If;
551: If (p_rec.attribute10 = hr_api.g_varchar2) then
552: p_rec.attribute10 :=
553: per_ceo_shd.g_old_rec.attribute10;

Line 553: per_ceo_shd.g_old_rec.attribute10;

549: per_ceo_shd.g_old_rec.attribute9;
550: End If;
551: If (p_rec.attribute10 = hr_api.g_varchar2) then
552: p_rec.attribute10 :=
553: per_ceo_shd.g_old_rec.attribute10;
554: End If;
555: If (p_rec.attribute11 = hr_api.g_varchar2) then
556: p_rec.attribute11 :=
557: per_ceo_shd.g_old_rec.attribute11;

Line 557: per_ceo_shd.g_old_rec.attribute11;

553: per_ceo_shd.g_old_rec.attribute10;
554: End If;
555: If (p_rec.attribute11 = hr_api.g_varchar2) then
556: p_rec.attribute11 :=
557: per_ceo_shd.g_old_rec.attribute11;
558: End If;
559: If (p_rec.attribute12 = hr_api.g_varchar2) then
560: p_rec.attribute12 :=
561: per_ceo_shd.g_old_rec.attribute12;

Line 561: per_ceo_shd.g_old_rec.attribute12;

557: per_ceo_shd.g_old_rec.attribute11;
558: End If;
559: If (p_rec.attribute12 = hr_api.g_varchar2) then
560: p_rec.attribute12 :=
561: per_ceo_shd.g_old_rec.attribute12;
562: End If;
563: If (p_rec.attribute13 = hr_api.g_varchar2) then
564: p_rec.attribute13 :=
565: per_ceo_shd.g_old_rec.attribute13;

Line 565: per_ceo_shd.g_old_rec.attribute13;

561: per_ceo_shd.g_old_rec.attribute12;
562: End If;
563: If (p_rec.attribute13 = hr_api.g_varchar2) then
564: p_rec.attribute13 :=
565: per_ceo_shd.g_old_rec.attribute13;
566: End If;
567: If (p_rec.attribute14 = hr_api.g_varchar2) then
568: p_rec.attribute14 :=
569: per_ceo_shd.g_old_rec.attribute14;

Line 569: per_ceo_shd.g_old_rec.attribute14;

565: per_ceo_shd.g_old_rec.attribute13;
566: End If;
567: If (p_rec.attribute14 = hr_api.g_varchar2) then
568: p_rec.attribute14 :=
569: per_ceo_shd.g_old_rec.attribute14;
570: End If;
571: If (p_rec.attribute15 = hr_api.g_varchar2) then
572: p_rec.attribute15 :=
573: per_ceo_shd.g_old_rec.attribute15;

Line 573: per_ceo_shd.g_old_rec.attribute15;

569: per_ceo_shd.g_old_rec.attribute14;
570: End If;
571: If (p_rec.attribute15 = hr_api.g_varchar2) then
572: p_rec.attribute15 :=
573: per_ceo_shd.g_old_rec.attribute15;
574: End If;
575: If (p_rec.attribute16 = hr_api.g_varchar2) then
576: p_rec.attribute16 :=
577: per_ceo_shd.g_old_rec.attribute16;

Line 577: per_ceo_shd.g_old_rec.attribute16;

573: per_ceo_shd.g_old_rec.attribute15;
574: End If;
575: If (p_rec.attribute16 = hr_api.g_varchar2) then
576: p_rec.attribute16 :=
577: per_ceo_shd.g_old_rec.attribute16;
578: End If;
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_ceo_shd.g_old_rec.attribute17;

Line 581: per_ceo_shd.g_old_rec.attribute17;

577: per_ceo_shd.g_old_rec.attribute16;
578: End If;
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_ceo_shd.g_old_rec.attribute17;
582: End If;
583: If (p_rec.attribute18 = hr_api.g_varchar2) then
584: p_rec.attribute18 :=
585: per_ceo_shd.g_old_rec.attribute18;

Line 585: per_ceo_shd.g_old_rec.attribute18;

581: per_ceo_shd.g_old_rec.attribute17;
582: End If;
583: If (p_rec.attribute18 = hr_api.g_varchar2) then
584: p_rec.attribute18 :=
585: per_ceo_shd.g_old_rec.attribute18;
586: End If;
587: If (p_rec.attribute19 = hr_api.g_varchar2) then
588: p_rec.attribute19 :=
589: per_ceo_shd.g_old_rec.attribute19;

Line 589: per_ceo_shd.g_old_rec.attribute19;

585: per_ceo_shd.g_old_rec.attribute18;
586: End If;
587: If (p_rec.attribute19 = hr_api.g_varchar2) then
588: p_rec.attribute19 :=
589: per_ceo_shd.g_old_rec.attribute19;
590: End If;
591: If (p_rec.attribute20 = hr_api.g_varchar2) then
592: p_rec.attribute20 :=
593: per_ceo_shd.g_old_rec.attribute20;

Line 593: per_ceo_shd.g_old_rec.attribute20;

589: per_ceo_shd.g_old_rec.attribute19;
590: End If;
591: If (p_rec.attribute20 = hr_api.g_varchar2) then
592: p_rec.attribute20 :=
593: per_ceo_shd.g_old_rec.attribute20;
594: End If;
595: If (p_rec.information_category = hr_api.g_varchar2) then
596: p_rec.information_category :=
597: per_ceo_shd.g_old_rec.information_category;

Line 597: per_ceo_shd.g_old_rec.information_category;

593: per_ceo_shd.g_old_rec.attribute20;
594: End If;
595: If (p_rec.information_category = hr_api.g_varchar2) then
596: p_rec.information_category :=
597: per_ceo_shd.g_old_rec.information_category;
598: End If;
599: If (p_rec.information1 = hr_api.g_varchar2) then
600: p_rec.information1 :=
601: per_ceo_shd.g_old_rec.information1;

Line 601: per_ceo_shd.g_old_rec.information1;

597: per_ceo_shd.g_old_rec.information_category;
598: End If;
599: If (p_rec.information1 = hr_api.g_varchar2) then
600: p_rec.information1 :=
601: per_ceo_shd.g_old_rec.information1;
602: End If;
603: If (p_rec.information2 = hr_api.g_varchar2) then
604: p_rec.information2 :=
605: per_ceo_shd.g_old_rec.information2;

Line 605: per_ceo_shd.g_old_rec.information2;

601: per_ceo_shd.g_old_rec.information1;
602: End If;
603: If (p_rec.information2 = hr_api.g_varchar2) then
604: p_rec.information2 :=
605: per_ceo_shd.g_old_rec.information2;
606: End If;
607: If (p_rec.information3 = hr_api.g_varchar2) then
608: p_rec.information3 :=
609: per_ceo_shd.g_old_rec.information3;

Line 609: per_ceo_shd.g_old_rec.information3;

605: per_ceo_shd.g_old_rec.information2;
606: End If;
607: If (p_rec.information3 = hr_api.g_varchar2) then
608: p_rec.information3 :=
609: per_ceo_shd.g_old_rec.information3;
610: End If;
611: If (p_rec.information4 = hr_api.g_varchar2) then
612: p_rec.information4 :=
613: per_ceo_shd.g_old_rec.information4;

Line 613: per_ceo_shd.g_old_rec.information4;

609: per_ceo_shd.g_old_rec.information3;
610: End If;
611: If (p_rec.information4 = hr_api.g_varchar2) then
612: p_rec.information4 :=
613: per_ceo_shd.g_old_rec.information4;
614: End If;
615: If (p_rec.information5 = hr_api.g_varchar2) then
616: p_rec.information5 :=
617: per_ceo_shd.g_old_rec.information5;

Line 617: per_ceo_shd.g_old_rec.information5;

613: per_ceo_shd.g_old_rec.information4;
614: End If;
615: If (p_rec.information5 = hr_api.g_varchar2) then
616: p_rec.information5 :=
617: per_ceo_shd.g_old_rec.information5;
618: End If;
619: If (p_rec.information6 = hr_api.g_varchar2) then
620: p_rec.information6 :=
621: per_ceo_shd.g_old_rec.information6;

Line 621: per_ceo_shd.g_old_rec.information6;

617: per_ceo_shd.g_old_rec.information5;
618: End If;
619: If (p_rec.information6 = hr_api.g_varchar2) then
620: p_rec.information6 :=
621: per_ceo_shd.g_old_rec.information6;
622: End If;
623: If (p_rec.information7 = hr_api.g_varchar2) then
624: p_rec.information7 :=
625: per_ceo_shd.g_old_rec.information7;

Line 625: per_ceo_shd.g_old_rec.information7;

621: per_ceo_shd.g_old_rec.information6;
622: End If;
623: If (p_rec.information7 = hr_api.g_varchar2) then
624: p_rec.information7 :=
625: per_ceo_shd.g_old_rec.information7;
626: End If;
627: If (p_rec.information8 = hr_api.g_varchar2) then
628: p_rec.information8 :=
629: per_ceo_shd.g_old_rec.information8;

Line 629: per_ceo_shd.g_old_rec.information8;

625: per_ceo_shd.g_old_rec.information7;
626: End If;
627: If (p_rec.information8 = hr_api.g_varchar2) then
628: p_rec.information8 :=
629: per_ceo_shd.g_old_rec.information8;
630: End If;
631: If (p_rec.information9 = hr_api.g_varchar2) then
632: p_rec.information9 :=
633: per_ceo_shd.g_old_rec.information9;

Line 633: per_ceo_shd.g_old_rec.information9;

629: per_ceo_shd.g_old_rec.information8;
630: End If;
631: If (p_rec.information9 = hr_api.g_varchar2) then
632: p_rec.information9 :=
633: per_ceo_shd.g_old_rec.information9;
634: End If;
635: If (p_rec.information10 = hr_api.g_varchar2) then
636: p_rec.information10 :=
637: per_ceo_shd.g_old_rec.information10;

Line 637: per_ceo_shd.g_old_rec.information10;

633: per_ceo_shd.g_old_rec.information9;
634: End If;
635: If (p_rec.information10 = hr_api.g_varchar2) then
636: p_rec.information10 :=
637: per_ceo_shd.g_old_rec.information10;
638: End If;
639: If (p_rec.information11 = hr_api.g_varchar2) then
640: p_rec.information11 :=
641: per_ceo_shd.g_old_rec.information11;

Line 641: per_ceo_shd.g_old_rec.information11;

637: per_ceo_shd.g_old_rec.information10;
638: End If;
639: If (p_rec.information11 = hr_api.g_varchar2) then
640: p_rec.information11 :=
641: per_ceo_shd.g_old_rec.information11;
642: End If;
643: If (p_rec.information12 = hr_api.g_varchar2) then
644: p_rec.information12 :=
645: per_ceo_shd.g_old_rec.information12;

Line 645: per_ceo_shd.g_old_rec.information12;

641: per_ceo_shd.g_old_rec.information11;
642: End If;
643: If (p_rec.information12 = hr_api.g_varchar2) then
644: p_rec.information12 :=
645: per_ceo_shd.g_old_rec.information12;
646: End If;
647: If (p_rec.information13 = hr_api.g_varchar2) then
648: p_rec.information13 :=
649: per_ceo_shd.g_old_rec.information13;

Line 649: per_ceo_shd.g_old_rec.information13;

645: per_ceo_shd.g_old_rec.information12;
646: End If;
647: If (p_rec.information13 = hr_api.g_varchar2) then
648: p_rec.information13 :=
649: per_ceo_shd.g_old_rec.information13;
650: End If;
651: If (p_rec.information14 = hr_api.g_varchar2) then
652: p_rec.information14 :=
653: per_ceo_shd.g_old_rec.information14;

Line 653: per_ceo_shd.g_old_rec.information14;

649: per_ceo_shd.g_old_rec.information13;
650: End If;
651: If (p_rec.information14 = hr_api.g_varchar2) then
652: p_rec.information14 :=
653: per_ceo_shd.g_old_rec.information14;
654: End If;
655: If (p_rec.information15 = hr_api.g_varchar2) then
656: p_rec.information15 :=
657: per_ceo_shd.g_old_rec.information15;

Line 657: per_ceo_shd.g_old_rec.information15;

653: per_ceo_shd.g_old_rec.information14;
654: End If;
655: If (p_rec.information15 = hr_api.g_varchar2) then
656: p_rec.information15 :=
657: per_ceo_shd.g_old_rec.information15;
658: End If;
659: If (p_rec.information16 = hr_api.g_varchar2) then
660: p_rec.information16 :=
661: per_ceo_shd.g_old_rec.information16;

Line 661: per_ceo_shd.g_old_rec.information16;

657: per_ceo_shd.g_old_rec.information15;
658: End If;
659: If (p_rec.information16 = hr_api.g_varchar2) then
660: p_rec.information16 :=
661: per_ceo_shd.g_old_rec.information16;
662: End If;
663: If (p_rec.information17 = hr_api.g_varchar2) then
664: p_rec.information17 :=
665: per_ceo_shd.g_old_rec.information17;

Line 665: per_ceo_shd.g_old_rec.information17;

661: per_ceo_shd.g_old_rec.information16;
662: End If;
663: If (p_rec.information17 = hr_api.g_varchar2) then
664: p_rec.information17 :=
665: per_ceo_shd.g_old_rec.information17;
666: End If;
667: If (p_rec.information18 = hr_api.g_varchar2) then
668: p_rec.information18 :=
669: per_ceo_shd.g_old_rec.information18;

Line 669: per_ceo_shd.g_old_rec.information18;

665: per_ceo_shd.g_old_rec.information17;
666: End If;
667: If (p_rec.information18 = hr_api.g_varchar2) then
668: p_rec.information18 :=
669: per_ceo_shd.g_old_rec.information18;
670: End If;
671: If (p_rec.information19 = hr_api.g_varchar2) then
672: p_rec.information19 :=
673: per_ceo_shd.g_old_rec.information19;

Line 673: per_ceo_shd.g_old_rec.information19;

669: per_ceo_shd.g_old_rec.information18;
670: End If;
671: If (p_rec.information19 = hr_api.g_varchar2) then
672: p_rec.information19 :=
673: per_ceo_shd.g_old_rec.information19;
674: End If;
675: If (p_rec.information20 = hr_api.g_varchar2) then
676: p_rec.information20 :=
677: per_ceo_shd.g_old_rec.information20;

Line 677: per_ceo_shd.g_old_rec.information20;

673: per_ceo_shd.g_old_rec.information19;
674: End If;
675: If (p_rec.information20 = hr_api.g_varchar2) then
676: p_rec.information20 :=
677: per_ceo_shd.g_old_rec.information20;
678: End If;
679: --
680: End convert_defs;
681: --

Line 687: ,p_rec in out nocopy per_ceo_shd.g_rec_type

683: -- |---------------------------------< upd >----------------------------------|
684: -- ----------------------------------------------------------------------------
685: Procedure upd
686: (p_effective_date in date
687: ,p_rec in out nocopy per_ceo_shd.g_rec_type
688: ) is
689: --
690: l_proc varchar2(72) := g_package||'upd';
691: --

Line 697: per_ceo_shd.lck

693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- We must lock the row which we need to update.
696: --
697: per_ceo_shd.lck
698: (p_rec.comp_element_outcome_id
699: ,p_rec.object_version_number
700: );
701: --

Line 791: l_rec per_ceo_shd.g_rec_type;

787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ) is
790: --
791: l_rec per_ceo_shd.g_rec_type;
792: l_proc varchar2(72) := g_package||'upd';
793: --
794: Begin
795: hr_utility.set_location('Entering:'||l_proc, 5);

Line 801: per_ceo_shd.convert_args

797: -- Call conversion function to turn arguments into the
798: -- l_rec structure.
799: --
800: l_rec :=
801: per_ceo_shd.convert_args
802: (p_comp_element_outcome_id
803: ,p_competence_element_id
804: ,p_outcome_id
805: ,p_date_from