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_CMB_UPD dependencies on OTA_CMB_SHD

Line 55: (p_rec in out nocopy ota_cmb_shd.g_rec_type

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

Line 112: ota_cmb_shd.constraint_error

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

Line 117: ota_cmb_shd.constraint_error

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

Line 122: ota_cmb_shd.constraint_error

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

Line 162: (p_rec in ota_cmb_shd.g_rec_type

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

Line 207: ,p_rec in ota_cmb_shd.g_rec_type

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

Line 279: => ota_cmb_shd.g_old_rec.certification_id

275: => p_rec.attribute19
276: ,p_attribute20
277: => p_rec.attribute20
278: ,p_certification_id_o
279: => ota_cmb_shd.g_old_rec.certification_id
280: ,p_object_id_o
281: => ota_cmb_shd.g_old_rec.object_id
282: ,p_object_type_o
283: => ota_cmb_shd.g_old_rec.object_type

Line 281: => ota_cmb_shd.g_old_rec.object_id

277: => p_rec.attribute20
278: ,p_certification_id_o
279: => ota_cmb_shd.g_old_rec.certification_id
280: ,p_object_id_o
281: => ota_cmb_shd.g_old_rec.object_id
282: ,p_object_type_o
283: => ota_cmb_shd.g_old_rec.object_type
284: ,p_member_sequence_o
285: => ota_cmb_shd.g_old_rec.member_sequence

Line 283: => ota_cmb_shd.g_old_rec.object_type

279: => ota_cmb_shd.g_old_rec.certification_id
280: ,p_object_id_o
281: => ota_cmb_shd.g_old_rec.object_id
282: ,p_object_type_o
283: => ota_cmb_shd.g_old_rec.object_type
284: ,p_member_sequence_o
285: => ota_cmb_shd.g_old_rec.member_sequence
286: ,p_business_group_id_o
287: => ota_cmb_shd.g_old_rec.business_group_id

Line 285: => ota_cmb_shd.g_old_rec.member_sequence

281: => ota_cmb_shd.g_old_rec.object_id
282: ,p_object_type_o
283: => ota_cmb_shd.g_old_rec.object_type
284: ,p_member_sequence_o
285: => ota_cmb_shd.g_old_rec.member_sequence
286: ,p_business_group_id_o
287: => ota_cmb_shd.g_old_rec.business_group_id
288: ,p_start_date_active_o
289: => ota_cmb_shd.g_old_rec.start_date_active

Line 287: => ota_cmb_shd.g_old_rec.business_group_id

283: => ota_cmb_shd.g_old_rec.object_type
284: ,p_member_sequence_o
285: => ota_cmb_shd.g_old_rec.member_sequence
286: ,p_business_group_id_o
287: => ota_cmb_shd.g_old_rec.business_group_id
288: ,p_start_date_active_o
289: => ota_cmb_shd.g_old_rec.start_date_active
290: ,p_end_date_active_o
291: => ota_cmb_shd.g_old_rec.end_date_active

Line 289: => ota_cmb_shd.g_old_rec.start_date_active

285: => ota_cmb_shd.g_old_rec.member_sequence
286: ,p_business_group_id_o
287: => ota_cmb_shd.g_old_rec.business_group_id
288: ,p_start_date_active_o
289: => ota_cmb_shd.g_old_rec.start_date_active
290: ,p_end_date_active_o
291: => ota_cmb_shd.g_old_rec.end_date_active
292: ,p_object_version_number_o
293: => ota_cmb_shd.g_old_rec.object_version_number

Line 291: => ota_cmb_shd.g_old_rec.end_date_active

287: => ota_cmb_shd.g_old_rec.business_group_id
288: ,p_start_date_active_o
289: => ota_cmb_shd.g_old_rec.start_date_active
290: ,p_end_date_active_o
291: => ota_cmb_shd.g_old_rec.end_date_active
292: ,p_object_version_number_o
293: => ota_cmb_shd.g_old_rec.object_version_number
294: ,p_attribute_category_o
295: => ota_cmb_shd.g_old_rec.attribute_category

Line 293: => ota_cmb_shd.g_old_rec.object_version_number

289: => ota_cmb_shd.g_old_rec.start_date_active
290: ,p_end_date_active_o
291: => ota_cmb_shd.g_old_rec.end_date_active
292: ,p_object_version_number_o
293: => ota_cmb_shd.g_old_rec.object_version_number
294: ,p_attribute_category_o
295: => ota_cmb_shd.g_old_rec.attribute_category
296: ,p_attribute1_o
297: => ota_cmb_shd.g_old_rec.attribute1

Line 295: => ota_cmb_shd.g_old_rec.attribute_category

291: => ota_cmb_shd.g_old_rec.end_date_active
292: ,p_object_version_number_o
293: => ota_cmb_shd.g_old_rec.object_version_number
294: ,p_attribute_category_o
295: => ota_cmb_shd.g_old_rec.attribute_category
296: ,p_attribute1_o
297: => ota_cmb_shd.g_old_rec.attribute1
298: ,p_attribute2_o
299: => ota_cmb_shd.g_old_rec.attribute2

Line 297: => ota_cmb_shd.g_old_rec.attribute1

293: => ota_cmb_shd.g_old_rec.object_version_number
294: ,p_attribute_category_o
295: => ota_cmb_shd.g_old_rec.attribute_category
296: ,p_attribute1_o
297: => ota_cmb_shd.g_old_rec.attribute1
298: ,p_attribute2_o
299: => ota_cmb_shd.g_old_rec.attribute2
300: ,p_attribute3_o
301: => ota_cmb_shd.g_old_rec.attribute3

Line 299: => ota_cmb_shd.g_old_rec.attribute2

295: => ota_cmb_shd.g_old_rec.attribute_category
296: ,p_attribute1_o
297: => ota_cmb_shd.g_old_rec.attribute1
298: ,p_attribute2_o
299: => ota_cmb_shd.g_old_rec.attribute2
300: ,p_attribute3_o
301: => ota_cmb_shd.g_old_rec.attribute3
302: ,p_attribute4_o
303: => ota_cmb_shd.g_old_rec.attribute4

Line 301: => ota_cmb_shd.g_old_rec.attribute3

297: => ota_cmb_shd.g_old_rec.attribute1
298: ,p_attribute2_o
299: => ota_cmb_shd.g_old_rec.attribute2
300: ,p_attribute3_o
301: => ota_cmb_shd.g_old_rec.attribute3
302: ,p_attribute4_o
303: => ota_cmb_shd.g_old_rec.attribute4
304: ,p_attribute5_o
305: => ota_cmb_shd.g_old_rec.attribute5

Line 303: => ota_cmb_shd.g_old_rec.attribute4

299: => ota_cmb_shd.g_old_rec.attribute2
300: ,p_attribute3_o
301: => ota_cmb_shd.g_old_rec.attribute3
302: ,p_attribute4_o
303: => ota_cmb_shd.g_old_rec.attribute4
304: ,p_attribute5_o
305: => ota_cmb_shd.g_old_rec.attribute5
306: ,p_attribute6_o
307: => ota_cmb_shd.g_old_rec.attribute6

Line 305: => ota_cmb_shd.g_old_rec.attribute5

301: => ota_cmb_shd.g_old_rec.attribute3
302: ,p_attribute4_o
303: => ota_cmb_shd.g_old_rec.attribute4
304: ,p_attribute5_o
305: => ota_cmb_shd.g_old_rec.attribute5
306: ,p_attribute6_o
307: => ota_cmb_shd.g_old_rec.attribute6
308: ,p_attribute7_o
309: => ota_cmb_shd.g_old_rec.attribute7

Line 307: => ota_cmb_shd.g_old_rec.attribute6

303: => ota_cmb_shd.g_old_rec.attribute4
304: ,p_attribute5_o
305: => ota_cmb_shd.g_old_rec.attribute5
306: ,p_attribute6_o
307: => ota_cmb_shd.g_old_rec.attribute6
308: ,p_attribute7_o
309: => ota_cmb_shd.g_old_rec.attribute7
310: ,p_attribute8_o
311: => ota_cmb_shd.g_old_rec.attribute8

Line 309: => ota_cmb_shd.g_old_rec.attribute7

305: => ota_cmb_shd.g_old_rec.attribute5
306: ,p_attribute6_o
307: => ota_cmb_shd.g_old_rec.attribute6
308: ,p_attribute7_o
309: => ota_cmb_shd.g_old_rec.attribute7
310: ,p_attribute8_o
311: => ota_cmb_shd.g_old_rec.attribute8
312: ,p_attribute9_o
313: => ota_cmb_shd.g_old_rec.attribute9

Line 311: => ota_cmb_shd.g_old_rec.attribute8

307: => ota_cmb_shd.g_old_rec.attribute6
308: ,p_attribute7_o
309: => ota_cmb_shd.g_old_rec.attribute7
310: ,p_attribute8_o
311: => ota_cmb_shd.g_old_rec.attribute8
312: ,p_attribute9_o
313: => ota_cmb_shd.g_old_rec.attribute9
314: ,p_attribute10_o
315: => ota_cmb_shd.g_old_rec.attribute10

Line 313: => ota_cmb_shd.g_old_rec.attribute9

309: => ota_cmb_shd.g_old_rec.attribute7
310: ,p_attribute8_o
311: => ota_cmb_shd.g_old_rec.attribute8
312: ,p_attribute9_o
313: => ota_cmb_shd.g_old_rec.attribute9
314: ,p_attribute10_o
315: => ota_cmb_shd.g_old_rec.attribute10
316: ,p_attribute11_o
317: => ota_cmb_shd.g_old_rec.attribute11

Line 315: => ota_cmb_shd.g_old_rec.attribute10

311: => ota_cmb_shd.g_old_rec.attribute8
312: ,p_attribute9_o
313: => ota_cmb_shd.g_old_rec.attribute9
314: ,p_attribute10_o
315: => ota_cmb_shd.g_old_rec.attribute10
316: ,p_attribute11_o
317: => ota_cmb_shd.g_old_rec.attribute11
318: ,p_attribute12_o
319: => ota_cmb_shd.g_old_rec.attribute12

Line 317: => ota_cmb_shd.g_old_rec.attribute11

313: => ota_cmb_shd.g_old_rec.attribute9
314: ,p_attribute10_o
315: => ota_cmb_shd.g_old_rec.attribute10
316: ,p_attribute11_o
317: => ota_cmb_shd.g_old_rec.attribute11
318: ,p_attribute12_o
319: => ota_cmb_shd.g_old_rec.attribute12
320: ,p_attribute13_o
321: => ota_cmb_shd.g_old_rec.attribute13

Line 319: => ota_cmb_shd.g_old_rec.attribute12

315: => ota_cmb_shd.g_old_rec.attribute10
316: ,p_attribute11_o
317: => ota_cmb_shd.g_old_rec.attribute11
318: ,p_attribute12_o
319: => ota_cmb_shd.g_old_rec.attribute12
320: ,p_attribute13_o
321: => ota_cmb_shd.g_old_rec.attribute13
322: ,p_attribute14_o
323: => ota_cmb_shd.g_old_rec.attribute14

Line 321: => ota_cmb_shd.g_old_rec.attribute13

317: => ota_cmb_shd.g_old_rec.attribute11
318: ,p_attribute12_o
319: => ota_cmb_shd.g_old_rec.attribute12
320: ,p_attribute13_o
321: => ota_cmb_shd.g_old_rec.attribute13
322: ,p_attribute14_o
323: => ota_cmb_shd.g_old_rec.attribute14
324: ,p_attribute15_o
325: => ota_cmb_shd.g_old_rec.attribute15

Line 323: => ota_cmb_shd.g_old_rec.attribute14

319: => ota_cmb_shd.g_old_rec.attribute12
320: ,p_attribute13_o
321: => ota_cmb_shd.g_old_rec.attribute13
322: ,p_attribute14_o
323: => ota_cmb_shd.g_old_rec.attribute14
324: ,p_attribute15_o
325: => ota_cmb_shd.g_old_rec.attribute15
326: ,p_attribute16_o
327: => ota_cmb_shd.g_old_rec.attribute16

Line 325: => ota_cmb_shd.g_old_rec.attribute15

321: => ota_cmb_shd.g_old_rec.attribute13
322: ,p_attribute14_o
323: => ota_cmb_shd.g_old_rec.attribute14
324: ,p_attribute15_o
325: => ota_cmb_shd.g_old_rec.attribute15
326: ,p_attribute16_o
327: => ota_cmb_shd.g_old_rec.attribute16
328: ,p_attribute17_o
329: => ota_cmb_shd.g_old_rec.attribute17

Line 327: => ota_cmb_shd.g_old_rec.attribute16

323: => ota_cmb_shd.g_old_rec.attribute14
324: ,p_attribute15_o
325: => ota_cmb_shd.g_old_rec.attribute15
326: ,p_attribute16_o
327: => ota_cmb_shd.g_old_rec.attribute16
328: ,p_attribute17_o
329: => ota_cmb_shd.g_old_rec.attribute17
330: ,p_attribute18_o
331: => ota_cmb_shd.g_old_rec.attribute18

Line 329: => ota_cmb_shd.g_old_rec.attribute17

325: => ota_cmb_shd.g_old_rec.attribute15
326: ,p_attribute16_o
327: => ota_cmb_shd.g_old_rec.attribute16
328: ,p_attribute17_o
329: => ota_cmb_shd.g_old_rec.attribute17
330: ,p_attribute18_o
331: => ota_cmb_shd.g_old_rec.attribute18
332: ,p_attribute19_o
333: => ota_cmb_shd.g_old_rec.attribute19

Line 331: => ota_cmb_shd.g_old_rec.attribute18

327: => ota_cmb_shd.g_old_rec.attribute16
328: ,p_attribute17_o
329: => ota_cmb_shd.g_old_rec.attribute17
330: ,p_attribute18_o
331: => ota_cmb_shd.g_old_rec.attribute18
332: ,p_attribute19_o
333: => ota_cmb_shd.g_old_rec.attribute19
334: ,p_attribute20_o
335: => ota_cmb_shd.g_old_rec.attribute20

Line 333: => ota_cmb_shd.g_old_rec.attribute19

329: => ota_cmb_shd.g_old_rec.attribute17
330: ,p_attribute18_o
331: => ota_cmb_shd.g_old_rec.attribute18
332: ,p_attribute19_o
333: => ota_cmb_shd.g_old_rec.attribute19
334: ,p_attribute20_o
335: => ota_cmb_shd.g_old_rec.attribute20
336: );
337: --

Line 335: => ota_cmb_shd.g_old_rec.attribute20

331: => ota_cmb_shd.g_old_rec.attribute18
332: ,p_attribute19_o
333: => ota_cmb_shd.g_old_rec.attribute19
334: ,p_attribute20_o
335: => ota_cmb_shd.g_old_rec.attribute20
336: );
337: --
338: exception
339: --

