APPS.OTA_TAV_BUS dependencies on OTA_TAV_SHD

Line 39: (p_rec in ota_tav_shd.g_rec_type

35: -- Internal Row Handler Use Only.
36: --
37: -- ----------------------------------------------------------------------------
38: procedure chk_ddf
39: (p_rec in ota_tav_shd.g_rec_type
40: ) is
41: --
42: l_proc varchar2(72) := g_package || 'chk_ddf';
43: --

Line 48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>

44: begin
45: hr_utility.set_location('Entering:'||l_proc,10);
46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>

Line 50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>

46: --
47: if ((p_rec.activity_version_id is not null) and (
48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>

Line 52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>

48: nvl(ota_tav_shd.g_old_rec.tav_information_category, hr_api.g_varchar2) <>
49: nvl(p_rec.tav_information_category, hr_api.g_varchar2) or
50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>

Line 54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>

50: nvl(ota_tav_shd.g_old_rec.tav_information1, hr_api.g_varchar2) <>
51: nvl(p_rec.tav_information1, hr_api.g_varchar2) or
52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>

Line 56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>

52: nvl(ota_tav_shd.g_old_rec.tav_information2, hr_api.g_varchar2) <>
53: nvl(p_rec.tav_information2, hr_api.g_varchar2) or
54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>

Line 58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>

54: nvl(ota_tav_shd.g_old_rec.tav_information3, hr_api.g_varchar2) <>
55: nvl(p_rec.tav_information3, hr_api.g_varchar2) or
56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>

Line 60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>

56: nvl(ota_tav_shd.g_old_rec.tav_information4, hr_api.g_varchar2) <>
57: nvl(p_rec.tav_information4, hr_api.g_varchar2) or
58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>

Line 62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>

58: nvl(ota_tav_shd.g_old_rec.tav_information5, hr_api.g_varchar2) <>
59: nvl(p_rec.tav_information5, hr_api.g_varchar2) or
60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>

Line 64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>

60: nvl(ota_tav_shd.g_old_rec.tav_information6, hr_api.g_varchar2) <>
61: nvl(p_rec.tav_information6, hr_api.g_varchar2) or
62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>

Line 66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>

62: nvl(ota_tav_shd.g_old_rec.tav_information7, hr_api.g_varchar2) <>
63: nvl(p_rec.tav_information7, hr_api.g_varchar2) or
64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>

Line 68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>

64: nvl(ota_tav_shd.g_old_rec.tav_information8, hr_api.g_varchar2) <>
65: nvl(p_rec.tav_information8, hr_api.g_varchar2) or
66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>

Line 70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>

66: nvl(ota_tav_shd.g_old_rec.tav_information9, hr_api.g_varchar2) <>
67: nvl(p_rec.tav_information9, hr_api.g_varchar2) or
68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>

Line 72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>

68: nvl(ota_tav_shd.g_old_rec.tav_information10, hr_api.g_varchar2) <>
69: nvl(p_rec.tav_information10, hr_api.g_varchar2) or
70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>

Line 74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>

70: nvl(ota_tav_shd.g_old_rec.tav_information11, hr_api.g_varchar2) <>
71: nvl(p_rec.tav_information11, hr_api.g_varchar2) or
72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>

Line 76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>

72: nvl(ota_tav_shd.g_old_rec.tav_information12, hr_api.g_varchar2) <>
73: nvl(p_rec.tav_information12, hr_api.g_varchar2) or
74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>

Line 78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>

74: nvl(ota_tav_shd.g_old_rec.tav_information13, hr_api.g_varchar2) <>
75: nvl(p_rec.tav_information13, hr_api.g_varchar2) or
76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>

Line 80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>

76: nvl(ota_tav_shd.g_old_rec.tav_information14, hr_api.g_varchar2) <>
77: nvl(p_rec.tav_information14, hr_api.g_varchar2) or
78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>

Line 82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>

78: nvl(ota_tav_shd.g_old_rec.tav_information15, hr_api.g_varchar2) <>
79: nvl(p_rec.tav_information15, hr_api.g_varchar2) or
80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>

Line 84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>

80: nvl(ota_tav_shd.g_old_rec.tav_information16, hr_api.g_varchar2) <>
81: nvl(p_rec.tav_information16, hr_api.g_varchar2) or
82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>

Line 86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>

82: nvl(ota_tav_shd.g_old_rec.tav_information17, hr_api.g_varchar2) <>
83: nvl(p_rec.tav_information17, hr_api.g_varchar2) or
84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then

Line 88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>

84: nvl(ota_tav_shd.g_old_rec.tav_information18, hr_api.g_varchar2) <>
85: nvl(p_rec.tav_information18, hr_api.g_varchar2) or
86: nvl(ota_tav_shd.g_old_rec.tav_information19, hr_api.g_varchar2) <>
87: nvl(p_rec.tav_information19, hr_api.g_varchar2) or
88: nvl(ota_tav_shd.g_old_rec.tav_information20, hr_api.g_varchar2) <>
89: nvl(p_rec.tav_information20, hr_api.g_varchar2) ))
90: or (p_rec.activity_version_id is null) then
91: --
92: -- Only execute the validation if absolutely necessary:

Line 239: l_api_updating := ota_tav_shd.api_updating

235: (p_api_name => l_proc
236: ,p_argument => 'effective_date'
237: ,p_argument_value => p_effective_date);
238:
239: l_api_updating := ota_tav_shd.api_updating
240: (p_activity_version_id => p_activity_version_id
241: ,p_object_version_number => p_object_version_number);
242:
243:

Line 245: NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>

241: ,p_object_version_number => p_object_version_number);
242:
243:
244: IF ((l_api_updating AND
245: NVL(ota_tav_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
246: NVL(p_competency_update_level, hr_api.g_varchar2))
247: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
248:
249: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 1280: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date

1276:
1277: l_proc varchar2(72) := g_package||'check_course_lp_dates';
1278: --
1279: l_start_date_changed boolean
1280: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1281: , p_start_date );
1282: --
1283: l_end_date_changed boolean
1284: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

Line 1284: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

1280: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1281: , p_start_date );
1282: --
1283: l_end_date_changed boolean
1284: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1285: , p_end_date );
1286:
1287: Begin
1288:

