APPS.IRC_IRF_DEL dependencies on IRC_IRF_SHD

Line 54: (p_rec in out nocopy irc_irf_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy irc_irf_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy irc_irf_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy irc_irf_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy irc_irf_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy irc_irf_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := irc_irf_shd.g_old_rec.start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.start_date
169: := irc_irf_shd.g_old_rec.start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.end_date := p_validation_start_date;
173: Else

Line 179: irc_irf_shd.upd_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: irc_irf_shd.upd_end_date
180: (p_effective_date => p_effective_date
181: ,p_referral_info_id => p_rec.referral_info_id
182: ,p_new_end_date => p_rec.end_date
183: ,p_object_version_number => p_rec.object_version_number

Line 226: (p_rec in out nocopy irc_irf_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_delete
226: (p_rec in out nocopy irc_irf_shd.g_rec_type
227: ,p_effective_date in date
228: ,p_datetrack_mode in varchar2
229: ,p_validation_start_date in date
230: ,p_validation_end_date in date

Line 286: (p_rec in irc_irf_shd.g_rec_type

282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure post_delete
286: (p_rec in irc_irf_shd.g_rec_type
287: ,p_effective_date in date
288: ,p_datetrack_mode in varchar2
289: ,p_validation_start_date in date
290: ,p_validation_end_date in date

Line 307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id

303: ,p_validation_end_date => p_validation_end_date
304: ,p_referral_info_id => p_rec.referral_info_id
305: ,p_start_date => p_rec.start_date
306: ,p_end_date => p_rec.end_date
307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id
308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type

Line 308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type

304: ,p_referral_info_id => p_rec.referral_info_id
305: ,p_start_date => p_rec.start_date
306: ,p_end_date => p_rec.end_date
307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id
308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name

Line 309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date

305: ,p_start_date => p_rec.start_date
306: ,p_end_date => p_rec.end_date
307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id
308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1

Line 310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date

306: ,p_end_date => p_rec.end_date
307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id
308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1

Line 311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type

307: ,p_object_id_o => irc_irf_shd.g_old_rec.object_id
308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2

Line 312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name

308: ,p_object_type_o => irc_irf_shd.g_old_rec.object_type
309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2

Line 313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1

309: ,p_start_date_o => irc_irf_shd.g_old_rec.start_date
310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3

Line 314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1

310: ,p_end_date_o => irc_irf_shd.g_old_rec.end_date
311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3

Line 315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2

311: ,p_source_type_o => irc_irf_shd.g_old_rec.source_type
312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4

Line 316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2

312: ,p_source_name_o => irc_irf_shd.g_old_rec.source_name
313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4

Line 317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3

313: ,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5

Line 318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3

314: ,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5

Line 319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4

315: ,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id

Line 320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4

316: ,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment

Line 321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5

317: ,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment

Line 322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5

318: ,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category

Line 323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id

319: ,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1

Line 324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment

320: ,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2

Line 325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment

321: ,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3

Line 326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category

322: ,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4

Line 327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1

323: ,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5

Line 328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2

324: ,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6

Line 329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3

325: ,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7

Line 330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4

326: ,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8

Line 331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5

327: ,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9

Line 332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6

328: ,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10

Line 333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7

329: ,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category

Line 334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8

330: ,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1

Line 335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9

331: ,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2

Line 336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10

332: ,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3

Line 337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category

333: ,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4

Line 338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1

334: ,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5

Line 339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2

335: ,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6

Line 340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3

336: ,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7

Line 341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4

337: ,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8

Line 342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5

338: ,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9

Line 343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6

339: ,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10

Line 344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7

340: ,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by

Line 345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8

341: ,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by

Line 346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9

342: ,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number

Line 347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10

343: ,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
351: );

Line 348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by

344: ,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
351: );
352: --

Line 349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by

345: ,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
351: );
352: --
353: exception

Line 350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number

346: ,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
347: ,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
348: ,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
349: ,p_created_by_o => irc_irf_shd.g_old_rec.created_by
350: ,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
351: );
352: --
353: exception
354: --

Line 372: ,p_rec in out nocopy irc_irf_shd.g_rec_type

368: -- ----------------------------------------------------------------------------
369: Procedure del
370: (p_effective_date in date
371: ,p_datetrack_mode in varchar2
372: ,p_rec in out nocopy irc_irf_shd.g_rec_type
373: ) is
374: --
375: l_proc varchar2(72) := g_package||'del';
376: l_validation_start_date date;

Line 388: irc_irf_shd.lck

384: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
385: --
386: -- We must lock the row which we need to delete.
387: --
388: irc_irf_shd.lck
389: (p_effective_date => p_effective_date
390: ,p_datetrack_mode => p_datetrack_mode
391: ,p_referral_info_id => p_rec.referral_info_id
392: ,p_object_version_number => p_rec.object_version_number

Line 447: l_rec irc_irf_shd.g_rec_type;

443: ,p_start_date out nocopy date
444: ,p_end_date out nocopy date
445: ) is
446: --
447: l_rec irc_irf_shd.g_rec_type;
448: l_proc varchar2(72) := g_package||'del';
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);