Line 395: (p_rec in out nocopy ota_cmb_shd.g_rec_type

391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure convert_defs
395: (p_rec in out nocopy ota_cmb_shd.g_rec_type
396: ) is
397: --
398: Begin
399: --

Line 407: ota_cmb_shd.g_old_rec.certification_id;

403: -- is being used then we must set to the 'current' argument value.
404: --
405: If (p_rec.certification_id = hr_api.g_number) then
406: p_rec.certification_id :=
407: ota_cmb_shd.g_old_rec.certification_id;
408: End If;
409: If (p_rec.object_id = hr_api.g_number) then
410: p_rec.object_id :=
411: ota_cmb_shd.g_old_rec.object_id;

Line 411: ota_cmb_shd.g_old_rec.object_id;

407: ota_cmb_shd.g_old_rec.certification_id;
408: End If;
409: If (p_rec.object_id = hr_api.g_number) then
410: p_rec.object_id :=
411: ota_cmb_shd.g_old_rec.object_id;
412: End If;
413: If (p_rec.object_type = hr_api.g_varchar2) then
414: p_rec.object_type :=
415: ota_cmb_shd.g_old_rec.object_type;

Line 415: ota_cmb_shd.g_old_rec.object_type;

411: ota_cmb_shd.g_old_rec.object_id;
412: End If;
413: If (p_rec.object_type = hr_api.g_varchar2) then
414: p_rec.object_type :=
415: ota_cmb_shd.g_old_rec.object_type;
416: End If;
417: If (p_rec.member_sequence = hr_api.g_number) then
418: p_rec.member_sequence :=
419: ota_cmb_shd.g_old_rec.member_sequence;

Line 419: ota_cmb_shd.g_old_rec.member_sequence;

415: ota_cmb_shd.g_old_rec.object_type;
416: End If;
417: If (p_rec.member_sequence = hr_api.g_number) then
418: p_rec.member_sequence :=
419: ota_cmb_shd.g_old_rec.member_sequence;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_cmb_shd.g_old_rec.business_group_id;

Line 423: ota_cmb_shd.g_old_rec.business_group_id;

419: ota_cmb_shd.g_old_rec.member_sequence;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_cmb_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.start_date_active = hr_api.g_date) then
426: p_rec.start_date_active :=
427: ota_cmb_shd.g_old_rec.start_date_active;

