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_XWC_DEL dependencies on BEN_XWC_SHD

Line 87: Procedure delete_dml(p_rec in ben_xwc_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_xwc_shd.g_rec_type) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --
91: Begin

Line 94: ben_xwc_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_xwc_shd.g_api_dml := true; -- Set the api dml status
95: --
96: -- Delete the ben_ext_where_clause row.
97: --
98: delete from ben_ext_where_clause

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

97: --
98: delete from ben_ext_where_clause
99: where ext_where_clause_id = p_rec.ext_where_clause_id;
100: --
101: ben_xwc_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_xwc_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_xwc_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xwc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status

Line 109: ben_xwc_shd.constraint_error

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

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

108: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
109: ben_xwc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: ben_xwc_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_xwc_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_xwc_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_xwc_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_xwc_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'post_delete';
194: --
195: Begin

Line 210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num

206: --
207: ben_xwc_rkd.after_delete
208: (
209: p_ext_where_clause_id =>p_rec.ext_where_clause_id
210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id

Line 211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd

207: ben_xwc_rkd.after_delete
208: (
209: p_ext_where_clause_id =>p_rec.ext_where_clause_id
210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id

Line 212: ,p_val_o =>ben_xwc_shd.g_old_rec.val

208: (
209: p_ext_where_clause_id =>p_rec.ext_where_clause_id
210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id

Line 213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd

209: p_ext_where_clause_id =>p_rec.ext_where_clause_id
210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id

Line 214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id

210: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id

Line 215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id

211: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code

Line 216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id

212: ,p_val_o =>ben_xwc_shd.g_old_rec.val
213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number

Line 217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id

213: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id

Line 218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id

214: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
222: );

Line 219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code

215: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
222: );
223: --

Line 220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number

216: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
222: );
223: --
224: exception

Line 221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id

217: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
218: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
219: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
220: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
221: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
222: );
223: --
224: exception
225: --

Line 246: p_rec in ben_xwc_shd.g_rec_type

242: -- ----------------------------------------------------------------------------
243: Procedure del
244: (
245: p_effective_date in date,
246: p_rec in ben_xwc_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'del';
250: --

Line 256: ben_xwc_shd.lck

252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must lock the row which we need to delete.
255: --
256: ben_xwc_shd.lck
257: (
258: p_rec.ext_where_clause_id,
259: p_rec.object_version_number
260: );

Line 292: l_rec ben_xwc_shd.g_rec_type;

288: p_legislation_code in varchar2 default null,
289: p_object_version_number in number
290: ) is
291: --
292: l_rec ben_xwc_shd.g_rec_type;
293: l_proc varchar2(72) := g_package||'del';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);