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_VAC_DEL dependencies on PER_VAC_SHD

Line 52: (p_rec in per_vac_shd.g_rec_type

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

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

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

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

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

Line 75: per_vac_shd.constraint_error

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

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

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

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

Line 168: => per_vac_shd.g_old_rec.business_group_id

164: per_vac_rkd.after_delete
165: (p_vacancy_id
166: => p_rec.vacancy_id
167: ,p_business_group_id_o
168: => per_vac_shd.g_old_rec.business_group_id
169: ,p_position_id_o
170: => per_vac_shd.g_old_rec.position_id
171: ,p_job_id_o
172: => per_vac_shd.g_old_rec.job_id

Line 170: => per_vac_shd.g_old_rec.position_id

166: => p_rec.vacancy_id
167: ,p_business_group_id_o
168: => per_vac_shd.g_old_rec.business_group_id
169: ,p_position_id_o
170: => per_vac_shd.g_old_rec.position_id
171: ,p_job_id_o
172: => per_vac_shd.g_old_rec.job_id
173: ,p_grade_id_o
174: => per_vac_shd.g_old_rec.grade_id

Line 172: => per_vac_shd.g_old_rec.job_id

168: => per_vac_shd.g_old_rec.business_group_id
169: ,p_position_id_o
170: => per_vac_shd.g_old_rec.position_id
171: ,p_job_id_o
172: => per_vac_shd.g_old_rec.job_id
173: ,p_grade_id_o
174: => per_vac_shd.g_old_rec.grade_id
175: ,p_organization_id_o
176: => per_vac_shd.g_old_rec.organization_id

Line 174: => per_vac_shd.g_old_rec.grade_id

170: => per_vac_shd.g_old_rec.position_id
171: ,p_job_id_o
172: => per_vac_shd.g_old_rec.job_id
173: ,p_grade_id_o
174: => per_vac_shd.g_old_rec.grade_id
175: ,p_organization_id_o
176: => per_vac_shd.g_old_rec.organization_id
177: ,p_requisition_id_o
178: => per_vac_shd.g_old_rec.requisition_id

Line 176: => per_vac_shd.g_old_rec.organization_id

172: => per_vac_shd.g_old_rec.job_id
173: ,p_grade_id_o
174: => per_vac_shd.g_old_rec.grade_id
175: ,p_organization_id_o
176: => per_vac_shd.g_old_rec.organization_id
177: ,p_requisition_id_o
178: => per_vac_shd.g_old_rec.requisition_id
179: ,p_people_group_id_o
180: => per_vac_shd.g_old_rec.people_group_id

Line 178: => per_vac_shd.g_old_rec.requisition_id

174: => per_vac_shd.g_old_rec.grade_id
175: ,p_organization_id_o
176: => per_vac_shd.g_old_rec.organization_id
177: ,p_requisition_id_o
178: => per_vac_shd.g_old_rec.requisition_id
179: ,p_people_group_id_o
180: => per_vac_shd.g_old_rec.people_group_id
181: ,p_location_id_o
182: => per_vac_shd.g_old_rec.location_id

Line 180: => per_vac_shd.g_old_rec.people_group_id

176: => per_vac_shd.g_old_rec.organization_id
177: ,p_requisition_id_o
178: => per_vac_shd.g_old_rec.requisition_id
179: ,p_people_group_id_o
180: => per_vac_shd.g_old_rec.people_group_id
181: ,p_location_id_o
182: => per_vac_shd.g_old_rec.location_id
183: ,p_recruiter_id_o
184: => per_vac_shd.g_old_rec.recruiter_id

Line 182: => per_vac_shd.g_old_rec.location_id

178: => per_vac_shd.g_old_rec.requisition_id
179: ,p_people_group_id_o
180: => per_vac_shd.g_old_rec.people_group_id
181: ,p_location_id_o
182: => per_vac_shd.g_old_rec.location_id
183: ,p_recruiter_id_o
184: => per_vac_shd.g_old_rec.recruiter_id
185: ,p_date_from_o
186: => per_vac_shd.g_old_rec.date_from

Line 184: => per_vac_shd.g_old_rec.recruiter_id

180: => per_vac_shd.g_old_rec.people_group_id
181: ,p_location_id_o
182: => per_vac_shd.g_old_rec.location_id
183: ,p_recruiter_id_o
184: => per_vac_shd.g_old_rec.recruiter_id
185: ,p_date_from_o
186: => per_vac_shd.g_old_rec.date_from
187: ,p_name_o
188: => per_vac_shd.g_old_rec.name

Line 186: => per_vac_shd.g_old_rec.date_from

182: => per_vac_shd.g_old_rec.location_id
183: ,p_recruiter_id_o
184: => per_vac_shd.g_old_rec.recruiter_id
185: ,p_date_from_o
186: => per_vac_shd.g_old_rec.date_from
187: ,p_name_o
188: => per_vac_shd.g_old_rec.name
189: ,p_comments_o
190: => per_vac_shd.g_old_rec.comments

Line 188: => per_vac_shd.g_old_rec.name

184: => per_vac_shd.g_old_rec.recruiter_id
185: ,p_date_from_o
186: => per_vac_shd.g_old_rec.date_from
187: ,p_name_o
188: => per_vac_shd.g_old_rec.name
189: ,p_comments_o
190: => per_vac_shd.g_old_rec.comments
191: ,p_date_to_o
192: => per_vac_shd.g_old_rec.date_to

Line 190: => per_vac_shd.g_old_rec.comments

186: => per_vac_shd.g_old_rec.date_from
187: ,p_name_o
188: => per_vac_shd.g_old_rec.name
189: ,p_comments_o
190: => per_vac_shd.g_old_rec.comments
191: ,p_date_to_o
192: => per_vac_shd.g_old_rec.date_to
193: ,p_description_o
194: => per_vac_shd.g_old_rec.description

Line 192: => per_vac_shd.g_old_rec.date_to

188: => per_vac_shd.g_old_rec.name
189: ,p_comments_o
190: => per_vac_shd.g_old_rec.comments
191: ,p_date_to_o
192: => per_vac_shd.g_old_rec.date_to
193: ,p_description_o
194: => per_vac_shd.g_old_rec.description
195: ,p_number_of_openings_o
196: => per_vac_shd.g_old_rec.number_of_openings

Line 194: => per_vac_shd.g_old_rec.description

190: => per_vac_shd.g_old_rec.comments
191: ,p_date_to_o
192: => per_vac_shd.g_old_rec.date_to
193: ,p_description_o
194: => per_vac_shd.g_old_rec.description
195: ,p_number_of_openings_o
196: => per_vac_shd.g_old_rec.number_of_openings
197: ,p_status_o
198: => per_vac_shd.g_old_rec.status

Line 196: => per_vac_shd.g_old_rec.number_of_openings

192: => per_vac_shd.g_old_rec.date_to
193: ,p_description_o
194: => per_vac_shd.g_old_rec.description
195: ,p_number_of_openings_o
196: => per_vac_shd.g_old_rec.number_of_openings
197: ,p_status_o
198: => per_vac_shd.g_old_rec.status
199: ,p_request_id_o
200: => per_vac_shd.g_old_rec.request_id

Line 198: => per_vac_shd.g_old_rec.status

194: => per_vac_shd.g_old_rec.description
195: ,p_number_of_openings_o
196: => per_vac_shd.g_old_rec.number_of_openings
197: ,p_status_o
198: => per_vac_shd.g_old_rec.status
199: ,p_request_id_o
200: => per_vac_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_vac_shd.g_old_rec.program_application_id

Line 200: => per_vac_shd.g_old_rec.request_id

196: => per_vac_shd.g_old_rec.number_of_openings
197: ,p_status_o
198: => per_vac_shd.g_old_rec.status
199: ,p_request_id_o
200: => per_vac_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_vac_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_vac_shd.g_old_rec.program_id

Line 202: => per_vac_shd.g_old_rec.program_application_id

198: => per_vac_shd.g_old_rec.status
199: ,p_request_id_o
200: => per_vac_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_vac_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_vac_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_vac_shd.g_old_rec.program_update_date

Line 204: => per_vac_shd.g_old_rec.program_id

200: => per_vac_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_vac_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_vac_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_vac_shd.g_old_rec.program_update_date
207: ,p_attribute_category_o
208: => per_vac_shd.g_old_rec.attribute_category

Line 206: => per_vac_shd.g_old_rec.program_update_date

202: => per_vac_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_vac_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_vac_shd.g_old_rec.program_update_date
207: ,p_attribute_category_o
208: => per_vac_shd.g_old_rec.attribute_category
209: ,p_attribute1_o
210: => per_vac_shd.g_old_rec.attribute1

Line 208: => per_vac_shd.g_old_rec.attribute_category

204: => per_vac_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_vac_shd.g_old_rec.program_update_date
207: ,p_attribute_category_o
208: => per_vac_shd.g_old_rec.attribute_category
209: ,p_attribute1_o
210: => per_vac_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => per_vac_shd.g_old_rec.attribute2

Line 210: => per_vac_shd.g_old_rec.attribute1

206: => per_vac_shd.g_old_rec.program_update_date
207: ,p_attribute_category_o
208: => per_vac_shd.g_old_rec.attribute_category
209: ,p_attribute1_o
210: => per_vac_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => per_vac_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => per_vac_shd.g_old_rec.attribute3

Line 212: => per_vac_shd.g_old_rec.attribute2

208: => per_vac_shd.g_old_rec.attribute_category
209: ,p_attribute1_o
210: => per_vac_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => per_vac_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => per_vac_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => per_vac_shd.g_old_rec.attribute4

Line 214: => per_vac_shd.g_old_rec.attribute3

210: => per_vac_shd.g_old_rec.attribute1
211: ,p_attribute2_o
212: => per_vac_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => per_vac_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => per_vac_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => per_vac_shd.g_old_rec.attribute5

Line 216: => per_vac_shd.g_old_rec.attribute4

212: => per_vac_shd.g_old_rec.attribute2
213: ,p_attribute3_o
214: => per_vac_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => per_vac_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => per_vac_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => per_vac_shd.g_old_rec.attribute6

Line 218: => per_vac_shd.g_old_rec.attribute5

214: => per_vac_shd.g_old_rec.attribute3
215: ,p_attribute4_o
216: => per_vac_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => per_vac_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => per_vac_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => per_vac_shd.g_old_rec.attribute7

Line 220: => per_vac_shd.g_old_rec.attribute6

216: => per_vac_shd.g_old_rec.attribute4
217: ,p_attribute5_o
218: => per_vac_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => per_vac_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => per_vac_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => per_vac_shd.g_old_rec.attribute8

Line 222: => per_vac_shd.g_old_rec.attribute7

218: => per_vac_shd.g_old_rec.attribute5
219: ,p_attribute6_o
220: => per_vac_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => per_vac_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => per_vac_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => per_vac_shd.g_old_rec.attribute9

Line 224: => per_vac_shd.g_old_rec.attribute8

220: => per_vac_shd.g_old_rec.attribute6
221: ,p_attribute7_o
222: => per_vac_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => per_vac_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => per_vac_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => per_vac_shd.g_old_rec.attribute10

Line 226: => per_vac_shd.g_old_rec.attribute9

222: => per_vac_shd.g_old_rec.attribute7
223: ,p_attribute8_o
224: => per_vac_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => per_vac_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => per_vac_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => per_vac_shd.g_old_rec.attribute11

Line 228: => per_vac_shd.g_old_rec.attribute10

224: => per_vac_shd.g_old_rec.attribute8
225: ,p_attribute9_o
226: => per_vac_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => per_vac_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => per_vac_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => per_vac_shd.g_old_rec.attribute12

Line 230: => per_vac_shd.g_old_rec.attribute11

226: => per_vac_shd.g_old_rec.attribute9
227: ,p_attribute10_o
228: => per_vac_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => per_vac_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => per_vac_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => per_vac_shd.g_old_rec.attribute13

Line 232: => per_vac_shd.g_old_rec.attribute12

228: => per_vac_shd.g_old_rec.attribute10
229: ,p_attribute11_o
230: => per_vac_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => per_vac_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => per_vac_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => per_vac_shd.g_old_rec.attribute14

Line 234: => per_vac_shd.g_old_rec.attribute13

230: => per_vac_shd.g_old_rec.attribute11
231: ,p_attribute12_o
232: => per_vac_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => per_vac_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => per_vac_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => per_vac_shd.g_old_rec.attribute15

Line 236: => per_vac_shd.g_old_rec.attribute14

232: => per_vac_shd.g_old_rec.attribute12
233: ,p_attribute13_o
234: => per_vac_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => per_vac_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => per_vac_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => per_vac_shd.g_old_rec.attribute16

Line 238: => per_vac_shd.g_old_rec.attribute15

234: => per_vac_shd.g_old_rec.attribute13
235: ,p_attribute14_o
236: => per_vac_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => per_vac_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => per_vac_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => per_vac_shd.g_old_rec.attribute17

Line 240: => per_vac_shd.g_old_rec.attribute16

236: => per_vac_shd.g_old_rec.attribute14
237: ,p_attribute15_o
238: => per_vac_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => per_vac_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => per_vac_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => per_vac_shd.g_old_rec.attribute18

Line 242: => per_vac_shd.g_old_rec.attribute17

238: => per_vac_shd.g_old_rec.attribute15
239: ,p_attribute16_o
240: => per_vac_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => per_vac_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => per_vac_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => per_vac_shd.g_old_rec.attribute19

Line 244: => per_vac_shd.g_old_rec.attribute18

240: => per_vac_shd.g_old_rec.attribute16
241: ,p_attribute17_o
242: => per_vac_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => per_vac_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => per_vac_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => per_vac_shd.g_old_rec.attribute20

Line 246: => per_vac_shd.g_old_rec.attribute19

242: => per_vac_shd.g_old_rec.attribute17
243: ,p_attribute18_o
244: => per_vac_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => per_vac_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => per_vac_shd.g_old_rec.attribute20
249: ,p_vacancy_category_o
250: => per_vac_shd.g_old_rec.vacancy_category

Line 248: => per_vac_shd.g_old_rec.attribute20

244: => per_vac_shd.g_old_rec.attribute18
245: ,p_attribute19_o
246: => per_vac_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => per_vac_shd.g_old_rec.attribute20
249: ,p_vacancy_category_o
250: => per_vac_shd.g_old_rec.vacancy_category
251: ,p_budget_measurement_type_o
252: => per_vac_shd.g_old_rec.budget_measurement_type

Line 250: => per_vac_shd.g_old_rec.vacancy_category

246: => per_vac_shd.g_old_rec.attribute19
247: ,p_attribute20_o
248: => per_vac_shd.g_old_rec.attribute20
249: ,p_vacancy_category_o
250: => per_vac_shd.g_old_rec.vacancy_category
251: ,p_budget_measurement_type_o
252: => per_vac_shd.g_old_rec.budget_measurement_type
253: ,p_budget_measurement_value_o
254: => per_vac_shd.g_old_rec.budget_measurement_value

Line 252: => per_vac_shd.g_old_rec.budget_measurement_type

248: => per_vac_shd.g_old_rec.attribute20
249: ,p_vacancy_category_o
250: => per_vac_shd.g_old_rec.vacancy_category
251: ,p_budget_measurement_type_o
252: => per_vac_shd.g_old_rec.budget_measurement_type
253: ,p_budget_measurement_value_o
254: => per_vac_shd.g_old_rec.budget_measurement_value
255: ,p_manager_id_o
256: => per_vac_shd.g_old_rec.manager_id

Line 254: => per_vac_shd.g_old_rec.budget_measurement_value

250: => per_vac_shd.g_old_rec.vacancy_category
251: ,p_budget_measurement_type_o
252: => per_vac_shd.g_old_rec.budget_measurement_type
253: ,p_budget_measurement_value_o
254: => per_vac_shd.g_old_rec.budget_measurement_value
255: ,p_manager_id_o
256: => per_vac_shd.g_old_rec.manager_id
257: ,p_security_method_o
258: => per_vac_shd.g_old_rec.security_method

Line 256: => per_vac_shd.g_old_rec.manager_id

252: => per_vac_shd.g_old_rec.budget_measurement_type
253: ,p_budget_measurement_value_o
254: => per_vac_shd.g_old_rec.budget_measurement_value
255: ,p_manager_id_o
256: => per_vac_shd.g_old_rec.manager_id
257: ,p_security_method_o
258: => per_vac_shd.g_old_rec.security_method
259: ,p_primary_posting_id_o
260: => per_vac_shd.g_old_rec.primary_posting_id

Line 258: => per_vac_shd.g_old_rec.security_method

254: => per_vac_shd.g_old_rec.budget_measurement_value
255: ,p_manager_id_o
256: => per_vac_shd.g_old_rec.manager_id
257: ,p_security_method_o
258: => per_vac_shd.g_old_rec.security_method
259: ,p_primary_posting_id_o
260: => per_vac_shd.g_old_rec.primary_posting_id
261: ,p_assessment_id_o
262: => per_vac_shd.g_old_rec.assessment_id

Line 260: => per_vac_shd.g_old_rec.primary_posting_id

256: => per_vac_shd.g_old_rec.manager_id
257: ,p_security_method_o
258: => per_vac_shd.g_old_rec.security_method
259: ,p_primary_posting_id_o
260: => per_vac_shd.g_old_rec.primary_posting_id
261: ,p_assessment_id_o
262: => per_vac_shd.g_old_rec.assessment_id
263: ,p_object_version_number_o
264: => per_vac_shd.g_old_rec.object_version_number

Line 262: => per_vac_shd.g_old_rec.assessment_id

258: => per_vac_shd.g_old_rec.security_method
259: ,p_primary_posting_id_o
260: => per_vac_shd.g_old_rec.primary_posting_id
261: ,p_assessment_id_o
262: => per_vac_shd.g_old_rec.assessment_id
263: ,p_object_version_number_o
264: => per_vac_shd.g_old_rec.object_version_number
265: );
266: --

Line 264: => per_vac_shd.g_old_rec.object_version_number

260: => per_vac_shd.g_old_rec.primary_posting_id
261: ,p_assessment_id_o
262: => per_vac_shd.g_old_rec.assessment_id
263: ,p_object_version_number_o
264: => per_vac_shd.g_old_rec.object_version_number
265: );
266: --
267: exception
268: --

Line 284: (p_rec in per_vac_shd.g_rec_type

280: -- ----------------------------------------------------------------------------
281: -- |---------------------------------< del >----------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure del
284: (p_rec in per_vac_shd.g_rec_type
285: ) is
286: --
287: l_proc varchar2(72) := g_package||'del';
288: --

Line 294: per_vac_shd.lck

290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to delete.
293: --
294: per_vac_shd.lck
295: (p_rec.vacancy_id
296: ,p_rec.object_version_number
297: );
298: --

Line 325: l_rec per_vac_shd.g_rec_type;

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