Line 1332: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date

1328:
1329: l_proc varchar2(72) := g_package||'check_course_crt_dates';
1330: --
1331: l_start_date_changed boolean
1332: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1333: , p_start_date );
1334: --
1335: l_end_date_changed boolean
1336: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

Line 1336: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

1332: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1333: , p_start_date );
1334: --
1335: l_end_date_changed boolean
1336: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1337: , p_end_date );
1338:
1339: Begin
1340:

Line 1425: Procedure insert_validate(p_rec in ota_tav_shd.g_rec_type) is

1421:
1422: -- ----------------------------------------------------------------------------
1423: -- |---------------------------< insert_validate >----------------------------|
1424: -- ----------------------------------------------------------------------------
1425: Procedure insert_validate(p_rec in ota_tav_shd.g_rec_type) is
1426: --
1427: l_proc varchar2(72) := g_package||'insert_validate';
1428: --
1429: Begin

Line 1437: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||

1433: --
1434: if p_rec.business_group_id is not null then
1435: hr_api.validate_bus_grp_id
1436: (p_business_group_id => p_rec.business_group_id
1437: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||
1438: '.BUSINESS_GROUP_ID'
1439: );
1440: end if;
1441: --

Line 1534: Procedure update_validate(p_rec in ota_tav_shd.g_rec_type) is

1530: -- ----------------------------------------------------------------------------
1531: -- |---------------------------< update_validate >----------------------------|
1532: -- ----------------------------------------------------------------------------
1533: --
1534: Procedure update_validate(p_rec in ota_tav_shd.g_rec_type) is
1535: --
1536: l_proc varchar2(72) := g_package||'update_validate';
1537: --
1538: l_api_updating boolean

Line 1539: := ota_tav_shd.api_updating(p_rec.activity_version_id

1535: --
1536: l_proc varchar2(72) := g_package||'update_validate';
1537: --
1538: l_api_updating boolean
1539: := ota_tav_shd.api_updating(p_rec.activity_version_id
1540: ,p_rec.object_version_number);
1541: --
1542: l_minimum_attendees_changed boolean
1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees

Line 1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees

1539: := ota_tav_shd.api_updating(p_rec.activity_version_id
1540: ,p_rec.object_version_number);
1541: --
1542: l_minimum_attendees_changed boolean
1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees
1544: , p_rec.minimum_attendees );
1545: --
1546: l_maximum_attendees_changed boolean
1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees

