APPS.PER_PAT_DEL dependencies on PER_PAT_SHD

Line 53: (p_rec in per_pat_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in per_pat_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --

Line 76: per_pat_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: per_pat_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;

Line 115: Procedure pre_delete(p_rec in per_pat_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in per_pat_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 157: Procedure post_delete(p_rec in per_pat_shd.g_rec_type) is

153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in per_pat_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 169: => per_pat_shd.g_old_rec.allocated_checklist_id

165: per_pat_rkd.after_delete
166: (p_allocated_task_id
167: => p_rec.allocated_task_id
168: ,p_allocated_checklist_id_o
169: => per_pat_shd.g_old_rec.allocated_checklist_id
170: ,p_task_name_o
171: => per_pat_shd.g_old_rec.task_name
172: ,p_description_o
173: => per_pat_shd.g_old_rec.description

Line 171: => per_pat_shd.g_old_rec.task_name

167: => p_rec.allocated_task_id
168: ,p_allocated_checklist_id_o
169: => per_pat_shd.g_old_rec.allocated_checklist_id
170: ,p_task_name_o
171: => per_pat_shd.g_old_rec.task_name
172: ,p_description_o
173: => per_pat_shd.g_old_rec.description
174: ,p_performer_orig_system_o
175: => per_pat_shd.g_old_rec.performer_orig_system

Line 173: => per_pat_shd.g_old_rec.description

169: => per_pat_shd.g_old_rec.allocated_checklist_id
170: ,p_task_name_o
171: => per_pat_shd.g_old_rec.task_name
172: ,p_description_o
173: => per_pat_shd.g_old_rec.description
174: ,p_performer_orig_system_o
175: => per_pat_shd.g_old_rec.performer_orig_system
176: ,p_performer_orig_sys_id_o
177: => per_pat_shd.g_old_rec.performer_orig_sys_id

Line 175: => per_pat_shd.g_old_rec.performer_orig_system

171: => per_pat_shd.g_old_rec.task_name
172: ,p_description_o
173: => per_pat_shd.g_old_rec.description
174: ,p_performer_orig_system_o
175: => per_pat_shd.g_old_rec.performer_orig_system
176: ,p_performer_orig_sys_id_o
177: => per_pat_shd.g_old_rec.performer_orig_sys_id
178: ,p_task_owner_person_id_o
179: => per_pat_shd.g_old_rec.task_owner_person_id

Line 177: => per_pat_shd.g_old_rec.performer_orig_sys_id

173: => per_pat_shd.g_old_rec.description
174: ,p_performer_orig_system_o
175: => per_pat_shd.g_old_rec.performer_orig_system
176: ,p_performer_orig_sys_id_o
177: => per_pat_shd.g_old_rec.performer_orig_sys_id
178: ,p_task_owner_person_id_o
179: => per_pat_shd.g_old_rec.task_owner_person_id
180: ,p_task_sequence_o
181: => per_pat_shd.g_old_rec.task_sequence

Line 179: => per_pat_shd.g_old_rec.task_owner_person_id

175: => per_pat_shd.g_old_rec.performer_orig_system
176: ,p_performer_orig_sys_id_o
177: => per_pat_shd.g_old_rec.performer_orig_sys_id
178: ,p_task_owner_person_id_o
179: => per_pat_shd.g_old_rec.task_owner_person_id
180: ,p_task_sequence_o
181: => per_pat_shd.g_old_rec.task_sequence
182: ,p_target_start_date_o
183: => per_pat_shd.g_old_rec.target_start_date

Line 181: => per_pat_shd.g_old_rec.task_sequence

177: => per_pat_shd.g_old_rec.performer_orig_sys_id
178: ,p_task_owner_person_id_o
179: => per_pat_shd.g_old_rec.task_owner_person_id
180: ,p_task_sequence_o
181: => per_pat_shd.g_old_rec.task_sequence
182: ,p_target_start_date_o
183: => per_pat_shd.g_old_rec.target_start_date
184: ,p_target_end_date_o
185: => per_pat_shd.g_old_rec.target_end_date

Line 183: => per_pat_shd.g_old_rec.target_start_date

179: => per_pat_shd.g_old_rec.task_owner_person_id
180: ,p_task_sequence_o
181: => per_pat_shd.g_old_rec.task_sequence
182: ,p_target_start_date_o
183: => per_pat_shd.g_old_rec.target_start_date
184: ,p_target_end_date_o
185: => per_pat_shd.g_old_rec.target_end_date
186: ,p_actual_start_date_o
187: => per_pat_shd.g_old_rec.actual_start_date

Line 185: => per_pat_shd.g_old_rec.target_end_date

181: => per_pat_shd.g_old_rec.task_sequence
182: ,p_target_start_date_o
183: => per_pat_shd.g_old_rec.target_start_date
184: ,p_target_end_date_o
185: => per_pat_shd.g_old_rec.target_end_date
186: ,p_actual_start_date_o
187: => per_pat_shd.g_old_rec.actual_start_date
188: ,p_actual_end_date_o
189: => per_pat_shd.g_old_rec.actual_end_date

Line 187: => per_pat_shd.g_old_rec.actual_start_date

183: => per_pat_shd.g_old_rec.target_start_date
184: ,p_target_end_date_o
185: => per_pat_shd.g_old_rec.target_end_date
186: ,p_actual_start_date_o
187: => per_pat_shd.g_old_rec.actual_start_date
188: ,p_actual_end_date_o
189: => per_pat_shd.g_old_rec.actual_end_date
190: ,p_action_url_o
191: => per_pat_shd.g_old_rec.action_url

Line 189: => per_pat_shd.g_old_rec.actual_end_date

185: => per_pat_shd.g_old_rec.target_end_date
186: ,p_actual_start_date_o
187: => per_pat_shd.g_old_rec.actual_start_date
188: ,p_actual_end_date_o
189: => per_pat_shd.g_old_rec.actual_end_date
190: ,p_action_url_o
191: => per_pat_shd.g_old_rec.action_url
192: ,p_mandatory_flag_o
193: => per_pat_shd.g_old_rec.mandatory_flag

Line 191: => per_pat_shd.g_old_rec.action_url

187: => per_pat_shd.g_old_rec.actual_start_date
188: ,p_actual_end_date_o
189: => per_pat_shd.g_old_rec.actual_end_date
190: ,p_action_url_o
191: => per_pat_shd.g_old_rec.action_url
192: ,p_mandatory_flag_o
193: => per_pat_shd.g_old_rec.mandatory_flag
194: ,p_status_o
195: => per_pat_shd.g_old_rec.status

Line 193: => per_pat_shd.g_old_rec.mandatory_flag

189: => per_pat_shd.g_old_rec.actual_end_date
190: ,p_action_url_o
191: => per_pat_shd.g_old_rec.action_url
192: ,p_mandatory_flag_o
193: => per_pat_shd.g_old_rec.mandatory_flag
194: ,p_status_o
195: => per_pat_shd.g_old_rec.status
196: ,p_object_version_number_o
197: => per_pat_shd.g_old_rec.object_version_number

Line 195: => per_pat_shd.g_old_rec.status

191: => per_pat_shd.g_old_rec.action_url
192: ,p_mandatory_flag_o
193: => per_pat_shd.g_old_rec.mandatory_flag
194: ,p_status_o
195: => per_pat_shd.g_old_rec.status
196: ,p_object_version_number_o
197: => per_pat_shd.g_old_rec.object_version_number
198: ,p_attribute_category_o
199: => per_pat_shd.g_old_rec.attribute_category

Line 197: => per_pat_shd.g_old_rec.object_version_number

193: => per_pat_shd.g_old_rec.mandatory_flag
194: ,p_status_o
195: => per_pat_shd.g_old_rec.status
196: ,p_object_version_number_o
197: => per_pat_shd.g_old_rec.object_version_number
198: ,p_attribute_category_o
199: => per_pat_shd.g_old_rec.attribute_category
200: ,p_attribute1_o
201: => per_pat_shd.g_old_rec.attribute1

Line 199: => per_pat_shd.g_old_rec.attribute_category

195: => per_pat_shd.g_old_rec.status
196: ,p_object_version_number_o
197: => per_pat_shd.g_old_rec.object_version_number
198: ,p_attribute_category_o
199: => per_pat_shd.g_old_rec.attribute_category
200: ,p_attribute1_o
201: => per_pat_shd.g_old_rec.attribute1
202: ,p_attribute2_o
203: => per_pat_shd.g_old_rec.attribute2

Line 201: => per_pat_shd.g_old_rec.attribute1

197: => per_pat_shd.g_old_rec.object_version_number
198: ,p_attribute_category_o
199: => per_pat_shd.g_old_rec.attribute_category
200: ,p_attribute1_o
201: => per_pat_shd.g_old_rec.attribute1
202: ,p_attribute2_o
203: => per_pat_shd.g_old_rec.attribute2
204: ,p_attribute3_o
205: => per_pat_shd.g_old_rec.attribute3

Line 203: => per_pat_shd.g_old_rec.attribute2

199: => per_pat_shd.g_old_rec.attribute_category
200: ,p_attribute1_o
201: => per_pat_shd.g_old_rec.attribute1
202: ,p_attribute2_o
203: => per_pat_shd.g_old_rec.attribute2
204: ,p_attribute3_o
205: => per_pat_shd.g_old_rec.attribute3
206: ,p_attribute4_o
207: => per_pat_shd.g_old_rec.attribute4

Line 205: => per_pat_shd.g_old_rec.attribute3

201: => per_pat_shd.g_old_rec.attribute1
202: ,p_attribute2_o
203: => per_pat_shd.g_old_rec.attribute2
204: ,p_attribute3_o
205: => per_pat_shd.g_old_rec.attribute3
206: ,p_attribute4_o
207: => per_pat_shd.g_old_rec.attribute4
208: ,p_attribute5_o
209: => per_pat_shd.g_old_rec.attribute5

Line 207: => per_pat_shd.g_old_rec.attribute4

203: => per_pat_shd.g_old_rec.attribute2
204: ,p_attribute3_o
205: => per_pat_shd.g_old_rec.attribute3
206: ,p_attribute4_o
207: => per_pat_shd.g_old_rec.attribute4
208: ,p_attribute5_o
209: => per_pat_shd.g_old_rec.attribute5
210: ,p_attribute6_o
211: => per_pat_shd.g_old_rec.attribute6

Line 209: => per_pat_shd.g_old_rec.attribute5

205: => per_pat_shd.g_old_rec.attribute3
206: ,p_attribute4_o
207: => per_pat_shd.g_old_rec.attribute4
208: ,p_attribute5_o
209: => per_pat_shd.g_old_rec.attribute5
210: ,p_attribute6_o
211: => per_pat_shd.g_old_rec.attribute6
212: ,p_attribute7_o
213: => per_pat_shd.g_old_rec.attribute7

Line 211: => per_pat_shd.g_old_rec.attribute6

207: => per_pat_shd.g_old_rec.attribute4
208: ,p_attribute5_o
209: => per_pat_shd.g_old_rec.attribute5
210: ,p_attribute6_o
211: => per_pat_shd.g_old_rec.attribute6
212: ,p_attribute7_o
213: => per_pat_shd.g_old_rec.attribute7
214: ,p_attribute8_o
215: => per_pat_shd.g_old_rec.attribute8

Line 213: => per_pat_shd.g_old_rec.attribute7

209: => per_pat_shd.g_old_rec.attribute5
210: ,p_attribute6_o
211: => per_pat_shd.g_old_rec.attribute6
212: ,p_attribute7_o
213: => per_pat_shd.g_old_rec.attribute7
214: ,p_attribute8_o
215: => per_pat_shd.g_old_rec.attribute8
216: ,p_attribute9_o
217: => per_pat_shd.g_old_rec.attribute9

Line 215: => per_pat_shd.g_old_rec.attribute8

211: => per_pat_shd.g_old_rec.attribute6
212: ,p_attribute7_o
213: => per_pat_shd.g_old_rec.attribute7
214: ,p_attribute8_o
215: => per_pat_shd.g_old_rec.attribute8
216: ,p_attribute9_o
217: => per_pat_shd.g_old_rec.attribute9
218: ,p_attribute10_o
219: => per_pat_shd.g_old_rec.attribute10

Line 217: => per_pat_shd.g_old_rec.attribute9

213: => per_pat_shd.g_old_rec.attribute7
214: ,p_attribute8_o
215: => per_pat_shd.g_old_rec.attribute8
216: ,p_attribute9_o
217: => per_pat_shd.g_old_rec.attribute9
218: ,p_attribute10_o
219: => per_pat_shd.g_old_rec.attribute10
220: ,p_attribute11_o
221: => per_pat_shd.g_old_rec.attribute11

Line 219: => per_pat_shd.g_old_rec.attribute10

215: => per_pat_shd.g_old_rec.attribute8
216: ,p_attribute9_o
217: => per_pat_shd.g_old_rec.attribute9
218: ,p_attribute10_o
219: => per_pat_shd.g_old_rec.attribute10
220: ,p_attribute11_o
221: => per_pat_shd.g_old_rec.attribute11
222: ,p_attribute12_o
223: => per_pat_shd.g_old_rec.attribute12

Line 221: => per_pat_shd.g_old_rec.attribute11

217: => per_pat_shd.g_old_rec.attribute9
218: ,p_attribute10_o
219: => per_pat_shd.g_old_rec.attribute10
220: ,p_attribute11_o
221: => per_pat_shd.g_old_rec.attribute11
222: ,p_attribute12_o
223: => per_pat_shd.g_old_rec.attribute12
224: ,p_attribute13_o
225: => per_pat_shd.g_old_rec.attribute13

Line 223: => per_pat_shd.g_old_rec.attribute12

219: => per_pat_shd.g_old_rec.attribute10
220: ,p_attribute11_o
221: => per_pat_shd.g_old_rec.attribute11
222: ,p_attribute12_o
223: => per_pat_shd.g_old_rec.attribute12
224: ,p_attribute13_o
225: => per_pat_shd.g_old_rec.attribute13
226: ,p_attribute14_o
227: => per_pat_shd.g_old_rec.attribute14

Line 225: => per_pat_shd.g_old_rec.attribute13

221: => per_pat_shd.g_old_rec.attribute11
222: ,p_attribute12_o
223: => per_pat_shd.g_old_rec.attribute12
224: ,p_attribute13_o
225: => per_pat_shd.g_old_rec.attribute13
226: ,p_attribute14_o
227: => per_pat_shd.g_old_rec.attribute14
228: ,p_attribute15_o
229: => per_pat_shd.g_old_rec.attribute15

Line 227: => per_pat_shd.g_old_rec.attribute14

223: => per_pat_shd.g_old_rec.attribute12
224: ,p_attribute13_o
225: => per_pat_shd.g_old_rec.attribute13
226: ,p_attribute14_o
227: => per_pat_shd.g_old_rec.attribute14
228: ,p_attribute15_o
229: => per_pat_shd.g_old_rec.attribute15
230: ,p_attribute16_o
231: => per_pat_shd.g_old_rec.attribute16

Line 229: => per_pat_shd.g_old_rec.attribute15

225: => per_pat_shd.g_old_rec.attribute13
226: ,p_attribute14_o
227: => per_pat_shd.g_old_rec.attribute14
228: ,p_attribute15_o
229: => per_pat_shd.g_old_rec.attribute15
230: ,p_attribute16_o
231: => per_pat_shd.g_old_rec.attribute16
232: ,p_attribute17_o
233: => per_pat_shd.g_old_rec.attribute17

Line 231: => per_pat_shd.g_old_rec.attribute16

227: => per_pat_shd.g_old_rec.attribute14
228: ,p_attribute15_o
229: => per_pat_shd.g_old_rec.attribute15
230: ,p_attribute16_o
231: => per_pat_shd.g_old_rec.attribute16
232: ,p_attribute17_o
233: => per_pat_shd.g_old_rec.attribute17
234: ,p_attribute18_o
235: => per_pat_shd.g_old_rec.attribute18

Line 233: => per_pat_shd.g_old_rec.attribute17

229: => per_pat_shd.g_old_rec.attribute15
230: ,p_attribute16_o
231: => per_pat_shd.g_old_rec.attribute16
232: ,p_attribute17_o
233: => per_pat_shd.g_old_rec.attribute17
234: ,p_attribute18_o
235: => per_pat_shd.g_old_rec.attribute18
236: ,p_attribute19_o
237: => per_pat_shd.g_old_rec.attribute19

Line 235: => per_pat_shd.g_old_rec.attribute18

231: => per_pat_shd.g_old_rec.attribute16
232: ,p_attribute17_o
233: => per_pat_shd.g_old_rec.attribute17
234: ,p_attribute18_o
235: => per_pat_shd.g_old_rec.attribute18
236: ,p_attribute19_o
237: => per_pat_shd.g_old_rec.attribute19
238: ,p_attribute20_o
239: => per_pat_shd.g_old_rec.attribute20

Line 237: => per_pat_shd.g_old_rec.attribute19

233: => per_pat_shd.g_old_rec.attribute17
234: ,p_attribute18_o
235: => per_pat_shd.g_old_rec.attribute18
236: ,p_attribute19_o
237: => per_pat_shd.g_old_rec.attribute19
238: ,p_attribute20_o
239: => per_pat_shd.g_old_rec.attribute20
240: ,p_information_category_o
241: => per_pat_shd.g_old_rec.information_category

Line 239: => per_pat_shd.g_old_rec.attribute20

235: => per_pat_shd.g_old_rec.attribute18
236: ,p_attribute19_o
237: => per_pat_shd.g_old_rec.attribute19
238: ,p_attribute20_o
239: => per_pat_shd.g_old_rec.attribute20
240: ,p_information_category_o
241: => per_pat_shd.g_old_rec.information_category
242: ,p_information1_o
243: => per_pat_shd.g_old_rec.information1

Line 241: => per_pat_shd.g_old_rec.information_category

237: => per_pat_shd.g_old_rec.attribute19
238: ,p_attribute20_o
239: => per_pat_shd.g_old_rec.attribute20
240: ,p_information_category_o
241: => per_pat_shd.g_old_rec.information_category
242: ,p_information1_o
243: => per_pat_shd.g_old_rec.information1
244: ,p_information2_o
245: => per_pat_shd.g_old_rec.information2

Line 243: => per_pat_shd.g_old_rec.information1

239: => per_pat_shd.g_old_rec.attribute20
240: ,p_information_category_o
241: => per_pat_shd.g_old_rec.information_category
242: ,p_information1_o
243: => per_pat_shd.g_old_rec.information1
244: ,p_information2_o
245: => per_pat_shd.g_old_rec.information2
246: ,p_information3_o
247: => per_pat_shd.g_old_rec.information3

Line 245: => per_pat_shd.g_old_rec.information2

241: => per_pat_shd.g_old_rec.information_category
242: ,p_information1_o
243: => per_pat_shd.g_old_rec.information1
244: ,p_information2_o
245: => per_pat_shd.g_old_rec.information2
246: ,p_information3_o
247: => per_pat_shd.g_old_rec.information3
248: ,p_information4_o
249: => per_pat_shd.g_old_rec.information4

Line 247: => per_pat_shd.g_old_rec.information3

243: => per_pat_shd.g_old_rec.information1
244: ,p_information2_o
245: => per_pat_shd.g_old_rec.information2
246: ,p_information3_o
247: => per_pat_shd.g_old_rec.information3
248: ,p_information4_o
249: => per_pat_shd.g_old_rec.information4
250: ,p_information5_o
251: => per_pat_shd.g_old_rec.information5

Line 249: => per_pat_shd.g_old_rec.information4

245: => per_pat_shd.g_old_rec.information2
246: ,p_information3_o
247: => per_pat_shd.g_old_rec.information3
248: ,p_information4_o
249: => per_pat_shd.g_old_rec.information4
250: ,p_information5_o
251: => per_pat_shd.g_old_rec.information5
252: ,p_information6_o
253: => per_pat_shd.g_old_rec.information6

Line 251: => per_pat_shd.g_old_rec.information5

247: => per_pat_shd.g_old_rec.information3
248: ,p_information4_o
249: => per_pat_shd.g_old_rec.information4
250: ,p_information5_o
251: => per_pat_shd.g_old_rec.information5
252: ,p_information6_o
253: => per_pat_shd.g_old_rec.information6
254: ,p_information7_o
255: => per_pat_shd.g_old_rec.information7

Line 253: => per_pat_shd.g_old_rec.information6

249: => per_pat_shd.g_old_rec.information4
250: ,p_information5_o
251: => per_pat_shd.g_old_rec.information5
252: ,p_information6_o
253: => per_pat_shd.g_old_rec.information6
254: ,p_information7_o
255: => per_pat_shd.g_old_rec.information7
256: ,p_information8_o
257: => per_pat_shd.g_old_rec.information8

Line 255: => per_pat_shd.g_old_rec.information7

251: => per_pat_shd.g_old_rec.information5
252: ,p_information6_o
253: => per_pat_shd.g_old_rec.information6
254: ,p_information7_o
255: => per_pat_shd.g_old_rec.information7
256: ,p_information8_o
257: => per_pat_shd.g_old_rec.information8
258: ,p_information9_o
259: => per_pat_shd.g_old_rec.information9

Line 257: => per_pat_shd.g_old_rec.information8

253: => per_pat_shd.g_old_rec.information6
254: ,p_information7_o
255: => per_pat_shd.g_old_rec.information7
256: ,p_information8_o
257: => per_pat_shd.g_old_rec.information8
258: ,p_information9_o
259: => per_pat_shd.g_old_rec.information9
260: ,p_information10_o
261: => per_pat_shd.g_old_rec.information10

Line 259: => per_pat_shd.g_old_rec.information9

255: => per_pat_shd.g_old_rec.information7
256: ,p_information8_o
257: => per_pat_shd.g_old_rec.information8
258: ,p_information9_o
259: => per_pat_shd.g_old_rec.information9
260: ,p_information10_o
261: => per_pat_shd.g_old_rec.information10
262: ,p_information11_o
263: => per_pat_shd.g_old_rec.information11

Line 261: => per_pat_shd.g_old_rec.information10

257: => per_pat_shd.g_old_rec.information8
258: ,p_information9_o
259: => per_pat_shd.g_old_rec.information9
260: ,p_information10_o
261: => per_pat_shd.g_old_rec.information10
262: ,p_information11_o
263: => per_pat_shd.g_old_rec.information11
264: ,p_information12_o
265: => per_pat_shd.g_old_rec.information12

Line 263: => per_pat_shd.g_old_rec.information11

259: => per_pat_shd.g_old_rec.information9
260: ,p_information10_o
261: => per_pat_shd.g_old_rec.information10
262: ,p_information11_o
263: => per_pat_shd.g_old_rec.information11
264: ,p_information12_o
265: => per_pat_shd.g_old_rec.information12
266: ,p_information13_o
267: => per_pat_shd.g_old_rec.information13

Line 265: => per_pat_shd.g_old_rec.information12

261: => per_pat_shd.g_old_rec.information10
262: ,p_information11_o
263: => per_pat_shd.g_old_rec.information11
264: ,p_information12_o
265: => per_pat_shd.g_old_rec.information12
266: ,p_information13_o
267: => per_pat_shd.g_old_rec.information13
268: ,p_information14_o
269: => per_pat_shd.g_old_rec.information14

Line 267: => per_pat_shd.g_old_rec.information13

263: => per_pat_shd.g_old_rec.information11
264: ,p_information12_o
265: => per_pat_shd.g_old_rec.information12
266: ,p_information13_o
267: => per_pat_shd.g_old_rec.information13
268: ,p_information14_o
269: => per_pat_shd.g_old_rec.information14
270: ,p_information15_o
271: => per_pat_shd.g_old_rec.information15

Line 269: => per_pat_shd.g_old_rec.information14

265: => per_pat_shd.g_old_rec.information12
266: ,p_information13_o
267: => per_pat_shd.g_old_rec.information13
268: ,p_information14_o
269: => per_pat_shd.g_old_rec.information14
270: ,p_information15_o
271: => per_pat_shd.g_old_rec.information15
272: ,p_information16_o
273: => per_pat_shd.g_old_rec.information16

Line 271: => per_pat_shd.g_old_rec.information15

267: => per_pat_shd.g_old_rec.information13
268: ,p_information14_o
269: => per_pat_shd.g_old_rec.information14
270: ,p_information15_o
271: => per_pat_shd.g_old_rec.information15
272: ,p_information16_o
273: => per_pat_shd.g_old_rec.information16
274: ,p_information17_o
275: => per_pat_shd.g_old_rec.information17

Line 273: => per_pat_shd.g_old_rec.information16

269: => per_pat_shd.g_old_rec.information14
270: ,p_information15_o
271: => per_pat_shd.g_old_rec.information15
272: ,p_information16_o
273: => per_pat_shd.g_old_rec.information16
274: ,p_information17_o
275: => per_pat_shd.g_old_rec.information17
276: ,p_information18_o
277: => per_pat_shd.g_old_rec.information18

Line 275: => per_pat_shd.g_old_rec.information17

271: => per_pat_shd.g_old_rec.information15
272: ,p_information16_o
273: => per_pat_shd.g_old_rec.information16
274: ,p_information17_o
275: => per_pat_shd.g_old_rec.information17
276: ,p_information18_o
277: => per_pat_shd.g_old_rec.information18
278: ,p_information19_o
279: => per_pat_shd.g_old_rec.information19

Line 277: => per_pat_shd.g_old_rec.information18

273: => per_pat_shd.g_old_rec.information16
274: ,p_information17_o
275: => per_pat_shd.g_old_rec.information17
276: ,p_information18_o
277: => per_pat_shd.g_old_rec.information18
278: ,p_information19_o
279: => per_pat_shd.g_old_rec.information19
280: ,p_information20_o
281: => per_pat_shd.g_old_rec.information20

Line 279: => per_pat_shd.g_old_rec.information19

275: => per_pat_shd.g_old_rec.information17
276: ,p_information18_o
277: => per_pat_shd.g_old_rec.information18
278: ,p_information19_o
279: => per_pat_shd.g_old_rec.information19
280: ,p_information20_o
281: => per_pat_shd.g_old_rec.information20
282: );
283: --

Line 281: => per_pat_shd.g_old_rec.information20

277: => per_pat_shd.g_old_rec.information18
278: ,p_information19_o
279: => per_pat_shd.g_old_rec.information19
280: ,p_information20_o
281: => per_pat_shd.g_old_rec.information20
282: );
283: --
284: exception
285: --

Line 301: (p_rec in per_pat_shd.g_rec_type

297: -- ----------------------------------------------------------------------------
298: -- |---------------------------------< del >----------------------------------|
299: -- ----------------------------------------------------------------------------
300: Procedure del
301: (p_rec in per_pat_shd.g_rec_type
302: ) is
303: --
304: l_proc varchar2(72) := g_package||'del';
305: --

Line 311: per_pat_shd.lck

307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- We must lock the row which we need to delete.
310: --
311: per_pat_shd.lck
312: (p_rec.allocated_task_id
313: ,p_rec.object_version_number
314: );
315: --

Line 348: l_rec per_pat_shd.g_rec_type;

344: (p_allocated_task_id in number
345: ,p_object_version_number in number
346: ) is
347: --
348: l_rec per_pat_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'del';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);