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_XRS_UPD dependencies on BEN_XRS_SHD

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

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

Line 94: ben_xrs_shd.g_api_dml := false; -- Unset the api dml status

90: xdo_template_id = p_rec.xdo_template_id,
91: object_version_number = p_rec.object_version_number
92: where ext_rslt_id = p_rec.ext_rslt_id;
93: --
94: ben_xrs_shd.g_api_dml := false; -- Unset the api dml status
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception

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

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

Line 102: ben_xrs_shd.constraint_error

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

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

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

Line 107: ben_xrs_shd.constraint_error

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

Line 111: ben_xrs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 112: ben_xrs_shd.constraint_error

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

Line 115: ben_xrs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 151: Procedure pre_update(p_rec in ben_xrs_shd.g_rec_type) is

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

Line 194: p_effective_date in date,p_rec in ben_xrs_shd.g_rec_type) is

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

Line 230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt

226: ,p_output_type =>p_rec.output_type
227: ,p_xdo_template_id =>p_rec.xdo_template_id
228: ,p_object_version_number =>p_rec.object_version_number
229: ,p_effective_date =>p_effective_date
230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt
231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num

Line 231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt

227: ,p_xdo_template_id =>p_rec.xdo_template_id
228: ,p_object_version_number =>p_rec.object_version_number
229: ,p_effective_date =>p_effective_date
230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt
231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num

Line 232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd

228: ,p_object_version_number =>p_rec.object_version_number
229: ,p_effective_date =>p_effective_date
230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt
231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt

Line 233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num

229: ,p_effective_date =>p_effective_date
230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt
231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt

Line 234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num

230: ,p_run_strt_dt_o =>ben_xrs_shd.g_old_rec.run_strt_dt
231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt

Line 235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num

231: ,p_run_end_dt_o =>ben_xrs_shd.g_old_rec.run_end_dt
232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name

Line 236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt

232: ,p_ext_stat_cd_o =>ben_xrs_shd.g_old_rec.ext_stat_cd
233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name

Line 237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt

233: ,p_tot_rec_num_o =>ben_xrs_shd.g_old_rec.tot_rec_num
234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id

Line 238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt

234: ,p_tot_per_num_o =>ben_xrs_shd.g_old_rec.tot_per_num
235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id

Line 239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name

235: ,p_tot_err_num_o =>ben_xrs_shd.g_old_rec.tot_err_num
236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id

Line 240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name

236: ,p_eff_dt_o =>ben_xrs_shd.g_old_rec.eff_dt
237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id

Line 241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id

237: ,p_ext_strt_dt_o =>ben_xrs_shd.g_old_rec.ext_strt_dt
238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date

Line 242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id

238: ,p_ext_end_dt_o =>ben_xrs_shd.g_old_rec.ext_end_dt
239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id

Line 243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id

239: ,p_output_name_o =>ben_xrs_shd.g_old_rec.output_name
240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type

Line 244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id

240: ,p_drctry_name_o =>ben_xrs_shd.g_old_rec.drctry_name
241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id

Line 245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date

241: ,p_ext_dfn_id_o =>ben_xrs_shd.g_old_rec.ext_dfn_id
242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id
249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number

Line 246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id

242: ,p_business_group_id_o =>ben_xrs_shd.g_old_rec.business_group_id
243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id
249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number
250: );

Line 247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type

243: ,p_program_application_id_o =>ben_xrs_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id
249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number
250: );
251: --

Line 248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id

244: ,p_program_id_o =>ben_xrs_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id
249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number
250: );
251: --
252: exception

Line 249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number

245: ,p_program_update_date_o =>ben_xrs_shd.g_old_rec.program_update_date
246: ,p_request_id_o =>ben_xrs_shd.g_old_rec.request_id
247: ,p_output_type_o =>ben_xrs_shd.g_old_rec.output_type
248: ,p_xdo_template_id_o =>ben_xrs_shd.g_old_rec.xdo_template_id
249: ,p_object_version_number_o =>ben_xrs_shd.g_old_rec.object_version_number
250: );
251: --
252: exception
253: --

Line 311: Procedure convert_defs(p_rec in out nocopy ben_xrs_shd.g_rec_type) is

307: -- Internal Row Handler Use Only.
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure convert_defs(p_rec in out nocopy ben_xrs_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'convert_defs';
314: --
315: Begin

Line 326: ben_xrs_shd.g_old_rec.run_strt_dt;

322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.run_strt_dt = hr_api.g_date) then
325: p_rec.run_strt_dt :=
326: ben_xrs_shd.g_old_rec.run_strt_dt;
327: End If;
328: If (p_rec.run_end_dt = hr_api.g_date) then
329: p_rec.run_end_dt :=
330: ben_xrs_shd.g_old_rec.run_end_dt;

Line 330: ben_xrs_shd.g_old_rec.run_end_dt;

