eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EVT_BUS dependencies on OTA_EVT_SHD

Line 17: G_FETCHED_REC ota_evt_shd.g_rec_type;

13:
14: --
15: -- Working record
16: --
17: G_FETCHED_REC ota_evt_shd.g_rec_type;
18:
19: -- ----------------------------------------------------------------------------
20: -- |-----------------------------< chk_ddf >----------------------------------|
21: -- ----------------------------------------------------------------------------

Line 48: (p_rec in ota_evt_shd.g_rec_type

44: -- Internal Row Handler Use Only.
45: --
46: -- ----------------------------------------------------------------------------
47: procedure chk_ddf
48: (p_rec in ota_evt_shd.g_rec_type
49: ) is
50: --
51: l_proc varchar2(72) := g_package || 'chk_ddf';
52: --

Line 57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>

53: begin
54: hr_utility.set_location('Entering:'||l_proc,10);
55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>

Line 59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>

55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>

Line 61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>

57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or
59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>

Line 63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>

59: nvl(ota_evt_shd.g_old_rec.evt_information1, hr_api.g_varchar2) <>
60: nvl(p_rec.evt_information1, hr_api.g_varchar2) or
61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>

Line 65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>

61: nvl(ota_evt_shd.g_old_rec.evt_information2, hr_api.g_varchar2) <>
62: nvl(p_rec.evt_information2, hr_api.g_varchar2) or
63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>

Line 67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>

63: nvl(ota_evt_shd.g_old_rec.evt_information3, hr_api.g_varchar2) <>
64: nvl(p_rec.evt_information3, hr_api.g_varchar2) or
65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>

Line 69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>

65: nvl(ota_evt_shd.g_old_rec.evt_information4, hr_api.g_varchar2) <>
66: nvl(p_rec.evt_information4, hr_api.g_varchar2) or
67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>

Line 71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>

67: nvl(ota_evt_shd.g_old_rec.evt_information5, hr_api.g_varchar2) <>
68: nvl(p_rec.evt_information5, hr_api.g_varchar2) or
69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>

Line 73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>

69: nvl(ota_evt_shd.g_old_rec.evt_information6, hr_api.g_varchar2) <>
70: nvl(p_rec.evt_information6, hr_api.g_varchar2) or
71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>

Line 75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>

71: nvl(ota_evt_shd.g_old_rec.evt_information7, hr_api.g_varchar2) <>
72: nvl(p_rec.evt_information7, hr_api.g_varchar2) or
73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>

Line 77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>

73: nvl(ota_evt_shd.g_old_rec.evt_information8, hr_api.g_varchar2) <>
74: nvl(p_rec.evt_information8, hr_api.g_varchar2) or
75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>

Line 79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>

75: nvl(ota_evt_shd.g_old_rec.evt_information9, hr_api.g_varchar2) <>
76: nvl(p_rec.evt_information9, hr_api.g_varchar2) or
77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>

Line 81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>

77: nvl(ota_evt_shd.g_old_rec.evt_information10, hr_api.g_varchar2) <>
78: nvl(p_rec.evt_information10, hr_api.g_varchar2) or
79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>

Line 83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>

79: nvl(ota_evt_shd.g_old_rec.evt_information11, hr_api.g_varchar2) <>
80: nvl(p_rec.evt_information11, hr_api.g_varchar2) or
81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>

Line 85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>

81: nvl(ota_evt_shd.g_old_rec.evt_information12, hr_api.g_varchar2) <>
82: nvl(p_rec.evt_information12, hr_api.g_varchar2) or
83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>

Line 87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>

83: nvl(ota_evt_shd.g_old_rec.evt_information13, hr_api.g_varchar2) <>
84: nvl(p_rec.evt_information13, hr_api.g_varchar2) or
85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>

Line 89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>

85: nvl(ota_evt_shd.g_old_rec.evt_information14, hr_api.g_varchar2) <>
86: nvl(p_rec.evt_information14, hr_api.g_varchar2) or
87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>

Line 91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>

87: nvl(ota_evt_shd.g_old_rec.evt_information15, hr_api.g_varchar2) <>
88: nvl(p_rec.evt_information15, hr_api.g_varchar2) or
89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>

Line 93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>

89: nvl(ota_evt_shd.g_old_rec.evt_information16, hr_api.g_varchar2) <>
90: nvl(p_rec.evt_information16, hr_api.g_varchar2) or
91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>

Line 95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>

91: nvl(ota_evt_shd.g_old_rec.evt_information17, hr_api.g_varchar2) <>
92: nvl(p_rec.evt_information17, hr_api.g_varchar2) or
93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then

Line 97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>

93: nvl(ota_evt_shd.g_old_rec.evt_information18, hr_api.g_varchar2) <>
94: nvl(p_rec.evt_information18, hr_api.g_varchar2) or
95: nvl(ota_evt_shd.g_old_rec.evt_information19, hr_api.g_varchar2) <>
96: nvl(p_rec.evt_information19, hr_api.g_varchar2) or
97: nvl(ota_evt_shd.g_old_rec.evt_information20, hr_api.g_varchar2) <>
98: nvl(p_rec.evt_information20, hr_api.g_varchar2) ))
99: or (p_rec.event_id is null) then
100: --
101: -- Only execute the validation if absolutely necessary:

Line 1551: if (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))

1547: -- Do not perform the uniqueness check unless inserting, or updating
1548: -- with a value different from the current value (and not just changing
1549: -- case)
1550: --
1551: if (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
1552: and (upper (P_TITLE) = upper (OTA_EVT_SHD.G_OLD_REC.TITLE) ))) then
1553: --
1554: if (not UNIQUE_EVENT_TITLE (
1555: P_TITLE => P_TITLE,

Line 1552: and (upper (P_TITLE) = upper (OTA_EVT_SHD.G_OLD_REC.TITLE) ))) then

1548: -- with a value different from the current value (and not just changing
1549: -- case)
1550: --
1551: if (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
1552: and (upper (P_TITLE) = upper (OTA_EVT_SHD.G_OLD_REC.TITLE) ))) then
1553: --
1554: if (not UNIQUE_EVENT_TITLE (
1555: P_TITLE => P_TITLE,
1556: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID,

Line 1559: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVENTS_UK2');

1555: P_TITLE => P_TITLE,
1556: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID,
1557: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,
1558: P_EVENT_ID => P_EVENT_ID)) then
1559: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVENTS_UK2');
1560: end if;
1561: --
1562: end if;
1563: --

Line 1752: OTA_EVT_SHD.GET_COURSE_DATES (

1748: P_ARGUMENT => 'P_PARENT_EVENT_ID',
1749: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1750: --
1751: if (P_NEW_SESSION_DATE is not null) then
1752: OTA_EVT_SHD.GET_COURSE_DATES (
1753: P_PARENT_EVENT_ID,
1754: L_COURSE_START_DATE,
1755: L_COURSE_END_DATE);
1756: --

Line 1964: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then

1960: l_dates_updated boolean := FALSE;
1961: --
1962: begin
1963: --
1964: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1965: --
1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)

Line 1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)

1964: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1965: --
1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );
1972: --

Line 1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)

1966: l_dates_updated :=
1967: (nvl (p_course_start_date, hr_general.start_of_time) <>
1968: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1969: or nvl (p_course_end_date, hr_general.end_of_time) <>
1970: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1971: );
1972: --
1973: end if;
1974: --

Line 1994: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_EVENT_SESSION_SPAN');

1990: p_event_id => p_event_id,
1991: p_course_start_date => p_course_start_date,
1992: p_course_end_date => p_course_end_date)
1993: then
1994: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_EVENT_SESSION_SPAN');
1995: end if;
1996: --
1997: end if;
1998: --

Line 2080: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))

2076: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
2077: --
2078: -- OK ?
2079: --
2080: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2081: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2082: --
2083: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2084: --

Line 2081: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then

