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_CRE_UPD dependencies on OTA_CRE_SHD

Line 55: (p_rec in out nocopy ota_cre_shd.g_rec_type

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

Line 116: ota_cre_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cre_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: ota_cre_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cre_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: ota_cre_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cre_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 166: (p_rec in ota_cre_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_update
166: (p_rec in ota_cre_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --

Line 211: ,p_rec in ota_cre_shd.g_rec_type

207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_effective_date in date
211: ,p_rec in ota_cre_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --

Line 291: => ota_cre_shd.g_old_rec.certification_id

287: => p_rec.attribute20
288: ,p_enrollment_date
289: => p_rec.enrollment_date
290: ,p_certification_id_o
291: => ota_cre_shd.g_old_rec.certification_id
292: ,p_person_id_o
293: => ota_cre_shd.g_old_rec.person_id
294: ,p_contact_id_o
295: => ota_cre_shd.g_old_rec.contact_id

Line 293: => ota_cre_shd.g_old_rec.person_id

289: => p_rec.enrollment_date
290: ,p_certification_id_o
291: => ota_cre_shd.g_old_rec.certification_id
292: ,p_person_id_o
293: => ota_cre_shd.g_old_rec.person_id
294: ,p_contact_id_o
295: => ota_cre_shd.g_old_rec.contact_id
296: ,p_object_version_number_o
297: => ota_cre_shd.g_old_rec.object_version_number

Line 295: => ota_cre_shd.g_old_rec.contact_id

291: => ota_cre_shd.g_old_rec.certification_id
292: ,p_person_id_o
293: => ota_cre_shd.g_old_rec.person_id
294: ,p_contact_id_o
295: => ota_cre_shd.g_old_rec.contact_id
296: ,p_object_version_number_o
297: => ota_cre_shd.g_old_rec.object_version_number
298: ,p_certification_status_code_o
299: => ota_cre_shd.g_old_rec.certification_status_code

Line 297: => ota_cre_shd.g_old_rec.object_version_number

293: => ota_cre_shd.g_old_rec.person_id
294: ,p_contact_id_o
295: => ota_cre_shd.g_old_rec.contact_id
296: ,p_object_version_number_o
297: => ota_cre_shd.g_old_rec.object_version_number
298: ,p_certification_status_code_o
299: => ota_cre_shd.g_old_rec.certification_status_code
300: ,p_completion_date_o
301: => ota_cre_shd.g_old_rec.completion_date

Line 299: => ota_cre_shd.g_old_rec.certification_status_code

295: => ota_cre_shd.g_old_rec.contact_id
296: ,p_object_version_number_o
297: => ota_cre_shd.g_old_rec.object_version_number
298: ,p_certification_status_code_o
299: => ota_cre_shd.g_old_rec.certification_status_code
300: ,p_completion_date_o
301: => ota_cre_shd.g_old_rec.completion_date
302: ,p_business_group_id_o
303: => ota_cre_shd.g_old_rec.business_group_id

Line 301: => ota_cre_shd.g_old_rec.completion_date

297: => ota_cre_shd.g_old_rec.object_version_number
298: ,p_certification_status_code_o
299: => ota_cre_shd.g_old_rec.certification_status_code
300: ,p_completion_date_o
301: => ota_cre_shd.g_old_rec.completion_date
302: ,p_business_group_id_o
303: => ota_cre_shd.g_old_rec.business_group_id
304: ,p_unenrollment_date_o
305: => ota_cre_shd.g_old_rec.unenrollment_date

Line 303: => ota_cre_shd.g_old_rec.business_group_id

299: => ota_cre_shd.g_old_rec.certification_status_code
300: ,p_completion_date_o
301: => ota_cre_shd.g_old_rec.completion_date
302: ,p_business_group_id_o
303: => ota_cre_shd.g_old_rec.business_group_id
304: ,p_unenrollment_date_o
305: => ota_cre_shd.g_old_rec.unenrollment_date
306: ,p_expiration_date_o
307: => ota_cre_shd.g_old_rec.expiration_date

Line 305: => ota_cre_shd.g_old_rec.unenrollment_date

301: => ota_cre_shd.g_old_rec.completion_date
302: ,p_business_group_id_o
303: => ota_cre_shd.g_old_rec.business_group_id
304: ,p_unenrollment_date_o
305: => ota_cre_shd.g_old_rec.unenrollment_date
306: ,p_expiration_date_o
307: => ota_cre_shd.g_old_rec.expiration_date
308: ,p_earliest_enroll_date_o
309: => ota_cre_shd.g_old_rec.earliest_enroll_date

Line 307: => ota_cre_shd.g_old_rec.expiration_date

303: => ota_cre_shd.g_old_rec.business_group_id
304: ,p_unenrollment_date_o
305: => ota_cre_shd.g_old_rec.unenrollment_date
306: ,p_expiration_date_o
307: => ota_cre_shd.g_old_rec.expiration_date
308: ,p_earliest_enroll_date_o
309: => ota_cre_shd.g_old_rec.earliest_enroll_date
310: ,p_is_history_flag_o
311: => ota_cre_shd.g_old_rec.is_history_flag

Line 309: => ota_cre_shd.g_old_rec.earliest_enroll_date

305: => ota_cre_shd.g_old_rec.unenrollment_date
306: ,p_expiration_date_o
307: => ota_cre_shd.g_old_rec.expiration_date
308: ,p_earliest_enroll_date_o
309: => ota_cre_shd.g_old_rec.earliest_enroll_date
310: ,p_is_history_flag_o
311: => ota_cre_shd.g_old_rec.is_history_flag
312: ,p_attribute_category_o
313: => ota_cre_shd.g_old_rec.attribute_category

Line 311: => ota_cre_shd.g_old_rec.is_history_flag

307: => ota_cre_shd.g_old_rec.expiration_date
308: ,p_earliest_enroll_date_o
309: => ota_cre_shd.g_old_rec.earliest_enroll_date
310: ,p_is_history_flag_o
311: => ota_cre_shd.g_old_rec.is_history_flag
312: ,p_attribute_category_o
313: => ota_cre_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => ota_cre_shd.g_old_rec.attribute1

Line 313: => ota_cre_shd.g_old_rec.attribute_category

309: => ota_cre_shd.g_old_rec.earliest_enroll_date
310: ,p_is_history_flag_o
311: => ota_cre_shd.g_old_rec.is_history_flag
312: ,p_attribute_category_o
313: => ota_cre_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => ota_cre_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => ota_cre_shd.g_old_rec.attribute2

Line 315: => ota_cre_shd.g_old_rec.attribute1

311: => ota_cre_shd.g_old_rec.is_history_flag
312: ,p_attribute_category_o
313: => ota_cre_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => ota_cre_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => ota_cre_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => ota_cre_shd.g_old_rec.attribute3

Line 317: => ota_cre_shd.g_old_rec.attribute2

313: => ota_cre_shd.g_old_rec.attribute_category
314: ,p_attribute1_o
315: => ota_cre_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => ota_cre_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => ota_cre_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => ota_cre_shd.g_old_rec.attribute4

Line 319: => ota_cre_shd.g_old_rec.attribute3

315: => ota_cre_shd.g_old_rec.attribute1
316: ,p_attribute2_o
317: => ota_cre_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => ota_cre_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => ota_cre_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => ota_cre_shd.g_old_rec.attribute5

Line 321: => ota_cre_shd.g_old_rec.attribute4

317: => ota_cre_shd.g_old_rec.attribute2
318: ,p_attribute3_o
319: => ota_cre_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => ota_cre_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => ota_cre_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => ota_cre_shd.g_old_rec.attribute6

Line 323: => ota_cre_shd.g_old_rec.attribute5

319: => ota_cre_shd.g_old_rec.attribute3
320: ,p_attribute4_o
321: => ota_cre_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => ota_cre_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => ota_cre_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => ota_cre_shd.g_old_rec.attribute7

Line 325: => ota_cre_shd.g_old_rec.attribute6

321: => ota_cre_shd.g_old_rec.attribute4
322: ,p_attribute5_o
323: => ota_cre_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => ota_cre_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => ota_cre_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => ota_cre_shd.g_old_rec.attribute8

Line 327: => ota_cre_shd.g_old_rec.attribute7

323: => ota_cre_shd.g_old_rec.attribute5
324: ,p_attribute6_o
325: => ota_cre_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => ota_cre_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => ota_cre_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => ota_cre_shd.g_old_rec.attribute9

Line 329: => ota_cre_shd.g_old_rec.attribute8

325: => ota_cre_shd.g_old_rec.attribute6
326: ,p_attribute7_o
327: => ota_cre_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => ota_cre_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => ota_cre_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => ota_cre_shd.g_old_rec.attribute10

Line 331: => ota_cre_shd.g_old_rec.attribute9

327: => ota_cre_shd.g_old_rec.attribute7
328: ,p_attribute8_o
329: => ota_cre_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => ota_cre_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => ota_cre_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => ota_cre_shd.g_old_rec.attribute11

Line 333: => ota_cre_shd.g_old_rec.attribute10

329: => ota_cre_shd.g_old_rec.attribute8
330: ,p_attribute9_o
331: => ota_cre_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => ota_cre_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => ota_cre_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => ota_cre_shd.g_old_rec.attribute12

Line 335: => ota_cre_shd.g_old_rec.attribute11

331: => ota_cre_shd.g_old_rec.attribute9
332: ,p_attribute10_o
333: => ota_cre_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => ota_cre_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => ota_cre_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => ota_cre_shd.g_old_rec.attribute13

Line 337: => ota_cre_shd.g_old_rec.attribute12

333: => ota_cre_shd.g_old_rec.attribute10
334: ,p_attribute11_o
335: => ota_cre_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => ota_cre_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => ota_cre_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => ota_cre_shd.g_old_rec.attribute14

Line 339: => ota_cre_shd.g_old_rec.attribute13

335: => ota_cre_shd.g_old_rec.attribute11
336: ,p_attribute12_o
337: => ota_cre_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => ota_cre_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => ota_cre_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => ota_cre_shd.g_old_rec.attribute15

Line 341: => ota_cre_shd.g_old_rec.attribute14

337: => ota_cre_shd.g_old_rec.attribute12
338: ,p_attribute13_o
339: => ota_cre_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => ota_cre_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => ota_cre_shd.g_old_rec.attribute15
344: ,p_attribute16_o
345: => ota_cre_shd.g_old_rec.attribute16

Line 343: => ota_cre_shd.g_old_rec.attribute15

339: => ota_cre_shd.g_old_rec.attribute13
340: ,p_attribute14_o
341: => ota_cre_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => ota_cre_shd.g_old_rec.attribute15
344: ,p_attribute16_o
345: => ota_cre_shd.g_old_rec.attribute16
346: ,p_attribute17_o
347: => ota_cre_shd.g_old_rec.attribute17

Line 345: => ota_cre_shd.g_old_rec.attribute16

341: => ota_cre_shd.g_old_rec.attribute14
342: ,p_attribute15_o
343: => ota_cre_shd.g_old_rec.attribute15
344: ,p_attribute16_o
345: => ota_cre_shd.g_old_rec.attribute16
346: ,p_attribute17_o
347: => ota_cre_shd.g_old_rec.attribute17
348: ,p_attribute18_o
349: => ota_cre_shd.g_old_rec.attribute18

Line 347: => ota_cre_shd.g_old_rec.attribute17

343: => ota_cre_shd.g_old_rec.attribute15
344: ,p_attribute16_o
345: => ota_cre_shd.g_old_rec.attribute16
346: ,p_attribute17_o
347: => ota_cre_shd.g_old_rec.attribute17
348: ,p_attribute18_o
349: => ota_cre_shd.g_old_rec.attribute18
350: ,p_attribute19_o
351: => ota_cre_shd.g_old_rec.attribute19

Line 349: => ota_cre_shd.g_old_rec.attribute18

345: => ota_cre_shd.g_old_rec.attribute16
346: ,p_attribute17_o
347: => ota_cre_shd.g_old_rec.attribute17
348: ,p_attribute18_o
349: => ota_cre_shd.g_old_rec.attribute18
350: ,p_attribute19_o
351: => ota_cre_shd.g_old_rec.attribute19
352: ,p_attribute20_o
353: => ota_cre_shd.g_old_rec.attribute20

Line 351: => ota_cre_shd.g_old_rec.attribute19

347: => ota_cre_shd.g_old_rec.attribute17
348: ,p_attribute18_o
349: => ota_cre_shd.g_old_rec.attribute18
350: ,p_attribute19_o
351: => ota_cre_shd.g_old_rec.attribute19
352: ,p_attribute20_o
353: => ota_cre_shd.g_old_rec.attribute20
354: ,p_enrollment_date_o
355: => ota_cre_shd.g_old_rec.enrollment_date

Line 353: => ota_cre_shd.g_old_rec.attribute20

349: => ota_cre_shd.g_old_rec.attribute18
350: ,p_attribute19_o
351: => ota_cre_shd.g_old_rec.attribute19
352: ,p_attribute20_o
353: => ota_cre_shd.g_old_rec.attribute20
354: ,p_enrollment_date_o
355: => ota_cre_shd.g_old_rec.enrollment_date
356: );
357: --

Line 355: => ota_cre_shd.g_old_rec.enrollment_date

351: => ota_cre_shd.g_old_rec.attribute19
352: ,p_attribute20_o
353: => ota_cre_shd.g_old_rec.attribute20
354: ,p_enrollment_date_o
355: => ota_cre_shd.g_old_rec.enrollment_date
356: );
357: --
358: exception
359: --

Line 415: (p_rec in out nocopy ota_cre_shd.g_rec_type

411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure convert_defs
415: (p_rec in out nocopy ota_cre_shd.g_rec_type
416: ) is
417: --
418: Begin
419: --

Line 427: ota_cre_shd.g_old_rec.certification_id;

423: -- is being used then we must set to the 'current' argument value.
424: --
425: If (p_rec.certification_id = hr_api.g_number) then
426: p_rec.certification_id :=
427: ota_cre_shd.g_old_rec.certification_id;
428: End If;
429: If (p_rec.person_id = hr_api.g_number) then
430: p_rec.person_id :=
431: ota_cre_shd.g_old_rec.person_id;

Line 431: ota_cre_shd.g_old_rec.person_id;

427: ota_cre_shd.g_old_rec.certification_id;
428: End If;
429: If (p_rec.person_id = hr_api.g_number) then
430: p_rec.person_id :=
431: ota_cre_shd.g_old_rec.person_id;
432: End If;
433: If (p_rec.contact_id = hr_api.g_number) then
434: p_rec.contact_id :=
435: ota_cre_shd.g_old_rec.contact_id;

Line 435: ota_cre_shd.g_old_rec.contact_id;

431: ota_cre_shd.g_old_rec.person_id;
432: End If;
433: If (p_rec.contact_id = hr_api.g_number) then
434: p_rec.contact_id :=
435: ota_cre_shd.g_old_rec.contact_id;
436: End If;
437: If (p_rec.certification_status_code = hr_api.g_varchar2) then
438: p_rec.certification_status_code :=
439: ota_cre_shd.g_old_rec.certification_status_code;

Line 439: ota_cre_shd.g_old_rec.certification_status_code;

435: ota_cre_shd.g_old_rec.contact_id;
436: End If;
437: If (p_rec.certification_status_code = hr_api.g_varchar2) then
438: p_rec.certification_status_code :=
439: ota_cre_shd.g_old_rec.certification_status_code;
440: End If;
441: If (p_rec.completion_date = hr_api.g_date) then
442: p_rec.completion_date :=
443: ota_cre_shd.g_old_rec.completion_date;

Line 443: ota_cre_shd.g_old_rec.completion_date;

439: ota_cre_shd.g_old_rec.certification_status_code;
440: End If;
441: If (p_rec.completion_date = hr_api.g_date) then
442: p_rec.completion_date :=
443: ota_cre_shd.g_old_rec.completion_date;
444: End If;
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_cre_shd.g_old_rec.business_group_id;

Line 447: ota_cre_shd.g_old_rec.business_group_id;

443: ota_cre_shd.g_old_rec.completion_date;
444: End If;
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_cre_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.unenrollment_date = hr_api.g_date) then
450: p_rec.unenrollment_date :=
451: ota_cre_shd.g_old_rec.unenrollment_date;

Line 451: ota_cre_shd.g_old_rec.unenrollment_date;

447: ota_cre_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.unenrollment_date = hr_api.g_date) then
450: p_rec.unenrollment_date :=
451: ota_cre_shd.g_old_rec.unenrollment_date;
452: End If;
453: If (p_rec.expiration_date = hr_api.g_date) then
454: p_rec.expiration_date :=
455: ota_cre_shd.g_old_rec.expiration_date;

