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_CRT_UPD dependencies on OTA_CRT_SHD

Line 55: (p_rec in out nocopy ota_crt_shd.g_rec_type

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

Line 120: ota_crt_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_crt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --

Line 125: ota_crt_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_crt_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --

Line 130: ota_crt_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_crt_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;

Line 170: (p_rec in ota_crt_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in ota_crt_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --

Line 215: ,p_rec in ota_crt_shd.g_rec_type

211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in ota_crt_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --

Line 303: => ota_crt_shd.g_old_rec.business_group_id

299: => p_rec.VALIDITY_START_TYPE
300: ,p_COMPETENCY_UPDATE_LEVEL
301: =>p_rec.COMPETENCY_UPDATE_LEVEL
302: ,p_business_group_id_o
303: => ota_crt_shd.g_old_rec.business_group_id
304: ,p_public_flag_o
305: => ota_crt_shd.g_old_rec.public_flag
306: ,p_initial_completion_date_o
307: => ota_crt_shd.g_old_rec.initial_completion_date

Line 305: => ota_crt_shd.g_old_rec.public_flag

301: =>p_rec.COMPETENCY_UPDATE_LEVEL
302: ,p_business_group_id_o
303: => ota_crt_shd.g_old_rec.business_group_id
304: ,p_public_flag_o
305: => ota_crt_shd.g_old_rec.public_flag
306: ,p_initial_completion_date_o
307: => ota_crt_shd.g_old_rec.initial_completion_date
308: ,p_initial_completion_duratio_o
309: => ota_crt_shd.g_old_rec.initial_completion_duration

Line 307: => ota_crt_shd.g_old_rec.initial_completion_date

303: => ota_crt_shd.g_old_rec.business_group_id
304: ,p_public_flag_o
305: => ota_crt_shd.g_old_rec.public_flag
306: ,p_initial_completion_date_o
307: => ota_crt_shd.g_old_rec.initial_completion_date
308: ,p_initial_completion_duratio_o
309: => ota_crt_shd.g_old_rec.initial_completion_duration
310: ,p_initial_compl_duration_uni_o
311: => ota_crt_shd.g_old_rec.initial_compl_duration_units

Line 309: => ota_crt_shd.g_old_rec.initial_completion_duration

305: => ota_crt_shd.g_old_rec.public_flag
306: ,p_initial_completion_date_o
307: => ota_crt_shd.g_old_rec.initial_completion_date
308: ,p_initial_completion_duratio_o
309: => ota_crt_shd.g_old_rec.initial_completion_duration
310: ,p_initial_compl_duration_uni_o
311: => ota_crt_shd.g_old_rec.initial_compl_duration_units
312: ,p_renewal_duration_o
313: => ota_crt_shd.g_old_rec.renewal_duration

Line 311: => ota_crt_shd.g_old_rec.initial_compl_duration_units

307: => ota_crt_shd.g_old_rec.initial_completion_date
308: ,p_initial_completion_duratio_o
309: => ota_crt_shd.g_old_rec.initial_completion_duration
310: ,p_initial_compl_duration_uni_o
311: => ota_crt_shd.g_old_rec.initial_compl_duration_units
312: ,p_renewal_duration_o
313: => ota_crt_shd.g_old_rec.renewal_duration
314: ,p_renewal_duration_units_o
315: => ota_crt_shd.g_old_rec.renewal_duration_units

Line 313: => ota_crt_shd.g_old_rec.renewal_duration

309: => ota_crt_shd.g_old_rec.initial_completion_duration
310: ,p_initial_compl_duration_uni_o
311: => ota_crt_shd.g_old_rec.initial_compl_duration_units
312: ,p_renewal_duration_o
313: => ota_crt_shd.g_old_rec.renewal_duration
314: ,p_renewal_duration_units_o
315: => ota_crt_shd.g_old_rec.renewal_duration_units
316: ,p_notify_days_before_expire_o
317: => ota_crt_shd.g_old_rec.notify_days_before_expire

Line 315: => ota_crt_shd.g_old_rec.renewal_duration_units

311: => ota_crt_shd.g_old_rec.initial_compl_duration_units
312: ,p_renewal_duration_o
313: => ota_crt_shd.g_old_rec.renewal_duration
314: ,p_renewal_duration_units_o
315: => ota_crt_shd.g_old_rec.renewal_duration_units
316: ,p_notify_days_before_expire_o
317: => ota_crt_shd.g_old_rec.notify_days_before_expire
318: ,p_object_version_number_o
319: => ota_crt_shd.g_old_rec.object_version_number

Line 317: => ota_crt_shd.g_old_rec.notify_days_before_expire

313: => ota_crt_shd.g_old_rec.renewal_duration
314: ,p_renewal_duration_units_o
315: => ota_crt_shd.g_old_rec.renewal_duration_units
316: ,p_notify_days_before_expire_o
317: => ota_crt_shd.g_old_rec.notify_days_before_expire
318: ,p_object_version_number_o
319: => ota_crt_shd.g_old_rec.object_version_number
320: ,p_start_date_active_o
321: => ota_crt_shd.g_old_rec.start_date_active

Line 319: => ota_crt_shd.g_old_rec.object_version_number

315: => ota_crt_shd.g_old_rec.renewal_duration_units
316: ,p_notify_days_before_expire_o
317: => ota_crt_shd.g_old_rec.notify_days_before_expire
318: ,p_object_version_number_o
319: => ota_crt_shd.g_old_rec.object_version_number
320: ,p_start_date_active_o
321: => ota_crt_shd.g_old_rec.start_date_active
322: ,p_end_date_active_o
323: => ota_crt_shd.g_old_rec.end_date_active

Line 321: => ota_crt_shd.g_old_rec.start_date_active

317: => ota_crt_shd.g_old_rec.notify_days_before_expire
318: ,p_object_version_number_o
319: => ota_crt_shd.g_old_rec.object_version_number
320: ,p_start_date_active_o
321: => ota_crt_shd.g_old_rec.start_date_active
322: ,p_end_date_active_o
323: => ota_crt_shd.g_old_rec.end_date_active
324: ,p_attribute_category_o
325: => ota_crt_shd.g_old_rec.attribute_category

Line 323: => ota_crt_shd.g_old_rec.end_date_active

319: => ota_crt_shd.g_old_rec.object_version_number
320: ,p_start_date_active_o
321: => ota_crt_shd.g_old_rec.start_date_active
322: ,p_end_date_active_o
323: => ota_crt_shd.g_old_rec.end_date_active
324: ,p_attribute_category_o
325: => ota_crt_shd.g_old_rec.attribute_category
326: ,p_attribute1_o
327: => ota_crt_shd.g_old_rec.attribute1

Line 325: => ota_crt_shd.g_old_rec.attribute_category

321: => ota_crt_shd.g_old_rec.start_date_active
322: ,p_end_date_active_o
323: => ota_crt_shd.g_old_rec.end_date_active
324: ,p_attribute_category_o
325: => ota_crt_shd.g_old_rec.attribute_category
326: ,p_attribute1_o
327: => ota_crt_shd.g_old_rec.attribute1
328: ,p_attribute2_o
329: => ota_crt_shd.g_old_rec.attribute2

Line 327: => ota_crt_shd.g_old_rec.attribute1

323: => ota_crt_shd.g_old_rec.end_date_active
324: ,p_attribute_category_o
325: => ota_crt_shd.g_old_rec.attribute_category
326: ,p_attribute1_o
327: => ota_crt_shd.g_old_rec.attribute1
328: ,p_attribute2_o
329: => ota_crt_shd.g_old_rec.attribute2
330: ,p_attribute3_o
331: => ota_crt_shd.g_old_rec.attribute3

Line 329: => ota_crt_shd.g_old_rec.attribute2

325: => ota_crt_shd.g_old_rec.attribute_category
326: ,p_attribute1_o
327: => ota_crt_shd.g_old_rec.attribute1
328: ,p_attribute2_o
329: => ota_crt_shd.g_old_rec.attribute2
330: ,p_attribute3_o
331: => ota_crt_shd.g_old_rec.attribute3
332: ,p_attribute4_o
333: => ota_crt_shd.g_old_rec.attribute4

Line 331: => ota_crt_shd.g_old_rec.attribute3

327: => ota_crt_shd.g_old_rec.attribute1
328: ,p_attribute2_o
329: => ota_crt_shd.g_old_rec.attribute2
330: ,p_attribute3_o
331: => ota_crt_shd.g_old_rec.attribute3
332: ,p_attribute4_o
333: => ota_crt_shd.g_old_rec.attribute4
334: ,p_attribute5_o
335: => ota_crt_shd.g_old_rec.attribute5

Line 333: => ota_crt_shd.g_old_rec.attribute4

329: => ota_crt_shd.g_old_rec.attribute2
330: ,p_attribute3_o
331: => ota_crt_shd.g_old_rec.attribute3
332: ,p_attribute4_o
333: => ota_crt_shd.g_old_rec.attribute4
334: ,p_attribute5_o
335: => ota_crt_shd.g_old_rec.attribute5
336: ,p_attribute6_o
337: => ota_crt_shd.g_old_rec.attribute6

Line 335: => ota_crt_shd.g_old_rec.attribute5

331: => ota_crt_shd.g_old_rec.attribute3
332: ,p_attribute4_o
333: => ota_crt_shd.g_old_rec.attribute4
334: ,p_attribute5_o
335: => ota_crt_shd.g_old_rec.attribute5
336: ,p_attribute6_o
337: => ota_crt_shd.g_old_rec.attribute6
338: ,p_attribute7_o
339: => ota_crt_shd.g_old_rec.attribute7

Line 337: => ota_crt_shd.g_old_rec.attribute6

333: => ota_crt_shd.g_old_rec.attribute4
334: ,p_attribute5_o
335: => ota_crt_shd.g_old_rec.attribute5
336: ,p_attribute6_o
337: => ota_crt_shd.g_old_rec.attribute6
338: ,p_attribute7_o
339: => ota_crt_shd.g_old_rec.attribute7
340: ,p_attribute8_o
341: => ota_crt_shd.g_old_rec.attribute8

Line 339: => ota_crt_shd.g_old_rec.attribute7

335: => ota_crt_shd.g_old_rec.attribute5
336: ,p_attribute6_o
337: => ota_crt_shd.g_old_rec.attribute6
338: ,p_attribute7_o
339: => ota_crt_shd.g_old_rec.attribute7
340: ,p_attribute8_o
341: => ota_crt_shd.g_old_rec.attribute8
342: ,p_attribute9_o
343: => ota_crt_shd.g_old_rec.attribute9

Line 341: => ota_crt_shd.g_old_rec.attribute8

337: => ota_crt_shd.g_old_rec.attribute6
338: ,p_attribute7_o
339: => ota_crt_shd.g_old_rec.attribute7
340: ,p_attribute8_o
341: => ota_crt_shd.g_old_rec.attribute8
342: ,p_attribute9_o
343: => ota_crt_shd.g_old_rec.attribute9
344: ,p_attribute10_o
345: => ota_crt_shd.g_old_rec.attribute10

Line 343: => ota_crt_shd.g_old_rec.attribute9

339: => ota_crt_shd.g_old_rec.attribute7
340: ,p_attribute8_o
341: => ota_crt_shd.g_old_rec.attribute8
342: ,p_attribute9_o
343: => ota_crt_shd.g_old_rec.attribute9
344: ,p_attribute10_o
345: => ota_crt_shd.g_old_rec.attribute10
346: ,p_attribute11_o
347: => ota_crt_shd.g_old_rec.attribute11

Line 345: => ota_crt_shd.g_old_rec.attribute10

341: => ota_crt_shd.g_old_rec.attribute8
342: ,p_attribute9_o
343: => ota_crt_shd.g_old_rec.attribute9
344: ,p_attribute10_o
345: => ota_crt_shd.g_old_rec.attribute10
346: ,p_attribute11_o
347: => ota_crt_shd.g_old_rec.attribute11
348: ,p_attribute12_o
349: => ota_crt_shd.g_old_rec.attribute12

Line 347: => ota_crt_shd.g_old_rec.attribute11

343: => ota_crt_shd.g_old_rec.attribute9
344: ,p_attribute10_o
345: => ota_crt_shd.g_old_rec.attribute10
346: ,p_attribute11_o
347: => ota_crt_shd.g_old_rec.attribute11
348: ,p_attribute12_o
349: => ota_crt_shd.g_old_rec.attribute12
350: ,p_attribute13_o
351: => ota_crt_shd.g_old_rec.attribute13

Line 349: => ota_crt_shd.g_old_rec.attribute12

345: => ota_crt_shd.g_old_rec.attribute10
346: ,p_attribute11_o
347: => ota_crt_shd.g_old_rec.attribute11
348: ,p_attribute12_o
349: => ota_crt_shd.g_old_rec.attribute12
350: ,p_attribute13_o
351: => ota_crt_shd.g_old_rec.attribute13
352: ,p_attribute14_o
353: => ota_crt_shd.g_old_rec.attribute14

Line 351: => ota_crt_shd.g_old_rec.attribute13

347: => ota_crt_shd.g_old_rec.attribute11
348: ,p_attribute12_o
349: => ota_crt_shd.g_old_rec.attribute12
350: ,p_attribute13_o
351: => ota_crt_shd.g_old_rec.attribute13
352: ,p_attribute14_o
353: => ota_crt_shd.g_old_rec.attribute14
354: ,p_attribute15_o
355: => ota_crt_shd.g_old_rec.attribute15

Line 353: => ota_crt_shd.g_old_rec.attribute14

349: => ota_crt_shd.g_old_rec.attribute12
350: ,p_attribute13_o
351: => ota_crt_shd.g_old_rec.attribute13
352: ,p_attribute14_o
353: => ota_crt_shd.g_old_rec.attribute14
354: ,p_attribute15_o
355: => ota_crt_shd.g_old_rec.attribute15
356: ,p_attribute16_o
357: => ota_crt_shd.g_old_rec.attribute16

Line 355: => ota_crt_shd.g_old_rec.attribute15

351: => ota_crt_shd.g_old_rec.attribute13
352: ,p_attribute14_o
353: => ota_crt_shd.g_old_rec.attribute14
354: ,p_attribute15_o
355: => ota_crt_shd.g_old_rec.attribute15
356: ,p_attribute16_o
357: => ota_crt_shd.g_old_rec.attribute16
358: ,p_attribute17_o
359: => ota_crt_shd.g_old_rec.attribute17

Line 357: => ota_crt_shd.g_old_rec.attribute16

353: => ota_crt_shd.g_old_rec.attribute14
354: ,p_attribute15_o
355: => ota_crt_shd.g_old_rec.attribute15
356: ,p_attribute16_o
357: => ota_crt_shd.g_old_rec.attribute16
358: ,p_attribute17_o
359: => ota_crt_shd.g_old_rec.attribute17
360: ,p_attribute18_o
361: => ota_crt_shd.g_old_rec.attribute18

Line 359: => ota_crt_shd.g_old_rec.attribute17

355: => ota_crt_shd.g_old_rec.attribute15
356: ,p_attribute16_o
357: => ota_crt_shd.g_old_rec.attribute16
358: ,p_attribute17_o
359: => ota_crt_shd.g_old_rec.attribute17
360: ,p_attribute18_o
361: => ota_crt_shd.g_old_rec.attribute18
362: ,p_attribute19_o
363: => ota_crt_shd.g_old_rec.attribute19

Line 361: => ota_crt_shd.g_old_rec.attribute18

357: => ota_crt_shd.g_old_rec.attribute16
358: ,p_attribute17_o
359: => ota_crt_shd.g_old_rec.attribute17
360: ,p_attribute18_o
361: => ota_crt_shd.g_old_rec.attribute18
362: ,p_attribute19_o
363: => ota_crt_shd.g_old_rec.attribute19
364: ,p_attribute20_o
365: => ota_crt_shd.g_old_rec.attribute20

Line 363: => ota_crt_shd.g_old_rec.attribute19

359: => ota_crt_shd.g_old_rec.attribute17
360: ,p_attribute18_o
361: => ota_crt_shd.g_old_rec.attribute18
362: ,p_attribute19_o
363: => ota_crt_shd.g_old_rec.attribute19
364: ,p_attribute20_o
365: => ota_crt_shd.g_old_rec.attribute20
366: ,p_VALIDITY_DURATION_o
367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION

Line 365: => ota_crt_shd.g_old_rec.attribute20

361: => ota_crt_shd.g_old_rec.attribute18
362: ,p_attribute19_o
363: => ota_crt_shd.g_old_rec.attribute19
364: ,p_attribute20_o
365: => ota_crt_shd.g_old_rec.attribute20
366: ,p_VALIDITY_DURATION_o
367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
368: ,p_VALIDITY_DURATION_UNITS_o
369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS

Line 367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION

363: => ota_crt_shd.g_old_rec.attribute19
364: ,p_attribute20_o
365: => ota_crt_shd.g_old_rec.attribute20
366: ,p_VALIDITY_DURATION_o
367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
368: ,p_VALIDITY_DURATION_UNITS_o
369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
370: ,p_RENEWABLE_FLAG_o
371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG

Line 369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS

365: => ota_crt_shd.g_old_rec.attribute20
366: ,p_VALIDITY_DURATION_o
367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
368: ,p_VALIDITY_DURATION_UNITS_o
369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
370: ,p_RENEWABLE_FLAG_o
371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
372: ,p_VALIDITY_START_TYPE_o
373: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE

Line 371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG

367: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
368: ,p_VALIDITY_DURATION_UNITS_o
369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
370: ,p_RENEWABLE_FLAG_o
371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
372: ,p_VALIDITY_START_TYPE_o
373: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
374: ,p_COMPETENCY_UPDATE_LEVEL_o
375: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL

Line 373: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE

369: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
370: ,p_RENEWABLE_FLAG_o
371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
372: ,p_VALIDITY_START_TYPE_o
373: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
374: ,p_COMPETENCY_UPDATE_LEVEL_o
375: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL
376: );
377: --

Line 375: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL

371: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
372: ,p_VALIDITY_START_TYPE_o
373: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
374: ,p_COMPETENCY_UPDATE_LEVEL_o
375: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL
376: );
377: --
378: exception
379: --

