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.HXC_HAV_UPD dependencies on HXC_HAV_SHD

Line 56: (p_rec in out nocopy hxc_hav_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_hav_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72);
60: --

Line 130: hxc_hav_shd.constraint_error

126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: hxc_hav_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --

Line 135: hxc_hav_shd.constraint_error

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

Line 140: hxc_hav_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: hxc_hav_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: --
144: Raise;

Line 180: (p_rec in hxc_hav_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure pre_update
180: (p_rec in hxc_hav_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72);
184: --

Line 227: (p_rec in hxc_hav_shd.g_rec_type

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update
227: (p_rec in hxc_hav_shd.g_rec_type
228: ) is
229: --
230: l_proc varchar2(72);
231: --

Line 319: => hxc_hav_shd.g_old_rec.alias_value_name

315: => p_rec.attribute30
316: ,p_object_version_number
317: => p_rec.object_version_number
318: ,p_alias_value_name_o
319: => hxc_hav_shd.g_old_rec.alias_value_name
320: ,p_date_from_o
321: => hxc_hav_shd.g_old_rec.date_from
322: ,p_date_to_o
323: => hxc_hav_shd.g_old_rec.date_to

Line 321: => hxc_hav_shd.g_old_rec.date_from

317: => p_rec.object_version_number
318: ,p_alias_value_name_o
319: => hxc_hav_shd.g_old_rec.alias_value_name
320: ,p_date_from_o
321: => hxc_hav_shd.g_old_rec.date_from
322: ,p_date_to_o
323: => hxc_hav_shd.g_old_rec.date_to
324: ,p_alias_definition_id_o
325: => hxc_hav_shd.g_old_rec.alias_definition_id

Line 323: => hxc_hav_shd.g_old_rec.date_to

319: => hxc_hav_shd.g_old_rec.alias_value_name
320: ,p_date_from_o
321: => hxc_hav_shd.g_old_rec.date_from
322: ,p_date_to_o
323: => hxc_hav_shd.g_old_rec.date_to
324: ,p_alias_definition_id_o
325: => hxc_hav_shd.g_old_rec.alias_definition_id
326: ,p_enabled_flag_o
327: => hxc_hav_shd.g_old_rec.enabled_flag

Line 325: => hxc_hav_shd.g_old_rec.alias_definition_id

321: => hxc_hav_shd.g_old_rec.date_from
322: ,p_date_to_o
323: => hxc_hav_shd.g_old_rec.date_to
324: ,p_alias_definition_id_o
325: => hxc_hav_shd.g_old_rec.alias_definition_id
326: ,p_enabled_flag_o
327: => hxc_hav_shd.g_old_rec.enabled_flag
328: ,p_attribute_category_o
329: => hxc_hav_shd.g_old_rec.attribute_category

Line 327: => hxc_hav_shd.g_old_rec.enabled_flag

323: => hxc_hav_shd.g_old_rec.date_to
324: ,p_alias_definition_id_o
325: => hxc_hav_shd.g_old_rec.alias_definition_id
326: ,p_enabled_flag_o
327: => hxc_hav_shd.g_old_rec.enabled_flag
328: ,p_attribute_category_o
329: => hxc_hav_shd.g_old_rec.attribute_category
330: ,p_attribute1_o
331: => hxc_hav_shd.g_old_rec.attribute1

Line 329: => hxc_hav_shd.g_old_rec.attribute_category

325: => hxc_hav_shd.g_old_rec.alias_definition_id
326: ,p_enabled_flag_o
327: => hxc_hav_shd.g_old_rec.enabled_flag
328: ,p_attribute_category_o
329: => hxc_hav_shd.g_old_rec.attribute_category
330: ,p_attribute1_o
331: => hxc_hav_shd.g_old_rec.attribute1
332: ,p_attribute2_o
333: => hxc_hav_shd.g_old_rec.attribute2

Line 331: => hxc_hav_shd.g_old_rec.attribute1

327: => hxc_hav_shd.g_old_rec.enabled_flag
328: ,p_attribute_category_o
329: => hxc_hav_shd.g_old_rec.attribute_category
330: ,p_attribute1_o
331: => hxc_hav_shd.g_old_rec.attribute1
332: ,p_attribute2_o
333: => hxc_hav_shd.g_old_rec.attribute2
334: ,p_attribute3_o
335: => hxc_hav_shd.g_old_rec.attribute3

Line 333: => hxc_hav_shd.g_old_rec.attribute2

329: => hxc_hav_shd.g_old_rec.attribute_category
330: ,p_attribute1_o
331: => hxc_hav_shd.g_old_rec.attribute1
332: ,p_attribute2_o
333: => hxc_hav_shd.g_old_rec.attribute2
334: ,p_attribute3_o
335: => hxc_hav_shd.g_old_rec.attribute3
336: ,p_attribute4_o
337: => hxc_hav_shd.g_old_rec.attribute4

Line 335: => hxc_hav_shd.g_old_rec.attribute3

331: => hxc_hav_shd.g_old_rec.attribute1
332: ,p_attribute2_o
333: => hxc_hav_shd.g_old_rec.attribute2
334: ,p_attribute3_o
335: => hxc_hav_shd.g_old_rec.attribute3
336: ,p_attribute4_o
337: => hxc_hav_shd.g_old_rec.attribute4
338: ,p_attribute5_o
339: => hxc_hav_shd.g_old_rec.attribute5

Line 337: => hxc_hav_shd.g_old_rec.attribute4

333: => hxc_hav_shd.g_old_rec.attribute2
334: ,p_attribute3_o
335: => hxc_hav_shd.g_old_rec.attribute3
336: ,p_attribute4_o
337: => hxc_hav_shd.g_old_rec.attribute4
338: ,p_attribute5_o
339: => hxc_hav_shd.g_old_rec.attribute5
340: ,p_attribute6_o
341: => hxc_hav_shd.g_old_rec.attribute6

Line 339: => hxc_hav_shd.g_old_rec.attribute5

335: => hxc_hav_shd.g_old_rec.attribute3
336: ,p_attribute4_o
337: => hxc_hav_shd.g_old_rec.attribute4
338: ,p_attribute5_o
339: => hxc_hav_shd.g_old_rec.attribute5
340: ,p_attribute6_o
341: => hxc_hav_shd.g_old_rec.attribute6
342: ,p_attribute7_o
343: => hxc_hav_shd.g_old_rec.attribute7

Line 341: => hxc_hav_shd.g_old_rec.attribute6

337: => hxc_hav_shd.g_old_rec.attribute4
338: ,p_attribute5_o
339: => hxc_hav_shd.g_old_rec.attribute5
340: ,p_attribute6_o
341: => hxc_hav_shd.g_old_rec.attribute6
342: ,p_attribute7_o
343: => hxc_hav_shd.g_old_rec.attribute7
344: ,p_attribute8_o
345: => hxc_hav_shd.g_old_rec.attribute8

Line 343: => hxc_hav_shd.g_old_rec.attribute7

339: => hxc_hav_shd.g_old_rec.attribute5
340: ,p_attribute6_o
341: => hxc_hav_shd.g_old_rec.attribute6
342: ,p_attribute7_o
343: => hxc_hav_shd.g_old_rec.attribute7
344: ,p_attribute8_o
345: => hxc_hav_shd.g_old_rec.attribute8
346: ,p_attribute9_o
347: => hxc_hav_shd.g_old_rec.attribute9

Line 345: => hxc_hav_shd.g_old_rec.attribute8

341: => hxc_hav_shd.g_old_rec.attribute6
342: ,p_attribute7_o
343: => hxc_hav_shd.g_old_rec.attribute7
344: ,p_attribute8_o
345: => hxc_hav_shd.g_old_rec.attribute8
346: ,p_attribute9_o
347: => hxc_hav_shd.g_old_rec.attribute9
348: ,p_attribute10_o
349: => hxc_hav_shd.g_old_rec.attribute10

Line 347: => hxc_hav_shd.g_old_rec.attribute9

343: => hxc_hav_shd.g_old_rec.attribute7
344: ,p_attribute8_o
345: => hxc_hav_shd.g_old_rec.attribute8
346: ,p_attribute9_o
347: => hxc_hav_shd.g_old_rec.attribute9
348: ,p_attribute10_o
349: => hxc_hav_shd.g_old_rec.attribute10
350: ,p_attribute11_o
351: => hxc_hav_shd.g_old_rec.attribute11

Line 349: => hxc_hav_shd.g_old_rec.attribute10

345: => hxc_hav_shd.g_old_rec.attribute8
346: ,p_attribute9_o
347: => hxc_hav_shd.g_old_rec.attribute9
348: ,p_attribute10_o
349: => hxc_hav_shd.g_old_rec.attribute10
350: ,p_attribute11_o
351: => hxc_hav_shd.g_old_rec.attribute11
352: ,p_attribute12_o
353: => hxc_hav_shd.g_old_rec.attribute12

Line 351: => hxc_hav_shd.g_old_rec.attribute11

347: => hxc_hav_shd.g_old_rec.attribute9
348: ,p_attribute10_o
349: => hxc_hav_shd.g_old_rec.attribute10
350: ,p_attribute11_o
351: => hxc_hav_shd.g_old_rec.attribute11
352: ,p_attribute12_o
353: => hxc_hav_shd.g_old_rec.attribute12
354: ,p_attribute13_o
355: => hxc_hav_shd.g_old_rec.attribute13

Line 353: => hxc_hav_shd.g_old_rec.attribute12

349: => hxc_hav_shd.g_old_rec.attribute10
350: ,p_attribute11_o
351: => hxc_hav_shd.g_old_rec.attribute11
352: ,p_attribute12_o
353: => hxc_hav_shd.g_old_rec.attribute12
354: ,p_attribute13_o
355: => hxc_hav_shd.g_old_rec.attribute13
356: ,p_attribute14_o
357: => hxc_hav_shd.g_old_rec.attribute14

Line 355: => hxc_hav_shd.g_old_rec.attribute13

351: => hxc_hav_shd.g_old_rec.attribute11
352: ,p_attribute12_o
353: => hxc_hav_shd.g_old_rec.attribute12
354: ,p_attribute13_o
355: => hxc_hav_shd.g_old_rec.attribute13
356: ,p_attribute14_o
357: => hxc_hav_shd.g_old_rec.attribute14
358: ,p_attribute15_o
359: => hxc_hav_shd.g_old_rec.attribute15

Line 357: => hxc_hav_shd.g_old_rec.attribute14

353: => hxc_hav_shd.g_old_rec.attribute12
354: ,p_attribute13_o
355: => hxc_hav_shd.g_old_rec.attribute13
356: ,p_attribute14_o
357: => hxc_hav_shd.g_old_rec.attribute14
358: ,p_attribute15_o
359: => hxc_hav_shd.g_old_rec.attribute15
360: ,p_attribute16_o
361: => hxc_hav_shd.g_old_rec.attribute16

Line 359: => hxc_hav_shd.g_old_rec.attribute15

355: => hxc_hav_shd.g_old_rec.attribute13
356: ,p_attribute14_o
357: => hxc_hav_shd.g_old_rec.attribute14
358: ,p_attribute15_o
359: => hxc_hav_shd.g_old_rec.attribute15
360: ,p_attribute16_o
361: => hxc_hav_shd.g_old_rec.attribute16
362: ,p_attribute17_o
363: => hxc_hav_shd.g_old_rec.attribute17

Line 361: => hxc_hav_shd.g_old_rec.attribute16

357: => hxc_hav_shd.g_old_rec.attribute14
358: ,p_attribute15_o
359: => hxc_hav_shd.g_old_rec.attribute15
360: ,p_attribute16_o
361: => hxc_hav_shd.g_old_rec.attribute16
362: ,p_attribute17_o
363: => hxc_hav_shd.g_old_rec.attribute17
364: ,p_attribute18_o
365: => hxc_hav_shd.g_old_rec.attribute18

Line 363: => hxc_hav_shd.g_old_rec.attribute17

359: => hxc_hav_shd.g_old_rec.attribute15
360: ,p_attribute16_o
361: => hxc_hav_shd.g_old_rec.attribute16
362: ,p_attribute17_o
363: => hxc_hav_shd.g_old_rec.attribute17
364: ,p_attribute18_o
365: => hxc_hav_shd.g_old_rec.attribute18
366: ,p_attribute19_o
367: => hxc_hav_shd.g_old_rec.attribute19

Line 365: => hxc_hav_shd.g_old_rec.attribute18

361: => hxc_hav_shd.g_old_rec.attribute16
362: ,p_attribute17_o
363: => hxc_hav_shd.g_old_rec.attribute17
364: ,p_attribute18_o
365: => hxc_hav_shd.g_old_rec.attribute18
366: ,p_attribute19_o
367: => hxc_hav_shd.g_old_rec.attribute19
368: ,p_attribute20_o
369: => hxc_hav_shd.g_old_rec.attribute20

Line 367: => hxc_hav_shd.g_old_rec.attribute19

363: => hxc_hav_shd.g_old_rec.attribute17
364: ,p_attribute18_o
365: => hxc_hav_shd.g_old_rec.attribute18
366: ,p_attribute19_o
367: => hxc_hav_shd.g_old_rec.attribute19
368: ,p_attribute20_o
369: => hxc_hav_shd.g_old_rec.attribute20
370: ,p_attribute21_o
371: => hxc_hav_shd.g_old_rec.attribute21

Line 369: => hxc_hav_shd.g_old_rec.attribute20

365: => hxc_hav_shd.g_old_rec.attribute18
366: ,p_attribute19_o
367: => hxc_hav_shd.g_old_rec.attribute19
368: ,p_attribute20_o
369: => hxc_hav_shd.g_old_rec.attribute20
370: ,p_attribute21_o
371: => hxc_hav_shd.g_old_rec.attribute21
372: ,p_attribute22_o
373: => hxc_hav_shd.g_old_rec.attribute22

Line 371: => hxc_hav_shd.g_old_rec.attribute21

367: => hxc_hav_shd.g_old_rec.attribute19
368: ,p_attribute20_o
369: => hxc_hav_shd.g_old_rec.attribute20
370: ,p_attribute21_o
371: => hxc_hav_shd.g_old_rec.attribute21
372: ,p_attribute22_o
373: => hxc_hav_shd.g_old_rec.attribute22
374: ,p_attribute23_o
375: => hxc_hav_shd.g_old_rec.attribute23

Line 373: => hxc_hav_shd.g_old_rec.attribute22

369: => hxc_hav_shd.g_old_rec.attribute20
370: ,p_attribute21_o
371: => hxc_hav_shd.g_old_rec.attribute21
372: ,p_attribute22_o
373: => hxc_hav_shd.g_old_rec.attribute22
374: ,p_attribute23_o
375: => hxc_hav_shd.g_old_rec.attribute23
376: ,p_attribute24_o
377: => hxc_hav_shd.g_old_rec.attribute24

Line 375: => hxc_hav_shd.g_old_rec.attribute23

371: => hxc_hav_shd.g_old_rec.attribute21
372: ,p_attribute22_o
373: => hxc_hav_shd.g_old_rec.attribute22
374: ,p_attribute23_o
375: => hxc_hav_shd.g_old_rec.attribute23
376: ,p_attribute24_o
377: => hxc_hav_shd.g_old_rec.attribute24
378: ,p_attribute25_o
379: => hxc_hav_shd.g_old_rec.attribute25

Line 377: => hxc_hav_shd.g_old_rec.attribute24

373: => hxc_hav_shd.g_old_rec.attribute22
374: ,p_attribute23_o
375: => hxc_hav_shd.g_old_rec.attribute23
376: ,p_attribute24_o
377: => hxc_hav_shd.g_old_rec.attribute24
378: ,p_attribute25_o
379: => hxc_hav_shd.g_old_rec.attribute25
380: ,p_attribute26_o
381: => hxc_hav_shd.g_old_rec.attribute26

Line 379: => hxc_hav_shd.g_old_rec.attribute25

375: => hxc_hav_shd.g_old_rec.attribute23
376: ,p_attribute24_o
377: => hxc_hav_shd.g_old_rec.attribute24
378: ,p_attribute25_o
379: => hxc_hav_shd.g_old_rec.attribute25
380: ,p_attribute26_o
381: => hxc_hav_shd.g_old_rec.attribute26
382: ,p_attribute27_o
383: => hxc_hav_shd.g_old_rec.attribute27

Line 381: => hxc_hav_shd.g_old_rec.attribute26

377: => hxc_hav_shd.g_old_rec.attribute24
378: ,p_attribute25_o
379: => hxc_hav_shd.g_old_rec.attribute25
380: ,p_attribute26_o
381: => hxc_hav_shd.g_old_rec.attribute26
382: ,p_attribute27_o
383: => hxc_hav_shd.g_old_rec.attribute27
384: ,p_attribute28_o
385: => hxc_hav_shd.g_old_rec.attribute28

Line 383: => hxc_hav_shd.g_old_rec.attribute27

379: => hxc_hav_shd.g_old_rec.attribute25
380: ,p_attribute26_o
381: => hxc_hav_shd.g_old_rec.attribute26
382: ,p_attribute27_o
383: => hxc_hav_shd.g_old_rec.attribute27
384: ,p_attribute28_o
385: => hxc_hav_shd.g_old_rec.attribute28
386: ,p_attribute29_o
387: => hxc_hav_shd.g_old_rec.attribute29

Line 385: => hxc_hav_shd.g_old_rec.attribute28

381: => hxc_hav_shd.g_old_rec.attribute26
382: ,p_attribute27_o
383: => hxc_hav_shd.g_old_rec.attribute27
384: ,p_attribute28_o
385: => hxc_hav_shd.g_old_rec.attribute28
386: ,p_attribute29_o
387: => hxc_hav_shd.g_old_rec.attribute29
388: ,p_attribute30_o
389: => hxc_hav_shd.g_old_rec.attribute30

Line 387: => hxc_hav_shd.g_old_rec.attribute29

383: => hxc_hav_shd.g_old_rec.attribute27
384: ,p_attribute28_o
385: => hxc_hav_shd.g_old_rec.attribute28
386: ,p_attribute29_o
387: => hxc_hav_shd.g_old_rec.attribute29
388: ,p_attribute30_o
389: => hxc_hav_shd.g_old_rec.attribute30
390: ,p_object_version_number_o
391: => hxc_hav_shd.g_old_rec.object_version_number

Line 389: => hxc_hav_shd.g_old_rec.attribute30

385: => hxc_hav_shd.g_old_rec.attribute28
386: ,p_attribute29_o
387: => hxc_hav_shd.g_old_rec.attribute29
388: ,p_attribute30_o
389: => hxc_hav_shd.g_old_rec.attribute30
390: ,p_object_version_number_o
391: => hxc_hav_shd.g_old_rec.object_version_number
392: );
393: --

Line 391: => hxc_hav_shd.g_old_rec.object_version_number

387: => hxc_hav_shd.g_old_rec.attribute29
388: ,p_attribute30_o
389: => hxc_hav_shd.g_old_rec.attribute30
390: ,p_object_version_number_o
391: => hxc_hav_shd.g_old_rec.object_version_number
392: );
393: --
394: exception
395: --

