DBA Data[Home] [Help]

APPS.PER_OBJ_DEL dependencies on PER_OBJ_SHD

Line 45: Procedure delete_dml(p_rec in per_obj_shd.g_rec_type) is

41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_obj_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 63: per_obj_shd.constraint_error

59: --
60: Exception
61: When hr_api.child_integrity_violated then
62: -- Child integrity has been violated
63: per_obj_shd.constraint_error
64: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
65: When Others Then
66: Raise;
67: End delete_dml;

Line 101: Procedure pre_delete(p_rec in per_obj_shd.g_rec_type) is

97: -- Internal Table Handler Use Only.
98: --
99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: Procedure pre_delete(p_rec in per_obj_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'pre_delete';
104: --
105: Begin

Line 143: Procedure post_delete(p_rec in per_obj_shd.g_rec_type) is

139: -- Internal table Handler Use Only.
140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure post_delete(p_rec in per_obj_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'post_delete';
146: --
147: Begin

Line 155: p_name_o => per_obj_shd.g_old_rec.name,

151: begin
152: per_obj_rkd.after_delete
153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,

Line 156: p_target_date_o => per_obj_shd.g_old_rec.target_date,

152: per_obj_rkd.after_delete
153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,

Line 157: p_start_date_o => per_obj_shd.g_old_rec.start_date,

153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,

Line 158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,

154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,

Line 159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,

155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,

Line 160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,

156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,

Line 161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,

157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,

Line 162: p_detail_o => per_obj_shd.g_old_rec.detail,

158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,

Line 163: p_comments_o => per_obj_shd.g_old_rec.comments,

159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,

Line 164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,

160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,

Line 165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,

161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,

Line 166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,

162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,

Line 167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,

163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,

Line 168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,

164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,

Line 169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,

165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,

Line 170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,

166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,

Line 171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,

167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,

Line 172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,

168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,

Line 173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,

169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,

Line 174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,

170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,

Line 175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,

171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,

Line 176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,

172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,

Line 177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,

173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,

Line 178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,

174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,

Line 179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,

175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,

Line 180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,

176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,

Line 181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,

177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,

Line 182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,

178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,

Line 183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,

179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:

Line 184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,

180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,

Line 185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,

181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,

Line 186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,

182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,

Line 188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,

184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,

Line 189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,

185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,

Line 190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,

186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,

Line 191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,

187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,

Line 192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,

188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,

Line 193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,

189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,

Line 194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,

190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:

Line 195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,

191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:

Line 196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,

192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,

Line 197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,

193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,

Line 200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,

196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:

Line 201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,

197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,

Line 202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,

198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,

Line 203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,

199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,

Line 205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,

201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,

Line 206: p_group_code_o => per_obj_shd.g_old_rec.group_code,

202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:

Line 207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,

203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,

Line 208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,

204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,

Line 209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,

205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,

Line 211: p_target_value_o => per_obj_shd.g_old_rec.target_value,

207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,

Line 212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,

208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:

Line 213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,

209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,

Line 214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,

210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,

Line 215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,

211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,

Line 217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,

213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code

Line 218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,

214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:

Line 219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,

215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:

Line 220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,

216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:
224: );

Line 221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code

217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:
224: );
225: exception

Line 242: p_rec in per_obj_shd.g_rec_type,

238: -- |---------------------------------< del >----------------------------------|
239: -- ----------------------------------------------------------------------------
240: Procedure del
241: (
242: p_rec in per_obj_shd.g_rec_type,
243: p_validate in boolean default false
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';

Line 262: per_obj_shd.lck

258: End If;
259: --
260: -- We must lock the row which we need to delete.
261: --
262: per_obj_shd.lck
263: (
264: p_rec.objective_id,
265: p_rec.object_version_number
266: );

Line 317: l_rec per_obj_shd.g_rec_type;

313: p_object_version_number in number,
314: p_validate in boolean default false
315: ) is
316: --
317: l_rec per_obj_shd.g_rec_type;
318: l_proc varchar2(72) := g_package||'del';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);