Line 435: (p_rec in out nocopy ota_crt_shd.g_rec_type

431: --
432: -- {End Of Comments}
433: -- ----------------------------------------------------------------------------
434: Procedure convert_defs
435: (p_rec in out nocopy ota_crt_shd.g_rec_type
436: ) is
437: --
438: Begin
439: --

Line 447: ota_crt_shd.g_old_rec.business_group_id;

443: -- is being used then we must set to the 'current' argument value.
444: --
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_crt_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.public_flag = hr_api.g_varchar2) then
450: p_rec.public_flag :=
451: ota_crt_shd.g_old_rec.public_flag;

Line 451: ota_crt_shd.g_old_rec.public_flag;

447: ota_crt_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.public_flag = hr_api.g_varchar2) then
450: p_rec.public_flag :=
451: ota_crt_shd.g_old_rec.public_flag;
452: End If;
453: If (p_rec.initial_completion_date = hr_api.g_date) then
454: p_rec.initial_completion_date :=
455: ota_crt_shd.g_old_rec.initial_completion_date;

Line 455: ota_crt_shd.g_old_rec.initial_completion_date;

451: ota_crt_shd.g_old_rec.public_flag;
452: End If;
453: If (p_rec.initial_completion_date = hr_api.g_date) then
454: p_rec.initial_completion_date :=
455: ota_crt_shd.g_old_rec.initial_completion_date;
456: End If;
457: If (p_rec.initial_completion_duration = hr_api.g_number) then
458: p_rec.initial_completion_duration :=
459: ota_crt_shd.g_old_rec.initial_completion_duration;