Line 455: ota_cre_shd.g_old_rec.expiration_date;

451: ota_cre_shd.g_old_rec.unenrollment_date;
452: End If;
453: If (p_rec.expiration_date = hr_api.g_date) then
454: p_rec.expiration_date :=
455: ota_cre_shd.g_old_rec.expiration_date;
456: End If;
457: If (p_rec.earliest_enroll_date = hr_api.g_date) then
458: p_rec.earliest_enroll_date :=
459: ota_cre_shd.g_old_rec.earliest_enroll_date;

Line 459: ota_cre_shd.g_old_rec.earliest_enroll_date;

455: ota_cre_shd.g_old_rec.expiration_date;
456: End If;
457: If (p_rec.earliest_enroll_date = hr_api.g_date) then
458: p_rec.earliest_enroll_date :=
459: ota_cre_shd.g_old_rec.earliest_enroll_date;
460: End If;
461: If (p_rec.is_history_flag = hr_api.g_varchar2) then
462: p_rec.is_history_flag :=
463: ota_cre_shd.g_old_rec.is_history_flag;

Line 463: ota_cre_shd.g_old_rec.is_history_flag;

459: ota_cre_shd.g_old_rec.earliest_enroll_date;
460: End If;
461: If (p_rec.is_history_flag = hr_api.g_varchar2) then
462: p_rec.is_history_flag :=
463: ota_cre_shd.g_old_rec.is_history_flag;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: ota_cre_shd.g_old_rec.attribute_category;

