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_XCT_UPD dependencies on BEN_XCT_SHD

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

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

Line 83: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

79: object_version_number = p_rec.object_version_number,
80: excld_flag = p_rec.excld_flag
81: where ext_crit_typ_id = p_rec.ext_crit_typ_id;
82: --
83: ben_xct_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception

Line 90: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 91: ben_xct_shd.constraint_error

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

Line 95: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 96: ben_xct_shd.constraint_error

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

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

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

Line 101: ben_xct_shd.constraint_error

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

Line 104: ben_xct_shd.g_api_dml := false; -- Unset the api dml status

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

Line 140: Procedure pre_update(p_rec in ben_xct_shd.g_rec_type) is

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

Line 183: p_effective_date in date,p_rec in ben_xct_shd.g_rec_type) is

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

Line 205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd

201: ,p_legislation_code =>p_rec.legislation_code
202: ,p_object_version_number =>p_rec.object_version_number
203: ,p_effective_date =>p_effective_date
204: ,p_excld_flag =>p_rec.excld_flag
205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd
206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number

Line 206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id

202: ,p_object_version_number =>p_rec.object_version_number
203: ,p_effective_date =>p_effective_date
204: ,p_excld_flag =>p_rec.excld_flag
205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd
206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number
210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag

Line 207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id

203: ,p_effective_date =>p_effective_date
204: ,p_excld_flag =>p_rec.excld_flag
205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd
206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number
210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag
211: );

Line 208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code

204: ,p_excld_flag =>p_rec.excld_flag
205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd
206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number
210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag
211: );
212: --

Line 209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number

205: ,p_crit_typ_cd_o =>ben_xct_shd.g_old_rec.crit_typ_cd
206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number
210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag
211: );
212: --
213: exception

Line 210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag

206: ,p_ext_crit_prfl_id_o =>ben_xct_shd.g_old_rec.ext_crit_prfl_id
207: ,p_business_group_id_o =>ben_xct_shd.g_old_rec.business_group_id
208: ,p_legislation_code_o =>ben_xct_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_xct_shd.g_old_rec.object_version_number
210: ,p_excld_flag_o =>ben_xct_shd.g_old_rec.excld_flag
211: );
212: --
213: exception
214: --

Line 272: Procedure convert_defs(p_rec in out nocopy ben_xct_shd.g_rec_type) is

268: -- Internal Row Handler Use Only.
269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs(p_rec in out nocopy ben_xct_shd.g_rec_type) is
273: --
274: l_proc varchar2(72) := g_package||'convert_defs';
275: --
276: Begin

Line 287: ben_xct_shd.g_old_rec.crit_typ_cd;

283: -- is being used then we must set to the 'current' argument value.
284: --
285: If (p_rec.crit_typ_cd = hr_api.g_varchar2) then
286: p_rec.crit_typ_cd :=
287: ben_xct_shd.g_old_rec.crit_typ_cd;
288: End If;
289: If (p_rec.ext_crit_prfl_id = hr_api.g_number) then
290: p_rec.ext_crit_prfl_id :=
291: ben_xct_shd.g_old_rec.ext_crit_prfl_id;

Line 291: ben_xct_shd.g_old_rec.ext_crit_prfl_id;

287: ben_xct_shd.g_old_rec.crit_typ_cd;
288: End If;
289: If (p_rec.ext_crit_prfl_id = hr_api.g_number) then
290: p_rec.ext_crit_prfl_id :=
291: ben_xct_shd.g_old_rec.ext_crit_prfl_id;
292: End If;
293: If (p_rec.business_group_id = hr_api.g_number) then
294: p_rec.business_group_id :=
295: ben_xct_shd.g_old_rec.business_group_id;

Line 295: ben_xct_shd.g_old_rec.business_group_id;

291: ben_xct_shd.g_old_rec.ext_crit_prfl_id;
292: End If;
293: If (p_rec.business_group_id = hr_api.g_number) then
294: p_rec.business_group_id :=
295: ben_xct_shd.g_old_rec.business_group_id;
296: End If;
297: If (p_rec.legislation_code = hr_api.g_varchar2) then
298: p_rec.legislation_code :=
299: ben_xct_shd.g_old_rec.legislation_code;

Line 299: ben_xct_shd.g_old_rec.legislation_code;

295: ben_xct_shd.g_old_rec.business_group_id;
296: End If;
297: If (p_rec.legislation_code = hr_api.g_varchar2) then
298: p_rec.legislation_code :=
299: ben_xct_shd.g_old_rec.legislation_code;
300: End If;
301: If (p_rec.excld_flag = hr_api.g_varchar2) then
302: p_rec.excld_flag :=
303: ben_xct_shd.g_old_rec.excld_flag;

Line 303: ben_xct_shd.g_old_rec.excld_flag;

299: ben_xct_shd.g_old_rec.legislation_code;
300: End If;
301: If (p_rec.excld_flag = hr_api.g_varchar2) then
302: p_rec.excld_flag :=
303: ben_xct_shd.g_old_rec.excld_flag;
304: End If;
305:
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 317: p_rec in out nocopy ben_xct_shd.g_rec_type

313: -- ----------------------------------------------------------------------------
314: Procedure upd
315: (
316: p_effective_date in date,
317: p_rec in out nocopy ben_xct_shd.g_rec_type
318: ) is
319: --
320: l_proc varchar2(72) := g_package||'upd';
321: --

Line 327: ben_xct_shd.lck

323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: -- We must lock the row which we need to update.
326: --
327: ben_xct_shd.lck
328: (
329: p_rec.ext_crit_typ_id,
330: p_rec.object_version_number
331: );

Line 377: l_rec ben_xct_shd.g_rec_type;

373: p_object_version_number in out nocopy number,
374: p_excld_flag in varchar2 default hr_api.g_varchar2
375: ) is
376: --
377: l_rec ben_xct_shd.g_rec_type;
378: l_proc varchar2(72) := g_package||'upd';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);

Line 387: ben_xct_shd.convert_args

383: -- Call conversion function to turn arguments into the
384: -- l_rec structure.
385: --
386: l_rec :=
387: ben_xct_shd.convert_args
388: (
389: p_ext_crit_typ_id,
390: p_crit_typ_cd,
391: p_ext_crit_prfl_id,