Line 1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees

1543: := ota_general.value_changed( ota_tav_shd.g_old_rec.minimum_attendees
1544: , p_rec.minimum_attendees );
1545: --
1546: l_maximum_attendees_changed boolean
1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees
1548: , p_rec.maximum_attendees );
1549: --
1550: l_activity_version_id_changed boolean
1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id

Line 1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id

1547: := ota_general.value_changed( ota_tav_shd.g_old_rec.maximum_attendees
1548: , p_rec.maximum_attendees );
1549: --
1550: l_activity_version_id_changed boolean
1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id
1552: , p_rec.activity_version_id );
1553: --
1554: l_activity_id_changed boolean
1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id

Line 1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id

1551: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_version_id
1552: , p_rec.activity_version_id );
1553: --
1554: l_activity_id_changed boolean
1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id
1556: , p_rec.activity_id );
1557: --
1558: l_version_name_changed boolean
1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name

Line 1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name

1555: := ota_general.value_changed( ota_tav_shd.g_old_rec.activity_id
1556: , p_rec.activity_id );
1557: --
1558: l_version_name_changed boolean
1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name
1560: , p_rec.version_name );
1561: --
1562: l_super_by_act_vers_id_changed boolean
1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id

Line 1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id

1559: := ota_general.value_changed( ota_tav_shd.g_old_rec.version_name
1560: , p_rec.version_name );
1561: --
1562: l_super_by_act_vers_id_changed boolean
1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id
1564: , p_rec.superseded_by_act_version_id );
1565: --
1566: l_start_date_changed boolean
1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date

Line 1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date

1563: := ota_general.value_changed( ota_tav_shd.g_old_rec.superseded_by_act_version_id
1564: , p_rec.superseded_by_act_version_id );
1565: --
1566: l_start_date_changed boolean
1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1568: , p_rec.start_date );
1569: --
1570: l_end_date_changed boolean
1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

Line 1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date

1567: := ota_general.value_changed( ota_tav_shd.g_old_rec.start_date
1568: , p_rec.start_date );
1569: --
1570: l_end_date_changed boolean
1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1572: , p_rec.end_date );
1573: --
1574: l_user_status_changed boolean
1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status

Line 1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status

1571: := ota_general.value_changed( ota_tav_shd.g_old_rec.end_date
1572: , p_rec.end_date );
1573: --
1574: l_user_status_changed boolean
1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status
1576: , p_rec.user_status );
1577: --
1578: l_success_criteria_changed boolean
1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria

Line 1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria

1575: := ota_general.value_changed( ota_tav_shd.g_old_rec.user_status
1576: , p_rec.user_status );
1577: --
1578: l_success_criteria_changed boolean
1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria
1580: , p_rec.success_criteria );
1581: --
1582: l_duration_units_changed boolean
1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units

Line 1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units

1579: := ota_general.value_changed( ota_tav_shd.g_old_rec.success_criteria
1580: , p_rec.success_criteria );
1581: --
1582: l_duration_units_changed boolean
1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units
1584: , p_rec.duration_units );
1585: --
1586: l_duration_changed boolean
1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration

Line 1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration

1583: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration_units
1584: , p_rec.duration_units );
1585: --
1586: l_duration_changed boolean
1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration
1588: , p_rec.duration );
1589: --
1590: l_language_id_changed boolean
1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id

Line 1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id

1587: := ota_general.value_changed( ota_tav_shd.g_old_rec.duration
1588: , p_rec.duration );
1589: --
1590: l_language_id_changed boolean
1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id
1592: , p_rec.language_id );
1593: --
1594: l_person_id_changed boolean
1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id

Line 1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id

1591: := ota_general.value_changed( ota_tav_shd.g_old_rec.language_id
1592: , p_rec.language_id );
1593: --
1594: l_person_id_changed boolean
1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id
1596: , p_rec.controlling_person_id );
1597: --
1598: l_vendor_id_changed boolean
1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id

Line 1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id

1595: := ota_general.value_changed( ota_tav_shd.g_old_rec.controlling_person_id
1596: , p_rec.controlling_person_id );
1597: --
1598: l_vendor_id_changed boolean
1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id
1600: , p_rec.vendor_id);
1601: --
1602: l_professional_ctype_changed boolean
1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type

