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

Line 56: PROCEDURE update_dml (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)

52: -- Internal Row Handler Use Only.
53: --
54: -- {End Of Comments}
55: -- ----------------------------------------------------------------------------
56: PROCEDURE update_dml (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)
57: IS
58: --
59: l_proc VARCHAR2 (72) := g_package || 'update_dml';
60: --

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

64: -- Increment the object version
65: --
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
68: per_suc_shd.g_api_dml := TRUE; -- Set the api dml status
69:
70: --
71: -- Update the per_succession_planning Row
72: --

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

110: readiness_percentage = p_rec.readiness_percentage
111: WHERE succession_plan_id = p_rec.succession_plan_id;
112:
113: --
114: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
115: --
116: hr_utility.set_location (' Leaving:' || l_proc, 10);
117: --
118: EXCEPTION

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

118: EXCEPTION
119: WHEN hr_api.check_integrity_violated
120: THEN
121: -- A check constraint has been violated
122: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
124: (SQLERRM));
125: WHEN hr_api.parent_integrity_violated
126: THEN

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

119: WHEN hr_api.check_integrity_violated
120: THEN
121: -- A check constraint has been violated
122: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
124: (SQLERRM));
125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated

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

124: (SQLERRM));
125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated
128: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
130: (SQLERRM));
131: WHEN hr_api.unique_integrity_violated
132: THEN

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

125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated
128: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
130: (SQLERRM));
131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated

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

130: (SQLERRM));
131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated
134: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
136: (SQLERRM));
137: WHEN OTHERS
138: THEN

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

131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated
134: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
136: (SQLERRM));
137: WHEN OTHERS
138: THEN
139: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

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

135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
136: (SQLERRM));
137: WHEN OTHERS
138: THEN
139: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
140: RAISE;
141: END update_dml;
142:
143: --

Line 176: PROCEDURE pre_update (p_rec IN per_suc_shd.g_rec_type)

172: -- Internal Row Handler Use Only.
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: PROCEDURE pre_update (p_rec IN per_suc_shd.g_rec_type)
177: IS
178: --
179: l_proc VARCHAR2 (72) := g_package || 'pre_update';
180: --

Line 220: PROCEDURE post_update (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)

216: -- Internal Row Handler Use Only.
217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: PROCEDURE post_update (p_rec IN per_suc_shd.g_rec_type, p_effective_date IN DATE)
221: IS
222: --
223: l_proc VARCHAR2 (72) := g_package || 'post_update';
224: --

Line 271: p_person_id_o => per_suc_shd.g_old_rec.person_id,

267: p_person_rank => p_rec.person_rank,
268: p_performance => p_rec.PERFORMANCE,
269: p_plan_status => p_rec.plan_status,
270: p_readiness_percentage => p_rec.readiness_percentage,
271: p_person_id_o => per_suc_shd.g_old_rec.person_id,
272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,

Line 272: p_position_id_o => per_suc_shd.g_old_rec.position_id,

268: p_performance => p_rec.PERFORMANCE,
269: p_plan_status => p_rec.plan_status,
270: p_readiness_percentage => p_rec.readiness_percentage,
271: p_person_id_o => per_suc_shd.g_old_rec.person_id,
272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,

Line 273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,

269: p_plan_status => p_rec.plan_status,
270: p_readiness_percentage => p_rec.readiness_percentage,
271: p_person_id_o => per_suc_shd.g_old_rec.person_id,
272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,

Line 274: p_start_date_o => per_suc_shd.g_old_rec.start_date,

270: p_readiness_percentage => p_rec.readiness_percentage,
271: p_person_id_o => per_suc_shd.g_old_rec.person_id,
272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,

Line 275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,

271: p_person_id_o => per_suc_shd.g_old_rec.person_id,
272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,

Line 276: p_end_date_o => per_suc_shd.g_old_rec.end_date,

272: p_position_id_o => per_suc_shd.g_old_rec.position_id,
273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,

Line 277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,

273: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,

Line 278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,

274: p_start_date_o => per_suc_shd.g_old_rec.start_date,
275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,

Line 279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,

275: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,

Line 280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,

276: p_end_date_o => per_suc_shd.g_old_rec.end_date,
277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,

Line 281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,

277: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,

Line 282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,

278: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,

