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_PSH_UPD dependencies on PER_PSH_SHD

Line 55: (p_rec in out nocopy per_psh_shd.g_rec_type

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

Line 117: per_psh_shd.constraint_error

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

Line 122: per_psh_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_psh_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --

Line 127: per_psh_shd.constraint_error

123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_psh_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;

Line 167: (p_rec in per_psh_shd.g_rec_type

163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update
167: (p_rec in per_psh_shd.g_rec_type
168: ) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --

Line 211: (p_rec in per_psh_shd.g_rec_type

207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update
211: (p_rec in per_psh_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --

Line 292: => per_psh_shd.g_old_rec.object_version_number

288: => p_rec.attribute29
289: ,p_attribute30
290: => p_rec.attribute30
291: ,p_object_version_number_o
292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id

Line 294: => per_psh_shd.g_old_rec.scorecard_id

290: => p_rec.attribute30
291: ,p_object_version_number_o
292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category

Line 296: => per_psh_shd.g_old_rec.person_id

292: => per_psh_shd.g_old_rec.object_version_number
293: ,p_scorecard_id_o
294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1

Line 298: => per_psh_shd.g_old_rec.attribute_category

294: => per_psh_shd.g_old_rec.scorecard_id
295: ,p_person_id_o
296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2

Line 300: => per_psh_shd.g_old_rec.attribute1

296: => per_psh_shd.g_old_rec.person_id
297: ,p_attribute_category_o
298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3

Line 302: => per_psh_shd.g_old_rec.attribute2

298: => per_psh_shd.g_old_rec.attribute_category
299: ,p_attribute1_o
300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4

Line 304: => per_psh_shd.g_old_rec.attribute3

300: => per_psh_shd.g_old_rec.attribute1
301: ,p_attribute2_o
302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5

Line 306: => per_psh_shd.g_old_rec.attribute4

302: => per_psh_shd.g_old_rec.attribute2
303: ,p_attribute3_o
304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6

Line 308: => per_psh_shd.g_old_rec.attribute5

304: => per_psh_shd.g_old_rec.attribute3
305: ,p_attribute4_o
306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7

Line 310: => per_psh_shd.g_old_rec.attribute6

306: => per_psh_shd.g_old_rec.attribute4
307: ,p_attribute5_o
308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8

Line 312: => per_psh_shd.g_old_rec.attribute7

308: => per_psh_shd.g_old_rec.attribute5
309: ,p_attribute6_o
310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9

Line 314: => per_psh_shd.g_old_rec.attribute8

310: => per_psh_shd.g_old_rec.attribute6
311: ,p_attribute7_o
312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10

Line 316: => per_psh_shd.g_old_rec.attribute9

312: => per_psh_shd.g_old_rec.attribute7
313: ,p_attribute8_o
314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11

Line 318: => per_psh_shd.g_old_rec.attribute10

314: => per_psh_shd.g_old_rec.attribute8
315: ,p_attribute9_o
316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12

Line 320: => per_psh_shd.g_old_rec.attribute11

316: => per_psh_shd.g_old_rec.attribute9
317: ,p_attribute10_o
318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13

Line 322: => per_psh_shd.g_old_rec.attribute12

318: => per_psh_shd.g_old_rec.attribute10
319: ,p_attribute11_o
320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14

Line 324: => per_psh_shd.g_old_rec.attribute13

320: => per_psh_shd.g_old_rec.attribute11
321: ,p_attribute12_o
322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15

Line 326: => per_psh_shd.g_old_rec.attribute14

322: => per_psh_shd.g_old_rec.attribute12
323: ,p_attribute13_o
324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16

Line 328: => per_psh_shd.g_old_rec.attribute15

324: => per_psh_shd.g_old_rec.attribute13
325: ,p_attribute14_o
326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17

Line 330: => per_psh_shd.g_old_rec.attribute16

326: => per_psh_shd.g_old_rec.attribute14
327: ,p_attribute15_o
328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18

Line 332: => per_psh_shd.g_old_rec.attribute17

328: => per_psh_shd.g_old_rec.attribute15
329: ,p_attribute16_o
330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19

Line 334: => per_psh_shd.g_old_rec.attribute18

330: => per_psh_shd.g_old_rec.attribute16
331: ,p_attribute17_o
332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20

Line 336: => per_psh_shd.g_old_rec.attribute19

332: => per_psh_shd.g_old_rec.attribute17
333: ,p_attribute18_o
334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21

Line 338: => per_psh_shd.g_old_rec.attribute20

334: => per_psh_shd.g_old_rec.attribute18
335: ,p_attribute19_o
336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22

Line 340: => per_psh_shd.g_old_rec.attribute21

336: => per_psh_shd.g_old_rec.attribute19
337: ,p_attribute20_o
338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23

Line 342: => per_psh_shd.g_old_rec.attribute22

338: => per_psh_shd.g_old_rec.attribute20
339: ,p_attribute21_o
340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24

Line 344: => per_psh_shd.g_old_rec.attribute23

340: => per_psh_shd.g_old_rec.attribute21
341: ,p_attribute22_o
342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25

Line 346: => per_psh_shd.g_old_rec.attribute24

342: => per_psh_shd.g_old_rec.attribute22
343: ,p_attribute23_o
344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26

Line 348: => per_psh_shd.g_old_rec.attribute25

344: => per_psh_shd.g_old_rec.attribute23
345: ,p_attribute24_o
346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27

Line 350: => per_psh_shd.g_old_rec.attribute26

346: => per_psh_shd.g_old_rec.attribute24
347: ,p_attribute25_o
348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28

Line 352: => per_psh_shd.g_old_rec.attribute27

348: => per_psh_shd.g_old_rec.attribute25
349: ,p_attribute26_o
350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29

Line 354: => per_psh_shd.g_old_rec.attribute28

350: => per_psh_shd.g_old_rec.attribute26
351: ,p_attribute27_o
352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30

Line 356: => per_psh_shd.g_old_rec.attribute29

352: => per_psh_shd.g_old_rec.attribute27
353: ,p_attribute28_o
354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30
359: );
360: --

Line 358: => per_psh_shd.g_old_rec.attribute30

354: => per_psh_shd.g_old_rec.attribute28
355: ,p_attribute29_o
356: => per_psh_shd.g_old_rec.attribute29
357: ,p_attribute30_o
358: => per_psh_shd.g_old_rec.attribute30
359: );
360: --
361: exception
362: --

Line 418: (p_rec in out nocopy per_psh_shd.g_rec_type

414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure convert_defs
418: (p_rec in out nocopy per_psh_shd.g_rec_type
419: ) is
420: --
421: Begin
422: --

Line 430: per_psh_shd.g_old_rec.scorecard_id;

426: -- is being used then we must set to the 'current' argument value.
427: --
428: If (p_rec.scorecard_id = hr_api.g_number) then
429: p_rec.scorecard_id :=
430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;

Line 434: per_psh_shd.g_old_rec.person_id;

430: per_psh_shd.g_old_rec.scorecard_id;
431: End If;
432: If (p_rec.person_id = hr_api.g_number) then
433: p_rec.person_id :=
434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;

Line 438: per_psh_shd.g_old_rec.attribute_category;

434: per_psh_shd.g_old_rec.person_id;
435: End If;
436: If (p_rec.attribute_category = hr_api.g_varchar2) then
437: p_rec.attribute_category :=
438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;

Line 442: per_psh_shd.g_old_rec.attribute1;

438: per_psh_shd.g_old_rec.attribute_category;
439: End If;
440: If (p_rec.attribute1 = hr_api.g_varchar2) then
441: p_rec.attribute1 :=
442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;

Line 446: per_psh_shd.g_old_rec.attribute2;

442: per_psh_shd.g_old_rec.attribute1;
443: End If;
444: If (p_rec.attribute2 = hr_api.g_varchar2) then
445: p_rec.attribute2 :=
446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;

Line 450: per_psh_shd.g_old_rec.attribute3;

446: per_psh_shd.g_old_rec.attribute2;
447: End If;
448: If (p_rec.attribute3 = hr_api.g_varchar2) then
449: p_rec.attribute3 :=
450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;

Line 454: per_psh_shd.g_old_rec.attribute4;

450: per_psh_shd.g_old_rec.attribute3;
451: End If;
452: If (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;

Line 458: per_psh_shd.g_old_rec.attribute5;

454: per_psh_shd.g_old_rec.attribute4;
455: End If;
456: If (p_rec.attribute5 = hr_api.g_varchar2) then
457: p_rec.attribute5 :=
458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;

Line 462: per_psh_shd.g_old_rec.attribute6;

458: per_psh_shd.g_old_rec.attribute5;
459: End If;
460: If (p_rec.attribute6 = hr_api.g_varchar2) then
461: p_rec.attribute6 :=
462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;

Line 466: per_psh_shd.g_old_rec.attribute7;

462: per_psh_shd.g_old_rec.attribute6;
463: End If;
464: If (p_rec.attribute7 = hr_api.g_varchar2) then
465: p_rec.attribute7 :=
466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;

Line 470: per_psh_shd.g_old_rec.attribute8;

466: per_psh_shd.g_old_rec.attribute7;
467: End If;
468: If (p_rec.attribute8 = hr_api.g_varchar2) then
469: p_rec.attribute8 :=
470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;

Line 474: per_psh_shd.g_old_rec.attribute9;

470: per_psh_shd.g_old_rec.attribute8;
471: End If;
472: If (p_rec.attribute9 = hr_api.g_varchar2) then
473: p_rec.attribute9 :=
474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;

Line 478: per_psh_shd.g_old_rec.attribute10;

474: per_psh_shd.g_old_rec.attribute9;
475: End If;
476: If (p_rec.attribute10 = hr_api.g_varchar2) then
477: p_rec.attribute10 :=
478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;

Line 482: per_psh_shd.g_old_rec.attribute11;

478: per_psh_shd.g_old_rec.attribute10;
479: End If;
480: If (p_rec.attribute11 = hr_api.g_varchar2) then
481: p_rec.attribute11 :=
482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;

Line 486: per_psh_shd.g_old_rec.attribute12;

482: per_psh_shd.g_old_rec.attribute11;
483: End If;
484: If (p_rec.attribute12 = hr_api.g_varchar2) then
485: p_rec.attribute12 :=
486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;

Line 490: per_psh_shd.g_old_rec.attribute13;

486: per_psh_shd.g_old_rec.attribute12;
487: End If;
488: If (p_rec.attribute13 = hr_api.g_varchar2) then
489: p_rec.attribute13 :=
490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;

Line 494: per_psh_shd.g_old_rec.attribute14;

490: per_psh_shd.g_old_rec.attribute13;
491: End If;
492: If (p_rec.attribute14 = hr_api.g_varchar2) then
493: p_rec.attribute14 :=
494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;

Line 498: per_psh_shd.g_old_rec.attribute15;

494: per_psh_shd.g_old_rec.attribute14;
495: End If;
496: If (p_rec.attribute15 = hr_api.g_varchar2) then
497: p_rec.attribute15 :=
498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;

Line 502: per_psh_shd.g_old_rec.attribute16;

498: per_psh_shd.g_old_rec.attribute15;
499: End If;
500: If (p_rec.attribute16 = hr_api.g_varchar2) then
501: p_rec.attribute16 :=
502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;

Line 506: per_psh_shd.g_old_rec.attribute17;

502: per_psh_shd.g_old_rec.attribute16;
503: End If;
504: If (p_rec.attribute17 = hr_api.g_varchar2) then
505: p_rec.attribute17 :=
506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;

Line 510: per_psh_shd.g_old_rec.attribute18;

506: per_psh_shd.g_old_rec.attribute17;
507: End If;
508: If (p_rec.attribute18 = hr_api.g_varchar2) then
509: p_rec.attribute18 :=
510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;

Line 514: per_psh_shd.g_old_rec.attribute19;

510: per_psh_shd.g_old_rec.attribute18;
511: End If;
512: If (p_rec.attribute19 = hr_api.g_varchar2) then
513: p_rec.attribute19 :=
514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;

Line 518: per_psh_shd.g_old_rec.attribute20;

514: per_psh_shd.g_old_rec.attribute19;
515: End If;
516: If (p_rec.attribute20 = hr_api.g_varchar2) then
517: p_rec.attribute20 :=
518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;

Line 522: per_psh_shd.g_old_rec.attribute21;

518: per_psh_shd.g_old_rec.attribute20;
519: End If;
520: If (p_rec.attribute21 = hr_api.g_varchar2) then
521: p_rec.attribute21 :=
522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;

Line 526: per_psh_shd.g_old_rec.attribute22;

522: per_psh_shd.g_old_rec.attribute21;
523: End If;
524: If (p_rec.attribute22 = hr_api.g_varchar2) then
525: p_rec.attribute22 :=
526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;

Line 530: per_psh_shd.g_old_rec.attribute23;

526: per_psh_shd.g_old_rec.attribute22;
527: End If;
528: If (p_rec.attribute23 = hr_api.g_varchar2) then
529: p_rec.attribute23 :=
530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;

Line 534: per_psh_shd.g_old_rec.attribute24;

530: per_psh_shd.g_old_rec.attribute23;
531: End If;
532: If (p_rec.attribute24 = hr_api.g_varchar2) then
533: p_rec.attribute24 :=
534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;

Line 538: per_psh_shd.g_old_rec.attribute25;

534: per_psh_shd.g_old_rec.attribute24;
535: End If;
536: If (p_rec.attribute25 = hr_api.g_varchar2) then
537: p_rec.attribute25 :=
538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;

Line 542: per_psh_shd.g_old_rec.attribute26;

538: per_psh_shd.g_old_rec.attribute25;
539: End If;
540: If (p_rec.attribute26 = hr_api.g_varchar2) then
541: p_rec.attribute26 :=
542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;

Line 546: per_psh_shd.g_old_rec.attribute27;

542: per_psh_shd.g_old_rec.attribute26;
543: End If;
544: If (p_rec.attribute27 = hr_api.g_varchar2) then
545: p_rec.attribute27 :=
546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;

Line 550: per_psh_shd.g_old_rec.attribute28;

546: per_psh_shd.g_old_rec.attribute27;
547: End If;
548: If (p_rec.attribute28 = hr_api.g_varchar2) then
549: p_rec.attribute28 :=
550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;

Line 554: per_psh_shd.g_old_rec.attribute29;

550: per_psh_shd.g_old_rec.attribute28;
551: End If;
552: If (p_rec.attribute29 = hr_api.g_varchar2) then
553: p_rec.attribute29 :=
554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
557: p_rec.attribute30 :=
558: per_psh_shd.g_old_rec.attribute30;

Line 558: per_psh_shd.g_old_rec.attribute30;

554: per_psh_shd.g_old_rec.attribute29;
555: End If;
556: If (p_rec.attribute30 = hr_api.g_varchar2) then
557: p_rec.attribute30 :=
558: per_psh_shd.g_old_rec.attribute30;
559: End If;
560: --
561: End convert_defs;
562: --

Line 567: (p_rec in out nocopy per_psh_shd.g_rec_type

563: -- ----------------------------------------------------------------------------
564: -- |---------------------------------< upd >----------------------------------|
565: -- ----------------------------------------------------------------------------
566: Procedure upd
567: (p_rec in out nocopy per_psh_shd.g_rec_type
568: ) is
569: --
570: l_proc varchar2(72) := g_package||'upd';
571: --

Line 577: per_psh_shd.lck

573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: -- We must lock the row which we need to update.
576: --
577: per_psh_shd.lck
578: (p_rec.sharing_instance_id
579: ,p_rec.object_version_number
580: );
581: --

Line 655: l_rec per_psh_shd.g_rec_type;

651: ,p_attribute29 in varchar2 default hr_api.g_varchar2
652: ,p_attribute30 in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_psh_shd.g_rec_type;
656: l_proc varchar2(72) := g_package||'upd';
657: --
658: Begin
659: hr_utility.set_location('Entering:'||l_proc, 5);

Line 665: per_psh_shd.convert_args

661: -- Call conversion function to turn arguments into the
662: -- l_rec structure.
663: --
664: l_rec :=
665: per_psh_shd.convert_args
666: (p_sharing_instance_id
667: ,p_object_version_number
668: ,p_scorecard_id
669: ,p_person_id