APPS.OTA_TDB_BUS dependencies on HR_API

Line 89: if nvl(p_rec.business_group_id,hr_api.g_number) <>

85: fnd_message.set_token('STEP ', '5');
86: fnd_message.raise_error;
87: END IF;
88:
89: if nvl(p_rec.business_group_id,hr_api.g_number) <>
90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)
91: then
92: l_argument := 'business_group_id';
93: raise l_error;

Line 90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)

86: fnd_message.raise_error;
87: END IF;
88:
89: if nvl(p_rec.business_group_id,hr_api.g_number) <>
90: nvl(ota_tdb_shd.g_old_rec.business_group_id,hr_api.g_number)
91: then
92: l_argument := 'business_group_id';
93: raise l_error;
94: end if;

Line 95: /* if nvl(p_rec.line_id,hr_api.g_number) <>

91: then
92: l_argument := 'business_group_id';
93: raise l_error;
94: end if;
95: /* if nvl(p_rec.line_id,hr_api.g_number) <>
96: nvl(ota_tdb_shd.g_old_rec.Line_id,hr_api.g_number)
97: then
98: l_argument := 'Line_id';
99: raise l_error;

Line 96: nvl(ota_tdb_shd.g_old_rec.Line_id,hr_api.g_number)

92: l_argument := 'business_group_id';
93: raise l_error;
94: end if;
95: /* if nvl(p_rec.line_id,hr_api.g_number) <>
96: nvl(ota_tdb_shd.g_old_rec.Line_id,hr_api.g_number)
97: then
98: l_argument := 'Line_id';
99: raise l_error;
100: end if;*/

Line 105: hr_api.argument_changed_error

101:
102:
103: EXCEPTION
104: WHEN l_error THEN
105: hr_api.argument_changed_error
106: (p_api_name => l_proc
107: ,p_argument => l_argument);
108: WHEN OTHERS THEN
109: RAISE;

Line 169: hr_api.mandatory_arg_error

165: hr_utility.set_location('Entering:'|| l_proc, 10);
166: --
167: -- Ensure that all the mandatory parameter are not null
168: --
169: hr_api.mandatory_arg_error
170: (p_api_name => l_proc
171: ,p_argument => 'booking_id'
172: ,p_argument_value => p_booking_id
173: );

Line 196: hr_api.set_security_group_id

192: close csr_sec_grp;
193: --
194: -- Set the security_group_id in CLIENT_INFO
195: --
196: hr_api.set_security_group_id
197: (p_security_group_id => l_security_group_id
198: );
199: --
200: -- Set the sessions legislation context in HR_SESSION_DATA

Line 202: hr_api.set_legislation_context(l_legislation_code);

198: );
199: --
200: -- Set the sessions legislation context in HR_SESSION_DATA
201: --
202: hr_api.set_legislation_context(l_legislation_code);
203: end if;
204: --
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);
206: END set_security_group_id;

Line 262: hr_api.mandatory_arg_error

258: hr_utility.set_location('Entering:'|| l_proc, 10);
259: --
260: -- Ensure that all the mandatory parameter are not null
261: --
262: hr_api.mandatory_arg_error
263: (p_api_name => l_proc
264: ,p_argument => 'booking_id'
265: ,p_argument_value => p_booking_id
266: );

Line 268: if ( nvl(ota_tdb_bus.g_booking_id, hr_api.g_number)

264: ,p_argument => 'booking_id'
265: ,p_argument_value => p_booking_id
266: );
267: --
268: if ( nvl(ota_tdb_bus.g_booking_id, hr_api.g_number)
269: = p_booking_id) then
270: --
271: -- The legislation code has already been found with a previous
272: -- call to this function. Just return the value in the global

Line 865: if l_booking <> nvl(p_booking_id, hr_api.g_number) then

861: p_delegate_person_id);
862: --
863: if l_booking is not null then
864: --
865: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
866: --
867: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
868: fnd_message.raise_error;
869: --

Line 888: if l_booking <> nvl(p_booking_id, hr_api.g_number) then

884: p_delegate_contact_id);
885: --
886: if l_booking is not null then
887: --
888: if l_booking <> nvl(p_booking_id, hr_api.g_number) then
889: --
890: fnd_message.set_name ('OTA','OTA_13582_DOUBLE_BOOKING');
891: fnd_message.raise_error;
892: --

Line 966: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);

962: where a.event_id = p_event_id
963: and a.booking_status_type_id = b.booking_status_type_id
964: and b.type in ('P','A','E') --6683076.Added new enrollment status.
965: and a.internal_booking_flag = 'Y'
966: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);
967: --
968: Begin
969: --
970: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3125: nvl(ota_tdb_shd.g_old_rec.line_id,hr_api.g_number) <>