Line 459: ota_crt_shd.g_old_rec.initial_completion_duration;

455: ota_crt_shd.g_old_rec.initial_completion_date;
456: End If;
457: If (p_rec.initial_completion_duration = hr_api.g_number) then
458: p_rec.initial_completion_duration :=
459: ota_crt_shd.g_old_rec.initial_completion_duration;
460: End If;
461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then
462: p_rec.initial_compl_duration_units :=
463: ota_crt_shd.g_old_rec.initial_compl_duration_units;

Line 463: ota_crt_shd.g_old_rec.initial_compl_duration_units;

459: ota_crt_shd.g_old_rec.initial_completion_duration;
460: End If;
461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then
462: p_rec.initial_compl_duration_units :=
463: ota_crt_shd.g_old_rec.initial_compl_duration_units;
464: End If;
465: If (p_rec.renewal_duration = hr_api.g_number) then
466: p_rec.renewal_duration :=
467: ota_crt_shd.g_old_rec.renewal_duration;

Line 467: ota_crt_shd.g_old_rec.renewal_duration;

463: ota_crt_shd.g_old_rec.initial_compl_duration_units;
464: End If;
465: If (p_rec.renewal_duration = hr_api.g_number) then
466: p_rec.renewal_duration :=
467: ota_crt_shd.g_old_rec.renewal_duration;
468: End If;
469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then
470: p_rec.renewal_duration_units :=
471: ota_crt_shd.g_old_rec.renewal_duration_units;

