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_OCL_UPD dependencies on OTA_OCL_SHD

Line 55: (p_rec in out nocopy ota_ocl_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_ocl_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 109: ota_ocl_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: ota_ocl_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --

Line 114: ota_ocl_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: ota_ocl_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: ota_ocl_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_ocl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 159: (p_rec in ota_ocl_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure pre_update
159: (p_rec in ota_ocl_shd.g_rec_type
160: ) is
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --

Line 204: ,p_rec in ota_ocl_shd.g_rec_type

200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_update
203: (p_effective_date in date
204: ,p_rec in ota_ocl_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --

Line 270: => ota_ocl_shd.g_old_rec.competence_id

266: => p_rec.ocl_information19
267: ,p_ocl_information20
268: => p_rec.ocl_information20
269: ,p_competence_id_o
270: => ota_ocl_shd.g_old_rec.competence_id
271: ,p_language_code_o
272: => ota_ocl_shd.g_old_rec.language_code
273: ,p_min_proficiency_level_id_o
274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id

Line 272: => ota_ocl_shd.g_old_rec.language_code

268: => p_rec.ocl_information20
269: ,p_competence_id_o
270: => ota_ocl_shd.g_old_rec.competence_id
271: ,p_language_code_o
272: => ota_ocl_shd.g_old_rec.language_code
273: ,p_min_proficiency_level_id_o
274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
275: ,p_business_group_id_o
276: => ota_ocl_shd.g_old_rec.business_group_id

Line 274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id

270: => ota_ocl_shd.g_old_rec.competence_id
271: ,p_language_code_o
272: => ota_ocl_shd.g_old_rec.language_code
273: ,p_min_proficiency_level_id_o
274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
275: ,p_business_group_id_o
276: => ota_ocl_shd.g_old_rec.business_group_id
277: ,p_object_version_number_o
278: => ota_ocl_shd.g_old_rec.object_version_number

Line 276: => ota_ocl_shd.g_old_rec.business_group_id

272: => ota_ocl_shd.g_old_rec.language_code
273: ,p_min_proficiency_level_id_o
274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
275: ,p_business_group_id_o
276: => ota_ocl_shd.g_old_rec.business_group_id
277: ,p_object_version_number_o
278: => ota_ocl_shd.g_old_rec.object_version_number
279: ,p_ocl_information_category_o
280: => ota_ocl_shd.g_old_rec.ocl_information_category

Line 278: => ota_ocl_shd.g_old_rec.object_version_number

274: => ota_ocl_shd.g_old_rec.min_proficiency_level_id
275: ,p_business_group_id_o
276: => ota_ocl_shd.g_old_rec.business_group_id
277: ,p_object_version_number_o
278: => ota_ocl_shd.g_old_rec.object_version_number
279: ,p_ocl_information_category_o
280: => ota_ocl_shd.g_old_rec.ocl_information_category
281: ,p_ocl_information1_o
282: => ota_ocl_shd.g_old_rec.ocl_information1

Line 280: => ota_ocl_shd.g_old_rec.ocl_information_category

276: => ota_ocl_shd.g_old_rec.business_group_id
277: ,p_object_version_number_o
278: => ota_ocl_shd.g_old_rec.object_version_number
279: ,p_ocl_information_category_o
280: => ota_ocl_shd.g_old_rec.ocl_information_category
281: ,p_ocl_information1_o
282: => ota_ocl_shd.g_old_rec.ocl_information1
283: ,p_ocl_information2_o
284: => ota_ocl_shd.g_old_rec.ocl_information2

Line 282: => ota_ocl_shd.g_old_rec.ocl_information1

278: => ota_ocl_shd.g_old_rec.object_version_number
279: ,p_ocl_information_category_o
280: => ota_ocl_shd.g_old_rec.ocl_information_category
281: ,p_ocl_information1_o
282: => ota_ocl_shd.g_old_rec.ocl_information1
283: ,p_ocl_information2_o
284: => ota_ocl_shd.g_old_rec.ocl_information2
285: ,p_ocl_information3_o
286: => ota_ocl_shd.g_old_rec.ocl_information3

Line 284: => ota_ocl_shd.g_old_rec.ocl_information2

280: => ota_ocl_shd.g_old_rec.ocl_information_category
281: ,p_ocl_information1_o
282: => ota_ocl_shd.g_old_rec.ocl_information1
283: ,p_ocl_information2_o
284: => ota_ocl_shd.g_old_rec.ocl_information2
285: ,p_ocl_information3_o
286: => ota_ocl_shd.g_old_rec.ocl_information3
287: ,p_ocl_information4_o
288: => ota_ocl_shd.g_old_rec.ocl_information4

Line 286: => ota_ocl_shd.g_old_rec.ocl_information3

282: => ota_ocl_shd.g_old_rec.ocl_information1
283: ,p_ocl_information2_o
284: => ota_ocl_shd.g_old_rec.ocl_information2
285: ,p_ocl_information3_o
286: => ota_ocl_shd.g_old_rec.ocl_information3
287: ,p_ocl_information4_o
288: => ota_ocl_shd.g_old_rec.ocl_information4
289: ,p_ocl_information5_o
290: => ota_ocl_shd.g_old_rec.ocl_information5

Line 288: => ota_ocl_shd.g_old_rec.ocl_information4

284: => ota_ocl_shd.g_old_rec.ocl_information2
285: ,p_ocl_information3_o
286: => ota_ocl_shd.g_old_rec.ocl_information3
287: ,p_ocl_information4_o
288: => ota_ocl_shd.g_old_rec.ocl_information4
289: ,p_ocl_information5_o
290: => ota_ocl_shd.g_old_rec.ocl_information5
291: ,p_ocl_information6_o
292: => ota_ocl_shd.g_old_rec.ocl_information6

Line 290: => ota_ocl_shd.g_old_rec.ocl_information5

286: => ota_ocl_shd.g_old_rec.ocl_information3
287: ,p_ocl_information4_o
288: => ota_ocl_shd.g_old_rec.ocl_information4
289: ,p_ocl_information5_o
290: => ota_ocl_shd.g_old_rec.ocl_information5
291: ,p_ocl_information6_o
292: => ota_ocl_shd.g_old_rec.ocl_information6
293: ,p_ocl_information7_o
294: => ota_ocl_shd.g_old_rec.ocl_information7

Line 292: => ota_ocl_shd.g_old_rec.ocl_information6

288: => ota_ocl_shd.g_old_rec.ocl_information4
289: ,p_ocl_information5_o
290: => ota_ocl_shd.g_old_rec.ocl_information5
291: ,p_ocl_information6_o
292: => ota_ocl_shd.g_old_rec.ocl_information6
293: ,p_ocl_information7_o
294: => ota_ocl_shd.g_old_rec.ocl_information7
295: ,p_ocl_information8_o
296: => ota_ocl_shd.g_old_rec.ocl_information8

Line 294: => ota_ocl_shd.g_old_rec.ocl_information7

290: => ota_ocl_shd.g_old_rec.ocl_information5
291: ,p_ocl_information6_o
292: => ota_ocl_shd.g_old_rec.ocl_information6
293: ,p_ocl_information7_o
294: => ota_ocl_shd.g_old_rec.ocl_information7
295: ,p_ocl_information8_o
296: => ota_ocl_shd.g_old_rec.ocl_information8
297: ,p_ocl_information9_o
298: => ota_ocl_shd.g_old_rec.ocl_information9

Line 296: => ota_ocl_shd.g_old_rec.ocl_information8

292: => ota_ocl_shd.g_old_rec.ocl_information6
293: ,p_ocl_information7_o
294: => ota_ocl_shd.g_old_rec.ocl_information7
295: ,p_ocl_information8_o
296: => ota_ocl_shd.g_old_rec.ocl_information8
297: ,p_ocl_information9_o
298: => ota_ocl_shd.g_old_rec.ocl_information9
299: ,p_ocl_information10_o
300: => ota_ocl_shd.g_old_rec.ocl_information10

Line 298: => ota_ocl_shd.g_old_rec.ocl_information9

294: => ota_ocl_shd.g_old_rec.ocl_information7
295: ,p_ocl_information8_o
296: => ota_ocl_shd.g_old_rec.ocl_information8
297: ,p_ocl_information9_o
298: => ota_ocl_shd.g_old_rec.ocl_information9
299: ,p_ocl_information10_o
300: => ota_ocl_shd.g_old_rec.ocl_information10
301: ,p_ocl_information11_o
302: => ota_ocl_shd.g_old_rec.ocl_information11

Line 300: => ota_ocl_shd.g_old_rec.ocl_information10

296: => ota_ocl_shd.g_old_rec.ocl_information8
297: ,p_ocl_information9_o
298: => ota_ocl_shd.g_old_rec.ocl_information9
299: ,p_ocl_information10_o
300: => ota_ocl_shd.g_old_rec.ocl_information10
301: ,p_ocl_information11_o
302: => ota_ocl_shd.g_old_rec.ocl_information11
303: ,p_ocl_information12_o
304: => ota_ocl_shd.g_old_rec.ocl_information12

Line 302: => ota_ocl_shd.g_old_rec.ocl_information11

298: => ota_ocl_shd.g_old_rec.ocl_information9
299: ,p_ocl_information10_o
300: => ota_ocl_shd.g_old_rec.ocl_information10
301: ,p_ocl_information11_o
302: => ota_ocl_shd.g_old_rec.ocl_information11
303: ,p_ocl_information12_o
304: => ota_ocl_shd.g_old_rec.ocl_information12
305: ,p_ocl_information13_o
306: => ota_ocl_shd.g_old_rec.ocl_information13

Line 304: => ota_ocl_shd.g_old_rec.ocl_information12

300: => ota_ocl_shd.g_old_rec.ocl_information10
301: ,p_ocl_information11_o
302: => ota_ocl_shd.g_old_rec.ocl_information11
303: ,p_ocl_information12_o
304: => ota_ocl_shd.g_old_rec.ocl_information12
305: ,p_ocl_information13_o
306: => ota_ocl_shd.g_old_rec.ocl_information13
307: ,p_ocl_information14_o
308: => ota_ocl_shd.g_old_rec.ocl_information14

Line 306: => ota_ocl_shd.g_old_rec.ocl_information13

302: => ota_ocl_shd.g_old_rec.ocl_information11
303: ,p_ocl_information12_o
304: => ota_ocl_shd.g_old_rec.ocl_information12
305: ,p_ocl_information13_o
306: => ota_ocl_shd.g_old_rec.ocl_information13
307: ,p_ocl_information14_o
308: => ota_ocl_shd.g_old_rec.ocl_information14
309: ,p_ocl_information15_o
310: => ota_ocl_shd.g_old_rec.ocl_information15

Line 308: => ota_ocl_shd.g_old_rec.ocl_information14

304: => ota_ocl_shd.g_old_rec.ocl_information12
305: ,p_ocl_information13_o
306: => ota_ocl_shd.g_old_rec.ocl_information13
307: ,p_ocl_information14_o
308: => ota_ocl_shd.g_old_rec.ocl_information14
309: ,p_ocl_information15_o
310: => ota_ocl_shd.g_old_rec.ocl_information15
311: ,p_ocl_information16_o
312: => ota_ocl_shd.g_old_rec.ocl_information16

Line 310: => ota_ocl_shd.g_old_rec.ocl_information15

306: => ota_ocl_shd.g_old_rec.ocl_information13
307: ,p_ocl_information14_o
308: => ota_ocl_shd.g_old_rec.ocl_information14
309: ,p_ocl_information15_o
310: => ota_ocl_shd.g_old_rec.ocl_information15
311: ,p_ocl_information16_o
312: => ota_ocl_shd.g_old_rec.ocl_information16
313: ,p_ocl_information17_o
314: => ota_ocl_shd.g_old_rec.ocl_information17

Line 312: => ota_ocl_shd.g_old_rec.ocl_information16

308: => ota_ocl_shd.g_old_rec.ocl_information14
309: ,p_ocl_information15_o
310: => ota_ocl_shd.g_old_rec.ocl_information15
311: ,p_ocl_information16_o
312: => ota_ocl_shd.g_old_rec.ocl_information16
313: ,p_ocl_information17_o
314: => ota_ocl_shd.g_old_rec.ocl_information17
315: ,p_ocl_information18_o
316: => ota_ocl_shd.g_old_rec.ocl_information18

Line 314: => ota_ocl_shd.g_old_rec.ocl_information17

310: => ota_ocl_shd.g_old_rec.ocl_information15
311: ,p_ocl_information16_o
312: => ota_ocl_shd.g_old_rec.ocl_information16
313: ,p_ocl_information17_o
314: => ota_ocl_shd.g_old_rec.ocl_information17
315: ,p_ocl_information18_o
316: => ota_ocl_shd.g_old_rec.ocl_information18
317: ,p_ocl_information19_o
318: => ota_ocl_shd.g_old_rec.ocl_information19

Line 316: => ota_ocl_shd.g_old_rec.ocl_information18

312: => ota_ocl_shd.g_old_rec.ocl_information16
313: ,p_ocl_information17_o
314: => ota_ocl_shd.g_old_rec.ocl_information17
315: ,p_ocl_information18_o
316: => ota_ocl_shd.g_old_rec.ocl_information18
317: ,p_ocl_information19_o
318: => ota_ocl_shd.g_old_rec.ocl_information19
319: ,p_ocl_information20_o
320: => ota_ocl_shd.g_old_rec.ocl_information20

Line 318: => ota_ocl_shd.g_old_rec.ocl_information19

314: => ota_ocl_shd.g_old_rec.ocl_information17
315: ,p_ocl_information18_o
316: => ota_ocl_shd.g_old_rec.ocl_information18
317: ,p_ocl_information19_o
318: => ota_ocl_shd.g_old_rec.ocl_information19
319: ,p_ocl_information20_o
320: => ota_ocl_shd.g_old_rec.ocl_information20
321: );
322: --

Line 320: => ota_ocl_shd.g_old_rec.ocl_information20

316: => ota_ocl_shd.g_old_rec.ocl_information18
317: ,p_ocl_information19_o
318: => ota_ocl_shd.g_old_rec.ocl_information19
319: ,p_ocl_information20_o
320: => ota_ocl_shd.g_old_rec.ocl_information20
321: );
322: --
323: exception
324: --

Line 380: (p_rec in out nocopy ota_ocl_shd.g_rec_type

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure convert_defs
380: (p_rec in out nocopy ota_ocl_shd.g_rec_type
381: ) is
382: --
383: Begin
384: --

Line 392: ota_ocl_shd.g_old_rec.competence_id;

388: -- is being used then we must set to the 'current' argument value.
389: --
390: If (p_rec.competence_id = hr_api.g_number) then
391: p_rec.competence_id :=
392: ota_ocl_shd.g_old_rec.competence_id;
393: End If;
394: If (p_rec.language_code = hr_api.g_varchar2) then
395: p_rec.language_code :=
396: ota_ocl_shd.g_old_rec.language_code;

Line 396: ota_ocl_shd.g_old_rec.language_code;

392: ota_ocl_shd.g_old_rec.competence_id;
393: End If;
394: If (p_rec.language_code = hr_api.g_varchar2) then
395: p_rec.language_code :=
396: ota_ocl_shd.g_old_rec.language_code;
397: End If;
398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then
399: p_rec.min_proficiency_level_id :=
400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;

Line 400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;

396: ota_ocl_shd.g_old_rec.language_code;
397: End If;
398: If (p_rec.min_proficiency_level_id = hr_api.g_number) then
399: p_rec.min_proficiency_level_id :=
400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: ota_ocl_shd.g_old_rec.business_group_id;

Line 404: ota_ocl_shd.g_old_rec.business_group_id;

400: ota_ocl_shd.g_old_rec.min_proficiency_level_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: ota_ocl_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.ocl_information_category = hr_api.g_varchar2) then
407: p_rec.ocl_information_category :=
408: ota_ocl_shd.g_old_rec.ocl_information_category;

Line 408: ota_ocl_shd.g_old_rec.ocl_information_category;

404: ota_ocl_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.ocl_information_category = hr_api.g_varchar2) then
407: p_rec.ocl_information_category :=
408: ota_ocl_shd.g_old_rec.ocl_information_category;
409: End If;
410: If (p_rec.ocl_information1 = hr_api.g_varchar2) then
411: p_rec.ocl_information1 :=
412: ota_ocl_shd.g_old_rec.ocl_information1;

