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_PMA_UPD dependencies on PER_PMA_SHD

Line 55: (p_rec in out nocopy per_pma_shd.g_rec_type

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

Line 125: per_pma_shd.constraint_error

121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: --
125: per_pma_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: --

Line 130: per_pma_shd.constraint_error

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

Line 135: per_pma_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --
135: per_pma_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: --
139: Raise;

Line 175: (p_rec in per_pma_shd.g_rec_type

171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_update
175: (p_rec in per_pma_shd.g_rec_type
176: ) is
177: --
178: l_proc varchar2(72) := g_package||'pre_update';
179: --

Line 220: ,p_rec in per_pma_shd.g_rec_type

216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure post_update
219: (p_effective_date in date
220: ,p_rec in per_pma_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72) := g_package||'post_update';
224: --

Line 323: => per_pma_shd.g_old_rec.object_version_number

319: => p_rec.attribute29
320: ,p_attribute30
321: => p_rec.attribute30
322: ,p_object_version_number_o
323: => per_pma_shd.g_old_rec.object_version_number
324: ,p_plan_id_o
325: => per_pma_shd.g_old_rec.plan_id
326: ,p_appraisal_template_id_o
327: => per_pma_shd.g_old_rec.appraisal_template_id

Line 325: => per_pma_shd.g_old_rec.plan_id

321: => p_rec.attribute30
322: ,p_object_version_number_o
323: => per_pma_shd.g_old_rec.object_version_number
324: ,p_plan_id_o
325: => per_pma_shd.g_old_rec.plan_id
326: ,p_appraisal_template_id_o
327: => per_pma_shd.g_old_rec.appraisal_template_id
328: ,p_start_date_o
329: => per_pma_shd.g_old_rec.start_date

Line 327: => per_pma_shd.g_old_rec.appraisal_template_id

323: => per_pma_shd.g_old_rec.object_version_number
324: ,p_plan_id_o
325: => per_pma_shd.g_old_rec.plan_id
326: ,p_appraisal_template_id_o
327: => per_pma_shd.g_old_rec.appraisal_template_id
328: ,p_start_date_o
329: => per_pma_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => per_pma_shd.g_old_rec.end_date

Line 329: => per_pma_shd.g_old_rec.start_date

325: => per_pma_shd.g_old_rec.plan_id
326: ,p_appraisal_template_id_o
327: => per_pma_shd.g_old_rec.appraisal_template_id
328: ,p_start_date_o
329: => per_pma_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => per_pma_shd.g_old_rec.end_date
332: ,p_task_start_date_o
333: => per_pma_shd.g_old_rec.task_start_date

Line 331: => per_pma_shd.g_old_rec.end_date

327: => per_pma_shd.g_old_rec.appraisal_template_id
328: ,p_start_date_o
329: => per_pma_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => per_pma_shd.g_old_rec.end_date
332: ,p_task_start_date_o
333: => per_pma_shd.g_old_rec.task_start_date
334: ,p_task_end_date_o
335: => per_pma_shd.g_old_rec.task_end_date

Line 333: => per_pma_shd.g_old_rec.task_start_date

329: => per_pma_shd.g_old_rec.start_date
330: ,p_end_date_o
331: => per_pma_shd.g_old_rec.end_date
332: ,p_task_start_date_o
333: => per_pma_shd.g_old_rec.task_start_date
334: ,p_task_end_date_o
335: => per_pma_shd.g_old_rec.task_end_date
336: ,p_initiator_code_o
337: => per_pma_shd.g_old_rec.initiator_code

Line 335: => per_pma_shd.g_old_rec.task_end_date

331: => per_pma_shd.g_old_rec.end_date
332: ,p_task_start_date_o
333: => per_pma_shd.g_old_rec.task_start_date
334: ,p_task_end_date_o
335: => per_pma_shd.g_old_rec.task_end_date
336: ,p_initiator_code_o
337: => per_pma_shd.g_old_rec.initiator_code
338: ,p_appraisal_system_type_o
339: => per_pma_shd.g_old_rec.appraisal_system_type

Line 337: => per_pma_shd.g_old_rec.initiator_code

333: => per_pma_shd.g_old_rec.task_start_date
334: ,p_task_end_date_o
335: => per_pma_shd.g_old_rec.task_end_date
336: ,p_initiator_code_o
337: => per_pma_shd.g_old_rec.initiator_code
338: ,p_appraisal_system_type_o
339: => per_pma_shd.g_old_rec.appraisal_system_type
340: ,p_appraisal_type_o
341: => per_pma_shd.g_old_rec.appraisal_type

Line 339: => per_pma_shd.g_old_rec.appraisal_system_type

335: => per_pma_shd.g_old_rec.task_end_date
336: ,p_initiator_code_o
337: => per_pma_shd.g_old_rec.initiator_code
338: ,p_appraisal_system_type_o
339: => per_pma_shd.g_old_rec.appraisal_system_type
340: ,p_appraisal_type_o
341: => per_pma_shd.g_old_rec.appraisal_type
342: ,p_appraisal_assmt_status_o
343: => per_pma_shd.g_old_rec.appraisal_assmt_status

Line 341: => per_pma_shd.g_old_rec.appraisal_type

337: => per_pma_shd.g_old_rec.initiator_code
338: ,p_appraisal_system_type_o
339: => per_pma_shd.g_old_rec.appraisal_system_type
340: ,p_appraisal_type_o
341: => per_pma_shd.g_old_rec.appraisal_type
342: ,p_appraisal_assmt_status_o
343: => per_pma_shd.g_old_rec.appraisal_assmt_status
344: ,p_auto_conc_process_o
345: => per_pma_shd.g_old_rec.auto_conc_process

Line 343: => per_pma_shd.g_old_rec.appraisal_assmt_status

339: => per_pma_shd.g_old_rec.appraisal_system_type
340: ,p_appraisal_type_o
341: => per_pma_shd.g_old_rec.appraisal_type
342: ,p_appraisal_assmt_status_o
343: => per_pma_shd.g_old_rec.appraisal_assmt_status
344: ,p_auto_conc_process_o
345: => per_pma_shd.g_old_rec.auto_conc_process
346: ,p_days_before_task_st_dt_o
347: => per_pma_shd.g_old_rec.days_before_task_st_dt

Line 345: => per_pma_shd.g_old_rec.auto_conc_process

341: => per_pma_shd.g_old_rec.appraisal_type
342: ,p_appraisal_assmt_status_o
343: => per_pma_shd.g_old_rec.appraisal_assmt_status
344: ,p_auto_conc_process_o
345: => per_pma_shd.g_old_rec.auto_conc_process
346: ,p_days_before_task_st_dt_o
347: => per_pma_shd.g_old_rec.days_before_task_st_dt
348: ,p_attribute_category_o
349: => per_pma_shd.g_old_rec.attribute_category

Line 347: => per_pma_shd.g_old_rec.days_before_task_st_dt

343: => per_pma_shd.g_old_rec.appraisal_assmt_status
344: ,p_auto_conc_process_o
345: => per_pma_shd.g_old_rec.auto_conc_process
346: ,p_days_before_task_st_dt_o
347: => per_pma_shd.g_old_rec.days_before_task_st_dt
348: ,p_attribute_category_o
349: => per_pma_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_pma_shd.g_old_rec.attribute1

Line 349: => per_pma_shd.g_old_rec.attribute_category

345: => per_pma_shd.g_old_rec.auto_conc_process
346: ,p_days_before_task_st_dt_o
347: => per_pma_shd.g_old_rec.days_before_task_st_dt
348: ,p_attribute_category_o
349: => per_pma_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_pma_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_pma_shd.g_old_rec.attribute2

Line 351: => per_pma_shd.g_old_rec.attribute1

347: => per_pma_shd.g_old_rec.days_before_task_st_dt
348: ,p_attribute_category_o
349: => per_pma_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_pma_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_pma_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_pma_shd.g_old_rec.attribute3

Line 353: => per_pma_shd.g_old_rec.attribute2

349: => per_pma_shd.g_old_rec.attribute_category
350: ,p_attribute1_o
351: => per_pma_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_pma_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_pma_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_pma_shd.g_old_rec.attribute4

Line 355: => per_pma_shd.g_old_rec.attribute3

351: => per_pma_shd.g_old_rec.attribute1
352: ,p_attribute2_o
353: => per_pma_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_pma_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_pma_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_pma_shd.g_old_rec.attribute5

Line 357: => per_pma_shd.g_old_rec.attribute4

353: => per_pma_shd.g_old_rec.attribute2
354: ,p_attribute3_o
355: => per_pma_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_pma_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_pma_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_pma_shd.g_old_rec.attribute6

Line 359: => per_pma_shd.g_old_rec.attribute5

355: => per_pma_shd.g_old_rec.attribute3
356: ,p_attribute4_o
357: => per_pma_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_pma_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_pma_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_pma_shd.g_old_rec.attribute7

Line 361: => per_pma_shd.g_old_rec.attribute6

357: => per_pma_shd.g_old_rec.attribute4
358: ,p_attribute5_o
359: => per_pma_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_pma_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_pma_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_pma_shd.g_old_rec.attribute8

Line 363: => per_pma_shd.g_old_rec.attribute7

359: => per_pma_shd.g_old_rec.attribute5
360: ,p_attribute6_o
361: => per_pma_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_pma_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_pma_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_pma_shd.g_old_rec.attribute9

Line 365: => per_pma_shd.g_old_rec.attribute8

361: => per_pma_shd.g_old_rec.attribute6
362: ,p_attribute7_o
363: => per_pma_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_pma_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_pma_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_pma_shd.g_old_rec.attribute10

Line 367: => per_pma_shd.g_old_rec.attribute9

363: => per_pma_shd.g_old_rec.attribute7
364: ,p_attribute8_o
365: => per_pma_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_pma_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_pma_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_pma_shd.g_old_rec.attribute11

Line 369: => per_pma_shd.g_old_rec.attribute10

365: => per_pma_shd.g_old_rec.attribute8
366: ,p_attribute9_o
367: => per_pma_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_pma_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_pma_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_pma_shd.g_old_rec.attribute12

Line 371: => per_pma_shd.g_old_rec.attribute11

367: => per_pma_shd.g_old_rec.attribute9
368: ,p_attribute10_o
369: => per_pma_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_pma_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_pma_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_pma_shd.g_old_rec.attribute13

Line 373: => per_pma_shd.g_old_rec.attribute12

369: => per_pma_shd.g_old_rec.attribute10
370: ,p_attribute11_o
371: => per_pma_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_pma_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_pma_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_pma_shd.g_old_rec.attribute14

Line 375: => per_pma_shd.g_old_rec.attribute13

371: => per_pma_shd.g_old_rec.attribute11
372: ,p_attribute12_o
373: => per_pma_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_pma_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_pma_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_pma_shd.g_old_rec.attribute15

Line 377: => per_pma_shd.g_old_rec.attribute14

373: => per_pma_shd.g_old_rec.attribute12
374: ,p_attribute13_o
375: => per_pma_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_pma_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_pma_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_pma_shd.g_old_rec.attribute16

Line 379: => per_pma_shd.g_old_rec.attribute15

375: => per_pma_shd.g_old_rec.attribute13
376: ,p_attribute14_o
377: => per_pma_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_pma_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_pma_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_pma_shd.g_old_rec.attribute17

Line 381: => per_pma_shd.g_old_rec.attribute16

377: => per_pma_shd.g_old_rec.attribute14
378: ,p_attribute15_o
379: => per_pma_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_pma_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_pma_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_pma_shd.g_old_rec.attribute18

Line 383: => per_pma_shd.g_old_rec.attribute17

379: => per_pma_shd.g_old_rec.attribute15
380: ,p_attribute16_o
381: => per_pma_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_pma_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_pma_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_pma_shd.g_old_rec.attribute19

Line 385: => per_pma_shd.g_old_rec.attribute18

381: => per_pma_shd.g_old_rec.attribute16
382: ,p_attribute17_o
383: => per_pma_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_pma_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_pma_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_pma_shd.g_old_rec.attribute20

Line 387: => per_pma_shd.g_old_rec.attribute19

383: => per_pma_shd.g_old_rec.attribute17
384: ,p_attribute18_o
385: => per_pma_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_pma_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_pma_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_pma_shd.g_old_rec.attribute21

Line 389: => per_pma_shd.g_old_rec.attribute20

385: => per_pma_shd.g_old_rec.attribute18
386: ,p_attribute19_o
387: => per_pma_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_pma_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_pma_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_pma_shd.g_old_rec.attribute22

Line 391: => per_pma_shd.g_old_rec.attribute21

387: => per_pma_shd.g_old_rec.attribute19
388: ,p_attribute20_o
389: => per_pma_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_pma_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_pma_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_pma_shd.g_old_rec.attribute23

Line 393: => per_pma_shd.g_old_rec.attribute22

389: => per_pma_shd.g_old_rec.attribute20
390: ,p_attribute21_o
391: => per_pma_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_pma_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_pma_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_pma_shd.g_old_rec.attribute24

Line 395: => per_pma_shd.g_old_rec.attribute23

391: => per_pma_shd.g_old_rec.attribute21
392: ,p_attribute22_o
393: => per_pma_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_pma_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_pma_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_pma_shd.g_old_rec.attribute25

Line 397: => per_pma_shd.g_old_rec.attribute24

393: => per_pma_shd.g_old_rec.attribute22
394: ,p_attribute23_o
395: => per_pma_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_pma_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_pma_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_pma_shd.g_old_rec.attribute26

Line 399: => per_pma_shd.g_old_rec.attribute25

395: => per_pma_shd.g_old_rec.attribute23
396: ,p_attribute24_o
397: => per_pma_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_pma_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_pma_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_pma_shd.g_old_rec.attribute27

Line 401: => per_pma_shd.g_old_rec.attribute26

397: => per_pma_shd.g_old_rec.attribute24
398: ,p_attribute25_o
399: => per_pma_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_pma_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_pma_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_pma_shd.g_old_rec.attribute28

Line 403: => per_pma_shd.g_old_rec.attribute27

399: => per_pma_shd.g_old_rec.attribute25
400: ,p_attribute26_o
401: => per_pma_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_pma_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_pma_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_pma_shd.g_old_rec.attribute29

Line 405: => per_pma_shd.g_old_rec.attribute28

401: => per_pma_shd.g_old_rec.attribute26
402: ,p_attribute27_o
403: => per_pma_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_pma_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_pma_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_pma_shd.g_old_rec.attribute30

Line 407: => per_pma_shd.g_old_rec.attribute29

403: => per_pma_shd.g_old_rec.attribute27
404: ,p_attribute28_o
405: => per_pma_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_pma_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_pma_shd.g_old_rec.attribute30
410: );
411: --

Line 409: => per_pma_shd.g_old_rec.attribute30

405: => per_pma_shd.g_old_rec.attribute28
406: ,p_attribute29_o
407: => per_pma_shd.g_old_rec.attribute29
408: ,p_attribute30_o
409: => per_pma_shd.g_old_rec.attribute30
410: );
411: --
412: exception
413: --