Line 471: ota_crt_shd.g_old_rec.renewal_duration_units;

467: ota_crt_shd.g_old_rec.renewal_duration;
468: End If;
469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then
470: p_rec.renewal_duration_units :=
471: ota_crt_shd.g_old_rec.renewal_duration_units;
472: End If;
473: If (p_rec.notify_days_before_expire = hr_api.g_number) then
474: p_rec.notify_days_before_expire :=
475: ota_crt_shd.g_old_rec.notify_days_before_expire;

Line 475: ota_crt_shd.g_old_rec.notify_days_before_expire;

471: ota_crt_shd.g_old_rec.renewal_duration_units;
472: End If;
473: If (p_rec.notify_days_before_expire = hr_api.g_number) then
474: p_rec.notify_days_before_expire :=
475: ota_crt_shd.g_old_rec.notify_days_before_expire;
476: End If;
477: If (p_rec.start_date_active = hr_api.g_date) then
478: p_rec.start_date_active :=
479: ota_crt_shd.g_old_rec.start_date_active;

Line 479: ota_crt_shd.g_old_rec.start_date_active;

475: ota_crt_shd.g_old_rec.notify_days_before_expire;
476: End If;
477: If (p_rec.start_date_active = hr_api.g_date) then
478: p_rec.start_date_active :=
479: ota_crt_shd.g_old_rec.start_date_active;
480: End If;
481: If (p_rec.end_date_active = hr_api.g_date) then
482: p_rec.end_date_active :=
483: ota_crt_shd.g_old_rec.end_date_active;

