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 93: PROCEDURE insert_dml (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)

89: -- Internal Row Handler Use Only.
90: --
91: -- {End Of Comments}
92: -- ----------------------------------------------------------------------------
93: PROCEDURE insert_dml (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)
94: IS
95: --
96: l_proc VARCHAR2 (72) := g_package || 'insert_dml';
97: --

Line 102: per_suc_shd.g_api_dml := TRUE; -- Set the api dml status

98: BEGIN
99: hr_utility.set_location ('Entering:' || l_proc, 5);
100: p_rec.object_version_number := 1; -- Initialise the object version
101: --
102: per_suc_shd.g_api_dml := TRUE; -- Set the api dml status
103:
104: --
105: -- Insert the row into: per_succession_planning
106: --

Line 186: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

182: p_rec.readiness_percentage
183: );
184:
185: --
186: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
187: --
188: hr_utility.set_location (' Leaving:' || l_proc, 10);
189: EXCEPTION
190: WHEN hr_api.check_integrity_violated

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

189: EXCEPTION
190: WHEN hr_api.check_integrity_violated
191: THEN
192: -- A check constraint has been violated
193: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
194: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
195: (SQLERRM));
196: WHEN hr_api.parent_integrity_violated
197: THEN

Line 194: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

190: WHEN hr_api.check_integrity_violated
191: THEN
192: -- A check constraint has been violated
193: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
194: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
195: (SQLERRM));
196: WHEN hr_api.parent_integrity_violated
197: THEN
198: -- Parent integrity has been violated

Line 199: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

195: (SQLERRM));
196: WHEN hr_api.parent_integrity_violated
197: THEN
198: -- Parent integrity has been violated
199: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
200: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
201: (SQLERRM));
202: WHEN hr_api.unique_integrity_violated
203: THEN

Line 200: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

196: WHEN hr_api.parent_integrity_violated
197: THEN
198: -- Parent integrity has been violated
199: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
200: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
201: (SQLERRM));
202: WHEN hr_api.unique_integrity_violated
203: THEN
204: -- Unique integrity has been violated

Line 205: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

201: (SQLERRM));
202: WHEN hr_api.unique_integrity_violated
203: THEN
204: -- Unique integrity has been violated
205: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
206: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
207: (SQLERRM));
208: WHEN OTHERS
209: THEN

Line 206: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

202: WHEN hr_api.unique_integrity_violated
203: THEN
204: -- Unique integrity has been violated
205: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
206: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
207: (SQLERRM));
208: WHEN OTHERS
209: THEN
210: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 210: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

206: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
207: (SQLERRM));
208: WHEN OTHERS
209: THEN
210: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
211: RAISE;
212: END insert_dml;
213:
214: --

Line 252: PROCEDURE pre_insert (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)

248: -- Internal Row Handler Use Only.
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: PROCEDURE pre_insert (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)
253: IS
254: --
255: l_proc VARCHAR2 (72) := g_package || 'pre_insert';
256:

Line 320: PROCEDURE post_insert (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)

316: -- Internal Row Handler Use Only.
317: --
318: -- {End Of Comments}
319: -- ----------------------------------------------------------------------------
320: PROCEDURE post_insert (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)
321: IS
322: --
323: l_proc VARCHAR2 (72) := g_package || 'post_insert';
324: --

Line 389: PROCEDURE ins (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type, p_effective_date IN DATE)

385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------------< ins >----------------------------------|
388: -- ----------------------------------------------------------------------------
389: PROCEDURE ins (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type, p_effective_date IN DATE)
390: IS
391: --
392: l_proc VARCHAR2 (72) := g_package || 'ins';
393: --

Line 460: l_rec per_suc_shd.g_rec_type;

456: p_readiness_percentage IN NUMBER DEFAULT NULL
457: )
458: IS
459: --
460: l_rec per_suc_shd.g_rec_type;
461: l_proc VARCHAR2 (72) := g_package || 'ins';
462: --
463: BEGIN
464: hr_utility.set_location ('Entering:' || l_proc, 5);

Line 470: per_suc_shd.convert_args (NULL,

466: -- Call conversion function to turn arguments into the
467: -- p_rec structure.
468: --
469: l_rec :=
470: per_suc_shd.convert_args (NULL,
471: p_person_id,
472: p_position_id,
473: p_business_group_id,
474: p_start_date,