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.BEN_RAN_UPD dependencies on BEN_RAN_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_ran_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_ran_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_ran_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_ran_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_batch_ranges Row
68: --
69: update ben_batch_ranges

Line 79: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

75: ending_person_action_id = p_rec.ending_person_action_id,
76: object_version_number = p_rec.object_version_number
77: where range_id = p_rec.range_id;
78: --
79: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
87: ben_ran_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated

Line 87: ben_ran_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
87: ben_ran_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

Line 91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

87: ben_ran_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
92: ben_ran_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: ben_ran_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
92: ben_ran_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

Line 96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

92: ben_ran_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
97: ben_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: ben_ran_shd.g_api_dml := false; -- Unset the api dml status

Line 97: ben_ran_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
97: ben_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

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

96: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
97: ben_ran_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: ben_ran_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in ben_ran_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in ben_ran_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 179: p_effective_date in date,p_rec in ben_ran_shd.g_rec_type) is

175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(
179: p_effective_date in date,p_rec in ben_ran_shd.g_rec_type) is
180: --
181: l_proc varchar2(72) := g_package||'post_update';
182: --
183: Begin

Line 232: Procedure convert_defs(p_rec in out nocopy ben_ran_shd.g_rec_type) is

228: -- Internal Row Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure convert_defs(p_rec in out nocopy ben_ran_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'convert_defs';
235: --
236: Begin

Line 247: ben_ran_shd.g_old_rec.benefit_action_id;

243: -- is being used then we must set to the 'current' argument value.
244: --
245: If (p_rec.benefit_action_id = hr_api.g_number) then
246: p_rec.benefit_action_id :=
247: ben_ran_shd.g_old_rec.benefit_action_id;
248: End If;
249: If (p_rec.range_status_cd = hr_api.g_varchar2) then
250: p_rec.range_status_cd :=
251: ben_ran_shd.g_old_rec.range_status_cd;

Line 251: ben_ran_shd.g_old_rec.range_status_cd;

247: ben_ran_shd.g_old_rec.benefit_action_id;
248: End If;
249: If (p_rec.range_status_cd = hr_api.g_varchar2) then
250: p_rec.range_status_cd :=
251: ben_ran_shd.g_old_rec.range_status_cd;
252: End If;
253: If (p_rec.starting_person_action_id = hr_api.g_number) then
254: p_rec.starting_person_action_id :=
255: ben_ran_shd.g_old_rec.starting_person_action_id;

Line 255: ben_ran_shd.g_old_rec.starting_person_action_id;

251: ben_ran_shd.g_old_rec.range_status_cd;
252: End If;
253: If (p_rec.starting_person_action_id = hr_api.g_number) then
254: p_rec.starting_person_action_id :=
255: ben_ran_shd.g_old_rec.starting_person_action_id;
256: End If;
257: If (p_rec.ending_person_action_id = hr_api.g_number) then
258: p_rec.ending_person_action_id :=
259: ben_ran_shd.g_old_rec.ending_person_action_id;

Line 259: ben_ran_shd.g_old_rec.ending_person_action_id;

255: ben_ran_shd.g_old_rec.starting_person_action_id;
256: End If;
257: If (p_rec.ending_person_action_id = hr_api.g_number) then
258: p_rec.ending_person_action_id :=
259: ben_ran_shd.g_old_rec.ending_person_action_id;
260: End If;
261:
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 273: p_rec in out nocopy ben_ran_shd.g_rec_type

269: -- ----------------------------------------------------------------------------
270: Procedure upd
271: (
272: p_effective_date in date,
273: p_rec in out nocopy ben_ran_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'upd';
277: --

Line 283: ben_ran_shd.lck

279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- We must lock the row which we need to update.
282: --
283: ben_ran_shd.lck
284: (
285: p_rec.range_id,
286: p_rec.object_version_number
287: );

Line 327: l_rec ben_ran_shd.g_rec_type;

323: p_ending_person_action_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --
327: l_rec ben_ran_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'upd';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);

Line 337: ben_ran_shd.convert_args

333: -- Call conversion function to turn arguments into the
334: -- l_rec structure.
335: --
336: l_rec :=
337: ben_ran_shd.convert_args
338: (
339: p_range_id,
340: p_benefit_action_id,
341: p_range_status_cd,