Line 483: ota_crt_shd.g_old_rec.end_date_active;

479: ota_crt_shd.g_old_rec.start_date_active;
480: End If;
481: If (p_rec.end_date_active = hr_api.g_date) then
482: p_rec.end_date_active :=
483: ota_crt_shd.g_old_rec.end_date_active;
484: End If;
485: If (p_rec.attribute_category = hr_api.g_varchar2) then
486: p_rec.attribute_category :=
487: ota_crt_shd.g_old_rec.attribute_category;

Line 487: ota_crt_shd.g_old_rec.attribute_category;

483: ota_crt_shd.g_old_rec.end_date_active;
484: End If;
485: If (p_rec.attribute_category = hr_api.g_varchar2) then
486: p_rec.attribute_category :=
487: ota_crt_shd.g_old_rec.attribute_category;
488: End If;
489: If (p_rec.attribute1 = hr_api.g_varchar2) then
490: p_rec.attribute1 :=
491: ota_crt_shd.g_old_rec.attribute1;

Line 491: ota_crt_shd.g_old_rec.attribute1;

487: ota_crt_shd.g_old_rec.attribute_category;
488: End If;
489: If (p_rec.attribute1 = hr_api.g_varchar2) then
490: p_rec.attribute1 :=
491: ota_crt_shd.g_old_rec.attribute1;
492: End If;
493: If (p_rec.attribute2 = hr_api.g_varchar2) then
494: p_rec.attribute2 :=
495: ota_crt_shd.g_old_rec.attribute2;

