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_GRR_UPD dependencies on PAY_GRR_SHD

Line 58: (p_rec in out nocopy pay_grr_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_grr_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) is

Line 81: pay_grr_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'pay_grade_rules_f',
78: p_base_key_column => 'grade_rule_id',
79: p_base_key_value => p_rec.grade_rule_id);
80: --
81: pay_grr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: hr_utility.set_location(l_proc, 12);
84: --
85: -- Update the pay_grade_rules_f Row

Line 106: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

102: and effective_end_date = p_validation_end_date;
103: --
104: hr_utility.set_location(l_proc, 14);
105: --
106: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: -- Set the effective start and end dates
109: --
110: p_rec.effective_start_date := p_validation_start_date;

Line 118: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 119: pay_grr_shd.constraint_error

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

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

119: pay_grr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
124: pay_grr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

Line 124: pay_grr_shd.constraint_error

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

Line 127: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

123: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
124: pay_grr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End dt_update_dml;
130: --
131: -- ----------------------------------------------------------------------------

Line 163: (p_rec in out nocopy pay_grr_shd.g_rec_type,

159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure update_dml
163: (p_rec in out nocopy pay_grr_shd.g_rec_type,
164: p_effective_date in date,
165: p_datetrack_mode in varchar2,
166: p_validation_start_date in date,
167: p_validation_end_date in date) is

Line 227: (p_rec in out nocopy pay_grr_shd.g_rec_type,

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

Line 243: pay_grr_shd.upd_effective_end_date

239: hr_utility.set_location(l_proc, 10);
240: --
241: -- Update the current effective end date
242: --
243: pay_grr_shd.upd_effective_end_date
244: (p_effective_date => p_effective_date,
245: p_base_key_value => p_rec.grade_rule_id,
246: p_new_effective_end_date => (p_validation_start_date - 1),
247: p_validation_start_date => p_validation_start_date,

Line 312: (p_rec in out nocopy pay_grr_shd.g_rec_type,

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

Line 366: (p_rec in pay_grr_shd.g_rec_type,

362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure post_update
366: (p_rec in pay_grr_shd.g_rec_type,
367: p_effective_date in date,
368: p_datetrack_mode in varchar2,
369: p_validation_start_date in date,
370: p_validation_end_date in date) is

Line 423: Procedure convert_defs(p_rec in out nocopy pay_grr_shd.g_rec_type) is

419: -- Internal Table Handler USe Only.
420: --
421: -- {End Of Comments}
422: -- ----------------------------------------------------------------------------
423: Procedure convert_defs(p_rec in out nocopy pay_grr_shd.g_rec_type) is
424: --
425: l_proc varchar2(72) := g_package||'convert_defs';
426: --
427: Begin

Line 438: pay_grr_shd.g_old_rec.business_group_id;

434: -- is being used then we must set to the 'current' argument value.
435: --
436: If (p_rec.business_group_id = hr_api.g_number) then
437: p_rec.business_group_id :=
438: pay_grr_shd.g_old_rec.business_group_id;
439: End If;
440: If (p_rec.rate_id = hr_api.g_number) then
441: p_rec.rate_id :=
442: pay_grr_shd.g_old_rec.rate_id;

Line 442: pay_grr_shd.g_old_rec.rate_id;

438: pay_grr_shd.g_old_rec.business_group_id;
439: End If;
440: If (p_rec.rate_id = hr_api.g_number) then
441: p_rec.rate_id :=
442: pay_grr_shd.g_old_rec.rate_id;
443: End If;
444: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
445: p_rec.grade_or_spinal_point_id :=
446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;

Line 446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;

442: pay_grr_shd.g_old_rec.rate_id;
443: End If;
444: If (p_rec.grade_or_spinal_point_id = hr_api.g_number) then
445: p_rec.grade_or_spinal_point_id :=
446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;
447: End If;
448: If (p_rec.rate_type = hr_api.g_varchar2) then
449: p_rec.rate_type :=
450: pay_grr_shd.g_old_rec.rate_type;

Line 450: pay_grr_shd.g_old_rec.rate_type;

446: pay_grr_shd.g_old_rec.grade_or_spinal_point_id;
447: End If;
448: If (p_rec.rate_type = hr_api.g_varchar2) then
449: p_rec.rate_type :=
450: pay_grr_shd.g_old_rec.rate_type;
451: End If;
452: If (p_rec.maximum = hr_api.g_varchar2) then
453: p_rec.maximum :=
454: pay_grr_shd.g_old_rec.maximum;

Line 454: pay_grr_shd.g_old_rec.maximum;

450: pay_grr_shd.g_old_rec.rate_type;
451: End If;
452: If (p_rec.maximum = hr_api.g_varchar2) then
453: p_rec.maximum :=
454: pay_grr_shd.g_old_rec.maximum;
455: End If;
456: If (p_rec.mid_value = hr_api.g_varchar2) then
457: p_rec.mid_value :=
458: pay_grr_shd.g_old_rec.mid_value;

Line 458: pay_grr_shd.g_old_rec.mid_value;

454: pay_grr_shd.g_old_rec.maximum;
455: End If;
456: If (p_rec.mid_value = hr_api.g_varchar2) then
457: p_rec.mid_value :=
458: pay_grr_shd.g_old_rec.mid_value;
459: End If;
460: If (p_rec.minimum = hr_api.g_varchar2) then
461: p_rec.minimum :=
462: pay_grr_shd.g_old_rec.minimum;

Line 462: pay_grr_shd.g_old_rec.minimum;

458: pay_grr_shd.g_old_rec.mid_value;
459: End If;
460: If (p_rec.minimum = hr_api.g_varchar2) then
461: p_rec.minimum :=
462: pay_grr_shd.g_old_rec.minimum;
463: End If;
464: If (p_rec.sequence = hr_api.g_number) then
465: p_rec.sequence :=
466: pay_grr_shd.g_old_rec.sequence;

Line 466: pay_grr_shd.g_old_rec.sequence;

462: pay_grr_shd.g_old_rec.minimum;
463: End If;
464: If (p_rec.sequence = hr_api.g_number) then
465: p_rec.sequence :=
466: pay_grr_shd.g_old_rec.sequence;
467: End If;
468: If (p_rec.value = hr_api.g_varchar2) then
469: p_rec.value :=
470: pay_grr_shd.g_old_rec.value;

Line 470: pay_grr_shd.g_old_rec.value;

466: pay_grr_shd.g_old_rec.sequence;
467: End If;
468: If (p_rec.value = hr_api.g_varchar2) then
469: p_rec.value :=
470: pay_grr_shd.g_old_rec.value;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pay_grr_shd.g_old_rec.request_id;

Line 474: pay_grr_shd.g_old_rec.request_id;

470: pay_grr_shd.g_old_rec.value;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pay_grr_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pay_grr_shd.g_old_rec.program_application_id;

Line 478: pay_grr_shd.g_old_rec.program_application_id;

474: pay_grr_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pay_grr_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pay_grr_shd.g_old_rec.program_id;

Line 482: pay_grr_shd.g_old_rec.program_id;

478: pay_grr_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pay_grr_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pay_grr_shd.g_old_rec.program_update_date;

Line 486: pay_grr_shd.g_old_rec.program_update_date;

482: pay_grr_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pay_grr_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.currency_code = hr_api.g_varchar2) then
489: p_rec.currency_code :=
490: pay_grr_shd.g_old_rec.currency_code;

Line 490: pay_grr_shd.g_old_rec.currency_code;

486: pay_grr_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.currency_code = hr_api.g_varchar2) then
489: p_rec.currency_code :=
490: pay_grr_shd.g_old_rec.currency_code;
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: --

Line 502: p_rec in out nocopy pay_grr_shd.g_rec_type,

498: -- |---------------------------------< upd >----------------------------------|
499: -- ----------------------------------------------------------------------------
500: Procedure upd
501: (
502: p_rec in out nocopy pay_grr_shd.g_rec_type,
503: p_effective_date in date,
504: p_datetrack_mode in varchar2,
505: p_validate in boolean default false
506: ) is

Line 530: pay_grr_shd.lck

526: End If;
527: --
528: -- We must lock the row which we need to update.
529: --
530: pay_grr_shd.lck
531: (p_effective_date => p_effective_date,
532: p_datetrack_mode => p_datetrack_mode,
533: p_grade_rule_id => p_rec.grade_rule_id,
534: p_object_version_number => p_rec.object_version_number,

Line 619: l_rec pay_grr_shd.g_rec_type;

615: p_validate in boolean default false,
616: p_currency_code in varchar2 default hr_api.g_varchar2
617: ) is
618: --
619: l_rec pay_grr_shd.g_rec_type;
620: l_proc varchar2(72) := g_package||'upd';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);

Line 629: pay_grr_shd.convert_args

625: -- Call conversion function to turn arguments into the
626: -- l_rec structure.
627: --
628: l_rec :=
629: pay_grr_shd.convert_args
630: (
631: p_grade_rule_id,
632: null,
633: null,