APPS.PER_SIP_INS dependencies on PER_SIP_SHD

Line 76: (p_rec in out nocopy per_sip_shd.g_rec_type

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

Line 85: per_sip_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_sip_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_sp_successor_in_plan
88: --
89: insert into per_sp_successor_in_plan

Line 208: per_sip_shd.g_api_dml := false; -- Unset the api dml status

204: ,p_rec.contract_id
205: ,p_rec.object_version_number
206: );
207: --
208: per_sip_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: Exception
212: When hr_api.check_integrity_violated Then

Line 214: per_sip_shd.g_api_dml := false; -- Unset the api dml status

210: hr_utility.set_location(' Leaving:'||l_proc, 10);
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: per_sip_shd.g_api_dml := false; -- Unset the api dml status
215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated

Line 215: per_sip_shd.constraint_error

211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: per_sip_shd.g_api_dml := false; -- Unset the api dml status
215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status

Line 219: per_sip_shd.g_api_dml := false; -- Unset the api dml status

215: per_sip_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated

Line 220: per_sip_shd.constraint_error

216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: per_sip_shd.g_api_dml := false; -- Unset the api dml status
220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status

Line 224: per_sip_shd.g_api_dml := false; -- Unset the api dml status

220: per_sip_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: per_sip_shd.g_api_dml := false; -- Unset the api dml status

Line 225: per_sip_shd.constraint_error

221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: per_sip_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;

Line 228: per_sip_shd.g_api_dml := false; -- Unset the api dml status

224: per_sip_shd.g_api_dml := false; -- Unset the api dml status
225: per_sip_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: per_sip_shd.g_api_dml := false; -- Unset the api dml status
229: Raise;
230: End insert_dml;
231: --
232: -- ----------------------------------------------------------------------------

Line 270: (p_rec in out nocopy per_sip_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure pre_insert
270: (p_rec in out nocopy per_sip_shd.g_rec_type
271: ) is
272: --
273: Cursor C_Sel1 is select per_sp_successor_in_plan_s.nextval from sys.dual;
274: --

Line 358: ,p_rec in per_sip_shd.g_rec_type

354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure post_insert
357: (p_effective_date in date
358: ,p_rec in per_sip_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'post_insert';
362: --

Line 503: ,p_rec in out nocopy per_sip_shd.g_rec_type

499: -- |---------------------------------< ins >----------------------------------|
500: -- ----------------------------------------------------------------------------
501: Procedure ins
502: (p_effective_date in date
503: ,p_rec in out nocopy per_sip_shd.g_rec_type
504: ) is
505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --

Line 606: l_rec per_sip_shd.g_rec_type;

602: ,p_successor_in_plan_id out nocopy number
603: ,p_object_version_number out nocopy number
604: ) is
605: --
606: l_rec per_sip_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'ins';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: per_sip_shd.convert_args

612: -- Call conversion function to turn arguments into the
613: -- p_rec structure.
614: --
615: l_rec :=
616: per_sip_shd.convert_args
617: (null
618: ,p_plan_id
619: ,p_successor_id
620: ,p_business_group_id