Line 495: ota_crt_shd.g_old_rec.attribute2;

491: ota_crt_shd.g_old_rec.attribute1;
492: End If;
493: If (p_rec.attribute2 = hr_api.g_varchar2) then
494: p_rec.attribute2 :=
495: ota_crt_shd.g_old_rec.attribute2;
496: End If;
497: If (p_rec.attribute3 = hr_api.g_varchar2) then
498: p_rec.attribute3 :=
499: ota_crt_shd.g_old_rec.attribute3;

Line 499: ota_crt_shd.g_old_rec.attribute3;

495: ota_crt_shd.g_old_rec.attribute2;
496: End If;
497: If (p_rec.attribute3 = hr_api.g_varchar2) then
498: p_rec.attribute3 :=
499: ota_crt_shd.g_old_rec.attribute3;
500: End If;
501: If (p_rec.attribute4 = hr_api.g_varchar2) then
502: p_rec.attribute4 :=
503: ota_crt_shd.g_old_rec.attribute4;

Line 503: ota_crt_shd.g_old_rec.attribute4;

499: ota_crt_shd.g_old_rec.attribute3;
500: End If;
501: If (p_rec.attribute4 = hr_api.g_varchar2) then
502: p_rec.attribute4 :=
503: ota_crt_shd.g_old_rec.attribute4;
504: End If;
505: If (p_rec.attribute5 = hr_api.g_varchar2) then
506: p_rec.attribute5 :=
507: ota_crt_shd.g_old_rec.attribute5;

Line 507: ota_crt_shd.g_old_rec.attribute5;

503: ota_crt_shd.g_old_rec.attribute4;
504: End If;
505: If (p_rec.attribute5 = hr_api.g_varchar2) then
506: p_rec.attribute5 :=
507: ota_crt_shd.g_old_rec.attribute5;
508: End If;
509: If (p_rec.attribute6 = hr_api.g_varchar2) then
510: p_rec.attribute6 :=
511: ota_crt_shd.g_old_rec.attribute6;

Line 511: ota_crt_shd.g_old_rec.attribute6;

507: ota_crt_shd.g_old_rec.attribute5;
508: End If;
509: If (p_rec.attribute6 = hr_api.g_varchar2) then
510: p_rec.attribute6 :=
511: ota_crt_shd.g_old_rec.attribute6;
512: End If;
513: If (p_rec.attribute7 = hr_api.g_varchar2) then
514: p_rec.attribute7 :=
515: ota_crt_shd.g_old_rec.attribute7;

Line 515: ota_crt_shd.g_old_rec.attribute7;

511: ota_crt_shd.g_old_rec.attribute6;
512: End If;
513: If (p_rec.attribute7 = hr_api.g_varchar2) then
514: p_rec.attribute7 :=
515: ota_crt_shd.g_old_rec.attribute7;
516: End If;
517: If (p_rec.attribute8 = hr_api.g_varchar2) then
518: p_rec.attribute8 :=
519: ota_crt_shd.g_old_rec.attribute8;

