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_CKL_UPD dependencies on PER_CKL_SHD

Line 55: (p_rec in out nocopy per_ckl_shd.g_rec_type

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

Line 131: per_ckl_shd.constraint_error

127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: --
131: per_ckl_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --

Line 136: per_ckl_shd.constraint_error

132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: per_ckl_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --

Line 141: per_ckl_shd.constraint_error

137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: per_ckl_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: --
145: Raise;

Line 181: (p_rec in per_ckl_shd.g_rec_type

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

Line 226: ,p_rec in per_ckl_shd.g_rec_type

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

Line 336: => per_ckl_shd.g_old_rec.name

332: => p_rec.information19
333: ,p_information20
334: => p_rec.information20
335: ,p_name_o
336: => per_ckl_shd.g_old_rec.name
337: ,p_description_o
338: => per_ckl_shd.g_old_rec.description
339: ,p_checklist_category_o
340: => per_ckl_shd.g_old_rec.checklist_category

Line 338: => per_ckl_shd.g_old_rec.description

334: => p_rec.information20
335: ,p_name_o
336: => per_ckl_shd.g_old_rec.name
337: ,p_description_o
338: => per_ckl_shd.g_old_rec.description
339: ,p_checklist_category_o
340: => per_ckl_shd.g_old_rec.checklist_category
341: ,p_event_reason_id_o
342: => per_ckl_shd.g_old_rec.event_reason_id

Line 340: => per_ckl_shd.g_old_rec.checklist_category

336: => per_ckl_shd.g_old_rec.name
337: ,p_description_o
338: => per_ckl_shd.g_old_rec.description
339: ,p_checklist_category_o
340: => per_ckl_shd.g_old_rec.checklist_category
341: ,p_event_reason_id_o
342: => per_ckl_shd.g_old_rec.event_reason_id
343: ,p_business_group_id_o
344: => per_ckl_shd.g_old_rec.business_group_id

Line 342: => per_ckl_shd.g_old_rec.event_reason_id

338: => per_ckl_shd.g_old_rec.description
339: ,p_checklist_category_o
340: => per_ckl_shd.g_old_rec.checklist_category
341: ,p_event_reason_id_o
342: => per_ckl_shd.g_old_rec.event_reason_id
343: ,p_business_group_id_o
344: => per_ckl_shd.g_old_rec.business_group_id
345: ,p_object_version_number_o
346: => per_ckl_shd.g_old_rec.object_version_number

Line 344: => per_ckl_shd.g_old_rec.business_group_id

340: => per_ckl_shd.g_old_rec.checklist_category
341: ,p_event_reason_id_o
342: => per_ckl_shd.g_old_rec.event_reason_id
343: ,p_business_group_id_o
344: => per_ckl_shd.g_old_rec.business_group_id
345: ,p_object_version_number_o
346: => per_ckl_shd.g_old_rec.object_version_number
347: ,p_attribute_category_o
348: => per_ckl_shd.g_old_rec.attribute_category

Line 346: => per_ckl_shd.g_old_rec.object_version_number

342: => per_ckl_shd.g_old_rec.event_reason_id
343: ,p_business_group_id_o
344: => per_ckl_shd.g_old_rec.business_group_id
345: ,p_object_version_number_o
346: => per_ckl_shd.g_old_rec.object_version_number
347: ,p_attribute_category_o
348: => per_ckl_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => per_ckl_shd.g_old_rec.attribute1

Line 348: => per_ckl_shd.g_old_rec.attribute_category

344: => per_ckl_shd.g_old_rec.business_group_id
345: ,p_object_version_number_o
346: => per_ckl_shd.g_old_rec.object_version_number
347: ,p_attribute_category_o
348: => per_ckl_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => per_ckl_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => per_ckl_shd.g_old_rec.attribute2

Line 350: => per_ckl_shd.g_old_rec.attribute1

346: => per_ckl_shd.g_old_rec.object_version_number
347: ,p_attribute_category_o
348: => per_ckl_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => per_ckl_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => per_ckl_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => per_ckl_shd.g_old_rec.attribute3

Line 352: => per_ckl_shd.g_old_rec.attribute2

348: => per_ckl_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => per_ckl_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => per_ckl_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => per_ckl_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => per_ckl_shd.g_old_rec.attribute4

Line 354: => per_ckl_shd.g_old_rec.attribute3

350: => per_ckl_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => per_ckl_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => per_ckl_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => per_ckl_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => per_ckl_shd.g_old_rec.attribute5

Line 356: => per_ckl_shd.g_old_rec.attribute4

352: => per_ckl_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => per_ckl_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => per_ckl_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => per_ckl_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => per_ckl_shd.g_old_rec.attribute6

Line 358: => per_ckl_shd.g_old_rec.attribute5

354: => per_ckl_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => per_ckl_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => per_ckl_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => per_ckl_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => per_ckl_shd.g_old_rec.attribute7

Line 360: => per_ckl_shd.g_old_rec.attribute6

356: => per_ckl_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => per_ckl_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => per_ckl_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => per_ckl_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => per_ckl_shd.g_old_rec.attribute8

Line 362: => per_ckl_shd.g_old_rec.attribute7

358: => per_ckl_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => per_ckl_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => per_ckl_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => per_ckl_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => per_ckl_shd.g_old_rec.attribute9

Line 364: => per_ckl_shd.g_old_rec.attribute8

360: => per_ckl_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => per_ckl_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => per_ckl_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => per_ckl_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => per_ckl_shd.g_old_rec.attribute10

Line 366: => per_ckl_shd.g_old_rec.attribute9

362: => per_ckl_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => per_ckl_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => per_ckl_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => per_ckl_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => per_ckl_shd.g_old_rec.attribute11

Line 368: => per_ckl_shd.g_old_rec.attribute10

364: => per_ckl_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => per_ckl_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => per_ckl_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => per_ckl_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => per_ckl_shd.g_old_rec.attribute12

Line 370: => per_ckl_shd.g_old_rec.attribute11

366: => per_ckl_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => per_ckl_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => per_ckl_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => per_ckl_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => per_ckl_shd.g_old_rec.attribute13

Line 372: => per_ckl_shd.g_old_rec.attribute12

368: => per_ckl_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => per_ckl_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => per_ckl_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => per_ckl_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => per_ckl_shd.g_old_rec.attribute14

Line 374: => per_ckl_shd.g_old_rec.attribute13

370: => per_ckl_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => per_ckl_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => per_ckl_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => per_ckl_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => per_ckl_shd.g_old_rec.attribute15

Line 376: => per_ckl_shd.g_old_rec.attribute14

372: => per_ckl_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => per_ckl_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => per_ckl_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => per_ckl_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => per_ckl_shd.g_old_rec.attribute16

Line 378: => per_ckl_shd.g_old_rec.attribute15

374: => per_ckl_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => per_ckl_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => per_ckl_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => per_ckl_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => per_ckl_shd.g_old_rec.attribute17

Line 380: => per_ckl_shd.g_old_rec.attribute16

376: => per_ckl_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => per_ckl_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => per_ckl_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => per_ckl_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => per_ckl_shd.g_old_rec.attribute18

Line 382: => per_ckl_shd.g_old_rec.attribute17

378: => per_ckl_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => per_ckl_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => per_ckl_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => per_ckl_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => per_ckl_shd.g_old_rec.attribute19

Line 384: => per_ckl_shd.g_old_rec.attribute18

380: => per_ckl_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => per_ckl_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => per_ckl_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => per_ckl_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => per_ckl_shd.g_old_rec.attribute20

Line 386: => per_ckl_shd.g_old_rec.attribute19

382: => per_ckl_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => per_ckl_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => per_ckl_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => per_ckl_shd.g_old_rec.attribute20
389: ,p_information_category_o
390: => per_ckl_shd.g_old_rec.information_category

Line 388: => per_ckl_shd.g_old_rec.attribute20

384: => per_ckl_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => per_ckl_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => per_ckl_shd.g_old_rec.attribute20
389: ,p_information_category_o
390: => per_ckl_shd.g_old_rec.information_category
391: ,p_information1_o
392: => per_ckl_shd.g_old_rec.information1

Line 390: => per_ckl_shd.g_old_rec.information_category

386: => per_ckl_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => per_ckl_shd.g_old_rec.attribute20
389: ,p_information_category_o
390: => per_ckl_shd.g_old_rec.information_category
391: ,p_information1_o
392: => per_ckl_shd.g_old_rec.information1
393: ,p_information2_o
394: => per_ckl_shd.g_old_rec.information2

Line 392: => per_ckl_shd.g_old_rec.information1

388: => per_ckl_shd.g_old_rec.attribute20
389: ,p_information_category_o
390: => per_ckl_shd.g_old_rec.information_category
391: ,p_information1_o
392: => per_ckl_shd.g_old_rec.information1
393: ,p_information2_o
394: => per_ckl_shd.g_old_rec.information2
395: ,p_information3_o
396: => per_ckl_shd.g_old_rec.information3

Line 394: => per_ckl_shd.g_old_rec.information2

390: => per_ckl_shd.g_old_rec.information_category
391: ,p_information1_o
392: => per_ckl_shd.g_old_rec.information1
393: ,p_information2_o
394: => per_ckl_shd.g_old_rec.information2
395: ,p_information3_o
396: => per_ckl_shd.g_old_rec.information3
397: ,p_information4_o
398: => per_ckl_shd.g_old_rec.information4

Line 396: => per_ckl_shd.g_old_rec.information3

392: => per_ckl_shd.g_old_rec.information1
393: ,p_information2_o
394: => per_ckl_shd.g_old_rec.information2
395: ,p_information3_o
396: => per_ckl_shd.g_old_rec.information3
397: ,p_information4_o
398: => per_ckl_shd.g_old_rec.information4
399: ,p_information5_o
400: => per_ckl_shd.g_old_rec.information5

Line 398: => per_ckl_shd.g_old_rec.information4

394: => per_ckl_shd.g_old_rec.information2
395: ,p_information3_o
396: => per_ckl_shd.g_old_rec.information3
397: ,p_information4_o
398: => per_ckl_shd.g_old_rec.information4
399: ,p_information5_o
400: => per_ckl_shd.g_old_rec.information5
401: ,p_information6_o
402: => per_ckl_shd.g_old_rec.information6

Line 400: => per_ckl_shd.g_old_rec.information5

396: => per_ckl_shd.g_old_rec.information3
397: ,p_information4_o
398: => per_ckl_shd.g_old_rec.information4
399: ,p_information5_o
400: => per_ckl_shd.g_old_rec.information5
401: ,p_information6_o
402: => per_ckl_shd.g_old_rec.information6
403: ,p_information7_o
404: => per_ckl_shd.g_old_rec.information7

Line 402: => per_ckl_shd.g_old_rec.information6

398: => per_ckl_shd.g_old_rec.information4
399: ,p_information5_o
400: => per_ckl_shd.g_old_rec.information5
401: ,p_information6_o
402: => per_ckl_shd.g_old_rec.information6
403: ,p_information7_o
404: => per_ckl_shd.g_old_rec.information7
405: ,p_information8_o
406: => per_ckl_shd.g_old_rec.information8

Line 404: => per_ckl_shd.g_old_rec.information7

400: => per_ckl_shd.g_old_rec.information5
401: ,p_information6_o
402: => per_ckl_shd.g_old_rec.information6
403: ,p_information7_o
404: => per_ckl_shd.g_old_rec.information7
405: ,p_information8_o
406: => per_ckl_shd.g_old_rec.information8
407: ,p_information9_o
408: => per_ckl_shd.g_old_rec.information9

Line 406: => per_ckl_shd.g_old_rec.information8

402: => per_ckl_shd.g_old_rec.information6
403: ,p_information7_o
404: => per_ckl_shd.g_old_rec.information7
405: ,p_information8_o
406: => per_ckl_shd.g_old_rec.information8
407: ,p_information9_o
408: => per_ckl_shd.g_old_rec.information9
409: ,p_information10_o
410: => per_ckl_shd.g_old_rec.information10

Line 408: => per_ckl_shd.g_old_rec.information9

404: => per_ckl_shd.g_old_rec.information7
405: ,p_information8_o
406: => per_ckl_shd.g_old_rec.information8
407: ,p_information9_o
408: => per_ckl_shd.g_old_rec.information9
409: ,p_information10_o
410: => per_ckl_shd.g_old_rec.information10
411: ,p_information11_o
412: => per_ckl_shd.g_old_rec.information11

Line 410: => per_ckl_shd.g_old_rec.information10

406: => per_ckl_shd.g_old_rec.information8
407: ,p_information9_o
408: => per_ckl_shd.g_old_rec.information9
409: ,p_information10_o
410: => per_ckl_shd.g_old_rec.information10
411: ,p_information11_o
412: => per_ckl_shd.g_old_rec.information11
413: ,p_information12_o
414: => per_ckl_shd.g_old_rec.information12

Line 412: => per_ckl_shd.g_old_rec.information11

408: => per_ckl_shd.g_old_rec.information9
409: ,p_information10_o
410: => per_ckl_shd.g_old_rec.information10
411: ,p_information11_o
412: => per_ckl_shd.g_old_rec.information11
413: ,p_information12_o
414: => per_ckl_shd.g_old_rec.information12
415: ,p_information13_o
416: => per_ckl_shd.g_old_rec.information13

Line 414: => per_ckl_shd.g_old_rec.information12

410: => per_ckl_shd.g_old_rec.information10
411: ,p_information11_o
412: => per_ckl_shd.g_old_rec.information11
413: ,p_information12_o
414: => per_ckl_shd.g_old_rec.information12
415: ,p_information13_o
416: => per_ckl_shd.g_old_rec.information13
417: ,p_information14_o
418: => per_ckl_shd.g_old_rec.information14

Line 416: => per_ckl_shd.g_old_rec.information13

412: => per_ckl_shd.g_old_rec.information11
413: ,p_information12_o
414: => per_ckl_shd.g_old_rec.information12
415: ,p_information13_o
416: => per_ckl_shd.g_old_rec.information13
417: ,p_information14_o
418: => per_ckl_shd.g_old_rec.information14
419: ,p_information15_o
420: => per_ckl_shd.g_old_rec.information15

Line 418: => per_ckl_shd.g_old_rec.information14

414: => per_ckl_shd.g_old_rec.information12
415: ,p_information13_o
416: => per_ckl_shd.g_old_rec.information13
417: ,p_information14_o
418: => per_ckl_shd.g_old_rec.information14
419: ,p_information15_o
420: => per_ckl_shd.g_old_rec.information15
421: ,p_information16_o
422: => per_ckl_shd.g_old_rec.information16

Line 420: => per_ckl_shd.g_old_rec.information15

416: => per_ckl_shd.g_old_rec.information13
417: ,p_information14_o
418: => per_ckl_shd.g_old_rec.information14
419: ,p_information15_o
420: => per_ckl_shd.g_old_rec.information15
421: ,p_information16_o
422: => per_ckl_shd.g_old_rec.information16
423: ,p_information17_o
424: => per_ckl_shd.g_old_rec.information17

Line 422: => per_ckl_shd.g_old_rec.information16

418: => per_ckl_shd.g_old_rec.information14
419: ,p_information15_o
420: => per_ckl_shd.g_old_rec.information15
421: ,p_information16_o
422: => per_ckl_shd.g_old_rec.information16
423: ,p_information17_o
424: => per_ckl_shd.g_old_rec.information17
425: ,p_information18_o
426: => per_ckl_shd.g_old_rec.information18

Line 424: => per_ckl_shd.g_old_rec.information17

420: => per_ckl_shd.g_old_rec.information15
421: ,p_information16_o
422: => per_ckl_shd.g_old_rec.information16
423: ,p_information17_o
424: => per_ckl_shd.g_old_rec.information17
425: ,p_information18_o
426: => per_ckl_shd.g_old_rec.information18
427: ,p_information19_o
428: => per_ckl_shd.g_old_rec.information19

Line 426: => per_ckl_shd.g_old_rec.information18

422: => per_ckl_shd.g_old_rec.information16
423: ,p_information17_o
424: => per_ckl_shd.g_old_rec.information17
425: ,p_information18_o
426: => per_ckl_shd.g_old_rec.information18
427: ,p_information19_o
428: => per_ckl_shd.g_old_rec.information19
429: ,p_information20_o
430: => per_ckl_shd.g_old_rec.information20

Line 428: => per_ckl_shd.g_old_rec.information19

424: => per_ckl_shd.g_old_rec.information17
425: ,p_information18_o
426: => per_ckl_shd.g_old_rec.information18
427: ,p_information19_o
428: => per_ckl_shd.g_old_rec.information19
429: ,p_information20_o
430: => per_ckl_shd.g_old_rec.information20
431: );
432: --

Line 430: => per_ckl_shd.g_old_rec.information20

426: => per_ckl_shd.g_old_rec.information18
427: ,p_information19_o
428: => per_ckl_shd.g_old_rec.information19
429: ,p_information20_o
430: => per_ckl_shd.g_old_rec.information20
431: );
432: --
433: exception
434: --

