DBA Data[Home] [Help]

APPS.IRC_IRF_UPD dependencies on IRC_IRF_SHD

Line 58: (p_rec in out nocopy irc_irf_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy irc_irf_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_irf_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_irf_shd.get_object_version_number
78: (p_referral_info_id => p_rec.referral_info_id
79: );
80: --
81: --

Line 147: irc_irf_shd.constraint_error

143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
147: irc_irf_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --

Line 152: irc_irf_shd.constraint_error

148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
152: irc_irf_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: --
156: Raise;

Line 191: (p_rec in out nocopy irc_irf_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure update_dml
191: (p_rec in out nocopy irc_irf_shd.g_rec_type
192: ,p_effective_date in date
193: ,p_datetrack_mode in varchar2
194: ,p_validation_start_date in date
195: ,p_validation_end_date in date

Line 258: (p_rec in out nocopy irc_irf_shd.g_rec_type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure dt_pre_update
258: (p_rec in out nocopy irc_irf_shd.g_rec_type
259: ,p_effective_date in date
260: ,p_datetrack_mode in varchar2
261: ,p_validation_start_date in date
262: ,p_validation_end_date in date

Line 274: irc_irf_shd.upd_end_date

270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: irc_irf_shd.upd_end_date
275: (p_effective_date => p_effective_date
276: ,p_referral_info_id => p_rec.referral_info_id
277: ,p_new_end_date => p_validation_start_date
278: ,p_object_version_number => l_dummy_version_number

Line 341: (p_rec in out nocopy irc_irf_shd.g_rec_type

337: --
338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure pre_update
341: (p_rec in out nocopy irc_irf_shd.g_rec_type
342: ,p_effective_date in date
343: ,p_datetrack_mode in varchar2
344: ,p_validation_start_date in date
345: ,p_validation_end_date in date

Line 399: (p_rec in irc_irf_shd.g_rec_type

395: --
396: -- {End Of Comments}
397: -- ----------------------------------------------------------------------------
398: Procedure post_update
399: (p_rec in irc_irf_shd.g_rec_type
400: ,p_effective_date in date
401: ,p_datetrack_mode in varchar2
402: ,p_validation_start_date in date
403: ,p_validation_end_date in date

Line 460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date

456: ,p_irf_information10 => p_rec.irf_information10
457: ,p_object_created_by => p_rec.object_created_by
458: ,p_created_by => p_rec.created_by
459: ,p_object_version_number => p_rec.object_version_number
460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1

Line 461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date

457: ,p_object_created_by => p_rec.object_created_by
458: ,p_created_by => p_rec.created_by
459: ,p_object_version_number => p_rec.object_version_number
460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1

Line 462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type

458: ,p_created_by => p_rec.created_by
459: ,p_object_version_number => p_rec.object_version_number
460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2

Line 463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name

459: ,p_object_version_number => p_rec.object_version_number
460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2

Line 464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1

460: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3

Line 465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1

461: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3

Line 466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2

462: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4

Line 467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2

463: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4

Line 468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3

464: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5

Line 469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3

465: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5

Line 470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4

466: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id

Line 471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4

467: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment

Line 472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5

468: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment

Line 473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5

469: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category

Line 474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id

470: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1

Line 475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment

471: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2

Line 476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment

472: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3

Line 477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category

473: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4

Line 478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1

474: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5

Line 479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2

475: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6

Line 480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3

476: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7

Line 481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4

477: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8

Line 482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5

478: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9

Line 483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6

479: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10

Line 484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7

480: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category

Line 485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8

481: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1

Line 486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9

482: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2

Line 487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10

483: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3

Line 488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category

484: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4

Line 489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1

485: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5

Line 490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2

486: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6

Line 491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3

487: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7

Line 492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4

488: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8

Line 493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5

489: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9

Line 494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6

490: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10

Line 495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7

491: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by

Line 496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8

492: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by

Line 497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9

493: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number

Line 498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10

494: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
502: );

Line 499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by

495: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
502: );
503: --

Line 500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by

496: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
502: );
503: --
504: exception

Line 501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number

497: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
498: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
499: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
500: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
501: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
502: );
503: --
504: exception
505: --

Line 561: (p_rec in out nocopy irc_irf_shd.g_rec_type

557: --
558: -- {End Of Comments}
559: -- ----------------------------------------------------------------------------
560: Procedure convert_defs
561: (p_rec in out nocopy irc_irf_shd.g_rec_type
562: ) is
563: --
564: Begin
565: --

Line 573: irc_irf_shd.g_old_rec.object_id;

569: -- is being used then we must set to the 'current' argument value.
570: --
571: If (p_rec.object_id = hr_api.g_number) then
572: p_rec.object_id :=
573: irc_irf_shd.g_old_rec.object_id;
574: End If;
575: If (p_rec.object_type = hr_api.g_varchar2) then
576: p_rec.object_type :=
577: irc_irf_shd.g_old_rec.object_type;

Line 577: irc_irf_shd.g_old_rec.object_type;

573: irc_irf_shd.g_old_rec.object_id;
574: End If;
575: If (p_rec.object_type = hr_api.g_varchar2) then
576: p_rec.object_type :=
577: irc_irf_shd.g_old_rec.object_type;
578: End If;
579: If (p_rec.start_date = hr_api.g_date) then
580: p_rec.start_date :=
581: irc_irf_shd.g_old_rec.start_date;

Line 581: irc_irf_shd.g_old_rec.start_date;

577: irc_irf_shd.g_old_rec.object_type;
578: End If;
579: If (p_rec.start_date = hr_api.g_date) then
580: p_rec.start_date :=
581: irc_irf_shd.g_old_rec.start_date;
582: End If;
583: If (p_rec.end_date = hr_api.g_date) then
584: p_rec.end_date :=
585: irc_irf_shd.g_old_rec.end_date;

Line 585: irc_irf_shd.g_old_rec.end_date;

581: irc_irf_shd.g_old_rec.start_date;
582: End If;
583: If (p_rec.end_date = hr_api.g_date) then
584: p_rec.end_date :=
585: irc_irf_shd.g_old_rec.end_date;
586: End If;
587: If (p_rec.source_type = hr_api.g_varchar2) then
588: p_rec.source_type :=
589: irc_irf_shd.g_old_rec.source_type;

Line 589: irc_irf_shd.g_old_rec.source_type;

585: irc_irf_shd.g_old_rec.end_date;
586: End If;
587: If (p_rec.source_type = hr_api.g_varchar2) then
588: p_rec.source_type :=
589: irc_irf_shd.g_old_rec.source_type;
590: End If;
591: If (p_rec.source_name = hr_api.g_varchar2) then
592: p_rec.source_name :=
593: irc_irf_shd.g_old_rec.source_name;

Line 593: irc_irf_shd.g_old_rec.source_name;

589: irc_irf_shd.g_old_rec.source_type;
590: End If;
591: If (p_rec.source_name = hr_api.g_varchar2) then
592: p_rec.source_name :=
593: irc_irf_shd.g_old_rec.source_name;
594: End If;
595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then
596: p_rec.source_criteria1 :=
597: irc_irf_shd.g_old_rec.source_criteria1;

Line 597: irc_irf_shd.g_old_rec.source_criteria1;

593: irc_irf_shd.g_old_rec.source_name;
594: End If;
595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then
596: p_rec.source_criteria1 :=
597: irc_irf_shd.g_old_rec.source_criteria1;
598: End If;
599: If (p_rec.source_value1 = hr_api.g_varchar2) then
600: p_rec.source_value1 :=
601: irc_irf_shd.g_old_rec.source_value1;

Line 601: irc_irf_shd.g_old_rec.source_value1;

597: irc_irf_shd.g_old_rec.source_criteria1;
598: End If;
599: If (p_rec.source_value1 = hr_api.g_varchar2) then
600: p_rec.source_value1 :=
601: irc_irf_shd.g_old_rec.source_value1;
602: End If;
603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then
604: p_rec.source_criteria2 :=
605: irc_irf_shd.g_old_rec.source_criteria2;

Line 605: irc_irf_shd.g_old_rec.source_criteria2;

601: irc_irf_shd.g_old_rec.source_value1;
602: End If;
603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then
604: p_rec.source_criteria2 :=
605: irc_irf_shd.g_old_rec.source_criteria2;
606: End If;
607: If (p_rec.source_value2 = hr_api.g_varchar2) then
608: p_rec.source_value2 :=
609: irc_irf_shd.g_old_rec.source_value2;

Line 609: irc_irf_shd.g_old_rec.source_value2;

605: irc_irf_shd.g_old_rec.source_criteria2;
606: End If;
607: If (p_rec.source_value2 = hr_api.g_varchar2) then
608: p_rec.source_value2 :=
609: irc_irf_shd.g_old_rec.source_value2;
610: End If;
611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then
612: p_rec.source_criteria3 :=
613: irc_irf_shd.g_old_rec.source_criteria3;

Line 613: irc_irf_shd.g_old_rec.source_criteria3;

609: irc_irf_shd.g_old_rec.source_value2;
610: End If;
611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then
612: p_rec.source_criteria3 :=
613: irc_irf_shd.g_old_rec.source_criteria3;
614: End If;
615: If (p_rec.source_value3 = hr_api.g_varchar2) then
616: p_rec.source_value3 :=
617: irc_irf_shd.g_old_rec.source_value3;

Line 617: irc_irf_shd.g_old_rec.source_value3;

613: irc_irf_shd.g_old_rec.source_criteria3;
614: End If;
615: If (p_rec.source_value3 = hr_api.g_varchar2) then
616: p_rec.source_value3 :=
617: irc_irf_shd.g_old_rec.source_value3;
618: End If;
619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then
620: p_rec.source_criteria4 :=
621: irc_irf_shd.g_old_rec.source_criteria4;

Line 621: irc_irf_shd.g_old_rec.source_criteria4;

617: irc_irf_shd.g_old_rec.source_value3;
618: End If;
619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then
620: p_rec.source_criteria4 :=
621: irc_irf_shd.g_old_rec.source_criteria4;
622: End If;
623: If (p_rec.source_value4 = hr_api.g_varchar2) then
624: p_rec.source_value4 :=
625: irc_irf_shd.g_old_rec.source_value4;

Line 625: irc_irf_shd.g_old_rec.source_value4;

621: irc_irf_shd.g_old_rec.source_criteria4;
622: End If;
623: If (p_rec.source_value4 = hr_api.g_varchar2) then
624: p_rec.source_value4 :=
625: irc_irf_shd.g_old_rec.source_value4;
626: End If;
627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then
628: p_rec.source_criteria5 :=
629: irc_irf_shd.g_old_rec.source_criteria5;

Line 629: irc_irf_shd.g_old_rec.source_criteria5;

625: irc_irf_shd.g_old_rec.source_value4;
626: End If;
627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then
628: p_rec.source_criteria5 :=
629: irc_irf_shd.g_old_rec.source_criteria5;
630: End If;
631: If (p_rec.source_value5 = hr_api.g_varchar2) then
632: p_rec.source_value5 :=
633: irc_irf_shd.g_old_rec.source_value5;

Line 633: irc_irf_shd.g_old_rec.source_value5;

629: irc_irf_shd.g_old_rec.source_criteria5;
630: End If;
631: If (p_rec.source_value5 = hr_api.g_varchar2) then
632: p_rec.source_value5 :=
633: irc_irf_shd.g_old_rec.source_value5;
634: End If;
635: If (p_rec.source_person_id = hr_api.g_number) then
636: p_rec.source_person_id :=
637: irc_irf_shd.g_old_rec.source_person_id;

Line 637: irc_irf_shd.g_old_rec.source_person_id;

633: irc_irf_shd.g_old_rec.source_value5;
634: End If;
635: If (p_rec.source_person_id = hr_api.g_number) then
636: p_rec.source_person_id :=
637: irc_irf_shd.g_old_rec.source_person_id;
638: End If;
639: If (p_rec.candidate_comment = hr_api.g_varchar2) then
640: p_rec.candidate_comment :=
641: irc_irf_shd.g_old_rec.candidate_comment;

Line 641: irc_irf_shd.g_old_rec.candidate_comment;

637: irc_irf_shd.g_old_rec.source_person_id;
638: End If;
639: If (p_rec.candidate_comment = hr_api.g_varchar2) then
640: p_rec.candidate_comment :=
641: irc_irf_shd.g_old_rec.candidate_comment;
642: End If;
643: If (p_rec.employee_comment = hr_api.g_varchar2) then
644: p_rec.employee_comment :=
645: irc_irf_shd.g_old_rec.employee_comment;

Line 645: irc_irf_shd.g_old_rec.employee_comment;

641: irc_irf_shd.g_old_rec.candidate_comment;
642: End If;
643: If (p_rec.employee_comment = hr_api.g_varchar2) then
644: p_rec.employee_comment :=
645: irc_irf_shd.g_old_rec.employee_comment;
646: End If;
647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then
648: p_rec.irf_attribute_category :=
649: irc_irf_shd.g_old_rec.irf_attribute_category;

Line 649: irc_irf_shd.g_old_rec.irf_attribute_category;

645: irc_irf_shd.g_old_rec.employee_comment;
646: End If;
647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then
648: p_rec.irf_attribute_category :=
649: irc_irf_shd.g_old_rec.irf_attribute_category;
650: End If;
651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then
652: p_rec.irf_attribute1 :=
653: irc_irf_shd.g_old_rec.irf_attribute1;

Line 653: irc_irf_shd.g_old_rec.irf_attribute1;

649: irc_irf_shd.g_old_rec.irf_attribute_category;
650: End If;
651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then
652: p_rec.irf_attribute1 :=
653: irc_irf_shd.g_old_rec.irf_attribute1;
654: End If;
655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then
656: p_rec.irf_attribute2 :=
657: irc_irf_shd.g_old_rec.irf_attribute2;

Line 657: irc_irf_shd.g_old_rec.irf_attribute2;

653: irc_irf_shd.g_old_rec.irf_attribute1;
654: End If;
655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then
656: p_rec.irf_attribute2 :=
657: irc_irf_shd.g_old_rec.irf_attribute2;
658: End If;
659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then
660: p_rec.irf_attribute3 :=
661: irc_irf_shd.g_old_rec.irf_attribute3;

Line 661: irc_irf_shd.g_old_rec.irf_attribute3;

657: irc_irf_shd.g_old_rec.irf_attribute2;
658: End If;
659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then
660: p_rec.irf_attribute3 :=
661: irc_irf_shd.g_old_rec.irf_attribute3;
662: End If;
663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then
664: p_rec.irf_attribute4 :=
665: irc_irf_shd.g_old_rec.irf_attribute4;

Line 665: irc_irf_shd.g_old_rec.irf_attribute4;

661: irc_irf_shd.g_old_rec.irf_attribute3;
662: End If;
663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then
664: p_rec.irf_attribute4 :=
665: irc_irf_shd.g_old_rec.irf_attribute4;
666: End If;
667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then
668: p_rec.irf_attribute5 :=
669: irc_irf_shd.g_old_rec.irf_attribute5;

Line 669: irc_irf_shd.g_old_rec.irf_attribute5;

665: irc_irf_shd.g_old_rec.irf_attribute4;
666: End If;
667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then
668: p_rec.irf_attribute5 :=
669: irc_irf_shd.g_old_rec.irf_attribute5;
670: End If;
671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then
672: p_rec.irf_attribute6 :=
673: irc_irf_shd.g_old_rec.irf_attribute6;

Line 673: irc_irf_shd.g_old_rec.irf_attribute6;

669: irc_irf_shd.g_old_rec.irf_attribute5;
670: End If;
671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then
672: p_rec.irf_attribute6 :=
673: irc_irf_shd.g_old_rec.irf_attribute6;
674: End If;
675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then
676: p_rec.irf_attribute7 :=
677: irc_irf_shd.g_old_rec.irf_attribute7;

Line 677: irc_irf_shd.g_old_rec.irf_attribute7;

673: irc_irf_shd.g_old_rec.irf_attribute6;
674: End If;
675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then
676: p_rec.irf_attribute7 :=
677: irc_irf_shd.g_old_rec.irf_attribute7;
678: End If;
679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then
680: p_rec.irf_attribute8 :=
681: irc_irf_shd.g_old_rec.irf_attribute8;

Line 681: irc_irf_shd.g_old_rec.irf_attribute8;

677: irc_irf_shd.g_old_rec.irf_attribute7;
678: End If;
679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then
680: p_rec.irf_attribute8 :=
681: irc_irf_shd.g_old_rec.irf_attribute8;
682: End If;
683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then
684: p_rec.irf_attribute9 :=
685: irc_irf_shd.g_old_rec.irf_attribute9;

Line 685: irc_irf_shd.g_old_rec.irf_attribute9;

681: irc_irf_shd.g_old_rec.irf_attribute8;
682: End If;
683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then
684: p_rec.irf_attribute9 :=
685: irc_irf_shd.g_old_rec.irf_attribute9;
686: End If;
687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then
688: p_rec.irf_attribute10 :=
689: irc_irf_shd.g_old_rec.irf_attribute10;

Line 689: irc_irf_shd.g_old_rec.irf_attribute10;

685: irc_irf_shd.g_old_rec.irf_attribute9;
686: End If;
687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then
688: p_rec.irf_attribute10 :=
689: irc_irf_shd.g_old_rec.irf_attribute10;
690: End If;
691: If (p_rec.irf_information_category = hr_api.g_varchar2) then
692: p_rec.irf_information_category :=
693: irc_irf_shd.g_old_rec.irf_information_category;

Line 693: irc_irf_shd.g_old_rec.irf_information_category;

689: irc_irf_shd.g_old_rec.irf_attribute10;
690: End If;
691: If (p_rec.irf_information_category = hr_api.g_varchar2) then
692: p_rec.irf_information_category :=
693: irc_irf_shd.g_old_rec.irf_information_category;
694: End If;
695: If (p_rec.irf_information1 = hr_api.g_varchar2) then
696: p_rec.irf_information1 :=
697: irc_irf_shd.g_old_rec.irf_information1;

Line 697: irc_irf_shd.g_old_rec.irf_information1;

693: irc_irf_shd.g_old_rec.irf_information_category;
694: End If;
695: If (p_rec.irf_information1 = hr_api.g_varchar2) then
696: p_rec.irf_information1 :=
697: irc_irf_shd.g_old_rec.irf_information1;
698: End If;
699: If (p_rec.irf_information2 = hr_api.g_varchar2) then
700: p_rec.irf_information2 :=
701: irc_irf_shd.g_old_rec.irf_information2;

Line 701: irc_irf_shd.g_old_rec.irf_information2;

697: irc_irf_shd.g_old_rec.irf_information1;
698: End If;
699: If (p_rec.irf_information2 = hr_api.g_varchar2) then
700: p_rec.irf_information2 :=
701: irc_irf_shd.g_old_rec.irf_information2;
702: End If;
703: If (p_rec.irf_information3 = hr_api.g_varchar2) then
704: p_rec.irf_information3 :=
705: irc_irf_shd.g_old_rec.irf_information3;

Line 705: irc_irf_shd.g_old_rec.irf_information3;

701: irc_irf_shd.g_old_rec.irf_information2;
702: End If;
703: If (p_rec.irf_information3 = hr_api.g_varchar2) then
704: p_rec.irf_information3 :=
705: irc_irf_shd.g_old_rec.irf_information3;
706: End If;
707: If (p_rec.irf_information4 = hr_api.g_varchar2) then
708: p_rec.irf_information4 :=
709: irc_irf_shd.g_old_rec.irf_information4;

Line 709: irc_irf_shd.g_old_rec.irf_information4;

705: irc_irf_shd.g_old_rec.irf_information3;
706: End If;
707: If (p_rec.irf_information4 = hr_api.g_varchar2) then
708: p_rec.irf_information4 :=
709: irc_irf_shd.g_old_rec.irf_information4;
710: End If;
711: If (p_rec.irf_information5 = hr_api.g_varchar2) then
712: p_rec.irf_information5 :=
713: irc_irf_shd.g_old_rec.irf_information5;

Line 713: irc_irf_shd.g_old_rec.irf_information5;

709: irc_irf_shd.g_old_rec.irf_information4;
710: End If;
711: If (p_rec.irf_information5 = hr_api.g_varchar2) then
712: p_rec.irf_information5 :=
713: irc_irf_shd.g_old_rec.irf_information5;
714: End If;
715: If (p_rec.irf_information6 = hr_api.g_varchar2) then
716: p_rec.irf_information6 :=
717: irc_irf_shd.g_old_rec.irf_information6;

Line 717: irc_irf_shd.g_old_rec.irf_information6;

713: irc_irf_shd.g_old_rec.irf_information5;
714: End If;
715: If (p_rec.irf_information6 = hr_api.g_varchar2) then
716: p_rec.irf_information6 :=
717: irc_irf_shd.g_old_rec.irf_information6;
718: End If;
719: If (p_rec.irf_information7 = hr_api.g_varchar2) then
720: p_rec.irf_information7 :=
721: irc_irf_shd.g_old_rec.irf_information7;

Line 721: irc_irf_shd.g_old_rec.irf_information7;

717: irc_irf_shd.g_old_rec.irf_information6;
718: End If;
719: If (p_rec.irf_information7 = hr_api.g_varchar2) then
720: p_rec.irf_information7 :=
721: irc_irf_shd.g_old_rec.irf_information7;
722: End If;
723: If (p_rec.irf_information8 = hr_api.g_varchar2) then
724: p_rec.irf_information8 :=
725: irc_irf_shd.g_old_rec.irf_information8;

Line 725: irc_irf_shd.g_old_rec.irf_information8;

721: irc_irf_shd.g_old_rec.irf_information7;
722: End If;
723: If (p_rec.irf_information8 = hr_api.g_varchar2) then
724: p_rec.irf_information8 :=
725: irc_irf_shd.g_old_rec.irf_information8;
726: End If;
727: If (p_rec.irf_information9 = hr_api.g_varchar2) then
728: p_rec.irf_information9 :=
729: irc_irf_shd.g_old_rec.irf_information9;

Line 729: irc_irf_shd.g_old_rec.irf_information9;

725: irc_irf_shd.g_old_rec.irf_information8;
726: End If;
727: If (p_rec.irf_information9 = hr_api.g_varchar2) then
728: p_rec.irf_information9 :=
729: irc_irf_shd.g_old_rec.irf_information9;
730: End If;
731: If (p_rec.irf_information10 = hr_api.g_varchar2) then
732: p_rec.irf_information10 :=
733: irc_irf_shd.g_old_rec.irf_information10;

Line 733: irc_irf_shd.g_old_rec.irf_information10;

729: irc_irf_shd.g_old_rec.irf_information9;
730: End If;
731: If (p_rec.irf_information10 = hr_api.g_varchar2) then
732: p_rec.irf_information10 :=
733: irc_irf_shd.g_old_rec.irf_information10;
734: End If;
735: If (p_rec.object_created_by = hr_api.g_varchar2) then
736: p_rec.object_created_by :=
737: irc_irf_shd.g_old_rec.object_created_by;

Line 737: irc_irf_shd.g_old_rec.object_created_by;

733: irc_irf_shd.g_old_rec.irf_information10;
734: End If;
735: If (p_rec.object_created_by = hr_api.g_varchar2) then
736: p_rec.object_created_by :=
737: irc_irf_shd.g_old_rec.object_created_by;
738: End If;
739: --
740: End convert_defs;
741: --

Line 748: ,p_rec in out nocopy irc_irf_shd.g_rec_type

744: -- ----------------------------------------------------------------------------
745: Procedure upd
746: (p_effective_date in date
747: ,p_datetrack_mode in varchar2
748: ,p_rec in out nocopy irc_irf_shd.g_rec_type
749: ) is
750: --
751: l_proc varchar2(72) := g_package||'upd';
752: l_validation_start_date date;

Line 764: irc_irf_shd.lck

760: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
761: --
762: -- We must lock the row which we need to update.
763: --
764: irc_irf_shd.lck
765: (p_effective_date => p_effective_date
766: ,p_datetrack_mode => p_datetrack_mode
767: ,p_referral_info_id => p_rec.referral_info_id
768: ,p_object_version_number => p_rec.object_version_number

Line 875: l_rec irc_irf_shd.g_rec_type;

871: ,p_start_date out nocopy date
872: ,p_end_date out nocopy date
873: ) is
874: --
875: l_rec irc_irf_shd.g_rec_type;
876: l_proc varchar2(72) := g_package||'upd';
877: --
878: Begin
879: hr_utility.set_location('Entering:'||l_proc, 5);

Line 885: irc_irf_shd.convert_args

881: -- Call conversion function to turn arguments into the
882: -- l_rec structure.
883: --
884: l_rec :=
885: irc_irf_shd.convert_args
886: (p_referral_info_id
887: ,hr_api.g_number
888: ,hr_api.g_varchar2
889: ,p_start_date