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_CPN_DEL dependencies on PER_CPN_SHD

Line 46: Procedure delete_dml(p_rec in per_cpn_shd.g_rec_type) is

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

Line 64: per_cpn_shd.constraint_error

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

Line 102: Procedure pre_delete(p_rec in per_cpn_shd.g_rec_type) is

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

Line 144: Procedure post_delete(p_rec in per_cpn_shd.g_rec_type) is

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

Line 156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,

152: --
153: begin
154: per_cpn_rkd.after_delete (
155: p_competence_id => p_rec.competence_id ,
156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,

Line 157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,

153: begin
154: per_cpn_rkd.after_delete (
155: p_competence_id => p_rec.competence_id ,
156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,

Line 158: p_name_o => per_cpn_shd.g_old_rec.name ,

154: per_cpn_rkd.after_delete (
155: p_competence_id => p_rec.competence_id ,
156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,

Line 159: p_description_o => per_cpn_shd.g_old_rec.description ,

155: p_competence_id => p_rec.competence_id ,
156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>

Line 160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,

156: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,

Line 161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,

157: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,

Line 162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,

158: p_name_o => per_cpn_shd.g_old_rec.name ,
159: p_description_o => per_cpn_shd.g_old_rec.description ,
160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>

Line 164: per_cpn_shd.g_old_rec.certification_required ,

160: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,

Line 165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,

161: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
162: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,

Line 167: per_cpn_shd.g_old_rec.renewal_period_frequency ,

163: p_certification_required_o =>
164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,

Line 168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,

164: per_cpn_shd.g_old_rec.certification_required ,
165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,

Line 169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,

165: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,

Line 170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,

166: p_renewal_period_frequency_o =>
167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,

Line 171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,

167: per_cpn_shd.g_old_rec.renewal_period_frequency ,
168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,

Line 172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,

168: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,

Line 173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,

169: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,

Line 174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,

170: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,

Line 175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,

171: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,

Line 176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,

172: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,

Line 177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,

173: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,

Line 178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,

174: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,

Line 179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,

175: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,

Line 180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,

176: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,

Line 181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,

177: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,

Line 182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,

178: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,

Line 183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,

179: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,
180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,

Line 184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,

180: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,
181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,

Line 185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,

181: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,
182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,

Line 186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,

182: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,
183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,

Line 187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,

183: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,
184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,

Line 188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,

184: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,
185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,

Line 189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,

185: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,

Line 190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,

186: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id

Line 191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,

187: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster

Line 192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,

188: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id

Line 193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,

189: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type

Line 194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id

190: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits

Line 195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster

191: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type

Line 196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id

192: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number

Line 197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type

193: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field

Line 198: ,p_credits_o => per_cpn_shd.g_old_rec.credits

194: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field

Line 199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type

195: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider

Line 200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number

196: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization

Line 201: ,p_field_o => per_cpn_shd.g_old_rec.field

197: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category

Line 202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field

198: ,p_credits_o => per_cpn_shd.g_old_rec.credits
199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1

Line 203: ,p_provider_o => per_cpn_shd.g_old_rec.provider

199: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2

Line 204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization

200: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3

Line 205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category

201: ,p_field_o => per_cpn_shd.g_old_rec.field
202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4

Line 206: ,p_information1_o => per_cpn_shd.g_old_rec.information1

202: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5

Line 207: ,p_information2_o => per_cpn_shd.g_old_rec.information2

203: ,p_provider_o => per_cpn_shd.g_old_rec.provider
204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6

Line 208: ,p_information3_o => per_cpn_shd.g_old_rec.information3

204: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7

Line 209: ,p_information4_o => per_cpn_shd.g_old_rec.information4

205: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8

Line 210: ,p_information5_o => per_cpn_shd.g_old_rec.information5

206: ,p_information1_o => per_cpn_shd.g_old_rec.information1
207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9

Line 211: ,p_information6_o => per_cpn_shd.g_old_rec.information6

207: ,p_information2_o => per_cpn_shd.g_old_rec.information2
208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10

Line 212: ,p_information7_o => per_cpn_shd.g_old_rec.information7

208: ,p_information3_o => per_cpn_shd.g_old_rec.information3
209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11

Line 213: ,p_information8_o => per_cpn_shd.g_old_rec.information8

209: ,p_information4_o => per_cpn_shd.g_old_rec.information4
210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12

Line 214: ,p_information9_o => per_cpn_shd.g_old_rec.information9

210: ,p_information5_o => per_cpn_shd.g_old_rec.information5
211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13

Line 215: ,p_information10_o => per_cpn_shd.g_old_rec.information10

211: ,p_information6_o => per_cpn_shd.g_old_rec.information6
212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14

Line 216: ,p_information11_o => per_cpn_shd.g_old_rec.information11

212: ,p_information7_o => per_cpn_shd.g_old_rec.information7
213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15

Line 217: ,p_information12_o => per_cpn_shd.g_old_rec.information12

213: ,p_information8_o => per_cpn_shd.g_old_rec.information8
214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16

Line 218: ,p_information13_o => per_cpn_shd.g_old_rec.information13

214: ,p_information9_o => per_cpn_shd.g_old_rec.information9
215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17

Line 219: ,p_information14_o => per_cpn_shd.g_old_rec.information14

215: ,p_information10_o => per_cpn_shd.g_old_rec.information10
216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18

Line 220: ,p_information15_o => per_cpn_shd.g_old_rec.information15

216: ,p_information11_o => per_cpn_shd.g_old_rec.information11
217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19

Line 221: ,p_information16_o => per_cpn_shd.g_old_rec.information16

217: ,p_information12_o => per_cpn_shd.g_old_rec.information12
218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20

Line 222: ,p_information17_o => per_cpn_shd.g_old_rec.information17

218: ,p_information13_o => per_cpn_shd.g_old_rec.information13
219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );

Line 223: ,p_information18_o => per_cpn_shd.g_old_rec.information18

219: ,p_information14_o => per_cpn_shd.g_old_rec.information14
220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );
227: exception

Line 224: ,p_information19_o => per_cpn_shd.g_old_rec.information19

220: ,p_information15_o => per_cpn_shd.g_old_rec.information15
221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then

Line 225: ,p_information20_o => per_cpn_shd.g_old_rec.information20

221: ,p_information16_o => per_cpn_shd.g_old_rec.information16
222: ,p_information17_o => per_cpn_shd.g_old_rec.information17
223: ,p_information18_o => per_cpn_shd.g_old_rec.information18
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error

Line 244: p_rec in per_cpn_shd.g_rec_type,

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

Line 264: per_cpn_shd.lck

260: End If;
261: --
262: -- We must lock the row which we need to delete.
263: --
264: per_cpn_shd.lck
265: (
266: p_rec.competence_id,
267: p_rec.object_version_number
268: );

Line 312: l_rec per_cpn_shd.g_rec_type;

308: p_object_version_number in number,
309: p_validate in boolean default false
310: ) is
311: --
312: l_rec per_cpn_shd.g_rec_type;
313: l_proc varchar2(72) := g_package||'del';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);