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.HR_TMP_UPD dependencies on HR_TMP_SHD

Line 55: (p_rec in out nocopy hr_tmp_shd.g_rec_type

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

Line 120: hr_tmp_shd.constraint_error

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

Line 125: hr_tmp_shd.constraint_error

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

Line 130: hr_tmp_shd.constraint_error

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

Line 170: (p_rec in hr_tmp_shd.g_rec_type

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

Line 215: ,p_rec in hr_tmp_shd.g_rec_type

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

Line 303: => hr_tmp_shd.g_old_rec.object_version_number

299: => p_rec.attribute29
300: ,p_attribute30
301: => p_rec.attribute30
302: ,p_object_version_number_o
303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id

Line 305: => hr_tmp_shd.g_old_rec.application_id

301: => p_rec.attribute30
302: ,p_object_version_number_o
303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name

Line 307: => hr_tmp_shd.g_old_rec.form_id

303: => hr_tmp_shd.g_old_rec.object_version_number
304: ,p_application_id_o
305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag

Line 309: => hr_tmp_shd.g_old_rec.template_name

305: => hr_tmp_shd.g_old_rec.application_id
306: ,p_form_id_o
307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code

Line 311: => hr_tmp_shd.g_old_rec.enabled_flag

307: => hr_tmp_shd.g_old_rec.form_id
308: ,p_template_name_o
309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category

Line 313: => hr_tmp_shd.g_old_rec.legislation_code

309: => hr_tmp_shd.g_old_rec.template_name
310: ,p_enabled_flag_o
311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1

Line 315: => hr_tmp_shd.g_old_rec.attribute_category

311: => hr_tmp_shd.g_old_rec.enabled_flag
312: ,p_legislation_code_o
313: => hr_tmp_shd.g_old_rec.legislation_code
314: ,p_attribute_category_o
315: => hr_tmp_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => hr_tmp_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => hr_tmp_shd.g_old_rec.attribute2

Line 317: => hr_tmp_shd.g_old_rec.attribute1

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

Line 319: => hr_tmp_shd.g_old_rec.attribute2

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

Line 321: => hr_tmp_shd.g_old_rec.attribute3

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

Line 323: => hr_tmp_shd.g_old_rec.attribute4

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

Line 325: => hr_tmp_shd.g_old_rec.attribute5

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

Line 327: => hr_tmp_shd.g_old_rec.attribute6

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

Line 329: => hr_tmp_shd.g_old_rec.attribute7

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

Line 331: => hr_tmp_shd.g_old_rec.attribute8

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

Line 333: => hr_tmp_shd.g_old_rec.attribute9

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

Line 335: => hr_tmp_shd.g_old_rec.attribute10

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

Line 337: => hr_tmp_shd.g_old_rec.attribute11

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

Line 339: => hr_tmp_shd.g_old_rec.attribute12

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

Line 341: => hr_tmp_shd.g_old_rec.attribute13

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

Line 343: => hr_tmp_shd.g_old_rec.attribute14

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

Line 345: => hr_tmp_shd.g_old_rec.attribute15

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

Line 347: => hr_tmp_shd.g_old_rec.attribute16

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

Line 349: => hr_tmp_shd.g_old_rec.attribute17

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

Line 351: => hr_tmp_shd.g_old_rec.attribute18

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

Line 353: => hr_tmp_shd.g_old_rec.attribute19

349: => hr_tmp_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21

Line 355: => hr_tmp_shd.g_old_rec.attribute20

351: => hr_tmp_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22

Line 357: => hr_tmp_shd.g_old_rec.attribute21

353: => hr_tmp_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23

Line 359: => hr_tmp_shd.g_old_rec.attribute22

355: => hr_tmp_shd.g_old_rec.attribute20
356: ,p_attribute21_o
357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24

Line 361: => hr_tmp_shd.g_old_rec.attribute23

357: => hr_tmp_shd.g_old_rec.attribute21
358: ,p_attribute22_o
359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25

Line 363: => hr_tmp_shd.g_old_rec.attribute24

359: => hr_tmp_shd.g_old_rec.attribute22
360: ,p_attribute23_o
361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26

Line 365: => hr_tmp_shd.g_old_rec.attribute25

361: => hr_tmp_shd.g_old_rec.attribute23
362: ,p_attribute24_o
363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27

Line 367: => hr_tmp_shd.g_old_rec.attribute26

363: => hr_tmp_shd.g_old_rec.attribute24
364: ,p_attribute25_o
365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28

Line 369: => hr_tmp_shd.g_old_rec.attribute27

365: => hr_tmp_shd.g_old_rec.attribute25
366: ,p_attribute26_o
367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29

Line 371: => hr_tmp_shd.g_old_rec.attribute28

367: => hr_tmp_shd.g_old_rec.attribute26
368: ,p_attribute27_o
369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30

Line 373: => hr_tmp_shd.g_old_rec.attribute29

369: => hr_tmp_shd.g_old_rec.attribute27
370: ,p_attribute28_o
371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30
376: );
377: --

Line 375: => hr_tmp_shd.g_old_rec.attribute30

371: => hr_tmp_shd.g_old_rec.attribute28
372: ,p_attribute29_o
373: => hr_tmp_shd.g_old_rec.attribute29
374: ,p_attribute30_o
375: => hr_tmp_shd.g_old_rec.attribute30
376: );
377: --
378: exception
379: --

