DBA Data[Home] [Help]

APPS.OTA_CPE_UPD dependencies on OTA_CPE_SHD

Line 55: (p_rec in out nocopy ota_cpe_shd.g_rec_type

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

Line 112: ota_cpe_shd.constraint_error

108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: ota_cpe_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_cpe_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_cpe_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_cpe_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_cpe_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_cpe_shd.g_rec_type

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

Line 207: ,p_rec in ota_cpe_shd.g_rec_type

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

Line 279: => ota_cpe_shd.g_old_rec.cert_enrollment_id

275: => p_rec.attribute20
276: ,p_expiration_date
277: => p_rec.expiration_date
278: ,p_cert_enrollment_id_o
279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code

Line 281: => ota_cpe_shd.g_old_rec.object_version_number

277: => p_rec.expiration_date
278: ,p_cert_enrollment_id_o
279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date

Line 283: => ota_cpe_shd.g_old_rec.period_status_code

279: => ota_cpe_shd.g_old_rec.cert_enrollment_id
280: ,p_object_version_number_o
281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date

Line 285: => ota_cpe_shd.g_old_rec.completion_date

281: => ota_cpe_shd.g_old_rec.object_version_number
282: ,p_period_status_code_o
283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date

Line 287: => ota_cpe_shd.g_old_rec.cert_period_start_date

283: => ota_cpe_shd.g_old_rec.period_status_code
284: ,p_completion_date_o
285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id

Line 289: => ota_cpe_shd.g_old_rec.cert_period_end_date

285: => ota_cpe_shd.g_old_rec.completion_date
286: ,p_cert_period_start_date_o
287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category

Line 291: => ota_cpe_shd.g_old_rec.business_group_id

287: => ota_cpe_shd.g_old_rec.cert_period_start_date
288: ,p_cert_period_end_date_o
289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1

Line 293: => ota_cpe_shd.g_old_rec.attribute_category

289: => ota_cpe_shd.g_old_rec.cert_period_end_date
290: ,p_business_group_id_o
291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2

Line 295: => ota_cpe_shd.g_old_rec.attribute1

291: => ota_cpe_shd.g_old_rec.business_group_id
292: ,p_attribute_category_o
293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3

Line 297: => ota_cpe_shd.g_old_rec.attribute2

293: => ota_cpe_shd.g_old_rec.attribute_category
294: ,p_attribute1_o
295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4

Line 299: => ota_cpe_shd.g_old_rec.attribute3

295: => ota_cpe_shd.g_old_rec.attribute1
296: ,p_attribute2_o
297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5

Line 301: => ota_cpe_shd.g_old_rec.attribute4

297: => ota_cpe_shd.g_old_rec.attribute2
298: ,p_attribute3_o
299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6

Line 303: => ota_cpe_shd.g_old_rec.attribute5

299: => ota_cpe_shd.g_old_rec.attribute3
300: ,p_attribute4_o
301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7

Line 305: => ota_cpe_shd.g_old_rec.attribute6

301: => ota_cpe_shd.g_old_rec.attribute4
302: ,p_attribute5_o
303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8

Line 307: => ota_cpe_shd.g_old_rec.attribute7

303: => ota_cpe_shd.g_old_rec.attribute5
304: ,p_attribute6_o
305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9

Line 309: => ota_cpe_shd.g_old_rec.attribute8

305: => ota_cpe_shd.g_old_rec.attribute6
306: ,p_attribute7_o
307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10

Line 311: => ota_cpe_shd.g_old_rec.attribute9

307: => ota_cpe_shd.g_old_rec.attribute7
308: ,p_attribute8_o
309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11

Line 313: => ota_cpe_shd.g_old_rec.attribute10

309: => ota_cpe_shd.g_old_rec.attribute8
310: ,p_attribute9_o
311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12

Line 315: => ota_cpe_shd.g_old_rec.attribute11

311: => ota_cpe_shd.g_old_rec.attribute9
312: ,p_attribute10_o
313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13

Line 317: => ota_cpe_shd.g_old_rec.attribute12

313: => ota_cpe_shd.g_old_rec.attribute10
314: ,p_attribute11_o
315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14

Line 319: => ota_cpe_shd.g_old_rec.attribute13

315: => ota_cpe_shd.g_old_rec.attribute11
316: ,p_attribute12_o
317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15

Line 321: => ota_cpe_shd.g_old_rec.attribute14

317: => ota_cpe_shd.g_old_rec.attribute12
318: ,p_attribute13_o
319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16

Line 323: => ota_cpe_shd.g_old_rec.attribute15

319: => ota_cpe_shd.g_old_rec.attribute13
320: ,p_attribute14_o
321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17

Line 325: => ota_cpe_shd.g_old_rec.attribute16

321: => ota_cpe_shd.g_old_rec.attribute14
322: ,p_attribute15_o
323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18

Line 327: => ota_cpe_shd.g_old_rec.attribute17

323: => ota_cpe_shd.g_old_rec.attribute15
324: ,p_attribute16_o
325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19

Line 329: => ota_cpe_shd.g_old_rec.attribute18

325: => ota_cpe_shd.g_old_rec.attribute16
326: ,p_attribute17_o
327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20

Line 331: => ota_cpe_shd.g_old_rec.attribute19

327: => ota_cpe_shd.g_old_rec.attribute17
328: ,p_attribute18_o
329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20
334: ,p_expiration_date_o
335: => p_rec.expiration_date

Line 333: => ota_cpe_shd.g_old_rec.attribute20

329: => ota_cpe_shd.g_old_rec.attribute18
330: ,p_attribute19_o
331: => ota_cpe_shd.g_old_rec.attribute19
332: ,p_attribute20_o
333: => ota_cpe_shd.g_old_rec.attribute20
334: ,p_expiration_date_o
335: => p_rec.expiration_date
336: );
337: --