Line 427: ota_cmb_shd.g_old_rec.start_date_active;

423: ota_cmb_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.start_date_active = hr_api.g_date) then
426: p_rec.start_date_active :=
427: ota_cmb_shd.g_old_rec.start_date_active;
428: End If;
429: If (p_rec.end_date_active = hr_api.g_date) then
430: p_rec.end_date_active :=
431: ota_cmb_shd.g_old_rec.end_date_active;

Line 431: ota_cmb_shd.g_old_rec.end_date_active;

427: ota_cmb_shd.g_old_rec.start_date_active;
428: End If;
429: If (p_rec.end_date_active = hr_api.g_date) then
430: p_rec.end_date_active :=
431: ota_cmb_shd.g_old_rec.end_date_active;
432: End If;
433: If (p_rec.attribute_category = hr_api.g_varchar2) then
434: p_rec.attribute_category :=
435: ota_cmb_shd.g_old_rec.attribute_category;

Line 435: ota_cmb_shd.g_old_rec.attribute_category;

431: ota_cmb_shd.g_old_rec.end_date_active;
432: End If;
433: If (p_rec.attribute_category = hr_api.g_varchar2) then
434: p_rec.attribute_category :=
435: ota_cmb_shd.g_old_rec.attribute_category;
436: End If;
437: If (p_rec.attribute1 = hr_api.g_varchar2) then
438: p_rec.attribute1 :=
439: ota_cmb_shd.g_old_rec.attribute1;

