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_CME_UPD dependencies on OTA_CME_SHD

Line 55: (p_rec in out nocopy ota_cme_shd.g_rec_type

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

Line 110: ota_cme_shd.constraint_error

106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ota_cme_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_cme_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_cme_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_cme_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_cme_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_cme_shd.g_rec_type

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

Line 205: ,p_rec in ota_cme_shd.g_rec_type

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

Line 273: => ota_cme_shd.g_old_rec.cert_prd_enrollment_id

269: => p_rec.attribute19
270: ,p_attribute20
271: => p_rec.attribute20
272: ,p_cert_prd_enrollment_id_o
273: => ota_cme_shd.g_old_rec.cert_prd_enrollment_id
274: ,p_cert_member_id_o
275: => ota_cme_shd.g_old_rec.cert_member_id
276: ,p_member_status_code_o
277: => ota_cme_shd.g_old_rec.member_status_code

Line 275: => ota_cme_shd.g_old_rec.cert_member_id

271: => p_rec.attribute20
272: ,p_cert_prd_enrollment_id_o
273: => ota_cme_shd.g_old_rec.cert_prd_enrollment_id
274: ,p_cert_member_id_o
275: => ota_cme_shd.g_old_rec.cert_member_id
276: ,p_member_status_code_o
277: => ota_cme_shd.g_old_rec.member_status_code
278: ,p_completion_date_o
279: => ota_cme_shd.g_old_rec.completion_date

Line 277: => ota_cme_shd.g_old_rec.member_status_code

273: => ota_cme_shd.g_old_rec.cert_prd_enrollment_id
274: ,p_cert_member_id_o
275: => ota_cme_shd.g_old_rec.cert_member_id
276: ,p_member_status_code_o
277: => ota_cme_shd.g_old_rec.member_status_code
278: ,p_completion_date_o
279: => ota_cme_shd.g_old_rec.completion_date
280: ,p_business_group_id_o
281: => ota_cme_shd.g_old_rec.business_group_id

Line 279: => ota_cme_shd.g_old_rec.completion_date

275: => ota_cme_shd.g_old_rec.cert_member_id
276: ,p_member_status_code_o
277: => ota_cme_shd.g_old_rec.member_status_code
278: ,p_completion_date_o
279: => ota_cme_shd.g_old_rec.completion_date
280: ,p_business_group_id_o
281: => ota_cme_shd.g_old_rec.business_group_id
282: ,p_object_version_number_o
283: => ota_cme_shd.g_old_rec.object_version_number

Line 281: => ota_cme_shd.g_old_rec.business_group_id

277: => ota_cme_shd.g_old_rec.member_status_code
278: ,p_completion_date_o
279: => ota_cme_shd.g_old_rec.completion_date
280: ,p_business_group_id_o
281: => ota_cme_shd.g_old_rec.business_group_id
282: ,p_object_version_number_o
283: => ota_cme_shd.g_old_rec.object_version_number
284: ,p_attribute_category_o
285: => ota_cme_shd.g_old_rec.attribute_category

Line 283: => ota_cme_shd.g_old_rec.object_version_number

279: => ota_cme_shd.g_old_rec.completion_date
280: ,p_business_group_id_o
281: => ota_cme_shd.g_old_rec.business_group_id
282: ,p_object_version_number_o
283: => ota_cme_shd.g_old_rec.object_version_number
284: ,p_attribute_category_o
285: => ota_cme_shd.g_old_rec.attribute_category
286: ,p_attribute1_o
287: => ota_cme_shd.g_old_rec.attribute1

Line 285: => ota_cme_shd.g_old_rec.attribute_category

281: => ota_cme_shd.g_old_rec.business_group_id
282: ,p_object_version_number_o
283: => ota_cme_shd.g_old_rec.object_version_number
284: ,p_attribute_category_o
285: => ota_cme_shd.g_old_rec.attribute_category
286: ,p_attribute1_o
287: => ota_cme_shd.g_old_rec.attribute1
288: ,p_attribute2_o
289: => ota_cme_shd.g_old_rec.attribute2

Line 287: => ota_cme_shd.g_old_rec.attribute1

283: => ota_cme_shd.g_old_rec.object_version_number
284: ,p_attribute_category_o
285: => ota_cme_shd.g_old_rec.attribute_category
286: ,p_attribute1_o
287: => ota_cme_shd.g_old_rec.attribute1
288: ,p_attribute2_o
289: => ota_cme_shd.g_old_rec.attribute2
290: ,p_attribute3_o
291: => ota_cme_shd.g_old_rec.attribute3

Line 289: => ota_cme_shd.g_old_rec.attribute2

285: => ota_cme_shd.g_old_rec.attribute_category
286: ,p_attribute1_o
287: => ota_cme_shd.g_old_rec.attribute1
288: ,p_attribute2_o
289: => ota_cme_shd.g_old_rec.attribute2
290: ,p_attribute3_o
291: => ota_cme_shd.g_old_rec.attribute3
292: ,p_attribute4_o
293: => ota_cme_shd.g_old_rec.attribute4

Line 291: => ota_cme_shd.g_old_rec.attribute3

287: => ota_cme_shd.g_old_rec.attribute1
288: ,p_attribute2_o
289: => ota_cme_shd.g_old_rec.attribute2
290: ,p_attribute3_o
291: => ota_cme_shd.g_old_rec.attribute3
292: ,p_attribute4_o
293: => ota_cme_shd.g_old_rec.attribute4
294: ,p_attribute5_o
295: => ota_cme_shd.g_old_rec.attribute5

Line 293: => ota_cme_shd.g_old_rec.attribute4

289: => ota_cme_shd.g_old_rec.attribute2
290: ,p_attribute3_o
291: => ota_cme_shd.g_old_rec.attribute3
292: ,p_attribute4_o
293: => ota_cme_shd.g_old_rec.attribute4
294: ,p_attribute5_o
295: => ota_cme_shd.g_old_rec.attribute5
296: ,p_attribute6_o
297: => ota_cme_shd.g_old_rec.attribute6

Line 295: => ota_cme_shd.g_old_rec.attribute5

291: => ota_cme_shd.g_old_rec.attribute3
292: ,p_attribute4_o
293: => ota_cme_shd.g_old_rec.attribute4
294: ,p_attribute5_o
295: => ota_cme_shd.g_old_rec.attribute5
296: ,p_attribute6_o
297: => ota_cme_shd.g_old_rec.attribute6
298: ,p_attribute7_o
299: => ota_cme_shd.g_old_rec.attribute7

Line 297: => ota_cme_shd.g_old_rec.attribute6

293: => ota_cme_shd.g_old_rec.attribute4
294: ,p_attribute5_o
295: => ota_cme_shd.g_old_rec.attribute5
296: ,p_attribute6_o
297: => ota_cme_shd.g_old_rec.attribute6
298: ,p_attribute7_o
299: => ota_cme_shd.g_old_rec.attribute7
300: ,p_attribute8_o
301: => ota_cme_shd.g_old_rec.attribute8

Line 299: => ota_cme_shd.g_old_rec.attribute7

295: => ota_cme_shd.g_old_rec.attribute5
296: ,p_attribute6_o
297: => ota_cme_shd.g_old_rec.attribute6
298: ,p_attribute7_o
299: => ota_cme_shd.g_old_rec.attribute7
300: ,p_attribute8_o
301: => ota_cme_shd.g_old_rec.attribute8
302: ,p_attribute9_o
303: => ota_cme_shd.g_old_rec.attribute9

Line 301: => ota_cme_shd.g_old_rec.attribute8

297: => ota_cme_shd.g_old_rec.attribute6
298: ,p_attribute7_o
299: => ota_cme_shd.g_old_rec.attribute7
300: ,p_attribute8_o
301: => ota_cme_shd.g_old_rec.attribute8
302: ,p_attribute9_o
303: => ota_cme_shd.g_old_rec.attribute9
304: ,p_attribute10_o
305: => ota_cme_shd.g_old_rec.attribute10

Line 303: => ota_cme_shd.g_old_rec.attribute9

299: => ota_cme_shd.g_old_rec.attribute7
300: ,p_attribute8_o
301: => ota_cme_shd.g_old_rec.attribute8
302: ,p_attribute9_o
303: => ota_cme_shd.g_old_rec.attribute9
304: ,p_attribute10_o
305: => ota_cme_shd.g_old_rec.attribute10
306: ,p_attribute11_o
307: => ota_cme_shd.g_old_rec.attribute11

Line 305: => ota_cme_shd.g_old_rec.attribute10

301: => ota_cme_shd.g_old_rec.attribute8
302: ,p_attribute9_o
303: => ota_cme_shd.g_old_rec.attribute9
304: ,p_attribute10_o
305: => ota_cme_shd.g_old_rec.attribute10
306: ,p_attribute11_o
307: => ota_cme_shd.g_old_rec.attribute11
308: ,p_attribute12_o
309: => ota_cme_shd.g_old_rec.attribute12

Line 307: => ota_cme_shd.g_old_rec.attribute11

303: => ota_cme_shd.g_old_rec.attribute9
304: ,p_attribute10_o
305: => ota_cme_shd.g_old_rec.attribute10
306: ,p_attribute11_o
307: => ota_cme_shd.g_old_rec.attribute11
308: ,p_attribute12_o
309: => ota_cme_shd.g_old_rec.attribute12
310: ,p_attribute13_o
311: => ota_cme_shd.g_old_rec.attribute13

Line 309: => ota_cme_shd.g_old_rec.attribute12

305: => ota_cme_shd.g_old_rec.attribute10
306: ,p_attribute11_o
307: => ota_cme_shd.g_old_rec.attribute11
308: ,p_attribute12_o
309: => ota_cme_shd.g_old_rec.attribute12
310: ,p_attribute13_o
311: => ota_cme_shd.g_old_rec.attribute13
312: ,p_attribute14_o
313: => ota_cme_shd.g_old_rec.attribute14

Line 311: => ota_cme_shd.g_old_rec.attribute13

307: => ota_cme_shd.g_old_rec.attribute11
308: ,p_attribute12_o
309: => ota_cme_shd.g_old_rec.attribute12
310: ,p_attribute13_o
311: => ota_cme_shd.g_old_rec.attribute13
312: ,p_attribute14_o
313: => ota_cme_shd.g_old_rec.attribute14
314: ,p_attribute15_o
315: => ota_cme_shd.g_old_rec.attribute15

Line 313: => ota_cme_shd.g_old_rec.attribute14

309: => ota_cme_shd.g_old_rec.attribute12
310: ,p_attribute13_o
311: => ota_cme_shd.g_old_rec.attribute13
312: ,p_attribute14_o
313: => ota_cme_shd.g_old_rec.attribute14
314: ,p_attribute15_o
315: => ota_cme_shd.g_old_rec.attribute15
316: ,p_attribute16_o
317: => ota_cme_shd.g_old_rec.attribute16

Line 315: => ota_cme_shd.g_old_rec.attribute15

311: => ota_cme_shd.g_old_rec.attribute13
312: ,p_attribute14_o
313: => ota_cme_shd.g_old_rec.attribute14
314: ,p_attribute15_o
315: => ota_cme_shd.g_old_rec.attribute15
316: ,p_attribute16_o
317: => ota_cme_shd.g_old_rec.attribute16
318: ,p_attribute17_o
319: => ota_cme_shd.g_old_rec.attribute17

Line 317: => ota_cme_shd.g_old_rec.attribute16

313: => ota_cme_shd.g_old_rec.attribute14
314: ,p_attribute15_o
315: => ota_cme_shd.g_old_rec.attribute15
316: ,p_attribute16_o
317: => ota_cme_shd.g_old_rec.attribute16
318: ,p_attribute17_o
319: => ota_cme_shd.g_old_rec.attribute17
320: ,p_attribute18_o
321: => ota_cme_shd.g_old_rec.attribute18

Line 319: => ota_cme_shd.g_old_rec.attribute17

315: => ota_cme_shd.g_old_rec.attribute15
316: ,p_attribute16_o
317: => ota_cme_shd.g_old_rec.attribute16
318: ,p_attribute17_o
319: => ota_cme_shd.g_old_rec.attribute17
320: ,p_attribute18_o
321: => ota_cme_shd.g_old_rec.attribute18
322: ,p_attribute19_o
323: => ota_cme_shd.g_old_rec.attribute19

Line 321: => ota_cme_shd.g_old_rec.attribute18

317: => ota_cme_shd.g_old_rec.attribute16
318: ,p_attribute17_o
319: => ota_cme_shd.g_old_rec.attribute17
320: ,p_attribute18_o
321: => ota_cme_shd.g_old_rec.attribute18
322: ,p_attribute19_o
323: => ota_cme_shd.g_old_rec.attribute19
324: ,p_attribute20_o
325: => ota_cme_shd.g_old_rec.attribute20

Line 323: => ota_cme_shd.g_old_rec.attribute19

319: => ota_cme_shd.g_old_rec.attribute17
320: ,p_attribute18_o
321: => ota_cme_shd.g_old_rec.attribute18
322: ,p_attribute19_o
323: => ota_cme_shd.g_old_rec.attribute19
324: ,p_attribute20_o
325: => ota_cme_shd.g_old_rec.attribute20
326: );
327: --