326: ben_xrs_shd.g_old_rec.run_strt_dt;
327: End If;
328: If (p_rec.run_end_dt = hr_api.g_date) then
329: p_rec.run_end_dt :=
330: ben_xrs_shd.g_old_rec.run_end_dt;
331: End If;
332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then
333: p_rec.ext_stat_cd :=
334: ben_xrs_shd.g_old_rec.ext_stat_cd;

Line 334: ben_xrs_shd.g_old_rec.ext_stat_cd;

330: ben_xrs_shd.g_old_rec.run_end_dt;
331: End If;
332: If (p_rec.ext_stat_cd = hr_api.g_varchar2) then
333: p_rec.ext_stat_cd :=
334: ben_xrs_shd.g_old_rec.ext_stat_cd;
335: End If;
336: If (p_rec.tot_rec_num = hr_api.g_number) then
337: p_rec.tot_rec_num :=
338: ben_xrs_shd.g_old_rec.tot_rec_num;

Line 338: ben_xrs_shd.g_old_rec.tot_rec_num;

334: ben_xrs_shd.g_old_rec.ext_stat_cd;
335: End If;
336: If (p_rec.tot_rec_num = hr_api.g_number) then
337: p_rec.tot_rec_num :=
338: ben_xrs_shd.g_old_rec.tot_rec_num;
339: End If;
340: If (p_rec.tot_per_num = hr_api.g_number) then
341: p_rec.tot_per_num :=
342: ben_xrs_shd.g_old_rec.tot_per_num;

Line 342: ben_xrs_shd.g_old_rec.tot_per_num;

338: ben_xrs_shd.g_old_rec.tot_rec_num;
339: End If;
340: If (p_rec.tot_per_num = hr_api.g_number) then
341: p_rec.tot_per_num :=
342: ben_xrs_shd.g_old_rec.tot_per_num;
343: End If;
344: If (p_rec.tot_err_num = hr_api.g_number) then
345: p_rec.tot_err_num :=
346: ben_xrs_shd.g_old_rec.tot_err_num;

Line 346: ben_xrs_shd.g_old_rec.tot_err_num;

342: ben_xrs_shd.g_old_rec.tot_per_num;
343: End If;
344: If (p_rec.tot_err_num = hr_api.g_number) then
345: p_rec.tot_err_num :=
346: ben_xrs_shd.g_old_rec.tot_err_num;
347: End If;
348: If (p_rec.eff_dt = hr_api.g_date) then
349: p_rec.eff_dt :=
350: ben_xrs_shd.g_old_rec.eff_dt;

Line 350: ben_xrs_shd.g_old_rec.eff_dt;

346: ben_xrs_shd.g_old_rec.tot_err_num;
347: End If;
348: If (p_rec.eff_dt = hr_api.g_date) then
349: p_rec.eff_dt :=
350: ben_xrs_shd.g_old_rec.eff_dt;
351: End If;
352: If (p_rec.ext_strt_dt = hr_api.g_date) then
353: p_rec.ext_strt_dt :=
354: ben_xrs_shd.g_old_rec.ext_strt_dt;

Line 354: ben_xrs_shd.g_old_rec.ext_strt_dt;

350: ben_xrs_shd.g_old_rec.eff_dt;
351: End If;
352: If (p_rec.ext_strt_dt = hr_api.g_date) then
353: p_rec.ext_strt_dt :=
354: ben_xrs_shd.g_old_rec.ext_strt_dt;
355: End If;
356: If (p_rec.ext_end_dt = hr_api.g_date) then
357: p_rec.ext_end_dt :=
358: ben_xrs_shd.g_old_rec.ext_end_dt;

Line 358: ben_xrs_shd.g_old_rec.ext_end_dt;

354: ben_xrs_shd.g_old_rec.ext_strt_dt;
355: End If;
356: If (p_rec.ext_end_dt = hr_api.g_date) then
357: p_rec.ext_end_dt :=
358: ben_xrs_shd.g_old_rec.ext_end_dt;
359: End If;
360: If (p_rec.output_name = hr_api.g_varchar2) then
361: p_rec.output_name :=
362: ben_xrs_shd.g_old_rec.output_name;

Line 362: ben_xrs_shd.g_old_rec.output_name;

358: ben_xrs_shd.g_old_rec.ext_end_dt;
359: End If;
360: If (p_rec.output_name = hr_api.g_varchar2) then
361: p_rec.output_name :=
362: ben_xrs_shd.g_old_rec.output_name;
363: End If;
364: If (p_rec.drctry_name = hr_api.g_varchar2) then
365: p_rec.drctry_name :=
366: ben_xrs_shd.g_old_rec.drctry_name;

Line 366: ben_xrs_shd.g_old_rec.drctry_name;

362: ben_xrs_shd.g_old_rec.output_name;
363: End If;
364: If (p_rec.drctry_name = hr_api.g_varchar2) then
365: p_rec.drctry_name :=
366: ben_xrs_shd.g_old_rec.drctry_name;
367: End If;
368: If (p_rec.ext_dfn_id = hr_api.g_number) then
369: p_rec.ext_dfn_id :=
370: ben_xrs_shd.g_old_rec.ext_dfn_id;

