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

Line 51: Procedure delete_dml(p_rec in ben_xre_shd.g_rec_type) is

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

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

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_xre_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_ext_rslt_err row.
61: --
62: delete from ben_ext_rslt_err

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

61: --
62: delete from ben_ext_rslt_err
63: where ext_rslt_err_id = p_rec.ext_rslt_err_id;
64: --
65: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
73: ben_xre_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_xre_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_xre_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
73: ben_xre_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
73: ben_xre_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_xre_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_xre_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_xre_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

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

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_xre_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num

166: --
167: ben_xre_rkd.after_delete
168: (
169: p_ext_rslt_err_id =>p_rec.ext_rslt_err_id
170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num
171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id

Line 171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt

167: ben_xre_rkd.after_delete
168: (
169: p_ext_rslt_err_id =>p_rec.ext_rslt_err_id
170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num
171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number

Line 172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd

168: (
169: p_ext_rslt_err_id =>p_rec.ext_rslt_err_id
170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num
171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id

Line 173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id

169: p_ext_rslt_err_id =>p_rec.ext_rslt_err_id
170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num
171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id

Line 174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id

170: ,p_err_num_o =>ben_xre_shd.g_old_rec.err_num
171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id

Line 175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number

171: ,p_err_txt_o =>ben_xre_shd.g_old_rec.err_txt
172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date

Line 176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id

172: ,p_typ_cd_o =>ben_xre_shd.g_old_rec.typ_cd
173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date
180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id

Line 177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id

173: ,p_person_id_o =>ben_xre_shd.g_old_rec.person_id
174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date
180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id
181: );

Line 178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id

174: ,p_business_group_id_o =>ben_xre_shd.g_old_rec.business_group_id
175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date
180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id
181: );
182: --

Line 179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date

175: ,p_object_version_number_o =>ben_xre_shd.g_old_rec.object_version_number
176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date
180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id
181: );
182: --
183: exception

Line 180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id

176: ,p_request_id_o =>ben_xre_shd.g_old_rec.request_id
177: ,p_program_application_id_o =>ben_xre_shd.g_old_rec.program_application_id
178: ,p_program_id_o =>ben_xre_shd.g_old_rec.program_id
179: ,p_program_update_date_o =>ben_xre_shd.g_old_rec.program_update_date
180: ,p_ext_rslt_id_o =>ben_xre_shd.g_old_rec.ext_rslt_id
181: );
182: --
183: exception
184: --

Line 205: p_rec in ben_xre_shd.g_rec_type

201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (
204: p_effective_date in date,
205: p_rec in ben_xre_shd.g_rec_type
206: ) is
207: --
208: l_proc varchar2(72) := g_package||'del';
209: --

Line 215: ben_xre_shd.lck

211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: -- We must lock the row which we need to delete.
214: --
215: ben_xre_shd.lck
216: (
217: p_rec.ext_rslt_err_id,
218: p_rec.object_version_number
219: );

Line 250: l_rec ben_xre_shd.g_rec_type;

246: p_ext_rslt_err_id in number,
247: p_object_version_number in number
248: ) is
249: --
250: l_rec ben_xre_shd.g_rec_type;
251: l_proc varchar2(72) := g_package||'del';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);