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_PGH_DEL dependencies on PER_PGH_SHD

Line 52: (p_rec in per_pgh_shd.g_rec_type

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

Line 75: per_pgh_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_pgh_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_pgh_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_pgh_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_pgh_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_pgh_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_pgh_shd.g_old_rec.business_group_id

164: per_pgh_rkd.after_delete
165: (p_hierarchy_id
166: => p_rec.hierarchy_id
167: ,p_business_group_id_o
168: => per_pgh_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pgh_shd.g_old_rec.name
171: ,p_type_o
172: => per_pgh_shd.g_old_rec.type

Line 170: => per_pgh_shd.g_old_rec.name

166: => p_rec.hierarchy_id
167: ,p_business_group_id_o
168: => per_pgh_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pgh_shd.g_old_rec.name
171: ,p_type_o
172: => per_pgh_shd.g_old_rec.type
173: ,p_request_id_o
174: => per_pgh_shd.g_old_rec.request_id

Line 172: => per_pgh_shd.g_old_rec.type

168: => per_pgh_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pgh_shd.g_old_rec.name
171: ,p_type_o
172: => per_pgh_shd.g_old_rec.type
173: ,p_request_id_o
174: => per_pgh_shd.g_old_rec.request_id
175: ,p_program_application_id_o
176: => per_pgh_shd.g_old_rec.program_application_id

Line 174: => per_pgh_shd.g_old_rec.request_id

170: => per_pgh_shd.g_old_rec.name
171: ,p_type_o
172: => per_pgh_shd.g_old_rec.type
173: ,p_request_id_o
174: => per_pgh_shd.g_old_rec.request_id
175: ,p_program_application_id_o
176: => per_pgh_shd.g_old_rec.program_application_id
177: ,p_program_id_o
178: => per_pgh_shd.g_old_rec.program_id

Line 176: => per_pgh_shd.g_old_rec.program_application_id

172: => per_pgh_shd.g_old_rec.type
173: ,p_request_id_o
174: => per_pgh_shd.g_old_rec.request_id
175: ,p_program_application_id_o
176: => per_pgh_shd.g_old_rec.program_application_id
177: ,p_program_id_o
178: => per_pgh_shd.g_old_rec.program_id
179: ,p_program_update_date_o
180: => per_pgh_shd.g_old_rec.program_update_date

Line 178: => per_pgh_shd.g_old_rec.program_id

174: => per_pgh_shd.g_old_rec.request_id
175: ,p_program_application_id_o
176: => per_pgh_shd.g_old_rec.program_application_id
177: ,p_program_id_o
178: => per_pgh_shd.g_old_rec.program_id
179: ,p_program_update_date_o
180: => per_pgh_shd.g_old_rec.program_update_date
181: ,p_object_version_number_o
182: => per_pgh_shd.g_old_rec.object_version_number

Line 180: => per_pgh_shd.g_old_rec.program_update_date

176: => per_pgh_shd.g_old_rec.program_application_id
177: ,p_program_id_o
178: => per_pgh_shd.g_old_rec.program_id
179: ,p_program_update_date_o
180: => per_pgh_shd.g_old_rec.program_update_date
181: ,p_object_version_number_o
182: => per_pgh_shd.g_old_rec.object_version_number
183: ,p_attribute_category_o
184: => per_pgh_shd.g_old_rec.attribute_category

Line 182: => per_pgh_shd.g_old_rec.object_version_number

178: => per_pgh_shd.g_old_rec.program_id
179: ,p_program_update_date_o
180: => per_pgh_shd.g_old_rec.program_update_date
181: ,p_object_version_number_o
182: => per_pgh_shd.g_old_rec.object_version_number
183: ,p_attribute_category_o
184: => per_pgh_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_pgh_shd.g_old_rec.attribute1

Line 184: => per_pgh_shd.g_old_rec.attribute_category

180: => per_pgh_shd.g_old_rec.program_update_date
181: ,p_object_version_number_o
182: => per_pgh_shd.g_old_rec.object_version_number
183: ,p_attribute_category_o
184: => per_pgh_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_pgh_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_pgh_shd.g_old_rec.attribute2

Line 186: => per_pgh_shd.g_old_rec.attribute1

182: => per_pgh_shd.g_old_rec.object_version_number
183: ,p_attribute_category_o
184: => per_pgh_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_pgh_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_pgh_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_pgh_shd.g_old_rec.attribute3

Line 188: => per_pgh_shd.g_old_rec.attribute2

184: => per_pgh_shd.g_old_rec.attribute_category
185: ,p_attribute1_o
186: => per_pgh_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_pgh_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_pgh_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_pgh_shd.g_old_rec.attribute4

Line 190: => per_pgh_shd.g_old_rec.attribute3

186: => per_pgh_shd.g_old_rec.attribute1
187: ,p_attribute2_o
188: => per_pgh_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_pgh_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_pgh_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_pgh_shd.g_old_rec.attribute5

Line 192: => per_pgh_shd.g_old_rec.attribute4

188: => per_pgh_shd.g_old_rec.attribute2
189: ,p_attribute3_o
190: => per_pgh_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_pgh_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_pgh_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_pgh_shd.g_old_rec.attribute6

Line 194: => per_pgh_shd.g_old_rec.attribute5

190: => per_pgh_shd.g_old_rec.attribute3
191: ,p_attribute4_o
192: => per_pgh_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_pgh_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_pgh_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_pgh_shd.g_old_rec.attribute7

Line 196: => per_pgh_shd.g_old_rec.attribute6

192: => per_pgh_shd.g_old_rec.attribute4
193: ,p_attribute5_o
194: => per_pgh_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_pgh_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_pgh_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_pgh_shd.g_old_rec.attribute8

Line 198: => per_pgh_shd.g_old_rec.attribute7

194: => per_pgh_shd.g_old_rec.attribute5
195: ,p_attribute6_o
196: => per_pgh_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_pgh_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_pgh_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_pgh_shd.g_old_rec.attribute9

Line 200: => per_pgh_shd.g_old_rec.attribute8

196: => per_pgh_shd.g_old_rec.attribute6
197: ,p_attribute7_o
198: => per_pgh_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_pgh_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_pgh_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_pgh_shd.g_old_rec.attribute10

Line 202: => per_pgh_shd.g_old_rec.attribute9

198: => per_pgh_shd.g_old_rec.attribute7
199: ,p_attribute8_o
200: => per_pgh_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_pgh_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_pgh_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_pgh_shd.g_old_rec.attribute11

Line 204: => per_pgh_shd.g_old_rec.attribute10

200: => per_pgh_shd.g_old_rec.attribute8
201: ,p_attribute9_o
202: => per_pgh_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_pgh_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_pgh_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_pgh_shd.g_old_rec.attribute12

Line 206: => per_pgh_shd.g_old_rec.attribute11

202: => per_pgh_shd.g_old_rec.attribute9
203: ,p_attribute10_o
204: => per_pgh_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_pgh_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_pgh_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_pgh_shd.g_old_rec.attribute13

Line 208: => per_pgh_shd.g_old_rec.attribute12

204: => per_pgh_shd.g_old_rec.attribute10
205: ,p_attribute11_o
206: => per_pgh_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_pgh_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_pgh_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_pgh_shd.g_old_rec.attribute14

Line 210: => per_pgh_shd.g_old_rec.attribute13

206: => per_pgh_shd.g_old_rec.attribute11
207: ,p_attribute12_o
208: => per_pgh_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_pgh_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_pgh_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_pgh_shd.g_old_rec.attribute15

Line 212: => per_pgh_shd.g_old_rec.attribute14

208: => per_pgh_shd.g_old_rec.attribute12
209: ,p_attribute13_o
210: => per_pgh_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_pgh_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_pgh_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_pgh_shd.g_old_rec.attribute16

Line 214: => per_pgh_shd.g_old_rec.attribute15

210: => per_pgh_shd.g_old_rec.attribute13
211: ,p_attribute14_o
212: => per_pgh_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_pgh_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_pgh_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_pgh_shd.g_old_rec.attribute17

Line 216: => per_pgh_shd.g_old_rec.attribute16

212: => per_pgh_shd.g_old_rec.attribute14
213: ,p_attribute15_o
214: => per_pgh_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_pgh_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_pgh_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_pgh_shd.g_old_rec.attribute18

Line 218: => per_pgh_shd.g_old_rec.attribute17

214: => per_pgh_shd.g_old_rec.attribute15
215: ,p_attribute16_o
216: => per_pgh_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_pgh_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_pgh_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_pgh_shd.g_old_rec.attribute19

Line 220: => per_pgh_shd.g_old_rec.attribute18

216: => per_pgh_shd.g_old_rec.attribute16
217: ,p_attribute17_o
218: => per_pgh_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_pgh_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_pgh_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_pgh_shd.g_old_rec.attribute20

Line 222: => per_pgh_shd.g_old_rec.attribute19

218: => per_pgh_shd.g_old_rec.attribute17
219: ,p_attribute18_o
220: => per_pgh_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_pgh_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_pgh_shd.g_old_rec.attribute20
225: ,p_attribute21_o
226: => per_pgh_shd.g_old_rec.attribute21

Line 224: => per_pgh_shd.g_old_rec.attribute20

220: => per_pgh_shd.g_old_rec.attribute18
221: ,p_attribute19_o
222: => per_pgh_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_pgh_shd.g_old_rec.attribute20
225: ,p_attribute21_o
226: => per_pgh_shd.g_old_rec.attribute21
227: ,p_attribute22_o
228: => per_pgh_shd.g_old_rec.attribute22

Line 226: => per_pgh_shd.g_old_rec.attribute21

222: => per_pgh_shd.g_old_rec.attribute19
223: ,p_attribute20_o
224: => per_pgh_shd.g_old_rec.attribute20
225: ,p_attribute21_o
226: => per_pgh_shd.g_old_rec.attribute21
227: ,p_attribute22_o
228: => per_pgh_shd.g_old_rec.attribute22
229: ,p_attribute23_o
230: => per_pgh_shd.g_old_rec.attribute23

Line 228: => per_pgh_shd.g_old_rec.attribute22

224: => per_pgh_shd.g_old_rec.attribute20
225: ,p_attribute21_o
226: => per_pgh_shd.g_old_rec.attribute21
227: ,p_attribute22_o
228: => per_pgh_shd.g_old_rec.attribute22
229: ,p_attribute23_o
230: => per_pgh_shd.g_old_rec.attribute23
231: ,p_attribute24_o
232: => per_pgh_shd.g_old_rec.attribute24

Line 230: => per_pgh_shd.g_old_rec.attribute23

226: => per_pgh_shd.g_old_rec.attribute21
227: ,p_attribute22_o
228: => per_pgh_shd.g_old_rec.attribute22
229: ,p_attribute23_o
230: => per_pgh_shd.g_old_rec.attribute23
231: ,p_attribute24_o
232: => per_pgh_shd.g_old_rec.attribute24
233: ,p_attribute25_o
234: => per_pgh_shd.g_old_rec.attribute25

Line 232: => per_pgh_shd.g_old_rec.attribute24

228: => per_pgh_shd.g_old_rec.attribute22
229: ,p_attribute23_o
230: => per_pgh_shd.g_old_rec.attribute23
231: ,p_attribute24_o
232: => per_pgh_shd.g_old_rec.attribute24
233: ,p_attribute25_o
234: => per_pgh_shd.g_old_rec.attribute25
235: ,p_attribute26_o
236: => per_pgh_shd.g_old_rec.attribute26

Line 234: => per_pgh_shd.g_old_rec.attribute25

230: => per_pgh_shd.g_old_rec.attribute23
231: ,p_attribute24_o
232: => per_pgh_shd.g_old_rec.attribute24
233: ,p_attribute25_o
234: => per_pgh_shd.g_old_rec.attribute25
235: ,p_attribute26_o
236: => per_pgh_shd.g_old_rec.attribute26
237: ,p_attribute27_o
238: => per_pgh_shd.g_old_rec.attribute27

Line 236: => per_pgh_shd.g_old_rec.attribute26

232: => per_pgh_shd.g_old_rec.attribute24
233: ,p_attribute25_o
234: => per_pgh_shd.g_old_rec.attribute25
235: ,p_attribute26_o
236: => per_pgh_shd.g_old_rec.attribute26
237: ,p_attribute27_o
238: => per_pgh_shd.g_old_rec.attribute27
239: ,p_attribute28_o
240: => per_pgh_shd.g_old_rec.attribute28

Line 238: => per_pgh_shd.g_old_rec.attribute27

234: => per_pgh_shd.g_old_rec.attribute25
235: ,p_attribute26_o
236: => per_pgh_shd.g_old_rec.attribute26
237: ,p_attribute27_o
238: => per_pgh_shd.g_old_rec.attribute27
239: ,p_attribute28_o
240: => per_pgh_shd.g_old_rec.attribute28
241: ,p_attribute29_o
242: => per_pgh_shd.g_old_rec.attribute29

Line 240: => per_pgh_shd.g_old_rec.attribute28

236: => per_pgh_shd.g_old_rec.attribute26
237: ,p_attribute27_o
238: => per_pgh_shd.g_old_rec.attribute27
239: ,p_attribute28_o
240: => per_pgh_shd.g_old_rec.attribute28
241: ,p_attribute29_o
242: => per_pgh_shd.g_old_rec.attribute29
243: ,p_attribute30_o
244: => per_pgh_shd.g_old_rec.attribute30

Line 242: => per_pgh_shd.g_old_rec.attribute29

238: => per_pgh_shd.g_old_rec.attribute27
239: ,p_attribute28_o
240: => per_pgh_shd.g_old_rec.attribute28
241: ,p_attribute29_o
242: => per_pgh_shd.g_old_rec.attribute29
243: ,p_attribute30_o
244: => per_pgh_shd.g_old_rec.attribute30
245: ,p_information_category_o
246: => per_pgh_shd.g_old_rec.information_category

Line 244: => per_pgh_shd.g_old_rec.attribute30

240: => per_pgh_shd.g_old_rec.attribute28
241: ,p_attribute29_o
242: => per_pgh_shd.g_old_rec.attribute29
243: ,p_attribute30_o
244: => per_pgh_shd.g_old_rec.attribute30
245: ,p_information_category_o
246: => per_pgh_shd.g_old_rec.information_category
247: ,p_information1_o
248: => per_pgh_shd.g_old_rec.information1

Line 246: => per_pgh_shd.g_old_rec.information_category

242: => per_pgh_shd.g_old_rec.attribute29
243: ,p_attribute30_o
244: => per_pgh_shd.g_old_rec.attribute30
245: ,p_information_category_o
246: => per_pgh_shd.g_old_rec.information_category
247: ,p_information1_o
248: => per_pgh_shd.g_old_rec.information1
249: ,p_information2_o
250: => per_pgh_shd.g_old_rec.information2

Line 248: => per_pgh_shd.g_old_rec.information1

244: => per_pgh_shd.g_old_rec.attribute30
245: ,p_information_category_o
246: => per_pgh_shd.g_old_rec.information_category
247: ,p_information1_o
248: => per_pgh_shd.g_old_rec.information1
249: ,p_information2_o
250: => per_pgh_shd.g_old_rec.information2
251: ,p_information3_o
252: => per_pgh_shd.g_old_rec.information3

Line 250: => per_pgh_shd.g_old_rec.information2

246: => per_pgh_shd.g_old_rec.information_category
247: ,p_information1_o
248: => per_pgh_shd.g_old_rec.information1
249: ,p_information2_o
250: => per_pgh_shd.g_old_rec.information2
251: ,p_information3_o
252: => per_pgh_shd.g_old_rec.information3
253: ,p_information4_o
254: => per_pgh_shd.g_old_rec.information4

Line 252: => per_pgh_shd.g_old_rec.information3

248: => per_pgh_shd.g_old_rec.information1
249: ,p_information2_o
250: => per_pgh_shd.g_old_rec.information2
251: ,p_information3_o
252: => per_pgh_shd.g_old_rec.information3
253: ,p_information4_o
254: => per_pgh_shd.g_old_rec.information4
255: ,p_information5_o
256: => per_pgh_shd.g_old_rec.information5

Line 254: => per_pgh_shd.g_old_rec.information4

250: => per_pgh_shd.g_old_rec.information2
251: ,p_information3_o
252: => per_pgh_shd.g_old_rec.information3
253: ,p_information4_o
254: => per_pgh_shd.g_old_rec.information4
255: ,p_information5_o
256: => per_pgh_shd.g_old_rec.information5
257: ,p_information6_o
258: => per_pgh_shd.g_old_rec.information6

Line 256: => per_pgh_shd.g_old_rec.information5

252: => per_pgh_shd.g_old_rec.information3
253: ,p_information4_o
254: => per_pgh_shd.g_old_rec.information4
255: ,p_information5_o
256: => per_pgh_shd.g_old_rec.information5
257: ,p_information6_o
258: => per_pgh_shd.g_old_rec.information6
259: ,p_information7_o
260: => per_pgh_shd.g_old_rec.information7

Line 258: => per_pgh_shd.g_old_rec.information6

254: => per_pgh_shd.g_old_rec.information4
255: ,p_information5_o
256: => per_pgh_shd.g_old_rec.information5
257: ,p_information6_o
258: => per_pgh_shd.g_old_rec.information6
259: ,p_information7_o
260: => per_pgh_shd.g_old_rec.information7
261: ,p_information8_o
262: => per_pgh_shd.g_old_rec.information8

Line 260: => per_pgh_shd.g_old_rec.information7

256: => per_pgh_shd.g_old_rec.information5
257: ,p_information6_o
258: => per_pgh_shd.g_old_rec.information6
259: ,p_information7_o
260: => per_pgh_shd.g_old_rec.information7
261: ,p_information8_o
262: => per_pgh_shd.g_old_rec.information8
263: ,p_information9_o
264: => per_pgh_shd.g_old_rec.information9

Line 262: => per_pgh_shd.g_old_rec.information8

258: => per_pgh_shd.g_old_rec.information6
259: ,p_information7_o
260: => per_pgh_shd.g_old_rec.information7
261: ,p_information8_o
262: => per_pgh_shd.g_old_rec.information8
263: ,p_information9_o
264: => per_pgh_shd.g_old_rec.information9
265: ,p_information10_o
266: => per_pgh_shd.g_old_rec.information10

Line 264: => per_pgh_shd.g_old_rec.information9

260: => per_pgh_shd.g_old_rec.information7
261: ,p_information8_o
262: => per_pgh_shd.g_old_rec.information8
263: ,p_information9_o
264: => per_pgh_shd.g_old_rec.information9
265: ,p_information10_o
266: => per_pgh_shd.g_old_rec.information10
267: ,p_information11_o
268: => per_pgh_shd.g_old_rec.information11

Line 266: => per_pgh_shd.g_old_rec.information10

262: => per_pgh_shd.g_old_rec.information8
263: ,p_information9_o
264: => per_pgh_shd.g_old_rec.information9
265: ,p_information10_o
266: => per_pgh_shd.g_old_rec.information10
267: ,p_information11_o
268: => per_pgh_shd.g_old_rec.information11
269: ,p_information12_o
270: => per_pgh_shd.g_old_rec.information12

Line 268: => per_pgh_shd.g_old_rec.information11

264: => per_pgh_shd.g_old_rec.information9
265: ,p_information10_o
266: => per_pgh_shd.g_old_rec.information10
267: ,p_information11_o
268: => per_pgh_shd.g_old_rec.information11
269: ,p_information12_o
270: => per_pgh_shd.g_old_rec.information12
271: ,p_information13_o
272: => per_pgh_shd.g_old_rec.information13

Line 270: => per_pgh_shd.g_old_rec.information12

266: => per_pgh_shd.g_old_rec.information10
267: ,p_information11_o
268: => per_pgh_shd.g_old_rec.information11
269: ,p_information12_o
270: => per_pgh_shd.g_old_rec.information12
271: ,p_information13_o
272: => per_pgh_shd.g_old_rec.information13
273: ,p_information14_o
274: => per_pgh_shd.g_old_rec.information14

Line 272: => per_pgh_shd.g_old_rec.information13

268: => per_pgh_shd.g_old_rec.information11
269: ,p_information12_o
270: => per_pgh_shd.g_old_rec.information12
271: ,p_information13_o
272: => per_pgh_shd.g_old_rec.information13
273: ,p_information14_o
274: => per_pgh_shd.g_old_rec.information14
275: ,p_information15_o
276: => per_pgh_shd.g_old_rec.information15

Line 274: => per_pgh_shd.g_old_rec.information14

270: => per_pgh_shd.g_old_rec.information12
271: ,p_information13_o
272: => per_pgh_shd.g_old_rec.information13
273: ,p_information14_o
274: => per_pgh_shd.g_old_rec.information14
275: ,p_information15_o
276: => per_pgh_shd.g_old_rec.information15
277: ,p_information16_o
278: => per_pgh_shd.g_old_rec.information16

Line 276: => per_pgh_shd.g_old_rec.information15

272: => per_pgh_shd.g_old_rec.information13
273: ,p_information14_o
274: => per_pgh_shd.g_old_rec.information14
275: ,p_information15_o
276: => per_pgh_shd.g_old_rec.information15
277: ,p_information16_o
278: => per_pgh_shd.g_old_rec.information16
279: ,p_information17_o
280: => per_pgh_shd.g_old_rec.information17

Line 278: => per_pgh_shd.g_old_rec.information16

274: => per_pgh_shd.g_old_rec.information14
275: ,p_information15_o
276: => per_pgh_shd.g_old_rec.information15
277: ,p_information16_o
278: => per_pgh_shd.g_old_rec.information16
279: ,p_information17_o
280: => per_pgh_shd.g_old_rec.information17
281: ,p_information18_o
282: => per_pgh_shd.g_old_rec.information18

Line 280: => per_pgh_shd.g_old_rec.information17

276: => per_pgh_shd.g_old_rec.information15
277: ,p_information16_o
278: => per_pgh_shd.g_old_rec.information16
279: ,p_information17_o
280: => per_pgh_shd.g_old_rec.information17
281: ,p_information18_o
282: => per_pgh_shd.g_old_rec.information18
283: ,p_information19_o
284: => per_pgh_shd.g_old_rec.information19

Line 282: => per_pgh_shd.g_old_rec.information18

278: => per_pgh_shd.g_old_rec.information16
279: ,p_information17_o
280: => per_pgh_shd.g_old_rec.information17
281: ,p_information18_o
282: => per_pgh_shd.g_old_rec.information18
283: ,p_information19_o
284: => per_pgh_shd.g_old_rec.information19
285: ,p_information20_o
286: => per_pgh_shd.g_old_rec.information20

Line 284: => per_pgh_shd.g_old_rec.information19

280: => per_pgh_shd.g_old_rec.information17
281: ,p_information18_o
282: => per_pgh_shd.g_old_rec.information18
283: ,p_information19_o
284: => per_pgh_shd.g_old_rec.information19
285: ,p_information20_o
286: => per_pgh_shd.g_old_rec.information20
287: ,p_information21_o
288: => per_pgh_shd.g_old_rec.information21

Line 286: => per_pgh_shd.g_old_rec.information20

282: => per_pgh_shd.g_old_rec.information18
283: ,p_information19_o
284: => per_pgh_shd.g_old_rec.information19
285: ,p_information20_o
286: => per_pgh_shd.g_old_rec.information20
287: ,p_information21_o
288: => per_pgh_shd.g_old_rec.information21
289: ,p_information22_o
290: => per_pgh_shd.g_old_rec.information22

Line 288: => per_pgh_shd.g_old_rec.information21

284: => per_pgh_shd.g_old_rec.information19
285: ,p_information20_o
286: => per_pgh_shd.g_old_rec.information20
287: ,p_information21_o
288: => per_pgh_shd.g_old_rec.information21
289: ,p_information22_o
290: => per_pgh_shd.g_old_rec.information22
291: ,p_information23_o
292: => per_pgh_shd.g_old_rec.information23

Line 290: => per_pgh_shd.g_old_rec.information22

286: => per_pgh_shd.g_old_rec.information20
287: ,p_information21_o
288: => per_pgh_shd.g_old_rec.information21
289: ,p_information22_o
290: => per_pgh_shd.g_old_rec.information22
291: ,p_information23_o
292: => per_pgh_shd.g_old_rec.information23
293: ,p_information24_o
294: => per_pgh_shd.g_old_rec.information24

Line 292: => per_pgh_shd.g_old_rec.information23

288: => per_pgh_shd.g_old_rec.information21
289: ,p_information22_o
290: => per_pgh_shd.g_old_rec.information22
291: ,p_information23_o
292: => per_pgh_shd.g_old_rec.information23
293: ,p_information24_o
294: => per_pgh_shd.g_old_rec.information24
295: ,p_information25_o
296: => per_pgh_shd.g_old_rec.information25

Line 294: => per_pgh_shd.g_old_rec.information24

290: => per_pgh_shd.g_old_rec.information22
291: ,p_information23_o
292: => per_pgh_shd.g_old_rec.information23
293: ,p_information24_o
294: => per_pgh_shd.g_old_rec.information24
295: ,p_information25_o
296: => per_pgh_shd.g_old_rec.information25
297: ,p_information26_o
298: => per_pgh_shd.g_old_rec.information26

Line 296: => per_pgh_shd.g_old_rec.information25

292: => per_pgh_shd.g_old_rec.information23
293: ,p_information24_o
294: => per_pgh_shd.g_old_rec.information24
295: ,p_information25_o
296: => per_pgh_shd.g_old_rec.information25
297: ,p_information26_o
298: => per_pgh_shd.g_old_rec.information26
299: ,p_information27_o
300: => per_pgh_shd.g_old_rec.information27

Line 298: => per_pgh_shd.g_old_rec.information26

294: => per_pgh_shd.g_old_rec.information24
295: ,p_information25_o
296: => per_pgh_shd.g_old_rec.information25
297: ,p_information26_o
298: => per_pgh_shd.g_old_rec.information26
299: ,p_information27_o
300: => per_pgh_shd.g_old_rec.information27
301: ,p_information28_o
302: => per_pgh_shd.g_old_rec.information28

Line 300: => per_pgh_shd.g_old_rec.information27

296: => per_pgh_shd.g_old_rec.information25
297: ,p_information26_o
298: => per_pgh_shd.g_old_rec.information26
299: ,p_information27_o
300: => per_pgh_shd.g_old_rec.information27
301: ,p_information28_o
302: => per_pgh_shd.g_old_rec.information28
303: ,p_information29_o
304: => per_pgh_shd.g_old_rec.information29

Line 302: => per_pgh_shd.g_old_rec.information28

298: => per_pgh_shd.g_old_rec.information26
299: ,p_information27_o
300: => per_pgh_shd.g_old_rec.information27
301: ,p_information28_o
302: => per_pgh_shd.g_old_rec.information28
303: ,p_information29_o
304: => per_pgh_shd.g_old_rec.information29
305: ,p_information30_o
306: => per_pgh_shd.g_old_rec.information30

Line 304: => per_pgh_shd.g_old_rec.information29

300: => per_pgh_shd.g_old_rec.information27
301: ,p_information28_o
302: => per_pgh_shd.g_old_rec.information28
303: ,p_information29_o
304: => per_pgh_shd.g_old_rec.information29
305: ,p_information30_o
306: => per_pgh_shd.g_old_rec.information30
307: );
308: --

Line 306: => per_pgh_shd.g_old_rec.information30

302: => per_pgh_shd.g_old_rec.information28
303: ,p_information29_o
304: => per_pgh_shd.g_old_rec.information29
305: ,p_information30_o
306: => per_pgh_shd.g_old_rec.information30
307: );
308: --
309: exception
310: --

Line 326: (p_rec in per_pgh_shd.g_rec_type

322: -- ----------------------------------------------------------------------------
323: -- |---------------------------------< del >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure del
326: (p_rec in per_pgh_shd.g_rec_type
327: ) is
328: --
329: l_proc varchar2(72) := g_package||'del';
330: --

Line 336: per_pgh_shd.lck

332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- We must lock the row which we need to delete.
335: --
336: per_pgh_shd.lck
337: (p_rec.hierarchy_id
338: ,p_rec.object_version_number
339: );
340: --

Line 367: l_rec per_pgh_shd.g_rec_type;

363: (p_hierarchy_id in number
364: ,p_object_version_number in number
365: ) is
366: --
367: l_rec per_pgh_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'del';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);