Line 412: ota_ocl_shd.g_old_rec.ocl_information1;

408: ota_ocl_shd.g_old_rec.ocl_information_category;
409: End If;
410: If (p_rec.ocl_information1 = hr_api.g_varchar2) then
411: p_rec.ocl_information1 :=
412: ota_ocl_shd.g_old_rec.ocl_information1;
413: End If;
414: If (p_rec.ocl_information2 = hr_api.g_varchar2) then
415: p_rec.ocl_information2 :=
416: ota_ocl_shd.g_old_rec.ocl_information2;

Line 416: ota_ocl_shd.g_old_rec.ocl_information2;

412: ota_ocl_shd.g_old_rec.ocl_information1;
413: End If;
414: If (p_rec.ocl_information2 = hr_api.g_varchar2) then
415: p_rec.ocl_information2 :=
416: ota_ocl_shd.g_old_rec.ocl_information2;
417: End If;
418: If (p_rec.ocl_information3 = hr_api.g_varchar2) then
419: p_rec.ocl_information3 :=
420: ota_ocl_shd.g_old_rec.ocl_information3;

Line 420: ota_ocl_shd.g_old_rec.ocl_information3;

416: ota_ocl_shd.g_old_rec.ocl_information2;
417: End If;
418: If (p_rec.ocl_information3 = hr_api.g_varchar2) then
419: p_rec.ocl_information3 :=
420: ota_ocl_shd.g_old_rec.ocl_information3;
421: End If;
422: If (p_rec.ocl_information4 = hr_api.g_varchar2) then
423: p_rec.ocl_information4 :=
424: ota_ocl_shd.g_old_rec.ocl_information4;

