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_XRE_INS dependencies on BEN_XRE_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ben_xre_shd.g_rec_type) is

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

Line 61: ben_xre_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ben_xre_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_ext_rslt_err
64: --
65: insert into ben_ext_rslt_err

Line 94: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

90: p_rec.program_update_date,
91: p_rec.ext_rslt_id
92: );
93: --
94: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: Exception
98: When hr_api.check_integrity_violated Then

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

96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
101: ben_xre_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated

Line 101: ben_xre_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
101: ben_xre_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

Line 105: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

101: ben_xre_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
106: ben_xre_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated

Line 106: ben_xre_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
106: ben_xre_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

Line 110: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

106: ben_xre_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
111: ben_xre_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

Line 111: ben_xre_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
111: ben_xre_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;

Line 114: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

110: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
111: ben_xre_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End insert_dml;
117: --
118: -- ----------------------------------------------------------------------------

Line 155: Procedure pre_insert(p_rec in out nocopy ben_xre_shd.g_rec_type) is

151: -- Internal Row Handler Use Only.
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure pre_insert(p_rec in out nocopy ben_xre_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'pre_insert';
158: --
159: cursor c1 is

Line 209: p_effective_date in date,p_rec in ben_xre_shd.g_rec_type) is

205: --
206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_insert(
209: p_effective_date in date,p_rec in ben_xre_shd.g_rec_type) is
210: --
211: l_proc varchar2(72) := g_package||'post_insert';
212: --
213: Begin

Line 260: p_rec in out nocopy ben_xre_shd.g_rec_type

256: -- ----------------------------------------------------------------------------
257: Procedure ins
258: (
259: p_effective_date in date,
260: p_rec in out nocopy ben_xre_shd.g_rec_type
261: ) is
262: --
263: l_proc varchar2(72) := g_package||'ins';
264: --

Line 307: l_rec ben_xre_shd.g_rec_type;

303: p_program_update_date in date default null,
304: p_ext_rslt_id in number default null
305: ) is
306: --
307: l_rec ben_xre_shd.g_rec_type;
308: l_proc varchar2(72) := g_package||'ins';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);

Line 317: ben_xre_shd.convert_args

313: -- Call conversion function to turn arguments into the
314: -- p_rec structure.
315: --
316: l_rec :=
317: ben_xre_shd.convert_args
318: (
319: null,
320: p_err_num,
321: p_err_txt,