Line 453: (p_rec in out nocopy hxc_hav_shd.g_rec_type

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

Line 465: hxc_hav_shd.g_old_rec.alias_value_name;

461: -- is being used then we must set to the 'current' argument value.
462: --
463: If (p_rec.alias_value_name = hr_api.g_varchar2) then
464: p_rec.alias_value_name :=
465: hxc_hav_shd.g_old_rec.alias_value_name;
466: End If;
467: If (p_rec.date_from = hr_api.g_date) then
468: p_rec.date_from :=
469: hxc_hav_shd.g_old_rec.date_from;

Line 469: hxc_hav_shd.g_old_rec.date_from;

465: hxc_hav_shd.g_old_rec.alias_value_name;
466: End If;
467: If (p_rec.date_from = hr_api.g_date) then
468: p_rec.date_from :=
469: hxc_hav_shd.g_old_rec.date_from;
470: End If;
471: If (p_rec.date_to = hr_api.g_date) then
472: p_rec.date_to :=
473: hxc_hav_shd.g_old_rec.date_to;

Line 473: hxc_hav_shd.g_old_rec.date_to;

469: hxc_hav_shd.g_old_rec.date_from;
470: End If;
471: If (p_rec.date_to = hr_api.g_date) then
472: p_rec.date_to :=
473: hxc_hav_shd.g_old_rec.date_to;
474: End If;
475: If (p_rec.alias_definition_id = hr_api.g_number) then
476: p_rec.alias_definition_id :=
477: hxc_hav_shd.g_old_rec.alias_definition_id;

Line 477: hxc_hav_shd.g_old_rec.alias_definition_id;

473: hxc_hav_shd.g_old_rec.date_to;
474: End If;
475: If (p_rec.alias_definition_id = hr_api.g_number) then
476: p_rec.alias_definition_id :=
477: hxc_hav_shd.g_old_rec.alias_definition_id;
478: End If;
479: If (p_rec.enabled_flag = hr_api.g_varchar2) then
480: p_rec.enabled_flag :=
481: hxc_hav_shd.g_old_rec.enabled_flag;

Line 481: hxc_hav_shd.g_old_rec.enabled_flag;

477: hxc_hav_shd.g_old_rec.alias_definition_id;
478: End If;
479: If (p_rec.enabled_flag = hr_api.g_varchar2) then
480: p_rec.enabled_flag :=
481: hxc_hav_shd.g_old_rec.enabled_flag;
482: End If;
483: If (p_rec.attribute_category = hr_api.g_varchar2) then
484: p_rec.attribute_category :=
485: hxc_hav_shd.g_old_rec.attribute_category;

Line 485: hxc_hav_shd.g_old_rec.attribute_category;

481: hxc_hav_shd.g_old_rec.enabled_flag;
482: End If;
483: If (p_rec.attribute_category = hr_api.g_varchar2) then
484: p_rec.attribute_category :=
485: hxc_hav_shd.g_old_rec.attribute_category;
486: End If;
487: If (p_rec.attribute1 = hr_api.g_varchar2) then
488: p_rec.attribute1 :=
489: hxc_hav_shd.g_old_rec.attribute1;

Line 489: hxc_hav_shd.g_old_rec.attribute1;

485: hxc_hav_shd.g_old_rec.attribute_category;
486: End If;
487: If (p_rec.attribute1 = hr_api.g_varchar2) then
488: p_rec.attribute1 :=
489: hxc_hav_shd.g_old_rec.attribute1;
490: End If;
491: If (p_rec.attribute2 = hr_api.g_varchar2) then
492: p_rec.attribute2 :=
493: hxc_hav_shd.g_old_rec.attribute2;

Line 493: hxc_hav_shd.g_old_rec.attribute2;

489: hxc_hav_shd.g_old_rec.attribute1;
490: End If;
491: If (p_rec.attribute2 = hr_api.g_varchar2) then
492: p_rec.attribute2 :=
493: hxc_hav_shd.g_old_rec.attribute2;
494: End If;
495: If (p_rec.attribute3 = hr_api.g_varchar2) then
496: p_rec.attribute3 :=
497: hxc_hav_shd.g_old_rec.attribute3;

Line 497: hxc_hav_shd.g_old_rec.attribute3;

493: hxc_hav_shd.g_old_rec.attribute2;
494: End If;
495: If (p_rec.attribute3 = hr_api.g_varchar2) then
496: p_rec.attribute3 :=
497: hxc_hav_shd.g_old_rec.attribute3;
498: End If;
499: If (p_rec.attribute4 = hr_api.g_varchar2) then
500: p_rec.attribute4 :=
501: hxc_hav_shd.g_old_rec.attribute4;

Line 501: hxc_hav_shd.g_old_rec.attribute4;

497: hxc_hav_shd.g_old_rec.attribute3;
498: End If;
499: If (p_rec.attribute4 = hr_api.g_varchar2) then
500: p_rec.attribute4 :=
501: hxc_hav_shd.g_old_rec.attribute4;
502: End If;
503: If (p_rec.attribute5 = hr_api.g_varchar2) then
504: p_rec.attribute5 :=
505: hxc_hav_shd.g_old_rec.attribute5;

Line 505: hxc_hav_shd.g_old_rec.attribute5;

501: hxc_hav_shd.g_old_rec.attribute4;
502: End If;
503: If (p_rec.attribute5 = hr_api.g_varchar2) then
504: p_rec.attribute5 :=
505: hxc_hav_shd.g_old_rec.attribute5;
506: End If;
507: If (p_rec.attribute6 = hr_api.g_varchar2) then
508: p_rec.attribute6 :=
509: hxc_hav_shd.g_old_rec.attribute6;

Line 509: hxc_hav_shd.g_old_rec.attribute6;

505: hxc_hav_shd.g_old_rec.attribute5;
506: End If;
507: If (p_rec.attribute6 = hr_api.g_varchar2) then
508: p_rec.attribute6 :=
509: hxc_hav_shd.g_old_rec.attribute6;
510: End If;
511: If (p_rec.attribute7 = hr_api.g_varchar2) then
512: p_rec.attribute7 :=
513: hxc_hav_shd.g_old_rec.attribute7;

Line 513: hxc_hav_shd.g_old_rec.attribute7;

509: hxc_hav_shd.g_old_rec.attribute6;
510: End If;
511: If (p_rec.attribute7 = hr_api.g_varchar2) then
512: p_rec.attribute7 :=
513: hxc_hav_shd.g_old_rec.attribute7;
514: End If;
515: If (p_rec.attribute8 = hr_api.g_varchar2) then
516: p_rec.attribute8 :=
517: hxc_hav_shd.g_old_rec.attribute8;

Line 517: hxc_hav_shd.g_old_rec.attribute8;

513: hxc_hav_shd.g_old_rec.attribute7;
514: End If;
515: If (p_rec.attribute8 = hr_api.g_varchar2) then
516: p_rec.attribute8 :=
517: hxc_hav_shd.g_old_rec.attribute8;
518: End If;
519: If (p_rec.attribute9 = hr_api.g_varchar2) then
520: p_rec.attribute9 :=
521: hxc_hav_shd.g_old_rec.attribute9;

Line 521: hxc_hav_shd.g_old_rec.attribute9;

517: hxc_hav_shd.g_old_rec.attribute8;
518: End If;
519: If (p_rec.attribute9 = hr_api.g_varchar2) then
520: p_rec.attribute9 :=
521: hxc_hav_shd.g_old_rec.attribute9;
522: End If;
523: If (p_rec.attribute10 = hr_api.g_varchar2) then
524: p_rec.attribute10 :=
525: hxc_hav_shd.g_old_rec.attribute10;

Line 525: hxc_hav_shd.g_old_rec.attribute10;

521: hxc_hav_shd.g_old_rec.attribute9;
522: End If;
523: If (p_rec.attribute10 = hr_api.g_varchar2) then
524: p_rec.attribute10 :=
525: hxc_hav_shd.g_old_rec.attribute10;
526: End If;
527: If (p_rec.attribute11 = hr_api.g_varchar2) then
528: p_rec.attribute11 :=
529: hxc_hav_shd.g_old_rec.attribute11;

Line 529: hxc_hav_shd.g_old_rec.attribute11;

525: hxc_hav_shd.g_old_rec.attribute10;
526: End If;
527: If (p_rec.attribute11 = hr_api.g_varchar2) then
528: p_rec.attribute11 :=
529: hxc_hav_shd.g_old_rec.attribute11;
530: End If;
531: If (p_rec.attribute12 = hr_api.g_varchar2) then
532: p_rec.attribute12 :=
533: hxc_hav_shd.g_old_rec.attribute12;

Line 533: hxc_hav_shd.g_old_rec.attribute12;

529: hxc_hav_shd.g_old_rec.attribute11;
530: End If;
531: If (p_rec.attribute12 = hr_api.g_varchar2) then
532: p_rec.attribute12 :=
533: hxc_hav_shd.g_old_rec.attribute12;
534: End If;
535: If (p_rec.attribute13 = hr_api.g_varchar2) then
536: p_rec.attribute13 :=
537: hxc_hav_shd.g_old_rec.attribute13;

Line 537: hxc_hav_shd.g_old_rec.attribute13;

533: hxc_hav_shd.g_old_rec.attribute12;
534: End If;
535: If (p_rec.attribute13 = hr_api.g_varchar2) then
536: p_rec.attribute13 :=
537: hxc_hav_shd.g_old_rec.attribute13;
538: End If;
539: If (p_rec.attribute14 = hr_api.g_varchar2) then
540: p_rec.attribute14 :=
541: hxc_hav_shd.g_old_rec.attribute14;

Line 541: hxc_hav_shd.g_old_rec.attribute14;

537: hxc_hav_shd.g_old_rec.attribute13;
538: End If;
539: If (p_rec.attribute14 = hr_api.g_varchar2) then
540: p_rec.attribute14 :=
541: hxc_hav_shd.g_old_rec.attribute14;
542: End If;
543: If (p_rec.attribute15 = hr_api.g_varchar2) then
544: p_rec.attribute15 :=
545: hxc_hav_shd.g_old_rec.attribute15;

Line 545: hxc_hav_shd.g_old_rec.attribute15;

541: hxc_hav_shd.g_old_rec.attribute14;
542: End If;
543: If (p_rec.attribute15 = hr_api.g_varchar2) then
544: p_rec.attribute15 :=
545: hxc_hav_shd.g_old_rec.attribute15;
546: End If;
547: If (p_rec.attribute16 = hr_api.g_varchar2) then
548: p_rec.attribute16 :=
549: hxc_hav_shd.g_old_rec.attribute16;

Line 549: hxc_hav_shd.g_old_rec.attribute16;

545: hxc_hav_shd.g_old_rec.attribute15;
546: End If;
547: If (p_rec.attribute16 = hr_api.g_varchar2) then
548: p_rec.attribute16 :=
549: hxc_hav_shd.g_old_rec.attribute16;
550: End If;
551: If (p_rec.attribute17 = hr_api.g_varchar2) then
552: p_rec.attribute17 :=
553: hxc_hav_shd.g_old_rec.attribute17;

Line 553: hxc_hav_shd.g_old_rec.attribute17;

549: hxc_hav_shd.g_old_rec.attribute16;
550: End If;
551: If (p_rec.attribute17 = hr_api.g_varchar2) then
552: p_rec.attribute17 :=
553: hxc_hav_shd.g_old_rec.attribute17;
554: End If;
555: If (p_rec.attribute18 = hr_api.g_varchar2) then
556: p_rec.attribute18 :=
557: hxc_hav_shd.g_old_rec.attribute18;

Line 557: hxc_hav_shd.g_old_rec.attribute18;

553: hxc_hav_shd.g_old_rec.attribute17;
554: End If;
555: If (p_rec.attribute18 = hr_api.g_varchar2) then
556: p_rec.attribute18 :=
557: hxc_hav_shd.g_old_rec.attribute18;
558: End If;
559: If (p_rec.attribute19 = hr_api.g_varchar2) then
560: p_rec.attribute19 :=
561: hxc_hav_shd.g_old_rec.attribute19;

Line 561: hxc_hav_shd.g_old_rec.attribute19;

557: hxc_hav_shd.g_old_rec.attribute18;
558: End If;
559: If (p_rec.attribute19 = hr_api.g_varchar2) then
560: p_rec.attribute19 :=
561: hxc_hav_shd.g_old_rec.attribute19;
562: End If;
563: If (p_rec.attribute20 = hr_api.g_varchar2) then
564: p_rec.attribute20 :=
565: hxc_hav_shd.g_old_rec.attribute20;

Line 565: hxc_hav_shd.g_old_rec.attribute20;

561: hxc_hav_shd.g_old_rec.attribute19;
562: End If;
563: If (p_rec.attribute20 = hr_api.g_varchar2) then
564: p_rec.attribute20 :=
565: hxc_hav_shd.g_old_rec.attribute20;
566: End If;
567: If (p_rec.attribute21 = hr_api.g_varchar2) then
568: p_rec.attribute21 :=
569: hxc_hav_shd.g_old_rec.attribute21;

Line 569: hxc_hav_shd.g_old_rec.attribute21;

565: hxc_hav_shd.g_old_rec.attribute20;
566: End If;
567: If (p_rec.attribute21 = hr_api.g_varchar2) then
568: p_rec.attribute21 :=
569: hxc_hav_shd.g_old_rec.attribute21;
570: End If;
571: If (p_rec.attribute22 = hr_api.g_varchar2) then
572: p_rec.attribute22 :=
573: hxc_hav_shd.g_old_rec.attribute22;

Line 573: hxc_hav_shd.g_old_rec.attribute22;

569: hxc_hav_shd.g_old_rec.attribute21;
570: End If;
571: If (p_rec.attribute22 = hr_api.g_varchar2) then
572: p_rec.attribute22 :=
573: hxc_hav_shd.g_old_rec.attribute22;
574: End If;
575: If (p_rec.attribute23 = hr_api.g_varchar2) then
576: p_rec.attribute23 :=
577: hxc_hav_shd.g_old_rec.attribute23;

Line 577: hxc_hav_shd.g_old_rec.attribute23;

573: hxc_hav_shd.g_old_rec.attribute22;
574: End If;
575: If (p_rec.attribute23 = hr_api.g_varchar2) then
576: p_rec.attribute23 :=
577: hxc_hav_shd.g_old_rec.attribute23;
578: End If;
579: If (p_rec.attribute24 = hr_api.g_varchar2) then
580: p_rec.attribute24 :=
581: hxc_hav_shd.g_old_rec.attribute24;

Line 581: hxc_hav_shd.g_old_rec.attribute24;

577: hxc_hav_shd.g_old_rec.attribute23;
578: End If;
579: If (p_rec.attribute24 = hr_api.g_varchar2) then
580: p_rec.attribute24 :=
581: hxc_hav_shd.g_old_rec.attribute24;
582: End If;
583: If (p_rec.attribute25 = hr_api.g_varchar2) then
584: p_rec.attribute25 :=
585: hxc_hav_shd.g_old_rec.attribute25;

Line 585: hxc_hav_shd.g_old_rec.attribute25;

581: hxc_hav_shd.g_old_rec.attribute24;
582: End If;
583: If (p_rec.attribute25 = hr_api.g_varchar2) then
584: p_rec.attribute25 :=
585: hxc_hav_shd.g_old_rec.attribute25;
586: End If;
587: If (p_rec.attribute26 = hr_api.g_varchar2) then
588: p_rec.attribute26 :=
589: hxc_hav_shd.g_old_rec.attribute26;

Line 589: hxc_hav_shd.g_old_rec.attribute26;

585: hxc_hav_shd.g_old_rec.attribute25;
586: End If;
587: If (p_rec.attribute26 = hr_api.g_varchar2) then
588: p_rec.attribute26 :=
589: hxc_hav_shd.g_old_rec.attribute26;
590: End If;
591: If (p_rec.attribute27 = hr_api.g_varchar2) then
592: p_rec.attribute27 :=
593: hxc_hav_shd.g_old_rec.attribute27;

Line 593: hxc_hav_shd.g_old_rec.attribute27;

589: hxc_hav_shd.g_old_rec.attribute26;
590: End If;
591: If (p_rec.attribute27 = hr_api.g_varchar2) then
592: p_rec.attribute27 :=
593: hxc_hav_shd.g_old_rec.attribute27;
594: End If;
595: If (p_rec.attribute28 = hr_api.g_varchar2) then
596: p_rec.attribute28 :=
597: hxc_hav_shd.g_old_rec.attribute28;

Line 597: hxc_hav_shd.g_old_rec.attribute28;

593: hxc_hav_shd.g_old_rec.attribute27;
594: End If;
595: If (p_rec.attribute28 = hr_api.g_varchar2) then
596: p_rec.attribute28 :=
597: hxc_hav_shd.g_old_rec.attribute28;
598: End If;
599: If (p_rec.attribute29 = hr_api.g_varchar2) then
600: p_rec.attribute29 :=
601: hxc_hav_shd.g_old_rec.attribute29;

Line 601: hxc_hav_shd.g_old_rec.attribute29;

597: hxc_hav_shd.g_old_rec.attribute28;
598: End If;
599: If (p_rec.attribute29 = hr_api.g_varchar2) then
600: p_rec.attribute29 :=
601: hxc_hav_shd.g_old_rec.attribute29;
602: End If;
603: If (p_rec.attribute30 = hr_api.g_varchar2) then
604: p_rec.attribute30 :=
605: hxc_hav_shd.g_old_rec.attribute30;

Line 605: hxc_hav_shd.g_old_rec.attribute30;

601: hxc_hav_shd.g_old_rec.attribute29;
602: End If;
603: If (p_rec.attribute30 = hr_api.g_varchar2) then
604: p_rec.attribute30 :=
605: hxc_hav_shd.g_old_rec.attribute30;
606: End If;
607: --
608: End convert_defs;
609: --

Line 614: (p_rec in out nocopy hxc_hav_shd.g_rec_type

610: -- ----------------------------------------------------------------------------
611: -- |---------------------------------< upd >----------------------------------|
612: -- ----------------------------------------------------------------------------
613: Procedure upd
614: (p_rec in out nocopy hxc_hav_shd.g_rec_type
615: ) is
616: --
617: l_proc varchar2(72);
618: --

Line 628: hxc_hav_shd.lck

624: end if;
625: --
626: -- We must lock the row which we need to update.
627: --
628: hxc_hav_shd.lck
629: (p_rec.alias_value_id
630: ,p_rec.object_version_number
631: );
632: --

Line 703: l_rec hxc_hav_shd.g_rec_type;

699: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ) is
702: --
703: l_rec hxc_hav_shd.g_rec_type;
704: l_proc varchar2(72);
705: --
706: Begin
707: g_debug:=hr_utility.debug_enabled;

Line 717: hxc_hav_shd.convert_args

713: -- Call conversion function to turn arguments into the
714: -- l_rec structure.
715: --
716: l_rec :=
717: hxc_hav_shd.convert_args
718: (p_alias_value_id
719: ,p_alias_value_name
720: ,p_date_from
721: ,p_date_to

Line 764: ,'hxc_hav_shd.upd'

760: -- business process.
761: --
762: /*
763: fnd_log.string(1
764: ,'hxc_hav_shd.upd'
765: ,'p_alias_value_name '||l_rec.alias_value_name);
766: */
767: hxc_hav_upd.upd
768: (l_rec