2077: --
2078: -- OK ?
2079: --
2080: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2081: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2082: --
2083: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2084: --
2085: if ( (P_EVENT_TYPE = 'SESSION')

Line 2089: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_SESSION_TIMING');

2085: if ( (P_EVENT_TYPE = 'SESSION')
2086: and (not COURSE_DATES_SPAN_SESSIONS (
2087: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,
2088: P_NEW_SESSION_DATE => P_COURSE_START_DATE))) then
2089: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_SESSION_TIMING');
2090: end if;
2091: --
2092: end if;
2093: --

Line 2142: OTA_EVT_SHD.FETCH_EVENT_DETAILS (

2138: -- Is there a parent ?
2139: --
2140: if (P_PARENT_EVENT_ID is not null) then
2141: --
2142: OTA_EVT_SHD.FETCH_EVENT_DETAILS (
2143: P_EVENT_ID => P_PARENT_EVENT_ID,
2144: P_EVENT_EXISTS => W_PARENT_ID_EXISTS);
2145: --
2146: if (W_PARENT_ID_EXISTS) then

Line 2194: and (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))

2190: 'Entering:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2191: 5);
2192: --
2193: if ( (P_PARENT_EVENT_ID is not null )
2194: and (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2195: and (OTA_EVT_SHD.G_OLD_REC.PARENT_EVENT_ID = P_PARENT_EVENT_ID )))) then
2196: --
2197: if (not VALID_PARENT_EVENT (
2198: P_PARENT_EVENT_ID,

Line 2195: and (OTA_EVT_SHD.G_OLD_REC.PARENT_EVENT_ID = P_PARENT_EVENT_ID )))) then

2191: 5);
2192: --
2193: if ( (P_PARENT_EVENT_ID is not null )
2194: and (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2195: and (OTA_EVT_SHD.G_OLD_REC.PARENT_EVENT_ID = P_PARENT_EVENT_ID )))) then
2196: --
2197: if (not VALID_PARENT_EVENT (
2198: P_PARENT_EVENT_ID,
2199: P_BUSINESS_GROUP_ID,

Line 2201: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_INVALID_PARENT');

2197: if (not VALID_PARENT_EVENT (
2198: P_PARENT_EVENT_ID,
2199: P_BUSINESS_GROUP_ID,
2200: P_EVENT_TYPE)) then
2201: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_INVALID_PARENT');
2202: end if;
2203: --
2204: end if;
2205: --

Line 2312: or (not OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number))) then

2308: --
2309: -- This check only applies to existing PROGRAMMEs and PROGRAMME_MEMBERs
2310: --
2311: if ( (P_EVENT_TYPE not in ('PROGRAMME', 'PROGRAMME MEMBER'))
2312: or (not OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number))) then
2313: return;
2314: end if;
2315: --
2316: -- With changing enrolment dates

Line 2318: if ( (OTA_EVT_SHD.g_old_rec.enrolment_start_date <> p_enrolment_start_date)

2314: end if;
2315: --
2316: -- With changing enrolment dates
2317: --
2318: if ( (OTA_EVT_SHD.g_old_rec.enrolment_start_date <> p_enrolment_start_date)
2319: or (OTA_EVT_SHD.g_old_rec.enrolment_end_date <> p_enrolment_end_date )) then
2320: --
2321: check_parameters;
2322: --

Line 2319: or (OTA_EVT_SHD.g_old_rec.enrolment_end_date <> p_enrolment_end_date )) then

2315: --
2316: -- With changing enrolment dates
2317: --
2318: if ( (OTA_EVT_SHD.g_old_rec.enrolment_start_date <> p_enrolment_start_date)
2319: or (OTA_EVT_SHD.g_old_rec.enrolment_end_date <> p_enrolment_end_date )) then
2320: --
2321: check_parameters;
2322: --
2323: if NOT enrolment_dates_valid then

Line 2324: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_ENROLMENT_DATE_SPAN');

2320: --
2321: check_parameters;
2322: --
2323: if NOT enrolment_dates_valid then
2324: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_ENROLMENT_DATE_SPAN');
2325: end if;
2326: --
2327: end if;
2328: --

