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_XRF_DEL dependencies on BEN_XRF_SHD

Line 87: Procedure delete_dml(p_rec in ben_xrf_shd.g_rec_type) is

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

Line 94: ben_xrf_shd.g_api_dml := true; -- Set the api dml status

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

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

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

Line 108: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 109: ben_xrf_shd.constraint_error

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

Line 112: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status

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

Line 148: Procedure pre_delete(p_rec in ben_xrf_shd.g_rec_type) is

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

Line 191: p_effective_date in date,p_rec in ben_xrf_shd.g_rec_type) is

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_delete(
191: p_effective_date in date,p_rec in ben_xrf_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'post_delete';
194: --
195: Begin

Line 212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num

208: --
209: ben_xrf_rkd.after_delete
210: (
211: p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id

Line 213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd

209: ben_xrf_rkd.after_delete
210: (
211: p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id

Line 214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id

210: (
211: p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id

Line 215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id

211: p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id

Line 216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id

212: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id

Line 217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id

213: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code

Line 218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id

214: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number

Line 219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id

215: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd

Line 220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id

216: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag

Line 221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code

217: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag

Line 222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number

218: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag

Line 223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd

219: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
227: );

Line 224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag

220: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
227: );
228: --

Line 225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag

221: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
227: );
228: --
229: exception

Line 226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag

222: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
223: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
224: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
225: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
226: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
227: );
228: --
229: exception
230: --

Line 251: p_rec in ben_xrf_shd.g_rec_type

247: -- ----------------------------------------------------------------------------
248: Procedure del
249: (
250: p_effective_date in date,
251: p_rec in ben_xrf_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'del';
255: --

Line 261: ben_xrf_shd.lck

257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: -- We must lock the row which we need to delete.
260: --
261: ben_xrf_shd.lck
262: (
263: p_rec.ext_rcd_in_file_id,
264: p_rec.object_version_number
265: );

Line 297: l_rec ben_xrf_shd.g_rec_type;

293: p_legislation_code in varchar2 default null,
294: p_object_version_number in number
295: ) is
296: --
297: l_rec ben_xrf_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'del';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);