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.PER_VAC_INS dependencies on PER_VAC_SHD

Line 76: (p_rec in out nocopy per_vac_shd.g_rec_type

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

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

Line 196: per_vac_shd.g_api_dml := false; -- Unset the api dml status

192: ,p_rec.assessment_id
193: ,p_rec.object_version_number
194: );
195: --
196: per_vac_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated then

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

198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated then
201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status
203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated

Line 203: per_vac_shd.constraint_error

199: Exception
200: When hr_api.check_integrity_violated then
201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status
203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status

Line 207: per_vac_shd.g_api_dml := false; -- Unset the api dml status

203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated

Line 208: per_vac_shd.constraint_error

204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated
212: per_vac_shd.g_api_dml := false; -- Unset the api dml status

Line 212: per_vac_shd.g_api_dml := false; -- Unset the api dml status

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

Line 213: per_vac_shd.constraint_error

209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated
212: per_vac_shd.g_api_dml := false; -- Unset the api dml status
213: per_vac_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others then
216: per_vac_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;

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

212: per_vac_shd.g_api_dml := false; -- Unset the api dml status
213: per_vac_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others then
216: per_vac_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;
218: End insert_dml;
219: --
220: -- ----------------------------------------------------------------------------

Line 259: (p_rec in out nocopy per_vac_shd.g_rec_type

255: --
256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure pre_insert
259: (p_rec in out nocopy per_vac_shd.g_rec_type
260: ) is
261: --
262: Cursor C_Sel1 is select per_vacancies_s.nextval from sys.dual;
263: --

Line 346: (p_rec in per_vac_shd.g_rec_type

342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure post_insert
346: (p_rec in per_vac_shd.g_rec_type
347: ,p_effective_date in date
348: ) is
349: --
350: l_proc varchar2(72) := g_package||'post_insert';

Line 480: (p_rec in out nocopy per_vac_shd.g_rec_type

476: -- ----------------------------------------------------------------------------
477: -- |---------------------------------< ins >----------------------------------|
478: -- ----------------------------------------------------------------------------
479: Procedure ins
480: (p_rec in out nocopy per_vac_shd.g_rec_type
481: ,p_effective_date in date
482: ,p_inv_pos_grade_warning out nocopy boolean
483: ,p_inv_job_grade_warning out nocopy boolean
484: ) is

Line 579: l_rec per_vac_shd.g_rec_type;

575: ,p_vacancy_id out nocopy number
576: ,p_object_version_number out nocopy number
577: ) is
578: --
579: l_rec per_vac_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: per_vac_shd.convert_args

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