Line 2346: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis

2342: l_proc varchar2(72) := 'price_basis_change';
2343: l_exists varchar2(1);
2344: --
2345: l_price_basis_changed boolean :=
2346: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis
2347: ,p_price_basis);
2348: --
2349: cursor get_enrollments is
2350: select null

Line 2446: P_REC in out nocopy OTA_EVT_SHD.G_REC_TYPE

2442: -- Performs the validation routines common to both insert and update.
2443: --
2444: -- VT 05/06/97 #488173
2445: procedure VALIDITY_CHECKS (
2446: P_REC in out nocopy OTA_EVT_SHD.G_REC_TYPE
2447: ) is
2448: --
2449: W_PROC varchar2 (72)
2450: := G_PACKAGE || 'VALIDITY_CHECKS';

Line 2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,

2448: --
2449: W_PROC varchar2 (72)
2450: := G_PACKAGE || 'VALIDITY_CHECKS';
2451: l_course_start_date_changed boolean
2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2453: p_rec.course_start_date);
2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);

Line 2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,

2451: l_course_start_date_changed boolean
2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2453: p_rec.course_start_date);
2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);
2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);

Line 2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,

2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);
2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);
2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);

Line 2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,

2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);
2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);
2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);

Line 2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,

2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);
2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);
2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);

Line 2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,

2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);
2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);
2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);

Line 2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,

2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);
2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);
2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);

Line 2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,

2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);
2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);
2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);

Line 2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,

2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);
2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);
2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);

Line 2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,

2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);
2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);
2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);

Line 2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,

2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);
2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);
2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);

Line 2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,

2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);
2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);
2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);

Line 2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,

2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);
2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);
2490: l_timezone_changed boolean
2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);

Line 2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,

2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);
2490: l_timezone_changed boolean
2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);
2493: --bug#4895398
2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

Line 2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);
2493: --bug#4895398
2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2496:
2497: l_course_end_time_changed boolean
2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2499: --bug#4895398

Line 2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);

2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2496:
2497: l_course_end_time_changed boolean
2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2499: --bug#4895398
2500:
2501: --Enhancement 1823602.
2502: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;

Line 3154: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>

3150: hr_utility.set_location('Entering:'||l_proc, 5);
3151: --
3152:
3153: if (((p_event_id is not null) and
3154: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3155: nvl(p_owner_id,hr_api.g_number))
3156: or (p_event_id is null)) then
3157:
3158: IF p_owner_id is not null then

Line 3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>

3213: Begin
3214: hr_utility.set_location('Entering:'||l_proc, 5);
3215:
3216: if (((p_event_id is not null) and
3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3218: nvl(p_line_id,hr_api.g_number))
3219: or (p_event_id is null)) then
3220: --
3221: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,

3261:
3262: l_proc varchar2(72) := g_package||'chk_status_changed';
3263:
3264: l_event_status_changed boolean :=
3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3266: p_event_status);
3267: l_status_type ota_booking_status_types.type%type;
3268: l_old_status_type ota_booking_status_types.type%type;
3269: l_invoice_rule varchar2(80);

Line 3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>

3417:
3418: Begin
3419: hr_utility.set_location('Entering:'||l_proc, 5);
3420: if (((p_event_id is not null) and
3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3422: nvl(p_training_center_id,hr_api.g_number))
3423: or (p_event_id is null)) then
3424: --
3425: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>

3475: Begin
3476: hr_utility.set_location('Entering:'||l_proc, 5);
3477:
3478: if (((p_event_id is not null) and
3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3480: nvl(p_location_id,hr_api.g_number))
3481: or (p_event_id is null)) then
3482: --
3483: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>

3535:
3536: hr_utility.set_location('Entering:'||l_proc, 5);
3537:
3538: if (((p_event_id is not null) and
3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3540: nvl(p_offering_id,hr_api.g_number))
3541: or (p_event_id is null)) then
3542: --
3543: hr_utility.set_location('Entering:'||l_proc, 10);

Line 3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');

