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_LCI_UPD dependencies on OTA_LCI_SHD

Line 55: (p_rec in out nocopy ota_lci_shd.g_rec_type

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

Line 110: ota_lci_shd.constraint_error

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

Line 115: ota_lci_shd.constraint_error

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

Line 120: ota_lci_shd.constraint_error

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

Line 160: (p_rec in ota_lci_shd.g_rec_type

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

Line 205: ,p_rec in ota_lci_shd.g_rec_type

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

Line 271: => ota_lci_shd.g_old_rec.primary_flag

267: => p_rec.attribute19
268: ,p_attribute20
269: => p_rec.attribute20
270: ,p_primary_flag_o
271: => ota_lci_shd.g_old_rec.primary_flag
272: ,p_start_date_active_o
273: => ota_lci_shd.g_old_rec.start_date_active
274: ,p_end_date_active_o
275: => ota_lci_shd.g_old_rec.end_date_active

Line 273: => ota_lci_shd.g_old_rec.start_date_active

269: => p_rec.attribute20
270: ,p_primary_flag_o
271: => ota_lci_shd.g_old_rec.primary_flag
272: ,p_start_date_active_o
273: => ota_lci_shd.g_old_rec.start_date_active
274: ,p_end_date_active_o
275: => ota_lci_shd.g_old_rec.end_date_active
276: ,p_object_version_number_o
277: => ota_lci_shd.g_old_rec.object_version_number

Line 275: => ota_lci_shd.g_old_rec.end_date_active

271: => ota_lci_shd.g_old_rec.primary_flag
272: ,p_start_date_active_o
273: => ota_lci_shd.g_old_rec.start_date_active
274: ,p_end_date_active_o
275: => ota_lci_shd.g_old_rec.end_date_active
276: ,p_object_version_number_o
277: => ota_lci_shd.g_old_rec.object_version_number
278: ,p_attribute_category_o
279: => ota_lci_shd.g_old_rec.attribute_category

Line 277: => ota_lci_shd.g_old_rec.object_version_number

273: => ota_lci_shd.g_old_rec.start_date_active
274: ,p_end_date_active_o
275: => ota_lci_shd.g_old_rec.end_date_active
276: ,p_object_version_number_o
277: => ota_lci_shd.g_old_rec.object_version_number
278: ,p_attribute_category_o
279: => ota_lci_shd.g_old_rec.attribute_category
280: ,p_attribute1_o
281: => ota_lci_shd.g_old_rec.attribute1

Line 279: => ota_lci_shd.g_old_rec.attribute_category

275: => ota_lci_shd.g_old_rec.end_date_active
276: ,p_object_version_number_o
277: => ota_lci_shd.g_old_rec.object_version_number
278: ,p_attribute_category_o
279: => ota_lci_shd.g_old_rec.attribute_category
280: ,p_attribute1_o
281: => ota_lci_shd.g_old_rec.attribute1
282: ,p_attribute2_o
283: => ota_lci_shd.g_old_rec.attribute2

Line 281: => ota_lci_shd.g_old_rec.attribute1

277: => ota_lci_shd.g_old_rec.object_version_number
278: ,p_attribute_category_o
279: => ota_lci_shd.g_old_rec.attribute_category
280: ,p_attribute1_o
281: => ota_lci_shd.g_old_rec.attribute1
282: ,p_attribute2_o
283: => ota_lci_shd.g_old_rec.attribute2
284: ,p_attribute3_o
285: => ota_lci_shd.g_old_rec.attribute3

Line 283: => ota_lci_shd.g_old_rec.attribute2

279: => ota_lci_shd.g_old_rec.attribute_category
280: ,p_attribute1_o
281: => ota_lci_shd.g_old_rec.attribute1
282: ,p_attribute2_o
283: => ota_lci_shd.g_old_rec.attribute2
284: ,p_attribute3_o
285: => ota_lci_shd.g_old_rec.attribute3
286: ,p_attribute4_o
287: => ota_lci_shd.g_old_rec.attribute4

Line 285: => ota_lci_shd.g_old_rec.attribute3

281: => ota_lci_shd.g_old_rec.attribute1
282: ,p_attribute2_o
283: => ota_lci_shd.g_old_rec.attribute2
284: ,p_attribute3_o
285: => ota_lci_shd.g_old_rec.attribute3
286: ,p_attribute4_o
287: => ota_lci_shd.g_old_rec.attribute4
288: ,p_attribute5_o
289: => ota_lci_shd.g_old_rec.attribute5

Line 287: => ota_lci_shd.g_old_rec.attribute4

283: => ota_lci_shd.g_old_rec.attribute2
284: ,p_attribute3_o
285: => ota_lci_shd.g_old_rec.attribute3
286: ,p_attribute4_o
287: => ota_lci_shd.g_old_rec.attribute4
288: ,p_attribute5_o
289: => ota_lci_shd.g_old_rec.attribute5
290: ,p_attribute6_o
291: => ota_lci_shd.g_old_rec.attribute6

Line 289: => ota_lci_shd.g_old_rec.attribute5

285: => ota_lci_shd.g_old_rec.attribute3
286: ,p_attribute4_o
287: => ota_lci_shd.g_old_rec.attribute4
288: ,p_attribute5_o
289: => ota_lci_shd.g_old_rec.attribute5
290: ,p_attribute6_o
291: => ota_lci_shd.g_old_rec.attribute6
292: ,p_attribute7_o
293: => ota_lci_shd.g_old_rec.attribute7

Line 291: => ota_lci_shd.g_old_rec.attribute6

287: => ota_lci_shd.g_old_rec.attribute4
288: ,p_attribute5_o
289: => ota_lci_shd.g_old_rec.attribute5
290: ,p_attribute6_o
291: => ota_lci_shd.g_old_rec.attribute6
292: ,p_attribute7_o
293: => ota_lci_shd.g_old_rec.attribute7
294: ,p_attribute8_o
295: => ota_lci_shd.g_old_rec.attribute8

Line 293: => ota_lci_shd.g_old_rec.attribute7

289: => ota_lci_shd.g_old_rec.attribute5
290: ,p_attribute6_o
291: => ota_lci_shd.g_old_rec.attribute6
292: ,p_attribute7_o
293: => ota_lci_shd.g_old_rec.attribute7
294: ,p_attribute8_o
295: => ota_lci_shd.g_old_rec.attribute8
296: ,p_attribute9_o
297: => ota_lci_shd.g_old_rec.attribute9

Line 295: => ota_lci_shd.g_old_rec.attribute8

291: => ota_lci_shd.g_old_rec.attribute6
292: ,p_attribute7_o
293: => ota_lci_shd.g_old_rec.attribute7
294: ,p_attribute8_o
295: => ota_lci_shd.g_old_rec.attribute8
296: ,p_attribute9_o
297: => ota_lci_shd.g_old_rec.attribute9
298: ,p_attribute10_o
299: => ota_lci_shd.g_old_rec.attribute10

Line 297: => ota_lci_shd.g_old_rec.attribute9

293: => ota_lci_shd.g_old_rec.attribute7
294: ,p_attribute8_o
295: => ota_lci_shd.g_old_rec.attribute8
296: ,p_attribute9_o
297: => ota_lci_shd.g_old_rec.attribute9
298: ,p_attribute10_o
299: => ota_lci_shd.g_old_rec.attribute10
300: ,p_attribute11_o
301: => ota_lci_shd.g_old_rec.attribute11

Line 299: => ota_lci_shd.g_old_rec.attribute10

295: => ota_lci_shd.g_old_rec.attribute8
296: ,p_attribute9_o
297: => ota_lci_shd.g_old_rec.attribute9
298: ,p_attribute10_o
299: => ota_lci_shd.g_old_rec.attribute10
300: ,p_attribute11_o
301: => ota_lci_shd.g_old_rec.attribute11
302: ,p_attribute12_o
303: => ota_lci_shd.g_old_rec.attribute12

Line 301: => ota_lci_shd.g_old_rec.attribute11

297: => ota_lci_shd.g_old_rec.attribute9
298: ,p_attribute10_o
299: => ota_lci_shd.g_old_rec.attribute10
300: ,p_attribute11_o
301: => ota_lci_shd.g_old_rec.attribute11
302: ,p_attribute12_o
303: => ota_lci_shd.g_old_rec.attribute12
304: ,p_attribute13_o
305: => ota_lci_shd.g_old_rec.attribute13

Line 303: => ota_lci_shd.g_old_rec.attribute12

299: => ota_lci_shd.g_old_rec.attribute10
300: ,p_attribute11_o
301: => ota_lci_shd.g_old_rec.attribute11
302: ,p_attribute12_o
303: => ota_lci_shd.g_old_rec.attribute12
304: ,p_attribute13_o
305: => ota_lci_shd.g_old_rec.attribute13
306: ,p_attribute14_o
307: => ota_lci_shd.g_old_rec.attribute14

Line 305: => ota_lci_shd.g_old_rec.attribute13

301: => ota_lci_shd.g_old_rec.attribute11
302: ,p_attribute12_o
303: => ota_lci_shd.g_old_rec.attribute12
304: ,p_attribute13_o
305: => ota_lci_shd.g_old_rec.attribute13
306: ,p_attribute14_o
307: => ota_lci_shd.g_old_rec.attribute14
308: ,p_attribute15_o
309: => ota_lci_shd.g_old_rec.attribute15

Line 307: => ota_lci_shd.g_old_rec.attribute14

303: => ota_lci_shd.g_old_rec.attribute12
304: ,p_attribute13_o
305: => ota_lci_shd.g_old_rec.attribute13
306: ,p_attribute14_o
307: => ota_lci_shd.g_old_rec.attribute14
308: ,p_attribute15_o
309: => ota_lci_shd.g_old_rec.attribute15
310: ,p_attribute16_o
311: => ota_lci_shd.g_old_rec.attribute16

Line 309: => ota_lci_shd.g_old_rec.attribute15

305: => ota_lci_shd.g_old_rec.attribute13
306: ,p_attribute14_o
307: => ota_lci_shd.g_old_rec.attribute14
308: ,p_attribute15_o
309: => ota_lci_shd.g_old_rec.attribute15
310: ,p_attribute16_o
311: => ota_lci_shd.g_old_rec.attribute16
312: ,p_attribute17_o
313: => ota_lci_shd.g_old_rec.attribute17

Line 311: => ota_lci_shd.g_old_rec.attribute16

307: => ota_lci_shd.g_old_rec.attribute14
308: ,p_attribute15_o
309: => ota_lci_shd.g_old_rec.attribute15
310: ,p_attribute16_o
311: => ota_lci_shd.g_old_rec.attribute16
312: ,p_attribute17_o
313: => ota_lci_shd.g_old_rec.attribute17
314: ,p_attribute18_o
315: => ota_lci_shd.g_old_rec.attribute18

Line 313: => ota_lci_shd.g_old_rec.attribute17

309: => ota_lci_shd.g_old_rec.attribute15
310: ,p_attribute16_o
311: => ota_lci_shd.g_old_rec.attribute16
312: ,p_attribute17_o
313: => ota_lci_shd.g_old_rec.attribute17
314: ,p_attribute18_o
315: => ota_lci_shd.g_old_rec.attribute18
316: ,p_attribute19_o
317: => ota_lci_shd.g_old_rec.attribute19

Line 315: => ota_lci_shd.g_old_rec.attribute18

311: => ota_lci_shd.g_old_rec.attribute16
312: ,p_attribute17_o
313: => ota_lci_shd.g_old_rec.attribute17
314: ,p_attribute18_o
315: => ota_lci_shd.g_old_rec.attribute18
316: ,p_attribute19_o
317: => ota_lci_shd.g_old_rec.attribute19
318: ,p_attribute20_o
319: => ota_lci_shd.g_old_rec.attribute20

Line 317: => ota_lci_shd.g_old_rec.attribute19

313: => ota_lci_shd.g_old_rec.attribute17
314: ,p_attribute18_o
315: => ota_lci_shd.g_old_rec.attribute18
316: ,p_attribute19_o
317: => ota_lci_shd.g_old_rec.attribute19
318: ,p_attribute20_o
319: => ota_lci_shd.g_old_rec.attribute20
320: );
321: --

Line 319: => ota_lci_shd.g_old_rec.attribute20

315: => ota_lci_shd.g_old_rec.attribute18
316: ,p_attribute19_o
317: => ota_lci_shd.g_old_rec.attribute19
318: ,p_attribute20_o
319: => ota_lci_shd.g_old_rec.attribute20
320: );
321: --
322: exception
323: --