Line 519: ota_crt_shd.g_old_rec.attribute8;

515: ota_crt_shd.g_old_rec.attribute7;
516: End If;
517: If (p_rec.attribute8 = hr_api.g_varchar2) then
518: p_rec.attribute8 :=
519: ota_crt_shd.g_old_rec.attribute8;
520: End If;
521: If (p_rec.attribute9 = hr_api.g_varchar2) then
522: p_rec.attribute9 :=
523: ota_crt_shd.g_old_rec.attribute9;

Line 523: ota_crt_shd.g_old_rec.attribute9;

519: ota_crt_shd.g_old_rec.attribute8;
520: End If;
521: If (p_rec.attribute9 = hr_api.g_varchar2) then
522: p_rec.attribute9 :=
523: ota_crt_shd.g_old_rec.attribute9;
524: End If;
525: If (p_rec.attribute10 = hr_api.g_varchar2) then
526: p_rec.attribute10 :=
527: ota_crt_shd.g_old_rec.attribute10;

Line 527: ota_crt_shd.g_old_rec.attribute10;

523: ota_crt_shd.g_old_rec.attribute9;
524: End If;
525: If (p_rec.attribute10 = hr_api.g_varchar2) then
526: p_rec.attribute10 :=
527: ota_crt_shd.g_old_rec.attribute10;
528: End If;
529: If (p_rec.attribute11 = hr_api.g_varchar2) then
530: p_rec.attribute11 :=
531: ota_crt_shd.g_old_rec.attribute11;

Line 531: ota_crt_shd.g_old_rec.attribute11;

527: ota_crt_shd.g_old_rec.attribute10;
528: End If;
529: If (p_rec.attribute11 = hr_api.g_varchar2) then
530: p_rec.attribute11 :=
531: ota_crt_shd.g_old_rec.attribute11;
532: End If;
533: If (p_rec.attribute12 = hr_api.g_varchar2) then
534: p_rec.attribute12 :=
535: ota_crt_shd.g_old_rec.attribute12;

Line 535: ota_crt_shd.g_old_rec.attribute12;

531: ota_crt_shd.g_old_rec.attribute11;
532: End If;
533: If (p_rec.attribute12 = hr_api.g_varchar2) then
534: p_rec.attribute12 :=
535: ota_crt_shd.g_old_rec.attribute12;
536: End If;
537: If (p_rec.attribute13 = hr_api.g_varchar2) then
538: p_rec.attribute13 :=
539: ota_crt_shd.g_old_rec.attribute13;

Line 539: ota_crt_shd.g_old_rec.attribute13;

535: ota_crt_shd.g_old_rec.attribute12;
536: End If;
537: If (p_rec.attribute13 = hr_api.g_varchar2) then
538: p_rec.attribute13 :=
539: ota_crt_shd.g_old_rec.attribute13;
540: End If;
541: If (p_rec.attribute14 = hr_api.g_varchar2) then
542: p_rec.attribute14 :=
543: ota_crt_shd.g_old_rec.attribute14;

Line 543: ota_crt_shd.g_old_rec.attribute14;

539: ota_crt_shd.g_old_rec.attribute13;
540: End If;
541: If (p_rec.attribute14 = hr_api.g_varchar2) then
542: p_rec.attribute14 :=
543: ota_crt_shd.g_old_rec.attribute14;
544: End If;
545: If (p_rec.attribute15 = hr_api.g_varchar2) then
546: p_rec.attribute15 :=
547: ota_crt_shd.g_old_rec.attribute15;

Line 547: ota_crt_shd.g_old_rec.attribute15;

543: ota_crt_shd.g_old_rec.attribute14;
544: End If;
545: If (p_rec.attribute15 = hr_api.g_varchar2) then
546: p_rec.attribute15 :=
547: ota_crt_shd.g_old_rec.attribute15;
548: End If;
549: If (p_rec.attribute16 = hr_api.g_varchar2) then
550: p_rec.attribute16 :=
551: ota_crt_shd.g_old_rec.attribute16;

Line 551: ota_crt_shd.g_old_rec.attribute16;

547: ota_crt_shd.g_old_rec.attribute15;
548: End If;
549: If (p_rec.attribute16 = hr_api.g_varchar2) then
550: p_rec.attribute16 :=
551: ota_crt_shd.g_old_rec.attribute16;
552: End If;
553: If (p_rec.attribute17 = hr_api.g_varchar2) then
554: p_rec.attribute17 :=
555: ota_crt_shd.g_old_rec.attribute17;