Line 283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,

279: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,

Line 284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,

280: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,

Line 285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,

281: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,

Line 286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,

282: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,

Line 287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,

283: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,

Line 288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,

284: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,

Line 289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,

285: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,

Line 290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,

286: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,

Line 291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,

287: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,

Line 292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,

288: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,

Line 293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,

289: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,

Line 294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,

290: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,

Line 295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,

291: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,

Line 296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,

292: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,

Line 297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,

293: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,

Line 298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,

294: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,

Line 299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,

295: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,

Line 300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,

296: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,

Line 301: p_job_id_o => per_suc_shd.g_old_rec.job_id,

297: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,

Line 302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,

298: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage

Line 303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,

299: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
307: );

Line 304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,

300: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
307: );
308: EXCEPTION

Line 305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,

301: p_job_id_o => per_suc_shd.g_old_rec.job_id,
302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
307: );
308: EXCEPTION
309: WHEN hr_api.cannot_find_prog_unit

Line 306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage

302: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
303: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
304: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
307: );
308: EXCEPTION
309: WHEN hr_api.cannot_find_prog_unit
310: THEN

Line 367: PROCEDURE convert_defs (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)

363: -- Internal Row Handler Use Only.
364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: PROCEDURE convert_defs (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type)
368: IS
369: --
370: l_proc VARCHAR2 (72) := g_package || 'convert_defs';
371: --

Line 384: p_rec.person_id := per_suc_shd.g_old_rec.person_id;

380: -- is being used then we must set to the 'current' argument value.
381: --
382: IF (p_rec.person_id = hr_api.g_number)
383: THEN
384: p_rec.person_id := per_suc_shd.g_old_rec.person_id;
385: END IF;
386:
387: IF (p_rec.position_id = hr_api.g_number)
388: THEN

Line 389: p_rec.position_id := per_suc_shd.g_old_rec.position_id;

385: END IF;
386:
387: IF (p_rec.position_id = hr_api.g_number)
388: THEN
389: p_rec.position_id := per_suc_shd.g_old_rec.position_id;
390: END IF;
391:
392: IF (p_rec.business_group_id = hr_api.g_number)
393: THEN

Line 394: p_rec.business_group_id := per_suc_shd.g_old_rec.business_group_id;

390: END IF;
391:
392: IF (p_rec.business_group_id = hr_api.g_number)
393: THEN
394: p_rec.business_group_id := per_suc_shd.g_old_rec.business_group_id;
395: END IF;
396:
397: IF (p_rec.start_date = hr_api.g_date)
398: THEN

Line 399: p_rec.start_date := per_suc_shd.g_old_rec.start_date;

395: END IF;
396:
397: IF (p_rec.start_date = hr_api.g_date)
398: THEN
399: p_rec.start_date := per_suc_shd.g_old_rec.start_date;
400: END IF;
401:
402: IF (p_rec.time_scale = hr_api.g_varchar2)
403: THEN

Line 404: p_rec.time_scale := per_suc_shd.g_old_rec.time_scale;

400: END IF;
401:
402: IF (p_rec.time_scale = hr_api.g_varchar2)
403: THEN
404: p_rec.time_scale := per_suc_shd.g_old_rec.time_scale;
405: END IF;
406:
407: IF (p_rec.end_date = hr_api.g_date)
408: THEN

Line 409: p_rec.end_date := per_suc_shd.g_old_rec.end_date;

405: END IF;
406:
407: IF (p_rec.end_date = hr_api.g_date)
408: THEN
409: p_rec.end_date := per_suc_shd.g_old_rec.end_date;
410: END IF;
411:
412: IF (p_rec.available_for_promotion = hr_api.g_varchar2)
413: THEN

Line 414: p_rec.available_for_promotion := per_suc_shd.g_old_rec.available_for_promotion;

410: END IF;
411:
412: IF (p_rec.available_for_promotion = hr_api.g_varchar2)
413: THEN
414: p_rec.available_for_promotion := per_suc_shd.g_old_rec.available_for_promotion;
415: END IF;
416:
417: IF (p_rec.manager_comments = hr_api.g_varchar2)
418: THEN

Line 419: p_rec.manager_comments := per_suc_shd.g_old_rec.manager_comments;

