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

Line 54: Procedure update_dml(p_rec in out nocopy ben_xwc_shd.g_rec_type) is

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

Line 65: ben_xwc_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_xwc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_where_clause Row
68: --
69: update ben_ext_where_clause

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

85: object_version_number = p_rec.object_version_number,
86: cond_ext_data_elmt_in_rcd_id = p_rec.cond_ext_data_elmt_in_rcd_id
87: where ext_where_clause_id = p_rec.ext_where_clause_id;
88: --
89: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception

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

92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xwc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated

Line 97: ben_xwc_shd.constraint_error

93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status
97: ben_xwc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: ben_xwc_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 102: ben_xwc_shd.constraint_error

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

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

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

Line 107: ben_xwc_shd.constraint_error

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

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

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

Line 146: Procedure pre_update(p_rec in ben_xwc_shd.g_rec_type) is

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

Line 189: p_effective_date in date,p_rec in ben_xwc_shd.g_rec_type) is

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

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

213: ,p_legislation_code =>p_rec.legislation_code
214: ,p_object_version_number =>p_rec.object_version_number
215: ,p_cond_ext_data_elmt_in_rcd_id =>p_rec.cond_ext_data_elmt_in_rcd_id
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id

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

214: ,p_object_version_number =>p_rec.object_version_number
215: ,p_cond_ext_data_elmt_in_rcd_id =>p_rec.cond_ext_data_elmt_in_rcd_id
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id

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

215: ,p_cond_ext_data_elmt_in_rcd_id =>p_rec.cond_ext_data_elmt_in_rcd_id
216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id

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

216: ,p_effective_date =>p_effective_date
217: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id

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

217: ,p_seq_num_o =>ben_xwc_shd.g_old_rec.seq_num
218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id

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

218: ,p_oper_cd_o =>ben_xwc_shd.g_old_rec.oper_cd
219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code

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

219: ,p_val_o =>ben_xwc_shd.g_old_rec.val
220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number

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

220: ,p_and_or_cd_o =>ben_xwc_shd.g_old_rec.and_or_cd
221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
228: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id

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

221: ,p_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_id
222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
228: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
229: );

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

222: ,p_cond_ext_data_elmt_id_o =>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id
223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
228: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
229: );
230: --

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

223: ,p_ext_rcd_in_file_id_o =>ben_xwc_shd.g_old_rec.ext_rcd_in_file_id
224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
228: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
229: );
230: --
231: exception

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

224: ,p_ext_data_elmt_in_rcd_id_o =>ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id
225: ,p_business_group_id_o =>ben_xwc_shd.g_old_rec.business_group_id
226: ,p_legislation_code_o =>ben_xwc_shd.g_old_rec.legislation_code
227: ,p_object_version_number_o =>ben_xwc_shd.g_old_rec.object_version_number
228: ,p_cond_ext_data_elmt_in_rcd__o=>ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id
229: );
230: --
231: exception
232: --

Line 290: Procedure convert_defs(p_rec in out nocopy ben_xwc_shd.g_rec_type) is

286: -- Internal Row Handler Use Only.
287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure convert_defs(p_rec in out nocopy ben_xwc_shd.g_rec_type) is
291: --
292: l_proc varchar2(72) := g_package||'convert_defs';
293: --
294: Begin

Line 305: ben_xwc_shd.g_old_rec.seq_num;

301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.seq_num = hr_api.g_number) then
304: p_rec.seq_num :=
305: ben_xwc_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.oper_cd = hr_api.g_varchar2) then
308: p_rec.oper_cd :=
309: ben_xwc_shd.g_old_rec.oper_cd;

Line 309: ben_xwc_shd.g_old_rec.oper_cd;

305: ben_xwc_shd.g_old_rec.seq_num;
306: End If;
307: If (p_rec.oper_cd = hr_api.g_varchar2) then
308: p_rec.oper_cd :=
309: ben_xwc_shd.g_old_rec.oper_cd;
310: End If;
311: If (p_rec.val = hr_api.g_varchar2) then
312: p_rec.val :=
313: ben_xwc_shd.g_old_rec.val;

