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: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
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:
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);
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
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:
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
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:
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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