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_RFM_UPD dependencies on PAY_RFM_SHD

Line 58: (p_rec in out nocopy pay_rfm_shd.g_rec_type

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

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

Line 111: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status

107: where report_format_mapping_id = p_rec.report_format_mapping_id
108: and effective_start_date = p_validation_start_date
109: and effective_end_date = p_validation_end_date;
110: --
111: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: -- Set the effective start and end dates
114: --
115: p_rec.effective_start_date := p_validation_start_date;

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

119: hr_utility.set_location(' Leaving:'||l_proc, 15);
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
124: pay_rfm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated

Line 124: pay_rfm_shd.constraint_error

120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
124: pay_rfm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status

Line 128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status

124: pay_rfm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status

Line 129: pay_rfm_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;

Line 132: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status

128: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
129: pay_rfm_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End dt_update_dml;
135: --
136: -- ----------------------------------------------------------------------------

Line 168: (p_rec in out nocopy pay_rfm_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure update_dml
168: (p_rec in out nocopy pay_rfm_shd.g_rec_type
169: ,p_effective_date in date
170: ,p_datetrack_mode in varchar2
171: ,p_validation_start_date in date
172: ,p_validation_end_date in date

Line 235: (p_rec in out nocopy pay_rfm_shd.g_rec_type

231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure dt_pre_update
235: (p_rec in out nocopy pay_rfm_shd.g_rec_type
236: ,p_effective_date in date
237: ,p_datetrack_mode in varchar2
238: ,p_validation_start_date in date
239: ,p_validation_end_date in date

Line 251: pay_rfm_shd.upd_effective_end_date

247: If (p_datetrack_mode <> hr_api.g_correction) then
248: --
249: -- Update the current effective end date
250: --
251: pay_rfm_shd.upd_effective_end_date
252: (p_effective_date => p_effective_date
253: ,p_base_key_value => p_rec.report_format_mapping_id
254: ,p_new_effective_end_date => (p_validation_start_date - 1)
255: ,p_validation_start_date => p_validation_start_date

Line 320: (p_rec in out nocopy pay_rfm_shd.g_rec_type

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: Procedure pre_update
320: (p_rec in out nocopy pay_rfm_shd.g_rec_type
321: ,p_effective_date in date
322: ,p_datetrack_mode in varchar2
323: ,p_validation_start_date in date
324: ,p_validation_end_date in date

Line 378: (p_rec in pay_rfm_shd.g_rec_type

374: --
375: -- {End Of Comments}
376: -- ----------------------------------------------------------------------------
377: Procedure post_update
378: (p_rec in pay_rfm_shd.g_rec_type
379: ,p_effective_date in date
380: ,p_datetrack_mode in varchar2
381: ,p_validation_start_date in date
382: ,p_validation_end_date in date

Line 437: (p_rec in out nocopy pay_rfm_shd.g_rec_type

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

Line 449: pay_rfm_shd.g_old_rec.report_type;

445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.report_type = hr_api.g_varchar2) then
448: p_rec.report_type :=
449: pay_rfm_shd.g_old_rec.report_type;
450: End If;
451: If (p_rec.report_qualifier = hr_api.g_varchar2) then
452: p_rec.report_qualifier :=
453: pay_rfm_shd.g_old_rec.report_qualifier;

Line 453: pay_rfm_shd.g_old_rec.report_qualifier;

449: pay_rfm_shd.g_old_rec.report_type;
450: End If;
451: If (p_rec.report_qualifier = hr_api.g_varchar2) then
452: p_rec.report_qualifier :=
453: pay_rfm_shd.g_old_rec.report_qualifier;
454: End If;
455: If (p_rec.report_format = hr_api.g_varchar2) then
456: p_rec.report_format :=
457: pay_rfm_shd.g_old_rec.report_format;

Line 457: pay_rfm_shd.g_old_rec.report_format;

453: pay_rfm_shd.g_old_rec.report_qualifier;
454: End If;
455: If (p_rec.report_format = hr_api.g_varchar2) then
456: p_rec.report_format :=
457: pay_rfm_shd.g_old_rec.report_format;
458: End If;
459: If (p_rec.range_code = hr_api.g_varchar2) then
460: p_rec.range_code :=
461: pay_rfm_shd.g_old_rec.range_code;

Line 461: pay_rfm_shd.g_old_rec.range_code;

457: pay_rfm_shd.g_old_rec.report_format;
458: End If;
459: If (p_rec.range_code = hr_api.g_varchar2) then
460: p_rec.range_code :=
461: pay_rfm_shd.g_old_rec.range_code;
462: End If;
463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then
464: p_rec.assignment_action_code :=
465: pay_rfm_shd.g_old_rec.assignment_action_code;

Line 465: pay_rfm_shd.g_old_rec.assignment_action_code;

461: pay_rfm_shd.g_old_rec.range_code;
462: End If;
463: If (p_rec.assignment_action_code = hr_api.g_varchar2) then
464: p_rec.assignment_action_code :=
465: pay_rfm_shd.g_old_rec.assignment_action_code;
466: End If;
467: If (p_rec.initialization_code = hr_api.g_varchar2) then
468: p_rec.initialization_code :=
469: pay_rfm_shd.g_old_rec.initialization_code;

Line 469: pay_rfm_shd.g_old_rec.initialization_code;

465: pay_rfm_shd.g_old_rec.assignment_action_code;
466: End If;
467: If (p_rec.initialization_code = hr_api.g_varchar2) then
468: p_rec.initialization_code :=
469: pay_rfm_shd.g_old_rec.initialization_code;
470: End If;
471: If (p_rec.archive_code = hr_api.g_varchar2) then
472: p_rec.archive_code :=
473: pay_rfm_shd.g_old_rec.archive_code;

Line 473: pay_rfm_shd.g_old_rec.archive_code;

469: pay_rfm_shd.g_old_rec.initialization_code;
470: End If;
471: If (p_rec.archive_code = hr_api.g_varchar2) then
472: p_rec.archive_code :=
473: pay_rfm_shd.g_old_rec.archive_code;
474: End If;
475: If (p_rec.magnetic_code = hr_api.g_varchar2) then
476: p_rec.magnetic_code :=
477: pay_rfm_shd.g_old_rec.magnetic_code;

Line 477: pay_rfm_shd.g_old_rec.magnetic_code;

473: pay_rfm_shd.g_old_rec.archive_code;
474: End If;
475: If (p_rec.magnetic_code = hr_api.g_varchar2) then
476: p_rec.magnetic_code :=
477: pay_rfm_shd.g_old_rec.magnetic_code;
478: End If;
479: If (p_rec.report_category = hr_api.g_varchar2) then
480: p_rec.report_category :=
481: pay_rfm_shd.g_old_rec.report_category;

Line 481: pay_rfm_shd.g_old_rec.report_category;

477: pay_rfm_shd.g_old_rec.magnetic_code;
478: End If;
479: If (p_rec.report_category = hr_api.g_varchar2) then
480: p_rec.report_category :=
481: pay_rfm_shd.g_old_rec.report_category;
482: End If;
483: If (p_rec.report_name = hr_api.g_varchar2) then
484: p_rec.report_name :=
485: pay_rfm_shd.g_old_rec.report_name;

Line 485: pay_rfm_shd.g_old_rec.report_name;

481: pay_rfm_shd.g_old_rec.report_category;
482: End If;
483: If (p_rec.report_name = hr_api.g_varchar2) then
484: p_rec.report_name :=
485: pay_rfm_shd.g_old_rec.report_name;
486: End If;
487: If (p_rec.sort_code = hr_api.g_varchar2) then
488: p_rec.sort_code :=
489: pay_rfm_shd.g_old_rec.sort_code;

Line 489: pay_rfm_shd.g_old_rec.sort_code;

485: pay_rfm_shd.g_old_rec.report_name;
486: End If;
487: If (p_rec.sort_code = hr_api.g_varchar2) then
488: p_rec.sort_code :=
489: pay_rfm_shd.g_old_rec.sort_code;
490: End If;
491: If (p_rec.updatable_flag = hr_api.g_varchar2) then
492: p_rec.updatable_flag :=
493: pay_rfm_shd.g_old_rec.updatable_flag;

Line 493: pay_rfm_shd.g_old_rec.updatable_flag;

489: pay_rfm_shd.g_old_rec.sort_code;
490: End If;
491: If (p_rec.updatable_flag = hr_api.g_varchar2) then
492: p_rec.updatable_flag :=
493: pay_rfm_shd.g_old_rec.updatable_flag;
494: End If;
495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then
496: p_rec.deinitialization_code :=
497: pay_rfm_shd.g_old_rec.deinitialization_code;

Line 497: pay_rfm_shd.g_old_rec.deinitialization_code;

493: pay_rfm_shd.g_old_rec.updatable_flag;
494: End If;
495: If (p_rec.deinitialization_code = hr_api.g_varchar2) then
496: p_rec.deinitialization_code :=
497: pay_rfm_shd.g_old_rec.deinitialization_code;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: pay_rfm_shd.g_old_rec.business_group_id;

Line 501: pay_rfm_shd.g_old_rec.business_group_id;

497: pay_rfm_shd.g_old_rec.deinitialization_code;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: pay_rfm_shd.g_old_rec.business_group_id;
502: End If;
503: If (p_rec.legislation_code = hr_api.g_varchar2) then
504: p_rec.legislation_code :=
505: pay_rfm_shd.g_old_rec.legislation_code;

Line 505: pay_rfm_shd.g_old_rec.legislation_code;

501: pay_rfm_shd.g_old_rec.business_group_id;
502: End If;
503: If (p_rec.legislation_code = hr_api.g_varchar2) then
504: p_rec.legislation_code :=
505: pay_rfm_shd.g_old_rec.legislation_code;
506: End If;
507: If (p_rec.temporary_action_flag = hr_api.g_varchar2) then
508: p_rec.temporary_action_flag :=
509: pay_rfm_shd.g_old_rec.temporary_action_flag;

Line 509: pay_rfm_shd.g_old_rec.temporary_action_flag;

505: pay_rfm_shd.g_old_rec.legislation_code;
506: End If;
507: If (p_rec.temporary_action_flag = hr_api.g_varchar2) then
508: p_rec.temporary_action_flag :=
509: pay_rfm_shd.g_old_rec.temporary_action_flag;
510: End If;
511: --
512: End convert_defs;
513: --

Line 520: ,p_rec in out nocopy pay_rfm_shd.g_rec_type

516: -- ----------------------------------------------------------------------------
517: Procedure upd
518: (p_effective_date in date
519: ,p_datetrack_mode in varchar2
520: ,p_rec in out nocopy pay_rfm_shd.g_rec_type
521: ) is
522: --
523: l_proc varchar2(72) := g_package||'upd';
524: l_validation_start_date date;

Line 536: pay_rfm_shd.lck

532: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
533: --
534: -- We must lock the row which we need to update.
535: --
536: pay_rfm_shd.lck
537: (p_effective_date => p_effective_date
538: ,p_datetrack_mode => p_datetrack_mode
539: ,p_report_format_mapping_id => p_rec.report_format_mapping_id
540: ,p_object_version_number => p_rec.object_version_number

Line 626: l_rec pay_rfm_shd.g_rec_type;

622: ,p_effective_start_date out nocopy date
623: ,p_effective_end_date out nocopy date
624: ) is
625: --
626: l_rec pay_rfm_shd.g_rec_type;
627: l_proc varchar2(72) := g_package||'upd';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);

Line 636: pay_rfm_shd.convert_args

632: -- Call conversion function to turn arguments into the
633: -- l_rec structure.
634: --
635: l_rec :=
636: pay_rfm_shd.convert_args
637: (p_report_type
638: ,p_report_qualifier
639: ,p_report_format
640: ,null