Line 490: (p_rec in out nocopy per_ckl_shd.g_rec_type

486: --
487: -- {End Of Comments}
488: -- ----------------------------------------------------------------------------
489: Procedure convert_defs
490: (p_rec in out nocopy per_ckl_shd.g_rec_type
491: ) is
492: --
493: Begin
494: --

Line 502: per_ckl_shd.g_old_rec.name;

498: -- is being used then we must set to the 'current' argument value.
499: --
500: If (p_rec.name = hr_api.g_varchar2) then
501: p_rec.name :=
502: per_ckl_shd.g_old_rec.name;
503: End If;
504: If (p_rec.description = hr_api.g_varchar2) then
505: p_rec.description :=
506: per_ckl_shd.g_old_rec.description;

Line 506: per_ckl_shd.g_old_rec.description;

502: per_ckl_shd.g_old_rec.name;
503: End If;
504: If (p_rec.description = hr_api.g_varchar2) then
505: p_rec.description :=
506: per_ckl_shd.g_old_rec.description;
507: End If;
508: If (p_rec.checklist_category = hr_api.g_varchar2) then
509: p_rec.checklist_category :=
510: per_ckl_shd.g_old_rec.checklist_category;

Line 510: per_ckl_shd.g_old_rec.checklist_category;

506: per_ckl_shd.g_old_rec.description;
507: End If;
508: If (p_rec.checklist_category = hr_api.g_varchar2) then
509: p_rec.checklist_category :=
510: per_ckl_shd.g_old_rec.checklist_category;
511: End If;
512: If (p_rec.event_reason_id = hr_api.g_number) then
513: p_rec.event_reason_id :=
514: per_ckl_shd.g_old_rec.event_reason_id;

Line 514: per_ckl_shd.g_old_rec.event_reason_id;

510: per_ckl_shd.g_old_rec.checklist_category;
511: End If;
512: If (p_rec.event_reason_id = hr_api.g_number) then
513: p_rec.event_reason_id :=
514: per_ckl_shd.g_old_rec.event_reason_id;
515: End If;
516: If (p_rec.business_group_id = hr_api.g_number) then
517: p_rec.business_group_id :=
518: per_ckl_shd.g_old_rec.business_group_id;

Line 518: per_ckl_shd.g_old_rec.business_group_id;

514: per_ckl_shd.g_old_rec.event_reason_id;
515: End If;
516: If (p_rec.business_group_id = hr_api.g_number) then
517: p_rec.business_group_id :=
518: per_ckl_shd.g_old_rec.business_group_id;
519: End If;
520: If (p_rec.attribute_category = hr_api.g_varchar2) then
521: p_rec.attribute_category :=
522: per_ckl_shd.g_old_rec.attribute_category;

Line 522: per_ckl_shd.g_old_rec.attribute_category;

518: per_ckl_shd.g_old_rec.business_group_id;
519: End If;
520: If (p_rec.attribute_category = hr_api.g_varchar2) then
521: p_rec.attribute_category :=
522: per_ckl_shd.g_old_rec.attribute_category;
523: End If;
524: If (p_rec.attribute1 = hr_api.g_varchar2) then
525: p_rec.attribute1 :=
526: per_ckl_shd.g_old_rec.attribute1;

Line 526: per_ckl_shd.g_old_rec.attribute1;

522: per_ckl_shd.g_old_rec.attribute_category;
523: End If;
524: If (p_rec.attribute1 = hr_api.g_varchar2) then
525: p_rec.attribute1 :=
526: per_ckl_shd.g_old_rec.attribute1;
527: End If;
528: If (p_rec.attribute2 = hr_api.g_varchar2) then
529: p_rec.attribute2 :=
530: per_ckl_shd.g_old_rec.attribute2;

Line 530: per_ckl_shd.g_old_rec.attribute2;

526: per_ckl_shd.g_old_rec.attribute1;
527: End If;
528: If (p_rec.attribute2 = hr_api.g_varchar2) then
529: p_rec.attribute2 :=
530: per_ckl_shd.g_old_rec.attribute2;
531: End If;
532: If (p_rec.attribute3 = hr_api.g_varchar2) then
533: p_rec.attribute3 :=
534: per_ckl_shd.g_old_rec.attribute3;

Line 534: per_ckl_shd.g_old_rec.attribute3;

530: per_ckl_shd.g_old_rec.attribute2;
531: End If;
532: If (p_rec.attribute3 = hr_api.g_varchar2) then
533: p_rec.attribute3 :=
534: per_ckl_shd.g_old_rec.attribute3;
535: End If;
536: If (p_rec.attribute4 = hr_api.g_varchar2) then
537: p_rec.attribute4 :=
538: per_ckl_shd.g_old_rec.attribute4;

Line 538: per_ckl_shd.g_old_rec.attribute4;

534: per_ckl_shd.g_old_rec.attribute3;
535: End If;
536: If (p_rec.attribute4 = hr_api.g_varchar2) then
537: p_rec.attribute4 :=
538: per_ckl_shd.g_old_rec.attribute4;
539: End If;
540: If (p_rec.attribute5 = hr_api.g_varchar2) then
541: p_rec.attribute5 :=
542: per_ckl_shd.g_old_rec.attribute5;

Line 542: per_ckl_shd.g_old_rec.attribute5;

538: per_ckl_shd.g_old_rec.attribute4;
539: End If;
540: If (p_rec.attribute5 = hr_api.g_varchar2) then
541: p_rec.attribute5 :=
542: per_ckl_shd.g_old_rec.attribute5;
543: End If;
544: If (p_rec.attribute6 = hr_api.g_varchar2) then
545: p_rec.attribute6 :=
546: per_ckl_shd.g_old_rec.attribute6;

Line 546: per_ckl_shd.g_old_rec.attribute6;

542: per_ckl_shd.g_old_rec.attribute5;
543: End If;
544: If (p_rec.attribute6 = hr_api.g_varchar2) then
545: p_rec.attribute6 :=
546: per_ckl_shd.g_old_rec.attribute6;
547: End If;
548: If (p_rec.attribute7 = hr_api.g_varchar2) then
549: p_rec.attribute7 :=
550: per_ckl_shd.g_old_rec.attribute7;

Line 550: per_ckl_shd.g_old_rec.attribute7;

546: per_ckl_shd.g_old_rec.attribute6;
547: End If;
548: If (p_rec.attribute7 = hr_api.g_varchar2) then
549: p_rec.attribute7 :=
550: per_ckl_shd.g_old_rec.attribute7;
551: End If;
552: If (p_rec.attribute8 = hr_api.g_varchar2) then
553: p_rec.attribute8 :=
554: per_ckl_shd.g_old_rec.attribute8;

Line 554: per_ckl_shd.g_old_rec.attribute8;

550: per_ckl_shd.g_old_rec.attribute7;
551: End If;
552: If (p_rec.attribute8 = hr_api.g_varchar2) then
553: p_rec.attribute8 :=
554: per_ckl_shd.g_old_rec.attribute8;
555: End If;
556: If (p_rec.attribute9 = hr_api.g_varchar2) then
557: p_rec.attribute9 :=
558: per_ckl_shd.g_old_rec.attribute9;

Line 558: per_ckl_shd.g_old_rec.attribute9;

554: per_ckl_shd.g_old_rec.attribute8;
555: End If;
556: If (p_rec.attribute9 = hr_api.g_varchar2) then
557: p_rec.attribute9 :=
558: per_ckl_shd.g_old_rec.attribute9;
559: End If;
560: If (p_rec.attribute10 = hr_api.g_varchar2) then
561: p_rec.attribute10 :=
562: per_ckl_shd.g_old_rec.attribute10;

Line 562: per_ckl_shd.g_old_rec.attribute10;

558: per_ckl_shd.g_old_rec.attribute9;
559: End If;
560: If (p_rec.attribute10 = hr_api.g_varchar2) then
561: p_rec.attribute10 :=
562: per_ckl_shd.g_old_rec.attribute10;
563: End If;
564: If (p_rec.attribute11 = hr_api.g_varchar2) then
565: p_rec.attribute11 :=
566: per_ckl_shd.g_old_rec.attribute11;

Line 566: per_ckl_shd.g_old_rec.attribute11;

562: per_ckl_shd.g_old_rec.attribute10;
563: End If;
564: If (p_rec.attribute11 = hr_api.g_varchar2) then
565: p_rec.attribute11 :=
566: per_ckl_shd.g_old_rec.attribute11;
567: End If;
568: If (p_rec.attribute12 = hr_api.g_varchar2) then
569: p_rec.attribute12 :=
570: per_ckl_shd.g_old_rec.attribute12;

Line 570: per_ckl_shd.g_old_rec.attribute12;

566: per_ckl_shd.g_old_rec.attribute11;
567: End If;
568: If (p_rec.attribute12 = hr_api.g_varchar2) then
569: p_rec.attribute12 :=
570: per_ckl_shd.g_old_rec.attribute12;
571: End If;
572: If (p_rec.attribute13 = hr_api.g_varchar2) then
573: p_rec.attribute13 :=
574: per_ckl_shd.g_old_rec.attribute13;

Line 574: per_ckl_shd.g_old_rec.attribute13;

570: per_ckl_shd.g_old_rec.attribute12;
571: End If;
572: If (p_rec.attribute13 = hr_api.g_varchar2) then
573: p_rec.attribute13 :=
574: per_ckl_shd.g_old_rec.attribute13;
575: End If;
576: If (p_rec.attribute14 = hr_api.g_varchar2) then
577: p_rec.attribute14 :=
578: per_ckl_shd.g_old_rec.attribute14;

Line 578: per_ckl_shd.g_old_rec.attribute14;

574: per_ckl_shd.g_old_rec.attribute13;
575: End If;
576: If (p_rec.attribute14 = hr_api.g_varchar2) then
577: p_rec.attribute14 :=
578: per_ckl_shd.g_old_rec.attribute14;
579: End If;
580: If (p_rec.attribute15 = hr_api.g_varchar2) then
581: p_rec.attribute15 :=
582: per_ckl_shd.g_old_rec.attribute15;

Line 582: per_ckl_shd.g_old_rec.attribute15;

578: per_ckl_shd.g_old_rec.attribute14;
579: End If;
580: If (p_rec.attribute15 = hr_api.g_varchar2) then
581: p_rec.attribute15 :=
582: per_ckl_shd.g_old_rec.attribute15;
583: End If;
584: If (p_rec.attribute16 = hr_api.g_varchar2) then
585: p_rec.attribute16 :=
586: per_ckl_shd.g_old_rec.attribute16;

Line 586: per_ckl_shd.g_old_rec.attribute16;

582: per_ckl_shd.g_old_rec.attribute15;
583: End If;
584: If (p_rec.attribute16 = hr_api.g_varchar2) then
585: p_rec.attribute16 :=
586: per_ckl_shd.g_old_rec.attribute16;
587: End If;
588: If (p_rec.attribute17 = hr_api.g_varchar2) then
589: p_rec.attribute17 :=
590: per_ckl_shd.g_old_rec.attribute17;

Line 590: per_ckl_shd.g_old_rec.attribute17;

586: per_ckl_shd.g_old_rec.attribute16;
587: End If;
588: If (p_rec.attribute17 = hr_api.g_varchar2) then
589: p_rec.attribute17 :=
590: per_ckl_shd.g_old_rec.attribute17;
591: End If;
592: If (p_rec.attribute18 = hr_api.g_varchar2) then
593: p_rec.attribute18 :=
594: per_ckl_shd.g_old_rec.attribute18;

Line 594: per_ckl_shd.g_old_rec.attribute18;

590: per_ckl_shd.g_old_rec.attribute17;
591: End If;
592: If (p_rec.attribute18 = hr_api.g_varchar2) then
593: p_rec.attribute18 :=
594: per_ckl_shd.g_old_rec.attribute18;
595: End If;
596: If (p_rec.attribute19 = hr_api.g_varchar2) then
597: p_rec.attribute19 :=
598: per_ckl_shd.g_old_rec.attribute19;

Line 598: per_ckl_shd.g_old_rec.attribute19;

594: per_ckl_shd.g_old_rec.attribute18;
595: End If;
596: If (p_rec.attribute19 = hr_api.g_varchar2) then
597: p_rec.attribute19 :=
598: per_ckl_shd.g_old_rec.attribute19;
599: End If;
600: If (p_rec.attribute20 = hr_api.g_varchar2) then
601: p_rec.attribute20 :=
602: per_ckl_shd.g_old_rec.attribute20;

Line 602: per_ckl_shd.g_old_rec.attribute20;

598: per_ckl_shd.g_old_rec.attribute19;
599: End If;
600: If (p_rec.attribute20 = hr_api.g_varchar2) then
601: p_rec.attribute20 :=
602: per_ckl_shd.g_old_rec.attribute20;
603: End If;
604: If (p_rec.information_category = hr_api.g_varchar2) then
605: p_rec.information_category :=
606: per_ckl_shd.g_old_rec.information_category;

Line 606: per_ckl_shd.g_old_rec.information_category;

602: per_ckl_shd.g_old_rec.attribute20;
603: End If;
604: If (p_rec.information_category = hr_api.g_varchar2) then
605: p_rec.information_category :=
606: per_ckl_shd.g_old_rec.information_category;
607: End If;
608: If (p_rec.information1 = hr_api.g_varchar2) then
609: p_rec.information1 :=
610: per_ckl_shd.g_old_rec.information1;

Line 610: per_ckl_shd.g_old_rec.information1;

606: per_ckl_shd.g_old_rec.information_category;
607: End If;
608: If (p_rec.information1 = hr_api.g_varchar2) then
609: p_rec.information1 :=
610: per_ckl_shd.g_old_rec.information1;
611: End If;
612: If (p_rec.information2 = hr_api.g_varchar2) then
613: p_rec.information2 :=
614: per_ckl_shd.g_old_rec.information2;

Line 614: per_ckl_shd.g_old_rec.information2;

610: per_ckl_shd.g_old_rec.information1;
611: End If;
612: If (p_rec.information2 = hr_api.g_varchar2) then
613: p_rec.information2 :=
614: per_ckl_shd.g_old_rec.information2;
615: End If;
616: If (p_rec.information3 = hr_api.g_varchar2) then
617: p_rec.information3 :=
618: per_ckl_shd.g_old_rec.information3;

Line 618: per_ckl_shd.g_old_rec.information3;

614: per_ckl_shd.g_old_rec.information2;
615: End If;
616: If (p_rec.information3 = hr_api.g_varchar2) then
617: p_rec.information3 :=
618: per_ckl_shd.g_old_rec.information3;
619: End If;
620: If (p_rec.information4 = hr_api.g_varchar2) then
621: p_rec.information4 :=
622: per_ckl_shd.g_old_rec.information4;

Line 622: per_ckl_shd.g_old_rec.information4;

618: per_ckl_shd.g_old_rec.information3;
619: End If;
620: If (p_rec.information4 = hr_api.g_varchar2) then
621: p_rec.information4 :=
622: per_ckl_shd.g_old_rec.information4;
623: End If;
624: If (p_rec.information5 = hr_api.g_varchar2) then
625: p_rec.information5 :=
626: per_ckl_shd.g_old_rec.information5;

Line 626: per_ckl_shd.g_old_rec.information5;

622: per_ckl_shd.g_old_rec.information4;
623: End If;
624: If (p_rec.information5 = hr_api.g_varchar2) then
625: p_rec.information5 :=
626: per_ckl_shd.g_old_rec.information5;
627: End If;
628: If (p_rec.information6 = hr_api.g_varchar2) then
629: p_rec.information6 :=
630: per_ckl_shd.g_old_rec.information6;

Line 630: per_ckl_shd.g_old_rec.information6;

626: per_ckl_shd.g_old_rec.information5;
627: End If;
628: If (p_rec.information6 = hr_api.g_varchar2) then
629: p_rec.information6 :=
630: per_ckl_shd.g_old_rec.information6;
631: End If;
632: If (p_rec.information7 = hr_api.g_varchar2) then
633: p_rec.information7 :=
634: per_ckl_shd.g_old_rec.information7;

Line 634: per_ckl_shd.g_old_rec.information7;

630: per_ckl_shd.g_old_rec.information6;
631: End If;
632: If (p_rec.information7 = hr_api.g_varchar2) then
633: p_rec.information7 :=
634: per_ckl_shd.g_old_rec.information7;
635: End If;
636: If (p_rec.information8 = hr_api.g_varchar2) then
637: p_rec.information8 :=
638: per_ckl_shd.g_old_rec.information8;

Line 638: per_ckl_shd.g_old_rec.information8;

634: per_ckl_shd.g_old_rec.information7;
635: End If;
636: If (p_rec.information8 = hr_api.g_varchar2) then
637: p_rec.information8 :=
638: per_ckl_shd.g_old_rec.information8;
639: End If;
640: If (p_rec.information9 = hr_api.g_varchar2) then
641: p_rec.information9 :=
642: per_ckl_shd.g_old_rec.information9;

Line 642: per_ckl_shd.g_old_rec.information9;

638: per_ckl_shd.g_old_rec.information8;
639: End If;
640: If (p_rec.information9 = hr_api.g_varchar2) then
641: p_rec.information9 :=
642: per_ckl_shd.g_old_rec.information9;
643: End If;
644: If (p_rec.information10 = hr_api.g_varchar2) then
645: p_rec.information10 :=
646: per_ckl_shd.g_old_rec.information10;

Line 646: per_ckl_shd.g_old_rec.information10;

642: per_ckl_shd.g_old_rec.information9;
643: End If;
644: If (p_rec.information10 = hr_api.g_varchar2) then
645: p_rec.information10 :=
646: per_ckl_shd.g_old_rec.information10;
647: End If;
648: If (p_rec.information11 = hr_api.g_varchar2) then
649: p_rec.information11 :=
650: per_ckl_shd.g_old_rec.information11;

Line 650: per_ckl_shd.g_old_rec.information11;

646: per_ckl_shd.g_old_rec.information10;
647: End If;
648: If (p_rec.information11 = hr_api.g_varchar2) then
649: p_rec.information11 :=
650: per_ckl_shd.g_old_rec.information11;
651: End If;
652: If (p_rec.information12 = hr_api.g_varchar2) then
653: p_rec.information12 :=
654: per_ckl_shd.g_old_rec.information12;

Line 654: per_ckl_shd.g_old_rec.information12;

650: per_ckl_shd.g_old_rec.information11;
651: End If;
652: If (p_rec.information12 = hr_api.g_varchar2) then
653: p_rec.information12 :=
654: per_ckl_shd.g_old_rec.information12;
655: End If;
656: If (p_rec.information13 = hr_api.g_varchar2) then
657: p_rec.information13 :=
658: per_ckl_shd.g_old_rec.information13;

Line 658: per_ckl_shd.g_old_rec.information13;

654: per_ckl_shd.g_old_rec.information12;
655: End If;
656: If (p_rec.information13 = hr_api.g_varchar2) then
657: p_rec.information13 :=
658: per_ckl_shd.g_old_rec.information13;
659: End If;
660: If (p_rec.information14 = hr_api.g_varchar2) then
661: p_rec.information14 :=
662: per_ckl_shd.g_old_rec.information14;

Line 662: per_ckl_shd.g_old_rec.information14;

658: per_ckl_shd.g_old_rec.information13;
659: End If;
660: If (p_rec.information14 = hr_api.g_varchar2) then
661: p_rec.information14 :=
662: per_ckl_shd.g_old_rec.information14;
663: End If;
664: If (p_rec.information15 = hr_api.g_varchar2) then
665: p_rec.information15 :=
666: per_ckl_shd.g_old_rec.information15;

Line 666: per_ckl_shd.g_old_rec.information15;

662: per_ckl_shd.g_old_rec.information14;
663: End If;
664: If (p_rec.information15 = hr_api.g_varchar2) then
665: p_rec.information15 :=
666: per_ckl_shd.g_old_rec.information15;
667: End If;
668: If (p_rec.information16 = hr_api.g_varchar2) then
669: p_rec.information16 :=
670: per_ckl_shd.g_old_rec.information16;

Line 670: per_ckl_shd.g_old_rec.information16;

666: per_ckl_shd.g_old_rec.information15;
667: End If;
668: If (p_rec.information16 = hr_api.g_varchar2) then
669: p_rec.information16 :=
670: per_ckl_shd.g_old_rec.information16;
671: End If;
672: If (p_rec.information17 = hr_api.g_varchar2) then
673: p_rec.information17 :=
674: per_ckl_shd.g_old_rec.information17;

Line 674: per_ckl_shd.g_old_rec.information17;

670: per_ckl_shd.g_old_rec.information16;
671: End If;
672: If (p_rec.information17 = hr_api.g_varchar2) then
673: p_rec.information17 :=
674: per_ckl_shd.g_old_rec.information17;
675: End If;
676: If (p_rec.information18 = hr_api.g_varchar2) then
677: p_rec.information18 :=
678: per_ckl_shd.g_old_rec.information18;

Line 678: per_ckl_shd.g_old_rec.information18;

674: per_ckl_shd.g_old_rec.information17;
675: End If;
676: If (p_rec.information18 = hr_api.g_varchar2) then
677: p_rec.information18 :=
678: per_ckl_shd.g_old_rec.information18;
679: End If;
680: If (p_rec.information19 = hr_api.g_varchar2) then
681: p_rec.information19 :=
682: per_ckl_shd.g_old_rec.information19;

Line 682: per_ckl_shd.g_old_rec.information19;

678: per_ckl_shd.g_old_rec.information18;
679: End If;
680: If (p_rec.information19 = hr_api.g_varchar2) then
681: p_rec.information19 :=
682: per_ckl_shd.g_old_rec.information19;
683: End If;
684: If (p_rec.information20 = hr_api.g_varchar2) then
685: p_rec.information20 :=
686: per_ckl_shd.g_old_rec.information20;

Line 686: per_ckl_shd.g_old_rec.information20;

682: per_ckl_shd.g_old_rec.information19;
683: End If;
684: If (p_rec.information20 = hr_api.g_varchar2) then
685: p_rec.information20 :=
686: per_ckl_shd.g_old_rec.information20;
687: End If;
688: --
689: End convert_defs;
690: --

Line 696: ,p_rec in out nocopy per_ckl_shd.g_rec_type

692: -- |---------------------------------< upd >----------------------------------|
693: -- ----------------------------------------------------------------------------
694: Procedure upd
695: (p_effective_date in date
696: ,p_rec in out nocopy per_ckl_shd.g_rec_type
697: ) is
698: --
699: l_proc varchar2(72) := g_package||'upd';
700: --

Line 706: per_ckl_shd.lck

702: hr_utility.set_location('Entering:'||l_proc, 5);
703: --
704: -- We must lock the row which we need to update.
705: --
706: per_ckl_shd.lck
707: (p_rec.checklist_id
708: ,p_rec.object_version_number
709: );
710: --

Line 801: l_rec per_ckl_shd.g_rec_type;

797: ,p_information19 in varchar2 default hr_api.g_varchar2
798: ,p_information20 in varchar2 default hr_api.g_varchar2
799: ) is
800: --
801: l_rec per_ckl_shd.g_rec_type;
802: l_proc varchar2(72) := g_package||'upd';
803: --
804: Begin
805: hr_utility.set_location('Entering:'||l_proc, 5);

Line 811: per_ckl_shd.convert_args

807: -- Call conversion function to turn arguments into the
808: -- l_rec structure.
809: --
810: l_rec :=
811: per_ckl_shd.convert_args
812: (p_checklist_id
813: ,p_name
814: ,p_description
815: ,p_checklist_category