APPS.BEN_PCP_INS dependencies on BEN_PCP_SHD

Line 54: (p_rec in out nocopy ben_pcp_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ben_pcp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 63: ben_pcp_shd.g_api_dml := true; -- Set the api dml status

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

Line 162: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

158: ,p_rec.pcp_attribute30
159: ,p_rec.object_version_number
160: );
161: --
162: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then

Line 168: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_pcp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated

Line 169: ben_pcp_shd.constraint_error

165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_pcp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 173: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

169: ben_pcp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
174: ben_pcp_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated

Line 174: ben_pcp_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
174: ben_pcp_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 178: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

174: ben_pcp_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pcp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

Line 179: ben_pcp_shd.constraint_error

175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pcp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;

Line 182: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

178: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pcp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: End insert_dml;
185: --
186: -- ----------------------------------------------------------------------------

Line 224: (p_rec in out nocopy ben_pcp_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure pre_insert
224: (p_rec in out nocopy ben_pcp_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'pre_insert';
228: --

Line 277: (p_rec in ben_pcp_shd.g_rec_type

273: --
274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure post_insert
277: (p_rec in ben_pcp_shd.g_rec_type
278: ) is
279: --
280: l_proc varchar2(72) := g_package||'post_insert';
281: --

Line 397: p_rec in out nocopy ben_pcp_shd.g_rec_type) is

393: -- |---------------------------------< ins >----------------------------------|
394: -- ----------------------------------------------------------------------------
395: Procedure ins
396: (p_effective_date in date,
397: p_rec in out nocopy ben_pcp_shd.g_rec_type) is
398: --
399: l_proc varchar2(72) := g_package||'ins';
400: --
401: Begin

Line 479: l_rec ben_pcp_shd.g_rec_type;

475: ,p_pl_pcp_id out nocopy number
476: ,p_object_version_number out nocopy number
477: ) is
478: --
479: l_rec ben_pcp_shd.g_rec_type;
480: l_proc varchar2(72) := g_package||'ins';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);

Line 489: ben_pcp_shd.convert_args

485: -- Call conversion function to turn arguments into the
486: -- p_rec structure.
487: --
488: l_rec :=
489: ben_pcp_shd.convert_args
490: (null
491: ,p_pl_id
492: ,p_business_group_id
493: ,p_pcp_strt_dt_cd