Line 370: ben_xrs_shd.g_old_rec.ext_dfn_id;

366: ben_xrs_shd.g_old_rec.drctry_name;
367: End If;
368: If (p_rec.ext_dfn_id = hr_api.g_number) then
369: p_rec.ext_dfn_id :=
370: ben_xrs_shd.g_old_rec.ext_dfn_id;
371: End If;
372: If (p_rec.business_group_id = hr_api.g_number) then
373: p_rec.business_group_id :=
374: ben_xrs_shd.g_old_rec.business_group_id;

Line 374: ben_xrs_shd.g_old_rec.business_group_id;

370: ben_xrs_shd.g_old_rec.ext_dfn_id;
371: End If;
372: If (p_rec.business_group_id = hr_api.g_number) then
373: p_rec.business_group_id :=
374: ben_xrs_shd.g_old_rec.business_group_id;
375: End If;
376: If (p_rec.program_application_id = hr_api.g_number) then
377: p_rec.program_application_id :=
378: ben_xrs_shd.g_old_rec.program_application_id;

Line 378: ben_xrs_shd.g_old_rec.program_application_id;

374: ben_xrs_shd.g_old_rec.business_group_id;
375: End If;
376: If (p_rec.program_application_id = hr_api.g_number) then
377: p_rec.program_application_id :=
378: ben_xrs_shd.g_old_rec.program_application_id;
379: End If;
380: If (p_rec.program_id = hr_api.g_number) then
381: p_rec.program_id :=
382: ben_xrs_shd.g_old_rec.program_id;

Line 382: ben_xrs_shd.g_old_rec.program_id;

378: ben_xrs_shd.g_old_rec.program_application_id;
379: End If;
380: If (p_rec.program_id = hr_api.g_number) then
381: p_rec.program_id :=
382: ben_xrs_shd.g_old_rec.program_id;
383: End If;
384: If (p_rec.program_update_date = hr_api.g_date) then
385: p_rec.program_update_date :=
386: ben_xrs_shd.g_old_rec.program_update_date;

Line 386: ben_xrs_shd.g_old_rec.program_update_date;

382: ben_xrs_shd.g_old_rec.program_id;
383: End If;
384: If (p_rec.program_update_date = hr_api.g_date) then
385: p_rec.program_update_date :=
386: ben_xrs_shd.g_old_rec.program_update_date;
387: End If;
388: If (p_rec.request_id = hr_api.g_number) then
389: p_rec.request_id :=
390: ben_xrs_shd.g_old_rec.request_id;

Line 390: ben_xrs_shd.g_old_rec.request_id;

386: ben_xrs_shd.g_old_rec.program_update_date;
387: End If;
388: If (p_rec.request_id = hr_api.g_number) then
389: p_rec.request_id :=
390: ben_xrs_shd.g_old_rec.request_id;
391: End If;
392:
393: If (p_rec.output_type = hr_api.g_varchar2) then
394: p_rec.output_type :=

Line 395: ben_xrs_shd.g_old_rec.output_type;

391: End If;
392:
393: If (p_rec.output_type = hr_api.g_varchar2) then
394: p_rec.output_type :=
395: ben_xrs_shd.g_old_rec.output_type;
396: End If;
397:
398:
399: if (p_rec.xdo_template_id = hr_api.g_number) then

Line 401: ben_xrs_shd.g_old_rec.xdo_template_id;

397:
398:
399: if (p_rec.xdo_template_id = hr_api.g_number) then
400: p_rec.xdo_template_id :=
401: ben_xrs_shd.g_old_rec.xdo_template_id;
402: End If;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: --

Line 414: p_rec in out nocopy ben_xrs_shd.g_rec_type

410: -- ----------------------------------------------------------------------------
411: Procedure upd
412: (
413: p_effective_date in date,
414: p_rec in out nocopy ben_xrs_shd.g_rec_type
415: ) is
416: --
417: l_proc varchar2(72) := g_package||'upd';
418: --

Line 424: ben_xrs_shd.lck

420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- We must lock the row which we need to update.
423: --
424: ben_xrs_shd.lck
425: (
426: p_rec.ext_rslt_id,
427: p_rec.object_version_number
428: );

Line 483: l_rec ben_xrs_shd.g_rec_type;

479: p_xdo_template_id in number default hr_api.g_number,
480: p_object_version_number in out nocopy number
481: ) is
482: --
483: l_rec ben_xrs_shd.g_rec_type;
484: l_proc varchar2(72) := g_package||'upd';
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);

Line 493: ben_xrs_shd.convert_args

489: -- Call conversion function to turn arguments into the
490: -- l_rec structure.
491: --
492: l_rec :=
493: ben_xrs_shd.convert_args
494: (
495: p_ext_rslt_id,
496: p_run_strt_dt,
497: p_run_end_dt,