415: END IF;
416:
417: IF (p_rec.manager_comments = hr_api.g_varchar2)
418: THEN
419: p_rec.manager_comments := per_suc_shd.g_old_rec.manager_comments;
420: END IF;
421:
422: IF (p_rec.attribute_category = hr_api.g_varchar2)
423: THEN

Line 424: p_rec.attribute_category := per_suc_shd.g_old_rec.attribute_category;

420: END IF;
421:
422: IF (p_rec.attribute_category = hr_api.g_varchar2)
423: THEN
424: p_rec.attribute_category := per_suc_shd.g_old_rec.attribute_category;
425: END IF;
426:
427: IF (p_rec.attribute1 = hr_api.g_varchar2)
428: THEN

Line 429: p_rec.attribute1 := per_suc_shd.g_old_rec.attribute1;

425: END IF;
426:
427: IF (p_rec.attribute1 = hr_api.g_varchar2)
428: THEN
429: p_rec.attribute1 := per_suc_shd.g_old_rec.attribute1;
430: END IF;
431:
432: IF (p_rec.attribute2 = hr_api.g_varchar2)
433: THEN

Line 434: p_rec.attribute2 := per_suc_shd.g_old_rec.attribute2;

430: END IF;
431:
432: IF (p_rec.attribute2 = hr_api.g_varchar2)
433: THEN
434: p_rec.attribute2 := per_suc_shd.g_old_rec.attribute2;
435: END IF;
436:
437: IF (p_rec.attribute3 = hr_api.g_varchar2)
438: THEN

Line 439: p_rec.attribute3 := per_suc_shd.g_old_rec.attribute3;

435: END IF;
436:
437: IF (p_rec.attribute3 = hr_api.g_varchar2)
438: THEN
439: p_rec.attribute3 := per_suc_shd.g_old_rec.attribute3;
440: END IF;
441:
442: IF (p_rec.attribute4 = hr_api.g_varchar2)
443: THEN

Line 444: p_rec.attribute4 := per_suc_shd.g_old_rec.attribute4;

440: END IF;
441:
442: IF (p_rec.attribute4 = hr_api.g_varchar2)
443: THEN
444: p_rec.attribute4 := per_suc_shd.g_old_rec.attribute4;
445: END IF;
446:
447: IF (p_rec.attribute5 = hr_api.g_varchar2)
448: THEN

Line 449: p_rec.attribute5 := per_suc_shd.g_old_rec.attribute5;

445: END IF;
446:
447: IF (p_rec.attribute5 = hr_api.g_varchar2)
448: THEN
449: p_rec.attribute5 := per_suc_shd.g_old_rec.attribute5;
450: END IF;
451:
452: IF (p_rec.attribute6 = hr_api.g_varchar2)
453: THEN

Line 454: p_rec.attribute6 := per_suc_shd.g_old_rec.attribute6;

450: END IF;
451:
452: IF (p_rec.attribute6 = hr_api.g_varchar2)
453: THEN
454: p_rec.attribute6 := per_suc_shd.g_old_rec.attribute6;
455: END IF;
456:
457: IF (p_rec.attribute7 = hr_api.g_varchar2)
458: THEN

Line 459: p_rec.attribute7 := per_suc_shd.g_old_rec.attribute7;

455: END IF;
456:
457: IF (p_rec.attribute7 = hr_api.g_varchar2)
458: THEN
459: p_rec.attribute7 := per_suc_shd.g_old_rec.attribute7;
460: END IF;
461:
462: IF (p_rec.attribute8 = hr_api.g_varchar2)
463: THEN

Line 464: p_rec.attribute8 := per_suc_shd.g_old_rec.attribute8;

460: END IF;
461:
462: IF (p_rec.attribute8 = hr_api.g_varchar2)
463: THEN
464: p_rec.attribute8 := per_suc_shd.g_old_rec.attribute8;
465: END IF;
466:
467: IF (p_rec.attribute9 = hr_api.g_varchar2)
468: THEN

Line 469: p_rec.attribute9 := per_suc_shd.g_old_rec.attribute9;

465: END IF;
466:
467: IF (p_rec.attribute9 = hr_api.g_varchar2)
468: THEN
469: p_rec.attribute9 := per_suc_shd.g_old_rec.attribute9;
470: END IF;
471:
472: IF (p_rec.attribute10 = hr_api.g_varchar2)
473: THEN

