APPS.OTA_OCL_DEL dependencies on OTA_OCL_SHD

Line 52: (p_rec in ota_ocl_shd.g_rec_type

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

Line 75: ota_ocl_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_ocl_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ota_ocl_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in ota_ocl_shd.g_rec_type) is

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

Line 168: => ota_ocl_shd.g_old_rec.competence_id

164: ota_ocl_rkd.after_delete
165: (p_competence_language_id
166: => p_rec.competence_language_id
167: ,p_competence_id_o
168: => ota_ocl_shd.g_old_rec.competence_id
169: ,p_language_code_o
170: => ota_ocl_shd.g_old_rec.language_code
171: ,p_min_proficiency_level_id_o
172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id

Line 170: => ota_ocl_shd.g_old_rec.language_code

166: => p_rec.competence_language_id
167: ,p_competence_id_o
168: => ota_ocl_shd.g_old_rec.competence_id
169: ,p_language_code_o
170: => ota_ocl_shd.g_old_rec.language_code
171: ,p_min_proficiency_level_id_o
172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
173: ,p_business_group_id_o
174: => ota_ocl_shd.g_old_rec.business_group_id

Line 172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id

168: => ota_ocl_shd.g_old_rec.competence_id
169: ,p_language_code_o
170: => ota_ocl_shd.g_old_rec.language_code
171: ,p_min_proficiency_level_id_o
172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
173: ,p_business_group_id_o
174: => ota_ocl_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o
176: => ota_ocl_shd.g_old_rec.object_version_number

Line 174: => ota_ocl_shd.g_old_rec.business_group_id

170: => ota_ocl_shd.g_old_rec.language_code
171: ,p_min_proficiency_level_id_o
172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
173: ,p_business_group_id_o
174: => ota_ocl_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o
176: => ota_ocl_shd.g_old_rec.object_version_number
177: ,p_ocl_information_category_o
178: => ota_ocl_shd.g_old_rec.ocl_information_category

Line 176: => ota_ocl_shd.g_old_rec.object_version_number

172: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
173: ,p_business_group_id_o
174: => ota_ocl_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o
176: => ota_ocl_shd.g_old_rec.object_version_number
177: ,p_ocl_information_category_o
178: => ota_ocl_shd.g_old_rec.ocl_information_category
179: ,p_ocl_information1_o
180: => ota_ocl_shd.g_old_rec.ocl_information1

Line 178: => ota_ocl_shd.g_old_rec.ocl_information_category

174: => ota_ocl_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o
176: => ota_ocl_shd.g_old_rec.object_version_number
177: ,p_ocl_information_category_o
178: => ota_ocl_shd.g_old_rec.ocl_information_category
179: ,p_ocl_information1_o
180: => ota_ocl_shd.g_old_rec.ocl_information1
181: ,p_ocl_information2_o
182: => ota_ocl_shd.g_old_rec.ocl_information2

Line 180: => ota_ocl_shd.g_old_rec.ocl_information1

176: => ota_ocl_shd.g_old_rec.object_version_number
177: ,p_ocl_information_category_o
178: => ota_ocl_shd.g_old_rec.ocl_information_category
179: ,p_ocl_information1_o
180: => ota_ocl_shd.g_old_rec.ocl_information1
181: ,p_ocl_information2_o
182: => ota_ocl_shd.g_old_rec.ocl_information2
183: ,p_ocl_information3_o
184: => ota_ocl_shd.g_old_rec.ocl_information3

Line 182: => ota_ocl_shd.g_old_rec.ocl_information2

178: => ota_ocl_shd.g_old_rec.ocl_information_category
179: ,p_ocl_information1_o
180: => ota_ocl_shd.g_old_rec.ocl_information1
181: ,p_ocl_information2_o
182: => ota_ocl_shd.g_old_rec.ocl_information2
183: ,p_ocl_information3_o
184: => ota_ocl_shd.g_old_rec.ocl_information3
185: ,p_ocl_information4_o
186: => ota_ocl_shd.g_old_rec.ocl_information4

Line 184: => ota_ocl_shd.g_old_rec.ocl_information3

180: => ota_ocl_shd.g_old_rec.ocl_information1
181: ,p_ocl_information2_o
182: => ota_ocl_shd.g_old_rec.ocl_information2
183: ,p_ocl_information3_o
184: => ota_ocl_shd.g_old_rec.ocl_information3
185: ,p_ocl_information4_o
186: => ota_ocl_shd.g_old_rec.ocl_information4
187: ,p_ocl_information5_o
188: => ota_ocl_shd.g_old_rec.ocl_information5

Line 186: => ota_ocl_shd.g_old_rec.ocl_information4

182: => ota_ocl_shd.g_old_rec.ocl_information2
183: ,p_ocl_information3_o
184: => ota_ocl_shd.g_old_rec.ocl_information3
185: ,p_ocl_information4_o
186: => ota_ocl_shd.g_old_rec.ocl_information4
187: ,p_ocl_information5_o
188: => ota_ocl_shd.g_old_rec.ocl_information5
189: ,p_ocl_information6_o
190: => ota_ocl_shd.g_old_rec.ocl_information6

Line 188: => ota_ocl_shd.g_old_rec.ocl_information5

184: => ota_ocl_shd.g_old_rec.ocl_information3
185: ,p_ocl_information4_o
186: => ota_ocl_shd.g_old_rec.ocl_information4
187: ,p_ocl_information5_o
188: => ota_ocl_shd.g_old_rec.ocl_information5
189: ,p_ocl_information6_o
190: => ota_ocl_shd.g_old_rec.ocl_information6
191: ,p_ocl_information7_o
192: => ota_ocl_shd.g_old_rec.ocl_information7

Line 190: => ota_ocl_shd.g_old_rec.ocl_information6

186: => ota_ocl_shd.g_old_rec.ocl_information4
187: ,p_ocl_information5_o
188: => ota_ocl_shd.g_old_rec.ocl_information5
189: ,p_ocl_information6_o
190: => ota_ocl_shd.g_old_rec.ocl_information6
191: ,p_ocl_information7_o
192: => ota_ocl_shd.g_old_rec.ocl_information7
193: ,p_ocl_information8_o
194: => ota_ocl_shd.g_old_rec.ocl_information8

Line 192: => ota_ocl_shd.g_old_rec.ocl_information7

188: => ota_ocl_shd.g_old_rec.ocl_information5
189: ,p_ocl_information6_o
190: => ota_ocl_shd.g_old_rec.ocl_information6
191: ,p_ocl_information7_o
192: => ota_ocl_shd.g_old_rec.ocl_information7
193: ,p_ocl_information8_o
194: => ota_ocl_shd.g_old_rec.ocl_information8
195: ,p_ocl_information9_o
196: => ota_ocl_shd.g_old_rec.ocl_information9

Line 194: => ota_ocl_shd.g_old_rec.ocl_information8

190: => ota_ocl_shd.g_old_rec.ocl_information6
191: ,p_ocl_information7_o
192: => ota_ocl_shd.g_old_rec.ocl_information7
193: ,p_ocl_information8_o
194: => ota_ocl_shd.g_old_rec.ocl_information8
195: ,p_ocl_information9_o
196: => ota_ocl_shd.g_old_rec.ocl_information9
197: ,p_ocl_information10_o
198: => ota_ocl_shd.g_old_rec.ocl_information10

Line 196: => ota_ocl_shd.g_old_rec.ocl_information9

192: => ota_ocl_shd.g_old_rec.ocl_information7
193: ,p_ocl_information8_o
194: => ota_ocl_shd.g_old_rec.ocl_information8
195: ,p_ocl_information9_o
196: => ota_ocl_shd.g_old_rec.ocl_information9
197: ,p_ocl_information10_o
198: => ota_ocl_shd.g_old_rec.ocl_information10
199: ,p_ocl_information11_o
200: => ota_ocl_shd.g_old_rec.ocl_information11

Line 198: => ota_ocl_shd.g_old_rec.ocl_information10

194: => ota_ocl_shd.g_old_rec.ocl_information8
195: ,p_ocl_information9_o
196: => ota_ocl_shd.g_old_rec.ocl_information9
197: ,p_ocl_information10_o
198: => ota_ocl_shd.g_old_rec.ocl_information10
199: ,p_ocl_information11_o
200: => ota_ocl_shd.g_old_rec.ocl_information11
201: ,p_ocl_information12_o
202: => ota_ocl_shd.g_old_rec.ocl_information12

Line 200: => ota_ocl_shd.g_old_rec.ocl_information11

196: => ota_ocl_shd.g_old_rec.ocl_information9
197: ,p_ocl_information10_o
198: => ota_ocl_shd.g_old_rec.ocl_information10
199: ,p_ocl_information11_o
200: => ota_ocl_shd.g_old_rec.ocl_information11
201: ,p_ocl_information12_o
202: => ota_ocl_shd.g_old_rec.ocl_information12
203: ,p_ocl_information13_o
204: => ota_ocl_shd.g_old_rec.ocl_information13

Line 202: => ota_ocl_shd.g_old_rec.ocl_information12

198: => ota_ocl_shd.g_old_rec.ocl_information10
199: ,p_ocl_information11_o
200: => ota_ocl_shd.g_old_rec.ocl_information11
201: ,p_ocl_information12_o
202: => ota_ocl_shd.g_old_rec.ocl_information12
203: ,p_ocl_information13_o
204: => ota_ocl_shd.g_old_rec.ocl_information13
205: ,p_ocl_information14_o
206: => ota_ocl_shd.g_old_rec.ocl_information14

Line 204: => ota_ocl_shd.g_old_rec.ocl_information13

200: => ota_ocl_shd.g_old_rec.ocl_information11
201: ,p_ocl_information12_o
202: => ota_ocl_shd.g_old_rec.ocl_information12
203: ,p_ocl_information13_o
204: => ota_ocl_shd.g_old_rec.ocl_information13
205: ,p_ocl_information14_o
206: => ota_ocl_shd.g_old_rec.ocl_information14
207: ,p_ocl_information15_o
208: => ota_ocl_shd.g_old_rec.ocl_information15

Line 206: => ota_ocl_shd.g_old_rec.ocl_information14

202: => ota_ocl_shd.g_old_rec.ocl_information12
203: ,p_ocl_information13_o
204: => ota_ocl_shd.g_old_rec.ocl_information13
205: ,p_ocl_information14_o
206: => ota_ocl_shd.g_old_rec.ocl_information14
207: ,p_ocl_information15_o
208: => ota_ocl_shd.g_old_rec.ocl_information15
209: ,p_ocl_information16_o
210: => ota_ocl_shd.g_old_rec.ocl_information16

Line 208: => ota_ocl_shd.g_old_rec.ocl_information15

204: => ota_ocl_shd.g_old_rec.ocl_information13
205: ,p_ocl_information14_o
206: => ota_ocl_shd.g_old_rec.ocl_information14
207: ,p_ocl_information15_o
208: => ota_ocl_shd.g_old_rec.ocl_information15
209: ,p_ocl_information16_o
210: => ota_ocl_shd.g_old_rec.ocl_information16
211: ,p_ocl_information17_o
212: => ota_ocl_shd.g_old_rec.ocl_information17

Line 210: => ota_ocl_shd.g_old_rec.ocl_information16

206: => ota_ocl_shd.g_old_rec.ocl_information14
207: ,p_ocl_information15_o
208: => ota_ocl_shd.g_old_rec.ocl_information15
209: ,p_ocl_information16_o
210: => ota_ocl_shd.g_old_rec.ocl_information16
211: ,p_ocl_information17_o
212: => ota_ocl_shd.g_old_rec.ocl_information17
213: ,p_ocl_information18_o
214: => ota_ocl_shd.g_old_rec.ocl_information18

Line 212: => ota_ocl_shd.g_old_rec.ocl_information17

208: => ota_ocl_shd.g_old_rec.ocl_information15
209: ,p_ocl_information16_o
210: => ota_ocl_shd.g_old_rec.ocl_information16
211: ,p_ocl_information17_o
212: => ota_ocl_shd.g_old_rec.ocl_information17
213: ,p_ocl_information18_o
214: => ota_ocl_shd.g_old_rec.ocl_information18
215: ,p_ocl_information19_o
216: => ota_ocl_shd.g_old_rec.ocl_information19

Line 214: => ota_ocl_shd.g_old_rec.ocl_information18

210: => ota_ocl_shd.g_old_rec.ocl_information16
211: ,p_ocl_information17_o
212: => ota_ocl_shd.g_old_rec.ocl_information17
213: ,p_ocl_information18_o
214: => ota_ocl_shd.g_old_rec.ocl_information18
215: ,p_ocl_information19_o
216: => ota_ocl_shd.g_old_rec.ocl_information19
217: ,p_ocl_information20_o
218: => ota_ocl_shd.g_old_rec.ocl_information20

Line 216: => ota_ocl_shd.g_old_rec.ocl_information19

212: => ota_ocl_shd.g_old_rec.ocl_information17
213: ,p_ocl_information18_o
214: => ota_ocl_shd.g_old_rec.ocl_information18
215: ,p_ocl_information19_o
216: => ota_ocl_shd.g_old_rec.ocl_information19
217: ,p_ocl_information20_o
218: => ota_ocl_shd.g_old_rec.ocl_information20
219: );
220: --

Line 218: => ota_ocl_shd.g_old_rec.ocl_information20

214: => ota_ocl_shd.g_old_rec.ocl_information18
215: ,p_ocl_information19_o
216: => ota_ocl_shd.g_old_rec.ocl_information19
217: ,p_ocl_information20_o
218: => ota_ocl_shd.g_old_rec.ocl_information20
219: );
220: --
221: exception
222: --

Line 238: (p_rec in ota_ocl_shd.g_rec_type,

234: -- ----------------------------------------------------------------------------
235: -- |---------------------------------< del >----------------------------------|
236: -- ----------------------------------------------------------------------------
237: Procedure del
238: (p_rec in ota_ocl_shd.g_rec_type,
239: p_validate in boolean default false
240:
241: ) is
242: --

Line 258: ota_ocl_shd.lck

254:
255: --
256: -- We must lock the row which we need to delete.
257: --
258: ota_ocl_shd.lck
259: (p_rec.competence_language_id
260: ,p_rec.object_version_number
261: );
262: --

Line 304: l_rec ota_ocl_shd.g_rec_type;

300: ,p_validate in boolean default false
301:
302: ) is
303: --
304: l_rec ota_ocl_shd.g_rec_type;
305: l_proc varchar2(72) := g_package||'del';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);