APPS.PER_SPH_INS dependencies on PER_SPH_SHD

Line 76: (p_rec in out nocopy per_sph_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_sph_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: per_sph_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_sph_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_sp_plan
88: --
89: insert into per_sp_plan

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

164: ,p_rec.attribute20
165: ,p_rec.object_version_number
166: );
167: --
168: per_sph_shd.g_api_dml := false; -- Unset the api dml status
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then

Line 174: per_sph_shd.g_api_dml := false; -- Unset the api dml status

170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: per_sph_shd.g_api_dml := false; -- Unset the api dml status
175: per_sph_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated

Line 175: per_sph_shd.constraint_error

171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: per_sph_shd.g_api_dml := false; -- Unset the api dml status
175: per_sph_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.parent_integrity_violated Then
178: -- Parent integrity has been violated
179: per_sph_shd.g_api_dml := false; -- Unset the api dml status

Line 179: per_sph_shd.g_api_dml := false; -- Unset the api dml status

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

Line 180: per_sph_shd.constraint_error

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

Line 184: per_sph_shd.g_api_dml := false; -- Unset the api dml status

180: per_sph_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.unique_integrity_violated Then
183: -- Unique integrity has been violated
184: per_sph_shd.g_api_dml := false; -- Unset the api dml status
185: per_sph_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When Others Then
188: per_sph_shd.g_api_dml := false; -- Unset the api dml status

Line 185: per_sph_shd.constraint_error

181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.unique_integrity_violated Then
183: -- Unique integrity has been violated
184: per_sph_shd.g_api_dml := false; -- Unset the api dml status
185: per_sph_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When Others Then
188: per_sph_shd.g_api_dml := false; -- Unset the api dml status
189: Raise;

Line 188: per_sph_shd.g_api_dml := false; -- Unset the api dml status

184: per_sph_shd.g_api_dml := false; -- Unset the api dml status
185: per_sph_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When Others Then
188: per_sph_shd.g_api_dml := false; -- Unset the api dml status
189: Raise;
190: End insert_dml;
191: --
192: -- ----------------------------------------------------------------------------

Line 230: (p_rec in out nocopy per_sph_shd.g_rec_type

226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: Procedure pre_insert
230: (p_rec in out nocopy per_sph_shd.g_rec_type
231: ) is
232: --
233: Cursor C_Sel1 is select per_sp_plan_s.nextval from sys.dual;
234: --

Line 318: ,p_rec in per_sph_shd.g_rec_type

314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure post_insert
317: (p_effective_date in date
318: ,p_rec in per_sph_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'post_insert';
322: --

Line 423: ,p_rec in out nocopy per_sph_shd.g_rec_type

419: -- |---------------------------------< ins >----------------------------------|
420: -- ----------------------------------------------------------------------------
421: Procedure ins
422: (p_effective_date in date
423: ,p_rec in out nocopy per_sph_shd.g_rec_type
424: ) is
425: --
426: l_proc varchar2(72) := g_package||'ins';
427: --

Line 506: l_rec per_sph_shd.g_rec_type;

502: ,p_plan_id out nocopy number
503: ,p_object_version_number out nocopy number
504: ) is
505: --
506: l_rec per_sph_shd.g_rec_type;
507: l_proc varchar2(72) := g_package||'ins';
508: --
509: Begin
510: hr_utility.set_location('Entering:'||l_proc, 5);

Line 516: per_sph_shd.convert_args

512: -- Call conversion function to turn arguments into the
513: -- p_rec structure.
514: --
515: l_rec :=
516: per_sph_shd.convert_args
517: (null
518: ,p_plan_type
519: ,p_plan_name
520: ,p_successee_id