Line 379: (p_rec in out nocopy ota_lci_shd.g_rec_type

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

Line 391: ota_lci_shd.g_old_rec.primary_flag;

387: -- is being used then we must set to the 'current' argument value.
388: --
389: If (p_rec.primary_flag = hr_api.g_varchar2) then
390: p_rec.primary_flag :=
391: ota_lci_shd.g_old_rec.primary_flag;
392: End If;
393: If (p_rec.start_date_active = hr_api.g_date) then
394: p_rec.start_date_active :=
395: ota_lci_shd.g_old_rec.start_date_active;

Line 395: ota_lci_shd.g_old_rec.start_date_active;

391: ota_lci_shd.g_old_rec.primary_flag;
392: End If;
393: If (p_rec.start_date_active = hr_api.g_date) then
394: p_rec.start_date_active :=
395: ota_lci_shd.g_old_rec.start_date_active;
396: End If;
397: If (p_rec.end_date_active = hr_api.g_date) then
398: p_rec.end_date_active :=
399: ota_lci_shd.g_old_rec.end_date_active;

Line 399: ota_lci_shd.g_old_rec.end_date_active;

395: ota_lci_shd.g_old_rec.start_date_active;
396: End If;
397: If (p_rec.end_date_active = hr_api.g_date) then
398: p_rec.end_date_active :=
399: ota_lci_shd.g_old_rec.end_date_active;
400: End If;
401: If (p_rec.attribute_category = hr_api.g_varchar2) then
402: p_rec.attribute_category :=
403: ota_lci_shd.g_old_rec.attribute_category;

Line 403: ota_lci_shd.g_old_rec.attribute_category;

399: ota_lci_shd.g_old_rec.end_date_active;
400: End If;
401: If (p_rec.attribute_category = hr_api.g_varchar2) then
402: p_rec.attribute_category :=
403: ota_lci_shd.g_old_rec.attribute_category;
404: End If;
405: If (p_rec.attribute1 = hr_api.g_varchar2) then
406: p_rec.attribute1 :=
407: ota_lci_shd.g_old_rec.attribute1;

Line 407: ota_lci_shd.g_old_rec.attribute1;

403: ota_lci_shd.g_old_rec.attribute_category;
404: End If;
405: If (p_rec.attribute1 = hr_api.g_varchar2) then
406: p_rec.attribute1 :=
407: ota_lci_shd.g_old_rec.attribute1;
408: End If;
409: If (p_rec.attribute2 = hr_api.g_varchar2) then
410: p_rec.attribute2 :=
411: ota_lci_shd.g_old_rec.attribute2;

Line 411: ota_lci_shd.g_old_rec.attribute2;

407: ota_lci_shd.g_old_rec.attribute1;
408: End If;
409: If (p_rec.attribute2 = hr_api.g_varchar2) then
410: p_rec.attribute2 :=
411: ota_lci_shd.g_old_rec.attribute2;
412: End If;
413: If (p_rec.attribute3 = hr_api.g_varchar2) then
414: p_rec.attribute3 :=
415: ota_lci_shd.g_old_rec.attribute3;

Line 415: ota_lci_shd.g_old_rec.attribute3;

411: ota_lci_shd.g_old_rec.attribute2;
412: End If;
413: If (p_rec.attribute3 = hr_api.g_varchar2) then
414: p_rec.attribute3 :=
415: ota_lci_shd.g_old_rec.attribute3;
416: End If;
417: If (p_rec.attribute4 = hr_api.g_varchar2) then
418: p_rec.attribute4 :=
419: ota_lci_shd.g_old_rec.attribute4;

Line 419: ota_lci_shd.g_old_rec.attribute4;

415: ota_lci_shd.g_old_rec.attribute3;
416: End If;
417: If (p_rec.attribute4 = hr_api.g_varchar2) then
418: p_rec.attribute4 :=
419: ota_lci_shd.g_old_rec.attribute4;
420: End If;
421: If (p_rec.attribute5 = hr_api.g_varchar2) then
422: p_rec.attribute5 :=
423: ota_lci_shd.g_old_rec.attribute5;

Line 423: ota_lci_shd.g_old_rec.attribute5;

419: ota_lci_shd.g_old_rec.attribute4;
420: End If;
421: If (p_rec.attribute5 = hr_api.g_varchar2) then
422: p_rec.attribute5 :=
423: ota_lci_shd.g_old_rec.attribute5;
424: End If;
425: If (p_rec.attribute6 = hr_api.g_varchar2) then
426: p_rec.attribute6 :=
427: ota_lci_shd.g_old_rec.attribute6;

Line 427: ota_lci_shd.g_old_rec.attribute6;

423: ota_lci_shd.g_old_rec.attribute5;
424: End If;
425: If (p_rec.attribute6 = hr_api.g_varchar2) then
426: p_rec.attribute6 :=
427: ota_lci_shd.g_old_rec.attribute6;
428: End If;
429: If (p_rec.attribute7 = hr_api.g_varchar2) then
430: p_rec.attribute7 :=
431: ota_lci_shd.g_old_rec.attribute7;

Line 431: ota_lci_shd.g_old_rec.attribute7;

427: ota_lci_shd.g_old_rec.attribute6;
428: End If;
429: If (p_rec.attribute7 = hr_api.g_varchar2) then
430: p_rec.attribute7 :=
431: ota_lci_shd.g_old_rec.attribute7;
432: End If;
433: If (p_rec.attribute8 = hr_api.g_varchar2) then
434: p_rec.attribute8 :=
435: ota_lci_shd.g_old_rec.attribute8;

Line 435: ota_lci_shd.g_old_rec.attribute8;

431: ota_lci_shd.g_old_rec.attribute7;
432: End If;
433: If (p_rec.attribute8 = hr_api.g_varchar2) then
434: p_rec.attribute8 :=
435: ota_lci_shd.g_old_rec.attribute8;
436: End If;
437: If (p_rec.attribute9 = hr_api.g_varchar2) then
438: p_rec.attribute9 :=
439: ota_lci_shd.g_old_rec.attribute9;

Line 439: ota_lci_shd.g_old_rec.attribute9;

435: ota_lci_shd.g_old_rec.attribute8;
436: End If;
437: If (p_rec.attribute9 = hr_api.g_varchar2) then
438: p_rec.attribute9 :=
439: ota_lci_shd.g_old_rec.attribute9;
440: End If;
441: If (p_rec.attribute10 = hr_api.g_varchar2) then
442: p_rec.attribute10 :=
443: ota_lci_shd.g_old_rec.attribute10;

Line 443: ota_lci_shd.g_old_rec.attribute10;

439: ota_lci_shd.g_old_rec.attribute9;
440: End If;
441: If (p_rec.attribute10 = hr_api.g_varchar2) then
442: p_rec.attribute10 :=
443: ota_lci_shd.g_old_rec.attribute10;
444: End If;
445: If (p_rec.attribute11 = hr_api.g_varchar2) then
446: p_rec.attribute11 :=
447: ota_lci_shd.g_old_rec.attribute11;

Line 447: ota_lci_shd.g_old_rec.attribute11;

443: ota_lci_shd.g_old_rec.attribute10;
444: End If;
445: If (p_rec.attribute11 = hr_api.g_varchar2) then
446: p_rec.attribute11 :=
447: ota_lci_shd.g_old_rec.attribute11;
448: End If;
449: If (p_rec.attribute12 = hr_api.g_varchar2) then
450: p_rec.attribute12 :=
451: ota_lci_shd.g_old_rec.attribute12;

Line 451: ota_lci_shd.g_old_rec.attribute12;

447: ota_lci_shd.g_old_rec.attribute11;
448: End If;
449: If (p_rec.attribute12 = hr_api.g_varchar2) then
450: p_rec.attribute12 :=
451: ota_lci_shd.g_old_rec.attribute12;
452: End If;
453: If (p_rec.attribute13 = hr_api.g_varchar2) then
454: p_rec.attribute13 :=
455: ota_lci_shd.g_old_rec.attribute13;

Line 455: ota_lci_shd.g_old_rec.attribute13;

451: ota_lci_shd.g_old_rec.attribute12;
452: End If;
453: If (p_rec.attribute13 = hr_api.g_varchar2) then
454: p_rec.attribute13 :=
455: ota_lci_shd.g_old_rec.attribute13;
456: End If;
457: If (p_rec.attribute14 = hr_api.g_varchar2) then
458: p_rec.attribute14 :=
459: ota_lci_shd.g_old_rec.attribute14;

Line 459: ota_lci_shd.g_old_rec.attribute14;

455: ota_lci_shd.g_old_rec.attribute13;
456: End If;
457: If (p_rec.attribute14 = hr_api.g_varchar2) then
458: p_rec.attribute14 :=
459: ota_lci_shd.g_old_rec.attribute14;
460: End If;
461: If (p_rec.attribute15 = hr_api.g_varchar2) then
462: p_rec.attribute15 :=
463: ota_lci_shd.g_old_rec.attribute15;

Line 463: ota_lci_shd.g_old_rec.attribute15;

459: ota_lci_shd.g_old_rec.attribute14;
460: End If;
461: If (p_rec.attribute15 = hr_api.g_varchar2) then
462: p_rec.attribute15 :=
463: ota_lci_shd.g_old_rec.attribute15;
464: End If;
465: If (p_rec.attribute16 = hr_api.g_varchar2) then
466: p_rec.attribute16 :=
467: ota_lci_shd.g_old_rec.attribute16;

Line 467: ota_lci_shd.g_old_rec.attribute16;

463: ota_lci_shd.g_old_rec.attribute15;
464: End If;
465: If (p_rec.attribute16 = hr_api.g_varchar2) then
466: p_rec.attribute16 :=
467: ota_lci_shd.g_old_rec.attribute16;
468: End If;
469: If (p_rec.attribute17 = hr_api.g_varchar2) then
470: p_rec.attribute17 :=
471: ota_lci_shd.g_old_rec.attribute17;

Line 471: ota_lci_shd.g_old_rec.attribute17;

467: ota_lci_shd.g_old_rec.attribute16;
468: End If;
469: If (p_rec.attribute17 = hr_api.g_varchar2) then
470: p_rec.attribute17 :=
471: ota_lci_shd.g_old_rec.attribute17;
472: End If;
473: If (p_rec.attribute18 = hr_api.g_varchar2) then
474: p_rec.attribute18 :=
475: ota_lci_shd.g_old_rec.attribute18;

Line 475: ota_lci_shd.g_old_rec.attribute18;

471: ota_lci_shd.g_old_rec.attribute17;
472: End If;
473: If (p_rec.attribute18 = hr_api.g_varchar2) then
474: p_rec.attribute18 :=
475: ota_lci_shd.g_old_rec.attribute18;
476: End If;
477: If (p_rec.attribute19 = hr_api.g_varchar2) then
478: p_rec.attribute19 :=
479: ota_lci_shd.g_old_rec.attribute19;

Line 479: ota_lci_shd.g_old_rec.attribute19;

475: ota_lci_shd.g_old_rec.attribute18;
476: End If;
477: If (p_rec.attribute19 = hr_api.g_varchar2) then
478: p_rec.attribute19 :=
479: ota_lci_shd.g_old_rec.attribute19;
480: End If;
481: If (p_rec.attribute20 = hr_api.g_varchar2) then
482: p_rec.attribute20 :=
483: ota_lci_shd.g_old_rec.attribute20;

Line 483: ota_lci_shd.g_old_rec.attribute20;

479: ota_lci_shd.g_old_rec.attribute19;
480: End If;
481: If (p_rec.attribute20 = hr_api.g_varchar2) then
482: p_rec.attribute20 :=
483: ota_lci_shd.g_old_rec.attribute20;
484: End If;
485: --
486: End convert_defs;
487: --

Line 493: ,p_rec in out nocopy ota_lci_shd.g_rec_type

489: -- |---------------------------------< upd >----------------------------------|
490: -- ----------------------------------------------------------------------------
491: Procedure upd
492: (p_effective_date in date
493: ,p_rec in out nocopy ota_lci_shd.g_rec_type
494: ) is
495: --
496: l_proc varchar2(72) := g_package||'upd';
497: --

Line 503: ota_lci_shd.lck

499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- We must lock the row which we need to update.
502: --
503: ota_lci_shd.lck
504: (p_rec.learning_path_id
505: ,p_rec.category_usage_id
506: ,p_rec.object_version_number
507: );

Line 577: l_rec ota_lci_shd.g_rec_type;

573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2
575: ) is
576: --
577: l_rec ota_lci_shd.g_rec_type;
578: l_proc varchar2(72) := g_package||'upd';
579: --
580: Begin
581: hr_utility.set_location('Entering:'||l_proc, 5);

Line 587: ota_lci_shd.convert_args

583: -- Call conversion function to turn arguments into the
584: -- l_rec structure.
585: --
586: l_rec :=
587: ota_lci_shd.convert_args
588: (p_learning_path_id
589: ,p_category_usage_id
590: ,p_primary_flag
591: ,p_start_date_active