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 1733: OTA_EVT_SHD.GET_COURSE_DATES (

1729: P_ARGUMENT => 'P_PARENT_EVENT_ID',
1730: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1731: --
1732: if (P_NEW_SESSION_DATE is not null) then
1733: OTA_EVT_SHD.GET_COURSE_DATES (
1734: P_PARENT_EVENT_ID,
1735: L_COURSE_START_DATE,
1736: L_COURSE_END_DATE);
1737: --

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

1941: l_dates_updated boolean := FALSE;
1942: --
1943: begin
1944: --
1945: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1946: --
1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)

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

1945: if (OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number)) then
1946: --
1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );
1953: --

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

1947: l_dates_updated :=
1948: (nvl (p_course_start_date, hr_general.start_of_time) <>
1949: nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
1950: or nvl (p_course_end_date, hr_general.end_of_time) <>
1951: nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
1952: );
1953: --
1954: end if;
1955: --

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

1971: p_event_id => p_event_id,
1972: p_course_start_date => p_course_start_date,
1973: p_course_end_date => p_course_end_date)
1974: then
1975: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_EVENT_SESSION_SPAN');
1976: end if;
1977: --
1978: end if;
1979: --

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

2057: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
2058: --
2059: -- OK ?
2060: --
2061: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2062: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2063: --
2064: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2065: --

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

2058: --
2059: -- OK ?
2060: --
2061: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2062: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2063: --
2064: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2065: --
2066: if ( (P_EVENT_TYPE = 'SESSION')

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

2066: if ( (P_EVENT_TYPE = 'SESSION')
2067: and (not COURSE_DATES_SPAN_SESSIONS (
2068: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,
2069: P_NEW_SESSION_DATE => P_COURSE_START_DATE))) then
2070: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_SESSION_TIMING');
2071: end if;
2072: --
2073: end if;
2074: --

Line 2123: OTA_EVT_SHD.FETCH_EVENT_DETAILS (

2119: -- Is there a parent ?
2120: --
2121: if (P_PARENT_EVENT_ID is not null) then
2122: --
2123: OTA_EVT_SHD.FETCH_EVENT_DETAILS (
2124: P_EVENT_ID => P_PARENT_EVENT_ID,
2125: P_EVENT_EXISTS => W_PARENT_ID_EXISTS);
2126: --
2127: if (W_PARENT_ID_EXISTS) then

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

2171: 'Entering:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2172: 5);
2173: --
2174: if ( (P_PARENT_EVENT_ID is not null )
2175: and (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2176: and (OTA_EVT_SHD.G_OLD_REC.PARENT_EVENT_ID = P_PARENT_EVENT_ID )))) then
2177: --
2178: if (not VALID_PARENT_EVENT (
2179: P_PARENT_EVENT_ID,

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

2172: 5);
2173: --
2174: if ( (P_PARENT_EVENT_ID is not null )
2175: and (not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2176: and (OTA_EVT_SHD.G_OLD_REC.PARENT_EVENT_ID = P_PARENT_EVENT_ID )))) then
2177: --
2178: if (not VALID_PARENT_EVENT (
2179: P_PARENT_EVENT_ID,
2180: P_BUSINESS_GROUP_ID,

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

2178: if (not VALID_PARENT_EVENT (
2179: P_PARENT_EVENT_ID,
2180: P_BUSINESS_GROUP_ID,
2181: P_EVENT_TYPE)) then
2182: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_INVALID_PARENT');
2183: end if;
2184: --
2185: end if;
2186: --

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

2289: --
2290: -- This check only applies to existing PROGRAMMEs and PROGRAMME_MEMBERs
2291: --
2292: if ( (P_EVENT_TYPE not in ('PROGRAMME', 'PROGRAMME MEMBER'))
2293: or (not OTA_EVT_SHD.api_updating (p_event_id, p_object_version_number))) then
2294: return;
2295: end if;
2296: --
2297: -- With changing enrolment dates

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

2295: end if;
2296: --
2297: -- With changing enrolment dates
2298: --
2299: if ( (OTA_EVT_SHD.g_old_rec.enrolment_start_date <> p_enrolment_start_date)
2300: or (OTA_EVT_SHD.g_old_rec.enrolment_end_date <> p_enrolment_end_date )) then
2301: --
2302: check_parameters;
2303: --

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

2296: --
2297: -- With changing enrolment dates
2298: --
2299: if ( (OTA_EVT_SHD.g_old_rec.enrolment_start_date <> p_enrolment_start_date)
2300: or (OTA_EVT_SHD.g_old_rec.enrolment_end_date <> p_enrolment_end_date )) then
2301: --
2302: check_parameters;
2303: --
2304: if NOT enrolment_dates_valid then

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

2301: --
2302: check_parameters;
2303: --
2304: if NOT enrolment_dates_valid then
2305: OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVT_ENROLMENT_DATE_SPAN');
2306: end if;
2307: --
2308: end if;
2309: --

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

2323: l_proc varchar2(72) := 'price_basis_change';
2324: l_exists varchar2(1);
2325: --
2326: l_price_basis_changed boolean :=
2327: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis
2328: ,p_price_basis);
2329: --
2330: cursor get_enrollments is
2331: select null

Line 2427: P_REC in out nocopy OTA_EVT_SHD.G_REC_TYPE

2423: -- Performs the validation routines common to both insert and update.
2424: --
2425: -- VT 05/06/97 #488173
2426: procedure VALIDITY_CHECKS (
2427: P_REC in out nocopy OTA_EVT_SHD.G_REC_TYPE
2428: ) is
2429: --
2430: W_PROC varchar2 (72)
2431: := G_PACKAGE || 'VALIDITY_CHECKS';

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

2429: --
2430: W_PROC varchar2 (72)
2431: := G_PACKAGE || 'VALIDITY_CHECKS';
2432: l_course_start_date_changed boolean
2433: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2434: p_rec.course_start_date);
2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);

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

