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_PMA_DEL dependencies on PER_PMA_SHD

Line 52: (p_rec in per_pma_shd.g_rec_type

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

Line 75: per_pma_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_pma_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_pma_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_pma_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_pma_shd.g_rec_type) is

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

Line 168: => per_pma_shd.g_old_rec.object_version_number

164: per_pma_rkd.after_delete
165: (p_appraisal_period_id
166: => p_rec.appraisal_period_id
167: ,p_object_version_number_o
168: => per_pma_shd.g_old_rec.object_version_number
169: ,p_plan_id_o
170: => per_pma_shd.g_old_rec.plan_id
171: ,p_appraisal_template_id_o
172: => per_pma_shd.g_old_rec.appraisal_template_id

Line 170: => per_pma_shd.g_old_rec.plan_id

166: => p_rec.appraisal_period_id
167: ,p_object_version_number_o
168: => per_pma_shd.g_old_rec.object_version_number
169: ,p_plan_id_o
170: => per_pma_shd.g_old_rec.plan_id
171: ,p_appraisal_template_id_o
172: => per_pma_shd.g_old_rec.appraisal_template_id
173: ,p_start_date_o
174: => per_pma_shd.g_old_rec.start_date

Line 172: => per_pma_shd.g_old_rec.appraisal_template_id

168: => per_pma_shd.g_old_rec.object_version_number
169: ,p_plan_id_o
170: => per_pma_shd.g_old_rec.plan_id
171: ,p_appraisal_template_id_o
172: => per_pma_shd.g_old_rec.appraisal_template_id
173: ,p_start_date_o
174: => per_pma_shd.g_old_rec.start_date
175: ,p_end_date_o
176: => per_pma_shd.g_old_rec.end_date

Line 174: => per_pma_shd.g_old_rec.start_date

170: => per_pma_shd.g_old_rec.plan_id
171: ,p_appraisal_template_id_o
172: => per_pma_shd.g_old_rec.appraisal_template_id
173: ,p_start_date_o
174: => per_pma_shd.g_old_rec.start_date
175: ,p_end_date_o
176: => per_pma_shd.g_old_rec.end_date
177: ,p_task_start_date_o
178: => per_pma_shd.g_old_rec.task_start_date

Line 176: => per_pma_shd.g_old_rec.end_date

172: => per_pma_shd.g_old_rec.appraisal_template_id
173: ,p_start_date_o
174: => per_pma_shd.g_old_rec.start_date
175: ,p_end_date_o
176: => per_pma_shd.g_old_rec.end_date
177: ,p_task_start_date_o
178: => per_pma_shd.g_old_rec.task_start_date
179: ,p_task_end_date_o
180: => per_pma_shd.g_old_rec.task_end_date

Line 178: => per_pma_shd.g_old_rec.task_start_date

174: => per_pma_shd.g_old_rec.start_date
175: ,p_end_date_o
176: => per_pma_shd.g_old_rec.end_date
177: ,p_task_start_date_o
178: => per_pma_shd.g_old_rec.task_start_date
179: ,p_task_end_date_o
180: => per_pma_shd.g_old_rec.task_end_date
181: ,p_initiator_code_o
182: => per_pma_shd.g_old_rec.initiator_code

Line 180: => per_pma_shd.g_old_rec.task_end_date

176: => per_pma_shd.g_old_rec.end_date
177: ,p_task_start_date_o
178: => per_pma_shd.g_old_rec.task_start_date
179: ,p_task_end_date_o
180: => per_pma_shd.g_old_rec.task_end_date
181: ,p_initiator_code_o
182: => per_pma_shd.g_old_rec.initiator_code
183: ,p_appraisal_system_type_o
184: => per_pma_shd.g_old_rec.appraisal_system_type

Line 182: => per_pma_shd.g_old_rec.initiator_code

178: => per_pma_shd.g_old_rec.task_start_date
179: ,p_task_end_date_o
180: => per_pma_shd.g_old_rec.task_end_date
181: ,p_initiator_code_o
182: => per_pma_shd.g_old_rec.initiator_code
183: ,p_appraisal_system_type_o
184: => per_pma_shd.g_old_rec.appraisal_system_type
185: ,p_appraisal_type_o
186: => per_pma_shd.g_old_rec.appraisal_type

Line 184: => per_pma_shd.g_old_rec.appraisal_system_type

180: => per_pma_shd.g_old_rec.task_end_date
181: ,p_initiator_code_o
182: => per_pma_shd.g_old_rec.initiator_code
183: ,p_appraisal_system_type_o
184: => per_pma_shd.g_old_rec.appraisal_system_type
185: ,p_appraisal_type_o
186: => per_pma_shd.g_old_rec.appraisal_type
187: ,p_appraisal_assmt_status_o
188: => per_pma_shd.g_old_rec.appraisal_assmt_status

Line 186: => per_pma_shd.g_old_rec.appraisal_type

182: => per_pma_shd.g_old_rec.initiator_code
183: ,p_appraisal_system_type_o
184: => per_pma_shd.g_old_rec.appraisal_system_type
185: ,p_appraisal_type_o
186: => per_pma_shd.g_old_rec.appraisal_type
187: ,p_appraisal_assmt_status_o
188: => per_pma_shd.g_old_rec.appraisal_assmt_status
189: ,p_auto_conc_process_o
190: => per_pma_shd.g_old_rec.auto_conc_process

Line 188: => per_pma_shd.g_old_rec.appraisal_assmt_status

184: => per_pma_shd.g_old_rec.appraisal_system_type
185: ,p_appraisal_type_o
186: => per_pma_shd.g_old_rec.appraisal_type
187: ,p_appraisal_assmt_status_o
188: => per_pma_shd.g_old_rec.appraisal_assmt_status
189: ,p_auto_conc_process_o
190: => per_pma_shd.g_old_rec.auto_conc_process
191: ,p_days_before_task_st_dt_o
192: => per_pma_shd.g_old_rec.days_before_task_st_dt

Line 190: => per_pma_shd.g_old_rec.auto_conc_process

186: => per_pma_shd.g_old_rec.appraisal_type
187: ,p_appraisal_assmt_status_o
188: => per_pma_shd.g_old_rec.appraisal_assmt_status
189: ,p_auto_conc_process_o
190: => per_pma_shd.g_old_rec.auto_conc_process
191: ,p_days_before_task_st_dt_o
192: => per_pma_shd.g_old_rec.days_before_task_st_dt
193: ,p_attribute_category_o
194: => per_pma_shd.g_old_rec.attribute_category

Line 192: => per_pma_shd.g_old_rec.days_before_task_st_dt

188: => per_pma_shd.g_old_rec.appraisal_assmt_status
189: ,p_auto_conc_process_o
190: => per_pma_shd.g_old_rec.auto_conc_process
191: ,p_days_before_task_st_dt_o
192: => per_pma_shd.g_old_rec.days_before_task_st_dt
193: ,p_attribute_category_o
194: => per_pma_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => per_pma_shd.g_old_rec.attribute1

Line 194: => per_pma_shd.g_old_rec.attribute_category

190: => per_pma_shd.g_old_rec.auto_conc_process
191: ,p_days_before_task_st_dt_o
192: => per_pma_shd.g_old_rec.days_before_task_st_dt
193: ,p_attribute_category_o
194: => per_pma_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => per_pma_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => per_pma_shd.g_old_rec.attribute2

Line 196: => per_pma_shd.g_old_rec.attribute1

192: => per_pma_shd.g_old_rec.days_before_task_st_dt
193: ,p_attribute_category_o
194: => per_pma_shd.g_old_rec.attribute_category
195: ,p_attribute1_o
196: => per_pma_shd.g_old_rec.attribute1
197: ,p_attribute2_o
198: => per_pma_shd.g_old_rec.attribute2
199: ,p_attribute3_o
200: => per_pma_shd.g_old_rec.attribute3

Line 198: => per_pma_shd.g_old_rec.attribute2

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

Line 200: => per_pma_shd.g_old_rec.attribute3

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

Line 202: => per_pma_shd.g_old_rec.attribute4

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

Line 204: => per_pma_shd.g_old_rec.attribute5

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

Line 206: => per_pma_shd.g_old_rec.attribute6

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

Line 208: => per_pma_shd.g_old_rec.attribute7

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

Line 210: => per_pma_shd.g_old_rec.attribute8

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

Line 212: => per_pma_shd.g_old_rec.attribute9

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

Line 214: => per_pma_shd.g_old_rec.attribute10

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

Line 216: => per_pma_shd.g_old_rec.attribute11

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

Line 218: => per_pma_shd.g_old_rec.attribute12

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

Line 220: => per_pma_shd.g_old_rec.attribute13

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

Line 222: => per_pma_shd.g_old_rec.attribute14

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

Line 224: => per_pma_shd.g_old_rec.attribute15

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

Line 226: => per_pma_shd.g_old_rec.attribute16

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

Line 228: => per_pma_shd.g_old_rec.attribute17

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

Line 230: => per_pma_shd.g_old_rec.attribute18

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

Line 232: => per_pma_shd.g_old_rec.attribute19

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

Line 234: => per_pma_shd.g_old_rec.attribute20

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

Line 236: => per_pma_shd.g_old_rec.attribute21

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

Line 238: => per_pma_shd.g_old_rec.attribute22

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

Line 240: => per_pma_shd.g_old_rec.attribute23

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

Line 242: => per_pma_shd.g_old_rec.attribute24

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

Line 244: => per_pma_shd.g_old_rec.attribute25

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

Line 246: => per_pma_shd.g_old_rec.attribute26

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

Line 248: => per_pma_shd.g_old_rec.attribute27

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

Line 250: => per_pma_shd.g_old_rec.attribute28

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

Line 252: => per_pma_shd.g_old_rec.attribute29

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

Line 254: => per_pma_shd.g_old_rec.attribute30

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

Line 274: (p_rec in per_pma_shd.g_rec_type

270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------< del >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure del
274: (p_rec in per_pma_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';
278: --

Line 284: per_pma_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_pma_shd.lck
285: (p_rec.appraisal_period_id
286: ,p_rec.object_version_number
287: );
288: --

Line 321: l_rec per_pma_shd.g_rec_type;

317: (p_appraisal_period_id in number
318: ,p_object_version_number in number
319: ) is
320: --
321: l_rec per_pma_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'del';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);