Line 467: ota_cre_shd.g_old_rec.attribute_category;

463: ota_cre_shd.g_old_rec.is_history_flag;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: ota_cre_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: ota_cre_shd.g_old_rec.attribute1;

Line 471: ota_cre_shd.g_old_rec.attribute1;

467: ota_cre_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: ota_cre_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: ota_cre_shd.g_old_rec.attribute2;

Line 475: ota_cre_shd.g_old_rec.attribute2;

471: ota_cre_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: ota_cre_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: ota_cre_shd.g_old_rec.attribute3;

Line 479: ota_cre_shd.g_old_rec.attribute3;

475: ota_cre_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: ota_cre_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: ota_cre_shd.g_old_rec.attribute4;

Line 483: ota_cre_shd.g_old_rec.attribute4;

479: ota_cre_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: ota_cre_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: ota_cre_shd.g_old_rec.attribute5;

Line 487: ota_cre_shd.g_old_rec.attribute5;

483: ota_cre_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: ota_cre_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: ota_cre_shd.g_old_rec.attribute6;

Line 491: ota_cre_shd.g_old_rec.attribute6;

487: ota_cre_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: ota_cre_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: ota_cre_shd.g_old_rec.attribute7;

Line 495: ota_cre_shd.g_old_rec.attribute7;

