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.IRC_IID_UPD dependencies on IRC_IID_SHD

Line 58: (p_rec in out nocopy irc_iid_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy irc_iid_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 77: irc_iid_shd.get_object_version_number

73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
76: p_rec.object_version_number :=
77: irc_iid_shd.get_object_version_number
78: (p_interview_details_id => p_rec.interview_details_id
79: );
80: --
81: --

Line 137: irc_iid_shd.constraint_error

133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: irc_iid_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: --

Line 142: irc_iid_shd.constraint_error

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

Line 181: (p_rec in out nocopy irc_iid_shd.g_rec_type

177: --
178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure update_dml
181: (p_rec in out nocopy irc_iid_shd.g_rec_type
182: ,p_effective_date in date
183: ,p_datetrack_mode in varchar2
184: ,p_validation_start_date in date
185: ,p_validation_end_date in date

Line 248: (p_rec in out nocopy irc_iid_shd.g_rec_type

244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure dt_pre_update
248: (p_rec in out nocopy irc_iid_shd.g_rec_type
249: ,p_effective_date in date
250: ,p_datetrack_mode in varchar2
251: ,p_validation_start_date in date
252: ,p_validation_end_date in date

Line 264: irc_iid_shd.upd_end_date

260: If (p_datetrack_mode <> hr_api.g_correction) then
261: --
262: -- Update the current effective end date
263: --
264: irc_iid_shd.upd_end_date
265: (p_effective_date => p_effective_date
266: ,p_interview_details_id => p_rec.interview_details_id
267: ,p_new_end_date => p_validation_start_date
268: ,p_object_version_number => l_dummy_version_number

Line 331: (p_rec in out nocopy irc_iid_shd.g_rec_type

327: --
328: -- {End Of Comments}
329: -- ----------------------------------------------------------------------------
330: Procedure pre_update
331: (p_rec in out nocopy irc_iid_shd.g_rec_type
332: ,p_effective_date in date
333: ,p_datetrack_mode in varchar2
334: ,p_validation_start_date in date
335: ,p_validation_end_date in date

Line 389: (p_rec in irc_iid_shd.g_rec_type

385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure post_update
389: (p_rec in irc_iid_shd.g_rec_type
390: ,p_effective_date in date
391: ,p_datetrack_mode in varchar2
392: ,p_validation_start_date in date
393: ,p_validation_end_date in date

Line 476: => irc_iid_shd.g_old_rec.status

472: => p_rec.event_id
473: ,p_object_version_number
474: => p_rec.object_version_number
475: ,p_status_o
476: => irc_iid_shd.g_old_rec.status
477: ,p_feedback_o
478: => irc_iid_shd.g_old_rec.feedback
479: ,p_notes_o
480: => irc_iid_shd.g_old_rec.notes

Line 478: => irc_iid_shd.g_old_rec.feedback

474: => p_rec.object_version_number
475: ,p_status_o
476: => irc_iid_shd.g_old_rec.status
477: ,p_feedback_o
478: => irc_iid_shd.g_old_rec.feedback
479: ,p_notes_o
480: => irc_iid_shd.g_old_rec.notes
481: ,p_notes_to_candidate_o
482: => irc_iid_shd.g_old_rec.notes_to_candidate

Line 480: => irc_iid_shd.g_old_rec.notes

476: => irc_iid_shd.g_old_rec.status
477: ,p_feedback_o
478: => irc_iid_shd.g_old_rec.feedback
479: ,p_notes_o
480: => irc_iid_shd.g_old_rec.notes
481: ,p_notes_to_candidate_o
482: => irc_iid_shd.g_old_rec.notes_to_candidate
483: ,p_category_o
484: => irc_iid_shd.g_old_rec.category

Line 482: => irc_iid_shd.g_old_rec.notes_to_candidate

478: => irc_iid_shd.g_old_rec.feedback
479: ,p_notes_o
480: => irc_iid_shd.g_old_rec.notes
481: ,p_notes_to_candidate_o
482: => irc_iid_shd.g_old_rec.notes_to_candidate
483: ,p_category_o
484: => irc_iid_shd.g_old_rec.category
485: ,p_result_o
486: => irc_iid_shd.g_old_rec.result

Line 484: => irc_iid_shd.g_old_rec.category

480: => irc_iid_shd.g_old_rec.notes
481: ,p_notes_to_candidate_o
482: => irc_iid_shd.g_old_rec.notes_to_candidate
483: ,p_category_o
484: => irc_iid_shd.g_old_rec.category
485: ,p_result_o
486: => irc_iid_shd.g_old_rec.result
487: ,p_iid_information_category_o
488: => irc_iid_shd.g_old_rec.iid_information_category

Line 486: => irc_iid_shd.g_old_rec.result

482: => irc_iid_shd.g_old_rec.notes_to_candidate
483: ,p_category_o
484: => irc_iid_shd.g_old_rec.category
485: ,p_result_o
486: => irc_iid_shd.g_old_rec.result
487: ,p_iid_information_category_o
488: => irc_iid_shd.g_old_rec.iid_information_category
489: ,p_iid_information1_o
490: => irc_iid_shd.g_old_rec.iid_information1

Line 488: => irc_iid_shd.g_old_rec.iid_information_category

484: => irc_iid_shd.g_old_rec.category
485: ,p_result_o
486: => irc_iid_shd.g_old_rec.result
487: ,p_iid_information_category_o
488: => irc_iid_shd.g_old_rec.iid_information_category
489: ,p_iid_information1_o
490: => irc_iid_shd.g_old_rec.iid_information1
491: ,p_iid_information2_o
492: => irc_iid_shd.g_old_rec.iid_information2

Line 490: => irc_iid_shd.g_old_rec.iid_information1

486: => irc_iid_shd.g_old_rec.result
487: ,p_iid_information_category_o
488: => irc_iid_shd.g_old_rec.iid_information_category
489: ,p_iid_information1_o
490: => irc_iid_shd.g_old_rec.iid_information1
491: ,p_iid_information2_o
492: => irc_iid_shd.g_old_rec.iid_information2
493: ,p_iid_information3_o
494: => irc_iid_shd.g_old_rec.iid_information3

Line 492: => irc_iid_shd.g_old_rec.iid_information2

488: => irc_iid_shd.g_old_rec.iid_information_category
489: ,p_iid_information1_o
490: => irc_iid_shd.g_old_rec.iid_information1
491: ,p_iid_information2_o
492: => irc_iid_shd.g_old_rec.iid_information2
493: ,p_iid_information3_o
494: => irc_iid_shd.g_old_rec.iid_information3
495: ,p_iid_information4_o
496: => irc_iid_shd.g_old_rec.iid_information4

Line 494: => irc_iid_shd.g_old_rec.iid_information3

490: => irc_iid_shd.g_old_rec.iid_information1
491: ,p_iid_information2_o
492: => irc_iid_shd.g_old_rec.iid_information2
493: ,p_iid_information3_o
494: => irc_iid_shd.g_old_rec.iid_information3
495: ,p_iid_information4_o
496: => irc_iid_shd.g_old_rec.iid_information4
497: ,p_iid_information5_o
498: => irc_iid_shd.g_old_rec.iid_information5

Line 496: => irc_iid_shd.g_old_rec.iid_information4

492: => irc_iid_shd.g_old_rec.iid_information2
493: ,p_iid_information3_o
494: => irc_iid_shd.g_old_rec.iid_information3
495: ,p_iid_information4_o
496: => irc_iid_shd.g_old_rec.iid_information4
497: ,p_iid_information5_o
498: => irc_iid_shd.g_old_rec.iid_information5
499: ,p_iid_information6_o
500: => irc_iid_shd.g_old_rec.iid_information6

Line 498: => irc_iid_shd.g_old_rec.iid_information5

494: => irc_iid_shd.g_old_rec.iid_information3
495: ,p_iid_information4_o
496: => irc_iid_shd.g_old_rec.iid_information4
497: ,p_iid_information5_o
498: => irc_iid_shd.g_old_rec.iid_information5
499: ,p_iid_information6_o
500: => irc_iid_shd.g_old_rec.iid_information6
501: ,p_iid_information7_o
502: => irc_iid_shd.g_old_rec.iid_information7

Line 500: => irc_iid_shd.g_old_rec.iid_information6

496: => irc_iid_shd.g_old_rec.iid_information4
497: ,p_iid_information5_o
498: => irc_iid_shd.g_old_rec.iid_information5
499: ,p_iid_information6_o
500: => irc_iid_shd.g_old_rec.iid_information6
501: ,p_iid_information7_o
502: => irc_iid_shd.g_old_rec.iid_information7
503: ,p_iid_information8_o
504: => irc_iid_shd.g_old_rec.iid_information8

Line 502: => irc_iid_shd.g_old_rec.iid_information7

498: => irc_iid_shd.g_old_rec.iid_information5
499: ,p_iid_information6_o
500: => irc_iid_shd.g_old_rec.iid_information6
501: ,p_iid_information7_o
502: => irc_iid_shd.g_old_rec.iid_information7
503: ,p_iid_information8_o
504: => irc_iid_shd.g_old_rec.iid_information8
505: ,p_iid_information9_o
506: => irc_iid_shd.g_old_rec.iid_information9

Line 504: => irc_iid_shd.g_old_rec.iid_information8

500: => irc_iid_shd.g_old_rec.iid_information6
501: ,p_iid_information7_o
502: => irc_iid_shd.g_old_rec.iid_information7
503: ,p_iid_information8_o
504: => irc_iid_shd.g_old_rec.iid_information8
505: ,p_iid_information9_o
506: => irc_iid_shd.g_old_rec.iid_information9
507: ,p_iid_information10_o
508: => irc_iid_shd.g_old_rec.iid_information10

Line 506: => irc_iid_shd.g_old_rec.iid_information9

502: => irc_iid_shd.g_old_rec.iid_information7
503: ,p_iid_information8_o
504: => irc_iid_shd.g_old_rec.iid_information8
505: ,p_iid_information9_o
506: => irc_iid_shd.g_old_rec.iid_information9
507: ,p_iid_information10_o
508: => irc_iid_shd.g_old_rec.iid_information10
509: ,p_iid_information11_o
510: => irc_iid_shd.g_old_rec.iid_information11

Line 508: => irc_iid_shd.g_old_rec.iid_information10

504: => irc_iid_shd.g_old_rec.iid_information8
505: ,p_iid_information9_o
506: => irc_iid_shd.g_old_rec.iid_information9
507: ,p_iid_information10_o
508: => irc_iid_shd.g_old_rec.iid_information10
509: ,p_iid_information11_o
510: => irc_iid_shd.g_old_rec.iid_information11
511: ,p_iid_information12_o
512: => irc_iid_shd.g_old_rec.iid_information12

Line 510: => irc_iid_shd.g_old_rec.iid_information11

506: => irc_iid_shd.g_old_rec.iid_information9
507: ,p_iid_information10_o
508: => irc_iid_shd.g_old_rec.iid_information10
509: ,p_iid_information11_o
510: => irc_iid_shd.g_old_rec.iid_information11
511: ,p_iid_information12_o
512: => irc_iid_shd.g_old_rec.iid_information12
513: ,p_iid_information13_o
514: => irc_iid_shd.g_old_rec.iid_information13

Line 512: => irc_iid_shd.g_old_rec.iid_information12

508: => irc_iid_shd.g_old_rec.iid_information10
509: ,p_iid_information11_o
510: => irc_iid_shd.g_old_rec.iid_information11
511: ,p_iid_information12_o
512: => irc_iid_shd.g_old_rec.iid_information12
513: ,p_iid_information13_o
514: => irc_iid_shd.g_old_rec.iid_information13
515: ,p_iid_information14_o
516: => irc_iid_shd.g_old_rec.iid_information14

Line 514: => irc_iid_shd.g_old_rec.iid_information13

510: => irc_iid_shd.g_old_rec.iid_information11
511: ,p_iid_information12_o
512: => irc_iid_shd.g_old_rec.iid_information12
513: ,p_iid_information13_o
514: => irc_iid_shd.g_old_rec.iid_information13
515: ,p_iid_information14_o
516: => irc_iid_shd.g_old_rec.iid_information14
517: ,p_iid_information15_o
518: => irc_iid_shd.g_old_rec.iid_information15

Line 516: => irc_iid_shd.g_old_rec.iid_information14

512: => irc_iid_shd.g_old_rec.iid_information12
513: ,p_iid_information13_o
514: => irc_iid_shd.g_old_rec.iid_information13
515: ,p_iid_information14_o
516: => irc_iid_shd.g_old_rec.iid_information14
517: ,p_iid_information15_o
518: => irc_iid_shd.g_old_rec.iid_information15
519: ,p_iid_information16_o
520: => irc_iid_shd.g_old_rec.iid_information16

Line 518: => irc_iid_shd.g_old_rec.iid_information15

514: => irc_iid_shd.g_old_rec.iid_information13
515: ,p_iid_information14_o
516: => irc_iid_shd.g_old_rec.iid_information14
517: ,p_iid_information15_o
518: => irc_iid_shd.g_old_rec.iid_information15
519: ,p_iid_information16_o
520: => irc_iid_shd.g_old_rec.iid_information16
521: ,p_iid_information17_o
522: => irc_iid_shd.g_old_rec.iid_information17

Line 520: => irc_iid_shd.g_old_rec.iid_information16

516: => irc_iid_shd.g_old_rec.iid_information14
517: ,p_iid_information15_o
518: => irc_iid_shd.g_old_rec.iid_information15
519: ,p_iid_information16_o
520: => irc_iid_shd.g_old_rec.iid_information16
521: ,p_iid_information17_o
522: => irc_iid_shd.g_old_rec.iid_information17
523: ,p_iid_information18_o
524: => irc_iid_shd.g_old_rec.iid_information18

Line 522: => irc_iid_shd.g_old_rec.iid_information17

518: => irc_iid_shd.g_old_rec.iid_information15
519: ,p_iid_information16_o
520: => irc_iid_shd.g_old_rec.iid_information16
521: ,p_iid_information17_o
522: => irc_iid_shd.g_old_rec.iid_information17
523: ,p_iid_information18_o
524: => irc_iid_shd.g_old_rec.iid_information18
525: ,p_iid_information19_o
526: => irc_iid_shd.g_old_rec.iid_information19

Line 524: => irc_iid_shd.g_old_rec.iid_information18

520: => irc_iid_shd.g_old_rec.iid_information16
521: ,p_iid_information17_o
522: => irc_iid_shd.g_old_rec.iid_information17
523: ,p_iid_information18_o
524: => irc_iid_shd.g_old_rec.iid_information18
525: ,p_iid_information19_o
526: => irc_iid_shd.g_old_rec.iid_information19
527: ,p_iid_information20_o
528: => irc_iid_shd.g_old_rec.iid_information20

Line 526: => irc_iid_shd.g_old_rec.iid_information19

522: => irc_iid_shd.g_old_rec.iid_information17
523: ,p_iid_information18_o
524: => irc_iid_shd.g_old_rec.iid_information18
525: ,p_iid_information19_o
526: => irc_iid_shd.g_old_rec.iid_information19
527: ,p_iid_information20_o
528: => irc_iid_shd.g_old_rec.iid_information20
529: ,p_start_date_o
530: => irc_iid_shd.g_old_rec.start_date

Line 528: => irc_iid_shd.g_old_rec.iid_information20

524: => irc_iid_shd.g_old_rec.iid_information18
525: ,p_iid_information19_o
526: => irc_iid_shd.g_old_rec.iid_information19
527: ,p_iid_information20_o
528: => irc_iid_shd.g_old_rec.iid_information20
529: ,p_start_date_o
530: => irc_iid_shd.g_old_rec.start_date
531: ,p_end_date_o
532: => irc_iid_shd.g_old_rec.end_date

Line 530: => irc_iid_shd.g_old_rec.start_date

526: => irc_iid_shd.g_old_rec.iid_information19
527: ,p_iid_information20_o
528: => irc_iid_shd.g_old_rec.iid_information20
529: ,p_start_date_o
530: => irc_iid_shd.g_old_rec.start_date
531: ,p_end_date_o
532: => irc_iid_shd.g_old_rec.end_date
533: ,p_event_id_o
534: => irc_iid_shd.g_old_rec.event_id

Line 532: => irc_iid_shd.g_old_rec.end_date

528: => irc_iid_shd.g_old_rec.iid_information20
529: ,p_start_date_o
530: => irc_iid_shd.g_old_rec.start_date
531: ,p_end_date_o
532: => irc_iid_shd.g_old_rec.end_date
533: ,p_event_id_o
534: => irc_iid_shd.g_old_rec.event_id
535: ,p_object_version_number_o
536: => irc_iid_shd.g_old_rec.object_version_number

Line 534: => irc_iid_shd.g_old_rec.event_id

530: => irc_iid_shd.g_old_rec.start_date
531: ,p_end_date_o
532: => irc_iid_shd.g_old_rec.end_date
533: ,p_event_id_o
534: => irc_iid_shd.g_old_rec.event_id
535: ,p_object_version_number_o
536: => irc_iid_shd.g_old_rec.object_version_number
537: );
538: --

Line 536: => irc_iid_shd.g_old_rec.object_version_number

532: => irc_iid_shd.g_old_rec.end_date
533: ,p_event_id_o
534: => irc_iid_shd.g_old_rec.event_id
535: ,p_object_version_number_o
536: => irc_iid_shd.g_old_rec.object_version_number
537: );
538: --
539: exception
540: --

Line 596: (p_rec in out nocopy irc_iid_shd.g_rec_type

592: --
593: -- {End Of Comments}
594: -- ----------------------------------------------------------------------------
595: Procedure convert_defs
596: (p_rec in out nocopy irc_iid_shd.g_rec_type
597: ) is
598: --
599: Begin
600: --

Line 608: irc_iid_shd.g_old_rec.status;

604: -- is being used then we must set to the 'current' argument value.
605: --
606: If (p_rec.status = hr_api.g_varchar2) then
607: p_rec.status :=
608: irc_iid_shd.g_old_rec.status;
609: End If;
610: If (p_rec.feedback = hr_api.g_varchar2) then
611: p_rec.feedback :=
612: irc_iid_shd.g_old_rec.feedback;

Line 612: irc_iid_shd.g_old_rec.feedback;

608: irc_iid_shd.g_old_rec.status;
609: End If;
610: If (p_rec.feedback = hr_api.g_varchar2) then
611: p_rec.feedback :=
612: irc_iid_shd.g_old_rec.feedback;
613: End If;
614: If (p_rec.notes = hr_api.g_varchar2) then
615: p_rec.notes :=
616: irc_iid_shd.g_old_rec.notes;

Line 616: irc_iid_shd.g_old_rec.notes;

612: irc_iid_shd.g_old_rec.feedback;
613: End If;
614: If (p_rec.notes = hr_api.g_varchar2) then
615: p_rec.notes :=
616: irc_iid_shd.g_old_rec.notes;
617: End If;
618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then
619: p_rec.notes_to_candidate :=
620: irc_iid_shd.g_old_rec.notes_to_candidate;

Line 620: irc_iid_shd.g_old_rec.notes_to_candidate;

616: irc_iid_shd.g_old_rec.notes;
617: End If;
618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then
619: p_rec.notes_to_candidate :=
620: irc_iid_shd.g_old_rec.notes_to_candidate;
621: End If;
622: If (p_rec.category = hr_api.g_varchar2) then
623: p_rec.category :=
624: irc_iid_shd.g_old_rec.category;

Line 624: irc_iid_shd.g_old_rec.category;

620: irc_iid_shd.g_old_rec.notes_to_candidate;
621: End If;
622: If (p_rec.category = hr_api.g_varchar2) then
623: p_rec.category :=
624: irc_iid_shd.g_old_rec.category;
625: End If;
626: If (p_rec.result = hr_api.g_varchar2) then
627: p_rec.result :=
628: irc_iid_shd.g_old_rec.result;

Line 628: irc_iid_shd.g_old_rec.result;

624: irc_iid_shd.g_old_rec.category;
625: End If;
626: If (p_rec.result = hr_api.g_varchar2) then
627: p_rec.result :=
628: irc_iid_shd.g_old_rec.result;
629: End If;
630: If (p_rec.iid_information_category = hr_api.g_varchar2) then
631: p_rec.iid_information_category :=
632: irc_iid_shd.g_old_rec.iid_information_category;

Line 632: irc_iid_shd.g_old_rec.iid_information_category;

628: irc_iid_shd.g_old_rec.result;
629: End If;
630: If (p_rec.iid_information_category = hr_api.g_varchar2) then
631: p_rec.iid_information_category :=
632: irc_iid_shd.g_old_rec.iid_information_category;
633: End If;
634: If (p_rec.iid_information1 = hr_api.g_varchar2) then
635: p_rec.iid_information1 :=
636: irc_iid_shd.g_old_rec.iid_information1;

Line 636: irc_iid_shd.g_old_rec.iid_information1;

632: irc_iid_shd.g_old_rec.iid_information_category;
633: End If;
634: If (p_rec.iid_information1 = hr_api.g_varchar2) then
635: p_rec.iid_information1 :=
636: irc_iid_shd.g_old_rec.iid_information1;
637: End If;
638: If (p_rec.iid_information2 = hr_api.g_varchar2) then
639: p_rec.iid_information2 :=
640: irc_iid_shd.g_old_rec.iid_information2;

Line 640: irc_iid_shd.g_old_rec.iid_information2;

636: irc_iid_shd.g_old_rec.iid_information1;
637: End If;
638: If (p_rec.iid_information2 = hr_api.g_varchar2) then
639: p_rec.iid_information2 :=
640: irc_iid_shd.g_old_rec.iid_information2;
641: End If;
642: If (p_rec.iid_information3 = hr_api.g_varchar2) then
643: p_rec.iid_information3 :=
644: irc_iid_shd.g_old_rec.iid_information3;

Line 644: irc_iid_shd.g_old_rec.iid_information3;

640: irc_iid_shd.g_old_rec.iid_information2;
641: End If;
642: If (p_rec.iid_information3 = hr_api.g_varchar2) then
643: p_rec.iid_information3 :=
644: irc_iid_shd.g_old_rec.iid_information3;
645: End If;
646: If (p_rec.iid_information4 = hr_api.g_varchar2) then
647: p_rec.iid_information4 :=
648: irc_iid_shd.g_old_rec.iid_information4;

Line 648: irc_iid_shd.g_old_rec.iid_information4;

644: irc_iid_shd.g_old_rec.iid_information3;
645: End If;
646: If (p_rec.iid_information4 = hr_api.g_varchar2) then
647: p_rec.iid_information4 :=
648: irc_iid_shd.g_old_rec.iid_information4;
649: End If;
650: If (p_rec.iid_information5 = hr_api.g_varchar2) then
651: p_rec.iid_information5 :=
652: irc_iid_shd.g_old_rec.iid_information5;

Line 652: irc_iid_shd.g_old_rec.iid_information5;

648: irc_iid_shd.g_old_rec.iid_information4;
649: End If;
650: If (p_rec.iid_information5 = hr_api.g_varchar2) then
651: p_rec.iid_information5 :=
652: irc_iid_shd.g_old_rec.iid_information5;
653: End If;
654: If (p_rec.iid_information6 = hr_api.g_varchar2) then
655: p_rec.iid_information6 :=
656: irc_iid_shd.g_old_rec.iid_information6;

Line 656: irc_iid_shd.g_old_rec.iid_information6;

652: irc_iid_shd.g_old_rec.iid_information5;
653: End If;
654: If (p_rec.iid_information6 = hr_api.g_varchar2) then
655: p_rec.iid_information6 :=
656: irc_iid_shd.g_old_rec.iid_information6;
657: End If;
658: If (p_rec.iid_information7 = hr_api.g_varchar2) then
659: p_rec.iid_information7 :=
660: irc_iid_shd.g_old_rec.iid_information7;

Line 660: irc_iid_shd.g_old_rec.iid_information7;

656: irc_iid_shd.g_old_rec.iid_information6;
657: End If;
658: If (p_rec.iid_information7 = hr_api.g_varchar2) then
659: p_rec.iid_information7 :=
660: irc_iid_shd.g_old_rec.iid_information7;
661: End If;
662: If (p_rec.iid_information8 = hr_api.g_varchar2) then
663: p_rec.iid_information8 :=
664: irc_iid_shd.g_old_rec.iid_information8;

Line 664: irc_iid_shd.g_old_rec.iid_information8;

660: irc_iid_shd.g_old_rec.iid_information7;
661: End If;
662: If (p_rec.iid_information8 = hr_api.g_varchar2) then
663: p_rec.iid_information8 :=
664: irc_iid_shd.g_old_rec.iid_information8;
665: End If;
666: If (p_rec.iid_information9 = hr_api.g_varchar2) then
667: p_rec.iid_information9 :=
668: irc_iid_shd.g_old_rec.iid_information9;

Line 668: irc_iid_shd.g_old_rec.iid_information9;

664: irc_iid_shd.g_old_rec.iid_information8;
665: End If;
666: If (p_rec.iid_information9 = hr_api.g_varchar2) then
667: p_rec.iid_information9 :=
668: irc_iid_shd.g_old_rec.iid_information9;
669: End If;
670: If (p_rec.iid_information10 = hr_api.g_varchar2) then
671: p_rec.iid_information10 :=
672: irc_iid_shd.g_old_rec.iid_information10;

Line 672: irc_iid_shd.g_old_rec.iid_information10;

668: irc_iid_shd.g_old_rec.iid_information9;
669: End If;
670: If (p_rec.iid_information10 = hr_api.g_varchar2) then
671: p_rec.iid_information10 :=
672: irc_iid_shd.g_old_rec.iid_information10;
673: End If;
674: If (p_rec.iid_information11 = hr_api.g_varchar2) then
675: p_rec.iid_information11 :=
676: irc_iid_shd.g_old_rec.iid_information11;

Line 676: irc_iid_shd.g_old_rec.iid_information11;

672: irc_iid_shd.g_old_rec.iid_information10;
673: End If;
674: If (p_rec.iid_information11 = hr_api.g_varchar2) then
675: p_rec.iid_information11 :=
676: irc_iid_shd.g_old_rec.iid_information11;
677: End If;
678: If (p_rec.iid_information12 = hr_api.g_varchar2) then
679: p_rec.iid_information12 :=
680: irc_iid_shd.g_old_rec.iid_information12;

Line 680: irc_iid_shd.g_old_rec.iid_information12;

676: irc_iid_shd.g_old_rec.iid_information11;
677: End If;
678: If (p_rec.iid_information12 = hr_api.g_varchar2) then
679: p_rec.iid_information12 :=
680: irc_iid_shd.g_old_rec.iid_information12;
681: End If;
682: If (p_rec.iid_information13 = hr_api.g_varchar2) then
683: p_rec.iid_information13 :=
684: irc_iid_shd.g_old_rec.iid_information13;

Line 684: irc_iid_shd.g_old_rec.iid_information13;

680: irc_iid_shd.g_old_rec.iid_information12;
681: End If;
682: If (p_rec.iid_information13 = hr_api.g_varchar2) then
683: p_rec.iid_information13 :=
684: irc_iid_shd.g_old_rec.iid_information13;
685: End If;
686: If (p_rec.iid_information14 = hr_api.g_varchar2) then
687: p_rec.iid_information14 :=
688: irc_iid_shd.g_old_rec.iid_information14;

Line 688: irc_iid_shd.g_old_rec.iid_information14;

684: irc_iid_shd.g_old_rec.iid_information13;
685: End If;
686: If (p_rec.iid_information14 = hr_api.g_varchar2) then
687: p_rec.iid_information14 :=
688: irc_iid_shd.g_old_rec.iid_information14;
689: End If;
690: If (p_rec.iid_information15 = hr_api.g_varchar2) then
691: p_rec.iid_information15 :=
692: irc_iid_shd.g_old_rec.iid_information15;

Line 692: irc_iid_shd.g_old_rec.iid_information15;

688: irc_iid_shd.g_old_rec.iid_information14;
689: End If;
690: If (p_rec.iid_information15 = hr_api.g_varchar2) then
691: p_rec.iid_information15 :=
692: irc_iid_shd.g_old_rec.iid_information15;
693: End If;
694: If (p_rec.iid_information16 = hr_api.g_varchar2) then
695: p_rec.iid_information16 :=
696: irc_iid_shd.g_old_rec.iid_information16;

Line 696: irc_iid_shd.g_old_rec.iid_information16;

692: irc_iid_shd.g_old_rec.iid_information15;
693: End If;
694: If (p_rec.iid_information16 = hr_api.g_varchar2) then
695: p_rec.iid_information16 :=
696: irc_iid_shd.g_old_rec.iid_information16;
697: End If;
698: If (p_rec.iid_information17 = hr_api.g_varchar2) then
699: p_rec.iid_information17 :=
700: irc_iid_shd.g_old_rec.iid_information17;

Line 700: irc_iid_shd.g_old_rec.iid_information17;

696: irc_iid_shd.g_old_rec.iid_information16;
697: End If;
698: If (p_rec.iid_information17 = hr_api.g_varchar2) then
699: p_rec.iid_information17 :=
700: irc_iid_shd.g_old_rec.iid_information17;
701: End If;
702: If (p_rec.iid_information18 = hr_api.g_varchar2) then
703: p_rec.iid_information18 :=
704: irc_iid_shd.g_old_rec.iid_information18;

Line 704: irc_iid_shd.g_old_rec.iid_information18;

700: irc_iid_shd.g_old_rec.iid_information17;
701: End If;
702: If (p_rec.iid_information18 = hr_api.g_varchar2) then
703: p_rec.iid_information18 :=
704: irc_iid_shd.g_old_rec.iid_information18;
705: End If;
706: If (p_rec.iid_information19 = hr_api.g_varchar2) then
707: p_rec.iid_information19 :=
708: irc_iid_shd.g_old_rec.iid_information19;

Line 708: irc_iid_shd.g_old_rec.iid_information19;

704: irc_iid_shd.g_old_rec.iid_information18;
705: End If;
706: If (p_rec.iid_information19 = hr_api.g_varchar2) then
707: p_rec.iid_information19 :=
708: irc_iid_shd.g_old_rec.iid_information19;
709: End If;
710: If (p_rec.iid_information20 = hr_api.g_varchar2) then
711: p_rec.iid_information20 :=
712: irc_iid_shd.g_old_rec.iid_information20;

Line 712: irc_iid_shd.g_old_rec.iid_information20;

708: irc_iid_shd.g_old_rec.iid_information19;
709: End If;
710: If (p_rec.iid_information20 = hr_api.g_varchar2) then
711: p_rec.iid_information20 :=
712: irc_iid_shd.g_old_rec.iid_information20;
713: End If;
714: If (p_rec.start_date = hr_api.g_date) then
715: p_rec.start_date :=
716: irc_iid_shd.g_old_rec.start_date;

Line 716: irc_iid_shd.g_old_rec.start_date;

712: irc_iid_shd.g_old_rec.iid_information20;
713: End If;
714: If (p_rec.start_date = hr_api.g_date) then
715: p_rec.start_date :=
716: irc_iid_shd.g_old_rec.start_date;
717: End If;
718: If (p_rec.end_date = hr_api.g_date) then
719: p_rec.end_date :=
720: irc_iid_shd.g_old_rec.end_date;

Line 720: irc_iid_shd.g_old_rec.end_date;

716: irc_iid_shd.g_old_rec.start_date;
717: End If;
718: If (p_rec.end_date = hr_api.g_date) then
719: p_rec.end_date :=
720: irc_iid_shd.g_old_rec.end_date;
721: End If;
722: If (p_rec.event_id = hr_api.g_number) then
723: p_rec.event_id :=
724: irc_iid_shd.g_old_rec.event_id;

Line 724: irc_iid_shd.g_old_rec.event_id;

720: irc_iid_shd.g_old_rec.end_date;
721: End If;
722: If (p_rec.event_id = hr_api.g_number) then
723: p_rec.event_id :=
724: irc_iid_shd.g_old_rec.event_id;
725: End If;
726: --
727: End convert_defs;
728: --

Line 735: ,p_rec in out nocopy irc_iid_shd.g_rec_type

731: -- ----------------------------------------------------------------------------
732: Procedure upd
733: (p_effective_date in date
734: ,p_datetrack_mode in varchar2
735: ,p_rec in out nocopy irc_iid_shd.g_rec_type
736: ) is
737: --
738: l_proc varchar2(72) := g_package||'upd';
739: l_validation_start_date date;

Line 751: irc_iid_shd.lck

747: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
748: --
749: -- We must lock the row which we need to update.
750: --
751: irc_iid_shd.lck
752: (p_effective_date => p_effective_date
753: ,p_datetrack_mode => p_datetrack_mode
754: ,p_interview_details_id => p_rec.interview_details_id
755: ,p_object_version_number => p_rec.object_version_number

Line 853: l_rec irc_iid_shd.g_rec_type;

849: ,p_start_date out nocopy date
850: ,p_end_date out nocopy date
851: ) is
852: --
853: l_rec irc_iid_shd.g_rec_type;
854: l_proc varchar2(72) := g_package||'upd';
855: --
856: Begin
857: hr_utility.set_location('Entering:'||l_proc, 5);

Line 863: irc_iid_shd.convert_args

859: -- Call conversion function to turn arguments into the
860: -- l_rec structure.
861: --
862: l_rec :=
863: irc_iid_shd.convert_args
864: (p_interview_details_id
865: ,p_status
866: ,p_feedback
867: ,p_notes