3121: Begin
3122: hr_utility.set_location('Entering:'||l_proc, 5);
3123:
3124: if (((p_booking_id is not null) and
3125: nvl(ota_tdb_shd.g_old_rec.line_id,hr_api.g_number) <>
3126: nvl(p_line_id,hr_api.g_number))
3127: or (p_booking_id is null)) then
3128: --
3129: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3126: nvl(p_line_id,hr_api.g_number))

3122: hr_utility.set_location('Entering:'||l_proc, 5);
3123:
3124: if (((p_booking_id is not null) and
3125: nvl(ota_tdb_shd.g_old_rec.line_id,hr_api.g_number) <>
3126: nvl(p_line_id,hr_api.g_number))
3127: or (p_booking_id is null)) then
3128: --
3129: hr_utility.set_location('Entering:'||l_proc, 10);
3130: if p_line_id is not null then

Line 3442: IF p_booking_status_type_id <> hr_api.g_number THEN

3438: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := p_delegate_person_id;
3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN
3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);
3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);
3445:
3446: IF l_bkng_status_type = 'A'

Line 3449: IF p_event_id = hr_api.g_number THEN

3445:
3446: IF l_bkng_status_type = 'A'
3447: OR l_old_bst not in('A','E') THEN RETURN; END IF;--Added for 6989133.
3448:
3449: IF p_event_id = hr_api.g_number THEN
3450: l_event_id := ota_tdb_shd.g_old_rec.event_id;
3451: END IF;
3452:
3453: OPEN csr_get_class_type(l_event_id);

Line 3462: IF l_player_status = hr_api.g_varchar2 THEN

3458: IF nvl(l_online_flag, 'N') = 'Y' THEN
3459: -- Add logic to check performance status and throw error acc.
3460: IF l_imported_off_id IS NOT NULL THEN
3461: -- Imported class. Performance data to be fetched from TDB table
3462: IF l_player_status = hr_api.g_varchar2 THEN
3463: l_player_status := ota_tdb_shd.g_old_rec.content_player_status;
3464: ELSE
3465: l_player_status := p_content_player_status;
3466: END IF;

Line 3469: IF l_contact_id = hr_api.g_number THEN

3465: l_player_status := p_content_player_status;
3466: END IF;
3467: ELSE
3468: -- Performance to be fetched from OTA_PERFORMANCES
3469: IF l_contact_id = hr_api.g_number THEN
3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3471: END IF;
3472: IF l_person_id = hr_api.g_number THEN
3473: l_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;

Line 3472: IF l_person_id = hr_api.g_number THEN

3468: -- Performance to be fetched from OTA_PERFORMANCES
3469: IF l_contact_id = hr_api.g_number THEN
3470: l_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3471: END IF;
3472: IF l_person_id = hr_api.g_number THEN
3473: l_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3474: END IF;
3475:
3476: IF l_person_id IS NOT NULL THEN

Line 3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>

3534: BEGIN
3535: hr_utility.set_location('Entering:'||l_proc,10);
3536: --
3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>

Line 3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR

3535: hr_utility.set_location('Entering:'||l_proc,10);
3536: --
3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR

Line 3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>

3536: --
3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>

Line 3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR

3537: IF ((p_rec.booking_id IS NOT NULL) AND (
3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR

Line 3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>

3538: NVL(ota_tdb_shd.g_old_rec.tdb_information_category, hr_api.g_varchar2) <>
3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>

Line 3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR

3539: NVL(p_rec.tdb_information_category, hr_api.g_varchar2) OR
3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR

Line 3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>

3540: NVL(ota_tdb_shd.g_old_rec.tdb_information1, hr_api.g_varchar2) <>
3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>

Line 3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR

3541: NVL(p_rec.tdb_information1, hr_api.g_varchar2) OR
3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR

Line 3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>

3542: NVL(ota_tdb_shd.g_old_rec.tdb_information2, hr_api.g_varchar2) <>
3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>

Line 3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR

3543: NVL(p_rec.tdb_information2, hr_api.g_varchar2) OR
3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR

Line 3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>

3544: NVL(ota_tdb_shd.g_old_rec.tdb_information3, hr_api.g_varchar2) <>
3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>

Line 3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR

3545: NVL(p_rec.tdb_information3, hr_api.g_varchar2) OR
3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR

Line 3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>

3546: NVL(ota_tdb_shd.g_old_rec.tdb_information4, hr_api.g_varchar2) <>
3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>

Line 3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR

3547: NVL(p_rec.tdb_information4, hr_api.g_varchar2) OR
3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR

Line 3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>

3548: NVL(ota_tdb_shd.g_old_rec.tdb_information5, hr_api.g_varchar2) <>
3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>

Line 3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR

3549: NVL(p_rec.tdb_information5, hr_api.g_varchar2) OR
3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR

Line 3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>

3550: NVL(ota_tdb_shd.g_old_rec.tdb_information6, hr_api.g_varchar2) <>
3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>

Line 3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR

3551: NVL(p_rec.tdb_information6, hr_api.g_varchar2) OR
3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR

Line 3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>

3552: NVL(ota_tdb_shd.g_old_rec.tdb_information7, hr_api.g_varchar2) <>
3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>

Line 3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR

3553: NVL(p_rec.tdb_information7, hr_api.g_varchar2) OR
3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR

Line 3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>

3554: NVL(ota_tdb_shd.g_old_rec.tdb_information8, hr_api.g_varchar2) <>
3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>

Line 3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR

3555: NVL(p_rec.tdb_information8, hr_api.g_varchar2) OR
3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR

Line 3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>

3556: NVL(ota_tdb_shd.g_old_rec.tdb_information9, hr_api.g_varchar2) <>
3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>

Line 3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR

3557: NVL(p_rec.tdb_information9, hr_api.g_varchar2) OR
3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR

Line 3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>

3558: NVL(ota_tdb_shd.g_old_rec.tdb_information10, hr_api.g_varchar2) <>
3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>

Line 3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR

3559: NVL(p_rec.tdb_information10, hr_api.g_varchar2) OR
3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR

Line 3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>

3560: NVL(ota_tdb_shd.g_old_rec.tdb_information11, hr_api.g_varchar2) <>
3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>

Line 3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR

3561: NVL(p_rec.tdb_information11, hr_api.g_varchar2) OR
3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR

Line 3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>

3562: NVL(ota_tdb_shd.g_old_rec.tdb_information12, hr_api.g_varchar2) <>
3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>

Line 3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR

3563: NVL(p_rec.tdb_information12, hr_api.g_varchar2) OR
3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR

Line 3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>

3564: NVL(ota_tdb_shd.g_old_rec.tdb_information13, hr_api.g_varchar2) <>
3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>

Line 3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR

3565: NVL(p_rec.tdb_information13, hr_api.g_varchar2) OR
3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR

Line 3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>

3566: NVL(ota_tdb_shd.g_old_rec.tdb_information14, hr_api.g_varchar2) <>
3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>

Line 3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR

3567: NVL(p_rec.tdb_information14, hr_api.g_varchar2) OR
3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR

Line 3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>

3568: NVL(ota_tdb_shd.g_old_rec.tdb_information15, hr_api.g_varchar2) <>
3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>

Line 3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR

3569: NVL(p_rec.tdb_information15, hr_api.g_varchar2) OR
3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR

Line 3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>

3570: NVL(ota_tdb_shd.g_old_rec.tdb_information16, hr_api.g_varchar2) <>
3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>

Line 3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR

3571: NVL(p_rec.tdb_information16, hr_api.g_varchar2) OR
3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )

Line 3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>

3572: NVL(ota_tdb_shd.g_old_rec.tdb_information17, hr_api.g_varchar2) <>
3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN

Line 3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR

3573: NVL(p_rec.tdb_information17, hr_api.g_varchar2) OR
3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN
3581: --

Line 3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>

3574: NVL(ota_tdb_shd.g_old_rec.tdb_information18, hr_api.g_varchar2) <>
3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN
3581: --
3582: -- Only execute the validation if absolutely necessary:

Line 3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )

3575: NVL(p_rec.tdb_information18, hr_api.g_varchar2) OR
3576: NVL(ota_tdb_shd.g_old_rec.tdb_information19, hr_api.g_varchar2) <>
3577: NVL(p_rec.tdb_information19, hr_api.g_varchar2) OR
3578: NVL(ota_tdb_shd.g_old_rec.tdb_information20, hr_api.g_varchar2) <>
3579: NVL(p_rec.tdb_information20, hr_api.g_varchar2) ) )
3580: OR (p_rec.booking_id IS NULL) THEN
3581: --
3582: -- Only execute the validation if absolutely necessary:
3583: -- a) During update, the structure column value or any

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

3655: hr_utility.set_location('Entering:'||l_proc, 5);
3656: --
3657: -- Call all supporting business operations
3658: --
3659: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
3660: --
3661: --
3662: -- Call all supporting business operations
3663: --

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

4035: );
4036: --
4037: -- Call all supporting business operations
4038: --
4039: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
4040: --
4041: --
4042: -- if the event has been updated then refresh the global event record
4043: -- and set an indicator to allow any subsequent event related checks to use

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

4158: --
4159: --
4160: if l_business_group_id_changed then
4161: --
4162: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
4163: --
4164: end if;
4165: --
4166: --