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_RFI_UPD dependencies on PAY_RFI_SHD

Line 58: (p_rec in out nocopy pay_rfi_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_rfi_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_rfi_shd.g_api_dml := true; -- Set the api dml status

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

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

98: where report_format_item_id = p_rec.report_format_item_id
99: and effective_start_date = p_validation_start_date
100: and effective_end_date = p_validation_end_date;
101: --
102: pay_rfi_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_rfi_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_rfi_shd.g_api_dml := false; -- Unset the api dml status
115: pay_rfi_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_rfi_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
115: pay_rfi_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_rfi_shd.g_api_dml := false; -- Unset the api dml status

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

115: pay_rfi_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_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status

Line 120: pay_rfi_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_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;

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

119: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
120: pay_rfi_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: pay_rfi_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_rfi_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure update_dml
159: (p_rec in out nocopy pay_rfi_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_rfi_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure dt_pre_update
226: (p_rec in out nocopy pay_rfi_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_rfi_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_rfi_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.report_format_item_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_rfi_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_update
311: (p_rec in out nocopy pay_rfi_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_rfi_shd.g_rec_type

365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure post_update
369: (p_rec in pay_rfi_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 428: (p_rec in out nocopy pay_rfi_shd.g_rec_type

424: --
425: -- {End Of Comments}
426: -- ----------------------------------------------------------------------------
427: Procedure convert_defs
428: (p_rec in out nocopy pay_rfi_shd.g_rec_type
429: ) is
430: --
431: Begin
432: --

Line 440: pay_rfi_shd.g_old_rec.report_type;

436: -- is being used then we must set to the 'current' argument value.
437: --
438: If (p_rec.report_type = hr_api.g_varchar2) then
439: p_rec.report_type :=
440: pay_rfi_shd.g_old_rec.report_type;
441: End If;
442: If (p_rec.report_qualifier = hr_api.g_varchar2) then
443: p_rec.report_qualifier :=
444: pay_rfi_shd.g_old_rec.report_qualifier;

Line 444: pay_rfi_shd.g_old_rec.report_qualifier;

440: pay_rfi_shd.g_old_rec.report_type;
441: End If;
442: If (p_rec.report_qualifier = hr_api.g_varchar2) then
443: p_rec.report_qualifier :=
444: pay_rfi_shd.g_old_rec.report_qualifier;
445: End If;
446: If (p_rec.report_category = hr_api.g_varchar2) then
447: p_rec.report_category :=
448: pay_rfi_shd.g_old_rec.report_category;

Line 448: pay_rfi_shd.g_old_rec.report_category;

444: pay_rfi_shd.g_old_rec.report_qualifier;
445: End If;
446: If (p_rec.report_category = hr_api.g_varchar2) then
447: p_rec.report_category :=
448: pay_rfi_shd.g_old_rec.report_category;
449: End If;
450: If (p_rec.user_entity_id = hr_api.g_number) then
451: p_rec.user_entity_id :=
452: pay_rfi_shd.g_old_rec.user_entity_id;

Line 452: pay_rfi_shd.g_old_rec.user_entity_id;

448: pay_rfi_shd.g_old_rec.report_category;
449: End If;
450: If (p_rec.user_entity_id = hr_api.g_number) then
451: p_rec.user_entity_id :=
452: pay_rfi_shd.g_old_rec.user_entity_id;
453: End If;
454: If (p_rec.archive_type = hr_api.g_varchar2) then
455: p_rec.archive_type :=
456: pay_rfi_shd.g_old_rec.archive_type;

Line 456: pay_rfi_shd.g_old_rec.archive_type;

452: pay_rfi_shd.g_old_rec.user_entity_id;
453: End If;
454: If (p_rec.archive_type = hr_api.g_varchar2) then
455: p_rec.archive_type :=
456: pay_rfi_shd.g_old_rec.archive_type;
457: End If;
458: If (p_rec.updatable_flag = hr_api.g_varchar2) then
459: p_rec.updatable_flag :=
460: pay_rfi_shd.g_old_rec.updatable_flag;

Line 460: pay_rfi_shd.g_old_rec.updatable_flag;

456: pay_rfi_shd.g_old_rec.archive_type;
457: End If;
458: If (p_rec.updatable_flag = hr_api.g_varchar2) then
459: p_rec.updatable_flag :=
460: pay_rfi_shd.g_old_rec.updatable_flag;
461: End If;
462: If (p_rec.display_sequence = hr_api.g_number) then
463: p_rec.display_sequence :=
464: pay_rfi_shd.g_old_rec.display_sequence;

Line 464: pay_rfi_shd.g_old_rec.display_sequence;

460: pay_rfi_shd.g_old_rec.updatable_flag;
461: End If;
462: If (p_rec.display_sequence = hr_api.g_number) then
463: p_rec.display_sequence :=
464: pay_rfi_shd.g_old_rec.display_sequence;
465: End If;
466: --
467: End convert_defs;
468: --

Line 475: ,p_rec in out nocopy pay_rfi_shd.g_rec_type

471: -- ----------------------------------------------------------------------------
472: Procedure upd
473: (p_effective_date in date
474: ,p_datetrack_mode in varchar2
475: ,p_rec in out nocopy pay_rfi_shd.g_rec_type
476: ) is
477: --
478: l_proc varchar2(72) := g_package||'upd';
479: l_validation_start_date date;

Line 491: pay_rfi_shd.lck

487: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
488: --
489: -- We must lock the row which we need to update.
490: --
491: pay_rfi_shd.lck
492: (p_effective_date => p_effective_date
493: ,p_datetrack_mode => p_datetrack_mode
494: ,p_report_format_item_id => p_rec.report_format_item_id
495: ,p_object_version_number => p_rec.object_version_number

Line 572: l_rec pay_rfi_shd.g_rec_type;

568: ,p_effective_start_date out nocopy date
569: ,p_effective_end_date out nocopy date
570: ) is
571: --
572: l_rec pay_rfi_shd.g_rec_type;
573: l_proc varchar2(72) := g_package||'upd';
574: l_report_format_mapping_id pay_report_format_mappings_f.report_format_mapping_id%type;
575: --
576: Begin

Line 589: pay_rfi_shd.convert_args

585: ,p_report_qualifier => p_report_qualifier
586: ,p_report_category => p_report_category );
587:
588: l_rec :=
589: pay_rfi_shd.convert_args
590: (p_report_type
591: ,p_report_qualifier
592: ,p_report_category
593: ,p_user_entity_id