2432: l_course_start_date_changed boolean
2433: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2434: p_rec.course_start_date);
2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);
2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);

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

2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);
2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);
2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);

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

2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);
2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);
2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);

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

2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);
2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);
2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);

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

2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);
2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);
2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);

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

2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);
2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);
2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);

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

2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);
2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);
2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);

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

2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);
2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);
2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);

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

2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);
2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);
2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);

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

2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);
2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);
2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);

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

2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);
2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);
2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);

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

2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);
2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);
2471: l_timezone_changed boolean
2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);

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

2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);
2471: l_timezone_changed boolean
2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);
2474: --bug#4895398
2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

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

2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);
2474: --bug#4895398
2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2477:
2478: l_course_end_time_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2480: --bug#4895398

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

2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2477:
2478: l_course_end_time_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2480: --bug#4895398
2481:
2482: --Enhancement 1823602.
2483: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;

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

3130: hr_utility.set_location('Entering:'||l_proc, 5);
3131: --
3132:
3133: if (((p_event_id is not null) and
3134: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>
3135: nvl(p_owner_id,hr_api.g_number))
3136: or (p_event_id is null)) then
3137:
3138: IF p_owner_id is not null then

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

3193: Begin
3194: hr_utility.set_location('Entering:'||l_proc, 5);
3195:
3196: if (((p_event_id is not null) and
3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3198: nvl(p_line_id,hr_api.g_number))
3199: or (p_event_id is null)) then
3200: --
3201: hr_utility.set_location('Entering:'||l_proc, 10);

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

3241:
3242: l_proc varchar2(72) := g_package||'chk_status_changed';
3243:
3244: l_event_status_changed boolean :=
3245: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3246: p_event_status);
3247: l_status_type ota_booking_status_types.type%type;
3248: l_old_status_type ota_booking_status_types.type%type;
3249: l_invoice_rule varchar2(80);

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

3397:
3398: Begin
3399: hr_utility.set_location('Entering:'||l_proc, 5);
3400: if (((p_event_id is not null) and
3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3402: nvl(p_training_center_id,hr_api.g_number))
3403: or (p_event_id is null)) then
3404: --
3405: hr_utility.set_location('Entering:'||l_proc, 10);

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

3455: Begin
3456: hr_utility.set_location('Entering:'||l_proc, 5);
3457:
3458: if (((p_event_id is not null) and
3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3460: nvl(p_location_id,hr_api.g_number))
3461: or (p_event_id is null)) then
3462: --
3463: hr_utility.set_location('Entering:'||l_proc, 10);

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

