APPS.PQP_SHP_INS dependencies on PQP_SHP_SHD

Line 54: (p_rec in out nocopy pqp_shp_shd.g_rec_type

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

Line 63: pqp_shp_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: pqp_shp_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: pqp_service_history_periods
66: --
67: insert into pqp_service_history_periods

Line 186: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

182: ,p_rec.shp_information19
183: ,p_rec.shp_information20
184: );
185: --
186: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then

Line 192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated

Line 193: pqp_shp_shd.constraint_error

189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

Line 197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated

Line 198: pqp_shp_shd.constraint_error

194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

Line 202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

Line 203: pqp_shp_shd.constraint_error

199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
207: Raise;

Line 206: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
207: Raise;
208: End insert_dml;
209: --
210: -- ----------------------------------------------------------------------------

Line 248: (p_rec in out nocopy pqp_shp_shd.g_rec_type

244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure pre_insert
248: (p_rec in out nocopy pqp_shp_shd.g_rec_type
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'pre_insert';
252: --

Line 302: p_rec in pqp_shp_shd.g_rec_type

298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Procedure post_insert
301: (
302: p_rec in pqp_shp_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'post_insert';
306: --

Line 447: p_rec in out nocopy pqp_shp_shd.g_rec_type

443: -- |---------------------------------< ins >----------------------------------|
444: -- ----------------------------------------------------------------------------
445: Procedure ins
446: (
447: p_rec in out nocopy pqp_shp_shd.g_rec_type
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'ins';
451: --

Line 543: l_rec pqp_shp_shd.g_rec_type;

539: ,p_service_history_period_id out nocopy number
540: ,p_object_version_number out nocopy number
541: ) is
542: --
543: l_rec pqp_shp_shd.g_rec_type;
544: l_proc varchar2(72) := g_package||'ins';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);

Line 553: pqp_shp_shd.convert_args

549: -- Call conversion function to turn arguments into the
550: -- p_rec structure.
551: --
552: l_rec :=
553: pqp_shp_shd.convert_args
554: (null
555: ,p_business_group_id
556: ,p_assignment_id
557: ,p_start_date