Line 395: (p_rec in out nocopy ota_cpe_shd.g_rec_type

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

Line 407: ota_cpe_shd.g_old_rec.cert_enrollment_id;

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

Line 411: ota_cpe_shd.g_old_rec.period_status_code;

407: ota_cpe_shd.g_old_rec.cert_enrollment_id;
408: End If;
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
410: p_rec.period_status_code :=
411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;

Line 415: ota_cpe_shd.g_old_rec.completion_date;

411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;

Line 419: ota_cpe_shd.g_old_rec.cert_period_start_date;

415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
420: End If;
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
422: p_rec.cert_period_end_date :=
423: ota_cpe_shd.g_old_rec.cert_period_end_date;

Line 423: ota_cpe_shd.g_old_rec.cert_period_end_date;

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

Line 427: ota_cpe_shd.g_old_rec.business_group_id;

423: ota_cpe_shd.g_old_rec.cert_period_end_date;
424: End If;
425: If (p_rec.business_group_id = hr_api.g_number) then
426: p_rec.business_group_id :=
427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;

Line 431: ota_cpe_shd.g_old_rec.attribute_category;

427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;
432: End If;
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
434: p_rec.attribute1 :=
435: ota_cpe_shd.g_old_rec.attribute1;

Line 435: ota_cpe_shd.g_old_rec.attribute1;

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

Line 439: ota_cpe_shd.g_old_rec.attribute2;

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

Line 443: ota_cpe_shd.g_old_rec.attribute3;

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

Line 447: ota_cpe_shd.g_old_rec.attribute4;

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

Line 451: ota_cpe_shd.g_old_rec.attribute5;

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

Line 455: ota_cpe_shd.g_old_rec.attribute6;

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

Line 459: ota_cpe_shd.g_old_rec.attribute7;

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

Line 463: ota_cpe_shd.g_old_rec.attribute8;

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

Line 467: ota_cpe_shd.g_old_rec.attribute9;

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

Line 471: ota_cpe_shd.g_old_rec.attribute10;

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

Line 475: ota_cpe_shd.g_old_rec.attribute11;

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

Line 479: ota_cpe_shd.g_old_rec.attribute12;

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

Line 483: ota_cpe_shd.g_old_rec.attribute13;

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

Line 487: ota_cpe_shd.g_old_rec.attribute14;

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

Line 491: ota_cpe_shd.g_old_rec.attribute15;

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

Line 495: ota_cpe_shd.g_old_rec.attribute16;

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

Line 499: ota_cpe_shd.g_old_rec.attribute17;

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

Line 503: ota_cpe_shd.g_old_rec.attribute18;

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

Line 507: ota_cpe_shd.g_old_rec.attribute19;

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

Line 511: ota_cpe_shd.g_old_rec.attribute20;

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

Line 515: ota_cpe_shd.g_old_rec.expiration_date;

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

Line 525: ,p_rec in out nocopy ota_cpe_shd.g_rec_type

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

Line 535: ota_cpe_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_cpe_shd.lck
536: (p_rec.cert_prd_enrollment_id
537: ,p_rec.object_version_number
538: );
539: --

Line 611: l_rec ota_cpe_shd.g_rec_type;

607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
610: --
611: l_rec ota_cpe_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_cpe_shd.convert_args

617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
620: l_rec :=
621: ota_cpe_shd.convert_args
622: (p_cert_prd_enrollment_id
623: ,p_cert_enrollment_id
624: ,p_object_version_number
625: ,p_period_status_code