Line 439: ota_cmb_shd.g_old_rec.attribute1;

435: ota_cmb_shd.g_old_rec.attribute_category;
436: End If;
437: If (p_rec.attribute1 = hr_api.g_varchar2) then
438: p_rec.attribute1 :=
439: ota_cmb_shd.g_old_rec.attribute1;
440: End If;
441: If (p_rec.attribute2 = hr_api.g_varchar2) then
442: p_rec.attribute2 :=
443: ota_cmb_shd.g_old_rec.attribute2;

Line 443: ota_cmb_shd.g_old_rec.attribute2;

439: ota_cmb_shd.g_old_rec.attribute1;
440: End If;
441: If (p_rec.attribute2 = hr_api.g_varchar2) then
442: p_rec.attribute2 :=
443: ota_cmb_shd.g_old_rec.attribute2;
444: End If;
445: If (p_rec.attribute3 = hr_api.g_varchar2) then
446: p_rec.attribute3 :=
447: ota_cmb_shd.g_old_rec.attribute3;

Line 447: ota_cmb_shd.g_old_rec.attribute3;

443: ota_cmb_shd.g_old_rec.attribute2;
444: End If;
445: If (p_rec.attribute3 = hr_api.g_varchar2) then
446: p_rec.attribute3 :=
447: ota_cmb_shd.g_old_rec.attribute3;
448: End If;
449: If (p_rec.attribute4 = hr_api.g_varchar2) then
450: p_rec.attribute4 :=
451: ota_cmb_shd.g_old_rec.attribute4;