Line 313: ben_xwc_shd.g_old_rec.val;

309: ben_xwc_shd.g_old_rec.oper_cd;
310: End If;
311: If (p_rec.val = hr_api.g_varchar2) then
312: p_rec.val :=
313: ben_xwc_shd.g_old_rec.val;
314: End If;
315: If (p_rec.and_or_cd = hr_api.g_varchar2) then
316: p_rec.and_or_cd :=
317: ben_xwc_shd.g_old_rec.and_or_cd;

Line 317: ben_xwc_shd.g_old_rec.and_or_cd;

313: ben_xwc_shd.g_old_rec.val;
314: End If;
315: If (p_rec.and_or_cd = hr_api.g_varchar2) then
316: p_rec.and_or_cd :=
317: ben_xwc_shd.g_old_rec.and_or_cd;
318: End If;
319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
320: p_rec.ext_data_elmt_id :=
321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;

Line 321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;

317: ben_xwc_shd.g_old_rec.and_or_cd;
318: End If;
319: If (p_rec.ext_data_elmt_id = hr_api.g_number) then
320: p_rec.ext_data_elmt_id :=
321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;
322: End If;
323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then
324: p_rec.cond_ext_data_elmt_id :=
325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;

Line 325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;

321: ben_xwc_shd.g_old_rec.ext_data_elmt_id;
322: End If;
323: If (p_rec.cond_ext_data_elmt_id = hr_api.g_number) then
324: p_rec.cond_ext_data_elmt_id :=
325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;
326: End If;
327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
328: p_rec.ext_rcd_in_file_id :=
329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;

Line 329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;

325: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_id;
326: End If;
327: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
328: p_rec.ext_rcd_in_file_id :=
329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;
330: End If;
331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
332: p_rec.ext_data_elmt_in_rcd_id :=
333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;

Line 333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;

329: ben_xwc_shd.g_old_rec.ext_rcd_in_file_id;
330: End If;
331: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
332: p_rec.ext_data_elmt_in_rcd_id :=
333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xwc_shd.g_old_rec.business_group_id;

Line 337: ben_xwc_shd.g_old_rec.business_group_id;

333: ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_xwc_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xwc_shd.g_old_rec.legislation_code;

Line 341: ben_xwc_shd.g_old_rec.legislation_code;

337: ben_xwc_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.legislation_code = hr_api.g_varchar2) then
340: p_rec.legislation_code :=
341: ben_xwc_shd.g_old_rec.legislation_code;
342: End If;
343: If (p_rec.cond_ext_data_elmt_in_rcd_id = hr_api.g_number) then
344: p_rec.cond_ext_data_elmt_in_rcd_id :=
345: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id;

Line 345: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id;

341: ben_xwc_shd.g_old_rec.legislation_code;
342: End If;
343: If (p_rec.cond_ext_data_elmt_in_rcd_id = hr_api.g_number) then
344: p_rec.cond_ext_data_elmt_in_rcd_id :=
345: ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id;
346: End If;
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: --

Line 358: p_rec in out nocopy ben_xwc_shd.g_rec_type

354: -- ----------------------------------------------------------------------------
355: Procedure upd
356: (
357: p_effective_date in date,
358: p_rec in out nocopy ben_xwc_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'upd';
362: --

Line 368: ben_xwc_shd.lck

364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- We must lock the row which we need to update.
367: --
368: ben_xwc_shd.lck
369: (
370: p_rec.ext_where_clause_id,
371: p_rec.object_version_number
372: );

Line 424: l_rec ben_xwc_shd.g_rec_type;

420: p_object_version_number in out nocopy number,
421: p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
422: ) is
423: --
424: l_rec ben_xwc_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'upd';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);

Line 434: ben_xwc_shd.convert_args

430: -- Call conversion function to turn arguments into the
431: -- l_rec structure.
432: --
433: l_rec :=
434: ben_xwc_shd.convert_args
435: (
436: p_ext_where_clause_id,
437: p_seq_num,
438: p_oper_cd,