Line 424: ota_ocl_shd.g_old_rec.ocl_information4;

420: ota_ocl_shd.g_old_rec.ocl_information3;
421: End If;
422: If (p_rec.ocl_information4 = hr_api.g_varchar2) then
423: p_rec.ocl_information4 :=
424: ota_ocl_shd.g_old_rec.ocl_information4;
425: End If;
426: If (p_rec.ocl_information5 = hr_api.g_varchar2) then
427: p_rec.ocl_information5 :=
428: ota_ocl_shd.g_old_rec.ocl_information5;

Line 428: ota_ocl_shd.g_old_rec.ocl_information5;

424: ota_ocl_shd.g_old_rec.ocl_information4;
425: End If;
426: If (p_rec.ocl_information5 = hr_api.g_varchar2) then
427: p_rec.ocl_information5 :=
428: ota_ocl_shd.g_old_rec.ocl_information5;
429: End If;
430: If (p_rec.ocl_information6 = hr_api.g_varchar2) then
431: p_rec.ocl_information6 :=
432: ota_ocl_shd.g_old_rec.ocl_information6;

Line 432: ota_ocl_shd.g_old_rec.ocl_information6;

428: ota_ocl_shd.g_old_rec.ocl_information5;
429: End If;
430: If (p_rec.ocl_information6 = hr_api.g_varchar2) then
431: p_rec.ocl_information6 :=
432: ota_ocl_shd.g_old_rec.ocl_information6;
433: End If;
434: If (p_rec.ocl_information7 = hr_api.g_varchar2) then
435: p_rec.ocl_information7 :=
436: ota_ocl_shd.g_old_rec.ocl_information7;

