DBA Data[Home] [Help]

APPS.BEN_BBP_UPD dependencies on BEN_BBP_SHD

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

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

Line 80: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status

76: business_group_id = p_rec.business_group_id,
77: object_version_number = p_rec.object_version_number
78: where batch_parameter_id = p_rec.batch_parameter_id;
79: --
80: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception

Line 87: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status

83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
88: ben_bbp_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated

Line 88: ben_bbp_shd.constraint_error

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

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

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

Line 93: ben_bbp_shd.constraint_error

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

Line 97: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 98: ben_bbp_shd.constraint_error

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

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

97: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bbp_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End update_dml;
104: --
105: -- ----------------------------------------------------------------------------

Line 137: Procedure pre_update(p_rec in ben_bbp_shd.g_rec_type) is

133: -- Internal Row Handler Use Only.
134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update(p_rec in ben_bbp_shd.g_rec_type) is
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin

Line 180: p_rec in ben_bbp_shd.g_rec_type) is

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure post_update(p_effective_date in date,
180: p_rec in ben_bbp_shd.g_rec_type) is
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin

Line 201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd

197: ,p_chunk_size =>p_rec.chunk_size
198: ,p_business_group_id =>p_rec.business_group_id
199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_effective_date =>p_effective_date
201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd
202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id

Line 202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num

198: ,p_business_group_id =>p_rec.business_group_id
199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_effective_date =>p_effective_date
201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd
202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id
206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);

Line 203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num

199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_effective_date =>p_effective_date
201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd
202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id
206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);
207: --

Line 204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size

200: ,p_effective_date =>p_effective_date
201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd
202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id
206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);
207: --
208: exception

Line 205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id

201: ,p_batch_exe_cd_o =>ben_bbp_shd.g_old_rec.batch_exe_cd
202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id
206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);
207: --
208: exception
209: --

Line 206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);

202: ,p_thread_cnt_num_o =>ben_bbp_shd.g_old_rec.thread_cnt_num
203: ,p_max_err_num_o =>ben_bbp_shd.g_old_rec.max_err_num
204: ,p_chunk_size_o =>ben_bbp_shd.g_old_rec.chunk_size
205: ,p_business_group_id_o =>ben_bbp_shd.g_old_rec.business_group_id
206: ,p_object_version_number_o =>ben_bbp_shd.g_old_rec.object_version_number);
207: --
208: exception
209: --
210: when hr_api.cannot_find_prog_unit then

Line 267: Procedure convert_defs(p_rec in out nocopy ben_bbp_shd.g_rec_type) is

263: -- Internal Row Handler Use Only.
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure convert_defs(p_rec in out nocopy ben_bbp_shd.g_rec_type) is
268: --
269: l_proc varchar2(72) := g_package||'convert_defs';
270: --
271: Begin

Line 282: ben_bbp_shd.g_old_rec.batch_exe_cd;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.batch_exe_cd = hr_api.g_varchar2) then
281: p_rec.batch_exe_cd :=
282: ben_bbp_shd.g_old_rec.batch_exe_cd;
283: End If;
284: If (p_rec.thread_cnt_num = hr_api.g_number) then
285: p_rec.thread_cnt_num :=
286: ben_bbp_shd.g_old_rec.thread_cnt_num;

Line 286: ben_bbp_shd.g_old_rec.thread_cnt_num;

282: ben_bbp_shd.g_old_rec.batch_exe_cd;
283: End If;
284: If (p_rec.thread_cnt_num = hr_api.g_number) then
285: p_rec.thread_cnt_num :=
286: ben_bbp_shd.g_old_rec.thread_cnt_num;
287: End If;
288: If (p_rec.max_err_num = hr_api.g_number) then
289: p_rec.max_err_num :=
290: ben_bbp_shd.g_old_rec.max_err_num;

Line 290: ben_bbp_shd.g_old_rec.max_err_num;

286: ben_bbp_shd.g_old_rec.thread_cnt_num;
287: End If;
288: If (p_rec.max_err_num = hr_api.g_number) then
289: p_rec.max_err_num :=
290: ben_bbp_shd.g_old_rec.max_err_num;
291: End If;
292: If (p_rec.chunk_size = hr_api.g_number) then
293: p_rec.chunk_size :=
294: ben_bbp_shd.g_old_rec.chunk_size;

Line 294: ben_bbp_shd.g_old_rec.chunk_size;

290: ben_bbp_shd.g_old_rec.max_err_num;
291: End If;
292: If (p_rec.chunk_size = hr_api.g_number) then
293: p_rec.chunk_size :=
294: ben_bbp_shd.g_old_rec.chunk_size;
295: End If;
296: If (p_rec.business_group_id = hr_api.g_number) then
297: p_rec.business_group_id :=
298: ben_bbp_shd.g_old_rec.business_group_id;

Line 298: ben_bbp_shd.g_old_rec.business_group_id;

294: ben_bbp_shd.g_old_rec.chunk_size;
295: End If;
296: If (p_rec.business_group_id = hr_api.g_number) then
297: p_rec.business_group_id :=
298: ben_bbp_shd.g_old_rec.business_group_id;
299: End If;
300:
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 312: p_rec in out nocopy ben_bbp_shd.g_rec_type

308: -- ----------------------------------------------------------------------------
309: Procedure upd
310: (
311: p_effective_date in date,
312: p_rec in out nocopy ben_bbp_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'upd';
316: --

Line 322: ben_bbp_shd.lck

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: ben_bbp_shd.lck
323: (
324: p_rec.batch_parameter_id,
325: p_rec.object_version_number
326: );

Line 365: l_rec ben_bbp_shd.g_rec_type;

361: p_business_group_id in number default hr_api.g_number,
362: p_object_version_number in out nocopy number
363: ) is
364: --
365: l_rec ben_bbp_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: ben_bbp_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: ben_bbp_shd.convert_args
376: (
377: p_batch_parameter_id,
378: p_batch_exe_cd,
379: p_thread_cnt_num,