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.PER_PMS_UPD dependencies on PER_PMS_SHD

Line 55: (p_rec in out nocopy per_pms_shd.g_rec_type

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

Line 121: per_pms_shd.constraint_error

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

Line 126: per_pms_shd.constraint_error

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

Line 131: per_pms_shd.constraint_error

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

Line 171: (p_rec in per_pms_shd.g_rec_type

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

Line 216: ,p_rec in per_pms_shd.g_rec_type

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

Line 311: => per_pms_shd.g_old_rec.object_version_number

307: => p_rec.attribute30
308: ,p_duplicate_name_warning
309: => p_duplicate_name_warning
310: ,p_object_version_number_o
311: => per_pms_shd.g_old_rec.object_version_number
312: ,p_scorecard_name_o
313: => per_pms_shd.g_old_rec.scorecard_name
314: ,p_person_id_o
315: => per_pms_shd.g_old_rec.person_id

Line 313: => per_pms_shd.g_old_rec.scorecard_name

309: => p_duplicate_name_warning
310: ,p_object_version_number_o
311: => per_pms_shd.g_old_rec.object_version_number
312: ,p_scorecard_name_o
313: => per_pms_shd.g_old_rec.scorecard_name
314: ,p_person_id_o
315: => per_pms_shd.g_old_rec.person_id
316: ,p_assignment_id_o
317: => per_pms_shd.g_old_rec.assignment_id

Line 315: => per_pms_shd.g_old_rec.person_id

311: => per_pms_shd.g_old_rec.object_version_number
312: ,p_scorecard_name_o
313: => per_pms_shd.g_old_rec.scorecard_name
314: ,p_person_id_o
315: => per_pms_shd.g_old_rec.person_id
316: ,p_assignment_id_o
317: => per_pms_shd.g_old_rec.assignment_id
318: ,p_start_date_o
319: => per_pms_shd.g_old_rec.start_date

Line 317: => per_pms_shd.g_old_rec.assignment_id

313: => per_pms_shd.g_old_rec.scorecard_name
314: ,p_person_id_o
315: => per_pms_shd.g_old_rec.person_id
316: ,p_assignment_id_o
317: => per_pms_shd.g_old_rec.assignment_id
318: ,p_start_date_o
319: => per_pms_shd.g_old_rec.start_date
320: ,p_end_date_o
321: => per_pms_shd.g_old_rec.end_date

Line 319: => per_pms_shd.g_old_rec.start_date

315: => per_pms_shd.g_old_rec.person_id
316: ,p_assignment_id_o
317: => per_pms_shd.g_old_rec.assignment_id
318: ,p_start_date_o
319: => per_pms_shd.g_old_rec.start_date
320: ,p_end_date_o
321: => per_pms_shd.g_old_rec.end_date
322: ,p_plan_id_o
323: => per_pms_shd.g_old_rec.plan_id

Line 321: => per_pms_shd.g_old_rec.end_date

317: => per_pms_shd.g_old_rec.assignment_id
318: ,p_start_date_o
319: => per_pms_shd.g_old_rec.start_date
320: ,p_end_date_o
321: => per_pms_shd.g_old_rec.end_date
322: ,p_plan_id_o
323: => per_pms_shd.g_old_rec.plan_id
324: ,p_status_code_o
325: => per_pms_shd.g_old_rec.status_code

Line 323: => per_pms_shd.g_old_rec.plan_id

319: => per_pms_shd.g_old_rec.start_date
320: ,p_end_date_o
321: => per_pms_shd.g_old_rec.end_date
322: ,p_plan_id_o
323: => per_pms_shd.g_old_rec.plan_id
324: ,p_status_code_o
325: => per_pms_shd.g_old_rec.status_code
326: ,p_creator_type_o
327: => per_pms_shd.g_old_rec.creator_type

Line 325: => per_pms_shd.g_old_rec.status_code

321: => per_pms_shd.g_old_rec.end_date
322: ,p_plan_id_o
323: => per_pms_shd.g_old_rec.plan_id
324: ,p_status_code_o
325: => per_pms_shd.g_old_rec.status_code
326: ,p_creator_type_o
327: => per_pms_shd.g_old_rec.creator_type
328: ,p_error_log_o
329: => per_pms_shd.g_old_rec.error_log

Line 327: => per_pms_shd.g_old_rec.creator_type

323: => per_pms_shd.g_old_rec.plan_id
324: ,p_status_code_o
325: => per_pms_shd.g_old_rec.status_code
326: ,p_creator_type_o
327: => per_pms_shd.g_old_rec.creator_type
328: ,p_error_log_o
329: => per_pms_shd.g_old_rec.error_log
330: ,p_attribute_category_o
331: => per_pms_shd.g_old_rec.attribute_category

Line 329: => per_pms_shd.g_old_rec.error_log

325: => per_pms_shd.g_old_rec.status_code
326: ,p_creator_type_o
327: => per_pms_shd.g_old_rec.creator_type
328: ,p_error_log_o
329: => per_pms_shd.g_old_rec.error_log
330: ,p_attribute_category_o
331: => per_pms_shd.g_old_rec.attribute_category
332: ,p_attribute1_o
333: => per_pms_shd.g_old_rec.attribute1

Line 331: => per_pms_shd.g_old_rec.attribute_category

327: => per_pms_shd.g_old_rec.creator_type
328: ,p_error_log_o
329: => per_pms_shd.g_old_rec.error_log
330: ,p_attribute_category_o
331: => per_pms_shd.g_old_rec.attribute_category
332: ,p_attribute1_o
333: => per_pms_shd.g_old_rec.attribute1
334: ,p_attribute2_o
335: => per_pms_shd.g_old_rec.attribute2

Line 333: => per_pms_shd.g_old_rec.attribute1

329: => per_pms_shd.g_old_rec.error_log
330: ,p_attribute_category_o
331: => per_pms_shd.g_old_rec.attribute_category
332: ,p_attribute1_o
333: => per_pms_shd.g_old_rec.attribute1
334: ,p_attribute2_o
335: => per_pms_shd.g_old_rec.attribute2
336: ,p_attribute3_o
337: => per_pms_shd.g_old_rec.attribute3

Line 335: => per_pms_shd.g_old_rec.attribute2

331: => per_pms_shd.g_old_rec.attribute_category
332: ,p_attribute1_o
333: => per_pms_shd.g_old_rec.attribute1
334: ,p_attribute2_o
335: => per_pms_shd.g_old_rec.attribute2
336: ,p_attribute3_o
337: => per_pms_shd.g_old_rec.attribute3
338: ,p_attribute4_o
339: => per_pms_shd.g_old_rec.attribute4

Line 337: => per_pms_shd.g_old_rec.attribute3

333: => per_pms_shd.g_old_rec.attribute1
334: ,p_attribute2_o
335: => per_pms_shd.g_old_rec.attribute2
336: ,p_attribute3_o
337: => per_pms_shd.g_old_rec.attribute3
338: ,p_attribute4_o
339: => per_pms_shd.g_old_rec.attribute4
340: ,p_attribute5_o
341: => per_pms_shd.g_old_rec.attribute5

Line 339: => per_pms_shd.g_old_rec.attribute4

335: => per_pms_shd.g_old_rec.attribute2
336: ,p_attribute3_o
337: => per_pms_shd.g_old_rec.attribute3
338: ,p_attribute4_o
339: => per_pms_shd.g_old_rec.attribute4
340: ,p_attribute5_o
341: => per_pms_shd.g_old_rec.attribute5
342: ,p_attribute6_o
343: => per_pms_shd.g_old_rec.attribute6

Line 341: => per_pms_shd.g_old_rec.attribute5

337: => per_pms_shd.g_old_rec.attribute3
338: ,p_attribute4_o
339: => per_pms_shd.g_old_rec.attribute4
340: ,p_attribute5_o
341: => per_pms_shd.g_old_rec.attribute5
342: ,p_attribute6_o
343: => per_pms_shd.g_old_rec.attribute6
344: ,p_attribute7_o
345: => per_pms_shd.g_old_rec.attribute7

Line 343: => per_pms_shd.g_old_rec.attribute6

339: => per_pms_shd.g_old_rec.attribute4
340: ,p_attribute5_o
341: => per_pms_shd.g_old_rec.attribute5
342: ,p_attribute6_o
343: => per_pms_shd.g_old_rec.attribute6
344: ,p_attribute7_o
345: => per_pms_shd.g_old_rec.attribute7
346: ,p_attribute8_o
347: => per_pms_shd.g_old_rec.attribute8

Line 345: => per_pms_shd.g_old_rec.attribute7

341: => per_pms_shd.g_old_rec.attribute5
342: ,p_attribute6_o
343: => per_pms_shd.g_old_rec.attribute6
344: ,p_attribute7_o
345: => per_pms_shd.g_old_rec.attribute7
346: ,p_attribute8_o
347: => per_pms_shd.g_old_rec.attribute8
348: ,p_attribute9_o
349: => per_pms_shd.g_old_rec.attribute9

Line 347: => per_pms_shd.g_old_rec.attribute8

343: => per_pms_shd.g_old_rec.attribute6
344: ,p_attribute7_o
345: => per_pms_shd.g_old_rec.attribute7
346: ,p_attribute8_o
347: => per_pms_shd.g_old_rec.attribute8
348: ,p_attribute9_o
349: => per_pms_shd.g_old_rec.attribute9
350: ,p_attribute10_o
351: => per_pms_shd.g_old_rec.attribute10

Line 349: => per_pms_shd.g_old_rec.attribute9

345: => per_pms_shd.g_old_rec.attribute7
346: ,p_attribute8_o
347: => per_pms_shd.g_old_rec.attribute8
348: ,p_attribute9_o
349: => per_pms_shd.g_old_rec.attribute9
350: ,p_attribute10_o
351: => per_pms_shd.g_old_rec.attribute10
352: ,p_attribute11_o
353: => per_pms_shd.g_old_rec.attribute11

Line 351: => per_pms_shd.g_old_rec.attribute10

347: => per_pms_shd.g_old_rec.attribute8
348: ,p_attribute9_o
349: => per_pms_shd.g_old_rec.attribute9
350: ,p_attribute10_o
351: => per_pms_shd.g_old_rec.attribute10
352: ,p_attribute11_o
353: => per_pms_shd.g_old_rec.attribute11
354: ,p_attribute12_o
355: => per_pms_shd.g_old_rec.attribute12

Line 353: => per_pms_shd.g_old_rec.attribute11

349: => per_pms_shd.g_old_rec.attribute9
350: ,p_attribute10_o
351: => per_pms_shd.g_old_rec.attribute10
352: ,p_attribute11_o
353: => per_pms_shd.g_old_rec.attribute11
354: ,p_attribute12_o
355: => per_pms_shd.g_old_rec.attribute12
356: ,p_attribute13_o
357: => per_pms_shd.g_old_rec.attribute13

Line 355: => per_pms_shd.g_old_rec.attribute12

351: => per_pms_shd.g_old_rec.attribute10
352: ,p_attribute11_o
353: => per_pms_shd.g_old_rec.attribute11
354: ,p_attribute12_o
355: => per_pms_shd.g_old_rec.attribute12
356: ,p_attribute13_o
357: => per_pms_shd.g_old_rec.attribute13
358: ,p_attribute14_o
359: => per_pms_shd.g_old_rec.attribute14

Line 357: => per_pms_shd.g_old_rec.attribute13

353: => per_pms_shd.g_old_rec.attribute11
354: ,p_attribute12_o
355: => per_pms_shd.g_old_rec.attribute12
356: ,p_attribute13_o
357: => per_pms_shd.g_old_rec.attribute13
358: ,p_attribute14_o
359: => per_pms_shd.g_old_rec.attribute14
360: ,p_attribute15_o
361: => per_pms_shd.g_old_rec.attribute15

Line 359: => per_pms_shd.g_old_rec.attribute14

355: => per_pms_shd.g_old_rec.attribute12
356: ,p_attribute13_o
357: => per_pms_shd.g_old_rec.attribute13
358: ,p_attribute14_o
359: => per_pms_shd.g_old_rec.attribute14
360: ,p_attribute15_o
361: => per_pms_shd.g_old_rec.attribute15
362: ,p_attribute16_o
363: => per_pms_shd.g_old_rec.attribute16

Line 361: => per_pms_shd.g_old_rec.attribute15

357: => per_pms_shd.g_old_rec.attribute13
358: ,p_attribute14_o
359: => per_pms_shd.g_old_rec.attribute14
360: ,p_attribute15_o
361: => per_pms_shd.g_old_rec.attribute15
362: ,p_attribute16_o
363: => per_pms_shd.g_old_rec.attribute16
364: ,p_attribute17_o
365: => per_pms_shd.g_old_rec.attribute17

Line 363: => per_pms_shd.g_old_rec.attribute16

359: => per_pms_shd.g_old_rec.attribute14
360: ,p_attribute15_o
361: => per_pms_shd.g_old_rec.attribute15
362: ,p_attribute16_o
363: => per_pms_shd.g_old_rec.attribute16
364: ,p_attribute17_o
365: => per_pms_shd.g_old_rec.attribute17
366: ,p_attribute18_o
367: => per_pms_shd.g_old_rec.attribute18

Line 365: => per_pms_shd.g_old_rec.attribute17

361: => per_pms_shd.g_old_rec.attribute15
362: ,p_attribute16_o
363: => per_pms_shd.g_old_rec.attribute16
364: ,p_attribute17_o
365: => per_pms_shd.g_old_rec.attribute17
366: ,p_attribute18_o
367: => per_pms_shd.g_old_rec.attribute18
368: ,p_attribute19_o
369: => per_pms_shd.g_old_rec.attribute19

Line 367: => per_pms_shd.g_old_rec.attribute18

363: => per_pms_shd.g_old_rec.attribute16
364: ,p_attribute17_o
365: => per_pms_shd.g_old_rec.attribute17
366: ,p_attribute18_o
367: => per_pms_shd.g_old_rec.attribute18
368: ,p_attribute19_o
369: => per_pms_shd.g_old_rec.attribute19
370: ,p_attribute20_o
371: => per_pms_shd.g_old_rec.attribute20

Line 369: => per_pms_shd.g_old_rec.attribute19

365: => per_pms_shd.g_old_rec.attribute17
366: ,p_attribute18_o
367: => per_pms_shd.g_old_rec.attribute18
368: ,p_attribute19_o
369: => per_pms_shd.g_old_rec.attribute19
370: ,p_attribute20_o
371: => per_pms_shd.g_old_rec.attribute20
372: ,p_attribute21_o
373: => per_pms_shd.g_old_rec.attribute21

Line 371: => per_pms_shd.g_old_rec.attribute20

367: => per_pms_shd.g_old_rec.attribute18
368: ,p_attribute19_o
369: => per_pms_shd.g_old_rec.attribute19
370: ,p_attribute20_o
371: => per_pms_shd.g_old_rec.attribute20
372: ,p_attribute21_o
373: => per_pms_shd.g_old_rec.attribute21
374: ,p_attribute22_o
375: => per_pms_shd.g_old_rec.attribute22

Line 373: => per_pms_shd.g_old_rec.attribute21

369: => per_pms_shd.g_old_rec.attribute19
370: ,p_attribute20_o
371: => per_pms_shd.g_old_rec.attribute20
372: ,p_attribute21_o
373: => per_pms_shd.g_old_rec.attribute21
374: ,p_attribute22_o
375: => per_pms_shd.g_old_rec.attribute22
376: ,p_attribute23_o
377: => per_pms_shd.g_old_rec.attribute23

Line 375: => per_pms_shd.g_old_rec.attribute22

371: => per_pms_shd.g_old_rec.attribute20
372: ,p_attribute21_o
373: => per_pms_shd.g_old_rec.attribute21
374: ,p_attribute22_o
375: => per_pms_shd.g_old_rec.attribute22
376: ,p_attribute23_o
377: => per_pms_shd.g_old_rec.attribute23
378: ,p_attribute24_o
379: => per_pms_shd.g_old_rec.attribute24

Line 377: => per_pms_shd.g_old_rec.attribute23

373: => per_pms_shd.g_old_rec.attribute21
374: ,p_attribute22_o
375: => per_pms_shd.g_old_rec.attribute22
376: ,p_attribute23_o
377: => per_pms_shd.g_old_rec.attribute23
378: ,p_attribute24_o
379: => per_pms_shd.g_old_rec.attribute24
380: ,p_attribute25_o
381: => per_pms_shd.g_old_rec.attribute25

Line 379: => per_pms_shd.g_old_rec.attribute24

375: => per_pms_shd.g_old_rec.attribute22
376: ,p_attribute23_o
377: => per_pms_shd.g_old_rec.attribute23
378: ,p_attribute24_o
379: => per_pms_shd.g_old_rec.attribute24
380: ,p_attribute25_o
381: => per_pms_shd.g_old_rec.attribute25
382: ,p_attribute26_o
383: => per_pms_shd.g_old_rec.attribute26

Line 381: => per_pms_shd.g_old_rec.attribute25

377: => per_pms_shd.g_old_rec.attribute23
378: ,p_attribute24_o
379: => per_pms_shd.g_old_rec.attribute24
380: ,p_attribute25_o
381: => per_pms_shd.g_old_rec.attribute25
382: ,p_attribute26_o
383: => per_pms_shd.g_old_rec.attribute26
384: ,p_attribute27_o
385: => per_pms_shd.g_old_rec.attribute27

Line 383: => per_pms_shd.g_old_rec.attribute26

379: => per_pms_shd.g_old_rec.attribute24
380: ,p_attribute25_o
381: => per_pms_shd.g_old_rec.attribute25
382: ,p_attribute26_o
383: => per_pms_shd.g_old_rec.attribute26
384: ,p_attribute27_o
385: => per_pms_shd.g_old_rec.attribute27
386: ,p_attribute28_o
387: => per_pms_shd.g_old_rec.attribute28

Line 385: => per_pms_shd.g_old_rec.attribute27

381: => per_pms_shd.g_old_rec.attribute25
382: ,p_attribute26_o
383: => per_pms_shd.g_old_rec.attribute26
384: ,p_attribute27_o
385: => per_pms_shd.g_old_rec.attribute27
386: ,p_attribute28_o
387: => per_pms_shd.g_old_rec.attribute28
388: ,p_attribute29_o
389: => per_pms_shd.g_old_rec.attribute29

Line 387: => per_pms_shd.g_old_rec.attribute28

383: => per_pms_shd.g_old_rec.attribute26
384: ,p_attribute27_o
385: => per_pms_shd.g_old_rec.attribute27
386: ,p_attribute28_o
387: => per_pms_shd.g_old_rec.attribute28
388: ,p_attribute29_o
389: => per_pms_shd.g_old_rec.attribute29
390: ,p_attribute30_o
391: => per_pms_shd.g_old_rec.attribute30

Line 389: => per_pms_shd.g_old_rec.attribute29

385: => per_pms_shd.g_old_rec.attribute27
386: ,p_attribute28_o
387: => per_pms_shd.g_old_rec.attribute28
388: ,p_attribute29_o
389: => per_pms_shd.g_old_rec.attribute29
390: ,p_attribute30_o
391: => per_pms_shd.g_old_rec.attribute30
392: );
393: --

Line 391: => per_pms_shd.g_old_rec.attribute30

387: => per_pms_shd.g_old_rec.attribute28
388: ,p_attribute29_o
389: => per_pms_shd.g_old_rec.attribute29
390: ,p_attribute30_o
391: => per_pms_shd.g_old_rec.attribute30
392: );
393: --
394: exception
395: --