Line 436: ota_ocl_shd.g_old_rec.ocl_information7;

432: ota_ocl_shd.g_old_rec.ocl_information6;
433: End If;
434: If (p_rec.ocl_information7 = hr_api.g_varchar2) then
435: p_rec.ocl_information7 :=
436: ota_ocl_shd.g_old_rec.ocl_information7;
437: End If;
438: If (p_rec.ocl_information8 = hr_api.g_varchar2) then
439: p_rec.ocl_information8 :=
440: ota_ocl_shd.g_old_rec.ocl_information8;

Line 440: ota_ocl_shd.g_old_rec.ocl_information8;

436: ota_ocl_shd.g_old_rec.ocl_information7;
437: End If;
438: If (p_rec.ocl_information8 = hr_api.g_varchar2) then
439: p_rec.ocl_information8 :=
440: ota_ocl_shd.g_old_rec.ocl_information8;
441: End If;
442: If (p_rec.ocl_information9 = hr_api.g_varchar2) then
443: p_rec.ocl_information9 :=
444: ota_ocl_shd.g_old_rec.ocl_information9;

Line 444: ota_ocl_shd.g_old_rec.ocl_information9;

440: ota_ocl_shd.g_old_rec.ocl_information8;
441: End If;
442: If (p_rec.ocl_information9 = hr_api.g_varchar2) then
443: p_rec.ocl_information9 :=
444: ota_ocl_shd.g_old_rec.ocl_information9;
445: End If;
446: If (p_rec.ocl_information10 = hr_api.g_varchar2) then
447: p_rec.ocl_information10 :=
448: ota_ocl_shd.g_old_rec.ocl_information10;