Line 469: (p_rec in out nocopy per_pma_shd.g_rec_type

465: --
466: -- {End Of Comments}
467: -- ----------------------------------------------------------------------------
468: Procedure convert_defs
469: (p_rec in out nocopy per_pma_shd.g_rec_type
470: ) is
471: --
472: Begin
473: --

Line 481: per_pma_shd.g_old_rec.plan_id;

477: -- is being used then we must set to the 'current' argument value.
478: --
479: If (p_rec.plan_id = hr_api.g_number) then
480: p_rec.plan_id :=
481: per_pma_shd.g_old_rec.plan_id;
482: End If;
483: If (p_rec.appraisal_template_id = hr_api.g_number) then
484: p_rec.appraisal_template_id :=
485: per_pma_shd.g_old_rec.appraisal_template_id;

Line 485: per_pma_shd.g_old_rec.appraisal_template_id;

481: per_pma_shd.g_old_rec.plan_id;
482: End If;
483: If (p_rec.appraisal_template_id = hr_api.g_number) then
484: p_rec.appraisal_template_id :=
485: per_pma_shd.g_old_rec.appraisal_template_id;
486: End If;
487: If (p_rec.start_date = hr_api.g_date) then
488: p_rec.start_date :=
489: per_pma_shd.g_old_rec.start_date;

Line 489: per_pma_shd.g_old_rec.start_date;

485: per_pma_shd.g_old_rec.appraisal_template_id;
486: End If;
487: If (p_rec.start_date = hr_api.g_date) then
488: p_rec.start_date :=
489: per_pma_shd.g_old_rec.start_date;
490: End If;
491: If (p_rec.end_date = hr_api.g_date) then
492: p_rec.end_date :=
493: per_pma_shd.g_old_rec.end_date;

Line 493: per_pma_shd.g_old_rec.end_date;

489: per_pma_shd.g_old_rec.start_date;
490: End If;
491: If (p_rec.end_date = hr_api.g_date) then
492: p_rec.end_date :=
493: per_pma_shd.g_old_rec.end_date;
494: End If;
495: If (p_rec.task_start_date = hr_api.g_date) then
496: p_rec.task_start_date :=
497: per_pma_shd.g_old_rec.task_start_date;

Line 497: per_pma_shd.g_old_rec.task_start_date;

493: per_pma_shd.g_old_rec.end_date;
494: End If;
495: If (p_rec.task_start_date = hr_api.g_date) then
496: p_rec.task_start_date :=
497: per_pma_shd.g_old_rec.task_start_date;
498: End If;
499: If (p_rec.task_end_date = hr_api.g_date) then
500: p_rec.task_end_date :=
501: per_pma_shd.g_old_rec.task_end_date;

Line 501: per_pma_shd.g_old_rec.task_end_date;

497: per_pma_shd.g_old_rec.task_start_date;
498: End If;
499: If (p_rec.task_end_date = hr_api.g_date) then
500: p_rec.task_end_date :=
501: per_pma_shd.g_old_rec.task_end_date;
502: End If;
503: If (p_rec.initiator_code = hr_api.g_varchar2) then
504: p_rec.initiator_code :=
505: per_pma_shd.g_old_rec.initiator_code;

Line 505: per_pma_shd.g_old_rec.initiator_code;

501: per_pma_shd.g_old_rec.task_end_date;
502: End If;
503: If (p_rec.initiator_code = hr_api.g_varchar2) then
504: p_rec.initiator_code :=
505: per_pma_shd.g_old_rec.initiator_code;
506: End If;
507: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then
508: p_rec.appraisal_system_type :=
509: per_pma_shd.g_old_rec.appraisal_system_type;

Line 509: per_pma_shd.g_old_rec.appraisal_system_type;

505: per_pma_shd.g_old_rec.initiator_code;
506: End If;
507: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then
508: p_rec.appraisal_system_type :=
509: per_pma_shd.g_old_rec.appraisal_system_type;
510: End If;
511: If (p_rec.appraisal_type = hr_api.g_varchar2) then
512: p_rec.appraisal_type :=
513: per_pma_shd.g_old_rec.appraisal_type;

Line 513: per_pma_shd.g_old_rec.appraisal_type;

509: per_pma_shd.g_old_rec.appraisal_system_type;
510: End If;
511: If (p_rec.appraisal_type = hr_api.g_varchar2) then
512: p_rec.appraisal_type :=
513: per_pma_shd.g_old_rec.appraisal_type;
514: End If;
515: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then
516: p_rec.appraisal_assmt_status :=
517: per_pma_shd.g_old_rec.appraisal_assmt_status;

Line 517: per_pma_shd.g_old_rec.appraisal_assmt_status;

513: per_pma_shd.g_old_rec.appraisal_type;
514: End If;
515: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then
516: p_rec.appraisal_assmt_status :=
517: per_pma_shd.g_old_rec.appraisal_assmt_status;
518: End If;
519: If (p_rec.auto_conc_process = hr_api.g_varchar2) then
520: p_rec.auto_conc_process :=
521: per_pma_shd.g_old_rec.auto_conc_process;

Line 521: per_pma_shd.g_old_rec.auto_conc_process;

517: per_pma_shd.g_old_rec.appraisal_assmt_status;
518: End If;
519: If (p_rec.auto_conc_process = hr_api.g_varchar2) then
520: p_rec.auto_conc_process :=
521: per_pma_shd.g_old_rec.auto_conc_process;
522: End If;
523: If (p_rec.days_before_task_st_dt = hr_api.g_number) then
524: p_rec.days_before_task_st_dt :=
525: per_pma_shd.g_old_rec.days_before_task_st_dt;

Line 525: per_pma_shd.g_old_rec.days_before_task_st_dt;

521: per_pma_shd.g_old_rec.auto_conc_process;
522: End If;
523: If (p_rec.days_before_task_st_dt = hr_api.g_number) then
524: p_rec.days_before_task_st_dt :=
525: per_pma_shd.g_old_rec.days_before_task_st_dt;
526: End If;
527: If (p_rec.attribute_category = hr_api.g_varchar2) then
528: p_rec.attribute_category :=
529: per_pma_shd.g_old_rec.attribute_category;

Line 529: per_pma_shd.g_old_rec.attribute_category;

525: per_pma_shd.g_old_rec.days_before_task_st_dt;
526: End If;
527: If (p_rec.attribute_category = hr_api.g_varchar2) then
528: p_rec.attribute_category :=
529: per_pma_shd.g_old_rec.attribute_category;
530: End If;
531: If (p_rec.attribute1 = hr_api.g_varchar2) then
532: p_rec.attribute1 :=
533: per_pma_shd.g_old_rec.attribute1;

Line 533: per_pma_shd.g_old_rec.attribute1;

529: per_pma_shd.g_old_rec.attribute_category;
530: End If;
531: If (p_rec.attribute1 = hr_api.g_varchar2) then
532: p_rec.attribute1 :=
533: per_pma_shd.g_old_rec.attribute1;
534: End If;
535: If (p_rec.attribute2 = hr_api.g_varchar2) then
536: p_rec.attribute2 :=
537: per_pma_shd.g_old_rec.attribute2;

Line 537: per_pma_shd.g_old_rec.attribute2;

533: per_pma_shd.g_old_rec.attribute1;
534: End If;
535: If (p_rec.attribute2 = hr_api.g_varchar2) then
536: p_rec.attribute2 :=
537: per_pma_shd.g_old_rec.attribute2;
538: End If;
539: If (p_rec.attribute3 = hr_api.g_varchar2) then
540: p_rec.attribute3 :=
541: per_pma_shd.g_old_rec.attribute3;

Line 541: per_pma_shd.g_old_rec.attribute3;

537: per_pma_shd.g_old_rec.attribute2;
538: End If;
539: If (p_rec.attribute3 = hr_api.g_varchar2) then
540: p_rec.attribute3 :=
541: per_pma_shd.g_old_rec.attribute3;
542: End If;
543: If (p_rec.attribute4 = hr_api.g_varchar2) then
544: p_rec.attribute4 :=
545: per_pma_shd.g_old_rec.attribute4;

Line 545: per_pma_shd.g_old_rec.attribute4;

541: per_pma_shd.g_old_rec.attribute3;
542: End If;
543: If (p_rec.attribute4 = hr_api.g_varchar2) then
544: p_rec.attribute4 :=
545: per_pma_shd.g_old_rec.attribute4;
546: End If;
547: If (p_rec.attribute5 = hr_api.g_varchar2) then
548: p_rec.attribute5 :=
549: per_pma_shd.g_old_rec.attribute5;

Line 549: per_pma_shd.g_old_rec.attribute5;

545: per_pma_shd.g_old_rec.attribute4;
546: End If;
547: If (p_rec.attribute5 = hr_api.g_varchar2) then
548: p_rec.attribute5 :=
549: per_pma_shd.g_old_rec.attribute5;
550: End If;
551: If (p_rec.attribute6 = hr_api.g_varchar2) then
552: p_rec.attribute6 :=
553: per_pma_shd.g_old_rec.attribute6;

Line 553: per_pma_shd.g_old_rec.attribute6;

549: per_pma_shd.g_old_rec.attribute5;
550: End If;
551: If (p_rec.attribute6 = hr_api.g_varchar2) then
552: p_rec.attribute6 :=
553: per_pma_shd.g_old_rec.attribute6;
554: End If;
555: If (p_rec.attribute7 = hr_api.g_varchar2) then
556: p_rec.attribute7 :=
557: per_pma_shd.g_old_rec.attribute7;

Line 557: per_pma_shd.g_old_rec.attribute7;

553: per_pma_shd.g_old_rec.attribute6;
554: End If;
555: If (p_rec.attribute7 = hr_api.g_varchar2) then
556: p_rec.attribute7 :=
557: per_pma_shd.g_old_rec.attribute7;
558: End If;
559: If (p_rec.attribute8 = hr_api.g_varchar2) then
560: p_rec.attribute8 :=
561: per_pma_shd.g_old_rec.attribute8;

Line 561: per_pma_shd.g_old_rec.attribute8;

557: per_pma_shd.g_old_rec.attribute7;
558: End If;
559: If (p_rec.attribute8 = hr_api.g_varchar2) then
560: p_rec.attribute8 :=
561: per_pma_shd.g_old_rec.attribute8;
562: End If;
563: If (p_rec.attribute9 = hr_api.g_varchar2) then
564: p_rec.attribute9 :=
565: per_pma_shd.g_old_rec.attribute9;

Line 565: per_pma_shd.g_old_rec.attribute9;

561: per_pma_shd.g_old_rec.attribute8;
562: End If;
563: If (p_rec.attribute9 = hr_api.g_varchar2) then
564: p_rec.attribute9 :=
565: per_pma_shd.g_old_rec.attribute9;
566: End If;
567: If (p_rec.attribute10 = hr_api.g_varchar2) then
568: p_rec.attribute10 :=
569: per_pma_shd.g_old_rec.attribute10;

Line 569: per_pma_shd.g_old_rec.attribute10;

565: per_pma_shd.g_old_rec.attribute9;
566: End If;
567: If (p_rec.attribute10 = hr_api.g_varchar2) then
568: p_rec.attribute10 :=
569: per_pma_shd.g_old_rec.attribute10;
570: End If;
571: If (p_rec.attribute11 = hr_api.g_varchar2) then
572: p_rec.attribute11 :=
573: per_pma_shd.g_old_rec.attribute11;

Line 573: per_pma_shd.g_old_rec.attribute11;

569: per_pma_shd.g_old_rec.attribute10;
570: End If;
571: If (p_rec.attribute11 = hr_api.g_varchar2) then
572: p_rec.attribute11 :=
573: per_pma_shd.g_old_rec.attribute11;
574: End If;
575: If (p_rec.attribute12 = hr_api.g_varchar2) then
576: p_rec.attribute12 :=
577: per_pma_shd.g_old_rec.attribute12;

Line 577: per_pma_shd.g_old_rec.attribute12;

573: per_pma_shd.g_old_rec.attribute11;
574: End If;
575: If (p_rec.attribute12 = hr_api.g_varchar2) then
576: p_rec.attribute12 :=
577: per_pma_shd.g_old_rec.attribute12;
578: End If;
579: If (p_rec.attribute13 = hr_api.g_varchar2) then
580: p_rec.attribute13 :=
581: per_pma_shd.g_old_rec.attribute13;

Line 581: per_pma_shd.g_old_rec.attribute13;

577: per_pma_shd.g_old_rec.attribute12;
578: End If;
579: If (p_rec.attribute13 = hr_api.g_varchar2) then
580: p_rec.attribute13 :=
581: per_pma_shd.g_old_rec.attribute13;
582: End If;
583: If (p_rec.attribute14 = hr_api.g_varchar2) then
584: p_rec.attribute14 :=
585: per_pma_shd.g_old_rec.attribute14;

Line 585: per_pma_shd.g_old_rec.attribute14;

581: per_pma_shd.g_old_rec.attribute13;
582: End If;
583: If (p_rec.attribute14 = hr_api.g_varchar2) then
584: p_rec.attribute14 :=
585: per_pma_shd.g_old_rec.attribute14;
586: End If;
587: If (p_rec.attribute15 = hr_api.g_varchar2) then
588: p_rec.attribute15 :=
589: per_pma_shd.g_old_rec.attribute15;

Line 589: per_pma_shd.g_old_rec.attribute15;

585: per_pma_shd.g_old_rec.attribute14;
586: End If;
587: If (p_rec.attribute15 = hr_api.g_varchar2) then
588: p_rec.attribute15 :=
589: per_pma_shd.g_old_rec.attribute15;
590: End If;
591: If (p_rec.attribute16 = hr_api.g_varchar2) then
592: p_rec.attribute16 :=
593: per_pma_shd.g_old_rec.attribute16;

Line 593: per_pma_shd.g_old_rec.attribute16;

589: per_pma_shd.g_old_rec.attribute15;
590: End If;
591: If (p_rec.attribute16 = hr_api.g_varchar2) then
592: p_rec.attribute16 :=
593: per_pma_shd.g_old_rec.attribute16;
594: End If;
595: If (p_rec.attribute17 = hr_api.g_varchar2) then
596: p_rec.attribute17 :=
597: per_pma_shd.g_old_rec.attribute17;

Line 597: per_pma_shd.g_old_rec.attribute17;

593: per_pma_shd.g_old_rec.attribute16;
594: End If;
595: If (p_rec.attribute17 = hr_api.g_varchar2) then
596: p_rec.attribute17 :=
597: per_pma_shd.g_old_rec.attribute17;
598: End If;
599: If (p_rec.attribute18 = hr_api.g_varchar2) then
600: p_rec.attribute18 :=
601: per_pma_shd.g_old_rec.attribute18;

Line 601: per_pma_shd.g_old_rec.attribute18;

597: per_pma_shd.g_old_rec.attribute17;
598: End If;
599: If (p_rec.attribute18 = hr_api.g_varchar2) then
600: p_rec.attribute18 :=
601: per_pma_shd.g_old_rec.attribute18;
602: End If;
603: If (p_rec.attribute19 = hr_api.g_varchar2) then
604: p_rec.attribute19 :=
605: per_pma_shd.g_old_rec.attribute19;

Line 605: per_pma_shd.g_old_rec.attribute19;

601: per_pma_shd.g_old_rec.attribute18;
602: End If;
603: If (p_rec.attribute19 = hr_api.g_varchar2) then
604: p_rec.attribute19 :=
605: per_pma_shd.g_old_rec.attribute19;
606: End If;
607: If (p_rec.attribute20 = hr_api.g_varchar2) then
608: p_rec.attribute20 :=
609: per_pma_shd.g_old_rec.attribute20;

Line 609: per_pma_shd.g_old_rec.attribute20;

605: per_pma_shd.g_old_rec.attribute19;
606: End If;
607: If (p_rec.attribute20 = hr_api.g_varchar2) then
608: p_rec.attribute20 :=
609: per_pma_shd.g_old_rec.attribute20;
610: End If;
611: If (p_rec.attribute21 = hr_api.g_varchar2) then
612: p_rec.attribute21 :=
613: per_pma_shd.g_old_rec.attribute21;

Line 613: per_pma_shd.g_old_rec.attribute21;

609: per_pma_shd.g_old_rec.attribute20;
610: End If;
611: If (p_rec.attribute21 = hr_api.g_varchar2) then
612: p_rec.attribute21 :=
613: per_pma_shd.g_old_rec.attribute21;
614: End If;
615: If (p_rec.attribute22 = hr_api.g_varchar2) then
616: p_rec.attribute22 :=
617: per_pma_shd.g_old_rec.attribute22;

Line 617: per_pma_shd.g_old_rec.attribute22;

613: per_pma_shd.g_old_rec.attribute21;
614: End If;
615: If (p_rec.attribute22 = hr_api.g_varchar2) then
616: p_rec.attribute22 :=
617: per_pma_shd.g_old_rec.attribute22;
618: End If;
619: If (p_rec.attribute23 = hr_api.g_varchar2) then
620: p_rec.attribute23 :=
621: per_pma_shd.g_old_rec.attribute23;

Line 621: per_pma_shd.g_old_rec.attribute23;

617: per_pma_shd.g_old_rec.attribute22;
618: End If;
619: If (p_rec.attribute23 = hr_api.g_varchar2) then
620: p_rec.attribute23 :=
621: per_pma_shd.g_old_rec.attribute23;
622: End If;
623: If (p_rec.attribute24 = hr_api.g_varchar2) then
624: p_rec.attribute24 :=
625: per_pma_shd.g_old_rec.attribute24;

Line 625: per_pma_shd.g_old_rec.attribute24;

621: per_pma_shd.g_old_rec.attribute23;
622: End If;
623: If (p_rec.attribute24 = hr_api.g_varchar2) then
624: p_rec.attribute24 :=
625: per_pma_shd.g_old_rec.attribute24;
626: End If;
627: If (p_rec.attribute25 = hr_api.g_varchar2) then
628: p_rec.attribute25 :=
629: per_pma_shd.g_old_rec.attribute25;

Line 629: per_pma_shd.g_old_rec.attribute25;

625: per_pma_shd.g_old_rec.attribute24;
626: End If;
627: If (p_rec.attribute25 = hr_api.g_varchar2) then
628: p_rec.attribute25 :=
629: per_pma_shd.g_old_rec.attribute25;
630: End If;
631: If (p_rec.attribute26 = hr_api.g_varchar2) then
632: p_rec.attribute26 :=
633: per_pma_shd.g_old_rec.attribute26;

Line 633: per_pma_shd.g_old_rec.attribute26;

629: per_pma_shd.g_old_rec.attribute25;
630: End If;
631: If (p_rec.attribute26 = hr_api.g_varchar2) then
632: p_rec.attribute26 :=
633: per_pma_shd.g_old_rec.attribute26;
634: End If;
635: If (p_rec.attribute27 = hr_api.g_varchar2) then
636: p_rec.attribute27 :=
637: per_pma_shd.g_old_rec.attribute27;

Line 637: per_pma_shd.g_old_rec.attribute27;

633: per_pma_shd.g_old_rec.attribute26;
634: End If;
635: If (p_rec.attribute27 = hr_api.g_varchar2) then
636: p_rec.attribute27 :=
637: per_pma_shd.g_old_rec.attribute27;
638: End If;
639: If (p_rec.attribute28 = hr_api.g_varchar2) then
640: p_rec.attribute28 :=
641: per_pma_shd.g_old_rec.attribute28;

Line 641: per_pma_shd.g_old_rec.attribute28;

637: per_pma_shd.g_old_rec.attribute27;
638: End If;
639: If (p_rec.attribute28 = hr_api.g_varchar2) then
640: p_rec.attribute28 :=
641: per_pma_shd.g_old_rec.attribute28;
642: End If;
643: If (p_rec.attribute29 = hr_api.g_varchar2) then
644: p_rec.attribute29 :=
645: per_pma_shd.g_old_rec.attribute29;

Line 645: per_pma_shd.g_old_rec.attribute29;

641: per_pma_shd.g_old_rec.attribute28;
642: End If;
643: If (p_rec.attribute29 = hr_api.g_varchar2) then
644: p_rec.attribute29 :=
645: per_pma_shd.g_old_rec.attribute29;
646: End If;
647: If (p_rec.attribute30 = hr_api.g_varchar2) then
648: p_rec.attribute30 :=
649: per_pma_shd.g_old_rec.attribute30;

Line 649: per_pma_shd.g_old_rec.attribute30;

645: per_pma_shd.g_old_rec.attribute29;
646: End If;
647: If (p_rec.attribute30 = hr_api.g_varchar2) then
648: p_rec.attribute30 :=
649: per_pma_shd.g_old_rec.attribute30;
650: End If;
651: --
652: End convert_defs;
653: --

Line 659: ,p_rec in out nocopy per_pma_shd.g_rec_type

655: -- |---------------------------------< upd >----------------------------------|
656: -- ----------------------------------------------------------------------------
657: Procedure upd
658: (p_effective_date in date
659: ,p_rec in out nocopy per_pma_shd.g_rec_type
660: ) is
661: --
662: l_proc varchar2(72) := g_package||'upd';
663: --

Line 669: per_pma_shd.lck

665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: -- We must lock the row which we need to update.
668: --
669: per_pma_shd.lck
670: (p_rec.appraisal_period_id
671: ,p_rec.object_version_number
672: );
673: --

Line 758: l_rec per_pma_shd.g_rec_type;

754: ,p_attribute29 in varchar2 default hr_api.g_varchar2
755: ,p_attribute30 in varchar2 default hr_api.g_varchar2
756: ) is
757: --
758: l_rec per_pma_shd.g_rec_type;
759: l_proc varchar2(72) := g_package||'upd';
760: --
761: Begin
762: hr_utility.set_location('Entering:'||l_proc, 5);

Line 768: per_pma_shd.convert_args

764: -- Call conversion function to turn arguments into the
765: -- l_rec structure.
766: --
767: l_rec :=
768: per_pma_shd.convert_args
769: (p_appraisal_period_id
770: ,p_object_version_number
771: ,hr_api.g_number --p_plan_id
772: ,hr_api.g_number --p_appraisal_template_id