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_XIC_UPD dependencies on BEN_XIC_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_xic_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_xic_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_xic_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_xic_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_incl_chg Row
68: --
69: update ben_ext_incl_chg

Line 84: ben_xic_shd.g_api_dml := false; -- Unset the api dml status

80: last_update_login = p_rec.last_update_login,
81: object_version_number = p_rec.object_version_number
82: where ext_incl_chg_id = p_rec.ext_incl_chg_id;
83: --
84: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception

Line 91: ben_xic_shd.g_api_dml := false; -- Unset the api dml status

87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
92: ben_xic_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated

Line 92: ben_xic_shd.constraint_error

88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
92: ben_xic_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: ben_xic_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 97: ben_xic_shd.constraint_error

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

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

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

Line 102: ben_xic_shd.constraint_error

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

Line 105: ben_xic_shd.g_api_dml := false; -- Unset the api dml status

101: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
102: ben_xic_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: ben_xic_shd.g_api_dml := false; -- Unset the api dml status
106: Raise;
107: End update_dml;
108: --
109: -- ----------------------------------------------------------------------------

Line 141: Procedure pre_update(p_rec in ben_xic_shd.g_rec_type) is

137: -- Internal Row Handler Use Only.
138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_update(p_rec in ben_xic_shd.g_rec_type) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --
145: Begin

Line 184: p_effective_date in date,p_rec in ben_xic_shd.g_rec_type) is

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update(
184: p_effective_date in date,p_rec in ben_xic_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin

Line 207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd

203: ,p_business_group_id =>p_rec.business_group_id
204: ,p_legislation_code =>p_rec.legislation_code
205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd
208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id

Line 208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source

204: ,p_legislation_code =>p_rec.legislation_code
205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd
208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xic_shd.g_old_rec.legislation_code

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

205: ,p_object_version_number =>p_rec.object_version_number
206: ,p_effective_date =>p_effective_date
207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd
208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xic_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xic_shd.g_old_rec.object_version_number

Line 210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id

206: ,p_effective_date =>p_effective_date
207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd
208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xic_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xic_shd.g_old_rec.object_version_number
214: );

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

207: ,p_chg_evt_cd_o =>ben_xic_shd.g_old_rec.chg_evt_cd
208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xic_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xic_shd.g_old_rec.object_version_number
214: );
215: --

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

208: ,p_chg_evt_source_o =>ben_xic_shd.g_old_rec.chg_evt_source
209: ,p_ext_rcd_in_file_id_o =>ben_xic_shd.g_old_rec.ext_rcd_in_file_id
210: ,p_ext_data_elmt_in_rcd_id_o =>ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id
211: ,p_business_group_id_o =>ben_xic_shd.g_old_rec.business_group_id
212: ,p_legislation_code_o =>ben_xic_shd.g_old_rec.legislation_code
213: ,p_object_version_number_o =>ben_xic_shd.g_old_rec.object_version_number
214: );
215: --
216: exception

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

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

Line 275: Procedure convert_defs(p_rec in out nocopy ben_xic_shd.g_rec_type) is

271: -- Internal Row Handler Use Only.
272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure convert_defs(p_rec in out nocopy ben_xic_shd.g_rec_type) is
276: --
277: l_proc varchar2(72) := g_package||'convert_defs';
278: --
279: Begin

Line 290: ben_xic_shd.g_old_rec.chg_evt_cd;

286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.chg_evt_cd = hr_api.g_varchar2) then
289: p_rec.chg_evt_cd :=
290: ben_xic_shd.g_old_rec.chg_evt_cd;
291: End If;
292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then
293: p_rec.chg_evt_source :=
294: ben_xic_shd.g_old_rec.chg_evt_source;

Line 294: ben_xic_shd.g_old_rec.chg_evt_source;

290: ben_xic_shd.g_old_rec.chg_evt_cd;
291: End If;
292: If (p_rec.chg_evt_source = hr_api.g_varchar2) then
293: p_rec.chg_evt_source :=
294: ben_xic_shd.g_old_rec.chg_evt_source;
295: End If;
296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
297: p_rec.ext_rcd_in_file_id :=
298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;

Line 298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;

294: ben_xic_shd.g_old_rec.chg_evt_source;
295: End If;
296: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
297: p_rec.ext_rcd_in_file_id :=
298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;
299: End If;
300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
301: p_rec.ext_data_elmt_in_rcd_id :=
302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;

Line 302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;

298: ben_xic_shd.g_old_rec.ext_rcd_in_file_id;
299: End If;
300: If (p_rec.ext_data_elmt_in_rcd_id = hr_api.g_number) then
301: p_rec.ext_data_elmt_in_rcd_id :=
302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;
303: End If;
304: If (p_rec.business_group_id = hr_api.g_number) then
305: p_rec.business_group_id :=
306: ben_xic_shd.g_old_rec.business_group_id;

Line 306: ben_xic_shd.g_old_rec.business_group_id;

302: ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id;
303: End If;
304: If (p_rec.business_group_id = hr_api.g_number) then
305: p_rec.business_group_id :=
306: ben_xic_shd.g_old_rec.business_group_id;
307: End If;
308: If (p_rec.legislation_code = hr_api.g_varchar2) then
309: p_rec.legislation_code :=
310: ben_xic_shd.g_old_rec.legislation_code;

Line 310: ben_xic_shd.g_old_rec.legislation_code;

306: ben_xic_shd.g_old_rec.business_group_id;
307: End If;
308: If (p_rec.legislation_code = hr_api.g_varchar2) then
309: p_rec.legislation_code :=
310: ben_xic_shd.g_old_rec.legislation_code;
311: End If;
312:
313:
314: --

Line 325: p_rec in out nocopy ben_xic_shd.g_rec_type

321: -- ----------------------------------------------------------------------------
322: Procedure upd
323: (
324: p_effective_date in date,
325: p_rec in out nocopy ben_xic_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --

Line 335: ben_xic_shd.lck

331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: ben_xic_shd.lck
336: (
337: p_rec.ext_incl_chg_id,
338: p_rec.object_version_number
339: );

Line 386: l_rec ben_xic_shd.g_rec_type;

382: p_created_by in number default hr_api.g_number,
383: p_object_version_number in out nocopy number
384: ) is
385: --
386: l_rec ben_xic_shd.g_rec_type;
387: l_proc varchar2(72) := g_package||'upd';
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);

Line 396: ben_xic_shd.convert_args

392: -- Call conversion function to turn arguments into the
393: -- l_rec structure.
394: --
395: l_rec :=
396: ben_xic_shd.convert_args
397: (
398: p_ext_incl_chg_id,
399: p_chg_evt_cd,
400: p_chg_evt_source,