APPS.OTA_ACI_DEL dependencies on OTA_ACI_SHD

Line 52: (p_rec in ota_aci_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_aci_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: ota_aci_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ota_aci_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_act_cat_inclusions row.
63: --
64: delete from ota_act_cat_inclusions

Line 68: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

64: delete from ota_act_cat_inclusions
65: where activity_version_id = p_rec.activity_version_id
66: and category_usage_id = p_rec.category_usage_id;
67: --
68: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception

Line 75: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
76: ota_aci_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

Line 76: ota_aci_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
76: ota_aci_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
80: Raise;

Line 79: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

75: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
76: ota_aci_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
80: Raise;
81: End delete_dml;
82: --
83: -- ----------------------------------------------------------------------------

Line 115: Procedure pre_delete(p_rec in ota_aci_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in ota_aci_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 157: Procedure post_delete(p_rec in ota_aci_shd.g_rec_type) is

153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in ota_aci_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 171: => ota_aci_shd.g_old_rec.activity_category

167: => p_rec.activity_version_id
168: ,p_category_usage_id
169: => p_rec.category_usage_id
170: ,p_activity_category_o
171: => ota_aci_shd.g_old_rec.activity_category
172: ,p_object_version_number_o
173: => ota_aci_shd.g_old_rec.object_version_number
174: ,p_event_id_o
175: => ota_aci_shd.g_old_rec.event_id

Line 173: => ota_aci_shd.g_old_rec.object_version_number

169: => p_rec.category_usage_id
170: ,p_activity_category_o
171: => ota_aci_shd.g_old_rec.activity_category
172: ,p_object_version_number_o
173: => ota_aci_shd.g_old_rec.object_version_number
174: ,p_event_id_o
175: => ota_aci_shd.g_old_rec.event_id
176: ,p_comments_o
177: => ota_aci_shd.g_old_rec.comments

Line 175: => ota_aci_shd.g_old_rec.event_id

171: => ota_aci_shd.g_old_rec.activity_category
172: ,p_object_version_number_o
173: => ota_aci_shd.g_old_rec.object_version_number
174: ,p_event_id_o
175: => ota_aci_shd.g_old_rec.event_id
176: ,p_comments_o
177: => ota_aci_shd.g_old_rec.comments
178: ,p_aci_information_category_o
179: => ota_aci_shd.g_old_rec.aci_information_category

Line 177: => ota_aci_shd.g_old_rec.comments

173: => ota_aci_shd.g_old_rec.object_version_number
174: ,p_event_id_o
175: => ota_aci_shd.g_old_rec.event_id
176: ,p_comments_o
177: => ota_aci_shd.g_old_rec.comments
178: ,p_aci_information_category_o
179: => ota_aci_shd.g_old_rec.aci_information_category
180: ,p_aci_information1_o
181: => ota_aci_shd.g_old_rec.aci_information1

Line 179: => ota_aci_shd.g_old_rec.aci_information_category

175: => ota_aci_shd.g_old_rec.event_id
176: ,p_comments_o
177: => ota_aci_shd.g_old_rec.comments
178: ,p_aci_information_category_o
179: => ota_aci_shd.g_old_rec.aci_information_category
180: ,p_aci_information1_o
181: => ota_aci_shd.g_old_rec.aci_information1
182: ,p_aci_information2_o
183: => ota_aci_shd.g_old_rec.aci_information2

Line 181: => ota_aci_shd.g_old_rec.aci_information1

177: => ota_aci_shd.g_old_rec.comments
178: ,p_aci_information_category_o
179: => ota_aci_shd.g_old_rec.aci_information_category
180: ,p_aci_information1_o
181: => ota_aci_shd.g_old_rec.aci_information1
182: ,p_aci_information2_o
183: => ota_aci_shd.g_old_rec.aci_information2
184: ,p_aci_information3_o
185: => ota_aci_shd.g_old_rec.aci_information3

Line 183: => ota_aci_shd.g_old_rec.aci_information2

179: => ota_aci_shd.g_old_rec.aci_information_category
180: ,p_aci_information1_o
181: => ota_aci_shd.g_old_rec.aci_information1
182: ,p_aci_information2_o
183: => ota_aci_shd.g_old_rec.aci_information2
184: ,p_aci_information3_o
185: => ota_aci_shd.g_old_rec.aci_information3
186: ,p_aci_information4_o
187: => ota_aci_shd.g_old_rec.aci_information4

Line 185: => ota_aci_shd.g_old_rec.aci_information3

181: => ota_aci_shd.g_old_rec.aci_information1
182: ,p_aci_information2_o
183: => ota_aci_shd.g_old_rec.aci_information2
184: ,p_aci_information3_o
185: => ota_aci_shd.g_old_rec.aci_information3
186: ,p_aci_information4_o
187: => ota_aci_shd.g_old_rec.aci_information4
188: ,p_aci_information5_o
189: => ota_aci_shd.g_old_rec.aci_information5

Line 187: => ota_aci_shd.g_old_rec.aci_information4

183: => ota_aci_shd.g_old_rec.aci_information2
184: ,p_aci_information3_o
185: => ota_aci_shd.g_old_rec.aci_information3
186: ,p_aci_information4_o
187: => ota_aci_shd.g_old_rec.aci_information4
188: ,p_aci_information5_o
189: => ota_aci_shd.g_old_rec.aci_information5
190: ,p_aci_information6_o
191: => ota_aci_shd.g_old_rec.aci_information6

Line 189: => ota_aci_shd.g_old_rec.aci_information5

185: => ota_aci_shd.g_old_rec.aci_information3
186: ,p_aci_information4_o
187: => ota_aci_shd.g_old_rec.aci_information4
188: ,p_aci_information5_o
189: => ota_aci_shd.g_old_rec.aci_information5
190: ,p_aci_information6_o
191: => ota_aci_shd.g_old_rec.aci_information6
192: ,p_aci_information7_o
193: => ota_aci_shd.g_old_rec.aci_information7

Line 191: => ota_aci_shd.g_old_rec.aci_information6

187: => ota_aci_shd.g_old_rec.aci_information4
188: ,p_aci_information5_o
189: => ota_aci_shd.g_old_rec.aci_information5
190: ,p_aci_information6_o
191: => ota_aci_shd.g_old_rec.aci_information6
192: ,p_aci_information7_o
193: => ota_aci_shd.g_old_rec.aci_information7
194: ,p_aci_information8_o
195: => ota_aci_shd.g_old_rec.aci_information8

Line 193: => ota_aci_shd.g_old_rec.aci_information7

189: => ota_aci_shd.g_old_rec.aci_information5
190: ,p_aci_information6_o
191: => ota_aci_shd.g_old_rec.aci_information6
192: ,p_aci_information7_o
193: => ota_aci_shd.g_old_rec.aci_information7
194: ,p_aci_information8_o
195: => ota_aci_shd.g_old_rec.aci_information8
196: ,p_aci_information9_o
197: => ota_aci_shd.g_old_rec.aci_information9

Line 195: => ota_aci_shd.g_old_rec.aci_information8

191: => ota_aci_shd.g_old_rec.aci_information6
192: ,p_aci_information7_o
193: => ota_aci_shd.g_old_rec.aci_information7
194: ,p_aci_information8_o
195: => ota_aci_shd.g_old_rec.aci_information8
196: ,p_aci_information9_o
197: => ota_aci_shd.g_old_rec.aci_information9
198: ,p_aci_information10_o
199: => ota_aci_shd.g_old_rec.aci_information10

Line 197: => ota_aci_shd.g_old_rec.aci_information9

193: => ota_aci_shd.g_old_rec.aci_information7
194: ,p_aci_information8_o
195: => ota_aci_shd.g_old_rec.aci_information8
196: ,p_aci_information9_o
197: => ota_aci_shd.g_old_rec.aci_information9
198: ,p_aci_information10_o
199: => ota_aci_shd.g_old_rec.aci_information10
200: ,p_aci_information11_o
201: => ota_aci_shd.g_old_rec.aci_information11

Line 199: => ota_aci_shd.g_old_rec.aci_information10

195: => ota_aci_shd.g_old_rec.aci_information8
196: ,p_aci_information9_o
197: => ota_aci_shd.g_old_rec.aci_information9
198: ,p_aci_information10_o
199: => ota_aci_shd.g_old_rec.aci_information10
200: ,p_aci_information11_o
201: => ota_aci_shd.g_old_rec.aci_information11
202: ,p_aci_information12_o
203: => ota_aci_shd.g_old_rec.aci_information12

Line 201: => ota_aci_shd.g_old_rec.aci_information11

197: => ota_aci_shd.g_old_rec.aci_information9
198: ,p_aci_information10_o
199: => ota_aci_shd.g_old_rec.aci_information10
200: ,p_aci_information11_o
201: => ota_aci_shd.g_old_rec.aci_information11
202: ,p_aci_information12_o
203: => ota_aci_shd.g_old_rec.aci_information12
204: ,p_aci_information13_o
205: => ota_aci_shd.g_old_rec.aci_information13

Line 203: => ota_aci_shd.g_old_rec.aci_information12

199: => ota_aci_shd.g_old_rec.aci_information10
200: ,p_aci_information11_o
201: => ota_aci_shd.g_old_rec.aci_information11
202: ,p_aci_information12_o
203: => ota_aci_shd.g_old_rec.aci_information12
204: ,p_aci_information13_o
205: => ota_aci_shd.g_old_rec.aci_information13
206: ,p_aci_information14_o
207: => ota_aci_shd.g_old_rec.aci_information14

Line 205: => ota_aci_shd.g_old_rec.aci_information13

201: => ota_aci_shd.g_old_rec.aci_information11
202: ,p_aci_information12_o
203: => ota_aci_shd.g_old_rec.aci_information12
204: ,p_aci_information13_o
205: => ota_aci_shd.g_old_rec.aci_information13
206: ,p_aci_information14_o
207: => ota_aci_shd.g_old_rec.aci_information14
208: ,p_aci_information15_o
209: => ota_aci_shd.g_old_rec.aci_information15

Line 207: => ota_aci_shd.g_old_rec.aci_information14

203: => ota_aci_shd.g_old_rec.aci_information12
204: ,p_aci_information13_o
205: => ota_aci_shd.g_old_rec.aci_information13
206: ,p_aci_information14_o
207: => ota_aci_shd.g_old_rec.aci_information14
208: ,p_aci_information15_o
209: => ota_aci_shd.g_old_rec.aci_information15
210: ,p_aci_information16_o
211: => ota_aci_shd.g_old_rec.aci_information16

Line 209: => ota_aci_shd.g_old_rec.aci_information15

205: => ota_aci_shd.g_old_rec.aci_information13
206: ,p_aci_information14_o
207: => ota_aci_shd.g_old_rec.aci_information14
208: ,p_aci_information15_o
209: => ota_aci_shd.g_old_rec.aci_information15
210: ,p_aci_information16_o
211: => ota_aci_shd.g_old_rec.aci_information16
212: ,p_aci_information17_o
213: => ota_aci_shd.g_old_rec.aci_information17

Line 211: => ota_aci_shd.g_old_rec.aci_information16

207: => ota_aci_shd.g_old_rec.aci_information14
208: ,p_aci_information15_o
209: => ota_aci_shd.g_old_rec.aci_information15
210: ,p_aci_information16_o
211: => ota_aci_shd.g_old_rec.aci_information16
212: ,p_aci_information17_o
213: => ota_aci_shd.g_old_rec.aci_information17
214: ,p_aci_information18_o
215: => ota_aci_shd.g_old_rec.aci_information18

Line 213: => ota_aci_shd.g_old_rec.aci_information17

209: => ota_aci_shd.g_old_rec.aci_information15
210: ,p_aci_information16_o
211: => ota_aci_shd.g_old_rec.aci_information16
212: ,p_aci_information17_o
213: => ota_aci_shd.g_old_rec.aci_information17
214: ,p_aci_information18_o
215: => ota_aci_shd.g_old_rec.aci_information18
216: ,p_aci_information19_o
217: => ota_aci_shd.g_old_rec.aci_information19

Line 215: => ota_aci_shd.g_old_rec.aci_information18

211: => ota_aci_shd.g_old_rec.aci_information16
212: ,p_aci_information17_o
213: => ota_aci_shd.g_old_rec.aci_information17
214: ,p_aci_information18_o
215: => ota_aci_shd.g_old_rec.aci_information18
216: ,p_aci_information19_o
217: => ota_aci_shd.g_old_rec.aci_information19
218: ,p_aci_information20_o
219: => ota_aci_shd.g_old_rec.aci_information20

Line 217: => ota_aci_shd.g_old_rec.aci_information19

213: => ota_aci_shd.g_old_rec.aci_information17
214: ,p_aci_information18_o
215: => ota_aci_shd.g_old_rec.aci_information18
216: ,p_aci_information19_o
217: => ota_aci_shd.g_old_rec.aci_information19
218: ,p_aci_information20_o
219: => ota_aci_shd.g_old_rec.aci_information20
220: ,p_start_date_active_o
221: => ota_aci_shd.g_old_rec.start_date_active

Line 219: => ota_aci_shd.g_old_rec.aci_information20

215: => ota_aci_shd.g_old_rec.aci_information18
216: ,p_aci_information19_o
217: => ota_aci_shd.g_old_rec.aci_information19
218: ,p_aci_information20_o
219: => ota_aci_shd.g_old_rec.aci_information20
220: ,p_start_date_active_o
221: => ota_aci_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_aci_shd.g_old_rec.end_date_active

Line 221: => ota_aci_shd.g_old_rec.start_date_active

217: => ota_aci_shd.g_old_rec.aci_information19
218: ,p_aci_information20_o
219: => ota_aci_shd.g_old_rec.aci_information20
220: ,p_start_date_active_o
221: => ota_aci_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_aci_shd.g_old_rec.end_date_active
224: ,p_primary_flag_o
225: => ota_aci_shd.g_old_rec.primary_flag

Line 223: => ota_aci_shd.g_old_rec.end_date_active

219: => ota_aci_shd.g_old_rec.aci_information20
220: ,p_start_date_active_o
221: => ota_aci_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_aci_shd.g_old_rec.end_date_active
224: ,p_primary_flag_o
225: => ota_aci_shd.g_old_rec.primary_flag
226: );
227: --

Line 225: => ota_aci_shd.g_old_rec.primary_flag

221: => ota_aci_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_aci_shd.g_old_rec.end_date_active
224: ,p_primary_flag_o
225: => ota_aci_shd.g_old_rec.primary_flag
226: );
227: --
228: exception
229: --

Line 245: (p_rec in ota_aci_shd.g_rec_type

241: -- ----------------------------------------------------------------------------
242: -- |---------------------------------< del >----------------------------------|
243: -- ----------------------------------------------------------------------------
244: Procedure del
245: (p_rec in ota_aci_shd.g_rec_type
246: ) is
247: --
248: l_proc varchar2(72) := g_package||'del';
249: --

Line 255: ota_aci_shd.lck

251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- We must lock the row which we need to delete.
254: --
255: ota_aci_shd.lck
256: (p_rec.activity_version_id
257: ,p_rec.category_usage_id
258: ,p_rec.object_version_number
259: );

Line 294: l_rec ota_aci_shd.g_rec_type;

290: ,p_category_usage_id in number
291: ,p_object_version_number in number
292: ) is
293: --
294: l_rec ota_aci_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);