DBA Data[Home] [Help]

APPS.IRC_IAD_UPD dependencies on IRC_IAD_SHD

Line 58: (p_rec in out nocopy irc_iad_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy irc_iad_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 114: irc_iad_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: irc_iad_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: irc_iad_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: irc_iad_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 158: (p_rec in out nocopy irc_iad_shd.g_rec_type

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure update_dml
158: (p_rec in out nocopy irc_iad_shd.g_rec_type
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
161: ,p_validation_start_date in date
162: ,p_validation_end_date in date

Line 225: (p_rec in out nocopy irc_iad_shd.g_rec_type

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy irc_iad_shd.g_rec_type
226: ,p_effective_date in date
227: ,p_datetrack_mode in varchar2
228: ,p_validation_start_date in date
229: ,p_validation_end_date in date

Line 242: irc_iad_shd.upd_effective_end_date

238: --
239: -- Update the current effective end date
240: --
241: hr_utility.set_location(l_proc, 10);
242: irc_iad_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.assignment_id
245: ,p_new_effective_end_date => (p_validation_start_date - 1)
246: ,p_validation_start_date => p_validation_start_date

Line 341: (p_rec in out nocopy irc_iad_shd.g_rec_type

337: --
338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure pre_update
341: (p_rec in out nocopy irc_iad_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_iad_shd.g_rec_type

395: --
396: -- {End Of Comments}
397: -- ----------------------------------------------------------------------------
398: Procedure post_update
399: (p_rec in irc_iad_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 442: => irc_iad_shd.g_old_rec.assignment_id

438: => p_rec.attempt_id
439: ,p_object_version_number
440: => p_rec.object_version_number
441: ,p_assignment_id_o
442: => irc_iad_shd.g_old_rec.assignment_id
443: ,p_effective_start_date_o
444: => irc_iad_shd.g_old_rec.effective_start_date
445: ,p_effective_end_date_o
446: => irc_iad_shd.g_old_rec.effective_end_date

Line 444: => irc_iad_shd.g_old_rec.effective_start_date

440: => p_rec.object_version_number
441: ,p_assignment_id_o
442: => irc_iad_shd.g_old_rec.assignment_id
443: ,p_effective_start_date_o
444: => irc_iad_shd.g_old_rec.effective_start_date
445: ,p_effective_end_date_o
446: => irc_iad_shd.g_old_rec.effective_end_date
447: ,p_details_version_o
448: => irc_iad_shd.g_old_rec.details_version

Line 446: => irc_iad_shd.g_old_rec.effective_end_date

442: => irc_iad_shd.g_old_rec.assignment_id
443: ,p_effective_start_date_o
444: => irc_iad_shd.g_old_rec.effective_start_date
445: ,p_effective_end_date_o
446: => irc_iad_shd.g_old_rec.effective_end_date
447: ,p_details_version_o
448: => irc_iad_shd.g_old_rec.details_version
449: ,p_latest_details_o
450: => irc_iad_shd.g_old_rec.latest_details

Line 448: => irc_iad_shd.g_old_rec.details_version

444: => irc_iad_shd.g_old_rec.effective_start_date
445: ,p_effective_end_date_o
446: => irc_iad_shd.g_old_rec.effective_end_date
447: ,p_details_version_o
448: => irc_iad_shd.g_old_rec.details_version
449: ,p_latest_details_o
450: => irc_iad_shd.g_old_rec.latest_details
451: ,p_attempt_id_o
452: => irc_iad_shd.g_old_rec.attempt_id

Line 450: => irc_iad_shd.g_old_rec.latest_details

446: => irc_iad_shd.g_old_rec.effective_end_date
447: ,p_details_version_o
448: => irc_iad_shd.g_old_rec.details_version
449: ,p_latest_details_o
450: => irc_iad_shd.g_old_rec.latest_details
451: ,p_attempt_id_o
452: => irc_iad_shd.g_old_rec.attempt_id
453: ,p_qualified_o
454: => irc_iad_shd.g_old_rec.qualified

Line 452: => irc_iad_shd.g_old_rec.attempt_id

448: => irc_iad_shd.g_old_rec.details_version
449: ,p_latest_details_o
450: => irc_iad_shd.g_old_rec.latest_details
451: ,p_attempt_id_o
452: => irc_iad_shd.g_old_rec.attempt_id
453: ,p_qualified_o
454: => irc_iad_shd.g_old_rec.qualified
455: ,p_considered_o
456: => irc_iad_shd.g_old_rec.considered

Line 454: => irc_iad_shd.g_old_rec.qualified

450: => irc_iad_shd.g_old_rec.latest_details
451: ,p_attempt_id_o
452: => irc_iad_shd.g_old_rec.attempt_id
453: ,p_qualified_o
454: => irc_iad_shd.g_old_rec.qualified
455: ,p_considered_o
456: => irc_iad_shd.g_old_rec.considered
457: ,p_object_version_number_o
458: => irc_iad_shd.g_old_rec.object_version_number

Line 456: => irc_iad_shd.g_old_rec.considered

452: => irc_iad_shd.g_old_rec.attempt_id
453: ,p_qualified_o
454: => irc_iad_shd.g_old_rec.qualified
455: ,p_considered_o
456: => irc_iad_shd.g_old_rec.considered
457: ,p_object_version_number_o
458: => irc_iad_shd.g_old_rec.object_version_number
459: );
460: --

Line 458: => irc_iad_shd.g_old_rec.object_version_number

454: => irc_iad_shd.g_old_rec.qualified
455: ,p_considered_o
456: => irc_iad_shd.g_old_rec.considered
457: ,p_object_version_number_o
458: => irc_iad_shd.g_old_rec.object_version_number
459: );
460: --
461: exception
462: --

Line 518: (p_rec in out nocopy irc_iad_shd.g_rec_type

514: --
515: -- {End Of Comments}
516: -- ----------------------------------------------------------------------------
517: Procedure convert_defs
518: (p_rec in out nocopy irc_iad_shd.g_rec_type
519: ) is
520: --
521: Begin
522: --

Line 530: irc_iad_shd.g_old_rec.assignment_id;

526: -- is being used then we must set to the 'current' argument value.
527: --
528: If (p_rec.assignment_id = hr_api.g_number) then
529: p_rec.assignment_id :=
530: irc_iad_shd.g_old_rec.assignment_id;
531: End If;
532: If (p_rec.effective_start_date = hr_api.g_date) then
533: p_rec.effective_start_date :=
534: irc_iad_shd.g_old_rec.effective_start_date;

Line 534: irc_iad_shd.g_old_rec.effective_start_date;

530: irc_iad_shd.g_old_rec.assignment_id;
531: End If;
532: If (p_rec.effective_start_date = hr_api.g_date) then
533: p_rec.effective_start_date :=
534: irc_iad_shd.g_old_rec.effective_start_date;
535: End If;
536: If (p_rec.effective_end_date = hr_api.g_date) then
537: p_rec.effective_end_date :=
538: irc_iad_shd.g_old_rec.effective_end_date;

Line 538: irc_iad_shd.g_old_rec.effective_end_date;

534: irc_iad_shd.g_old_rec.effective_start_date;
535: End If;
536: If (p_rec.effective_end_date = hr_api.g_date) then
537: p_rec.effective_end_date :=
538: irc_iad_shd.g_old_rec.effective_end_date;
539: End If;
540: If (p_rec.details_version = hr_api.g_number) then
541: p_rec.details_version :=
542: irc_iad_shd.g_old_rec.details_version;

Line 542: irc_iad_shd.g_old_rec.details_version;

538: irc_iad_shd.g_old_rec.effective_end_date;
539: End If;
540: If (p_rec.details_version = hr_api.g_number) then
541: p_rec.details_version :=
542: irc_iad_shd.g_old_rec.details_version;
543: End If;
544: If (p_rec.latest_details = hr_api.g_varchar2) then
545: p_rec.latest_details :=
546: irc_iad_shd.g_old_rec.latest_details;

Line 546: irc_iad_shd.g_old_rec.latest_details;

542: irc_iad_shd.g_old_rec.details_version;
543: End If;
544: If (p_rec.latest_details = hr_api.g_varchar2) then
545: p_rec.latest_details :=
546: irc_iad_shd.g_old_rec.latest_details;
547: End If;
548: If (p_rec.attempt_id = hr_api.g_number) then
549: p_rec.attempt_id :=
550: irc_iad_shd.g_old_rec.attempt_id;

Line 550: irc_iad_shd.g_old_rec.attempt_id;

546: irc_iad_shd.g_old_rec.latest_details;
547: End If;
548: If (p_rec.attempt_id = hr_api.g_number) then
549: p_rec.attempt_id :=
550: irc_iad_shd.g_old_rec.attempt_id;
551: End If;
552: --
553: End convert_defs;
554: --

Line 561: ,p_rec in out nocopy irc_iad_shd.g_rec_type

557: -- ----------------------------------------------------------------------------
558: Procedure upd
559: (p_effective_date in date
560: ,p_datetrack_mode in varchar2
561: ,p_rec in out nocopy irc_iad_shd.g_rec_type
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
565: l_validation_start_date date;

Line 577: irc_iad_shd.lck

573: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
574: --
575: -- We must lock the row which we need to update.
576: --
577: irc_iad_shd.lck
578: (p_effective_date => p_effective_date
579: ,p_datetrack_mode => p_datetrack_mode
580: ,p_assignment_details_id => p_rec.assignment_details_id
581: ,p_object_version_number => p_rec.object_version_number

Line 650: l_rec irc_iad_shd.g_rec_type;

646: ,p_details_version out nocopy number
647: ,p_latest_details out nocopy varchar2
648: ) is
649: --
650: l_rec irc_iad_shd.g_rec_type;
651: l_proc varchar2(72) := g_package||'upd';
652: --
653: Begin
654: hr_utility.set_location('Entering:'||l_proc, 5);

Line 660: irc_iad_shd.convert_args

656: -- Call conversion function to turn arguments into the
657: -- l_rec structure.
658: --
659: l_rec :=
660: irc_iad_shd.convert_args
661: (p_assignment_details_id
662: ,p_assignment_id
663: ,null
664: ,null