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.PAY_LIV_UPD dependencies on PAY_LIV_SHD

Line 58: (p_rec in out nocopy pay_liv_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_liv_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 83: pay_liv_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'link_input_value_id'
80: ,p_base_key_value => p_rec.link_input_value_id
81: );
82: --
83: pay_liv_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_link_input_values_f Row
86: --
87: update pay_link_input_values_f

Line 102: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

98: where link_input_value_id = p_rec.link_input_value_id
99: and effective_start_date = p_validation_start_date
100: and effective_end_date = p_validation_end_date;
101: --
102: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
103: --
104: -- Set the effective start and end dates
105: --
106: p_rec.effective_start_date := p_validation_start_date;

Line 114: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
115: pay_liv_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated

Line 115: pay_liv_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
115: pay_liv_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

Line 119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

115: pay_liv_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
120: pay_liv_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

Line 120: pay_liv_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
120: pay_liv_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;

Line 123: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
120: pay_liv_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;
125: End dt_update_dml;
126: --
127: -- ----------------------------------------------------------------------------

Line 159: (p_rec in out nocopy pay_liv_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure update_dml
159: (p_rec in out nocopy pay_liv_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 226: (p_rec in out nocopy pay_liv_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure dt_pre_update
226: (p_rec in out nocopy pay_liv_shd.g_rec_type
227: ,p_effective_date in date
228: ,p_datetrack_mode in varchar2
229: ,p_validation_start_date in date
230: ,p_validation_end_date in date

Line 242: pay_liv_shd.upd_effective_end_date

238: If (p_datetrack_mode <> hr_api.g_correction) then
239: --
240: -- Update the current effective end date
241: --
242: pay_liv_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.link_input_value_id
245: ,p_new_effective_end_date => (p_validation_start_date - 1)
246: ,p_validation_start_date => p_validation_start_date

Line 311: (p_rec in out nocopy pay_liv_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_update
311: (p_rec in out nocopy pay_liv_shd.g_rec_type
312: ,p_effective_date in date
313: ,p_datetrack_mode in varchar2
314: ,p_validation_start_date in date
315: ,p_validation_end_date in date

Line 369: (p_rec in pay_liv_shd.g_rec_type

365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure post_update
369: (p_rec in pay_liv_shd.g_rec_type
370: ,p_effective_date in date
371: ,p_datetrack_mode in varchar2
372: ,p_validation_start_date in date
373: ,p_validation_end_date in date

Line 414: => pay_liv_shd.g_old_rec.effective_start_date

410: => p_rec.warning_or_error
411: ,p_object_version_number
412: => p_rec.object_version_number
413: ,p_effective_start_date_o
414: => pay_liv_shd.g_old_rec.effective_start_date
415: ,p_effective_end_date_o
416: => pay_liv_shd.g_old_rec.effective_end_date
417: ,p_element_link_id_o
418: => pay_liv_shd.g_old_rec.element_link_id

Line 416: => pay_liv_shd.g_old_rec.effective_end_date

412: => p_rec.object_version_number
413: ,p_effective_start_date_o
414: => pay_liv_shd.g_old_rec.effective_start_date
415: ,p_effective_end_date_o
416: => pay_liv_shd.g_old_rec.effective_end_date
417: ,p_element_link_id_o
418: => pay_liv_shd.g_old_rec.element_link_id
419: ,p_input_value_id_o
420: => pay_liv_shd.g_old_rec.input_value_id

Line 418: => pay_liv_shd.g_old_rec.element_link_id

414: => pay_liv_shd.g_old_rec.effective_start_date
415: ,p_effective_end_date_o
416: => pay_liv_shd.g_old_rec.effective_end_date
417: ,p_element_link_id_o
418: => pay_liv_shd.g_old_rec.element_link_id
419: ,p_input_value_id_o
420: => pay_liv_shd.g_old_rec.input_value_id
421: ,p_costed_flag_o
422: => pay_liv_shd.g_old_rec.costed_flag

Line 420: => pay_liv_shd.g_old_rec.input_value_id

416: => pay_liv_shd.g_old_rec.effective_end_date
417: ,p_element_link_id_o
418: => pay_liv_shd.g_old_rec.element_link_id
419: ,p_input_value_id_o
420: => pay_liv_shd.g_old_rec.input_value_id
421: ,p_costed_flag_o
422: => pay_liv_shd.g_old_rec.costed_flag
423: ,p_default_value_o
424: => pay_liv_shd.g_old_rec.default_value

Line 422: => pay_liv_shd.g_old_rec.costed_flag

418: => pay_liv_shd.g_old_rec.element_link_id
419: ,p_input_value_id_o
420: => pay_liv_shd.g_old_rec.input_value_id
421: ,p_costed_flag_o
422: => pay_liv_shd.g_old_rec.costed_flag
423: ,p_default_value_o
424: => pay_liv_shd.g_old_rec.default_value
425: ,p_max_value_o
426: => pay_liv_shd.g_old_rec.max_value

Line 424: => pay_liv_shd.g_old_rec.default_value

420: => pay_liv_shd.g_old_rec.input_value_id
421: ,p_costed_flag_o
422: => pay_liv_shd.g_old_rec.costed_flag
423: ,p_default_value_o
424: => pay_liv_shd.g_old_rec.default_value
425: ,p_max_value_o
426: => pay_liv_shd.g_old_rec.max_value
427: ,p_min_value_o
428: => pay_liv_shd.g_old_rec.min_value

Line 426: => pay_liv_shd.g_old_rec.max_value

422: => pay_liv_shd.g_old_rec.costed_flag
423: ,p_default_value_o
424: => pay_liv_shd.g_old_rec.default_value
425: ,p_max_value_o
426: => pay_liv_shd.g_old_rec.max_value
427: ,p_min_value_o
428: => pay_liv_shd.g_old_rec.min_value
429: ,p_warning_or_error_o
430: => pay_liv_shd.g_old_rec.warning_or_error

Line 428: => pay_liv_shd.g_old_rec.min_value

424: => pay_liv_shd.g_old_rec.default_value
425: ,p_max_value_o
426: => pay_liv_shd.g_old_rec.max_value
427: ,p_min_value_o
428: => pay_liv_shd.g_old_rec.min_value
429: ,p_warning_or_error_o
430: => pay_liv_shd.g_old_rec.warning_or_error
431: ,p_object_version_number_o
432: => pay_liv_shd.g_old_rec.object_version_number

Line 430: => pay_liv_shd.g_old_rec.warning_or_error

426: => pay_liv_shd.g_old_rec.max_value
427: ,p_min_value_o
428: => pay_liv_shd.g_old_rec.min_value
429: ,p_warning_or_error_o
430: => pay_liv_shd.g_old_rec.warning_or_error
431: ,p_object_version_number_o
432: => pay_liv_shd.g_old_rec.object_version_number
433: );
434: --

Line 432: => pay_liv_shd.g_old_rec.object_version_number

428: => pay_liv_shd.g_old_rec.min_value
429: ,p_warning_or_error_o
430: => pay_liv_shd.g_old_rec.warning_or_error
431: ,p_object_version_number_o
432: => pay_liv_shd.g_old_rec.object_version_number
433: );
434: --
435: exception
436: --

Line 492: (p_rec in out nocopy pay_liv_shd.g_rec_type

488: --
489: -- {End Of Comments}
490: -- ----------------------------------------------------------------------------
491: Procedure convert_defs
492: (p_rec in out nocopy pay_liv_shd.g_rec_type
493: ) is
494: --
495: Begin
496: --

Line 504: pay_liv_shd.g_old_rec.element_link_id;

500: -- is being used then we must set to the 'current' argument value.
501: --
502: If (p_rec.element_link_id = hr_api.g_number) then
503: p_rec.element_link_id :=
504: pay_liv_shd.g_old_rec.element_link_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then
507: p_rec.input_value_id :=
508: pay_liv_shd.g_old_rec.input_value_id;

Line 508: pay_liv_shd.g_old_rec.input_value_id;

504: pay_liv_shd.g_old_rec.element_link_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then
507: p_rec.input_value_id :=
508: pay_liv_shd.g_old_rec.input_value_id;
509: End If;
510: If (p_rec.costed_flag = hr_api.g_varchar2) then
511: p_rec.costed_flag :=
512: pay_liv_shd.g_old_rec.costed_flag;

Line 512: pay_liv_shd.g_old_rec.costed_flag;

508: pay_liv_shd.g_old_rec.input_value_id;
509: End If;
510: If (p_rec.costed_flag = hr_api.g_varchar2) then
511: p_rec.costed_flag :=
512: pay_liv_shd.g_old_rec.costed_flag;
513: End If;
514: If (p_rec.default_value = hr_api.g_varchar2) then
515: p_rec.default_value :=
516: pay_liv_shd.g_old_rec.default_value;

Line 516: pay_liv_shd.g_old_rec.default_value;

512: pay_liv_shd.g_old_rec.costed_flag;
513: End If;
514: If (p_rec.default_value = hr_api.g_varchar2) then
515: p_rec.default_value :=
516: pay_liv_shd.g_old_rec.default_value;
517: End If;
518: If (p_rec.max_value = hr_api.g_varchar2) then
519: p_rec.max_value :=
520: pay_liv_shd.g_old_rec.max_value;

Line 520: pay_liv_shd.g_old_rec.max_value;

516: pay_liv_shd.g_old_rec.default_value;
517: End If;
518: If (p_rec.max_value = hr_api.g_varchar2) then
519: p_rec.max_value :=
520: pay_liv_shd.g_old_rec.max_value;
521: End If;
522: If (p_rec.min_value = hr_api.g_varchar2) then
523: p_rec.min_value :=
524: pay_liv_shd.g_old_rec.min_value;

Line 524: pay_liv_shd.g_old_rec.min_value;

520: pay_liv_shd.g_old_rec.max_value;
521: End If;
522: If (p_rec.min_value = hr_api.g_varchar2) then
523: p_rec.min_value :=
524: pay_liv_shd.g_old_rec.min_value;
525: End If;
526: If (p_rec.warning_or_error = hr_api.g_varchar2) then
527: p_rec.warning_or_error :=
528: pay_liv_shd.g_old_rec.warning_or_error;

Line 528: pay_liv_shd.g_old_rec.warning_or_error;

524: pay_liv_shd.g_old_rec.min_value;
525: End If;
526: If (p_rec.warning_or_error = hr_api.g_varchar2) then
527: p_rec.warning_or_error :=
528: pay_liv_shd.g_old_rec.warning_or_error;
529: End If;
530: --
531: End convert_defs;
532: --

Line 539: ,p_rec in out nocopy pay_liv_shd.g_rec_type

535: -- ----------------------------------------------------------------------------
536: Procedure upd
537: (p_effective_date in date
538: ,p_datetrack_mode in varchar2
539: ,p_rec in out nocopy pay_liv_shd.g_rec_type
540: ,p_default_range_warning out nocopy boolean
541: ,p_default_formula_warning out nocopy boolean
542: ,p_assignment_id_warning out nocopy boolean
543: ,p_formula_message out nocopy varchar2

Line 559: pay_liv_shd.lck

555: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
556: --
557: -- We must lock the row which we need to update.
558: --
559: pay_liv_shd.lck
560: (p_effective_date => p_effective_date
561: ,p_datetrack_mode => p_datetrack_mode
562: ,p_link_input_value_id => p_rec.link_input_value_id
563: ,p_object_version_number => p_rec.object_version_number

Line 648: l_rec pay_liv_shd.g_rec_type;

644: ,p_assignment_id_warning out nocopy boolean
645: ,p_formula_message out nocopy varchar2
646: ) is
647: --
648: l_rec pay_liv_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'upd';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);

Line 658: pay_liv_shd.convert_args

654: -- Call conversion function to turn arguments into the
655: -- l_rec structure.
656: --
657: l_rec :=
658: pay_liv_shd.convert_args
659: (p_link_input_value_id
660: ,null
661: ,null
662: ,p_element_link_id