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_PPS_DEL dependencies on PER_PPS_SHD

Line 52: (p_rec in per_pps_shd.g_rec_type

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

Line 60: per_pps_shd.g_api_dml := true; -- Set the api dml status

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: per_pps_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_parent_spines row.
63: --
64: delete from per_parent_spines

Line 67: per_pps_shd.g_api_dml := false; -- Unset the api dml status

63: --
64: delete from per_parent_spines
65: where parent_spine_id = p_rec.parent_spine_id;
66: --
67: per_pps_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

Line 74: per_pps_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_pps_shd.g_api_dml := false; -- Unset the api dml status
75: per_pps_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_pps_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_pps_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: per_pps_shd.g_api_dml := false; -- Unset the api dml status
75: per_pps_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_pps_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;

Line 78: per_pps_shd.g_api_dml := false; -- Unset the api dml status

74: per_pps_shd.g_api_dml := false; -- Unset the api dml status
75: per_pps_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_pps_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: Procedure pre_delete(p_rec in per_pps_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_pps_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_pps_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_pps_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_pps_shd.g_old_rec.business_group_id

164: per_pps_rkd.after_delete
165: (p_parent_spine_id
166: => p_rec.parent_spine_id
167: ,p_business_group_id_o
168: => per_pps_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pps_shd.g_old_rec.name
171: ,p_comments_o
172: => per_pps_shd.g_old_rec.comments

Line 170: => per_pps_shd.g_old_rec.name

166: => p_rec.parent_spine_id
167: ,p_business_group_id_o
168: => per_pps_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pps_shd.g_old_rec.name
171: ,p_comments_o
172: => per_pps_shd.g_old_rec.comments
173: ,p_increment_frequency_o
174: => per_pps_shd.g_old_rec.increment_frequency

Line 172: => per_pps_shd.g_old_rec.comments

168: => per_pps_shd.g_old_rec.business_group_id
169: ,p_name_o
170: => per_pps_shd.g_old_rec.name
171: ,p_comments_o
172: => per_pps_shd.g_old_rec.comments
173: ,p_increment_frequency_o
174: => per_pps_shd.g_old_rec.increment_frequency
175: ,p_increment_period_o
176: => per_pps_shd.g_old_rec.increment_period

Line 174: => per_pps_shd.g_old_rec.increment_frequency

170: => per_pps_shd.g_old_rec.name
171: ,p_comments_o
172: => per_pps_shd.g_old_rec.comments
173: ,p_increment_frequency_o
174: => per_pps_shd.g_old_rec.increment_frequency
175: ,p_increment_period_o
176: => per_pps_shd.g_old_rec.increment_period
177: ,p_last_automatic_increment_d_o
178: => per_pps_shd.g_old_rec.last_automatic_increment_date

Line 176: => per_pps_shd.g_old_rec.increment_period

172: => per_pps_shd.g_old_rec.comments
173: ,p_increment_frequency_o
174: => per_pps_shd.g_old_rec.increment_frequency
175: ,p_increment_period_o
176: => per_pps_shd.g_old_rec.increment_period
177: ,p_last_automatic_increment_d_o
178: => per_pps_shd.g_old_rec.last_automatic_increment_date
179: ,p_request_id_o
180: => per_pps_shd.g_old_rec.request_id

Line 178: => per_pps_shd.g_old_rec.last_automatic_increment_date

174: => per_pps_shd.g_old_rec.increment_frequency
175: ,p_increment_period_o
176: => per_pps_shd.g_old_rec.increment_period
177: ,p_last_automatic_increment_d_o
178: => per_pps_shd.g_old_rec.last_automatic_increment_date
179: ,p_request_id_o
180: => per_pps_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pps_shd.g_old_rec.program_application_id

Line 180: => per_pps_shd.g_old_rec.request_id

176: => per_pps_shd.g_old_rec.increment_period
177: ,p_last_automatic_increment_d_o
178: => per_pps_shd.g_old_rec.last_automatic_increment_date
179: ,p_request_id_o
180: => per_pps_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pps_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pps_shd.g_old_rec.program_id

Line 182: => per_pps_shd.g_old_rec.program_application_id

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

Line 184: => per_pps_shd.g_old_rec.program_id

180: => per_pps_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => per_pps_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pps_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pps_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => per_pps_shd.g_old_rec.attribute_category

Line 186: => per_pps_shd.g_old_rec.program_update_date

182: => per_pps_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => per_pps_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pps_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => per_pps_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => per_pps_shd.g_old_rec.attribute1

Line 188: => per_pps_shd.g_old_rec.attribute_category

184: => per_pps_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => per_pps_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => per_pps_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => per_pps_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => per_pps_shd.g_old_rec.attribute2

Line 190: => per_pps_shd.g_old_rec.attribute1

186: => per_pps_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => per_pps_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => per_pps_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => per_pps_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => per_pps_shd.g_old_rec.attribute3

Line 192: => per_pps_shd.g_old_rec.attribute2

188: => per_pps_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => per_pps_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => per_pps_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => per_pps_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => per_pps_shd.g_old_rec.attribute4

Line 194: => per_pps_shd.g_old_rec.attribute3

190: => per_pps_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => per_pps_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => per_pps_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => per_pps_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => per_pps_shd.g_old_rec.attribute5

Line 196: => per_pps_shd.g_old_rec.attribute4

192: => per_pps_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => per_pps_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => per_pps_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => per_pps_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => per_pps_shd.g_old_rec.attribute6

Line 198: => per_pps_shd.g_old_rec.attribute5

194: => per_pps_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => per_pps_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => per_pps_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => per_pps_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => per_pps_shd.g_old_rec.attribute7

Line 200: => per_pps_shd.g_old_rec.attribute6

196: => per_pps_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => per_pps_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => per_pps_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => per_pps_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => per_pps_shd.g_old_rec.attribute8

Line 202: => per_pps_shd.g_old_rec.attribute7

198: => per_pps_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => per_pps_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => per_pps_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => per_pps_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => per_pps_shd.g_old_rec.attribute9

Line 204: => per_pps_shd.g_old_rec.attribute8

200: => per_pps_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => per_pps_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => per_pps_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => per_pps_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => per_pps_shd.g_old_rec.attribute10

Line 206: => per_pps_shd.g_old_rec.attribute9

202: => per_pps_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => per_pps_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => per_pps_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => per_pps_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => per_pps_shd.g_old_rec.attribute11

Line 208: => per_pps_shd.g_old_rec.attribute10

204: => per_pps_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => per_pps_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => per_pps_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => per_pps_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => per_pps_shd.g_old_rec.attribute12

Line 210: => per_pps_shd.g_old_rec.attribute11

206: => per_pps_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => per_pps_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => per_pps_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => per_pps_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => per_pps_shd.g_old_rec.attribute13

Line 212: => per_pps_shd.g_old_rec.attribute12

208: => per_pps_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => per_pps_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => per_pps_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => per_pps_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => per_pps_shd.g_old_rec.attribute14

Line 214: => per_pps_shd.g_old_rec.attribute13

210: => per_pps_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => per_pps_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => per_pps_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => per_pps_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => per_pps_shd.g_old_rec.attribute15

Line 216: => per_pps_shd.g_old_rec.attribute14

212: => per_pps_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => per_pps_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => per_pps_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => per_pps_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => per_pps_shd.g_old_rec.attribute16

Line 218: => per_pps_shd.g_old_rec.attribute15

214: => per_pps_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => per_pps_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => per_pps_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => per_pps_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => per_pps_shd.g_old_rec.attribute17

Line 220: => per_pps_shd.g_old_rec.attribute16

216: => per_pps_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => per_pps_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => per_pps_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => per_pps_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => per_pps_shd.g_old_rec.attribute18

Line 222: => per_pps_shd.g_old_rec.attribute17

218: => per_pps_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => per_pps_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => per_pps_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => per_pps_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => per_pps_shd.g_old_rec.attribute19

Line 224: => per_pps_shd.g_old_rec.attribute18

220: => per_pps_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => per_pps_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => per_pps_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => per_pps_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => per_pps_shd.g_old_rec.attribute20

Line 226: => per_pps_shd.g_old_rec.attribute19

222: => per_pps_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => per_pps_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => per_pps_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => per_pps_shd.g_old_rec.attribute20
229: --
230: ,p_information_category_o

Line 228: => per_pps_shd.g_old_rec.attribute20

224: => per_pps_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => per_pps_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => per_pps_shd.g_old_rec.attribute20
229: --
230: ,p_information_category_o
231: => per_pps_shd.g_old_rec.information_category
232: ,p_information1_o

Line 231: => per_pps_shd.g_old_rec.information_category

227: ,p_attribute20_o
228: => per_pps_shd.g_old_rec.attribute20
229: --
230: ,p_information_category_o
231: => per_pps_shd.g_old_rec.information_category
232: ,p_information1_o
233: => per_pps_shd.g_old_rec.information1
234: ,p_information2_o
235: => per_pps_shd.g_old_rec.information2

Line 233: => per_pps_shd.g_old_rec.information1

229: --
230: ,p_information_category_o
231: => per_pps_shd.g_old_rec.information_category
232: ,p_information1_o
233: => per_pps_shd.g_old_rec.information1
234: ,p_information2_o
235: => per_pps_shd.g_old_rec.information2
236: ,p_information3_o
237: => per_pps_shd.g_old_rec.information3

Line 235: => per_pps_shd.g_old_rec.information2

231: => per_pps_shd.g_old_rec.information_category
232: ,p_information1_o
233: => per_pps_shd.g_old_rec.information1
234: ,p_information2_o
235: => per_pps_shd.g_old_rec.information2
236: ,p_information3_o
237: => per_pps_shd.g_old_rec.information3
238: ,p_information4_o
239: => per_pps_shd.g_old_rec.information4

Line 237: => per_pps_shd.g_old_rec.information3

233: => per_pps_shd.g_old_rec.information1
234: ,p_information2_o
235: => per_pps_shd.g_old_rec.information2
236: ,p_information3_o
237: => per_pps_shd.g_old_rec.information3
238: ,p_information4_o
239: => per_pps_shd.g_old_rec.information4
240: ,p_information5_o
241: => per_pps_shd.g_old_rec.information5

Line 239: => per_pps_shd.g_old_rec.information4

235: => per_pps_shd.g_old_rec.information2
236: ,p_information3_o
237: => per_pps_shd.g_old_rec.information3
238: ,p_information4_o
239: => per_pps_shd.g_old_rec.information4
240: ,p_information5_o
241: => per_pps_shd.g_old_rec.information5
242: ,p_information6_o
243: => per_pps_shd.g_old_rec.information6

Line 241: => per_pps_shd.g_old_rec.information5

237: => per_pps_shd.g_old_rec.information3
238: ,p_information4_o
239: => per_pps_shd.g_old_rec.information4
240: ,p_information5_o
241: => per_pps_shd.g_old_rec.information5
242: ,p_information6_o
243: => per_pps_shd.g_old_rec.information6
244: ,p_information7_o
245: => per_pps_shd.g_old_rec.information7

Line 243: => per_pps_shd.g_old_rec.information6

239: => per_pps_shd.g_old_rec.information4
240: ,p_information5_o
241: => per_pps_shd.g_old_rec.information5
242: ,p_information6_o
243: => per_pps_shd.g_old_rec.information6
244: ,p_information7_o
245: => per_pps_shd.g_old_rec.information7
246: ,p_information8_o
247: => per_pps_shd.g_old_rec.information8

Line 245: => per_pps_shd.g_old_rec.information7

241: => per_pps_shd.g_old_rec.information5
242: ,p_information6_o
243: => per_pps_shd.g_old_rec.information6
244: ,p_information7_o
245: => per_pps_shd.g_old_rec.information7
246: ,p_information8_o
247: => per_pps_shd.g_old_rec.information8
248: ,p_information9_o
249: => per_pps_shd.g_old_rec.information9

Line 247: => per_pps_shd.g_old_rec.information8

243: => per_pps_shd.g_old_rec.information6
244: ,p_information7_o
245: => per_pps_shd.g_old_rec.information7
246: ,p_information8_o
247: => per_pps_shd.g_old_rec.information8
248: ,p_information9_o
249: => per_pps_shd.g_old_rec.information9
250: ,p_information10_o
251: => per_pps_shd.g_old_rec.information10

Line 249: => per_pps_shd.g_old_rec.information9

245: => per_pps_shd.g_old_rec.information7
246: ,p_information8_o
247: => per_pps_shd.g_old_rec.information8
248: ,p_information9_o
249: => per_pps_shd.g_old_rec.information9
250: ,p_information10_o
251: => per_pps_shd.g_old_rec.information10
252: ,p_information11_o
253: => per_pps_shd.g_old_rec.information11

Line 251: => per_pps_shd.g_old_rec.information10

247: => per_pps_shd.g_old_rec.information8
248: ,p_information9_o
249: => per_pps_shd.g_old_rec.information9
250: ,p_information10_o
251: => per_pps_shd.g_old_rec.information10
252: ,p_information11_o
253: => per_pps_shd.g_old_rec.information11
254: ,p_information12_o
255: => per_pps_shd.g_old_rec.information12

Line 253: => per_pps_shd.g_old_rec.information11

249: => per_pps_shd.g_old_rec.information9
250: ,p_information10_o
251: => per_pps_shd.g_old_rec.information10
252: ,p_information11_o
253: => per_pps_shd.g_old_rec.information11
254: ,p_information12_o
255: => per_pps_shd.g_old_rec.information12
256: ,p_information13_o
257: => per_pps_shd.g_old_rec.information13

Line 255: => per_pps_shd.g_old_rec.information12

251: => per_pps_shd.g_old_rec.information10
252: ,p_information11_o
253: => per_pps_shd.g_old_rec.information11
254: ,p_information12_o
255: => per_pps_shd.g_old_rec.information12
256: ,p_information13_o
257: => per_pps_shd.g_old_rec.information13
258: ,p_information14_o
259: => per_pps_shd.g_old_rec.information14

Line 257: => per_pps_shd.g_old_rec.information13

253: => per_pps_shd.g_old_rec.information11
254: ,p_information12_o
255: => per_pps_shd.g_old_rec.information12
256: ,p_information13_o
257: => per_pps_shd.g_old_rec.information13
258: ,p_information14_o
259: => per_pps_shd.g_old_rec.information14
260: ,p_information15_o
261: => per_pps_shd.g_old_rec.information15

Line 259: => per_pps_shd.g_old_rec.information14

255: => per_pps_shd.g_old_rec.information12
256: ,p_information13_o
257: => per_pps_shd.g_old_rec.information13
258: ,p_information14_o
259: => per_pps_shd.g_old_rec.information14
260: ,p_information15_o
261: => per_pps_shd.g_old_rec.information15
262: ,p_information16_o
263: => per_pps_shd.g_old_rec.information16

Line 261: => per_pps_shd.g_old_rec.information15

257: => per_pps_shd.g_old_rec.information13
258: ,p_information14_o
259: => per_pps_shd.g_old_rec.information14
260: ,p_information15_o
261: => per_pps_shd.g_old_rec.information15
262: ,p_information16_o
263: => per_pps_shd.g_old_rec.information16
264: ,p_information17_o
265: => per_pps_shd.g_old_rec.information17

Line 263: => per_pps_shd.g_old_rec.information16

259: => per_pps_shd.g_old_rec.information14
260: ,p_information15_o
261: => per_pps_shd.g_old_rec.information15
262: ,p_information16_o
263: => per_pps_shd.g_old_rec.information16
264: ,p_information17_o
265: => per_pps_shd.g_old_rec.information17
266: ,p_information18_o
267: => per_pps_shd.g_old_rec.information18

Line 265: => per_pps_shd.g_old_rec.information17

261: => per_pps_shd.g_old_rec.information15
262: ,p_information16_o
263: => per_pps_shd.g_old_rec.information16
264: ,p_information17_o
265: => per_pps_shd.g_old_rec.information17
266: ,p_information18_o
267: => per_pps_shd.g_old_rec.information18
268: ,p_information19_o
269: => per_pps_shd.g_old_rec.information19

Line 267: => per_pps_shd.g_old_rec.information18

263: => per_pps_shd.g_old_rec.information16
264: ,p_information17_o
265: => per_pps_shd.g_old_rec.information17
266: ,p_information18_o
267: => per_pps_shd.g_old_rec.information18
268: ,p_information19_o
269: => per_pps_shd.g_old_rec.information19
270: ,p_information20_o
271: => per_pps_shd.g_old_rec.information20

Line 269: => per_pps_shd.g_old_rec.information19

265: => per_pps_shd.g_old_rec.information17
266: ,p_information18_o
267: => per_pps_shd.g_old_rec.information18
268: ,p_information19_o
269: => per_pps_shd.g_old_rec.information19
270: ,p_information20_o
271: => per_pps_shd.g_old_rec.information20
272: ,p_information21_o
273: => per_pps_shd.g_old_rec.information21

Line 271: => per_pps_shd.g_old_rec.information20

267: => per_pps_shd.g_old_rec.information18
268: ,p_information19_o
269: => per_pps_shd.g_old_rec.information19
270: ,p_information20_o
271: => per_pps_shd.g_old_rec.information20
272: ,p_information21_o
273: => per_pps_shd.g_old_rec.information21
274: ,p_information22_o
275: => per_pps_shd.g_old_rec.information22

Line 273: => per_pps_shd.g_old_rec.information21

269: => per_pps_shd.g_old_rec.information19
270: ,p_information20_o
271: => per_pps_shd.g_old_rec.information20
272: ,p_information21_o
273: => per_pps_shd.g_old_rec.information21
274: ,p_information22_o
275: => per_pps_shd.g_old_rec.information22
276: ,p_information23_o
277: => per_pps_shd.g_old_rec.information23

Line 275: => per_pps_shd.g_old_rec.information22

271: => per_pps_shd.g_old_rec.information20
272: ,p_information21_o
273: => per_pps_shd.g_old_rec.information21
274: ,p_information22_o
275: => per_pps_shd.g_old_rec.information22
276: ,p_information23_o
277: => per_pps_shd.g_old_rec.information23
278: ,p_information24_o
279: => per_pps_shd.g_old_rec.information24

Line 277: => per_pps_shd.g_old_rec.information23

273: => per_pps_shd.g_old_rec.information21
274: ,p_information22_o
275: => per_pps_shd.g_old_rec.information22
276: ,p_information23_o
277: => per_pps_shd.g_old_rec.information23
278: ,p_information24_o
279: => per_pps_shd.g_old_rec.information24
280: ,p_information25_o
281: => per_pps_shd.g_old_rec.information25

Line 279: => per_pps_shd.g_old_rec.information24

275: => per_pps_shd.g_old_rec.information22
276: ,p_information23_o
277: => per_pps_shd.g_old_rec.information23
278: ,p_information24_o
279: => per_pps_shd.g_old_rec.information24
280: ,p_information25_o
281: => per_pps_shd.g_old_rec.information25
282: ,p_information26_o
283: => per_pps_shd.g_old_rec.information26

Line 281: => per_pps_shd.g_old_rec.information25

277: => per_pps_shd.g_old_rec.information23
278: ,p_information24_o
279: => per_pps_shd.g_old_rec.information24
280: ,p_information25_o
281: => per_pps_shd.g_old_rec.information25
282: ,p_information26_o
283: => per_pps_shd.g_old_rec.information26
284: ,p_information27_o
285: => per_pps_shd.g_old_rec.information27

Line 283: => per_pps_shd.g_old_rec.information26

279: => per_pps_shd.g_old_rec.information24
280: ,p_information25_o
281: => per_pps_shd.g_old_rec.information25
282: ,p_information26_o
283: => per_pps_shd.g_old_rec.information26
284: ,p_information27_o
285: => per_pps_shd.g_old_rec.information27
286: ,p_information28_o
287: => per_pps_shd.g_old_rec.information28

Line 285: => per_pps_shd.g_old_rec.information27

281: => per_pps_shd.g_old_rec.information25
282: ,p_information26_o
283: => per_pps_shd.g_old_rec.information26
284: ,p_information27_o
285: => per_pps_shd.g_old_rec.information27
286: ,p_information28_o
287: => per_pps_shd.g_old_rec.information28
288: ,p_information29_o
289: => per_pps_shd.g_old_rec.information29

Line 287: => per_pps_shd.g_old_rec.information28

283: => per_pps_shd.g_old_rec.information26
284: ,p_information27_o
285: => per_pps_shd.g_old_rec.information27
286: ,p_information28_o
287: => per_pps_shd.g_old_rec.information28
288: ,p_information29_o
289: => per_pps_shd.g_old_rec.information29
290: ,p_information30_o
291: => per_pps_shd.g_old_rec.information30

Line 289: => per_pps_shd.g_old_rec.information29

285: => per_pps_shd.g_old_rec.information27
286: ,p_information28_o
287: => per_pps_shd.g_old_rec.information28
288: ,p_information29_o
289: => per_pps_shd.g_old_rec.information29
290: ,p_information30_o
291: => per_pps_shd.g_old_rec.information30
292: --
293: ,p_object_version_number_o

Line 291: => per_pps_shd.g_old_rec.information30

287: => per_pps_shd.g_old_rec.information28
288: ,p_information29_o
289: => per_pps_shd.g_old_rec.information29
290: ,p_information30_o
291: => per_pps_shd.g_old_rec.information30
292: --
293: ,p_object_version_number_o
294: => per_pps_shd.g_old_rec.object_version_number
295: );

Line 294: => per_pps_shd.g_old_rec.object_version_number

290: ,p_information30_o
291: => per_pps_shd.g_old_rec.information30
292: --
293: ,p_object_version_number_o
294: => per_pps_shd.g_old_rec.object_version_number
295: );
296: --
297: exception
298: --

Line 314: (p_rec in per_pps_shd.g_rec_type

310: -- ----------------------------------------------------------------------------
311: -- |---------------------------------< del >----------------------------------|
312: -- ----------------------------------------------------------------------------
313: Procedure del
314: (p_rec in per_pps_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package||'del';
318: --

Line 324: per_pps_shd.lck

320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- We must lock the row which we need to delete.
323: --
324: per_pps_shd.lck
325: (p_rec.parent_spine_id
326: ,p_rec.object_version_number
327: );
328: --

Line 361: l_rec per_pps_shd.g_rec_type;

357: (p_parent_spine_id in number
358: ,p_object_version_number in number
359: ) is
360: --
361: l_rec per_pps_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'del';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);