DBA Data[Home] [Help]

APPS.PER_PMS_DEL dependencies on PER_PMS_SHD

Line 52: (p_rec in per_pms_shd.g_rec_type

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

Line 75: per_pms_shd.constraint_error

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

Line 114: Procedure pre_delete(p_rec in per_pms_shd.g_rec_type) is

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

Line 157: (p_rec in per_pms_shd.g_rec_type

153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete
157: (p_rec in per_pms_shd.g_rec_type
158: ,p_created_by_plan_warning in boolean
159: ) is
160: --
161: l_proc varchar2(72) := g_package||'post_delete';

Line 173: => per_pms_shd.g_old_rec.object_version_number

169: => p_rec.scorecard_id
170: ,p_created_by_plan_warning
171: => p_created_by_plan_warning
172: ,p_object_version_number_o
173: => per_pms_shd.g_old_rec.object_version_number
174: ,p_scorecard_name_o
175: => per_pms_shd.g_old_rec.scorecard_name
176: ,p_person_id_o
177: => per_pms_shd.g_old_rec.person_id

Line 175: => per_pms_shd.g_old_rec.scorecard_name

171: => p_created_by_plan_warning
172: ,p_object_version_number_o
173: => per_pms_shd.g_old_rec.object_version_number
174: ,p_scorecard_name_o
175: => per_pms_shd.g_old_rec.scorecard_name
176: ,p_person_id_o
177: => per_pms_shd.g_old_rec.person_id
178: ,p_assignment_id_o
179: => per_pms_shd.g_old_rec.assignment_id

Line 177: => per_pms_shd.g_old_rec.person_id

173: => per_pms_shd.g_old_rec.object_version_number
174: ,p_scorecard_name_o
175: => per_pms_shd.g_old_rec.scorecard_name
176: ,p_person_id_o
177: => per_pms_shd.g_old_rec.person_id
178: ,p_assignment_id_o
179: => per_pms_shd.g_old_rec.assignment_id
180: ,p_start_date_o
181: => per_pms_shd.g_old_rec.start_date

Line 179: => per_pms_shd.g_old_rec.assignment_id

175: => per_pms_shd.g_old_rec.scorecard_name
176: ,p_person_id_o
177: => per_pms_shd.g_old_rec.person_id
178: ,p_assignment_id_o
179: => per_pms_shd.g_old_rec.assignment_id
180: ,p_start_date_o
181: => per_pms_shd.g_old_rec.start_date
182: ,p_end_date_o
183: => per_pms_shd.g_old_rec.end_date

Line 181: => per_pms_shd.g_old_rec.start_date

177: => per_pms_shd.g_old_rec.person_id
178: ,p_assignment_id_o
179: => per_pms_shd.g_old_rec.assignment_id
180: ,p_start_date_o
181: => per_pms_shd.g_old_rec.start_date
182: ,p_end_date_o
183: => per_pms_shd.g_old_rec.end_date
184: ,p_plan_id_o
185: => per_pms_shd.g_old_rec.plan_id

Line 183: => per_pms_shd.g_old_rec.end_date

179: => per_pms_shd.g_old_rec.assignment_id
180: ,p_start_date_o
181: => per_pms_shd.g_old_rec.start_date
182: ,p_end_date_o
183: => per_pms_shd.g_old_rec.end_date
184: ,p_plan_id_o
185: => per_pms_shd.g_old_rec.plan_id
186: ,p_status_code_o
187: => per_pms_shd.g_old_rec.status_code

Line 185: => per_pms_shd.g_old_rec.plan_id

181: => per_pms_shd.g_old_rec.start_date
182: ,p_end_date_o
183: => per_pms_shd.g_old_rec.end_date
184: ,p_plan_id_o
185: => per_pms_shd.g_old_rec.plan_id
186: ,p_status_code_o
187: => per_pms_shd.g_old_rec.status_code
188: ,p_creator_type_o
189: => per_pms_shd.g_old_rec.creator_type

Line 187: => per_pms_shd.g_old_rec.status_code

183: => per_pms_shd.g_old_rec.end_date
184: ,p_plan_id_o
185: => per_pms_shd.g_old_rec.plan_id
186: ,p_status_code_o
187: => per_pms_shd.g_old_rec.status_code
188: ,p_creator_type_o
189: => per_pms_shd.g_old_rec.creator_type
190: ,p_error_log_o
191: => per_pms_shd.g_old_rec.error_log

Line 189: => per_pms_shd.g_old_rec.creator_type

185: => per_pms_shd.g_old_rec.plan_id
186: ,p_status_code_o
187: => per_pms_shd.g_old_rec.status_code
188: ,p_creator_type_o
189: => per_pms_shd.g_old_rec.creator_type
190: ,p_error_log_o
191: => per_pms_shd.g_old_rec.error_log
192: ,p_attribute_category_o
193: => per_pms_shd.g_old_rec.attribute_category

Line 191: => per_pms_shd.g_old_rec.error_log

187: => per_pms_shd.g_old_rec.status_code
188: ,p_creator_type_o
189: => per_pms_shd.g_old_rec.creator_type
190: ,p_error_log_o
191: => per_pms_shd.g_old_rec.error_log
192: ,p_attribute_category_o
193: => per_pms_shd.g_old_rec.attribute_category
194: ,p_attribute1_o
195: => per_pms_shd.g_old_rec.attribute1

Line 193: => per_pms_shd.g_old_rec.attribute_category

189: => per_pms_shd.g_old_rec.creator_type
190: ,p_error_log_o
191: => per_pms_shd.g_old_rec.error_log
192: ,p_attribute_category_o
193: => per_pms_shd.g_old_rec.attribute_category
194: ,p_attribute1_o
195: => per_pms_shd.g_old_rec.attribute1
196: ,p_attribute2_o
197: => per_pms_shd.g_old_rec.attribute2

Line 195: => per_pms_shd.g_old_rec.attribute1

191: => per_pms_shd.g_old_rec.error_log
192: ,p_attribute_category_o
193: => per_pms_shd.g_old_rec.attribute_category
194: ,p_attribute1_o
195: => per_pms_shd.g_old_rec.attribute1
196: ,p_attribute2_o
197: => per_pms_shd.g_old_rec.attribute2
198: ,p_attribute3_o
199: => per_pms_shd.g_old_rec.attribute3

Line 197: => per_pms_shd.g_old_rec.attribute2

193: => per_pms_shd.g_old_rec.attribute_category
194: ,p_attribute1_o
195: => per_pms_shd.g_old_rec.attribute1
196: ,p_attribute2_o
197: => per_pms_shd.g_old_rec.attribute2
198: ,p_attribute3_o
199: => per_pms_shd.g_old_rec.attribute3
200: ,p_attribute4_o
201: => per_pms_shd.g_old_rec.attribute4

Line 199: => per_pms_shd.g_old_rec.attribute3

195: => per_pms_shd.g_old_rec.attribute1
196: ,p_attribute2_o
197: => per_pms_shd.g_old_rec.attribute2
198: ,p_attribute3_o
199: => per_pms_shd.g_old_rec.attribute3
200: ,p_attribute4_o
201: => per_pms_shd.g_old_rec.attribute4
202: ,p_attribute5_o
203: => per_pms_shd.g_old_rec.attribute5

Line 201: => per_pms_shd.g_old_rec.attribute4

197: => per_pms_shd.g_old_rec.attribute2
198: ,p_attribute3_o
199: => per_pms_shd.g_old_rec.attribute3
200: ,p_attribute4_o
201: => per_pms_shd.g_old_rec.attribute4
202: ,p_attribute5_o
203: => per_pms_shd.g_old_rec.attribute5
204: ,p_attribute6_o
205: => per_pms_shd.g_old_rec.attribute6

Line 203: => per_pms_shd.g_old_rec.attribute5

199: => per_pms_shd.g_old_rec.attribute3
200: ,p_attribute4_o
201: => per_pms_shd.g_old_rec.attribute4
202: ,p_attribute5_o
203: => per_pms_shd.g_old_rec.attribute5
204: ,p_attribute6_o
205: => per_pms_shd.g_old_rec.attribute6
206: ,p_attribute7_o
207: => per_pms_shd.g_old_rec.attribute7

Line 205: => per_pms_shd.g_old_rec.attribute6

201: => per_pms_shd.g_old_rec.attribute4
202: ,p_attribute5_o
203: => per_pms_shd.g_old_rec.attribute5
204: ,p_attribute6_o
205: => per_pms_shd.g_old_rec.attribute6
206: ,p_attribute7_o
207: => per_pms_shd.g_old_rec.attribute7
208: ,p_attribute8_o
209: => per_pms_shd.g_old_rec.attribute8

Line 207: => per_pms_shd.g_old_rec.attribute7

203: => per_pms_shd.g_old_rec.attribute5
204: ,p_attribute6_o
205: => per_pms_shd.g_old_rec.attribute6
206: ,p_attribute7_o
207: => per_pms_shd.g_old_rec.attribute7
208: ,p_attribute8_o
209: => per_pms_shd.g_old_rec.attribute8
210: ,p_attribute9_o
211: => per_pms_shd.g_old_rec.attribute9

Line 209: => per_pms_shd.g_old_rec.attribute8

205: => per_pms_shd.g_old_rec.attribute6
206: ,p_attribute7_o
207: => per_pms_shd.g_old_rec.attribute7
208: ,p_attribute8_o
209: => per_pms_shd.g_old_rec.attribute8
210: ,p_attribute9_o
211: => per_pms_shd.g_old_rec.attribute9
212: ,p_attribute10_o
213: => per_pms_shd.g_old_rec.attribute10

Line 211: => per_pms_shd.g_old_rec.attribute9

207: => per_pms_shd.g_old_rec.attribute7
208: ,p_attribute8_o
209: => per_pms_shd.g_old_rec.attribute8
210: ,p_attribute9_o
211: => per_pms_shd.g_old_rec.attribute9
212: ,p_attribute10_o
213: => per_pms_shd.g_old_rec.attribute10
214: ,p_attribute11_o
215: => per_pms_shd.g_old_rec.attribute11

Line 213: => per_pms_shd.g_old_rec.attribute10

209: => per_pms_shd.g_old_rec.attribute8
210: ,p_attribute9_o
211: => per_pms_shd.g_old_rec.attribute9
212: ,p_attribute10_o
213: => per_pms_shd.g_old_rec.attribute10
214: ,p_attribute11_o
215: => per_pms_shd.g_old_rec.attribute11
216: ,p_attribute12_o
217: => per_pms_shd.g_old_rec.attribute12

Line 215: => per_pms_shd.g_old_rec.attribute11

211: => per_pms_shd.g_old_rec.attribute9
212: ,p_attribute10_o
213: => per_pms_shd.g_old_rec.attribute10
214: ,p_attribute11_o
215: => per_pms_shd.g_old_rec.attribute11
216: ,p_attribute12_o
217: => per_pms_shd.g_old_rec.attribute12
218: ,p_attribute13_o
219: => per_pms_shd.g_old_rec.attribute13

Line 217: => per_pms_shd.g_old_rec.attribute12

213: => per_pms_shd.g_old_rec.attribute10
214: ,p_attribute11_o
215: => per_pms_shd.g_old_rec.attribute11
216: ,p_attribute12_o
217: => per_pms_shd.g_old_rec.attribute12
218: ,p_attribute13_o
219: => per_pms_shd.g_old_rec.attribute13
220: ,p_attribute14_o
221: => per_pms_shd.g_old_rec.attribute14

Line 219: => per_pms_shd.g_old_rec.attribute13

215: => per_pms_shd.g_old_rec.attribute11
216: ,p_attribute12_o
217: => per_pms_shd.g_old_rec.attribute12
218: ,p_attribute13_o
219: => per_pms_shd.g_old_rec.attribute13
220: ,p_attribute14_o
221: => per_pms_shd.g_old_rec.attribute14
222: ,p_attribute15_o
223: => per_pms_shd.g_old_rec.attribute15

Line 221: => per_pms_shd.g_old_rec.attribute14

217: => per_pms_shd.g_old_rec.attribute12
218: ,p_attribute13_o
219: => per_pms_shd.g_old_rec.attribute13
220: ,p_attribute14_o
221: => per_pms_shd.g_old_rec.attribute14
222: ,p_attribute15_o
223: => per_pms_shd.g_old_rec.attribute15
224: ,p_attribute16_o
225: => per_pms_shd.g_old_rec.attribute16

Line 223: => per_pms_shd.g_old_rec.attribute15

219: => per_pms_shd.g_old_rec.attribute13
220: ,p_attribute14_o
221: => per_pms_shd.g_old_rec.attribute14
222: ,p_attribute15_o
223: => per_pms_shd.g_old_rec.attribute15
224: ,p_attribute16_o
225: => per_pms_shd.g_old_rec.attribute16
226: ,p_attribute17_o
227: => per_pms_shd.g_old_rec.attribute17

Line 225: => per_pms_shd.g_old_rec.attribute16

221: => per_pms_shd.g_old_rec.attribute14
222: ,p_attribute15_o
223: => per_pms_shd.g_old_rec.attribute15
224: ,p_attribute16_o
225: => per_pms_shd.g_old_rec.attribute16
226: ,p_attribute17_o
227: => per_pms_shd.g_old_rec.attribute17
228: ,p_attribute18_o
229: => per_pms_shd.g_old_rec.attribute18

Line 227: => per_pms_shd.g_old_rec.attribute17

223: => per_pms_shd.g_old_rec.attribute15
224: ,p_attribute16_o
225: => per_pms_shd.g_old_rec.attribute16
226: ,p_attribute17_o
227: => per_pms_shd.g_old_rec.attribute17
228: ,p_attribute18_o
229: => per_pms_shd.g_old_rec.attribute18
230: ,p_attribute19_o
231: => per_pms_shd.g_old_rec.attribute19

Line 229: => per_pms_shd.g_old_rec.attribute18

225: => per_pms_shd.g_old_rec.attribute16
226: ,p_attribute17_o
227: => per_pms_shd.g_old_rec.attribute17
228: ,p_attribute18_o
229: => per_pms_shd.g_old_rec.attribute18
230: ,p_attribute19_o
231: => per_pms_shd.g_old_rec.attribute19
232: ,p_attribute20_o
233: => per_pms_shd.g_old_rec.attribute20

Line 231: => per_pms_shd.g_old_rec.attribute19

227: => per_pms_shd.g_old_rec.attribute17
228: ,p_attribute18_o
229: => per_pms_shd.g_old_rec.attribute18
230: ,p_attribute19_o
231: => per_pms_shd.g_old_rec.attribute19
232: ,p_attribute20_o
233: => per_pms_shd.g_old_rec.attribute20
234: ,p_attribute21_o
235: => per_pms_shd.g_old_rec.attribute21

Line 233: => per_pms_shd.g_old_rec.attribute20

229: => per_pms_shd.g_old_rec.attribute18
230: ,p_attribute19_o
231: => per_pms_shd.g_old_rec.attribute19
232: ,p_attribute20_o
233: => per_pms_shd.g_old_rec.attribute20
234: ,p_attribute21_o
235: => per_pms_shd.g_old_rec.attribute21
236: ,p_attribute22_o
237: => per_pms_shd.g_old_rec.attribute22

Line 235: => per_pms_shd.g_old_rec.attribute21

231: => per_pms_shd.g_old_rec.attribute19
232: ,p_attribute20_o
233: => per_pms_shd.g_old_rec.attribute20
234: ,p_attribute21_o
235: => per_pms_shd.g_old_rec.attribute21
236: ,p_attribute22_o
237: => per_pms_shd.g_old_rec.attribute22
238: ,p_attribute23_o
239: => per_pms_shd.g_old_rec.attribute23

Line 237: => per_pms_shd.g_old_rec.attribute22

233: => per_pms_shd.g_old_rec.attribute20
234: ,p_attribute21_o
235: => per_pms_shd.g_old_rec.attribute21
236: ,p_attribute22_o
237: => per_pms_shd.g_old_rec.attribute22
238: ,p_attribute23_o
239: => per_pms_shd.g_old_rec.attribute23
240: ,p_attribute24_o
241: => per_pms_shd.g_old_rec.attribute24

Line 239: => per_pms_shd.g_old_rec.attribute23

235: => per_pms_shd.g_old_rec.attribute21
236: ,p_attribute22_o
237: => per_pms_shd.g_old_rec.attribute22
238: ,p_attribute23_o
239: => per_pms_shd.g_old_rec.attribute23
240: ,p_attribute24_o
241: => per_pms_shd.g_old_rec.attribute24
242: ,p_attribute25_o
243: => per_pms_shd.g_old_rec.attribute25

Line 241: => per_pms_shd.g_old_rec.attribute24

237: => per_pms_shd.g_old_rec.attribute22
238: ,p_attribute23_o
239: => per_pms_shd.g_old_rec.attribute23
240: ,p_attribute24_o
241: => per_pms_shd.g_old_rec.attribute24
242: ,p_attribute25_o
243: => per_pms_shd.g_old_rec.attribute25
244: ,p_attribute26_o
245: => per_pms_shd.g_old_rec.attribute26

Line 243: => per_pms_shd.g_old_rec.attribute25

239: => per_pms_shd.g_old_rec.attribute23
240: ,p_attribute24_o
241: => per_pms_shd.g_old_rec.attribute24
242: ,p_attribute25_o
243: => per_pms_shd.g_old_rec.attribute25
244: ,p_attribute26_o
245: => per_pms_shd.g_old_rec.attribute26
246: ,p_attribute27_o
247: => per_pms_shd.g_old_rec.attribute27

Line 245: => per_pms_shd.g_old_rec.attribute26

241: => per_pms_shd.g_old_rec.attribute24
242: ,p_attribute25_o
243: => per_pms_shd.g_old_rec.attribute25
244: ,p_attribute26_o
245: => per_pms_shd.g_old_rec.attribute26
246: ,p_attribute27_o
247: => per_pms_shd.g_old_rec.attribute27
248: ,p_attribute28_o
249: => per_pms_shd.g_old_rec.attribute28

Line 247: => per_pms_shd.g_old_rec.attribute27

243: => per_pms_shd.g_old_rec.attribute25
244: ,p_attribute26_o
245: => per_pms_shd.g_old_rec.attribute26
246: ,p_attribute27_o
247: => per_pms_shd.g_old_rec.attribute27
248: ,p_attribute28_o
249: => per_pms_shd.g_old_rec.attribute28
250: ,p_attribute29_o
251: => per_pms_shd.g_old_rec.attribute29

Line 249: => per_pms_shd.g_old_rec.attribute28

245: => per_pms_shd.g_old_rec.attribute26
246: ,p_attribute27_o
247: => per_pms_shd.g_old_rec.attribute27
248: ,p_attribute28_o
249: => per_pms_shd.g_old_rec.attribute28
250: ,p_attribute29_o
251: => per_pms_shd.g_old_rec.attribute29
252: ,p_attribute30_o
253: => per_pms_shd.g_old_rec.attribute30

Line 251: => per_pms_shd.g_old_rec.attribute29

247: => per_pms_shd.g_old_rec.attribute27
248: ,p_attribute28_o
249: => per_pms_shd.g_old_rec.attribute28
250: ,p_attribute29_o
251: => per_pms_shd.g_old_rec.attribute29
252: ,p_attribute30_o
253: => per_pms_shd.g_old_rec.attribute30
254: );
255: --

Line 253: => per_pms_shd.g_old_rec.attribute30

249: => per_pms_shd.g_old_rec.attribute28
250: ,p_attribute29_o
251: => per_pms_shd.g_old_rec.attribute29
252: ,p_attribute30_o
253: => per_pms_shd.g_old_rec.attribute30
254: );
255: --
256: exception
257: --

Line 273: (p_rec in per_pms_shd.g_rec_type

269: -- ----------------------------------------------------------------------------
270: -- |---------------------------------< del >----------------------------------|
271: -- ----------------------------------------------------------------------------
272: Procedure del
273: (p_rec in per_pms_shd.g_rec_type
274: ,p_created_by_plan_warning out nocopy boolean
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';

Line 284: per_pms_shd.lck

280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to delete.
283: --
284: per_pms_shd.lck
285: (p_rec.scorecard_id
286: ,p_rec.object_version_number
287: );
288: --

Line 326: l_rec per_pms_shd.g_rec_type;

322: ,p_object_version_number in number
323: ,p_created_by_plan_warning out nocopy boolean
324: ) is
325: --
326: l_rec per_pms_shd.g_rec_type;
327: l_proc varchar2(72) := g_package||'del';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);