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_SUC_INS dependencies on PER_SUC_SHD

Line 90: Procedure insert_dml(p_rec in out nocopy per_suc_shd.g_rec_type) is

86: -- Internal Row Handler Use Only.
87: --
88: -- {End Of Comments}
89: -- ----------------------------------------------------------------------------
90: Procedure insert_dml(p_rec in out nocopy per_suc_shd.g_rec_type) is
91: --
92: l_proc varchar2(72) := g_package||'insert_dml';
93: --
94: Begin

Line 98: per_suc_shd.g_api_dml := true; -- Set the api dml status

94: Begin
95: hr_utility.set_location('Entering:'||l_proc, 5);
96: p_rec.object_version_number := 1; -- Initialise the object version
97: --
98: per_suc_shd.g_api_dml := true; -- Set the api dml status
99: --
100: -- Insert the row into: per_succession_planning
101: --
102: insert into per_succession_planning

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

169: p_rec.job_id,
170: p_rec.successee_person_id
171: );
172: --
173: per_suc_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_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status
180: per_suc_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_suc_shd.constraint_error

176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_suc_shd.g_api_dml := false; -- Unset the api dml status
180: per_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status

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

180: per_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_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_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status

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

185: per_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_suc_shd.g_api_dml := false; -- Unset the api dml status

Line 190: per_suc_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_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_suc_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;

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

189: per_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_suc_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_suc_shd.g_rec_type) is

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

Line 292: Procedure post_insert(p_rec in per_suc_shd.g_rec_type,

288: -- Internal Row Handler Use Only.
289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_insert(p_rec in per_suc_shd.g_rec_type,
293: p_effective_date in date) is
294: --
295: l_proc varchar2(72) := g_package||'post_insert';
296: --

Line 358: p_rec in out nocopy per_suc_shd.g_rec_type,

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

Line 425: l_rec per_suc_shd.g_rec_type;

421: p_job_id in number default null,
422: p_successee_person_id in number default null
423: ) is
424: --
425: l_rec per_suc_shd.g_rec_type;
426: l_proc varchar2(72) := g_package||'ins';
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 5);

Line 435: per_suc_shd.convert_args

431: -- Call conversion function to turn arguments into the
432: -- p_rec structure.
433: --
434: l_rec :=
435: per_suc_shd.convert_args
436: (
437: null,
438: p_person_id,
439: p_position_id,