491: ota_cre_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: ota_cre_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: ota_cre_shd.g_old_rec.attribute8;

Line 499: ota_cre_shd.g_old_rec.attribute8;

495: ota_cre_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: ota_cre_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: ota_cre_shd.g_old_rec.attribute9;

Line 503: ota_cre_shd.g_old_rec.attribute9;

499: ota_cre_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: ota_cre_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: ota_cre_shd.g_old_rec.attribute10;

Line 507: ota_cre_shd.g_old_rec.attribute10;

503: ota_cre_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: ota_cre_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: ota_cre_shd.g_old_rec.attribute11;

Line 511: ota_cre_shd.g_old_rec.attribute11;

507: ota_cre_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: ota_cre_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: ota_cre_shd.g_old_rec.attribute12;

Line 515: ota_cre_shd.g_old_rec.attribute12;

511: ota_cre_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: ota_cre_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: ota_cre_shd.g_old_rec.attribute13;

Line 519: ota_cre_shd.g_old_rec.attribute13;

515: ota_cre_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: ota_cre_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: ota_cre_shd.g_old_rec.attribute14;

Line 523: ota_cre_shd.g_old_rec.attribute14;

519: ota_cre_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: ota_cre_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: ota_cre_shd.g_old_rec.attribute15;

Line 527: ota_cre_shd.g_old_rec.attribute15;

