DBA Data[Home] [Help]

APPS.PER_ABV_UPD dependencies on PER_ABV_SHD

Line 58: (p_rec in out nocopy per_abv_shd.g_rec_type

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

138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: --
142: per_abv_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --

Line 147: per_abv_shd.constraint_error

143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: per_abv_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: --
151: Raise;

Line 186: (p_rec in out nocopy per_abv_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure update_dml
186: (p_rec in out nocopy per_abv_shd.g_rec_type
187: ,p_effective_date in date
188: ,p_datetrack_mode in varchar2
189: ,p_validation_start_date in date
190: ,p_validation_end_date in date

Line 253: (p_rec in out nocopy per_abv_shd.g_rec_type

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy per_abv_shd.g_rec_type
254: ,p_effective_date in date
255: ,p_datetrack_mode in varchar2
256: ,p_validation_start_date in date
257: ,p_validation_end_date in date

Line 269: per_abv_shd.upd_effective_end_date

265: If (p_datetrack_mode <> hr_api.g_correction) then
266: --
267: -- Update the current effective end date
268: --
269: per_abv_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date
271: ,p_base_key_value => p_rec.assignment_budget_value_id
272: ,p_new_effective_end_date => (p_validation_start_date - 1)
273: ,p_validation_start_date => p_validation_start_date

Line 339: (p_rec in out nocopy per_abv_shd.g_rec_type

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

Line 397: (p_rec in per_abv_shd.g_rec_type

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

Line 438: => per_abv_shd.g_old_rec.effective_start_date

434: => p_rec.program_id
435: ,p_program_update_date
436: => p_rec.program_update_date
437: ,p_effective_start_date_o
438: => per_abv_shd.g_old_rec.effective_start_date
439: ,p_effective_end_date_o
440: => per_abv_shd.g_old_rec.effective_end_date
441: ,p_object_version_number
442: => p_rec.object_version_number

Line 440: => per_abv_shd.g_old_rec.effective_end_date

436: => p_rec.program_update_date
437: ,p_effective_start_date_o
438: => per_abv_shd.g_old_rec.effective_start_date
439: ,p_effective_end_date_o
440: => per_abv_shd.g_old_rec.effective_end_date
441: ,p_object_version_number
442: => p_rec.object_version_number
443: ,p_business_group_id_o
444: => per_abv_shd.g_old_rec.business_group_id

Line 444: => per_abv_shd.g_old_rec.business_group_id

440: => per_abv_shd.g_old_rec.effective_end_date
441: ,p_object_version_number
442: => p_rec.object_version_number
443: ,p_business_group_id_o
444: => per_abv_shd.g_old_rec.business_group_id
445: ,p_assignment_id_o
446: => per_abv_shd.g_old_rec.assignment_id
447: ,p_unit_o
448: => per_abv_shd.g_old_rec.unit

Line 446: => per_abv_shd.g_old_rec.assignment_id

442: => p_rec.object_version_number
443: ,p_business_group_id_o
444: => per_abv_shd.g_old_rec.business_group_id
445: ,p_assignment_id_o
446: => per_abv_shd.g_old_rec.assignment_id
447: ,p_unit_o
448: => per_abv_shd.g_old_rec.unit
449: ,p_value_o
450: => per_abv_shd.g_old_rec.value

Line 448: => per_abv_shd.g_old_rec.unit

444: => per_abv_shd.g_old_rec.business_group_id
445: ,p_assignment_id_o
446: => per_abv_shd.g_old_rec.assignment_id
447: ,p_unit_o
448: => per_abv_shd.g_old_rec.unit
449: ,p_value_o
450: => per_abv_shd.g_old_rec.value
451: ,p_request_id_o
452: => per_abv_shd.g_old_rec.request_id

Line 450: => per_abv_shd.g_old_rec.value

446: => per_abv_shd.g_old_rec.assignment_id
447: ,p_unit_o
448: => per_abv_shd.g_old_rec.unit
449: ,p_value_o
450: => per_abv_shd.g_old_rec.value
451: ,p_request_id_o
452: => per_abv_shd.g_old_rec.request_id
453: ,p_program_application_id_o
454: => per_abv_shd.g_old_rec.program_application_id

Line 452: => per_abv_shd.g_old_rec.request_id

448: => per_abv_shd.g_old_rec.unit
449: ,p_value_o
450: => per_abv_shd.g_old_rec.value
451: ,p_request_id_o
452: => per_abv_shd.g_old_rec.request_id
453: ,p_program_application_id_o
454: => per_abv_shd.g_old_rec.program_application_id
455: ,p_program_id_o
456: => per_abv_shd.g_old_rec.program_id

Line 454: => per_abv_shd.g_old_rec.program_application_id

450: => per_abv_shd.g_old_rec.value
451: ,p_request_id_o
452: => per_abv_shd.g_old_rec.request_id
453: ,p_program_application_id_o
454: => per_abv_shd.g_old_rec.program_application_id
455: ,p_program_id_o
456: => per_abv_shd.g_old_rec.program_id
457: ,p_program_update_date_o
458: => per_abv_shd.g_old_rec.program_update_date

Line 456: => per_abv_shd.g_old_rec.program_id

452: => per_abv_shd.g_old_rec.request_id
453: ,p_program_application_id_o
454: => per_abv_shd.g_old_rec.program_application_id
455: ,p_program_id_o
456: => per_abv_shd.g_old_rec.program_id
457: ,p_program_update_date_o
458: => per_abv_shd.g_old_rec.program_update_date
459: ,p_object_version_number_o
460: => per_abv_shd.g_old_rec.object_version_number

Line 458: => per_abv_shd.g_old_rec.program_update_date

454: => per_abv_shd.g_old_rec.program_application_id
455: ,p_program_id_o
456: => per_abv_shd.g_old_rec.program_id
457: ,p_program_update_date_o
458: => per_abv_shd.g_old_rec.program_update_date
459: ,p_object_version_number_o
460: => per_abv_shd.g_old_rec.object_version_number
461: );
462: --

Line 460: => per_abv_shd.g_old_rec.object_version_number

456: => per_abv_shd.g_old_rec.program_id
457: ,p_program_update_date_o
458: => per_abv_shd.g_old_rec.program_update_date
459: ,p_object_version_number_o
460: => per_abv_shd.g_old_rec.object_version_number
461: );
462: --
463: exception
464: --

Line 520: (p_rec in out nocopy per_abv_shd.g_rec_type

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

Line 532: per_abv_shd.g_old_rec.business_group_id;

528: -- is being used then we must set to the 'current' argument value.
529: --
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_abv_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.assignment_id = hr_api.g_number) then
535: p_rec.assignment_id :=
536: per_abv_shd.g_old_rec.assignment_id;

Line 536: per_abv_shd.g_old_rec.assignment_id;

532: per_abv_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.assignment_id = hr_api.g_number) then
535: p_rec.assignment_id :=
536: per_abv_shd.g_old_rec.assignment_id;
537: End If;
538: If (p_rec.unit = hr_api.g_varchar2) then
539: p_rec.unit :=
540: per_abv_shd.g_old_rec.unit;

Line 540: per_abv_shd.g_old_rec.unit;

536: per_abv_shd.g_old_rec.assignment_id;
537: End If;
538: If (p_rec.unit = hr_api.g_varchar2) then
539: p_rec.unit :=
540: per_abv_shd.g_old_rec.unit;
541: End If;
542: If (p_rec.value = hr_api.g_number) then
543: p_rec.value :=
544: per_abv_shd.g_old_rec.value;

Line 544: per_abv_shd.g_old_rec.value;

540: per_abv_shd.g_old_rec.unit;
541: End If;
542: If (p_rec.value = hr_api.g_number) then
543: p_rec.value :=
544: per_abv_shd.g_old_rec.value;
545: End If;
546: If (p_rec.request_id = hr_api.g_number) then
547: p_rec.request_id :=
548: per_abv_shd.g_old_rec.request_id;

Line 548: per_abv_shd.g_old_rec.request_id;

544: per_abv_shd.g_old_rec.value;
545: End If;
546: If (p_rec.request_id = hr_api.g_number) then
547: p_rec.request_id :=
548: per_abv_shd.g_old_rec.request_id;
549: End If;
550: If (p_rec.program_application_id = hr_api.g_number) then
551: p_rec.program_application_id :=
552: per_abv_shd.g_old_rec.program_application_id;

Line 552: per_abv_shd.g_old_rec.program_application_id;

548: per_abv_shd.g_old_rec.request_id;
549: End If;
550: If (p_rec.program_application_id = hr_api.g_number) then
551: p_rec.program_application_id :=
552: per_abv_shd.g_old_rec.program_application_id;
553: End If;
554: If (p_rec.program_id = hr_api.g_number) then
555: p_rec.program_id :=
556: per_abv_shd.g_old_rec.program_id;

Line 556: per_abv_shd.g_old_rec.program_id;

552: per_abv_shd.g_old_rec.program_application_id;
553: End If;
554: If (p_rec.program_id = hr_api.g_number) then
555: p_rec.program_id :=
556: per_abv_shd.g_old_rec.program_id;
557: End If;
558: If (p_rec.program_update_date = hr_api.g_date) then
559: p_rec.program_update_date :=
560: per_abv_shd.g_old_rec.program_update_date;

Line 560: per_abv_shd.g_old_rec.program_update_date;

556: per_abv_shd.g_old_rec.program_id;
557: End If;
558: If (p_rec.program_update_date = hr_api.g_date) then
559: p_rec.program_update_date :=
560: per_abv_shd.g_old_rec.program_update_date;
561: End If;
562: --
563: End convert_defs;
564: --

Line 571: ,p_rec in out nocopy per_abv_shd.g_rec_type

567: -- ----------------------------------------------------------------------------
568: Procedure upd
569: (p_effective_date in date
570: ,p_datetrack_mode in varchar2
571: ,p_rec in out nocopy per_abv_shd.g_rec_type
572: ) is
573: --
574: l_proc varchar2(72) := g_package||'upd';
575: l_validation_start_date date;

Line 587: per_abv_shd.lck

583: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
584: --
585: -- We must lock the row which we need to update.
586: --
587: per_abv_shd.lck
588: (p_effective_date => p_effective_date
589: ,p_datetrack_mode => p_datetrack_mode
590: ,p_assignment_budget_value_id => p_rec.assignment_budget_value_id
591: ,p_validation_start_date => l_validation_start_date

Line 661: l_rec per_abv_shd.g_rec_type;

657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is
660: --
661: l_rec per_abv_shd.g_rec_type;
662: l_proc varchar2(72) := g_package||'upd';
663: l_assignment_id number := hr_api.g_number;
664: l_business_group_id number := hr_api.g_number;
665: --

Line 673: per_abv_shd.convert_args

669: -- Call conversion function to turn arguments into the
670: -- l_rec structure.
671: --
672: l_rec :=
673: per_abv_shd.convert_args
674: (p_assignment_budget_value_id => p_assignment_budget_value_id
675: ,p_business_group_id => l_business_group_id
676: ,p_unit => p_unit
677: ,p_assignment_id => l_assignment_id