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_PGN_DEL dependencies on PER_PGN_SHD

Line 52: (p_rec in per_pgn_shd.g_rec_type

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

Line 75: per_pgn_shd.constraint_error

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

Line 168: => per_pgn_shd.g_old_rec.business_group_id

164: per_pgn_rkd.after_delete
165: (p_hierarchy_node_id
166: => p_rec.hierarchy_node_id
167: ,p_business_group_id_o
168: => per_pgn_shd.g_old_rec.business_group_id
169: ,p_entity_id_o
170: => per_pgn_shd.g_old_rec.entity_id
171: ,p_hierarchy_version_id_o
172: => per_pgn_shd.g_old_rec.hierarchy_version_id

Line 170: => per_pgn_shd.g_old_rec.entity_id

166: => p_rec.hierarchy_node_id
167: ,p_business_group_id_o
168: => per_pgn_shd.g_old_rec.business_group_id
169: ,p_entity_id_o
170: => per_pgn_shd.g_old_rec.entity_id
171: ,p_hierarchy_version_id_o
172: => per_pgn_shd.g_old_rec.hierarchy_version_id
173: ,p_node_type_o
174: => per_pgn_shd.g_old_rec.node_type

Line 172: => per_pgn_shd.g_old_rec.hierarchy_version_id

168: => per_pgn_shd.g_old_rec.business_group_id
169: ,p_entity_id_o
170: => per_pgn_shd.g_old_rec.entity_id
171: ,p_hierarchy_version_id_o
172: => per_pgn_shd.g_old_rec.hierarchy_version_id
173: ,p_node_type_o
174: => per_pgn_shd.g_old_rec.node_type
175: ,p_seq_o
176: => per_pgn_shd.g_old_rec.seq

Line 174: => per_pgn_shd.g_old_rec.node_type

170: => per_pgn_shd.g_old_rec.entity_id
171: ,p_hierarchy_version_id_o
172: => per_pgn_shd.g_old_rec.hierarchy_version_id
173: ,p_node_type_o
174: => per_pgn_shd.g_old_rec.node_type
175: ,p_seq_o
176: => per_pgn_shd.g_old_rec.seq
177: ,p_parent_hierarchy_node_id_o
178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id

Line 176: => per_pgn_shd.g_old_rec.seq

172: => per_pgn_shd.g_old_rec.hierarchy_version_id
173: ,p_node_type_o
174: => per_pgn_shd.g_old_rec.node_type
175: ,p_seq_o
176: => per_pgn_shd.g_old_rec.seq
177: ,p_parent_hierarchy_node_id_o
178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id
179: ,p_request_id_o
180: => per_pgn_shd.g_old_rec.request_id

Line 178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id

174: => per_pgn_shd.g_old_rec.node_type
175: ,p_seq_o
176: => per_pgn_shd.g_old_rec.seq
177: ,p_parent_hierarchy_node_id_o
178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id
179: ,p_request_id_o
180: => per_pgn_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pgn_shd.g_old_rec.program_application_id

Line 180: => per_pgn_shd.g_old_rec.request_id

176: => per_pgn_shd.g_old_rec.seq
177: ,p_parent_hierarchy_node_id_o
178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id
179: ,p_request_id_o
180: => per_pgn_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pgn_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pgn_shd.g_old_rec.program_id

Line 182: => per_pgn_shd.g_old_rec.program_application_id

178: => per_pgn_shd.g_old_rec.parent_hierarchy_node_id
179: ,p_request_id_o
180: => per_pgn_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pgn_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pgn_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pgn_shd.g_old_rec.program_update_date

Line 184: => per_pgn_shd.g_old_rec.program_id

180: => per_pgn_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pgn_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pgn_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pgn_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_pgn_shd.g_old_rec.object_version_number

Line 186: => per_pgn_shd.g_old_rec.program_update_date

182: => per_pgn_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pgn_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pgn_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_pgn_shd.g_old_rec.object_version_number
189: ,p_attribute_category_o
190: => per_pgn_shd.g_old_rec.attribute_category

Line 188: => per_pgn_shd.g_old_rec.object_version_number

184: => per_pgn_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pgn_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_pgn_shd.g_old_rec.object_version_number
189: ,p_attribute_category_o
190: => per_pgn_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_pgn_shd.g_old_rec.attribute1

Line 190: => per_pgn_shd.g_old_rec.attribute_category

186: => per_pgn_shd.g_old_rec.program_update_date
187: ,p_object_version_number_o
188: => per_pgn_shd.g_old_rec.object_version_number
189: ,p_attribute_category_o
190: => per_pgn_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_pgn_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_pgn_shd.g_old_rec.attribute2

Line 192: => per_pgn_shd.g_old_rec.attribute1

188: => per_pgn_shd.g_old_rec.object_version_number
189: ,p_attribute_category_o
190: => per_pgn_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_pgn_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_pgn_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_pgn_shd.g_old_rec.attribute3

Line 194: => per_pgn_shd.g_old_rec.attribute2

190: => per_pgn_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => per_pgn_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_pgn_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_pgn_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_pgn_shd.g_old_rec.attribute4

Line 196: => per_pgn_shd.g_old_rec.attribute3

192: => per_pgn_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => per_pgn_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_pgn_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_pgn_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_pgn_shd.g_old_rec.attribute5

Line 198: => per_pgn_shd.g_old_rec.attribute4

194: => per_pgn_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => per_pgn_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_pgn_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_pgn_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_pgn_shd.g_old_rec.attribute6

Line 200: => per_pgn_shd.g_old_rec.attribute5

196: => per_pgn_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => per_pgn_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_pgn_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_pgn_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_pgn_shd.g_old_rec.attribute7

Line 202: => per_pgn_shd.g_old_rec.attribute6

198: => per_pgn_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => per_pgn_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_pgn_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_pgn_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_pgn_shd.g_old_rec.attribute8

Line 204: => per_pgn_shd.g_old_rec.attribute7

200: => per_pgn_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => per_pgn_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_pgn_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_pgn_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_pgn_shd.g_old_rec.attribute9

Line 206: => per_pgn_shd.g_old_rec.attribute8

202: => per_pgn_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => per_pgn_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_pgn_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_pgn_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_pgn_shd.g_old_rec.attribute10

Line 208: => per_pgn_shd.g_old_rec.attribute9

204: => per_pgn_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => per_pgn_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_pgn_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_pgn_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_pgn_shd.g_old_rec.attribute11

Line 210: => per_pgn_shd.g_old_rec.attribute10

206: => per_pgn_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => per_pgn_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_pgn_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_pgn_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_pgn_shd.g_old_rec.attribute12

Line 212: => per_pgn_shd.g_old_rec.attribute11

208: => per_pgn_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => per_pgn_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_pgn_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_pgn_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_pgn_shd.g_old_rec.attribute13

Line 214: => per_pgn_shd.g_old_rec.attribute12

210: => per_pgn_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => per_pgn_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_pgn_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_pgn_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_pgn_shd.g_old_rec.attribute14

Line 216: => per_pgn_shd.g_old_rec.attribute13

212: => per_pgn_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => per_pgn_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_pgn_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_pgn_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_pgn_shd.g_old_rec.attribute15

Line 218: => per_pgn_shd.g_old_rec.attribute14

214: => per_pgn_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => per_pgn_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_pgn_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_pgn_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_pgn_shd.g_old_rec.attribute16

Line 220: => per_pgn_shd.g_old_rec.attribute15

216: => per_pgn_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => per_pgn_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_pgn_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_pgn_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_pgn_shd.g_old_rec.attribute17

Line 222: => per_pgn_shd.g_old_rec.attribute16

218: => per_pgn_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => per_pgn_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_pgn_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_pgn_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_pgn_shd.g_old_rec.attribute18

Line 224: => per_pgn_shd.g_old_rec.attribute17

220: => per_pgn_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => per_pgn_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_pgn_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_pgn_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_pgn_shd.g_old_rec.attribute19

Line 226: => per_pgn_shd.g_old_rec.attribute18

222: => per_pgn_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => per_pgn_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_pgn_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_pgn_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_pgn_shd.g_old_rec.attribute20

Line 228: => per_pgn_shd.g_old_rec.attribute19

224: => per_pgn_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => per_pgn_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_pgn_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_pgn_shd.g_old_rec.attribute20
231: ,p_attribute21_o
232: => per_pgn_shd.g_old_rec.attribute21

Line 230: => per_pgn_shd.g_old_rec.attribute20

226: => per_pgn_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => per_pgn_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_pgn_shd.g_old_rec.attribute20
231: ,p_attribute21_o
232: => per_pgn_shd.g_old_rec.attribute21
233: ,p_attribute22_o
234: => per_pgn_shd.g_old_rec.attribute22

Line 232: => per_pgn_shd.g_old_rec.attribute21

228: => per_pgn_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => per_pgn_shd.g_old_rec.attribute20
231: ,p_attribute21_o
232: => per_pgn_shd.g_old_rec.attribute21
233: ,p_attribute22_o
234: => per_pgn_shd.g_old_rec.attribute22
235: ,p_attribute23_o
236: => per_pgn_shd.g_old_rec.attribute23

Line 234: => per_pgn_shd.g_old_rec.attribute22

230: => per_pgn_shd.g_old_rec.attribute20
231: ,p_attribute21_o
232: => per_pgn_shd.g_old_rec.attribute21
233: ,p_attribute22_o
234: => per_pgn_shd.g_old_rec.attribute22
235: ,p_attribute23_o
236: => per_pgn_shd.g_old_rec.attribute23
237: ,p_attribute24_o
238: => per_pgn_shd.g_old_rec.attribute24

Line 236: => per_pgn_shd.g_old_rec.attribute23

232: => per_pgn_shd.g_old_rec.attribute21
233: ,p_attribute22_o
234: => per_pgn_shd.g_old_rec.attribute22
235: ,p_attribute23_o
236: => per_pgn_shd.g_old_rec.attribute23
237: ,p_attribute24_o
238: => per_pgn_shd.g_old_rec.attribute24
239: ,p_attribute25_o
240: => per_pgn_shd.g_old_rec.attribute25

Line 238: => per_pgn_shd.g_old_rec.attribute24

234: => per_pgn_shd.g_old_rec.attribute22
235: ,p_attribute23_o
236: => per_pgn_shd.g_old_rec.attribute23
237: ,p_attribute24_o
238: => per_pgn_shd.g_old_rec.attribute24
239: ,p_attribute25_o
240: => per_pgn_shd.g_old_rec.attribute25
241: ,p_attribute26_o
242: => per_pgn_shd.g_old_rec.attribute26

Line 240: => per_pgn_shd.g_old_rec.attribute25

236: => per_pgn_shd.g_old_rec.attribute23
237: ,p_attribute24_o
238: => per_pgn_shd.g_old_rec.attribute24
239: ,p_attribute25_o
240: => per_pgn_shd.g_old_rec.attribute25
241: ,p_attribute26_o
242: => per_pgn_shd.g_old_rec.attribute26
243: ,p_attribute27_o
244: => per_pgn_shd.g_old_rec.attribute27

Line 242: => per_pgn_shd.g_old_rec.attribute26

238: => per_pgn_shd.g_old_rec.attribute24
239: ,p_attribute25_o
240: => per_pgn_shd.g_old_rec.attribute25
241: ,p_attribute26_o
242: => per_pgn_shd.g_old_rec.attribute26
243: ,p_attribute27_o
244: => per_pgn_shd.g_old_rec.attribute27
245: ,p_attribute28_o
246: => per_pgn_shd.g_old_rec.attribute28

Line 244: => per_pgn_shd.g_old_rec.attribute27

240: => per_pgn_shd.g_old_rec.attribute25
241: ,p_attribute26_o
242: => per_pgn_shd.g_old_rec.attribute26
243: ,p_attribute27_o
244: => per_pgn_shd.g_old_rec.attribute27
245: ,p_attribute28_o
246: => per_pgn_shd.g_old_rec.attribute28
247: ,p_attribute29_o
248: => per_pgn_shd.g_old_rec.attribute29

Line 246: => per_pgn_shd.g_old_rec.attribute28

242: => per_pgn_shd.g_old_rec.attribute26
243: ,p_attribute27_o
244: => per_pgn_shd.g_old_rec.attribute27
245: ,p_attribute28_o
246: => per_pgn_shd.g_old_rec.attribute28
247: ,p_attribute29_o
248: => per_pgn_shd.g_old_rec.attribute29
249: ,p_attribute30_o
250: => per_pgn_shd.g_old_rec.attribute30

Line 248: => per_pgn_shd.g_old_rec.attribute29

244: => per_pgn_shd.g_old_rec.attribute27
245: ,p_attribute28_o
246: => per_pgn_shd.g_old_rec.attribute28
247: ,p_attribute29_o
248: => per_pgn_shd.g_old_rec.attribute29
249: ,p_attribute30_o
250: => per_pgn_shd.g_old_rec.attribute30
251: ,p_information_category_o
252: => per_pgn_shd.g_old_rec.information_category

Line 250: => per_pgn_shd.g_old_rec.attribute30

246: => per_pgn_shd.g_old_rec.attribute28
247: ,p_attribute29_o
248: => per_pgn_shd.g_old_rec.attribute29
249: ,p_attribute30_o
250: => per_pgn_shd.g_old_rec.attribute30
251: ,p_information_category_o
252: => per_pgn_shd.g_old_rec.information_category
253: ,p_information1_o
254: => per_pgn_shd.g_old_rec.information1

Line 252: => per_pgn_shd.g_old_rec.information_category

248: => per_pgn_shd.g_old_rec.attribute29
249: ,p_attribute30_o
250: => per_pgn_shd.g_old_rec.attribute30
251: ,p_information_category_o
252: => per_pgn_shd.g_old_rec.information_category
253: ,p_information1_o
254: => per_pgn_shd.g_old_rec.information1
255: ,p_information2_o
256: => per_pgn_shd.g_old_rec.information2

Line 254: => per_pgn_shd.g_old_rec.information1

250: => per_pgn_shd.g_old_rec.attribute30
251: ,p_information_category_o
252: => per_pgn_shd.g_old_rec.information_category
253: ,p_information1_o
254: => per_pgn_shd.g_old_rec.information1
255: ,p_information2_o
256: => per_pgn_shd.g_old_rec.information2
257: ,p_information3_o
258: => per_pgn_shd.g_old_rec.information3

Line 256: => per_pgn_shd.g_old_rec.information2

252: => per_pgn_shd.g_old_rec.information_category
253: ,p_information1_o
254: => per_pgn_shd.g_old_rec.information1
255: ,p_information2_o
256: => per_pgn_shd.g_old_rec.information2
257: ,p_information3_o
258: => per_pgn_shd.g_old_rec.information3
259: ,p_information4_o
260: => per_pgn_shd.g_old_rec.information4

Line 258: => per_pgn_shd.g_old_rec.information3

254: => per_pgn_shd.g_old_rec.information1
255: ,p_information2_o
256: => per_pgn_shd.g_old_rec.information2
257: ,p_information3_o
258: => per_pgn_shd.g_old_rec.information3
259: ,p_information4_o
260: => per_pgn_shd.g_old_rec.information4
261: ,p_information5_o
262: => per_pgn_shd.g_old_rec.information5

Line 260: => per_pgn_shd.g_old_rec.information4

256: => per_pgn_shd.g_old_rec.information2
257: ,p_information3_o
258: => per_pgn_shd.g_old_rec.information3
259: ,p_information4_o
260: => per_pgn_shd.g_old_rec.information4
261: ,p_information5_o
262: => per_pgn_shd.g_old_rec.information5
263: ,p_information6_o
264: => per_pgn_shd.g_old_rec.information6

Line 262: => per_pgn_shd.g_old_rec.information5

258: => per_pgn_shd.g_old_rec.information3
259: ,p_information4_o
260: => per_pgn_shd.g_old_rec.information4
261: ,p_information5_o
262: => per_pgn_shd.g_old_rec.information5
263: ,p_information6_o
264: => per_pgn_shd.g_old_rec.information6
265: ,p_information7_o
266: => per_pgn_shd.g_old_rec.information7

Line 264: => per_pgn_shd.g_old_rec.information6

260: => per_pgn_shd.g_old_rec.information4
261: ,p_information5_o
262: => per_pgn_shd.g_old_rec.information5
263: ,p_information6_o
264: => per_pgn_shd.g_old_rec.information6
265: ,p_information7_o
266: => per_pgn_shd.g_old_rec.information7
267: ,p_information8_o
268: => per_pgn_shd.g_old_rec.information8

Line 266: => per_pgn_shd.g_old_rec.information7

262: => per_pgn_shd.g_old_rec.information5
263: ,p_information6_o
264: => per_pgn_shd.g_old_rec.information6
265: ,p_information7_o
266: => per_pgn_shd.g_old_rec.information7
267: ,p_information8_o
268: => per_pgn_shd.g_old_rec.information8
269: ,p_information9_o
270: => per_pgn_shd.g_old_rec.information9

Line 268: => per_pgn_shd.g_old_rec.information8

264: => per_pgn_shd.g_old_rec.information6
265: ,p_information7_o
266: => per_pgn_shd.g_old_rec.information7
267: ,p_information8_o
268: => per_pgn_shd.g_old_rec.information8
269: ,p_information9_o
270: => per_pgn_shd.g_old_rec.information9
271: ,p_information10_o
272: => per_pgn_shd.g_old_rec.information10

Line 270: => per_pgn_shd.g_old_rec.information9

266: => per_pgn_shd.g_old_rec.information7
267: ,p_information8_o
268: => per_pgn_shd.g_old_rec.information8
269: ,p_information9_o
270: => per_pgn_shd.g_old_rec.information9
271: ,p_information10_o
272: => per_pgn_shd.g_old_rec.information10
273: ,p_information11_o
274: => per_pgn_shd.g_old_rec.information11

Line 272: => per_pgn_shd.g_old_rec.information10

268: => per_pgn_shd.g_old_rec.information8
269: ,p_information9_o
270: => per_pgn_shd.g_old_rec.information9
271: ,p_information10_o
272: => per_pgn_shd.g_old_rec.information10
273: ,p_information11_o
274: => per_pgn_shd.g_old_rec.information11
275: ,p_information12_o
276: => per_pgn_shd.g_old_rec.information12

Line 274: => per_pgn_shd.g_old_rec.information11

270: => per_pgn_shd.g_old_rec.information9
271: ,p_information10_o
272: => per_pgn_shd.g_old_rec.information10
273: ,p_information11_o
274: => per_pgn_shd.g_old_rec.information11
275: ,p_information12_o
276: => per_pgn_shd.g_old_rec.information12
277: ,p_information13_o
278: => per_pgn_shd.g_old_rec.information13

Line 276: => per_pgn_shd.g_old_rec.information12

272: => per_pgn_shd.g_old_rec.information10
273: ,p_information11_o
274: => per_pgn_shd.g_old_rec.information11
275: ,p_information12_o
276: => per_pgn_shd.g_old_rec.information12
277: ,p_information13_o
278: => per_pgn_shd.g_old_rec.information13
279: ,p_information14_o
280: => per_pgn_shd.g_old_rec.information14

Line 278: => per_pgn_shd.g_old_rec.information13

274: => per_pgn_shd.g_old_rec.information11
275: ,p_information12_o
276: => per_pgn_shd.g_old_rec.information12
277: ,p_information13_o
278: => per_pgn_shd.g_old_rec.information13
279: ,p_information14_o
280: => per_pgn_shd.g_old_rec.information14
281: ,p_information15_o
282: => per_pgn_shd.g_old_rec.information15

Line 280: => per_pgn_shd.g_old_rec.information14

276: => per_pgn_shd.g_old_rec.information12
277: ,p_information13_o
278: => per_pgn_shd.g_old_rec.information13
279: ,p_information14_o
280: => per_pgn_shd.g_old_rec.information14
281: ,p_information15_o
282: => per_pgn_shd.g_old_rec.information15
283: ,p_information16_o
284: => per_pgn_shd.g_old_rec.information16

Line 282: => per_pgn_shd.g_old_rec.information15

278: => per_pgn_shd.g_old_rec.information13
279: ,p_information14_o
280: => per_pgn_shd.g_old_rec.information14
281: ,p_information15_o
282: => per_pgn_shd.g_old_rec.information15
283: ,p_information16_o
284: => per_pgn_shd.g_old_rec.information16
285: ,p_information17_o
286: => per_pgn_shd.g_old_rec.information17

Line 284: => per_pgn_shd.g_old_rec.information16

280: => per_pgn_shd.g_old_rec.information14
281: ,p_information15_o
282: => per_pgn_shd.g_old_rec.information15
283: ,p_information16_o
284: => per_pgn_shd.g_old_rec.information16
285: ,p_information17_o
286: => per_pgn_shd.g_old_rec.information17
287: ,p_information18_o
288: => per_pgn_shd.g_old_rec.information18

Line 286: => per_pgn_shd.g_old_rec.information17

282: => per_pgn_shd.g_old_rec.information15
283: ,p_information16_o
284: => per_pgn_shd.g_old_rec.information16
285: ,p_information17_o
286: => per_pgn_shd.g_old_rec.information17
287: ,p_information18_o
288: => per_pgn_shd.g_old_rec.information18
289: ,p_information19_o
290: => per_pgn_shd.g_old_rec.information19

Line 288: => per_pgn_shd.g_old_rec.information18

284: => per_pgn_shd.g_old_rec.information16
285: ,p_information17_o
286: => per_pgn_shd.g_old_rec.information17
287: ,p_information18_o
288: => per_pgn_shd.g_old_rec.information18
289: ,p_information19_o
290: => per_pgn_shd.g_old_rec.information19
291: ,p_information20_o
292: => per_pgn_shd.g_old_rec.information20

Line 290: => per_pgn_shd.g_old_rec.information19

286: => per_pgn_shd.g_old_rec.information17
287: ,p_information18_o
288: => per_pgn_shd.g_old_rec.information18
289: ,p_information19_o
290: => per_pgn_shd.g_old_rec.information19
291: ,p_information20_o
292: => per_pgn_shd.g_old_rec.information20
293: ,p_information21_o
294: => per_pgn_shd.g_old_rec.information21

Line 292: => per_pgn_shd.g_old_rec.information20

288: => per_pgn_shd.g_old_rec.information18
289: ,p_information19_o
290: => per_pgn_shd.g_old_rec.information19
291: ,p_information20_o
292: => per_pgn_shd.g_old_rec.information20
293: ,p_information21_o
294: => per_pgn_shd.g_old_rec.information21
295: ,p_information22_o
296: => per_pgn_shd.g_old_rec.information22

Line 294: => per_pgn_shd.g_old_rec.information21

290: => per_pgn_shd.g_old_rec.information19
291: ,p_information20_o
292: => per_pgn_shd.g_old_rec.information20
293: ,p_information21_o
294: => per_pgn_shd.g_old_rec.information21
295: ,p_information22_o
296: => per_pgn_shd.g_old_rec.information22
297: ,p_information23_o
298: => per_pgn_shd.g_old_rec.information23

Line 296: => per_pgn_shd.g_old_rec.information22

292: => per_pgn_shd.g_old_rec.information20
293: ,p_information21_o
294: => per_pgn_shd.g_old_rec.information21
295: ,p_information22_o
296: => per_pgn_shd.g_old_rec.information22
297: ,p_information23_o
298: => per_pgn_shd.g_old_rec.information23
299: ,p_information24_o
300: => per_pgn_shd.g_old_rec.information24

Line 298: => per_pgn_shd.g_old_rec.information23

294: => per_pgn_shd.g_old_rec.information21
295: ,p_information22_o
296: => per_pgn_shd.g_old_rec.information22
297: ,p_information23_o
298: => per_pgn_shd.g_old_rec.information23
299: ,p_information24_o
300: => per_pgn_shd.g_old_rec.information24
301: ,p_information25_o
302: => per_pgn_shd.g_old_rec.information25

Line 300: => per_pgn_shd.g_old_rec.information24

296: => per_pgn_shd.g_old_rec.information22
297: ,p_information23_o
298: => per_pgn_shd.g_old_rec.information23
299: ,p_information24_o
300: => per_pgn_shd.g_old_rec.information24
301: ,p_information25_o
302: => per_pgn_shd.g_old_rec.information25
303: ,p_information26_o
304: => per_pgn_shd.g_old_rec.information26

Line 302: => per_pgn_shd.g_old_rec.information25

298: => per_pgn_shd.g_old_rec.information23
299: ,p_information24_o
300: => per_pgn_shd.g_old_rec.information24
301: ,p_information25_o
302: => per_pgn_shd.g_old_rec.information25
303: ,p_information26_o
304: => per_pgn_shd.g_old_rec.information26
305: ,p_information27_o
306: => per_pgn_shd.g_old_rec.information27

Line 304: => per_pgn_shd.g_old_rec.information26

300: => per_pgn_shd.g_old_rec.information24
301: ,p_information25_o
302: => per_pgn_shd.g_old_rec.information25
303: ,p_information26_o
304: => per_pgn_shd.g_old_rec.information26
305: ,p_information27_o
306: => per_pgn_shd.g_old_rec.information27
307: ,p_information28_o
308: => per_pgn_shd.g_old_rec.information28

Line 306: => per_pgn_shd.g_old_rec.information27

302: => per_pgn_shd.g_old_rec.information25
303: ,p_information26_o
304: => per_pgn_shd.g_old_rec.information26
305: ,p_information27_o
306: => per_pgn_shd.g_old_rec.information27
307: ,p_information28_o
308: => per_pgn_shd.g_old_rec.information28
309: ,p_information29_o
310: => per_pgn_shd.g_old_rec.information29

Line 308: => per_pgn_shd.g_old_rec.information28

304: => per_pgn_shd.g_old_rec.information26
305: ,p_information27_o
306: => per_pgn_shd.g_old_rec.information27
307: ,p_information28_o
308: => per_pgn_shd.g_old_rec.information28
309: ,p_information29_o
310: => per_pgn_shd.g_old_rec.information29
311: ,p_information30_o
312: => per_pgn_shd.g_old_rec.information30

Line 310: => per_pgn_shd.g_old_rec.information29

306: => per_pgn_shd.g_old_rec.information27
307: ,p_information28_o
308: => per_pgn_shd.g_old_rec.information28
309: ,p_information29_o
310: => per_pgn_shd.g_old_rec.information29
311: ,p_information30_o
312: => per_pgn_shd.g_old_rec.information30
313: );
314: --

Line 312: => per_pgn_shd.g_old_rec.information30

308: => per_pgn_shd.g_old_rec.information28
309: ,p_information29_o
310: => per_pgn_shd.g_old_rec.information29
311: ,p_information30_o
312: => per_pgn_shd.g_old_rec.information30
313: );
314: --
315: exception
316: --

Line 332: (p_rec in per_pgn_shd.g_rec_type

328: -- ----------------------------------------------------------------------------
329: -- |---------------------------------< del >----------------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure del
332: (p_rec in per_pgn_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'del';
336: --

Line 342: per_pgn_shd.lck

338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: -- We must lock the row which we need to delete.
341: --
342: per_pgn_shd.lck
343: (p_rec.hierarchy_node_id
344: ,p_rec.object_version_number
345: );
346: --

Line 373: l_rec per_pgn_shd.g_rec_type;

369: (p_hierarchy_node_id in number
370: ,p_object_version_number in number
371: ) is
372: --
373: l_rec per_pgn_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'del';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);