523: ota_cre_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: ota_cre_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: ota_cre_shd.g_old_rec.attribute16;

Line 531: ota_cre_shd.g_old_rec.attribute16;

527: ota_cre_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: ota_cre_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: ota_cre_shd.g_old_rec.attribute17;

Line 535: ota_cre_shd.g_old_rec.attribute17;

531: ota_cre_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: ota_cre_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: ota_cre_shd.g_old_rec.attribute18;

Line 539: ota_cre_shd.g_old_rec.attribute18;

535: ota_cre_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: ota_cre_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: ota_cre_shd.g_old_rec.attribute19;

Line 543: ota_cre_shd.g_old_rec.attribute19;

539: ota_cre_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: ota_cre_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: ota_cre_shd.g_old_rec.attribute20;

Line 547: ota_cre_shd.g_old_rec.attribute20;

543: ota_cre_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: ota_cre_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.enrollment_date = hr_api.g_date) then
550: p_rec.enrollment_date :=
551: ota_cre_shd.g_old_rec.enrollment_date;

Line 551: ota_cre_shd.g_old_rec.enrollment_date;

547: ota_cre_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.enrollment_date = hr_api.g_date) then
550: p_rec.enrollment_date :=
551: ota_cre_shd.g_old_rec.enrollment_date;
552: End If;
553: --
554: End convert_defs;
555: --

Line 561: ,p_rec in out nocopy ota_cre_shd.g_rec_type

557: -- |---------------------------------< upd >----------------------------------|
558: -- ----------------------------------------------------------------------------
559: Procedure upd
560: (p_effective_date in date
561: ,p_rec in out nocopy ota_cre_shd.g_rec_type
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
565: --

Line 571: ota_cre_shd.lck

567: hr_utility.set_location('Entering:'||l_proc, 5);
568: --
569: -- We must lock the row which we need to update.
570: --
571: ota_cre_shd.lck
572: (p_rec.cert_enrollment_id
573: ,p_rec.object_version_number
574: );
575: --

Line 651: l_rec ota_cre_shd.g_rec_type;

647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
649: ) is
650: --
651: l_rec ota_cre_shd.g_rec_type;
652: l_proc varchar2(72) := g_package||'upd';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);

Line 661: ota_cre_shd.convert_args

657: -- Call conversion function to turn arguments into the
658: -- l_rec structure.
659: --
660: l_rec :=
661: ota_cre_shd.convert_args
662: (p_cert_enrollment_id
663: ,p_certification_id
664: ,p_person_id
665: ,p_contact_id