Line 451: ota_cmb_shd.g_old_rec.attribute4;

447: ota_cmb_shd.g_old_rec.attribute3;
448: End If;
449: If (p_rec.attribute4 = hr_api.g_varchar2) then
450: p_rec.attribute4 :=
451: ota_cmb_shd.g_old_rec.attribute4;
452: End If;
453: If (p_rec.attribute5 = hr_api.g_varchar2) then
454: p_rec.attribute5 :=
455: ota_cmb_shd.g_old_rec.attribute5;

Line 455: ota_cmb_shd.g_old_rec.attribute5;

451: ota_cmb_shd.g_old_rec.attribute4;
452: End If;
453: If (p_rec.attribute5 = hr_api.g_varchar2) then
454: p_rec.attribute5 :=
455: ota_cmb_shd.g_old_rec.attribute5;
456: End If;
457: If (p_rec.attribute6 = hr_api.g_varchar2) then
458: p_rec.attribute6 :=
459: ota_cmb_shd.g_old_rec.attribute6;

Line 459: ota_cmb_shd.g_old_rec.attribute6;

455: ota_cmb_shd.g_old_rec.attribute5;
456: End If;
457: If (p_rec.attribute6 = hr_api.g_varchar2) then
458: p_rec.attribute6 :=
459: ota_cmb_shd.g_old_rec.attribute6;
460: End If;
461: If (p_rec.attribute7 = hr_api.g_varchar2) then
462: p_rec.attribute7 :=
463: ota_cmb_shd.g_old_rec.attribute7;

