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

Line 53: PROCEDURE delete_dml (p_rec IN per_suc_shd.g_rec_type)

49: -- Internal Row Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: PROCEDURE delete_dml (p_rec IN per_suc_shd.g_rec_type)
54: IS
55: --
56: l_proc VARCHAR2 (72) := g_package || 'delete_dml';
57: --

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

57: --
58: BEGIN
59: hr_utility.set_location ('Entering:' || l_proc, 5);
60: --
61: per_suc_shd.g_api_dml := TRUE; -- Set the api dml status
62:
63: --
64: -- Delete the per_succession_planning row.
65: --

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

66: DELETE FROM per_succession_planning
67: WHERE succession_plan_id = p_rec.succession_plan_id;
68:
69: --
70: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
71: --
72: hr_utility.set_location (' Leaving:' || l_proc, 10);
73: --
74: EXCEPTION

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

74: EXCEPTION
75: WHEN hr_api.child_integrity_violated
76: THEN
77: -- Child integrity has been violated
78: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
79: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
80: (SQLERRM));
81: WHEN OTHERS
82: THEN

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

75: WHEN hr_api.child_integrity_violated
76: THEN
77: -- Child integrity has been violated
78: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
79: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
80: (SQLERRM));
81: WHEN OTHERS
82: THEN
83: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

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

79: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
80: (SQLERRM));
81: WHEN OTHERS
82: THEN
83: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
84: RAISE;
85: END delete_dml;
86:
87: --

Line 120: PROCEDURE pre_delete (p_rec IN per_suc_shd.g_rec_type)

116: -- Internal Row Handler Use Only.
117: --
118: -- {End Of Comments}
119: -- ----------------------------------------------------------------------------
120: PROCEDURE pre_delete (p_rec IN per_suc_shd.g_rec_type)
121: IS
122: --
123: l_proc VARCHAR2 (72) := g_package || 'pre_delete';
124: --

Line 164: PROCEDURE post_delete (p_rec IN per_suc_shd.g_rec_type)

160: -- Internal table Handler Use Only.
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: PROCEDURE post_delete (p_rec IN per_suc_shd.g_rec_type)
165: IS
166: --
167: l_proc VARCHAR2 (72) := g_package || 'post_delete';
168: --

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