Line 325: => ota_cme_shd.g_old_rec.attribute20

321: => ota_cme_shd.g_old_rec.attribute18
322: ,p_attribute19_o
323: => ota_cme_shd.g_old_rec.attribute19
324: ,p_attribute20_o
325: => ota_cme_shd.g_old_rec.attribute20
326: );
327: --
328: exception
329: --

Line 385: (p_rec in out nocopy ota_cme_shd.g_rec_type

381: --
382: -- {End Of Comments}
383: -- ----------------------------------------------------------------------------
384: Procedure convert_defs
385: (p_rec in out nocopy ota_cme_shd.g_rec_type
386: ) is
387: --
388: Begin
389: --

Line 397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;

393: -- is being used then we must set to the 'current' argument value.
394: --
395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then
396: p_rec.cert_prd_enrollment_id :=
397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;

Line 401: ota_cme_shd.g_old_rec.cert_member_id;

397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;

Line 405: ota_cme_shd.g_old_rec.member_status_code;

401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;

Line 409: ota_cme_shd.g_old_rec.completion_date;

405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;

Line 413: ota_cme_shd.g_old_rec.business_group_id;

409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;

Line 417: ota_cme_shd.g_old_rec.attribute_category;

413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;

Line 421: ota_cme_shd.g_old_rec.attribute1;

417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;

Line 425: ota_cme_shd.g_old_rec.attribute2;

421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;

Line 429: ota_cme_shd.g_old_rec.attribute3;

425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;

Line 433: ota_cme_shd.g_old_rec.attribute4;

429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;

Line 437: ota_cme_shd.g_old_rec.attribute5;

433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;

Line 441: ota_cme_shd.g_old_rec.attribute6;

437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;

Line 445: ota_cme_shd.g_old_rec.attribute7;

441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;

Line 449: ota_cme_shd.g_old_rec.attribute8;

445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;

Line 453: ota_cme_shd.g_old_rec.attribute9;

449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;

Line 457: ota_cme_shd.g_old_rec.attribute10;

453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;

Line 461: ota_cme_shd.g_old_rec.attribute11;

457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;

Line 465: ota_cme_shd.g_old_rec.attribute12;

461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;

Line 469: ota_cme_shd.g_old_rec.attribute13;

465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;

Line 473: ota_cme_shd.g_old_rec.attribute14;

469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;

Line 477: ota_cme_shd.g_old_rec.attribute15;

473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;

Line 481: ota_cme_shd.g_old_rec.attribute16;

477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;

Line 485: ota_cme_shd.g_old_rec.attribute17;

481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;

Line 489: ota_cme_shd.g_old_rec.attribute18;

485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;

Line 493: ota_cme_shd.g_old_rec.attribute19;

489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then
496: p_rec.attribute20 :=
497: ota_cme_shd.g_old_rec.attribute20;

Line 497: ota_cme_shd.g_old_rec.attribute20;

493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then
496: p_rec.attribute20 :=
497: ota_cme_shd.g_old_rec.attribute20;
498: End If;
499: --
500: End convert_defs;
501: --

Line 507: ,p_rec in out nocopy ota_cme_shd.g_rec_type

503: -- |---------------------------------< upd >----------------------------------|
504: -- ----------------------------------------------------------------------------
505: Procedure upd
506: (p_effective_date in date
507: ,p_rec in out nocopy ota_cme_shd.g_rec_type
508: ) is
509: --
510: l_proc varchar2(72) := g_package||'upd';
511: --

Line 517: ota_cme_shd.lck

513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- We must lock the row which we need to update.
516: --
517: ota_cme_shd.lck
518: (p_rec.cert_mbr_enrollment_id
519: ,p_rec.object_version_number
520: );
521: --

Line 591: l_rec ota_cme_shd.g_rec_type;

587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
591: l_rec ota_cme_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'upd';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);

Line 601: ota_cme_shd.convert_args

597: -- Call conversion function to turn arguments into the
598: -- l_rec structure.
599: --
600: l_rec :=
601: ota_cme_shd.convert_args
602: (p_cert_mbr_enrollment_id
603: ,p_cert_prd_enrollment_id
604: ,p_cert_member_id
605: ,p_member_status_code