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_PAR_DEL dependencies on PER_PAR_SHD

Line 45: Procedure delete_dml(p_rec in per_par_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_par_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 62: per_par_shd.constraint_error

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

Line 100: Procedure pre_delete(p_rec in per_par_shd.g_rec_type) is

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

Line 142: Procedure post_delete(p_rec in per_par_shd.g_rec_type) is

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

Line 154: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,

150: --
151: begin
152: per_par_rkd.after_delete (
153: p_participant_id => p_rec.participant_id ,
154: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,

Line 155: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,

151: begin
152: per_par_rkd.after_delete (
153: p_participant_id => p_rec.participant_id ,
154: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>

Line 156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,

152: per_par_rkd.after_delete (
153: p_participant_id => p_rec.participant_id ,
154: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,

Line 158: per_par_shd.g_old_rec.participation_in_table ,

154: p_business_group_id_o => per_par_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_par_shd.g_old_rec.object_version_number,
156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,

Line 160: per_par_shd.g_old_rec.participation_in_column ,

156: p_questionnaire_template_id_o => per_par_shd.g_old_rec.questionnaire_template_id,
157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,

Line 161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,

157: p_participation_in_table_o =>
158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,

Line 162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,

158: per_par_shd.g_old_rec.participation_in_table ,
159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,

Line 163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,

159: p_participation_in_column_o =>
160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,

Line 164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,

160: per_par_shd.g_old_rec.participation_in_column ,
161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,

Line 165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,

161: p_participation_in_id_o => per_par_shd.g_old_rec.participation_in_id ,
162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,

Line 166: p_comments_o => per_par_shd.g_old_rec.comments ,

162: p_participation_status_o => per_par_shd.g_old_rec.participation_status ,
163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,

Line 167: p_person_id_o => per_par_shd.g_old_rec.person_id ,

163: p_participation_type_o => per_par_shd.g_old_rec.participation_type ,
164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,

Line 168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,

164: p_last_notified_date_o => per_par_shd.g_old_rec.last_notified_date ,
165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
172: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,

Line 169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,

165: p_date_completed_o => per_par_shd.g_old_rec.date_completed ,
166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
172: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
173: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,

Line 170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,

166: p_comments_o => per_par_shd.g_old_rec.comments ,
167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
172: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
173: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
174: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,

Line 171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,

167: p_person_id_o => per_par_shd.g_old_rec.person_id ,
168: p_attribute_category_o => per_par_shd.g_old_rec.attribute_category ,
169: p_attribute1_o => per_par_shd.g_old_rec.attribute1 ,
170: p_attribute2_o => per_par_shd.g_old_rec.attribute2 ,
171: p_attribute3_o => per_par_shd.g_old_rec.attribute3 ,
172: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,
173: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,
174: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,
175: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,

Line 172: p_attribute4_o => per_par_shd.g_old_rec.attribute4 ,

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

Line 173: p_attribute5_o => per_par_shd.g_old_rec.attribute5 ,

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

Line 174: p_attribute6_o => per_par_shd.g_old_rec.attribute6 ,

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

Line 175: p_attribute7_o => per_par_shd.g_old_rec.attribute7 ,

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

Line 176: p_attribute8_o => per_par_shd.g_old_rec.attribute8 ,

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

Line 177: p_attribute9_o => per_par_shd.g_old_rec.attribute9 ,

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

Line 178: p_attribute10_o => per_par_shd.g_old_rec.attribute10 ,

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

Line 179: p_attribute11_o => per_par_shd.g_old_rec.attribute11 ,

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

Line 180: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,

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

Line 181: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,

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

Line 182: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,

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

Line 183: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,

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

Line 184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,

180: p_attribute12_o => per_par_shd.g_old_rec.attribute12 ,
181: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
182: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
183: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );

Line 185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,

181: p_attribute13_o => per_par_shd.g_old_rec.attribute13 ,
182: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
183: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );
189: exception

Line 186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,

182: p_attribute14_o => per_par_shd.g_old_rec.attribute14 ,
183: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );
189: exception
190: when hr_api.cannot_find_prog_unit then

Line 187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,

183: p_attribute15_o => per_par_shd.g_old_rec.attribute15 ,
184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error

Line 188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );

184: p_attribute16_o => per_par_shd.g_old_rec.attribute16 ,
185: p_attribute17_o => per_par_shd.g_old_rec.attribute17 ,
186: p_attribute18_o => per_par_shd.g_old_rec.attribute18 ,
187: p_attribute19_o => per_par_shd.g_old_rec.attribute19 ,
188: p_attribute20_o => per_par_shd.g_old_rec.attribute20 );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: ( p_module_name => 'PER_PARTICIPANTS'

Line 206: p_rec in per_par_shd.g_rec_type,

202: -- |---------------------------------< del >----------------------------------|
203: -- ----------------------------------------------------------------------------
204: Procedure del
205: (
206: p_rec in per_par_shd.g_rec_type,
207: p_validate in boolean default false
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'del';

Line 226: per_par_shd.lck

222: End If;
223: --
224: -- We must lock the row which we need to delete.
225: --
226: per_par_shd.lck
227: (
228: p_rec.participant_id,
229: p_rec.object_version_number
230: );

Line 284: l_rec per_par_shd.g_rec_type;

280: p_object_version_number in number,
281: p_validate in boolean default false
282: ) is
283: --
284: l_rec per_par_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'del';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);