Line 463: ota_cmb_shd.g_old_rec.attribute7;

459: ota_cmb_shd.g_old_rec.attribute6;
460: End If;
461: If (p_rec.attribute7 = hr_api.g_varchar2) then
462: p_rec.attribute7 :=
463: ota_cmb_shd.g_old_rec.attribute7;
464: End If;
465: If (p_rec.attribute8 = hr_api.g_varchar2) then
466: p_rec.attribute8 :=
467: ota_cmb_shd.g_old_rec.attribute8;

Line 467: ota_cmb_shd.g_old_rec.attribute8;

463: ota_cmb_shd.g_old_rec.attribute7;
464: End If;
465: If (p_rec.attribute8 = hr_api.g_varchar2) then
466: p_rec.attribute8 :=
467: ota_cmb_shd.g_old_rec.attribute8;
468: End If;
469: If (p_rec.attribute9 = hr_api.g_varchar2) then
470: p_rec.attribute9 :=
471: ota_cmb_shd.g_old_rec.attribute9;

Line 471: ota_cmb_shd.g_old_rec.attribute9;

467: ota_cmb_shd.g_old_rec.attribute8;
468: End If;
469: If (p_rec.attribute9 = hr_api.g_varchar2) then
470: p_rec.attribute9 :=
471: ota_cmb_shd.g_old_rec.attribute9;
472: End If;
473: If (p_rec.attribute10 = hr_api.g_varchar2) then
474: p_rec.attribute10 :=
475: ota_cmb_shd.g_old_rec.attribute10;

Line 475: ota_cmb_shd.g_old_rec.attribute10;

471: ota_cmb_shd.g_old_rec.attribute9;
472: End If;
473: If (p_rec.attribute10 = hr_api.g_varchar2) then
474: p_rec.attribute10 :=
475: ota_cmb_shd.g_old_rec.attribute10;
476: End If;
477: If (p_rec.attribute11 = hr_api.g_varchar2) then
478: p_rec.attribute11 :=
479: ota_cmb_shd.g_old_rec.attribute11;

Line 479: ota_cmb_shd.g_old_rec.attribute11;

475: ota_cmb_shd.g_old_rec.attribute10;
476: End If;
477: If (p_rec.attribute11 = hr_api.g_varchar2) then
478: p_rec.attribute11 :=
479: ota_cmb_shd.g_old_rec.attribute11;
480: End If;
481: If (p_rec.attribute12 = hr_api.g_varchar2) then
482: p_rec.attribute12 :=
483: ota_cmb_shd.g_old_rec.attribute12;

Line 483: ota_cmb_shd.g_old_rec.attribute12;

479: ota_cmb_shd.g_old_rec.attribute11;
480: End If;
481: If (p_rec.attribute12 = hr_api.g_varchar2) then
482: p_rec.attribute12 :=
483: ota_cmb_shd.g_old_rec.attribute12;
484: End If;
485: If (p_rec.attribute13 = hr_api.g_varchar2) then
486: p_rec.attribute13 :=
487: ota_cmb_shd.g_old_rec.attribute13;

Line 487: ota_cmb_shd.g_old_rec.attribute13;

483: ota_cmb_shd.g_old_rec.attribute12;
484: End If;
485: If (p_rec.attribute13 = hr_api.g_varchar2) then
486: p_rec.attribute13 :=
487: ota_cmb_shd.g_old_rec.attribute13;
488: End If;
489: If (p_rec.attribute14 = hr_api.g_varchar2) then
490: p_rec.attribute14 :=
491: ota_cmb_shd.g_old_rec.attribute14;

Line 491: ota_cmb_shd.g_old_rec.attribute14;