Line 448: ota_ocl_shd.g_old_rec.ocl_information10;

444: ota_ocl_shd.g_old_rec.ocl_information9;
445: End If;
446: If (p_rec.ocl_information10 = hr_api.g_varchar2) then
447: p_rec.ocl_information10 :=
448: ota_ocl_shd.g_old_rec.ocl_information10;
449: End If;
450: If (p_rec.ocl_information11 = hr_api.g_varchar2) then
451: p_rec.ocl_information11 :=
452: ota_ocl_shd.g_old_rec.ocl_information11;

Line 452: ota_ocl_shd.g_old_rec.ocl_information11;

448: ota_ocl_shd.g_old_rec.ocl_information10;
449: End If;
450: If (p_rec.ocl_information11 = hr_api.g_varchar2) then
451: p_rec.ocl_information11 :=
452: ota_ocl_shd.g_old_rec.ocl_information11;
453: End If;
454: If (p_rec.ocl_information12 = hr_api.g_varchar2) then
455: p_rec.ocl_information12 :=
456: ota_ocl_shd.g_old_rec.ocl_information12;

Line 456: ota_ocl_shd.g_old_rec.ocl_information12;

452: ota_ocl_shd.g_old_rec.ocl_information11;
453: End If;
454: If (p_rec.ocl_information12 = hr_api.g_varchar2) then
455: p_rec.ocl_information12 :=
456: ota_ocl_shd.g_old_rec.ocl_information12;
457: End If;
458: If (p_rec.ocl_information13 = hr_api.g_varchar2) then
459: p_rec.ocl_information13 :=
460: ota_ocl_shd.g_old_rec.ocl_information13;

