DBA Data[Home] [Help]

APPS.BEN_BBP_INS dependencies on BEN_BBP_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ben_bbp_shd.g_rec_type) is

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

Line 61: ben_bbp_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ben_bbp_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ben_batch_parameter
64: --
65: insert into ben_batch_parameter

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

80: p_rec.business_group_id,
81: p_rec.object_version_number
82: );
83: --
84: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then

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

86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: ben_bbp_shd.g_api_dml := false; -- Unset the api dml status
91: ben_bbp_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated

Line 91: ben_bbp_shd.constraint_error

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

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

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

Line 96: ben_bbp_shd.constraint_error

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

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

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

Line 101: ben_bbp_shd.constraint_error

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

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

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

Line 145: Procedure pre_insert(p_rec in out nocopy ben_bbp_shd.g_rec_type) is

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

Line 195: p_rec in ben_bbp_shd.g_rec_type) is

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

Line 238: p_rec in out nocopy ben_bbp_shd.g_rec_type) is

234: -- |---------------------------------< ins >----------------------------------|
235: -- ----------------------------------------------------------------------------
236: Procedure ins
237: (p_effective_date in date,
238: p_rec in out nocopy ben_bbp_shd.g_rec_type) is
239: --
240: l_proc varchar2(72) := g_package||'ins';
241: --
242: Begin

Line 277: l_rec ben_bbp_shd.g_rec_type;

273: p_business_group_id in number,
274: p_object_version_number out nocopy number
275: ) is
276: --
277: l_rec ben_bbp_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'ins';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);

Line 287: ben_bbp_shd.convert_args

283: -- Call conversion function to turn arguments into the
284: -- p_rec structure.
285: --
286: l_rec :=
287: ben_bbp_shd.convert_args
288: (
289: null,
290: p_batch_exe_cd,
291: p_thread_cnt_num,