3545: hr_utility.set_location('Entering:'||l_proc, 15);
3546: open csr_offering;
3547: fetch csr_offering into l_exists;
3548: if csr_offering%found then
3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3550: end if;
3551: close csr_offering;
3552: hr_utility.set_location('Leaving:'||l_proc, 20);
3553: end if;

Line 3681: Procedure insert_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is

3677: -- ----------------------------------------------------------------------------
3678: -- |---------------------------< insert_validate >----------------------------|
3679: -- ----------------------------------------------------------------------------
3680: -- VT 05/06/97 #488173
3681: Procedure insert_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3682: --
3683: l_proc varchar2(72) := g_package||'insert_validate';
3684: --
3685: Begin

Line 3703: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp

3699: --modified for eBS by asud
3700: -- Call all supporting business operations
3701: -- Validate Important Attributes
3702: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3703: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3704: --
3705: hr_multi_message.end_validation_set;
3706:
3707: VALIDITY_CHECKS (

Line 3726: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is

3722: -- ----------------------------------------------------------------------------
3723: -- |---------------------------< update_validate >----------------------------|
3724: -- ----------------------------------------------------------------------------
3725: -- VT 05/06/97 #488173
3726: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3727: --
3728: l_proc varchar2(72) := g_package||'update_validate';
3729: l_secure_event_flag_changed boolean
3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);

Line 3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);

3726: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3727: --
3728: l_proc varchar2(72) := g_package||'update_validate';
3729: l_secure_event_flag_changed boolean
3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3731: l_organization_id_changed boolean
3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3733: --
3734: Begin

Line 3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);

3728: l_proc varchar2(72) := g_package||'update_validate';
3729: l_secure_event_flag_changed boolean
3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3731: l_organization_id_changed boolean
3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3733: --
3734: Begin
3735: --
3736: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3751: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp

3747: --
3748: */
3749: -- Validate Important Attributes
3750: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3751: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3752: --
3753: hr_multi_message.end_validation_set;
3754:
3755: VALIDITY_CHECKS (

Line 3764: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);

3760: IF l_secure_event_flag_changed THEN
3761: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3762: ELSE -- secure event flag not changed
3763: IF l_organization_id_changed THEN
3764: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3765: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3766: ELSE
3767: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3768: END IF;

Line 3772: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);

3768: END IF;
3769: END IF;
3770: ELSE
3771: IF l_secure_event_flag_changed THEN
3772: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3773: END IF;
3774: END IF;
3775: -- bug 4348022
3776:

Line 3787: Procedure delete_validate(p_rec in ota_evt_shd.g_rec_type) is

3783: --
3784: -- ----------------------------------------------------------------------------
3785: -- |---------------------------< delete_validate >----------------------------|
3786: -- ----------------------------------------------------------------------------
3787: Procedure delete_validate(p_rec in ota_evt_shd.g_rec_type) is
3788: --
3789: l_proc varchar2(72) := g_package||'delete_validate';
3790: --
3791: Begin

Line 3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id

3792: hr_utility.set_location('Entering:'||l_proc, 5);
3793: --
3794: -- Call all supporting business operations
3795: check_child_entities (p_event_id => p_rec.event_id);
3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3797: ,ota_evt_shd.g_old_rec.org_id) ;
3798: --
3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);

Line 3797: ,ota_evt_shd.g_old_rec.org_id) ;

3793: --
3794: -- Call all supporting business operations
3795: check_child_entities (p_event_id => p_rec.event_id);
3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3797: ,ota_evt_shd.g_old_rec.org_id) ;
3798: --
3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3801: END IF;

Line 3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN

3795: check_child_entities (p_event_id => p_rec.event_id);
3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3797: ,ota_evt_shd.g_old_rec.org_id) ;
3798: --
3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3801: END IF;
3802: --
3803: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);

3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3797: ,ota_evt_shd.g_old_rec.org_id) ;
3798: --
3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3801: END IF;
3802: --
3803: hr_utility.set_location(' Leaving:'||l_proc, 10);
3804: End delete_validate;