Line 435: (p_rec in out nocopy hr_tmp_shd.g_rec_type

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

Line 447: hr_tmp_shd.g_old_rec.application_id;

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

Line 451: hr_tmp_shd.g_old_rec.form_id;

447: hr_tmp_shd.g_old_rec.application_id;
448: End If;
449: If (p_rec.form_id = hr_api.g_number) then
450: p_rec.form_id :=
451: hr_tmp_shd.g_old_rec.form_id;
452: End If;
453: If (p_rec.template_name = hr_api.g_varchar2) then
454: p_rec.template_name :=
455: hr_tmp_shd.g_old_rec.template_name;

Line 455: hr_tmp_shd.g_old_rec.template_name;

451: hr_tmp_shd.g_old_rec.form_id;
452: End If;
453: If (p_rec.template_name = hr_api.g_varchar2) then
454: p_rec.template_name :=
455: hr_tmp_shd.g_old_rec.template_name;
456: End If;
457: If (p_rec.enabled_flag = hr_api.g_varchar2) then
458: p_rec.enabled_flag :=
459: hr_tmp_shd.g_old_rec.enabled_flag;

Line 459: hr_tmp_shd.g_old_rec.enabled_flag;

455: hr_tmp_shd.g_old_rec.template_name;
456: End If;
457: If (p_rec.enabled_flag = hr_api.g_varchar2) then
458: p_rec.enabled_flag :=
459: hr_tmp_shd.g_old_rec.enabled_flag;
460: End If;
461: If (p_rec.legislation_code = hr_api.g_varchar2) then
462: p_rec.legislation_code :=
463: hr_tmp_shd.g_old_rec.legislation_code;

Line 463: hr_tmp_shd.g_old_rec.legislation_code;

459: hr_tmp_shd.g_old_rec.enabled_flag;
460: End If;
461: If (p_rec.legislation_code = hr_api.g_varchar2) then
462: p_rec.legislation_code :=
463: hr_tmp_shd.g_old_rec.legislation_code;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: hr_tmp_shd.g_old_rec.attribute_category;

Line 467: hr_tmp_shd.g_old_rec.attribute_category;

463: hr_tmp_shd.g_old_rec.legislation_code;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: hr_tmp_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: hr_tmp_shd.g_old_rec.attribute1;

Line 471: hr_tmp_shd.g_old_rec.attribute1;

467: hr_tmp_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: hr_tmp_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: hr_tmp_shd.g_old_rec.attribute2;

Line 475: hr_tmp_shd.g_old_rec.attribute2;

471: hr_tmp_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: hr_tmp_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: hr_tmp_shd.g_old_rec.attribute3;

Line 479: hr_tmp_shd.g_old_rec.attribute3;

475: hr_tmp_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: hr_tmp_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: hr_tmp_shd.g_old_rec.attribute4;

Line 483: hr_tmp_shd.g_old_rec.attribute4;

479: hr_tmp_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: hr_tmp_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: hr_tmp_shd.g_old_rec.attribute5;

Line 487: hr_tmp_shd.g_old_rec.attribute5;

483: hr_tmp_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: hr_tmp_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: hr_tmp_shd.g_old_rec.attribute6;

Line 491: hr_tmp_shd.g_old_rec.attribute6;

487: hr_tmp_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: hr_tmp_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: hr_tmp_shd.g_old_rec.attribute7;

Line 495: hr_tmp_shd.g_old_rec.attribute7;

491: hr_tmp_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: hr_tmp_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: hr_tmp_shd.g_old_rec.attribute8;

Line 499: hr_tmp_shd.g_old_rec.attribute8;

495: hr_tmp_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: hr_tmp_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: hr_tmp_shd.g_old_rec.attribute9;

Line 503: hr_tmp_shd.g_old_rec.attribute9;

499: hr_tmp_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: hr_tmp_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: hr_tmp_shd.g_old_rec.attribute10;

Line 507: hr_tmp_shd.g_old_rec.attribute10;

503: hr_tmp_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: hr_tmp_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: hr_tmp_shd.g_old_rec.attribute11;

Line 511: hr_tmp_shd.g_old_rec.attribute11;

507: hr_tmp_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: hr_tmp_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: hr_tmp_shd.g_old_rec.attribute12;

Line 515: hr_tmp_shd.g_old_rec.attribute12;

511: hr_tmp_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: hr_tmp_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: hr_tmp_shd.g_old_rec.attribute13;

Line 519: hr_tmp_shd.g_old_rec.attribute13;

515: hr_tmp_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: hr_tmp_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: hr_tmp_shd.g_old_rec.attribute14;

Line 523: hr_tmp_shd.g_old_rec.attribute14;

519: hr_tmp_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: hr_tmp_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: hr_tmp_shd.g_old_rec.attribute15;

Line 527: hr_tmp_shd.g_old_rec.attribute15;

523: hr_tmp_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: hr_tmp_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: hr_tmp_shd.g_old_rec.attribute16;

Line 531: hr_tmp_shd.g_old_rec.attribute16;

527: hr_tmp_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: hr_tmp_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: hr_tmp_shd.g_old_rec.attribute17;

Line 535: hr_tmp_shd.g_old_rec.attribute17;

531: hr_tmp_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: hr_tmp_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: hr_tmp_shd.g_old_rec.attribute18;

Line 539: hr_tmp_shd.g_old_rec.attribute18;

535: hr_tmp_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: hr_tmp_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: hr_tmp_shd.g_old_rec.attribute19;

Line 543: hr_tmp_shd.g_old_rec.attribute19;

539: hr_tmp_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: hr_tmp_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: hr_tmp_shd.g_old_rec.attribute20;

Line 547: hr_tmp_shd.g_old_rec.attribute20;

543: hr_tmp_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: hr_tmp_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.attribute21 = hr_api.g_varchar2) then
550: p_rec.attribute21 :=
551: hr_tmp_shd.g_old_rec.attribute21;