Line 474: p_rec.attribute10 := per_suc_shd.g_old_rec.attribute10;

470: END IF;
471:
472: IF (p_rec.attribute10 = hr_api.g_varchar2)
473: THEN
474: p_rec.attribute10 := per_suc_shd.g_old_rec.attribute10;
475: END IF;
476:
477: IF (p_rec.attribute11 = hr_api.g_varchar2)
478: THEN

Line 479: p_rec.attribute11 := per_suc_shd.g_old_rec.attribute11;

475: END IF;
476:
477: IF (p_rec.attribute11 = hr_api.g_varchar2)
478: THEN
479: p_rec.attribute11 := per_suc_shd.g_old_rec.attribute11;
480: END IF;
481:
482: IF (p_rec.attribute12 = hr_api.g_varchar2)
483: THEN

Line 484: p_rec.attribute12 := per_suc_shd.g_old_rec.attribute12;

480: END IF;
481:
482: IF (p_rec.attribute12 = hr_api.g_varchar2)
483: THEN
484: p_rec.attribute12 := per_suc_shd.g_old_rec.attribute12;
485: END IF;
486:
487: IF (p_rec.attribute13 = hr_api.g_varchar2)
488: THEN

Line 489: p_rec.attribute13 := per_suc_shd.g_old_rec.attribute13;

485: END IF;
486:
487: IF (p_rec.attribute13 = hr_api.g_varchar2)
488: THEN
489: p_rec.attribute13 := per_suc_shd.g_old_rec.attribute13;
490: END IF;
491:
492: IF (p_rec.attribute14 = hr_api.g_varchar2)
493: THEN

Line 494: p_rec.attribute14 := per_suc_shd.g_old_rec.attribute14;

490: END IF;
491:
492: IF (p_rec.attribute14 = hr_api.g_varchar2)
493: THEN
494: p_rec.attribute14 := per_suc_shd.g_old_rec.attribute14;
495: END IF;
496:
497: IF (p_rec.attribute15 = hr_api.g_varchar2)
498: THEN

Line 499: p_rec.attribute15 := per_suc_shd.g_old_rec.attribute15;

495: END IF;
496:
497: IF (p_rec.attribute15 = hr_api.g_varchar2)
498: THEN
499: p_rec.attribute15 := per_suc_shd.g_old_rec.attribute15;
500: END IF;
501:
502: IF (p_rec.attribute16 = hr_api.g_varchar2)
503: THEN

Line 504: p_rec.attribute16 := per_suc_shd.g_old_rec.attribute16;

500: END IF;
501:
502: IF (p_rec.attribute16 = hr_api.g_varchar2)
503: THEN
504: p_rec.attribute16 := per_suc_shd.g_old_rec.attribute16;
505: END IF;
506:
507: IF (p_rec.attribute17 = hr_api.g_varchar2)
508: THEN

Line 509: p_rec.attribute17 := per_suc_shd.g_old_rec.attribute17;

505: END IF;
506:
507: IF (p_rec.attribute17 = hr_api.g_varchar2)
508: THEN
509: p_rec.attribute17 := per_suc_shd.g_old_rec.attribute17;
510: END IF;
511:
512: IF (p_rec.attribute18 = hr_api.g_varchar2)
513: THEN

Line 514: p_rec.attribute18 := per_suc_shd.g_old_rec.attribute18;

510: END IF;
511:
512: IF (p_rec.attribute18 = hr_api.g_varchar2)
513: THEN
514: p_rec.attribute18 := per_suc_shd.g_old_rec.attribute18;
515: END IF;
516:
517: IF (p_rec.attribute19 = hr_api.g_varchar2)
518: THEN

Line 519: p_rec.attribute19 := per_suc_shd.g_old_rec.attribute19;

515: END IF;
516:
517: IF (p_rec.attribute19 = hr_api.g_varchar2)
518: THEN
519: p_rec.attribute19 := per_suc_shd.g_old_rec.attribute19;
520: END IF;
521:
522: IF (p_rec.attribute20 = hr_api.g_varchar2)
523: THEN

Line 524: p_rec.attribute20 := per_suc_shd.g_old_rec.attribute20;