Line 460: ota_ocl_shd.g_old_rec.ocl_information13;

456: ota_ocl_shd.g_old_rec.ocl_information12;
457: End If;
458: If (p_rec.ocl_information13 = hr_api.g_varchar2) then
459: p_rec.ocl_information13 :=
460: ota_ocl_shd.g_old_rec.ocl_information13;
461: End If;
462: If (p_rec.ocl_information14 = hr_api.g_varchar2) then
463: p_rec.ocl_information14 :=
464: ota_ocl_shd.g_old_rec.ocl_information14;

Line 464: ota_ocl_shd.g_old_rec.ocl_information14;

460: ota_ocl_shd.g_old_rec.ocl_information13;
461: End If;
462: If (p_rec.ocl_information14 = hr_api.g_varchar2) then
463: p_rec.ocl_information14 :=
464: ota_ocl_shd.g_old_rec.ocl_information14;
465: End If;
466: If (p_rec.ocl_information15 = hr_api.g_varchar2) then
467: p_rec.ocl_information15 :=
468: ota_ocl_shd.g_old_rec.ocl_information15;

Line 468: ota_ocl_shd.g_old_rec.ocl_information15;

464: ota_ocl_shd.g_old_rec.ocl_information14;
465: End If;
466: If (p_rec.ocl_information15 = hr_api.g_varchar2) then
467: p_rec.ocl_information15 :=
468: ota_ocl_shd.g_old_rec.ocl_information15;
469: End If;
470: If (p_rec.ocl_information16 = hr_api.g_varchar2) then
471: p_rec.ocl_information16 :=
472: ota_ocl_shd.g_old_rec.ocl_information16;