Line 1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type

1599: := ota_general.value_changed( ota_tav_shd.g_old_rec.vendor_id
1600: , p_rec.vendor_id);
1601: --
1602: l_professional_ctype_changed boolean
1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type
1604: , p_rec.professional_credit_type);
1605: --
1606: l_professional_credits_changed boolean
1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits

Line 1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits

1603: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credit_type
1604: , p_rec.professional_credit_type);
1605: --
1606: l_professional_credits_changed boolean
1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits
1608: , p_rec.professional_credits);
1609: --
1610: l_budget_currency_code_changed boolean
1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code

Line 1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code

1607: := ota_general.value_changed( ota_tav_shd.g_old_rec.professional_credits
1608: , p_rec.professional_credits);
1609: --
1610: l_budget_currency_code_changed boolean
1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code
1612: , p_rec.budget_currency_code);
1613: --
1614: l_budget_cost_changed boolean
1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost

Line 1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost

1611: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_currency_code
1612: , p_rec.budget_currency_code);
1613: --
1614: l_budget_cost_changed boolean
1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost
1616: , p_rec.budget_cost);
1617: --
1618: l_actual_cost_changed boolean
1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost

Line 1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost

1615: := ota_general.value_changed( ota_tav_shd.g_old_rec.budget_cost
1616: , p_rec.budget_cost);
1617: --
1618: l_actual_cost_changed boolean
1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost
1620: , p_rec.actual_cost);
1621: --
1622: l_inventory_item_id_changed boolean
1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id

Line 1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id

1619: := ota_general.value_changed( ota_tav_shd.g_old_rec.actual_cost
1620: , p_rec.actual_cost);
1621: --
1622: l_inventory_item_id_changed boolean
1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id
1624: , p_rec.inventory_item_id);
1625:
1626: l_rco_id_changed boolean
1627: := ota_general.value_changed (ota_tav_shd.g_old_rec.rco_id

Line 1627: := ota_general.value_changed (ota_tav_shd.g_old_rec.rco_id

1623: := ota_general.value_changed (ota_tav_shd.g_old_rec.inventory_item_id
1624: , p_rec.inventory_item_id);
1625:
1626: l_rco_id_changed boolean
1627: := ota_general.value_changed (ota_tav_shd.g_old_rec.rco_id
1628: , p_rec.rco_id);
1629:
1630: --
1631: Begin

Line 1639: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||

1635: --
1636: if p_rec.business_group_id is not null then
1637: hr_api.validate_bus_grp_id
1638: (p_business_group_id => p_rec.business_group_id
1639: ,p_associated_column1 => ota_tav_shd.g_tab_nam ||
1640: '.BUSINESS_GROUP_ID'
1641: );
1642: end if;
1643: --

Line 1718: , ota_tav_shd.g_old_rec.start_date

1714: /*
1715: ota_tav_api_business_rules.check_dates_update_rud( p_rec.activity_version_id
1716: , p_rec.start_date
1717: , p_rec.end_date
1718: , ota_tav_shd.g_old_rec.start_date
1719: , ota_tav_shd.g_old_rec.end_date
1720: );
1721: */
1722: check_dates_update_tbd( p_rec.activity_version_id

Line 1719: , ota_tav_shd.g_old_rec.end_date

1715: ota_tav_api_business_rules.check_dates_update_rud( p_rec.activity_version_id
1716: , p_rec.start_date
1717: , p_rec.end_date
1718: , ota_tav_shd.g_old_rec.start_date
1719: , ota_tav_shd.g_old_rec.end_date
1720: );
1721: */
1722: check_dates_update_tbd( p_rec.activity_version_id
1723: , p_rec.start_date

Line 1850: Procedure delete_validate(p_rec in ota_tav_shd.g_rec_type) is

1846: --
1847: -- ----------------------------------------------------------------------------
1848: -- |---------------------------< delete_validate >----------------------------|
1849: -- ----------------------------------------------------------------------------
1850: Procedure delete_validate(p_rec in ota_tav_shd.g_rec_type) is
1851: --
1852: l_proc varchar2(72) := g_package||'delete_validate';
1853: --
1854: Begin