520: END IF;
521:
522: IF (p_rec.attribute20 = hr_api.g_varchar2)
523: THEN
524: p_rec.attribute20 := per_suc_shd.g_old_rec.attribute20;
525: END IF;
526:
527: IF (p_rec.job_id = hr_api.g_number)
528: THEN

Line 529: p_rec.job_id := per_suc_shd.g_old_rec.job_id;

525: END IF;
526:
527: IF (p_rec.job_id = hr_api.g_number)
528: THEN
529: p_rec.job_id := per_suc_shd.g_old_rec.job_id;
530: END IF;
531:
532: IF (p_rec.successee_person_id = hr_api.g_number)
533: THEN

Line 534: p_rec.successee_person_id := per_suc_shd.g_old_rec.successee_person_id;

530: END IF;
531:
532: IF (p_rec.successee_person_id = hr_api.g_number)
533: THEN
534: p_rec.successee_person_id := per_suc_shd.g_old_rec.successee_person_id;
535: END IF;
536:
537: IF (p_rec.person_rank = hr_api.g_number)
538: THEN

Line 539: p_rec.person_rank := per_suc_shd.g_old_rec.person_rank;

535: END IF;
536:
537: IF (p_rec.person_rank = hr_api.g_number)
538: THEN
539: p_rec.person_rank := per_suc_shd.g_old_rec.person_rank;
540: END IF;
541:
542: IF (p_rec.PERFORMANCE = hr_api.g_varchar2)
543: THEN

Line 544: p_rec.PERFORMANCE := per_suc_shd.g_old_rec.PERFORMANCE;

540: END IF;
541:
542: IF (p_rec.PERFORMANCE = hr_api.g_varchar2)
543: THEN
544: p_rec.PERFORMANCE := per_suc_shd.g_old_rec.PERFORMANCE;
545: END IF;
546:
547: IF (p_rec.plan_status = hr_api.g_varchar2)
548: THEN

Line 549: p_rec.plan_status := per_suc_shd.g_old_rec.plan_status;

545: END IF;
546:
547: IF (p_rec.plan_status = hr_api.g_varchar2)
548: THEN
549: p_rec.plan_status := per_suc_shd.g_old_rec.plan_status;
550: END IF;
551:
552: IF (p_rec.readiness_percentage = hr_api.g_number)
553: THEN

Line 554: p_rec.readiness_percentage := per_suc_shd.g_old_rec.readiness_percentage;

550: END IF;
551:
552: IF (p_rec.readiness_percentage = hr_api.g_number)
553: THEN
554: p_rec.readiness_percentage := per_suc_shd.g_old_rec.readiness_percentage;
555: END IF;
556:
557: hr_utility.set_location (' Leaving:' || l_proc, 10);
558: --

Line 565: PROCEDURE upd (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type, p_effective_date IN DATE)

561: --
562: -- ----------------------------------------------------------------------------
563: -- |---------------------------------< upd >----------------------------------|
564: -- ----------------------------------------------------------------------------
565: PROCEDURE upd (p_rec IN OUT NOCOPY per_suc_shd.g_rec_type, p_effective_date IN DATE)
566: IS
567: --
568: l_proc VARCHAR2 (72) := g_package || 'upd';
569: --

Line 575: per_suc_shd.lck (p_rec.succession_plan_id, p_rec.object_version_number);

571: hr_utility.set_location ('Entering:' || l_proc, 5);
572: --
573: -- We must lock the row which we need to update.
574: --
575: per_suc_shd.lck (p_rec.succession_plan_id, p_rec.object_version_number);
576: --
577: -- 1. During an update system defaults are used to determine if
578: -- arguments have been defaulted or not. We must therefore
579: -- derive the full record structure values to be updated.

Line 645: l_rec per_suc_shd.g_rec_type;

641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number
642: )
643: IS
644: --
645: l_rec per_suc_shd.g_rec_type;
646: l_proc VARCHAR2 (72) := g_package || 'upd';
647: --
648: BEGIN
649: hr_utility.set_location ('Entering:' || l_proc, 5);

Line 655: per_suc_shd.convert_args (p_succession_plan_id,

651: -- Call conversion function to turn arguments into the
652: -- l_rec structure.
653: --
654: l_rec :=
655: per_suc_shd.convert_args (p_succession_plan_id,
656: p_person_id,
657: p_position_id,
658: p_business_group_id,
659: p_start_date,