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_GRD_INS dependencies on PER_GRD_SHD

Line 76: (p_rec in out nocopy per_grd_shd.g_rec_type

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

Line 92: per_grd_shd.g_api_dml := true; -- Set the api dml status

88: hr_utility.trace('name => ' || p_rec.name);
89: hr_utility.trace('short_name => ' || p_rec.short_name);
90: p_rec.object_version_number := 1; -- Initialise the object version
91: --
92: per_grd_shd.g_api_dml := true; -- Set the api dml status
93: --
94: -- Insert the row into: per_grades
95: --
96: insert into per_grades

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

207: ,p_rec.information20
208: ,p_rec.object_version_number
209: );
210: --
211: per_grd_shd.g_api_dml := false; -- Unset the api dml status
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: Exception
215: When hr_api.check_integrity_violated Then

Line 218: per_grd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 219: per_grd_shd.constraint_error

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

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

220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 225: per_grd_shd.constraint_error

221: When hr_api.parent_integrity_violated Then
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated

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

226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 231: per_grd_shd.constraint_error

227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: hr_utility.set_location(' Leaving:'||l_proc, 50);
235: per_grd_shd.g_api_dml := false; -- Unset the api dml status

Line 235: per_grd_shd.g_api_dml := false; -- Unset the api dml status

231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: hr_utility.set_location(' Leaving:'||l_proc, 50);
235: per_grd_shd.g_api_dml := false; -- Unset the api dml status
236: Raise;
237: End insert_dml;
238: --
239: -- ----------------------------------------------------------------------------

Line 277: (p_rec in out nocopy per_grd_shd.g_rec_type

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

Line 367: ,p_rec in per_grd_shd.g_rec_type

363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure post_insert
366: (p_effective_date in date
367: ,p_rec in per_grd_shd.g_rec_type
368: ) is
369: --
370: l_proc varchar2(72) := g_package||'post_insert';
371: --

Line 508: ,p_rec in out nocopy per_grd_shd.g_rec_type

504: -- |---------------------------------< ins >----------------------------------|
505: -- ----------------------------------------------------------------------------
506: Procedure ins
507: (p_effective_date in date
508: ,p_rec in out nocopy per_grd_shd.g_rec_type
509: ) is
510: --
511: l_proc varchar2(72) := g_package||'ins';
512: --

Line 609: l_rec per_grd_shd.g_rec_type;

605: ,p_grade_id out nocopy number
606: ,p_object_version_number out nocopy number
607: ) is
608: --
609: l_rec per_grd_shd.g_rec_type;
610: l_proc varchar2(72) := g_package||'ins';
611: --
612: Begin
613: hr_utility.set_location('Entering:'||l_proc, 5);

Line 619: per_grd_shd.convert_args

615: -- Call conversion function to turn arguments into the
616: -- p_rec structure.
617: --
618: l_rec :=
619: per_grd_shd.convert_args
620: (null
621: ,p_business_group_id
622: ,p_grade_definition_id
623: ,p_date_from