Line 551: hr_tmp_shd.g_old_rec.attribute21;

547: hr_tmp_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.attribute21 = hr_api.g_varchar2) then
550: p_rec.attribute21 :=
551: hr_tmp_shd.g_old_rec.attribute21;
552: End If;
553: If (p_rec.attribute22 = hr_api.g_varchar2) then
554: p_rec.attribute22 :=
555: hr_tmp_shd.g_old_rec.attribute22;

Line 555: hr_tmp_shd.g_old_rec.attribute22;

551: hr_tmp_shd.g_old_rec.attribute21;
552: End If;
553: If (p_rec.attribute22 = hr_api.g_varchar2) then
554: p_rec.attribute22 :=
555: hr_tmp_shd.g_old_rec.attribute22;
556: End If;
557: If (p_rec.attribute23 = hr_api.g_varchar2) then
558: p_rec.attribute23 :=
559: hr_tmp_shd.g_old_rec.attribute23;

Line 559: hr_tmp_shd.g_old_rec.attribute23;

555: hr_tmp_shd.g_old_rec.attribute22;
556: End If;
557: If (p_rec.attribute23 = hr_api.g_varchar2) then
558: p_rec.attribute23 :=
559: hr_tmp_shd.g_old_rec.attribute23;
560: End If;
561: If (p_rec.attribute24 = hr_api.g_varchar2) then
562: p_rec.attribute24 :=
563: hr_tmp_shd.g_old_rec.attribute24;

