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_LPS_UPD dependencies on OTA_LPS_SHD

Line 55: (p_rec in out nocopy ota_lps_shd.g_rec_type

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

Line 120: ota_lps_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_lps_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_lps_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_lps_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_lps_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_lps_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_lps_shd.g_rec_type

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

Line 215: ,p_rec in ota_lps_shd.g_rec_type

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

Line 303: => ota_lps_shd.g_old_rec.business_group_id

299: ,p_public_flag
300: => p_rec.public_flag
301: ,p_competency_update_level => p_rec.competency_update_level
302: ,p_business_group_id_o
303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units

Line 305: => ota_lps_shd.g_old_rec.duration

301: ,p_competency_update_level => p_rec.competency_update_level
302: ,p_business_group_id_o
303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active

Line 307: => ota_lps_shd.g_old_rec.duration_units

303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active

Line 309: => ota_lps_shd.g_old_rec.start_date_active

305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number

Line 311: => ota_lps_shd.g_old_rec.end_date_active

307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category

Line 313: => ota_lps_shd.g_old_rec.object_version_number

309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1

Line 315: => ota_lps_shd.g_old_rec.attribute_category

311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2

Line 317: => ota_lps_shd.g_old_rec.attribute1

313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3

Line 319: => ota_lps_shd.g_old_rec.attribute2

315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4

Line 321: => ota_lps_shd.g_old_rec.attribute3

317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5

Line 323: => ota_lps_shd.g_old_rec.attribute4

319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6

Line 325: => ota_lps_shd.g_old_rec.attribute5

321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7

Line 327: => ota_lps_shd.g_old_rec.attribute6

323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8

Line 329: => ota_lps_shd.g_old_rec.attribute7

325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9

Line 331: => ota_lps_shd.g_old_rec.attribute8

327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10

Line 333: => ota_lps_shd.g_old_rec.attribute9

329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11

Line 335: => ota_lps_shd.g_old_rec.attribute10

331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12

Line 337: => ota_lps_shd.g_old_rec.attribute11

333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13

Line 339: => ota_lps_shd.g_old_rec.attribute12

335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14

Line 341: => ota_lps_shd.g_old_rec.attribute13

337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15

Line 343: => ota_lps_shd.g_old_rec.attribute14

339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16

Line 345: => ota_lps_shd.g_old_rec.attribute15

341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17

Line 347: => ota_lps_shd.g_old_rec.attribute16

343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18

Line 349: => ota_lps_shd.g_old_rec.attribute17

345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19

Line 351: => ota_lps_shd.g_old_rec.attribute18

347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20

Line 353: => ota_lps_shd.g_old_rec.attribute19

349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code

Line 355: => ota_lps_shd.g_old_rec.attribute20

351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code

Line 357: => ota_lps_shd.g_old_rec.path_source_code

353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id

Line 359: => ota_lps_shd.g_old_rec.source_function_code

355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id

Line 361: => ota_lps_shd.g_old_rec.assignment_id

357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target

Line 363: => ota_lps_shd.g_old_rec.source_id

359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id

Line 365: => ota_lps_shd.g_old_rec.notify_days_before_target

361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id

Line 367: => ota_lps_shd.g_old_rec.person_id

363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag

Line 369: => ota_lps_shd.g_old_rec.contact_id

365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag

Line 371: => ota_lps_shd.g_old_rec.display_to_learner_flag

367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );

Line 373: => ota_lps_shd.g_old_rec.public_flag

369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );
376:
377:

Line 374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level

370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );
376:
377:
378: --

Line 437: (p_rec in out nocopy ota_lps_shd.g_rec_type

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

Line 449: ota_lps_shd.g_old_rec.business_group_id;

445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;

Line 453: ota_lps_shd.g_old_rec.duration;

449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;

Line 457: ota_lps_shd.g_old_rec.duration_units;

453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;

Line 461: ota_lps_shd.g_old_rec.attribute_category;

457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;

Line 465: ota_lps_shd.g_old_rec.attribute1;

461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;

Line 469: ota_lps_shd.g_old_rec.attribute2;

465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;

Line 473: ota_lps_shd.g_old_rec.attribute3;

469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;

Line 477: ota_lps_shd.g_old_rec.attribute4;

473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;

Line 481: ota_lps_shd.g_old_rec.attribute5;

477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;

Line 485: ota_lps_shd.g_old_rec.attribute6;

481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;

Line 489: ota_lps_shd.g_old_rec.attribute7;

485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;

Line 493: ota_lps_shd.g_old_rec.attribute8;

489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;

Line 497: ota_lps_shd.g_old_rec.attribute9;

493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;

Line 501: ota_lps_shd.g_old_rec.attribute10;

497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;

Line 505: ota_lps_shd.g_old_rec.attribute11;

501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;

Line 509: ota_lps_shd.g_old_rec.attribute12;

505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;

Line 513: ota_lps_shd.g_old_rec.attribute13;

509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;

Line 517: ota_lps_shd.g_old_rec.attribute14;

513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;

Line 521: ota_lps_shd.g_old_rec.attribute15;

517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;

Line 525: ota_lps_shd.g_old_rec.attribute16;

521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;

Line 529: ota_lps_shd.g_old_rec.attribute17;

525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;

Line 533: ota_lps_shd.g_old_rec.attribute18;

529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;

Line 537: ota_lps_shd.g_old_rec.attribute19;

533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;

Line 541: ota_lps_shd.g_old_rec.attribute20;

537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;

Line 545: ota_lps_shd.g_old_rec.start_date_active;

541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;

Line 549: ota_lps_shd.g_old_rec.end_date_active;

545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;

Line 553: ota_lps_shd.g_old_rec.path_source_code;

549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;

Line 557: ota_lps_shd.g_old_rec.source_function_code;

553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;

Line 561: ota_lps_shd.g_old_rec.assignment_id;

557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;

Line 565: ota_lps_shd.g_old_rec.source_id;

561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;

Line 569: ota_lps_shd.g_old_rec.notify_days_before_target;

565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;

Line 573: ota_lps_shd.g_old_rec.person_id;

569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;

Line 577: ota_lps_shd.g_old_rec.contact_id;

573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;

Line 581: ota_lps_shd.g_old_rec.display_to_learner_flag;

577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;

Line 585: ota_lps_shd.g_old_rec.public_flag;

581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then
588: p_rec.competency_update_level :=
589: ota_lps_shd.g_old_rec.competency_update_level;

Line 589: ota_lps_shd.g_old_rec.competency_update_level;

585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then
588: p_rec.competency_update_level :=
589: ota_lps_shd.g_old_rec.competency_update_level;
590: End If;
591: --
592: End convert_defs;
593: --

Line 599: ,p_rec in out nocopy ota_lps_shd.g_rec_type

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

Line 609: ota_lps_shd.lck

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

Line 693: l_rec ota_lps_shd.g_rec_type;

689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is
692: --
693: l_rec ota_lps_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'upd';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);

Line 703: ota_lps_shd.convert_args

699: -- Call conversion function to turn arguments into the
700: -- l_rec structure.
701: --
702: l_rec :=
703: ota_lps_shd.convert_args
704: (p_learning_path_id
705: ,p_business_group_id
706: ,p_duration
707: ,p_duration_units