3515:
3516: hr_utility.set_location('Entering:'||l_proc, 5);
3517:
3518: if (((p_event_id is not null) and
3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3520: nvl(p_offering_id,hr_api.g_number))
3521: or (p_event_id is null)) then
3522: --
3523: hr_utility.set_location('Entering:'||l_proc, 10);

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

3525: hr_utility.set_location('Entering:'||l_proc, 15);
3526: open csr_offering;
3527: fetch csr_offering into l_exists;
3528: if csr_offering%found then
3529: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3530: end if;
3531: close csr_offering;
3532: hr_utility.set_location('Leaving:'||l_proc, 20);
3533: end if;

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

3657: -- ----------------------------------------------------------------------------
3658: -- |---------------------------< insert_validate >----------------------------|
3659: -- ----------------------------------------------------------------------------
3660: -- VT 05/06/97 #488173
3661: Procedure insert_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3662: --
3663: l_proc varchar2(72) := g_package||'insert_validate';
3664: --
3665: Begin

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

3679: --modified for eBS by asud
3680: -- Call all supporting business operations
3681: -- Validate Important Attributes
3682: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3683: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3684: --
3685: hr_multi_message.end_validation_set;
3686:
3687: VALIDITY_CHECKS (

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

3702: -- ----------------------------------------------------------------------------
3703: -- |---------------------------< update_validate >----------------------------|
3704: -- ----------------------------------------------------------------------------
3705: -- VT 05/06/97 #488173
3706: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3707: --
3708: l_proc varchar2(72) := g_package||'update_validate';
3709: l_secure_event_flag_changed boolean
3710: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);

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

3706: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3707: --
3708: l_proc varchar2(72) := g_package||'update_validate';
3709: l_secure_event_flag_changed boolean
3710: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3711: l_organization_id_changed boolean
3712: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3713: --
3714: Begin

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

3708: l_proc varchar2(72) := g_package||'update_validate';
3709: l_secure_event_flag_changed boolean
3710: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3711: l_organization_id_changed boolean
3712: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3713: --
3714: Begin
3715: --
3716: hr_utility.set_location('Entering:'||l_proc, 5);

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

3727: --
3728: */
3729: -- Validate Important Attributes
3730: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,
3731: p_associated_column1 => ota_evt_shd.g_tab_nam||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
3732: --
3733: hr_multi_message.end_validation_set;
3734:
3735: VALIDITY_CHECKS (

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

3740: IF l_secure_event_flag_changed THEN
3741: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3742: ELSE -- secure event flag not changed
3743: IF l_organization_id_changed THEN
3744: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3745: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3746: ELSE
3747: chk_secure_event_flag(p_organization_id => p_rec.organization_id);
3748: END IF;

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

3748: END IF;
3749: END IF;
3750: ELSE
3751: IF l_secure_event_flag_changed THEN
3752: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3753: END IF;
3754: END IF;
3755: -- bug 4348022
3756:

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

3763: --
3764: -- ----------------------------------------------------------------------------
3765: -- |---------------------------< delete_validate >----------------------------|
3766: -- ----------------------------------------------------------------------------
3767: Procedure delete_validate(p_rec in ota_evt_shd.g_rec_type) is
3768: --
3769: l_proc varchar2(72) := g_package||'delete_validate';
3770: --
3771: Begin

Line 3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id

3772: hr_utility.set_location('Entering:'||l_proc, 5);
3773: --
3774: -- Call all supporting business operations
3775: check_child_entities (p_event_id => p_rec.event_id);
3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3777: ,ota_evt_shd.g_old_rec.org_id) ;
3778: --
3779: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3780: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);

Line 3777: ,ota_evt_shd.g_old_rec.org_id) ;

3773: --
3774: -- Call all supporting business operations
3775: check_child_entities (p_event_id => p_rec.event_id);
3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3777: ,ota_evt_shd.g_old_rec.org_id) ;
3778: --
3779: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3780: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3781: END IF;

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

3775: check_child_entities (p_event_id => p_rec.event_id);
3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3777: ,ota_evt_shd.g_old_rec.org_id) ;
3778: --
3779: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3780: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3781: END IF;
3782: --
3783: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id
3777: ,ota_evt_shd.g_old_rec.org_id) ;
3778: --
3779: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3780: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3781: END IF;
3782: --
3783: hr_utility.set_location(' Leaving:'||l_proc, 10);
3784: End delete_validate;