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

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

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

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

88: rqd_flag = p_rec.rqd_flag ,
89: chg_rcd_upd_flag = p_rec.chg_rcd_upd_flag
90: where ext_rcd_in_file_id = p_rec.ext_rcd_in_file_id;
91: --
92: ben_xrf_shd.g_api_dml := false; -- Unset the api dml status
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception

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

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

Line 100: ben_xrf_shd.constraint_error

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

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

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

Line 105: ben_xrf_shd.constraint_error

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

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

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

Line 110: ben_xrf_shd.constraint_error

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

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

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

Line 149: Procedure pre_update(p_rec in ben_xrf_shd.g_rec_type) is

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

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

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

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

219: ,p_hide_flag =>p_rec.hide_flag
220: ,p_rqd_flag =>p_rec.rqd_flag
221: ,p_chg_rcd_upd_flag =>p_rec.chg_rcd_upd_flag
222: ,p_effective_date =>p_effective_date
223: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id

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

220: ,p_rqd_flag =>p_rec.rqd_flag
221: ,p_chg_rcd_upd_flag =>p_rec.chg_rcd_upd_flag
222: ,p_effective_date =>p_effective_date
223: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id

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

221: ,p_chg_rcd_upd_flag =>p_rec.chg_rcd_upd_flag
222: ,p_effective_date =>p_effective_date
223: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id

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

222: ,p_effective_date =>p_effective_date
223: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id

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

223: ,p_seq_num_o =>ben_xrf_shd.g_old_rec.seq_num
224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id

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

224: ,p_sprs_cd_o =>ben_xrf_shd.g_old_rec.sprs_cd
225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code

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

225: ,p_sort1_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id
226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number

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

226: ,p_sort2_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id
227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd

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

227: ,p_sort3_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id
228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag

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

228: ,p_sort4_data_elmt_in_rcd_id_o =>ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id
229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag

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

229: ,p_ext_rcd_id_o =>ben_xrf_shd.g_old_rec.ext_rcd_id
230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
237: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag

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

230: ,p_ext_file_id_o =>ben_xrf_shd.g_old_rec.ext_file_id
231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
237: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
238: );

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

231: ,p_business_group_id_o =>ben_xrf_shd.g_old_rec.business_group_id
232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
237: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
238: );
239: --

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

232: ,p_legislation_code_o =>ben_xrf_shd.g_old_rec.legislation_code
233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
237: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
238: );
239: --
240: exception

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

233: ,p_object_version_number_o =>ben_xrf_shd.g_old_rec.object_version_number
234: ,p_any_or_all_cd_o =>ben_xrf_shd.g_old_rec.any_or_all_cd
235: ,p_hide_flag_o =>ben_xrf_shd.g_old_rec.hide_flag
236: ,p_rqd_flag_o =>ben_xrf_shd.g_old_rec.rqd_flag
237: ,p_chg_rcd_upd_flag_o =>ben_xrf_shd.g_old_rec.chg_rcd_upd_flag
238: );
239: --
240: exception
241: --

Line 299: Procedure convert_defs(p_rec in out nocopy ben_xrf_shd.g_rec_type) is

295: -- Internal Row Handler Use Only.
296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure convert_defs(p_rec in out nocopy ben_xrf_shd.g_rec_type) is
300: --
301: l_proc varchar2(72) := g_package||'convert_defs';
302: --
303: Begin

Line 314: ben_xrf_shd.g_old_rec.seq_num;

310: -- is being used then we must set to the 'current' argument value.
311: --
312: If (p_rec.seq_num = hr_api.g_number) then
313: p_rec.seq_num :=
314: ben_xrf_shd.g_old_rec.seq_num;
315: End If;
316: If (p_rec.sprs_cd = hr_api.g_varchar2) then
317: p_rec.sprs_cd :=
318: ben_xrf_shd.g_old_rec.sprs_cd;

Line 318: ben_xrf_shd.g_old_rec.sprs_cd;

314: ben_xrf_shd.g_old_rec.seq_num;
315: End If;
316: If (p_rec.sprs_cd = hr_api.g_varchar2) then
317: p_rec.sprs_cd :=
318: ben_xrf_shd.g_old_rec.sprs_cd;
319: End If;
320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then
321: p_rec.sort1_data_elmt_in_rcd_id :=
322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;

Line 322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;

318: ben_xrf_shd.g_old_rec.sprs_cd;
319: End If;
320: If (p_rec.sort1_data_elmt_in_rcd_id = hr_api.g_number) then
321: p_rec.sort1_data_elmt_in_rcd_id :=
322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;
323: End If;
324: If (p_rec.sort2_data_elmt_in_rcd_id = hr_api.g_number) then
325: p_rec.sort2_data_elmt_in_rcd_id :=
326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;

Line 326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;

322: ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id;
323: End If;
324: If (p_rec.sort2_data_elmt_in_rcd_id = hr_api.g_number) then
325: p_rec.sort2_data_elmt_in_rcd_id :=
326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;
327: End If;
328: If (p_rec.sort3_data_elmt_in_rcd_id = hr_api.g_number) then
329: p_rec.sort3_data_elmt_in_rcd_id :=
330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;

Line 330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;

326: ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id;
327: End If;
328: If (p_rec.sort3_data_elmt_in_rcd_id = hr_api.g_number) then
329: p_rec.sort3_data_elmt_in_rcd_id :=
330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;
331: End If;
332: If (p_rec.sort4_data_elmt_in_rcd_id = hr_api.g_number) then
333: p_rec.sort4_data_elmt_in_rcd_id :=
334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;

