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_XID_DEL dependencies on BEN_XID_SHD

Line 86: Procedure delete_dml(p_rec in ben_xid_shd.g_rec_type) is

82: -- Internal Row Handler Use Only.
83: --
84: -- {End Of Comments}
85: -- ----------------------------------------------------------------------------
86: Procedure delete_dml(p_rec in ben_xid_shd.g_rec_type) is
87: --
88: l_proc varchar2(72) := g_package||'delete_dml';
89: --
90: Begin

Line 93: ben_xid_shd.g_api_dml := true; -- Set the api dml status

89: --
90: Begin
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: --
93: ben_xid_shd.g_api_dml := true; -- Set the api dml status
94: --
95: -- Delete the ben_ext_incl_data_elmt row.
96: --
97: delete from ben_ext_incl_data_elmt

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

96: --
97: delete from ben_ext_incl_data_elmt
98: where ext_incl_data_elmt_id = p_rec.ext_incl_data_elmt_id;
99: --
100: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception

Line 107: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

103: --
104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xid_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

Line 108: ben_xid_shd.constraint_error

104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xid_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;

Line 111: ben_xid_shd.g_api_dml := false; -- Unset the api dml status

107: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xid_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xid_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End delete_dml;
114: --
115: -- ----------------------------------------------------------------------------

Line 147: Procedure pre_delete(p_rec in ben_xid_shd.g_rec_type) is

143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_delete(p_rec in ben_xid_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_delete';
150: --
151: Begin

Line 189: Procedure post_delete(p_rec in ben_xid_shd.g_rec_type) is

185: -- Internal table Handler Use Only.
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_delete(p_rec in ben_xid_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_delete';
192: --
193: Begin

Line 209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id

205: --
206: ben_xid_rkd.after_delete
207: (
208: p_ext_incl_data_elmt_id =>p_rec.ext_incl_data_elmt_id
209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number

Line 210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id

206: ben_xid_rkd.after_delete
207: (
208: p_ext_incl_data_elmt_id =>p_rec.ext_incl_data_elmt_id
209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number
214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id

Line 211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id

207: (
208: p_ext_incl_data_elmt_id =>p_rec.ext_incl_data_elmt_id
209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number
214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id
215: );

Line 212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code

208: p_ext_incl_data_elmt_id =>p_rec.ext_incl_data_elmt_id
209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number
214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id
215: );
216: --

Line 213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number

209: ,p_ext_rcd_in_file_id_o =>ben_xid_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number
214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id
215: );
216: --
217: exception

Line 214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id

210: ,p_ext_data_elmt_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_id
211: ,p_business_group_id_o =>ben_xid_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xid_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xid_shd.g_old_rec.object_version_number
214: ,p_ext_data_elmt_in_rcd_id_o =>ben_xid_shd.g_old_rec.ext_data_elmt_in_rcd_id
215: );
216: --
217: exception
218: --

Line 238: p_rec in ben_xid_shd.g_rec_type

234: -- |---------------------------------< del >----------------------------------|
235: -- ----------------------------------------------------------------------------
236: Procedure del
237: (
238: p_rec in ben_xid_shd.g_rec_type
239: ) is
240: --
241: l_proc varchar2(72) := g_package||'del';
242: --

Line 248: ben_xid_shd.lck

244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- We must lock the row which we need to delete.
247: --
248: ben_xid_shd.lck
249: (
250: p_rec.ext_incl_data_elmt_id,
251: p_rec.object_version_number
252: );

Line 281: l_rec ben_xid_shd.g_rec_type;

277: p_legislation_code in varchar2 default null,
278: p_object_version_number in number
279: ) is
280: --
281: l_rec ben_xid_shd.g_rec_type;
282: l_proc varchar2(72) := g_package||'del';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);