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_SUB_INS dependencies on PER_SUB_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_sub_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_sub_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

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

Line 173: per_sub_shd.g_api_dml := false; -- Unset the api dml status

169: p_rec.sub_information20
170:
171: );
172: --
173: per_sub_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then

Line 179: per_sub_shd.g_api_dml := false; -- Unset the api dml status

175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
180: per_sub_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated

Line 180: per_sub_shd.constraint_error

176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
180: per_sub_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status

Line 184: per_sub_shd.g_api_dml := false; -- Unset the api dml status

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

Line 185: per_sub_shd.constraint_error

181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_sub_shd.g_api_dml := false; -- Unset the api dml status
185: per_sub_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status

Line 189: per_sub_shd.g_api_dml := false; -- Unset the api dml status

185: per_sub_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_sub_shd.g_api_dml := false; -- Unset the api dml status

Line 190: per_sub_shd.constraint_error

186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_sub_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;

Line 193: per_sub_shd.g_api_dml := false; -- Unset the api dml status

189: per_sub_shd.g_api_dml := false; -- Unset the api dml status
190: per_sub_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_sub_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;
195: End insert_dml;
196: --
197: -- ----------------------------------------------------------------------------

Line 234: Procedure pre_insert(p_rec in out nocopy per_sub_shd.g_rec_type) is

230: -- Internal Table Handler Use Only.
231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure pre_insert(p_rec in out nocopy per_sub_shd.g_rec_type) is
235: --
236: l_proc varchar2(72) := g_package||'pre_insert';
237: --
238: Cursor C_Sel1 is select per_subjects_taken_s.nextval from sys.dual;

Line 285: Procedure post_insert(p_rec in per_sub_shd.g_rec_type,

281: -- Internal Table Handler Use Only.
282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure post_insert(p_rec in per_sub_shd.g_rec_type,
286: p_effective_date in date) is
287: --
288: l_proc varchar2(72) := g_package||'post_insert';
289: --

Line 369: p_rec in out nocopy per_sub_shd.g_rec_type,

365: -- |---------------------------------< ins >----------------------------------|
366: -- ----------------------------------------------------------------------------
367: Procedure ins
368: (
369: p_rec in out nocopy per_sub_shd.g_rec_type,
370: p_effective_date in date,
371: p_validate in boolean default false
372: ) is
373: --

Line 480: l_rec per_sub_shd.g_rec_type;

476: p_effective_date in date,
477: p_validate in boolean default false
478: ) is
479: --
480: l_rec per_sub_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'ins';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);

Line 490: per_sub_shd.convert_args

486: -- Call conversion function to turn arguments into the
487: -- p_rec structure.
488: --
489: l_rec :=
490: per_sub_shd.convert_args
491: (
492: null,
493: p_start_date,
494: p_major,