Line 334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;

330: ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id;
331: End If;
332: If (p_rec.sort4_data_elmt_in_rcd_id = hr_api.g_number) then
333: p_rec.sort4_data_elmt_in_rcd_id :=
334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;
335: End If;
336: If (p_rec.ext_rcd_id = hr_api.g_number) then
337: p_rec.ext_rcd_id :=
338: ben_xrf_shd.g_old_rec.ext_rcd_id;

Line 338: ben_xrf_shd.g_old_rec.ext_rcd_id;

334: ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id;
335: End If;
336: If (p_rec.ext_rcd_id = hr_api.g_number) then
337: p_rec.ext_rcd_id :=
338: ben_xrf_shd.g_old_rec.ext_rcd_id;
339: End If;
340: If (p_rec.ext_file_id = hr_api.g_number) then
341: p_rec.ext_file_id :=
342: ben_xrf_shd.g_old_rec.ext_file_id;

Line 342: ben_xrf_shd.g_old_rec.ext_file_id;

338: ben_xrf_shd.g_old_rec.ext_rcd_id;
339: End If;
340: If (p_rec.ext_file_id = hr_api.g_number) then
341: p_rec.ext_file_id :=
342: ben_xrf_shd.g_old_rec.ext_file_id;
343: End If;
344: If (p_rec.business_group_id = hr_api.g_number) then
345: p_rec.business_group_id :=
346: ben_xrf_shd.g_old_rec.business_group_id;

Line 346: ben_xrf_shd.g_old_rec.business_group_id;

342: ben_xrf_shd.g_old_rec.ext_file_id;
343: End If;
344: If (p_rec.business_group_id = hr_api.g_number) then
345: p_rec.business_group_id :=
346: ben_xrf_shd.g_old_rec.business_group_id;
347: End If;
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: ben_xrf_shd.g_old_rec.legislation_code;

Line 350: ben_xrf_shd.g_old_rec.legislation_code;

346: ben_xrf_shd.g_old_rec.business_group_id;
347: End If;
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: ben_xrf_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
353: p_rec.any_or_all_cd :=
354: ben_xrf_shd.g_old_rec.any_or_all_cd;

Line 354: ben_xrf_shd.g_old_rec.any_or_all_cd;

350: ben_xrf_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.any_or_all_cd = hr_api.g_varchar2) then
353: p_rec.any_or_all_cd :=
354: ben_xrf_shd.g_old_rec.any_or_all_cd;
355: End If;
356: If (p_rec.hide_flag = hr_api.g_varchar2) then
357: p_rec.hide_flag :=
358: ben_xrf_shd.g_old_rec.hide_flag;

Line 358: ben_xrf_shd.g_old_rec.hide_flag;

354: ben_xrf_shd.g_old_rec.any_or_all_cd;
355: End If;
356: If (p_rec.hide_flag = hr_api.g_varchar2) then
357: p_rec.hide_flag :=
358: ben_xrf_shd.g_old_rec.hide_flag;
359: End If;
360: If (p_rec.rqd_flag = hr_api.g_varchar2) then
361: p_rec.rqd_flag :=
362: ben_xrf_shd.g_old_rec.rqd_flag;

Line 362: ben_xrf_shd.g_old_rec.rqd_flag;

358: ben_xrf_shd.g_old_rec.hide_flag;
359: End If;
360: If (p_rec.rqd_flag = hr_api.g_varchar2) then
361: p_rec.rqd_flag :=
362: ben_xrf_shd.g_old_rec.rqd_flag;
363: End If;
364: --
365: If (p_rec.chg_rcd_upd_flag = hr_api.g_varchar2) then
366: p_rec.chg_rcd_upd_flag :=

Line 367: ben_xrf_shd.g_old_rec.chg_rcd_upd_flag;

363: End If;
364: --
365: If (p_rec.chg_rcd_upd_flag = hr_api.g_varchar2) then
366: p_rec.chg_rcd_upd_flag :=
367: ben_xrf_shd.g_old_rec.chg_rcd_upd_flag;
368: End If;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: --

Line 380: p_rec in out nocopy ben_xrf_shd.g_rec_type

376: -- ----------------------------------------------------------------------------
377: Procedure upd
378: (
379: p_effective_date in date,
380: p_rec in out nocopy ben_xrf_shd.g_rec_type
381: ) is
382: --
383: l_proc varchar2(72) := g_package||'upd';
384: --

Line 390: ben_xrf_shd.lck

386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- We must lock the row which we need to update.
389: --
390: ben_xrf_shd.lck
391: (
392: p_rec.ext_rcd_in_file_id,
393: p_rec.object_version_number
394: );

Line 449: l_rec ben_xrf_shd.g_rec_type;

445: p_rqd_flag in varchar2 default hr_api.g_varchar2,
446: p_chg_rcd_upd_flag in varchar2 default hr_api.g_varchar2
447: ) is
448: --
449: l_rec ben_xrf_shd.g_rec_type;
450: l_proc varchar2(72) := g_package||'upd';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);

Line 459: ben_xrf_shd.convert_args

455: -- Call conversion function to turn arguments into the
456: -- l_rec structure.
457: --
458: l_rec :=
459: ben_xrf_shd.convert_args
460: (
461: p_ext_rcd_in_file_id,
462: p_seq_num,
463: p_sprs_cd,