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.GHR_PDI_INS dependencies on GHR_PDI_SHD

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

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

Line 61: --ghr_pdi_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: --ghr_pdi_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ghr_position_descriptions
64: --
65: insert into ghr_position_descriptions

Line 166: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

162: p_rec.business_group_id,
163: p_rec.object_version_number
164: );
165: --
166: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: Exception
170: When hr_api.check_integrity_violated Then

Line 172: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: Exception
170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
173: ghr_pdi_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated

Line 173: ghr_pdi_shd.constraint_error

169: Exception
170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
173: ghr_pdi_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

Line 177: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

173: ghr_pdi_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
178: ghr_pdi_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated

Line 178: ghr_pdi_shd.constraint_error

174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
178: ghr_pdi_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

Line 182: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

178: ghr_pdi_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
183: ghr_pdi_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

Line 183: ghr_pdi_shd.constraint_error

179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
183: ghr_pdi_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
187: Raise;

Line 186: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

182: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
183: ghr_pdi_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
187: Raise;
188: End insert_dml;
189: --
190: -- ----------------------------------------------------------------------------

Line 227: Procedure pre_insert(p_rec in out nocopy ghr_pdi_shd.g_rec_type) is

223: -- Internal Row Handler Use Only.
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_insert(p_rec in out nocopy ghr_pdi_shd.g_rec_type) is
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';
230: --
231: Cursor C_Sel1 is select ghr_position_descriptions_s.nextval from sys.dual;

Line 278: Procedure post_insert(p_rec in ghr_pdi_shd.g_rec_type) is

274: -- Internal Row Handler Use Only.
275: --
276: -- {End Of Comments}
277: -- ----------------------------------------------------------------------------
278: Procedure post_insert(p_rec in ghr_pdi_shd.g_rec_type) is
279: --
280: l_proc varchar2(72) := g_package||'post_insert';
281: --
282: Begin

Line 357: p_rec in out nocopy ghr_pdi_shd.g_rec_type

353: -- |---------------------------------< ins >----------------------------------|
354: -- ----------------------------------------------------------------------------
355: Procedure ins
356: (
357: p_rec in out nocopy ghr_pdi_shd.g_rec_type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'ins';
361: --

Line 437: l_rec ghr_pdi_shd.g_rec_type;

433: p_business_group_id in number default null,
434: p_object_version_number out nocopy number
435: ) is
436: --
437: l_rec ghr_pdi_shd.g_rec_type;
438: l_proc varchar2(72) := g_package||'ins';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);

Line 447: ghr_pdi_shd.convert_args

443: -- Call conversion function to turn arguments into the
444: -- p_rec structure.
445: --
446: l_rec :=
447: ghr_pdi_shd.convert_args
448: (
449: null,
450: p_routing_group_id,
451: p_date_from,