Line 563: hr_tmp_shd.g_old_rec.attribute24;

559: hr_tmp_shd.g_old_rec.attribute23;
560: End If;
561: If (p_rec.attribute24 = hr_api.g_varchar2) then
562: p_rec.attribute24 :=
563: hr_tmp_shd.g_old_rec.attribute24;
564: End If;
565: If (p_rec.attribute25 = hr_api.g_varchar2) then
566: p_rec.attribute25 :=
567: hr_tmp_shd.g_old_rec.attribute25;

Line 567: hr_tmp_shd.g_old_rec.attribute25;

563: hr_tmp_shd.g_old_rec.attribute24;
564: End If;
565: If (p_rec.attribute25 = hr_api.g_varchar2) then
566: p_rec.attribute25 :=
567: hr_tmp_shd.g_old_rec.attribute25;
568: End If;
569: If (p_rec.attribute26 = hr_api.g_varchar2) then
570: p_rec.attribute26 :=
571: hr_tmp_shd.g_old_rec.attribute26;

Line 571: hr_tmp_shd.g_old_rec.attribute26;

567: hr_tmp_shd.g_old_rec.attribute25;
568: End If;
569: If (p_rec.attribute26 = hr_api.g_varchar2) then
570: p_rec.attribute26 :=
571: hr_tmp_shd.g_old_rec.attribute26;
572: End If;
573: If (p_rec.attribute27 = hr_api.g_varchar2) then
574: p_rec.attribute27 :=
575: hr_tmp_shd.g_old_rec.attribute27;

Line 575: hr_tmp_shd.g_old_rec.attribute27;

571: hr_tmp_shd.g_old_rec.attribute26;
572: End If;
573: If (p_rec.attribute27 = hr_api.g_varchar2) then
574: p_rec.attribute27 :=
575: hr_tmp_shd.g_old_rec.attribute27;
576: End If;
577: If (p_rec.attribute28 = hr_api.g_varchar2) then
578: p_rec.attribute28 :=
579: hr_tmp_shd.g_old_rec.attribute28;

Line 579: hr_tmp_shd.g_old_rec.attribute28;

575: hr_tmp_shd.g_old_rec.attribute27;
576: End If;
577: If (p_rec.attribute28 = hr_api.g_varchar2) then
578: p_rec.attribute28 :=
579: hr_tmp_shd.g_old_rec.attribute28;
580: End If;
581: If (p_rec.attribute29 = hr_api.g_varchar2) then
582: p_rec.attribute29 :=
583: hr_tmp_shd.g_old_rec.attribute29;

Line 583: hr_tmp_shd.g_old_rec.attribute29;

579: hr_tmp_shd.g_old_rec.attribute28;
580: End If;
581: If (p_rec.attribute29 = hr_api.g_varchar2) then
582: p_rec.attribute29 :=
583: hr_tmp_shd.g_old_rec.attribute29;
584: End If;
585: If (p_rec.attribute30 = hr_api.g_varchar2) then
586: p_rec.attribute30 :=
587: hr_tmp_shd.g_old_rec.attribute30;

Line 587: hr_tmp_shd.g_old_rec.attribute30;

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

Line 597: ,p_rec in out nocopy hr_tmp_shd.g_rec_type

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

Line 607: hr_tmp_shd.lck

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

Line 685: l_rec hr_tmp_shd.g_rec_type;

681: ,p_attribute29 in varchar2 default hr_api.g_varchar2
682: ,p_attribute30 in varchar2 default hr_api.g_varchar2
683: ) is
684: --
685: l_rec hr_tmp_shd.g_rec_type;
686: l_proc varchar2(72) := g_package||'upd';
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);

Line 695: hr_tmp_shd.convert_args

691: -- Call conversion function to turn arguments into the
692: -- l_rec structure.
693: --
694: l_rec :=
695: hr_tmp_shd.convert_args
696: (p_form_template_id
697: ,p_object_version_number
698: ,p_application_id
699: ,p_form_id