Line 451: (p_rec in out nocopy per_pms_shd.g_rec_type

447: --
448: -- {End Of Comments}
449: -- ----------------------------------------------------------------------------
450: Procedure convert_defs
451: (p_rec in out nocopy per_pms_shd.g_rec_type
452: ) is
453: --
454: Begin
455: --

Line 463: per_pms_shd.g_old_rec.scorecard_name;

459: -- is being used then we must set to the 'current' argument value.
460: --
461: If (p_rec.scorecard_name = hr_api.g_varchar2) then
462: p_rec.scorecard_name :=
463: per_pms_shd.g_old_rec.scorecard_name;
464: End If;
465: If (p_rec.person_id = hr_api.g_number) then
466: p_rec.person_id :=
467: per_pms_shd.g_old_rec.person_id;

Line 467: per_pms_shd.g_old_rec.person_id;

463: per_pms_shd.g_old_rec.scorecard_name;
464: End If;
465: If (p_rec.person_id = hr_api.g_number) then
466: p_rec.person_id :=
467: per_pms_shd.g_old_rec.person_id;
468: End If;
469: If (p_rec.assignment_id = hr_api.g_number) then
470: p_rec.assignment_id :=
471: per_pms_shd.g_old_rec.assignment_id;

Line 471: per_pms_shd.g_old_rec.assignment_id;

467: per_pms_shd.g_old_rec.person_id;
468: End If;
469: If (p_rec.assignment_id = hr_api.g_number) then
470: p_rec.assignment_id :=
471: per_pms_shd.g_old_rec.assignment_id;
472: End If;
473: If (p_rec.start_date = hr_api.g_date) then
474: p_rec.start_date :=
475: per_pms_shd.g_old_rec.start_date;

Line 475: per_pms_shd.g_old_rec.start_date;

471: per_pms_shd.g_old_rec.assignment_id;
472: End If;
473: If (p_rec.start_date = hr_api.g_date) then
474: p_rec.start_date :=
475: per_pms_shd.g_old_rec.start_date;
476: End If;
477: If (p_rec.end_date = hr_api.g_date) then
478: p_rec.end_date :=
479: per_pms_shd.g_old_rec.end_date;

Line 479: per_pms_shd.g_old_rec.end_date;

475: per_pms_shd.g_old_rec.start_date;
476: End If;
477: If (p_rec.end_date = hr_api.g_date) then
478: p_rec.end_date :=
479: per_pms_shd.g_old_rec.end_date;
480: End If;
481: If (p_rec.plan_id = hr_api.g_number) then
482: p_rec.plan_id :=
483: per_pms_shd.g_old_rec.plan_id;

Line 483: per_pms_shd.g_old_rec.plan_id;

479: per_pms_shd.g_old_rec.end_date;
480: End If;
481: If (p_rec.plan_id = hr_api.g_number) then
482: p_rec.plan_id :=
483: per_pms_shd.g_old_rec.plan_id;
484: End If;
485: If (p_rec.status_code = hr_api.g_varchar2) then
486: p_rec.status_code :=
487: per_pms_shd.g_old_rec.status_code;

Line 487: per_pms_shd.g_old_rec.status_code;

483: per_pms_shd.g_old_rec.plan_id;
484: End If;
485: If (p_rec.status_code = hr_api.g_varchar2) then
486: p_rec.status_code :=
487: per_pms_shd.g_old_rec.status_code;
488: End If;
489: If (p_rec.creator_type = hr_api.g_varchar2) then
490: p_rec.creator_type :=
491: per_pms_shd.g_old_rec.creator_type;

Line 491: per_pms_shd.g_old_rec.creator_type;

487: per_pms_shd.g_old_rec.status_code;
488: End If;
489: If (p_rec.creator_type = hr_api.g_varchar2) then
490: p_rec.creator_type :=
491: per_pms_shd.g_old_rec.creator_type;
492: End If;
493: If (p_rec.error_log = hr_api.g_varchar2) then
494: p_rec.error_log :=
495: per_pms_shd.g_old_rec.error_log;

Line 495: per_pms_shd.g_old_rec.error_log;

491: per_pms_shd.g_old_rec.creator_type;
492: End If;
493: If (p_rec.error_log = hr_api.g_varchar2) then
494: p_rec.error_log :=
495: per_pms_shd.g_old_rec.error_log;
496: End If;
497: If (p_rec.attribute_category = hr_api.g_varchar2) then
498: p_rec.attribute_category :=
499: per_pms_shd.g_old_rec.attribute_category;

Line 499: per_pms_shd.g_old_rec.attribute_category;

495: per_pms_shd.g_old_rec.error_log;
496: End If;
497: If (p_rec.attribute_category = hr_api.g_varchar2) then
498: p_rec.attribute_category :=
499: per_pms_shd.g_old_rec.attribute_category;
500: End If;
501: If (p_rec.attribute1 = hr_api.g_varchar2) then
502: p_rec.attribute1 :=
503: per_pms_shd.g_old_rec.attribute1;

Line 503: per_pms_shd.g_old_rec.attribute1;

499: per_pms_shd.g_old_rec.attribute_category;
500: End If;
501: If (p_rec.attribute1 = hr_api.g_varchar2) then
502: p_rec.attribute1 :=
503: per_pms_shd.g_old_rec.attribute1;
504: End If;
505: If (p_rec.attribute2 = hr_api.g_varchar2) then
506: p_rec.attribute2 :=
507: per_pms_shd.g_old_rec.attribute2;

Line 507: per_pms_shd.g_old_rec.attribute2;

503: per_pms_shd.g_old_rec.attribute1;
504: End If;
505: If (p_rec.attribute2 = hr_api.g_varchar2) then
506: p_rec.attribute2 :=
507: per_pms_shd.g_old_rec.attribute2;
508: End If;
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=
511: per_pms_shd.g_old_rec.attribute3;

Line 511: per_pms_shd.g_old_rec.attribute3;

507: per_pms_shd.g_old_rec.attribute2;
508: End If;
509: If (p_rec.attribute3 = hr_api.g_varchar2) then
510: p_rec.attribute3 :=
511: per_pms_shd.g_old_rec.attribute3;
512: End If;
513: If (p_rec.attribute4 = hr_api.g_varchar2) then
514: p_rec.attribute4 :=
515: per_pms_shd.g_old_rec.attribute4;

Line 515: per_pms_shd.g_old_rec.attribute4;

511: per_pms_shd.g_old_rec.attribute3;
512: End If;
513: If (p_rec.attribute4 = hr_api.g_varchar2) then
514: p_rec.attribute4 :=
515: per_pms_shd.g_old_rec.attribute4;
516: End If;
517: If (p_rec.attribute5 = hr_api.g_varchar2) then
518: p_rec.attribute5 :=
519: per_pms_shd.g_old_rec.attribute5;

Line 519: per_pms_shd.g_old_rec.attribute5;

515: per_pms_shd.g_old_rec.attribute4;
516: End If;
517: If (p_rec.attribute5 = hr_api.g_varchar2) then
518: p_rec.attribute5 :=
519: per_pms_shd.g_old_rec.attribute5;
520: End If;
521: If (p_rec.attribute6 = hr_api.g_varchar2) then
522: p_rec.attribute6 :=
523: per_pms_shd.g_old_rec.attribute6;

Line 523: per_pms_shd.g_old_rec.attribute6;

519: per_pms_shd.g_old_rec.attribute5;
520: End If;
521: If (p_rec.attribute6 = hr_api.g_varchar2) then
522: p_rec.attribute6 :=
523: per_pms_shd.g_old_rec.attribute6;
524: End If;
525: If (p_rec.attribute7 = hr_api.g_varchar2) then
526: p_rec.attribute7 :=
527: per_pms_shd.g_old_rec.attribute7;

Line 527: per_pms_shd.g_old_rec.attribute7;

523: per_pms_shd.g_old_rec.attribute6;
524: End If;
525: If (p_rec.attribute7 = hr_api.g_varchar2) then
526: p_rec.attribute7 :=
527: per_pms_shd.g_old_rec.attribute7;
528: End If;
529: If (p_rec.attribute8 = hr_api.g_varchar2) then
530: p_rec.attribute8 :=
531: per_pms_shd.g_old_rec.attribute8;

Line 531: per_pms_shd.g_old_rec.attribute8;

527: per_pms_shd.g_old_rec.attribute7;
528: End If;
529: If (p_rec.attribute8 = hr_api.g_varchar2) then
530: p_rec.attribute8 :=
531: per_pms_shd.g_old_rec.attribute8;
532: End If;
533: If (p_rec.attribute9 = hr_api.g_varchar2) then
534: p_rec.attribute9 :=
535: per_pms_shd.g_old_rec.attribute9;

Line 535: per_pms_shd.g_old_rec.attribute9;

531: per_pms_shd.g_old_rec.attribute8;
532: End If;
533: If (p_rec.attribute9 = hr_api.g_varchar2) then
534: p_rec.attribute9 :=
535: per_pms_shd.g_old_rec.attribute9;
536: End If;
537: If (p_rec.attribute10 = hr_api.g_varchar2) then
538: p_rec.attribute10 :=
539: per_pms_shd.g_old_rec.attribute10;

Line 539: per_pms_shd.g_old_rec.attribute10;

535: per_pms_shd.g_old_rec.attribute9;
536: End If;
537: If (p_rec.attribute10 = hr_api.g_varchar2) then
538: p_rec.attribute10 :=
539: per_pms_shd.g_old_rec.attribute10;
540: End If;
541: If (p_rec.attribute11 = hr_api.g_varchar2) then
542: p_rec.attribute11 :=
543: per_pms_shd.g_old_rec.attribute11;

Line 543: per_pms_shd.g_old_rec.attribute11;

539: per_pms_shd.g_old_rec.attribute10;
540: End If;
541: If (p_rec.attribute11 = hr_api.g_varchar2) then
542: p_rec.attribute11 :=
543: per_pms_shd.g_old_rec.attribute11;
544: End If;
545: If (p_rec.attribute12 = hr_api.g_varchar2) then
546: p_rec.attribute12 :=
547: per_pms_shd.g_old_rec.attribute12;

Line 547: per_pms_shd.g_old_rec.attribute12;

543: per_pms_shd.g_old_rec.attribute11;
544: End If;
545: If (p_rec.attribute12 = hr_api.g_varchar2) then
546: p_rec.attribute12 :=
547: per_pms_shd.g_old_rec.attribute12;
548: End If;
549: If (p_rec.attribute13 = hr_api.g_varchar2) then
550: p_rec.attribute13 :=
551: per_pms_shd.g_old_rec.attribute13;

Line 551: per_pms_shd.g_old_rec.attribute13;

547: per_pms_shd.g_old_rec.attribute12;
548: End If;
549: If (p_rec.attribute13 = hr_api.g_varchar2) then
550: p_rec.attribute13 :=
551: per_pms_shd.g_old_rec.attribute13;
552: End If;
553: If (p_rec.attribute14 = hr_api.g_varchar2) then
554: p_rec.attribute14 :=
555: per_pms_shd.g_old_rec.attribute14;

Line 555: per_pms_shd.g_old_rec.attribute14;

551: per_pms_shd.g_old_rec.attribute13;
552: End If;
553: If (p_rec.attribute14 = hr_api.g_varchar2) then
554: p_rec.attribute14 :=
555: per_pms_shd.g_old_rec.attribute14;
556: End If;
557: If (p_rec.attribute15 = hr_api.g_varchar2) then
558: p_rec.attribute15 :=
559: per_pms_shd.g_old_rec.attribute15;

Line 559: per_pms_shd.g_old_rec.attribute15;

555: per_pms_shd.g_old_rec.attribute14;
556: End If;
557: If (p_rec.attribute15 = hr_api.g_varchar2) then
558: p_rec.attribute15 :=
559: per_pms_shd.g_old_rec.attribute15;
560: End If;
561: If (p_rec.attribute16 = hr_api.g_varchar2) then
562: p_rec.attribute16 :=
563: per_pms_shd.g_old_rec.attribute16;

Line 563: per_pms_shd.g_old_rec.attribute16;

559: per_pms_shd.g_old_rec.attribute15;
560: End If;
561: If (p_rec.attribute16 = hr_api.g_varchar2) then
562: p_rec.attribute16 :=
563: per_pms_shd.g_old_rec.attribute16;
564: End If;
565: If (p_rec.attribute17 = hr_api.g_varchar2) then
566: p_rec.attribute17 :=
567: per_pms_shd.g_old_rec.attribute17;

Line 567: per_pms_shd.g_old_rec.attribute17;

563: per_pms_shd.g_old_rec.attribute16;
564: End If;
565: If (p_rec.attribute17 = hr_api.g_varchar2) then
566: p_rec.attribute17 :=
567: per_pms_shd.g_old_rec.attribute17;
568: End If;
569: If (p_rec.attribute18 = hr_api.g_varchar2) then
570: p_rec.attribute18 :=
571: per_pms_shd.g_old_rec.attribute18;

Line 571: per_pms_shd.g_old_rec.attribute18;

567: per_pms_shd.g_old_rec.attribute17;
568: End If;
569: If (p_rec.attribute18 = hr_api.g_varchar2) then
570: p_rec.attribute18 :=
571: per_pms_shd.g_old_rec.attribute18;
572: End If;
573: If (p_rec.attribute19 = hr_api.g_varchar2) then
574: p_rec.attribute19 :=
575: per_pms_shd.g_old_rec.attribute19;

Line 575: per_pms_shd.g_old_rec.attribute19;

571: per_pms_shd.g_old_rec.attribute18;
572: End If;
573: If (p_rec.attribute19 = hr_api.g_varchar2) then
574: p_rec.attribute19 :=
575: per_pms_shd.g_old_rec.attribute19;
576: End If;
577: If (p_rec.attribute20 = hr_api.g_varchar2) then
578: p_rec.attribute20 :=
579: per_pms_shd.g_old_rec.attribute20;

Line 579: per_pms_shd.g_old_rec.attribute20;

575: per_pms_shd.g_old_rec.attribute19;
576: End If;
577: If (p_rec.attribute20 = hr_api.g_varchar2) then
578: p_rec.attribute20 :=
579: per_pms_shd.g_old_rec.attribute20;
580: End If;
581: If (p_rec.attribute21 = hr_api.g_varchar2) then
582: p_rec.attribute21 :=
583: per_pms_shd.g_old_rec.attribute21;

Line 583: per_pms_shd.g_old_rec.attribute21;

579: per_pms_shd.g_old_rec.attribute20;
580: End If;
581: If (p_rec.attribute21 = hr_api.g_varchar2) then
582: p_rec.attribute21 :=
583: per_pms_shd.g_old_rec.attribute21;
584: End If;
585: If (p_rec.attribute22 = hr_api.g_varchar2) then
586: p_rec.attribute22 :=
587: per_pms_shd.g_old_rec.attribute22;

Line 587: per_pms_shd.g_old_rec.attribute22;

583: per_pms_shd.g_old_rec.attribute21;
584: End If;
585: If (p_rec.attribute22 = hr_api.g_varchar2) then
586: p_rec.attribute22 :=
587: per_pms_shd.g_old_rec.attribute22;
588: End If;
589: If (p_rec.attribute23 = hr_api.g_varchar2) then
590: p_rec.attribute23 :=
591: per_pms_shd.g_old_rec.attribute23;

Line 591: per_pms_shd.g_old_rec.attribute23;

587: per_pms_shd.g_old_rec.attribute22;
588: End If;
589: If (p_rec.attribute23 = hr_api.g_varchar2) then
590: p_rec.attribute23 :=
591: per_pms_shd.g_old_rec.attribute23;
592: End If;
593: If (p_rec.attribute24 = hr_api.g_varchar2) then
594: p_rec.attribute24 :=
595: per_pms_shd.g_old_rec.attribute24;

Line 595: per_pms_shd.g_old_rec.attribute24;

591: per_pms_shd.g_old_rec.attribute23;
592: End If;
593: If (p_rec.attribute24 = hr_api.g_varchar2) then
594: p_rec.attribute24 :=
595: per_pms_shd.g_old_rec.attribute24;
596: End If;
597: If (p_rec.attribute25 = hr_api.g_varchar2) then
598: p_rec.attribute25 :=
599: per_pms_shd.g_old_rec.attribute25;

Line 599: per_pms_shd.g_old_rec.attribute25;

595: per_pms_shd.g_old_rec.attribute24;
596: End If;
597: If (p_rec.attribute25 = hr_api.g_varchar2) then
598: p_rec.attribute25 :=
599: per_pms_shd.g_old_rec.attribute25;
600: End If;
601: If (p_rec.attribute26 = hr_api.g_varchar2) then
602: p_rec.attribute26 :=
603: per_pms_shd.g_old_rec.attribute26;

Line 603: per_pms_shd.g_old_rec.attribute26;

599: per_pms_shd.g_old_rec.attribute25;
600: End If;
601: If (p_rec.attribute26 = hr_api.g_varchar2) then
602: p_rec.attribute26 :=
603: per_pms_shd.g_old_rec.attribute26;
604: End If;
605: If (p_rec.attribute27 = hr_api.g_varchar2) then
606: p_rec.attribute27 :=
607: per_pms_shd.g_old_rec.attribute27;

Line 607: per_pms_shd.g_old_rec.attribute27;

603: per_pms_shd.g_old_rec.attribute26;
604: End If;
605: If (p_rec.attribute27 = hr_api.g_varchar2) then
606: p_rec.attribute27 :=
607: per_pms_shd.g_old_rec.attribute27;
608: End If;
609: If (p_rec.attribute28 = hr_api.g_varchar2) then
610: p_rec.attribute28 :=
611: per_pms_shd.g_old_rec.attribute28;

Line 611: per_pms_shd.g_old_rec.attribute28;

607: per_pms_shd.g_old_rec.attribute27;
608: End If;
609: If (p_rec.attribute28 = hr_api.g_varchar2) then
610: p_rec.attribute28 :=
611: per_pms_shd.g_old_rec.attribute28;
612: End If;
613: If (p_rec.attribute29 = hr_api.g_varchar2) then
614: p_rec.attribute29 :=
615: per_pms_shd.g_old_rec.attribute29;

Line 615: per_pms_shd.g_old_rec.attribute29;

611: per_pms_shd.g_old_rec.attribute28;
612: End If;
613: If (p_rec.attribute29 = hr_api.g_varchar2) then
614: p_rec.attribute29 :=
615: per_pms_shd.g_old_rec.attribute29;
616: End If;
617: If (p_rec.attribute30 = hr_api.g_varchar2) then
618: p_rec.attribute30 :=
619: per_pms_shd.g_old_rec.attribute30;

Line 619: per_pms_shd.g_old_rec.attribute30;

615: per_pms_shd.g_old_rec.attribute29;
616: End If;
617: If (p_rec.attribute30 = hr_api.g_varchar2) then
618: p_rec.attribute30 :=
619: per_pms_shd.g_old_rec.attribute30;
620: End If;
621: --
622: End convert_defs;
623: --

Line 629: ,p_rec in out nocopy per_pms_shd.g_rec_type

625: -- |---------------------------------< upd >----------------------------------|
626: -- ----------------------------------------------------------------------------
627: Procedure upd
628: (p_effective_date in date
629: ,p_rec in out nocopy per_pms_shd.g_rec_type
630: ,p_duplicate_name_warning out nocopy boolean
631: ) is
632: --
633: l_proc varchar2(72) := g_package||'upd';

Line 640: per_pms_shd.lck

636: hr_utility.set_location('Entering:'||l_proc, 5);
637: --
638: -- We must lock the row which we need to update.
639: --
640: per_pms_shd.lck
641: (p_rec.scorecard_id
642: ,p_rec.object_version_number
643: );
644: --

Line 728: l_rec per_pms_shd.g_rec_type;

724: ,p_attribute30 in varchar2 default hr_api.g_varchar2
725: ,p_duplicate_name_warning out nocopy boolean
726: ) is
727: --
728: l_rec per_pms_shd.g_rec_type;
729: l_proc varchar2(72) := g_package||'upd';
730: --
731: Begin
732: hr_utility.set_location('Entering:'||l_proc, 5);

Line 738: per_pms_shd.convert_args

734: -- Call conversion function to turn arguments into the
735: -- l_rec structure.
736: --
737: l_rec :=
738: per_pms_shd.convert_args
739: (p_scorecard_id
740: ,p_object_version_number
741: ,p_scorecard_name
742: ,hr_api.g_number -- p_person_id