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_ACT_UPD dependencies on BEN_ACT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_act_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_act_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_act_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_act_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_person_actions Row
68: --
69: update ben_person_actions

Line 80: ben_act_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 88: ben_act_shd.constraint_error

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

Line 92: ben_act_shd.g_api_dml := false; -- Unset the api dml status

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

Line 93: ben_act_shd.constraint_error

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

Line 97: ben_act_shd.g_api_dml := false; -- Unset the api dml status

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

Line 98: ben_act_shd.constraint_error

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

Line 101: ben_act_shd.g_api_dml := false; -- Unset the api dml status

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

Line 137: Procedure pre_update(p_rec in ben_act_shd.g_rec_type) is

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

Line 180: p_effective_date in date,p_rec in ben_act_shd.g_rec_type) is

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

Line 201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id

197: ,p_action_status_cd => p_rec.action_status_cd
198: ,p_chunk_number => p_rec.chunk_number
199: ,p_object_version_number => p_rec.object_version_number
200: ,p_effective_date => p_effective_date
201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id
202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number

Line 202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id

198: ,p_chunk_number => p_rec.chunk_number
199: ,p_object_version_number => p_rec.object_version_number
200: ,p_effective_date => p_effective_date
201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id
202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number
206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);

Line 203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id

199: ,p_object_version_number => p_rec.object_version_number
200: ,p_effective_date => p_effective_date
201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id
202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number
206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);
207: --

Line 204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd

200: ,p_effective_date => p_effective_date
201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id
202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number
206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);
207: --
208: exception

Line 205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number

201: ,p_person_id_o => ben_act_shd.g_old_rec.person_id
202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number
206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);
207: --
208: exception
209: --

Line 206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);

202: ,p_ler_id_o => ben_act_shd.g_old_rec.ler_id
203: ,p_benefit_action_id_o => ben_act_shd.g_old_rec.benefit_action_id
204: ,p_action_status_cd_o => ben_act_shd.g_old_rec.action_status_cd
205: ,p_chunk_number_o => ben_act_shd.g_old_rec.chunk_number
206: ,p_object_version_number_o => ben_act_shd.g_old_rec.object_version_number);
207: --
208: exception
209: --
210: when hr_api.cannot_find_prog_unit then

Line 267: Procedure convert_defs(p_rec in out nocopy ben_act_shd.g_rec_type) is

263: -- Internal Row Handler Use Only.
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure convert_defs(p_rec in out nocopy ben_act_shd.g_rec_type) is
268: --
269: l_proc varchar2(72) := g_package||'convert_defs';
270: --
271: Begin

Line 282: ben_act_shd.g_old_rec.person_id;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.person_id = hr_api.g_number) then
281: p_rec.person_id :=
282: ben_act_shd.g_old_rec.person_id;
283: End If;
284: If (p_rec.ler_id = hr_api.g_number) then
285: p_rec.ler_id :=
286: ben_act_shd.g_old_rec.ler_id;

Line 286: ben_act_shd.g_old_rec.ler_id;

282: ben_act_shd.g_old_rec.person_id;
283: End If;
284: If (p_rec.ler_id = hr_api.g_number) then
285: p_rec.ler_id :=
286: ben_act_shd.g_old_rec.ler_id;
287: End If;
288: If (p_rec.benefit_action_id = hr_api.g_number) then
289: p_rec.benefit_action_id :=
290: ben_act_shd.g_old_rec.benefit_action_id;

Line 290: ben_act_shd.g_old_rec.benefit_action_id;

286: ben_act_shd.g_old_rec.ler_id;
287: End If;
288: If (p_rec.benefit_action_id = hr_api.g_number) then
289: p_rec.benefit_action_id :=
290: ben_act_shd.g_old_rec.benefit_action_id;
291: End If;
292: If (p_rec.action_status_cd = hr_api.g_varchar2) then
293: p_rec.action_status_cd :=
294: ben_act_shd.g_old_rec.action_status_cd;

Line 294: ben_act_shd.g_old_rec.action_status_cd;

290: ben_act_shd.g_old_rec.benefit_action_id;
291: End If;
292: If (p_rec.action_status_cd = hr_api.g_varchar2) then
293: p_rec.action_status_cd :=
294: ben_act_shd.g_old_rec.action_status_cd;
295: End If;
296: If (p_rec.chunk_number = hr_api.g_number) then
297: p_rec.chunk_number :=
298: ben_act_shd.g_old_rec.chunk_number;

Line 298: ben_act_shd.g_old_rec.chunk_number;

294: ben_act_shd.g_old_rec.action_status_cd;
295: End If;
296: If (p_rec.chunk_number = hr_api.g_number) then
297: p_rec.chunk_number :=
298: ben_act_shd.g_old_rec.chunk_number;
299: End If;
300:
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 312: p_rec in out nocopy ben_act_shd.g_rec_type

308: -- ----------------------------------------------------------------------------
309: Procedure upd
310: (
311: p_effective_date in date,
312: p_rec in out nocopy ben_act_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'upd';
316: --

Line 322: ben_act_shd.lck

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: ben_act_shd.lck
323: (
324: p_rec.person_action_id,
325: p_rec.object_version_number
326: );

Line 366: l_rec ben_act_shd.g_rec_type;

362: p_chunk_number in number default hr_api.g_number,
363: p_object_version_number in out nocopy number
364: ) is
365: --
366: l_rec ben_act_shd.g_rec_type;
367: l_proc varchar2(72) := g_package||'upd';
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);

Line 376: ben_act_shd.convert_args

372: -- Call conversion function to turn arguments into the
373: -- l_rec structure.
374: --
375: l_rec :=
376: ben_act_shd.convert_args
377: (
378: p_person_action_id,
379: p_person_id,
380: p_ler_id,