eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VRI_INS dependencies on PQP_VRI_SHD

Line 76: (p_rec in out nocopy pqp_vri_shd.g_rec_type

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

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

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

210: ,p_rec.program_id
211: ,p_rec.program_update_date
212: );
213: --
214: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: Exception
218: When hr_api.check_integrity_violated Then

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

216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
221: pqp_vri_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated

Line 221: pqp_vri_shd.constraint_error

217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
221: pqp_vri_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status

Line 225: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status

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

Line 226: pqp_vri_shd.constraint_error

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

Line 230: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status

226: pqp_vri_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
231: pqp_vri_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status

Line 231: pqp_vri_shd.constraint_error

227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
231: pqp_vri_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
235: Raise;

Line 234: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status

230: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
231: pqp_vri_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: pqp_vri_shd.g_api_dml := false; -- Unset the api dml status
235: Raise;
236: End insert_dml;
237: --
238: -- ----------------------------------------------------------------------------

Line 276: (p_rec in out nocopy pqp_vri_shd.g_rec_type

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure pre_insert
276: (p_rec in out nocopy pqp_vri_shd.g_rec_type
277: ) is
278: --
279: Cursor C_Sel1 is select pqp_veh_repos_extra_info_s.nextval from sys.dual;
280: --

Line 363: (p_rec in pqp_vri_shd.g_rec_type

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure post_insert
363: (p_rec in pqp_vri_shd.g_rec_type
364: ) is
365: --
366: l_proc varchar2(72) := g_package||'post_insert';
367: --

Line 512: (p_rec in out nocopy pqp_vri_shd.g_rec_type

508: -- ----------------------------------------------------------------------------
509: -- |---------------------------------< ins >----------------------------------|
510: -- ----------------------------------------------------------------------------
511: Procedure ins
512: (p_rec in out nocopy pqp_vri_shd.g_rec_type
513: ) is
514: --
515: l_proc varchar2(72) := g_package||'ins';
516: --

Line 615: l_rec pqp_vri_shd.g_rec_type;

611: ,p_veh_repos_extra_info_id out nocopy number
612: ,p_object_version_number out nocopy number
613: ) is
614: --
615: l_rec pqp_vri_shd.g_rec_type;
616: l_proc varchar2(72) := g_package||'ins';
617: --
618: Begin
619: hr_utility.set_location('Entering:'||l_proc, 5);

Line 625: pqp_vri_shd.convert_args

621: -- Call conversion function to turn arguments into the
622: -- p_rec structure.
623: --
624: l_rec :=
625: pqp_vri_shd.convert_args
626: (null
627: ,p_vehicle_repository_id
628: ,p_information_type
629: ,p_vrei_attribute_category