APPS.OTA_TSR_BUS dependencies on HR_API

Line 72: hr_api.mandatory_arg_error

68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Ensure that all the mandatory parameter are not null
71: --
72: hr_api.mandatory_arg_error
73: (p_api_name => l_proc
74: ,p_argument => 'supplied_resource_id'
75: ,p_argument_value => p_supplied_resource_id
76: );

Line 99: hr_api.set_security_group_id

95: close csr_sec_grp;
96: --
97: -- Set the security_group_id in CLIENT_INFO
98: --
99: hr_api.set_security_group_id
100: (p_security_group_id => l_security_group_id
101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA

Line 105: hr_api.set_legislation_context(l_legislation_code);

101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA
104: --
105: hr_api.set_legislation_context(l_legislation_code);
106: end if;
107: --
108: hr_utility.set_location(' Leaving:'|| l_proc, 20);
109: --

Line 258: hr_api.mandatory_arg_error(g_package,'business_group',p_biz);

254: l_dummy integer;
255: --
256: procedure chkp is
257: begin
258: hr_api.mandatory_arg_error(g_package,'business_group',p_biz);
259: end chkp;
260: -----------------
261: begin
262: --

Line 403: nvl(end_date, hr_api.g_eot) > nvl(p_end_date, hr_api.g_eot));

399: select 'X'
400: from ota_resource_usages
401: where supplied_resource_id = p_supplied_resource_id
402: and (start_date < p_start_date or
403: nvl(end_date, hr_api.g_eot) > nvl(p_end_date, hr_api.g_eot));
404: --
405: l_proc varchar2(72) := g_package||'check_usage_dates';
406: l_dummy varchar2(1);
407: --

Line 440: nvl(required_date_to,hr_api.g_eot) > nvl(p_end_date,hr_api.g_eot));

436: from ota_resource_bookings
437: where supplied_resource_id = p_supplied_resource_id
438: and (required_date_from < p_start_date
439: or
440: nvl(required_date_to,hr_api.g_eot) > nvl(p_end_date,hr_api.g_eot));
441: --
442: l_proc varchar2(72) := g_package||'check_booking_dates';
443: l_dummy varchar2(1);
444: --

Line 644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>

640:
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: if (((p_supplied_resource_id is not null) and
644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>
645: nvl(p_training_center_id,hr_api.g_number))
646: or (p_supplied_resource_id is null)) then
647: --
648: hr_utility.set_location('Entering:'||l_proc, 10);

Line 645: nvl(p_training_center_id,hr_api.g_number))

641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: if (((p_supplied_resource_id is not null) and
644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>
645: nvl(p_training_center_id,hr_api.g_number))
646: or (p_supplied_resource_id is null)) then
647: --
648: hr_utility.set_location('Entering:'||l_proc, 10);
649: if (p_training_center_id is not null) then

Line 694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>

690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
692:
693: if (((p_supplied_resource_id is not null) and
694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>
695: nvl(p_location_id,hr_api.g_number))
696: or (p_supplied_resource_id is null)) then
697: --
698: hr_utility.set_location('Entering:'||l_proc, 10);

Line 695: nvl(p_location_id,hr_api.g_number))

691: hr_utility.set_location('Entering:'||l_proc, 5);
692:
693: if (((p_supplied_resource_id is not null) and
694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>
695: nvl(p_location_id,hr_api.g_number))
696: or (p_supplied_resource_id is null)) then
697: --
698: hr_utility.set_location('Entering:'||l_proc, 10);
699: if (p_location_id is not null) then

Line 787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>

783: Begin
784: hr_utility.set_location('Entering:'||l_proc, 5);
785:
786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR

Line 788: nvl(p_trainer_id,hr_api.g_number))

784: hr_utility.set_location('Entering:'||l_proc, 5);
785:
786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>

Line 790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>

786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then

Line 791: nvl(p_start_date, hr_api.g_date) OR

787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then
795: --

Line 792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>

788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then
795: --
796: hr_utility.set_location('Entering:'||l_proc, 10);

Line 793: nvl(p_end_date, hr_api.g_date)

789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then
795: --
796: hr_utility.set_location('Entering:'||l_proc, 10);
797: if (p_trainer_id is not null) then

Line 865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>

861: BEGIN
862: hr_utility.set_location('Entering:'||l_proc,10);
863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>

Line 866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR

862: hr_utility.set_location('Entering:'||l_proc,10);
863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR

Line 867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>

863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>

Line 868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR

864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR

Line 869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>

865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>

Line 870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR

866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR

Line 871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>

867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>

Line 872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR

868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR

Line 873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>

869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>

Line 874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR

870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR

Line 875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>

871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>

Line 876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR

872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR

Line 877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>

873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>

Line 878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR

874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR

Line 879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>

875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>

Line 880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR

876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR

Line 881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>

877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>

Line 882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR

878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR

Line 883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>

879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>

Line 884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR

880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR

Line 885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>

881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>

Line 886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR

882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR

Line 887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>

883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>

Line 888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR

884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR

Line 889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>

885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>

Line 890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR

886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR

Line 891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>

887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>

Line 892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR

888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR

Line 893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>

889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>

Line 894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR

890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR

Line 895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>

891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>

Line 896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR

892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR

Line 897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>

893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>

Line 898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR

894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR

Line 899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>

895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>

Line 900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR

896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR

Line 901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>

897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>

Line 902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR

898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )

Line 903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>

899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN

Line 904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR

900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN
908: --

Line 905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>

901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN
908: --
909: -- Only execute the validation if absolutely necessary:

Line 906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )

902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN
908: --
909: -- Only execute the validation if absolutely necessary:
910: -- a) During update, the structure column value or any

Line 1097: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1093: --
1094: -- Call all supporting business operations
1095: insert_validate2(p_rec);
1096: --
1097: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1098: --
1099: ota_tsr_bus.chk_df(p_rec);
1100: hr_utility.set_location(' Leaving:'||l_proc, 10);
1101: End insert_validate;

Line 1116: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1112: --
1113: -- Call all supporting business operations
1114: update_validate2(p_rec);
1115: --
1116: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1117: --
1118: hr_utility.set_location(' Leaving:'||l_proc, 10);
1119: End update_validate;
1120: --

Line 1191: hr_api.mandatory_arg_error (p_api_name => l_proc,

1187: hr_utility.set_location('Entering:'||l_proc, 5);
1188: --
1189: -- Ensure that all the mandatory parameters are not null
1190: --
1191: hr_api.mandatory_arg_error (p_api_name => l_proc,
1192: p_argument => 'supplied_resource_id',
1193: p_argument_value => p_supplied_resource_id);
1194: open csr_leg_code;
1195: fetch csr_leg_code into l_legislation_code;