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

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

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_grr_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

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

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: pay_grr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

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

71: delete from pay_grade_rules_f
72: where grade_rule_id = p_rec.grade_rule_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_grr_shd.g_api_dml := true; -- Set the api dml status
79: --

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

74: --
75: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_grr_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

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

83: delete from pay_grade_rules_f
84: where grade_rule_id = p_rec.grade_rule_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: -- 40.1 change a start.
91: --

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

96: hr_utility.set_location(' Leaving:'||l_proc, 20);
97: --
98: Exception
99: When Others Then
100: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End dt_delete_dml;
103: --
104: -- ----------------------------------------------------------------------------

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

104: -- ----------------------------------------------------------------------------
105: -- |------------------------------< delete_dml >------------------------------|
106: -- ----------------------------------------------------------------------------
107: Procedure delete_dml
108: (p_rec in out nocopy pay_grr_shd.g_rec_type,
109: p_effective_date in date,
110: p_datetrack_mode in varchar2,
111: p_validation_start_date in date,
112: p_validation_end_date in date) is

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

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

Line 178: p_rec.effective_start_date := pay_grr_shd.g_old_rec.effective_start_date;

174: --
175: --
176: -- 40.1 change a start.
177: --
178: p_rec.effective_start_date := pay_grr_shd.g_old_rec.effective_start_date;
179: --
180: -- 40.1 change a end.
181: --
182: If (p_datetrack_mode = 'DELETE') then

Line 190: pay_grr_shd.upd_effective_end_date

186: End If;
187: --
188: -- Update the current effective end date record
189: --
190: pay_grr_shd.upd_effective_end_date
191: (p_effective_date => p_effective_date,
192: p_base_key_value => p_rec.grade_rule_id,
193: p_new_effective_end_date => p_rec.effective_end_date,
194: p_validation_start_date => p_validation_start_date,

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

240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure pre_delete
244: (p_rec in out nocopy pay_grr_shd.g_rec_type,
245: p_effective_date in date,
246: p_datetrack_mode in varchar2,
247: p_validation_start_date in date,
248: p_validation_end_date in date) is

Line 302: (p_rec in pay_grr_shd.g_rec_type,

298: --
299: -- {End Of Comments}
300: -- ----------------------------------------------------------------------------
301: Procedure post_delete
302: (p_rec in pay_grr_shd.g_rec_type,
303: p_effective_date in date,
304: p_datetrack_mode in varchar2,
305: p_validation_start_date in date,
306: p_validation_end_date in date) is

Line 321: p_rec in out nocopy pay_grr_shd.g_rec_type,

317: -- |---------------------------------< del >----------------------------------|
318: -- ----------------------------------------------------------------------------
319: Procedure del
320: (
321: p_rec in out nocopy pay_grr_shd.g_rec_type,
322: p_effective_date in date,
323: p_datetrack_mode in varchar2,
324: p_validate in boolean default false
325: ) is

Line 349: pay_grr_shd.lck

345: End If;
346: --
347: -- We must lock the row which we need to delete.
348: --
349: pay_grr_shd.lck
350: (p_effective_date => p_effective_date,
351: p_datetrack_mode => p_datetrack_mode,
352: p_grade_rule_id => p_rec.grade_rule_id,
353: p_object_version_number => p_rec.object_version_number,

Line 423: l_rec pay_grr_shd.g_rec_type;

419: p_datetrack_mode in varchar2,
420: p_validate in boolean default false
421: ) is
422: --
423: l_rec pay_grr_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'del';
425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);