APPS.PER_POS_DEL dependencies on PER_POS_SHD

Line 51: Procedure delete_dml(p_rec in per_pos_shd.g_rec_type) is

47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_pos_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_pos_shd.g_api_dml := true; -- Set the api dml status

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

Line 65: per_pos_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from per_all_positions
63: where position_id = p_rec.position_id;
64: --
65: per_pos_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: per_pos_shd.g_api_dml := false; -- Unset the api dml status

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

Line 73: per_pos_shd.constraint_error

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

Line 76: per_pos_shd.g_api_dml := false; -- Unset the api dml status

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

Line 112: Procedure pre_delete(p_rec in per_pos_shd.g_rec_type) is

108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_pos_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in per_pos_shd.g_rec_type) is

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

Line 166: => per_pos_shd.g_old_rec.business_group_id

162: begin
163: per_pos_rkd.after_delete
164: (p_position_id => p_rec.position_id
165: ,p_business_group_id_o
166: => per_pos_shd.g_old_rec.business_group_id
167: ,p_job_id_o
168: => per_pos_shd.g_old_rec.job_id
169: ,p_organization_id_o
170: => per_pos_shd.g_old_rec.organization_id

Line 168: => per_pos_shd.g_old_rec.job_id

164: (p_position_id => p_rec.position_id
165: ,p_business_group_id_o
166: => per_pos_shd.g_old_rec.business_group_id
167: ,p_job_id_o
168: => per_pos_shd.g_old_rec.job_id
169: ,p_organization_id_o
170: => per_pos_shd.g_old_rec.organization_id
171: ,p_successor_position_id_o
172: => per_pos_shd.g_old_rec.successor_position_id

Line 170: => per_pos_shd.g_old_rec.organization_id

166: => per_pos_shd.g_old_rec.business_group_id
167: ,p_job_id_o
168: => per_pos_shd.g_old_rec.job_id
169: ,p_organization_id_o
170: => per_pos_shd.g_old_rec.organization_id
171: ,p_successor_position_id_o
172: => per_pos_shd.g_old_rec.successor_position_id
173: ,p_relief_position_id_o
174: => per_pos_shd.g_old_rec.relief_position_id

Line 172: => per_pos_shd.g_old_rec.successor_position_id

168: => per_pos_shd.g_old_rec.job_id
169: ,p_organization_id_o
170: => per_pos_shd.g_old_rec.organization_id
171: ,p_successor_position_id_o
172: => per_pos_shd.g_old_rec.successor_position_id
173: ,p_relief_position_id_o
174: => per_pos_shd.g_old_rec.relief_position_id
175: ,p_location_id_o
176: => per_pos_shd.g_old_rec.location_id

Line 174: => per_pos_shd.g_old_rec.relief_position_id

170: => per_pos_shd.g_old_rec.organization_id
171: ,p_successor_position_id_o
172: => per_pos_shd.g_old_rec.successor_position_id
173: ,p_relief_position_id_o
174: => per_pos_shd.g_old_rec.relief_position_id
175: ,p_location_id_o
176: => per_pos_shd.g_old_rec.location_id
177: ,p_position_definition_id_o
178: => per_pos_shd.g_old_rec.position_definition_id

Line 176: => per_pos_shd.g_old_rec.location_id

172: => per_pos_shd.g_old_rec.successor_position_id
173: ,p_relief_position_id_o
174: => per_pos_shd.g_old_rec.relief_position_id
175: ,p_location_id_o
176: => per_pos_shd.g_old_rec.location_id
177: ,p_position_definition_id_o
178: => per_pos_shd.g_old_rec.position_definition_id
179: ,p_date_effective_o
180: => per_pos_shd.g_old_rec.date_effective

Line 178: => per_pos_shd.g_old_rec.position_definition_id

174: => per_pos_shd.g_old_rec.relief_position_id
175: ,p_location_id_o
176: => per_pos_shd.g_old_rec.location_id
177: ,p_position_definition_id_o
178: => per_pos_shd.g_old_rec.position_definition_id
179: ,p_date_effective_o
180: => per_pos_shd.g_old_rec.date_effective
181: ,p_comments_o
182: => per_pos_shd.g_old_rec.comments

Line 180: => per_pos_shd.g_old_rec.date_effective

176: => per_pos_shd.g_old_rec.location_id
177: ,p_position_definition_id_o
178: => per_pos_shd.g_old_rec.position_definition_id
179: ,p_date_effective_o
180: => per_pos_shd.g_old_rec.date_effective
181: ,p_comments_o
182: => per_pos_shd.g_old_rec.comments
183: ,p_date_end_o
184: => per_pos_shd.g_old_rec.date_end

Line 182: => per_pos_shd.g_old_rec.comments

178: => per_pos_shd.g_old_rec.position_definition_id
179: ,p_date_effective_o
180: => per_pos_shd.g_old_rec.date_effective
181: ,p_comments_o
182: => per_pos_shd.g_old_rec.comments
183: ,p_date_end_o
184: => per_pos_shd.g_old_rec.date_end
185: ,p_frequency_o
186: => per_pos_shd.g_old_rec.frequency

Line 184: => per_pos_shd.g_old_rec.date_end

180: => per_pos_shd.g_old_rec.date_effective
181: ,p_comments_o
182: => per_pos_shd.g_old_rec.comments
183: ,p_date_end_o
184: => per_pos_shd.g_old_rec.date_end
185: ,p_frequency_o
186: => per_pos_shd.g_old_rec.frequency
187: ,p_name_o
188: => per_pos_shd.g_old_rec.name

Line 186: => per_pos_shd.g_old_rec.frequency

182: => per_pos_shd.g_old_rec.comments
183: ,p_date_end_o
184: => per_pos_shd.g_old_rec.date_end
185: ,p_frequency_o
186: => per_pos_shd.g_old_rec.frequency
187: ,p_name_o
188: => per_pos_shd.g_old_rec.name
189: ,p_probation_period_o
190: => per_pos_shd.g_old_rec.probation_period

Line 188: => per_pos_shd.g_old_rec.name

184: => per_pos_shd.g_old_rec.date_end
185: ,p_frequency_o
186: => per_pos_shd.g_old_rec.frequency
187: ,p_name_o
188: => per_pos_shd.g_old_rec.name
189: ,p_probation_period_o
190: => per_pos_shd.g_old_rec.probation_period
191: ,p_probation_period_units_o
192: => per_pos_shd.g_old_rec.probation_period_units

Line 190: => per_pos_shd.g_old_rec.probation_period

186: => per_pos_shd.g_old_rec.frequency
187: ,p_name_o
188: => per_pos_shd.g_old_rec.name
189: ,p_probation_period_o
190: => per_pos_shd.g_old_rec.probation_period
191: ,p_probation_period_units_o
192: => per_pos_shd.g_old_rec.probation_period_units
193: ,p_replacement_required_flag_o
194: => per_pos_shd.g_old_rec.replacement_required_flag

Line 192: => per_pos_shd.g_old_rec.probation_period_units

188: => per_pos_shd.g_old_rec.name
189: ,p_probation_period_o
190: => per_pos_shd.g_old_rec.probation_period
191: ,p_probation_period_units_o
192: => per_pos_shd.g_old_rec.probation_period_units
193: ,p_replacement_required_flag_o
194: => per_pos_shd.g_old_rec.replacement_required_flag
195: ,p_time_normal_finish_o
196: => per_pos_shd.g_old_rec.time_normal_finish

Line 194: => per_pos_shd.g_old_rec.replacement_required_flag

190: => per_pos_shd.g_old_rec.probation_period
191: ,p_probation_period_units_o
192: => per_pos_shd.g_old_rec.probation_period_units
193: ,p_replacement_required_flag_o
194: => per_pos_shd.g_old_rec.replacement_required_flag
195: ,p_time_normal_finish_o
196: => per_pos_shd.g_old_rec.time_normal_finish
197: ,p_time_normal_start_o
198: => per_pos_shd.g_old_rec.time_normal_start

Line 196: => per_pos_shd.g_old_rec.time_normal_finish

192: => per_pos_shd.g_old_rec.probation_period_units
193: ,p_replacement_required_flag_o
194: => per_pos_shd.g_old_rec.replacement_required_flag
195: ,p_time_normal_finish_o
196: => per_pos_shd.g_old_rec.time_normal_finish
197: ,p_time_normal_start_o
198: => per_pos_shd.g_old_rec.time_normal_start
199: ,p_status_o
200: => per_pos_shd.g_old_rec.status

Line 198: => per_pos_shd.g_old_rec.time_normal_start

194: => per_pos_shd.g_old_rec.replacement_required_flag
195: ,p_time_normal_finish_o
196: => per_pos_shd.g_old_rec.time_normal_finish
197: ,p_time_normal_start_o
198: => per_pos_shd.g_old_rec.time_normal_start
199: ,p_status_o
200: => per_pos_shd.g_old_rec.status
201: ,p_working_hours_o
202: => per_pos_shd.g_old_rec.working_hours

Line 200: => per_pos_shd.g_old_rec.status

196: => per_pos_shd.g_old_rec.time_normal_finish
197: ,p_time_normal_start_o
198: => per_pos_shd.g_old_rec.time_normal_start
199: ,p_status_o
200: => per_pos_shd.g_old_rec.status
201: ,p_working_hours_o
202: => per_pos_shd.g_old_rec.working_hours
203: ,p_request_id_o
204: => per_pos_shd.g_old_rec.request_id

Line 202: => per_pos_shd.g_old_rec.working_hours

198: => per_pos_shd.g_old_rec.time_normal_start
199: ,p_status_o
200: => per_pos_shd.g_old_rec.status
201: ,p_working_hours_o
202: => per_pos_shd.g_old_rec.working_hours
203: ,p_request_id_o
204: => per_pos_shd.g_old_rec.request_id
205: ,p_program_application_id_o
206: => per_pos_shd.g_old_rec.program_application_id

Line 204: => per_pos_shd.g_old_rec.request_id

200: => per_pos_shd.g_old_rec.status
201: ,p_working_hours_o
202: => per_pos_shd.g_old_rec.working_hours
203: ,p_request_id_o
204: => per_pos_shd.g_old_rec.request_id
205: ,p_program_application_id_o
206: => per_pos_shd.g_old_rec.program_application_id
207: ,p_program_id_o
208: => per_pos_shd.g_old_rec.program_id

Line 206: => per_pos_shd.g_old_rec.program_application_id

202: => per_pos_shd.g_old_rec.working_hours
203: ,p_request_id_o
204: => per_pos_shd.g_old_rec.request_id
205: ,p_program_application_id_o
206: => per_pos_shd.g_old_rec.program_application_id
207: ,p_program_id_o
208: => per_pos_shd.g_old_rec.program_id
209: ,p_program_update_date_o
210: => per_pos_shd.g_old_rec.program_update_date

Line 208: => per_pos_shd.g_old_rec.program_id

204: => per_pos_shd.g_old_rec.request_id
205: ,p_program_application_id_o
206: => per_pos_shd.g_old_rec.program_application_id
207: ,p_program_id_o
208: => per_pos_shd.g_old_rec.program_id
209: ,p_program_update_date_o
210: => per_pos_shd.g_old_rec.program_update_date
211: ,p_attribute_category_o
212: => per_pos_shd.g_old_rec.attribute_category

Line 210: => per_pos_shd.g_old_rec.program_update_date

206: => per_pos_shd.g_old_rec.program_application_id
207: ,p_program_id_o
208: => per_pos_shd.g_old_rec.program_id
209: ,p_program_update_date_o
210: => per_pos_shd.g_old_rec.program_update_date
211: ,p_attribute_category_o
212: => per_pos_shd.g_old_rec.attribute_category
213: ,p_attribute1_o
214: => per_pos_shd.g_old_rec.attribute1

Line 212: => per_pos_shd.g_old_rec.attribute_category

208: => per_pos_shd.g_old_rec.program_id
209: ,p_program_update_date_o
210: => per_pos_shd.g_old_rec.program_update_date
211: ,p_attribute_category_o
212: => per_pos_shd.g_old_rec.attribute_category
213: ,p_attribute1_o
214: => per_pos_shd.g_old_rec.attribute1
215: ,p_attribute2_o
216: => per_pos_shd.g_old_rec.attribute2

Line 214: => per_pos_shd.g_old_rec.attribute1

210: => per_pos_shd.g_old_rec.program_update_date
211: ,p_attribute_category_o
212: => per_pos_shd.g_old_rec.attribute_category
213: ,p_attribute1_o
214: => per_pos_shd.g_old_rec.attribute1
215: ,p_attribute2_o
216: => per_pos_shd.g_old_rec.attribute2
217: ,p_attribute3_o
218: => per_pos_shd.g_old_rec.attribute3

Line 216: => per_pos_shd.g_old_rec.attribute2

212: => per_pos_shd.g_old_rec.attribute_category
213: ,p_attribute1_o
214: => per_pos_shd.g_old_rec.attribute1
215: ,p_attribute2_o
216: => per_pos_shd.g_old_rec.attribute2
217: ,p_attribute3_o
218: => per_pos_shd.g_old_rec.attribute3
219: ,p_attribute4_o
220: => per_pos_shd.g_old_rec.attribute4

Line 218: => per_pos_shd.g_old_rec.attribute3

214: => per_pos_shd.g_old_rec.attribute1
215: ,p_attribute2_o
216: => per_pos_shd.g_old_rec.attribute2
217: ,p_attribute3_o
218: => per_pos_shd.g_old_rec.attribute3
219: ,p_attribute4_o
220: => per_pos_shd.g_old_rec.attribute4
221: ,p_attribute5_o
222: => per_pos_shd.g_old_rec.attribute5

Line 220: => per_pos_shd.g_old_rec.attribute4

216: => per_pos_shd.g_old_rec.attribute2
217: ,p_attribute3_o
218: => per_pos_shd.g_old_rec.attribute3
219: ,p_attribute4_o
220: => per_pos_shd.g_old_rec.attribute4
221: ,p_attribute5_o
222: => per_pos_shd.g_old_rec.attribute5
223: ,p_attribute6_o
224: => per_pos_shd.g_old_rec.attribute6

Line 222: => per_pos_shd.g_old_rec.attribute5

218: => per_pos_shd.g_old_rec.attribute3
219: ,p_attribute4_o
220: => per_pos_shd.g_old_rec.attribute4
221: ,p_attribute5_o
222: => per_pos_shd.g_old_rec.attribute5
223: ,p_attribute6_o
224: => per_pos_shd.g_old_rec.attribute6
225: ,p_attribute7_o
226: => per_pos_shd.g_old_rec.attribute7

Line 224: => per_pos_shd.g_old_rec.attribute6

220: => per_pos_shd.g_old_rec.attribute4
221: ,p_attribute5_o
222: => per_pos_shd.g_old_rec.attribute5
223: ,p_attribute6_o
224: => per_pos_shd.g_old_rec.attribute6
225: ,p_attribute7_o
226: => per_pos_shd.g_old_rec.attribute7
227: ,p_attribute8_o
228: => per_pos_shd.g_old_rec.attribute8

Line 226: => per_pos_shd.g_old_rec.attribute7

222: => per_pos_shd.g_old_rec.attribute5
223: ,p_attribute6_o
224: => per_pos_shd.g_old_rec.attribute6
225: ,p_attribute7_o
226: => per_pos_shd.g_old_rec.attribute7
227: ,p_attribute8_o
228: => per_pos_shd.g_old_rec.attribute8
229: ,p_attribute9_o
230: => per_pos_shd.g_old_rec.attribute9

Line 228: => per_pos_shd.g_old_rec.attribute8

224: => per_pos_shd.g_old_rec.attribute6
225: ,p_attribute7_o
226: => per_pos_shd.g_old_rec.attribute7
227: ,p_attribute8_o
228: => per_pos_shd.g_old_rec.attribute8
229: ,p_attribute9_o
230: => per_pos_shd.g_old_rec.attribute9
231: ,p_attribute10_o
232: => per_pos_shd.g_old_rec.attribute10

Line 230: => per_pos_shd.g_old_rec.attribute9

226: => per_pos_shd.g_old_rec.attribute7
227: ,p_attribute8_o
228: => per_pos_shd.g_old_rec.attribute8
229: ,p_attribute9_o
230: => per_pos_shd.g_old_rec.attribute9
231: ,p_attribute10_o
232: => per_pos_shd.g_old_rec.attribute10
233: ,p_attribute11_o
234: => per_pos_shd.g_old_rec.attribute11

Line 232: => per_pos_shd.g_old_rec.attribute10

228: => per_pos_shd.g_old_rec.attribute8
229: ,p_attribute9_o
230: => per_pos_shd.g_old_rec.attribute9
231: ,p_attribute10_o
232: => per_pos_shd.g_old_rec.attribute10
233: ,p_attribute11_o
234: => per_pos_shd.g_old_rec.attribute11
235: ,p_attribute12_o
236: => per_pos_shd.g_old_rec.attribute12

Line 234: => per_pos_shd.g_old_rec.attribute11

230: => per_pos_shd.g_old_rec.attribute9
231: ,p_attribute10_o
232: => per_pos_shd.g_old_rec.attribute10
233: ,p_attribute11_o
234: => per_pos_shd.g_old_rec.attribute11
235: ,p_attribute12_o
236: => per_pos_shd.g_old_rec.attribute12
237: ,p_attribute13_o
238: => per_pos_shd.g_old_rec.attribute13

Line 236: => per_pos_shd.g_old_rec.attribute12

232: => per_pos_shd.g_old_rec.attribute10
233: ,p_attribute11_o
234: => per_pos_shd.g_old_rec.attribute11
235: ,p_attribute12_o
236: => per_pos_shd.g_old_rec.attribute12
237: ,p_attribute13_o
238: => per_pos_shd.g_old_rec.attribute13
239: ,p_attribute14_o
240: => per_pos_shd.g_old_rec.attribute14

Line 238: => per_pos_shd.g_old_rec.attribute13

234: => per_pos_shd.g_old_rec.attribute11
235: ,p_attribute12_o
236: => per_pos_shd.g_old_rec.attribute12
237: ,p_attribute13_o
238: => per_pos_shd.g_old_rec.attribute13
239: ,p_attribute14_o
240: => per_pos_shd.g_old_rec.attribute14
241: ,p_attribute15_o
242: => per_pos_shd.g_old_rec.attribute15

Line 240: => per_pos_shd.g_old_rec.attribute14

236: => per_pos_shd.g_old_rec.attribute12
237: ,p_attribute13_o
238: => per_pos_shd.g_old_rec.attribute13
239: ,p_attribute14_o
240: => per_pos_shd.g_old_rec.attribute14
241: ,p_attribute15_o
242: => per_pos_shd.g_old_rec.attribute15
243: ,p_attribute16_o
244: => per_pos_shd.g_old_rec.attribute16

Line 242: => per_pos_shd.g_old_rec.attribute15

238: => per_pos_shd.g_old_rec.attribute13
239: ,p_attribute14_o
240: => per_pos_shd.g_old_rec.attribute14
241: ,p_attribute15_o
242: => per_pos_shd.g_old_rec.attribute15
243: ,p_attribute16_o
244: => per_pos_shd.g_old_rec.attribute16
245: ,p_attribute17_o
246: => per_pos_shd.g_old_rec.attribute17

Line 244: => per_pos_shd.g_old_rec.attribute16

240: => per_pos_shd.g_old_rec.attribute14
241: ,p_attribute15_o
242: => per_pos_shd.g_old_rec.attribute15
243: ,p_attribute16_o
244: => per_pos_shd.g_old_rec.attribute16
245: ,p_attribute17_o
246: => per_pos_shd.g_old_rec.attribute17
247: ,p_attribute18_o
248: => per_pos_shd.g_old_rec.attribute18

Line 246: => per_pos_shd.g_old_rec.attribute17

242: => per_pos_shd.g_old_rec.attribute15
243: ,p_attribute16_o
244: => per_pos_shd.g_old_rec.attribute16
245: ,p_attribute17_o
246: => per_pos_shd.g_old_rec.attribute17
247: ,p_attribute18_o
248: => per_pos_shd.g_old_rec.attribute18
249: ,p_attribute19_o
250: => per_pos_shd.g_old_rec.attribute19

Line 248: => per_pos_shd.g_old_rec.attribute18

244: => per_pos_shd.g_old_rec.attribute16
245: ,p_attribute17_o
246: => per_pos_shd.g_old_rec.attribute17
247: ,p_attribute18_o
248: => per_pos_shd.g_old_rec.attribute18
249: ,p_attribute19_o
250: => per_pos_shd.g_old_rec.attribute19
251: ,p_attribute20_o
252: => per_pos_shd.g_old_rec.attribute20

Line 250: => per_pos_shd.g_old_rec.attribute19

246: => per_pos_shd.g_old_rec.attribute17
247: ,p_attribute18_o
248: => per_pos_shd.g_old_rec.attribute18
249: ,p_attribute19_o
250: => per_pos_shd.g_old_rec.attribute19
251: ,p_attribute20_o
252: => per_pos_shd.g_old_rec.attribute20
253: ,p_object_version_number_o
254: => per_pos_shd.g_old_rec.object_version_number

Line 252: => per_pos_shd.g_old_rec.attribute20

248: => per_pos_shd.g_old_rec.attribute18
249: ,p_attribute19_o
250: => per_pos_shd.g_old_rec.attribute19
251: ,p_attribute20_o
252: => per_pos_shd.g_old_rec.attribute20
253: ,p_object_version_number_o
254: => per_pos_shd.g_old_rec.object_version_number
255: );
256: exception

Line 254: => per_pos_shd.g_old_rec.object_version_number

250: => per_pos_shd.g_old_rec.attribute19
251: ,p_attribute20_o
252: => per_pos_shd.g_old_rec.attribute20
253: ,p_object_version_number_o
254: => per_pos_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error

Line 273: p_rec in per_pos_shd.g_rec_type,

269: -- |---------------------------------< del >----------------------------------|
270: -- ----------------------------------------------------------------------------
271: Procedure del
272: (
273: p_rec in per_pos_shd.g_rec_type,
274: p_validate in boolean default false
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';

Line 293: per_pos_shd.lck

289: End If;
290: --
291: -- We must lock the row which we need to delete.
292: --
293: per_pos_shd.lck
294: (
295: p_rec.position_id,
296: p_rec.object_version_number
297: );

Line 341: l_rec per_pos_shd.g_rec_type;

337: p_object_version_number in number,
338: p_validate in boolean default false
339: ) is
340: --
341: l_rec per_pos_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'del';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);