Line 472: ota_ocl_shd.g_old_rec.ocl_information16;

468: ota_ocl_shd.g_old_rec.ocl_information15;
469: End If;
470: If (p_rec.ocl_information16 = hr_api.g_varchar2) then
471: p_rec.ocl_information16 :=
472: ota_ocl_shd.g_old_rec.ocl_information16;
473: End If;
474: If (p_rec.ocl_information17 = hr_api.g_varchar2) then
475: p_rec.ocl_information17 :=
476: ota_ocl_shd.g_old_rec.ocl_information17;

Line 476: ota_ocl_shd.g_old_rec.ocl_information17;

472: ota_ocl_shd.g_old_rec.ocl_information16;
473: End If;
474: If (p_rec.ocl_information17 = hr_api.g_varchar2) then
475: p_rec.ocl_information17 :=
476: ota_ocl_shd.g_old_rec.ocl_information17;
477: End If;
478: If (p_rec.ocl_information18 = hr_api.g_varchar2) then
479: p_rec.ocl_information18 :=
480: ota_ocl_shd.g_old_rec.ocl_information18;

Line 480: ota_ocl_shd.g_old_rec.ocl_information18;

476: ota_ocl_shd.g_old_rec.ocl_information17;
477: End If;
478: If (p_rec.ocl_information18 = hr_api.g_varchar2) then
479: p_rec.ocl_information18 :=
480: ota_ocl_shd.g_old_rec.ocl_information18;
481: End If;
482: If (p_rec.ocl_information19 = hr_api.g_varchar2) then
483: p_rec.ocl_information19 :=
484: ota_ocl_shd.g_old_rec.ocl_information19;

Line 484: ota_ocl_shd.g_old_rec.ocl_information19;

480: ota_ocl_shd.g_old_rec.ocl_information18;
481: End If;
482: If (p_rec.ocl_information19 = hr_api.g_varchar2) then
483: p_rec.ocl_information19 :=
484: ota_ocl_shd.g_old_rec.ocl_information19;
485: End If;
486: If (p_rec.ocl_information20 = hr_api.g_varchar2) then
487: p_rec.ocl_information20 :=
488: ota_ocl_shd.g_old_rec.ocl_information20;

Line 488: ota_ocl_shd.g_old_rec.ocl_information20;

484: ota_ocl_shd.g_old_rec.ocl_information19;
485: End If;
486: If (p_rec.ocl_information20 = hr_api.g_varchar2) then
487: p_rec.ocl_information20 :=
488: ota_ocl_shd.g_old_rec.ocl_information20;
489: End If;
490: --
491: End convert_defs;
492: --

Line 498: ,p_rec in out nocopy ota_ocl_shd.g_rec_type

494: -- |---------------------------------< upd >----------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure upd
497: (p_effective_date in date
498: ,p_rec in out nocopy ota_ocl_shd.g_rec_type
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'upd';
502: --

Line 508: ota_ocl_shd.lck

504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- We must lock the row which we need to update.
507: --
508: ota_ocl_shd.lck
509: (p_rec.competence_language_id
510: ,p_rec.object_version_number
511: );
512: --

Line 575: l_rec ota_ocl_shd.g_rec_type;

571: ,p_ocl_information19 in varchar2 default hr_api.g_varchar2
572: ,p_ocl_information20 in varchar2 default hr_api.g_varchar2
573: ) is
574: --
575: l_rec ota_ocl_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'upd';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);

Line 585: ota_ocl_shd.convert_args

581: -- Call conversion function to turn arguments into the
582: -- l_rec structure.
583: --
584: l_rec :=
585: ota_ocl_shd.convert_args
586: (p_competence_language_id
587: ,p_competence_id
588: ,p_language_code
589: ,p_min_proficiency_level_id