APPS.OTA_EVT_DEL dependencies on OTA_EVT_SHD

Line 51: Procedure delete_dml(p_rec in ota_evt_shd.g_rec_type) is

47: -- Internal Development Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ota_evt_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ota_evt_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ota_evt_shd.g_api_dml := true; -- Set the api dml status
59: --
60: /* -- Removed until a Delete Function is implemented
61: --
62: -- Delete delegate bookings

Line 78: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

74: --
75: delete from ota_events
76: where event_id = p_rec.event_id;
77: --
78: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception

Line 85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

81: --
82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
86: ota_evt_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 86: ota_evt_shd.constraint_error

82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
86: ota_evt_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;

Line 89: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
86: ota_evt_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;
91: End delete_dml;
92: --
93: -- ----------------------------------------------------------------------------

Line 125: Procedure pre_delete(p_rec in ota_evt_shd.g_rec_type) is

121: -- Internal Development Use Only.
122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure pre_delete(p_rec in ota_evt_shd.g_rec_type) is
126: --
127: l_proc varchar2(72) := g_package||'pre_delete';
128: --
129: Begin

Line 167: Procedure post_delete(p_rec in ota_evt_shd.g_rec_type) is

163: -- Internal Development Use Only.
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure post_delete(p_rec in ota_evt_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_delete';
170: --
171: Begin

Line 182: p_rec in ota_evt_shd.g_rec_type,

178: -- |---------------------------------< del >----------------------------------|
179: -- ----------------------------------------------------------------------------
180: Procedure del
181: (
182: p_rec in ota_evt_shd.g_rec_type,
183: p_validate in boolean default false
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'del';

Line 202: ota_evt_shd.lck

198: End If;
199: --
200: -- We must lock the row which we need to delete.
201: --
202: ota_evt_shd.lck
203: (
204: p_rec.event_id,
205: p_rec.object_version_number
206: );

Line 258: l_rec ota_evt_shd.g_rec_type;

254: p_object_version_number in number,
255: p_validate in boolean default false
256: ) is
257: --
258: l_rec ota_evt_shd.g_rec_type;
259: l_proc varchar2(72) := g_package||'del';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);