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_EQT_INS dependencies on PER_EQT_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_eqt_shd.g_rec_type) is

49: -- Internal Table Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy per_eqt_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: per_eqt_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: per_eqt_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_qualification_types
64:
65: -- mvankada

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

202: ,p_rec.provider
203: ,p_rec.qa_organization
204: );
205: --
206: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: Exception
210: When hr_api.check_integrity_violated Then

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

208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: Exception
210: When hr_api.check_integrity_violated Then
211: -- A check constraint has been violated
212: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
213: per_eqt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated

Line 213: per_eqt_shd.constraint_error

209: Exception
210: When hr_api.check_integrity_violated Then
211: -- A check constraint has been violated
212: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
213: per_eqt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

Line 217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

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

Line 218: per_eqt_shd.constraint_error

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

Line 222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

218: per_eqt_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

Line 223: per_eqt_shd.constraint_error

219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
227: Raise;

Line 226: per_eqt_shd.g_api_dml := false; -- Unset the api dml status

222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
227: Raise;
228: End insert_dml;
229: --
230: -- ----------------------------------------------------------------------------

Line 267: Procedure pre_insert(p_rec in out nocopy per_eqt_shd.g_rec_type) is

263: -- Internal Table Handler Use Only.
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure pre_insert(p_rec in out nocopy per_eqt_shd.g_rec_type) is
268: --
269: l_proc varchar2(72) := g_package||'pre_insert';
270: --
271: cursor c1 is

Line 322: Procedure post_insert(p_rec in per_eqt_shd.g_rec_type

318: -- ---------------------------------------------------------------------------
319: -- mvankada
320: -- Added Developer DF columns
321:
322: Procedure post_insert(p_rec in per_eqt_shd.g_rec_type
323: ,p_effective_date in date) is
324: --
325: l_proc varchar2(72) := g_package||'post_insert';
326: --

Line 419: p_rec in out nocopy per_eqt_shd.g_rec_type,

415: -- |---------------------------------< ins >----------------------------------|
416: -- ----------------------------------------------------------------------------
417: Procedure ins
418: (
419: p_rec in out nocopy per_eqt_shd.g_rec_type,
420: p_effective_date in date,
421: p_validate in boolean default false
422: ) is
423: --

Line 553: l_rec per_eqt_shd.g_rec_type;

549: ,p_provider in varchar2 default null
550: ,p_qa_organization in varchar2 default null
551: ) is
552: --
553: l_rec per_eqt_shd.g_rec_type;
554: l_proc varchar2(72) := g_package||'ins';
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);

Line 563: per_eqt_shd.convert_args

559: -- Call conversion function to turn arguments into the
560: -- p_rec structure.
561: --
562: l_rec :=
563: per_eqt_shd.convert_args
564: (
565: null,
566: p_name,
567: p_category,