174: --
175: BEGIN
176: per_suc_rkd.after_delete
177: (p_succession_plan_id => p_rec.succession_plan_id,
178: p_person_id_o => per_suc_shd.g_old_rec.person_id,
179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,

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

175: BEGIN
176: per_suc_rkd.after_delete
177: (p_succession_plan_id => p_rec.succession_plan_id,
178: p_person_id_o => per_suc_shd.g_old_rec.person_id,
179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,

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

176: per_suc_rkd.after_delete
177: (p_succession_plan_id => p_rec.succession_plan_id,
178: p_person_id_o => per_suc_shd.g_old_rec.person_id,
179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,

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

177: (p_succession_plan_id => p_rec.succession_plan_id,
178: p_person_id_o => per_suc_shd.g_old_rec.person_id,
179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,

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

178: p_person_id_o => per_suc_shd.g_old_rec.person_id,
179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,

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

179: p_position_id_o => per_suc_shd.g_old_rec.position_id,
180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,

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

180: p_business_group_id_o => per_suc_shd.g_old_rec.business_group_id,
181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,

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

181: p_start_date_o => per_suc_shd.g_old_rec.start_date,
182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,

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

182: p_time_scale_o => per_suc_shd.g_old_rec.time_scale,
183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,

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

183: p_end_date_o => per_suc_shd.g_old_rec.end_date,
184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,

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

184: p_available_for_promotion_o => per_suc_shd.g_old_rec.available_for_promotion,
185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,

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

185: p_manager_comments_o => per_suc_shd.g_old_rec.manager_comments,
186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,

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

186: p_object_version_number_o => per_suc_shd.g_old_rec.object_version_number,
187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,

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

187: p_attribute_category_o => per_suc_shd.g_old_rec.attribute_category,
188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,

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

188: p_attribute1_o => per_suc_shd.g_old_rec.attribute1,
189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,

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

189: p_attribute2_o => per_suc_shd.g_old_rec.attribute2,
190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,

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

190: p_attribute3_o => per_suc_shd.g_old_rec.attribute3,
191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,

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

191: p_attribute4_o => per_suc_shd.g_old_rec.attribute4,
192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,

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

192: p_attribute5_o => per_suc_shd.g_old_rec.attribute5,
193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,

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

193: p_attribute6_o => per_suc_shd.g_old_rec.attribute6,
194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,

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

194: p_attribute7_o => per_suc_shd.g_old_rec.attribute7,
195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,

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

195: p_attribute8_o => per_suc_shd.g_old_rec.attribute8,
196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,

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

196: p_attribute9_o => per_suc_shd.g_old_rec.attribute9,
197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,

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

197: p_attribute10_o => per_suc_shd.g_old_rec.attribute10,
198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,

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

198: p_attribute11_o => per_suc_shd.g_old_rec.attribute11,
199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,

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

199: p_attribute12_o => per_suc_shd.g_old_rec.attribute12,
200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,

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

200: p_attribute13_o => per_suc_shd.g_old_rec.attribute13,
201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,

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

201: p_attribute14_o => per_suc_shd.g_old_rec.attribute14,
202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,

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

202: p_attribute15_o => per_suc_shd.g_old_rec.attribute15,
203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,

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

203: p_attribute16_o => per_suc_shd.g_old_rec.attribute16,
204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,

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

204: p_attribute17_o => per_suc_shd.g_old_rec.attribute17,
205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,

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

205: p_attribute18_o => per_suc_shd.g_old_rec.attribute18,
206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage

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

206: p_attribute19_o => per_suc_shd.g_old_rec.attribute19,
207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
214: );

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

207: p_attribute20_o => per_suc_shd.g_old_rec.attribute20,
208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
214: );
215: EXCEPTION

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

208: p_job_id_o => per_suc_shd.g_old_rec.job_id,
209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
214: );
215: EXCEPTION
216: WHEN hr_api.cannot_find_prog_unit

Line 213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage

209: p_successee_person_id_o => per_suc_shd.g_old_rec.successee_person_id,
210: p_person_rank_o => per_suc_shd.g_old_rec.person_rank,
211: p_performance_o => per_suc_shd.g_old_rec.PERFORMANCE,
212: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
213: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
214: );
215: EXCEPTION
216: WHEN hr_api.cannot_find_prog_unit
217: THEN

Line 233: PROCEDURE del (p_rec IN per_suc_shd.g_rec_type)

229: --
230: -- ----------------------------------------------------------------------------
231: -- |---------------------------------< del >----------------------------------|
232: -- ----------------------------------------------------------------------------
233: PROCEDURE del (p_rec IN per_suc_shd.g_rec_type)
234: IS
235: --
236: l_proc VARCHAR2 (72) := g_package || 'del';
237: --

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

239: hr_utility.set_location ('Entering:' || l_proc, 5);
240: --
241: -- We must lock the row which we need to delete.
242: --
243: per_suc_shd.lck (p_rec.succession_plan_id, p_rec.object_version_number);
244: --
245: -- Call the supporting delete validate operation
246: --
247: per_suc_bus.delete_validate (p_rec);

Line 269: l_rec per_suc_shd.g_rec_type;

265: -- ----------------------------------------------------------------------------
266: PROCEDURE del (p_succession_plan_id IN NUMBER, p_object_version_number IN NUMBER)
267: IS
268: --
269: l_rec per_suc_shd.g_rec_type;
270: l_proc VARCHAR2 (72) := g_package || 'del';
271: --
272: BEGIN
273: hr_utility.set_location ('Entering:' || l_proc, 5);