487: ota_cmb_shd.g_old_rec.attribute13;
488: End If;
489: If (p_rec.attribute14 = hr_api.g_varchar2) then
490: p_rec.attribute14 :=
491: ota_cmb_shd.g_old_rec.attribute14;
492: End If;
493: If (p_rec.attribute15 = hr_api.g_varchar2) then
494: p_rec.attribute15 :=
495: ota_cmb_shd.g_old_rec.attribute15;

Line 495: ota_cmb_shd.g_old_rec.attribute15;

491: ota_cmb_shd.g_old_rec.attribute14;
492: End If;
493: If (p_rec.attribute15 = hr_api.g_varchar2) then
494: p_rec.attribute15 :=
495: ota_cmb_shd.g_old_rec.attribute15;
496: End If;
497: If (p_rec.attribute16 = hr_api.g_varchar2) then
498: p_rec.attribute16 :=
499: ota_cmb_shd.g_old_rec.attribute16;

Line 499: ota_cmb_shd.g_old_rec.attribute16;

495: ota_cmb_shd.g_old_rec.attribute15;
496: End If;
497: If (p_rec.attribute16 = hr_api.g_varchar2) then
498: p_rec.attribute16 :=
499: ota_cmb_shd.g_old_rec.attribute16;
500: End If;
501: If (p_rec.attribute17 = hr_api.g_varchar2) then
502: p_rec.attribute17 :=
503: ota_cmb_shd.g_old_rec.attribute17;

Line 503: ota_cmb_shd.g_old_rec.attribute17;

499: ota_cmb_shd.g_old_rec.attribute16;
500: End If;
501: If (p_rec.attribute17 = hr_api.g_varchar2) then
502: p_rec.attribute17 :=
503: ota_cmb_shd.g_old_rec.attribute17;
504: End If;
505: If (p_rec.attribute18 = hr_api.g_varchar2) then
506: p_rec.attribute18 :=
507: ota_cmb_shd.g_old_rec.attribute18;

Line 507: ota_cmb_shd.g_old_rec.attribute18;

503: ota_cmb_shd.g_old_rec.attribute17;
504: End If;
505: If (p_rec.attribute18 = hr_api.g_varchar2) then
506: p_rec.attribute18 :=
507: ota_cmb_shd.g_old_rec.attribute18;
508: End If;
509: If (p_rec.attribute19 = hr_api.g_varchar2) then
510: p_rec.attribute19 :=
511: ota_cmb_shd.g_old_rec.attribute19;

Line 511: ota_cmb_shd.g_old_rec.attribute19;

507: ota_cmb_shd.g_old_rec.attribute18;
508: End If;
509: If (p_rec.attribute19 = hr_api.g_varchar2) then
510: p_rec.attribute19 :=
511: ota_cmb_shd.g_old_rec.attribute19;
512: End If;
513: If (p_rec.attribute20 = hr_api.g_varchar2) then
514: p_rec.attribute20 :=
515: ota_cmb_shd.g_old_rec.attribute20;

Line 515: ota_cmb_shd.g_old_rec.attribute20;

511: ota_cmb_shd.g_old_rec.attribute19;
512: End If;
513: If (p_rec.attribute20 = hr_api.g_varchar2) then
514: p_rec.attribute20 :=
515: ota_cmb_shd.g_old_rec.attribute20;
516: End If;
517: --
518: End convert_defs;
519: --

Line 525: ,p_rec in out nocopy ota_cmb_shd.g_rec_type

521: -- |---------------------------------< upd >----------------------------------|
522: -- ----------------------------------------------------------------------------
523: Procedure upd
524: (p_effective_date in date
525: ,p_rec in out nocopy ota_cmb_shd.g_rec_type
526: ) is
527: --
528: l_proc varchar2(72) := g_package||'upd';
529: --

Line 535: ota_cmb_shd.lck

531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- We must lock the row which we need to update.
534: --
535: ota_cmb_shd.lck
536: (p_rec.certification_member_id
537: ,p_rec.object_version_number
538: );
539: --

Line 611: l_rec ota_cmb_shd.g_rec_type;

607: ,p_attribute19 in varchar2 default hr_api.g_varchar2
608: ,p_attribute20 in varchar2 default hr_api.g_varchar2
609: ) is
610: --
611: l_rec ota_cmb_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);

Line 621: ota_cmb_shd.convert_args

617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
620: l_rec :=
621: ota_cmb_shd.convert_args
622: (p_certification_member_id
623: ,p_certification_id
624: ,p_object_id
625: ,p_object_type