APPS.PQP_PVD_INS dependencies on PQP_PVD_SHD

Line 54: (p_rec in out nocopy pqp_pvd_shd.g_rec_type

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

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

Line 200: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

196: ,p_rec.vhd_information19
197: ,p_rec.vhd_information20
198: );
199: --
200: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 10);
203: Exception
204: When hr_api.check_integrity_violated Then

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

202: hr_utility.set_location(' Leaving:'||l_proc, 10);
203: Exception
204: When hr_api.check_integrity_violated Then
205: -- A check constraint has been violated
206: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
207: pqp_pvd_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.parent_integrity_violated Then
210: -- Parent integrity has been violated

Line 207: pqp_pvd_shd.constraint_error

203: Exception
204: When hr_api.check_integrity_violated Then
205: -- A check constraint has been violated
206: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
207: pqp_pvd_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.parent_integrity_violated Then
210: -- Parent integrity has been violated
211: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

Line 211: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

207: pqp_pvd_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.parent_integrity_violated Then
210: -- Parent integrity has been violated
211: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
212: pqp_pvd_shd.constraint_error
213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated

Line 212: pqp_pvd_shd.constraint_error

208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When hr_api.parent_integrity_violated Then
210: -- Parent integrity has been violated
211: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
212: pqp_pvd_shd.constraint_error
213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated
216: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

Line 216: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

212: pqp_pvd_shd.constraint_error
213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated
216: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
217: pqp_pvd_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When Others Then
220: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

Line 217: pqp_pvd_shd.constraint_error

213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated
216: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
217: pqp_pvd_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When Others Then
220: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
221: Raise;

Line 220: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status

216: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
217: pqp_pvd_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When Others Then
220: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
221: Raise;
222: End insert_dml;
223: --
224: -- ----------------------------------------------------------------------------

Line 262: (p_rec in out nocopy pqp_pvd_shd.g_rec_type

258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure pre_insert
262: (p_rec in out nocopy pqp_pvd_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72) := g_package||'pre_insert';
266: --

Line 316: ,p_rec in pqp_pvd_shd.g_rec_type

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

Line 475: ,p_rec in out nocopy pqp_pvd_shd.g_rec_type

471: -- |---------------------------------< ins >----------------------------------|
472: -- ----------------------------------------------------------------------------
473: Procedure ins
474: (p_effective_date in date
475: ,p_rec in out nocopy pqp_pvd_shd.g_rec_type
476: ) is
477: --
478: l_proc varchar2(72) := g_package||'ins';
479: --

Line 579: l_rec pqp_pvd_shd.g_rec_type;

575: ,p_vehicle_details_id out nocopy number
576: ,p_object_version_number out nocopy number
577: ) is
578: --
579: l_rec pqp_pvd_shd.g_rec_type;
580: l_proc varchar2(72) := g_package||'ins';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);

Line 589: pqp_pvd_shd.convert_args

585: -- Call conversion function to turn arguments into the
586: -- p_rec structure.
587: --
588: l_rec :=
589: pqp_pvd_shd.convert_args
590: (null
591: ,p_vehicle_type
592: ,p_business_group_id
593: ,p_registration_number