Line 555: ota_crt_shd.g_old_rec.attribute17;

551: ota_crt_shd.g_old_rec.attribute16;
552: End If;
553: If (p_rec.attribute17 = hr_api.g_varchar2) then
554: p_rec.attribute17 :=
555: ota_crt_shd.g_old_rec.attribute17;
556: End If;
557: If (p_rec.attribute18 = hr_api.g_varchar2) then
558: p_rec.attribute18 :=
559: ota_crt_shd.g_old_rec.attribute18;

Line 559: ota_crt_shd.g_old_rec.attribute18;

555: ota_crt_shd.g_old_rec.attribute17;
556: End If;
557: If (p_rec.attribute18 = hr_api.g_varchar2) then
558: p_rec.attribute18 :=
559: ota_crt_shd.g_old_rec.attribute18;
560: End If;
561: If (p_rec.attribute19 = hr_api.g_varchar2) then
562: p_rec.attribute19 :=
563: ota_crt_shd.g_old_rec.attribute19;

Line 563: ota_crt_shd.g_old_rec.attribute19;

559: ota_crt_shd.g_old_rec.attribute18;
560: End If;
561: If (p_rec.attribute19 = hr_api.g_varchar2) then
562: p_rec.attribute19 :=
563: ota_crt_shd.g_old_rec.attribute19;
564: End If;
565: If (p_rec.attribute20 = hr_api.g_varchar2) then
566: p_rec.attribute20 :=
567: ota_crt_shd.g_old_rec.attribute20;

Line 567: ota_crt_shd.g_old_rec.attribute20;

563: ota_crt_shd.g_old_rec.attribute19;
564: End If;
565: If (p_rec.attribute20 = hr_api.g_varchar2) then
566: p_rec.attribute20 :=
567: ota_crt_shd.g_old_rec.attribute20;
568: End If;
569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then
570: p_rec.VALIDITY_DURATION :=
571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;

Line 571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;

567: ota_crt_shd.g_old_rec.attribute20;
568: End If;
569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then
570: p_rec.VALIDITY_DURATION :=
571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;
572: End If;
573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then
574: p_rec.VALIDITY_DURATION_UNITS :=
575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;

Line 575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;

571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;
572: End If;
573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then
574: p_rec.VALIDITY_DURATION_UNITS :=
575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;
576: End If;
577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then
578: p_rec.RENEWABLE_FLAG :=
579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;

Line 579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;

575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;
576: End If;
577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then
578: p_rec.RENEWABLE_FLAG :=
579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;
580: End If;
581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then
582: p_rec.VALIDITY_START_TYPE :=
583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;

Line 583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;

579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;
580: End If;
581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then
582: p_rec.VALIDITY_START_TYPE :=
583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;
584: End If;
585: If (p_rec.COMPETENCY_UPDATE_LEVEL = hr_api.g_varchar2) then
586: p_rec.COMPETENCY_UPDATE_LEVEL :=
587: ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL;

Line 587: ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL;

583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;
584: End If;
585: If (p_rec.COMPETENCY_UPDATE_LEVEL = hr_api.g_varchar2) then
586: p_rec.COMPETENCY_UPDATE_LEVEL :=
587: ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL;
588: End If;
589:
590: --
591: End convert_defs;

Line 598: ,p_rec in out nocopy ota_crt_shd.g_rec_type

594: -- |---------------------------------< upd >----------------------------------|
595: -- ----------------------------------------------------------------------------
596: Procedure upd
597: (p_effective_date in date
598: ,p_rec in out nocopy ota_crt_shd.g_rec_type
599: ) is
600: --
601: l_proc varchar2(72) := g_package||'upd';
602: --

Line 608: ota_crt_shd.lck

604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: -- We must lock the row which we need to update.
607: --
608: ota_crt_shd.lck
609: (p_rec.certification_id
610: ,p_rec.object_version_number
611: );
612: --

Line 692: l_rec ota_crt_shd.g_rec_type;

688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
690: ) is
691: --
692: l_rec ota_crt_shd.g_rec_type;
693: l_proc varchar2(72) := g_package||'upd';
694: --
695: Begin
696: hr_utility.set_location('Entering:'||l_proc, 5);

Line 702: ota_crt_shd.convert_args

698: -- Call conversion function to turn arguments into the
699: -- l_rec structure.
700: --
701: l_rec :=
702: ota_crt_shd.convert_args
703: (p_certification_id
704: ,p_business_group_id
705: ,p_public_flag
706: ,p_initial_completion_date