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_CEO_DEL dependencies on PER_CEO_SHD

Line 52: (p_rec in per_ceo_shd.g_rec_type

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

Line 60: per_ceo_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_ceo_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the per_comp_element_outcomes row.
63: --
64: delete from per_comp_element_outcomes

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

63: --
64: delete from per_comp_element_outcomes
65: where comp_element_outcome_id = p_rec.comp_element_outcome_id;
66: --
67: per_ceo_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_ceo_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_ceo_shd.g_api_dml := false; -- Unset the api dml status
75: per_ceo_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_ceo_shd.g_api_dml := false; -- Unset the api dml status

Line 75: per_ceo_shd.constraint_error

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

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

74: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
75: per_ceo_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: per_ceo_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_ceo_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_ceo_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_ceo_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_ceo_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => per_ceo_shd.g_old_rec.competence_element_id

164: per_ceo_rkd.after_delete
165: (p_comp_element_outcome_id
166: => p_rec.comp_element_outcome_id
167: ,p_competence_element_id_o
168: => per_ceo_shd.g_old_rec.competence_element_id
169: ,p_outcome_id_o
170: => per_ceo_shd.g_old_rec.outcome_id
171: ,p_date_from_o
172: => per_ceo_shd.g_old_rec.date_from

Line 170: => per_ceo_shd.g_old_rec.outcome_id

166: => p_rec.comp_element_outcome_id
167: ,p_competence_element_id_o
168: => per_ceo_shd.g_old_rec.competence_element_id
169: ,p_outcome_id_o
170: => per_ceo_shd.g_old_rec.outcome_id
171: ,p_date_from_o
172: => per_ceo_shd.g_old_rec.date_from
173: ,p_date_to_o
174: => per_ceo_shd.g_old_rec.date_to

Line 172: => per_ceo_shd.g_old_rec.date_from

168: => per_ceo_shd.g_old_rec.competence_element_id
169: ,p_outcome_id_o
170: => per_ceo_shd.g_old_rec.outcome_id
171: ,p_date_from_o
172: => per_ceo_shd.g_old_rec.date_from
173: ,p_date_to_o
174: => per_ceo_shd.g_old_rec.date_to
175: ,p_object_version_number_o
176: => per_ceo_shd.g_old_rec.object_version_number

Line 174: => per_ceo_shd.g_old_rec.date_to

170: => per_ceo_shd.g_old_rec.outcome_id
171: ,p_date_from_o
172: => per_ceo_shd.g_old_rec.date_from
173: ,p_date_to_o
174: => per_ceo_shd.g_old_rec.date_to
175: ,p_object_version_number_o
176: => per_ceo_shd.g_old_rec.object_version_number
177: ,p_attribute_category_o
178: => per_ceo_shd.g_old_rec.attribute_category

Line 176: => per_ceo_shd.g_old_rec.object_version_number

172: => per_ceo_shd.g_old_rec.date_from
173: ,p_date_to_o
174: => per_ceo_shd.g_old_rec.date_to
175: ,p_object_version_number_o
176: => per_ceo_shd.g_old_rec.object_version_number
177: ,p_attribute_category_o
178: => per_ceo_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => per_ceo_shd.g_old_rec.attribute1

Line 178: => per_ceo_shd.g_old_rec.attribute_category

174: => per_ceo_shd.g_old_rec.date_to
175: ,p_object_version_number_o
176: => per_ceo_shd.g_old_rec.object_version_number
177: ,p_attribute_category_o
178: => per_ceo_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => per_ceo_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => per_ceo_shd.g_old_rec.attribute2

Line 180: => per_ceo_shd.g_old_rec.attribute1

176: => per_ceo_shd.g_old_rec.object_version_number
177: ,p_attribute_category_o
178: => per_ceo_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => per_ceo_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => per_ceo_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => per_ceo_shd.g_old_rec.attribute3

Line 182: => per_ceo_shd.g_old_rec.attribute2

178: => per_ceo_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => per_ceo_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => per_ceo_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => per_ceo_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => per_ceo_shd.g_old_rec.attribute4

Line 184: => per_ceo_shd.g_old_rec.attribute3

180: => per_ceo_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => per_ceo_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => per_ceo_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => per_ceo_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => per_ceo_shd.g_old_rec.attribute5

Line 186: => per_ceo_shd.g_old_rec.attribute4

182: => per_ceo_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => per_ceo_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => per_ceo_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => per_ceo_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => per_ceo_shd.g_old_rec.attribute6

Line 188: => per_ceo_shd.g_old_rec.attribute5

184: => per_ceo_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => per_ceo_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => per_ceo_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => per_ceo_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => per_ceo_shd.g_old_rec.attribute7

Line 190: => per_ceo_shd.g_old_rec.attribute6

186: => per_ceo_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => per_ceo_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => per_ceo_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => per_ceo_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => per_ceo_shd.g_old_rec.attribute8

Line 192: => per_ceo_shd.g_old_rec.attribute7

188: => per_ceo_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => per_ceo_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => per_ceo_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => per_ceo_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => per_ceo_shd.g_old_rec.attribute9

Line 194: => per_ceo_shd.g_old_rec.attribute8

190: => per_ceo_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => per_ceo_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => per_ceo_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => per_ceo_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => per_ceo_shd.g_old_rec.attribute10

Line 196: => per_ceo_shd.g_old_rec.attribute9

192: => per_ceo_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => per_ceo_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => per_ceo_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => per_ceo_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => per_ceo_shd.g_old_rec.attribute11

Line 198: => per_ceo_shd.g_old_rec.attribute10

194: => per_ceo_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => per_ceo_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => per_ceo_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => per_ceo_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => per_ceo_shd.g_old_rec.attribute12

Line 200: => per_ceo_shd.g_old_rec.attribute11

196: => per_ceo_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => per_ceo_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => per_ceo_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => per_ceo_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => per_ceo_shd.g_old_rec.attribute13

Line 202: => per_ceo_shd.g_old_rec.attribute12

198: => per_ceo_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => per_ceo_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => per_ceo_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => per_ceo_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => per_ceo_shd.g_old_rec.attribute14

Line 204: => per_ceo_shd.g_old_rec.attribute13

200: => per_ceo_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => per_ceo_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => per_ceo_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => per_ceo_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => per_ceo_shd.g_old_rec.attribute15

Line 206: => per_ceo_shd.g_old_rec.attribute14

202: => per_ceo_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => per_ceo_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => per_ceo_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => per_ceo_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => per_ceo_shd.g_old_rec.attribute16

Line 208: => per_ceo_shd.g_old_rec.attribute15

204: => per_ceo_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => per_ceo_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => per_ceo_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => per_ceo_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => per_ceo_shd.g_old_rec.attribute17

Line 210: => per_ceo_shd.g_old_rec.attribute16

206: => per_ceo_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => per_ceo_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => per_ceo_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => per_ceo_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => per_ceo_shd.g_old_rec.attribute18

Line 212: => per_ceo_shd.g_old_rec.attribute17

208: => per_ceo_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => per_ceo_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => per_ceo_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => per_ceo_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => per_ceo_shd.g_old_rec.attribute19

Line 214: => per_ceo_shd.g_old_rec.attribute18

210: => per_ceo_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => per_ceo_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => per_ceo_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => per_ceo_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => per_ceo_shd.g_old_rec.attribute20

Line 216: => per_ceo_shd.g_old_rec.attribute19

212: => per_ceo_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => per_ceo_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => per_ceo_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => per_ceo_shd.g_old_rec.attribute20
219: ,p_information_category_o
220: => per_ceo_shd.g_old_rec.information_category

Line 218: => per_ceo_shd.g_old_rec.attribute20

214: => per_ceo_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => per_ceo_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => per_ceo_shd.g_old_rec.attribute20
219: ,p_information_category_o
220: => per_ceo_shd.g_old_rec.information_category
221: ,p_information1_o
222: => per_ceo_shd.g_old_rec.information1

Line 220: => per_ceo_shd.g_old_rec.information_category

216: => per_ceo_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => per_ceo_shd.g_old_rec.attribute20
219: ,p_information_category_o
220: => per_ceo_shd.g_old_rec.information_category
221: ,p_information1_o
222: => per_ceo_shd.g_old_rec.information1
223: ,p_information2_o
224: => per_ceo_shd.g_old_rec.information2

Line 222: => per_ceo_shd.g_old_rec.information1

218: => per_ceo_shd.g_old_rec.attribute20
219: ,p_information_category_o
220: => per_ceo_shd.g_old_rec.information_category
221: ,p_information1_o
222: => per_ceo_shd.g_old_rec.information1
223: ,p_information2_o
224: => per_ceo_shd.g_old_rec.information2
225: ,p_information3_o
226: => per_ceo_shd.g_old_rec.information3

Line 224: => per_ceo_shd.g_old_rec.information2

220: => per_ceo_shd.g_old_rec.information_category
221: ,p_information1_o
222: => per_ceo_shd.g_old_rec.information1
223: ,p_information2_o
224: => per_ceo_shd.g_old_rec.information2
225: ,p_information3_o
226: => per_ceo_shd.g_old_rec.information3
227: ,p_information4_o
228: => per_ceo_shd.g_old_rec.information4

Line 226: => per_ceo_shd.g_old_rec.information3

222: => per_ceo_shd.g_old_rec.information1
223: ,p_information2_o
224: => per_ceo_shd.g_old_rec.information2
225: ,p_information3_o
226: => per_ceo_shd.g_old_rec.information3
227: ,p_information4_o
228: => per_ceo_shd.g_old_rec.information4
229: ,p_information5_o
230: => per_ceo_shd.g_old_rec.information5

Line 228: => per_ceo_shd.g_old_rec.information4

224: => per_ceo_shd.g_old_rec.information2
225: ,p_information3_o
226: => per_ceo_shd.g_old_rec.information3
227: ,p_information4_o
228: => per_ceo_shd.g_old_rec.information4
229: ,p_information5_o
230: => per_ceo_shd.g_old_rec.information5
231: ,p_information6_o
232: => per_ceo_shd.g_old_rec.information6

Line 230: => per_ceo_shd.g_old_rec.information5

226: => per_ceo_shd.g_old_rec.information3
227: ,p_information4_o
228: => per_ceo_shd.g_old_rec.information4
229: ,p_information5_o
230: => per_ceo_shd.g_old_rec.information5
231: ,p_information6_o
232: => per_ceo_shd.g_old_rec.information6
233: ,p_information7_o
234: => per_ceo_shd.g_old_rec.information7

Line 232: => per_ceo_shd.g_old_rec.information6

228: => per_ceo_shd.g_old_rec.information4
229: ,p_information5_o
230: => per_ceo_shd.g_old_rec.information5
231: ,p_information6_o
232: => per_ceo_shd.g_old_rec.information6
233: ,p_information7_o
234: => per_ceo_shd.g_old_rec.information7
235: ,p_information8_o
236: => per_ceo_shd.g_old_rec.information8

Line 234: => per_ceo_shd.g_old_rec.information7

230: => per_ceo_shd.g_old_rec.information5
231: ,p_information6_o
232: => per_ceo_shd.g_old_rec.information6
233: ,p_information7_o
234: => per_ceo_shd.g_old_rec.information7
235: ,p_information8_o
236: => per_ceo_shd.g_old_rec.information8
237: ,p_information9_o
238: => per_ceo_shd.g_old_rec.information9

Line 236: => per_ceo_shd.g_old_rec.information8

232: => per_ceo_shd.g_old_rec.information6
233: ,p_information7_o
234: => per_ceo_shd.g_old_rec.information7
235: ,p_information8_o
236: => per_ceo_shd.g_old_rec.information8
237: ,p_information9_o
238: => per_ceo_shd.g_old_rec.information9
239: ,p_information10_o
240: => per_ceo_shd.g_old_rec.information10

Line 238: => per_ceo_shd.g_old_rec.information9

234: => per_ceo_shd.g_old_rec.information7
235: ,p_information8_o
236: => per_ceo_shd.g_old_rec.information8
237: ,p_information9_o
238: => per_ceo_shd.g_old_rec.information9
239: ,p_information10_o
240: => per_ceo_shd.g_old_rec.information10
241: ,p_information11_o
242: => per_ceo_shd.g_old_rec.information11

Line 240: => per_ceo_shd.g_old_rec.information10

236: => per_ceo_shd.g_old_rec.information8
237: ,p_information9_o
238: => per_ceo_shd.g_old_rec.information9
239: ,p_information10_o
240: => per_ceo_shd.g_old_rec.information10
241: ,p_information11_o
242: => per_ceo_shd.g_old_rec.information11
243: ,p_information12_o
244: => per_ceo_shd.g_old_rec.information12

Line 242: => per_ceo_shd.g_old_rec.information11

238: => per_ceo_shd.g_old_rec.information9
239: ,p_information10_o
240: => per_ceo_shd.g_old_rec.information10
241: ,p_information11_o
242: => per_ceo_shd.g_old_rec.information11
243: ,p_information12_o
244: => per_ceo_shd.g_old_rec.information12
245: ,p_information13_o
246: => per_ceo_shd.g_old_rec.information13

Line 244: => per_ceo_shd.g_old_rec.information12

240: => per_ceo_shd.g_old_rec.information10
241: ,p_information11_o
242: => per_ceo_shd.g_old_rec.information11
243: ,p_information12_o
244: => per_ceo_shd.g_old_rec.information12
245: ,p_information13_o
246: => per_ceo_shd.g_old_rec.information13
247: ,p_information14_o
248: => per_ceo_shd.g_old_rec.information14

Line 246: => per_ceo_shd.g_old_rec.information13

242: => per_ceo_shd.g_old_rec.information11
243: ,p_information12_o
244: => per_ceo_shd.g_old_rec.information12
245: ,p_information13_o
246: => per_ceo_shd.g_old_rec.information13
247: ,p_information14_o
248: => per_ceo_shd.g_old_rec.information14
249: ,p_information15_o
250: => per_ceo_shd.g_old_rec.information15

Line 248: => per_ceo_shd.g_old_rec.information14

244: => per_ceo_shd.g_old_rec.information12
245: ,p_information13_o
246: => per_ceo_shd.g_old_rec.information13
247: ,p_information14_o
248: => per_ceo_shd.g_old_rec.information14
249: ,p_information15_o
250: => per_ceo_shd.g_old_rec.information15
251: ,p_information16_o
252: => per_ceo_shd.g_old_rec.information16

Line 250: => per_ceo_shd.g_old_rec.information15

246: => per_ceo_shd.g_old_rec.information13
247: ,p_information14_o
248: => per_ceo_shd.g_old_rec.information14
249: ,p_information15_o
250: => per_ceo_shd.g_old_rec.information15
251: ,p_information16_o
252: => per_ceo_shd.g_old_rec.information16
253: ,p_information17_o
254: => per_ceo_shd.g_old_rec.information17

Line 252: => per_ceo_shd.g_old_rec.information16

248: => per_ceo_shd.g_old_rec.information14
249: ,p_information15_o
250: => per_ceo_shd.g_old_rec.information15
251: ,p_information16_o
252: => per_ceo_shd.g_old_rec.information16
253: ,p_information17_o
254: => per_ceo_shd.g_old_rec.information17
255: ,p_information18_o
256: => per_ceo_shd.g_old_rec.information18

Line 254: => per_ceo_shd.g_old_rec.information17

250: => per_ceo_shd.g_old_rec.information15
251: ,p_information16_o
252: => per_ceo_shd.g_old_rec.information16
253: ,p_information17_o
254: => per_ceo_shd.g_old_rec.information17
255: ,p_information18_o
256: => per_ceo_shd.g_old_rec.information18
257: ,p_information19_o
258: => per_ceo_shd.g_old_rec.information19

Line 256: => per_ceo_shd.g_old_rec.information18

252: => per_ceo_shd.g_old_rec.information16
253: ,p_information17_o
254: => per_ceo_shd.g_old_rec.information17
255: ,p_information18_o
256: => per_ceo_shd.g_old_rec.information18
257: ,p_information19_o
258: => per_ceo_shd.g_old_rec.information19
259: ,p_information20_o
260: => per_ceo_shd.g_old_rec.information20

Line 258: => per_ceo_shd.g_old_rec.information19

254: => per_ceo_shd.g_old_rec.information17
255: ,p_information18_o
256: => per_ceo_shd.g_old_rec.information18
257: ,p_information19_o
258: => per_ceo_shd.g_old_rec.information19
259: ,p_information20_o
260: => per_ceo_shd.g_old_rec.information20
261: );
262: --

Line 260: => per_ceo_shd.g_old_rec.information20

256: => per_ceo_shd.g_old_rec.information18
257: ,p_information19_o
258: => per_ceo_shd.g_old_rec.information19
259: ,p_information20_o
260: => per_ceo_shd.g_old_rec.information20
261: );
262: --
263: exception
264: --

Line 280: (p_rec in per_ceo_shd.g_rec_type

276: -- ----------------------------------------------------------------------------
277: -- |---------------------------------< del >----------------------------------|
278: -- ----------------------------------------------------------------------------
279: Procedure del
280: (p_rec in per_ceo_shd.g_rec_type
281: ) is
282: --
283: l_proc varchar2(72) := g_package||'del';
284: --

Line 290: per_ceo_shd.lck

286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: -- We must lock the row which we need to delete.
289: --
290: per_ceo_shd.lck
291: (p_rec.comp_element_outcome_id
292: ,p_rec.object_version_number
293: );
294: --

Line 327: l_rec per_ceo_shd.g_rec_type;

323: (p_comp_element_outcome_id in number
324: ,p_object_version_number in number
325: ) is
326: --
327: l_rec per_ceo_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'del';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);