APPS.IRC_IID_DEL dependencies on IRC_IID_SHD

Line 54: (p_rec in out nocopy irc_iid_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy irc_iid_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_iid_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy irc_iid_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_iid_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy irc_iid_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_iid_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_iid_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_iid_shd.upd_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: irc_iid_shd.upd_end_date
180: (p_effective_date => p_effective_date
181: ,p_interview_details_id => p_rec.interview_details_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_iid_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_delete
226: (p_rec in out nocopy irc_iid_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_iid_shd.g_rec_type

282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure post_delete
286: (p_rec in irc_iid_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 315: => irc_iid_shd.g_old_rec.status

311: => p_rec.start_date
312: ,p_end_date
313: => p_rec.end_date
314: ,p_status_o
315: => irc_iid_shd.g_old_rec.status
316: ,p_feedback_o
317: => irc_iid_shd.g_old_rec.feedback
318: ,p_notes_o
319: => irc_iid_shd.g_old_rec.notes

Line 317: => irc_iid_shd.g_old_rec.feedback

313: => p_rec.end_date
314: ,p_status_o
315: => irc_iid_shd.g_old_rec.status
316: ,p_feedback_o
317: => irc_iid_shd.g_old_rec.feedback
318: ,p_notes_o
319: => irc_iid_shd.g_old_rec.notes
320: ,p_notes_to_candidate_o
321: => irc_iid_shd.g_old_rec.notes_to_candidate

Line 319: => irc_iid_shd.g_old_rec.notes

315: => irc_iid_shd.g_old_rec.status
316: ,p_feedback_o
317: => irc_iid_shd.g_old_rec.feedback
318: ,p_notes_o
319: => irc_iid_shd.g_old_rec.notes
320: ,p_notes_to_candidate_o
321: => irc_iid_shd.g_old_rec.notes_to_candidate
322: ,p_category_o
323: => irc_iid_shd.g_old_rec.category

Line 321: => irc_iid_shd.g_old_rec.notes_to_candidate

317: => irc_iid_shd.g_old_rec.feedback
318: ,p_notes_o
319: => irc_iid_shd.g_old_rec.notes
320: ,p_notes_to_candidate_o
321: => irc_iid_shd.g_old_rec.notes_to_candidate
322: ,p_category_o
323: => irc_iid_shd.g_old_rec.category
324: ,p_result_o
325: => irc_iid_shd.g_old_rec.result

Line 323: => irc_iid_shd.g_old_rec.category

319: => irc_iid_shd.g_old_rec.notes
320: ,p_notes_to_candidate_o
321: => irc_iid_shd.g_old_rec.notes_to_candidate
322: ,p_category_o
323: => irc_iid_shd.g_old_rec.category
324: ,p_result_o
325: => irc_iid_shd.g_old_rec.result
326: ,p_iid_information_category_o
327: => irc_iid_shd.g_old_rec.iid_information_category

Line 325: => irc_iid_shd.g_old_rec.result

321: => irc_iid_shd.g_old_rec.notes_to_candidate
322: ,p_category_o
323: => irc_iid_shd.g_old_rec.category
324: ,p_result_o
325: => irc_iid_shd.g_old_rec.result
326: ,p_iid_information_category_o
327: => irc_iid_shd.g_old_rec.iid_information_category
328: ,p_iid_information1_o
329: => irc_iid_shd.g_old_rec.iid_information1

Line 327: => irc_iid_shd.g_old_rec.iid_information_category

323: => irc_iid_shd.g_old_rec.category
324: ,p_result_o
325: => irc_iid_shd.g_old_rec.result
326: ,p_iid_information_category_o
327: => irc_iid_shd.g_old_rec.iid_information_category
328: ,p_iid_information1_o
329: => irc_iid_shd.g_old_rec.iid_information1
330: ,p_iid_information2_o
331: => irc_iid_shd.g_old_rec.iid_information2

Line 329: => irc_iid_shd.g_old_rec.iid_information1

325: => irc_iid_shd.g_old_rec.result
326: ,p_iid_information_category_o
327: => irc_iid_shd.g_old_rec.iid_information_category
328: ,p_iid_information1_o
329: => irc_iid_shd.g_old_rec.iid_information1
330: ,p_iid_information2_o
331: => irc_iid_shd.g_old_rec.iid_information2
332: ,p_iid_information3_o
333: => irc_iid_shd.g_old_rec.iid_information3

Line 331: => irc_iid_shd.g_old_rec.iid_information2

327: => irc_iid_shd.g_old_rec.iid_information_category
328: ,p_iid_information1_o
329: => irc_iid_shd.g_old_rec.iid_information1
330: ,p_iid_information2_o
331: => irc_iid_shd.g_old_rec.iid_information2
332: ,p_iid_information3_o
333: => irc_iid_shd.g_old_rec.iid_information3
334: ,p_iid_information4_o
335: => irc_iid_shd.g_old_rec.iid_information4

Line 333: => irc_iid_shd.g_old_rec.iid_information3

329: => irc_iid_shd.g_old_rec.iid_information1
330: ,p_iid_information2_o
331: => irc_iid_shd.g_old_rec.iid_information2
332: ,p_iid_information3_o
333: => irc_iid_shd.g_old_rec.iid_information3
334: ,p_iid_information4_o
335: => irc_iid_shd.g_old_rec.iid_information4
336: ,p_iid_information5_o
337: => irc_iid_shd.g_old_rec.iid_information5

Line 335: => irc_iid_shd.g_old_rec.iid_information4

331: => irc_iid_shd.g_old_rec.iid_information2
332: ,p_iid_information3_o
333: => irc_iid_shd.g_old_rec.iid_information3
334: ,p_iid_information4_o
335: => irc_iid_shd.g_old_rec.iid_information4
336: ,p_iid_information5_o
337: => irc_iid_shd.g_old_rec.iid_information5
338: ,p_iid_information6_o
339: => irc_iid_shd.g_old_rec.iid_information6

Line 337: => irc_iid_shd.g_old_rec.iid_information5

333: => irc_iid_shd.g_old_rec.iid_information3
334: ,p_iid_information4_o
335: => irc_iid_shd.g_old_rec.iid_information4
336: ,p_iid_information5_o
337: => irc_iid_shd.g_old_rec.iid_information5
338: ,p_iid_information6_o
339: => irc_iid_shd.g_old_rec.iid_information6
340: ,p_iid_information7_o
341: => irc_iid_shd.g_old_rec.iid_information7

Line 339: => irc_iid_shd.g_old_rec.iid_information6

335: => irc_iid_shd.g_old_rec.iid_information4
336: ,p_iid_information5_o
337: => irc_iid_shd.g_old_rec.iid_information5
338: ,p_iid_information6_o
339: => irc_iid_shd.g_old_rec.iid_information6
340: ,p_iid_information7_o
341: => irc_iid_shd.g_old_rec.iid_information7
342: ,p_iid_information8_o
343: => irc_iid_shd.g_old_rec.iid_information8

Line 341: => irc_iid_shd.g_old_rec.iid_information7

337: => irc_iid_shd.g_old_rec.iid_information5
338: ,p_iid_information6_o
339: => irc_iid_shd.g_old_rec.iid_information6
340: ,p_iid_information7_o
341: => irc_iid_shd.g_old_rec.iid_information7
342: ,p_iid_information8_o
343: => irc_iid_shd.g_old_rec.iid_information8
344: ,p_iid_information9_o
345: => irc_iid_shd.g_old_rec.iid_information9

Line 343: => irc_iid_shd.g_old_rec.iid_information8

339: => irc_iid_shd.g_old_rec.iid_information6
340: ,p_iid_information7_o
341: => irc_iid_shd.g_old_rec.iid_information7
342: ,p_iid_information8_o
343: => irc_iid_shd.g_old_rec.iid_information8
344: ,p_iid_information9_o
345: => irc_iid_shd.g_old_rec.iid_information9
346: ,p_iid_information10_o
347: => irc_iid_shd.g_old_rec.iid_information10

Line 345: => irc_iid_shd.g_old_rec.iid_information9

341: => irc_iid_shd.g_old_rec.iid_information7
342: ,p_iid_information8_o
343: => irc_iid_shd.g_old_rec.iid_information8
344: ,p_iid_information9_o
345: => irc_iid_shd.g_old_rec.iid_information9
346: ,p_iid_information10_o
347: => irc_iid_shd.g_old_rec.iid_information10
348: ,p_iid_information11_o
349: => irc_iid_shd.g_old_rec.iid_information11

Line 347: => irc_iid_shd.g_old_rec.iid_information10

343: => irc_iid_shd.g_old_rec.iid_information8
344: ,p_iid_information9_o
345: => irc_iid_shd.g_old_rec.iid_information9
346: ,p_iid_information10_o
347: => irc_iid_shd.g_old_rec.iid_information10
348: ,p_iid_information11_o
349: => irc_iid_shd.g_old_rec.iid_information11
350: ,p_iid_information12_o
351: => irc_iid_shd.g_old_rec.iid_information12

Line 349: => irc_iid_shd.g_old_rec.iid_information11

345: => irc_iid_shd.g_old_rec.iid_information9
346: ,p_iid_information10_o
347: => irc_iid_shd.g_old_rec.iid_information10
348: ,p_iid_information11_o
349: => irc_iid_shd.g_old_rec.iid_information11
350: ,p_iid_information12_o
351: => irc_iid_shd.g_old_rec.iid_information12
352: ,p_iid_information13_o
353: => irc_iid_shd.g_old_rec.iid_information13

Line 351: => irc_iid_shd.g_old_rec.iid_information12

347: => irc_iid_shd.g_old_rec.iid_information10
348: ,p_iid_information11_o
349: => irc_iid_shd.g_old_rec.iid_information11
350: ,p_iid_information12_o
351: => irc_iid_shd.g_old_rec.iid_information12
352: ,p_iid_information13_o
353: => irc_iid_shd.g_old_rec.iid_information13
354: ,p_iid_information14_o
355: => irc_iid_shd.g_old_rec.iid_information14

Line 353: => irc_iid_shd.g_old_rec.iid_information13

349: => irc_iid_shd.g_old_rec.iid_information11
350: ,p_iid_information12_o
351: => irc_iid_shd.g_old_rec.iid_information12
352: ,p_iid_information13_o
353: => irc_iid_shd.g_old_rec.iid_information13
354: ,p_iid_information14_o
355: => irc_iid_shd.g_old_rec.iid_information14
356: ,p_iid_information15_o
357: => irc_iid_shd.g_old_rec.iid_information15

Line 355: => irc_iid_shd.g_old_rec.iid_information14

351: => irc_iid_shd.g_old_rec.iid_information12
352: ,p_iid_information13_o
353: => irc_iid_shd.g_old_rec.iid_information13
354: ,p_iid_information14_o
355: => irc_iid_shd.g_old_rec.iid_information14
356: ,p_iid_information15_o
357: => irc_iid_shd.g_old_rec.iid_information15
358: ,p_iid_information16_o
359: => irc_iid_shd.g_old_rec.iid_information16

Line 357: => irc_iid_shd.g_old_rec.iid_information15

353: => irc_iid_shd.g_old_rec.iid_information13
354: ,p_iid_information14_o
355: => irc_iid_shd.g_old_rec.iid_information14
356: ,p_iid_information15_o
357: => irc_iid_shd.g_old_rec.iid_information15
358: ,p_iid_information16_o
359: => irc_iid_shd.g_old_rec.iid_information16
360: ,p_iid_information17_o
361: => irc_iid_shd.g_old_rec.iid_information17

Line 359: => irc_iid_shd.g_old_rec.iid_information16

355: => irc_iid_shd.g_old_rec.iid_information14
356: ,p_iid_information15_o
357: => irc_iid_shd.g_old_rec.iid_information15
358: ,p_iid_information16_o
359: => irc_iid_shd.g_old_rec.iid_information16
360: ,p_iid_information17_o
361: => irc_iid_shd.g_old_rec.iid_information17
362: ,p_iid_information18_o
363: => irc_iid_shd.g_old_rec.iid_information18

Line 361: => irc_iid_shd.g_old_rec.iid_information17

357: => irc_iid_shd.g_old_rec.iid_information15
358: ,p_iid_information16_o
359: => irc_iid_shd.g_old_rec.iid_information16
360: ,p_iid_information17_o
361: => irc_iid_shd.g_old_rec.iid_information17
362: ,p_iid_information18_o
363: => irc_iid_shd.g_old_rec.iid_information18
364: ,p_iid_information19_o
365: => irc_iid_shd.g_old_rec.iid_information19

Line 363: => irc_iid_shd.g_old_rec.iid_information18

359: => irc_iid_shd.g_old_rec.iid_information16
360: ,p_iid_information17_o
361: => irc_iid_shd.g_old_rec.iid_information17
362: ,p_iid_information18_o
363: => irc_iid_shd.g_old_rec.iid_information18
364: ,p_iid_information19_o
365: => irc_iid_shd.g_old_rec.iid_information19
366: ,p_iid_information20_o
367: => irc_iid_shd.g_old_rec.iid_information20

Line 365: => irc_iid_shd.g_old_rec.iid_information19

361: => irc_iid_shd.g_old_rec.iid_information17
362: ,p_iid_information18_o
363: => irc_iid_shd.g_old_rec.iid_information18
364: ,p_iid_information19_o
365: => irc_iid_shd.g_old_rec.iid_information19
366: ,p_iid_information20_o
367: => irc_iid_shd.g_old_rec.iid_information20
368: ,p_start_date_o
369: => irc_iid_shd.g_old_rec.start_date

Line 367: => irc_iid_shd.g_old_rec.iid_information20

363: => irc_iid_shd.g_old_rec.iid_information18
364: ,p_iid_information19_o
365: => irc_iid_shd.g_old_rec.iid_information19
366: ,p_iid_information20_o
367: => irc_iid_shd.g_old_rec.iid_information20
368: ,p_start_date_o
369: => irc_iid_shd.g_old_rec.start_date
370: ,p_end_date_o
371: => irc_iid_shd.g_old_rec.end_date

Line 369: => irc_iid_shd.g_old_rec.start_date

365: => irc_iid_shd.g_old_rec.iid_information19
366: ,p_iid_information20_o
367: => irc_iid_shd.g_old_rec.iid_information20
368: ,p_start_date_o
369: => irc_iid_shd.g_old_rec.start_date
370: ,p_end_date_o
371: => irc_iid_shd.g_old_rec.end_date
372: ,p_event_id_o
373: => irc_iid_shd.g_old_rec.event_id

Line 371: => irc_iid_shd.g_old_rec.end_date

367: => irc_iid_shd.g_old_rec.iid_information20
368: ,p_start_date_o
369: => irc_iid_shd.g_old_rec.start_date
370: ,p_end_date_o
371: => irc_iid_shd.g_old_rec.end_date
372: ,p_event_id_o
373: => irc_iid_shd.g_old_rec.event_id
374: ,p_object_version_number_o
375: => irc_iid_shd.g_old_rec.object_version_number

Line 373: => irc_iid_shd.g_old_rec.event_id

369: => irc_iid_shd.g_old_rec.start_date
370: ,p_end_date_o
371: => irc_iid_shd.g_old_rec.end_date
372: ,p_event_id_o
373: => irc_iid_shd.g_old_rec.event_id
374: ,p_object_version_number_o
375: => irc_iid_shd.g_old_rec.object_version_number
376: );
377: --

Line 375: => irc_iid_shd.g_old_rec.object_version_number

371: => irc_iid_shd.g_old_rec.end_date
372: ,p_event_id_o
373: => irc_iid_shd.g_old_rec.event_id
374: ,p_object_version_number_o
375: => irc_iid_shd.g_old_rec.object_version_number
376: );
377: --
378: exception
379: --

Line 397: ,p_rec in out nocopy irc_iid_shd.g_rec_type

393: -- ----------------------------------------------------------------------------
394: Procedure del
395: (p_effective_date in date
396: ,p_datetrack_mode in varchar2
397: ,p_rec in out nocopy irc_iid_shd.g_rec_type
398: ) is
399: --
400: l_proc varchar2(72) := g_package||'del';
401: l_validation_start_date date;

Line 413: irc_iid_shd.lck

409: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
410: --
411: -- We must lock the row which we need to delete.
412: --
413: irc_iid_shd.lck
414: (p_effective_date => p_effective_date
415: ,p_datetrack_mode => p_datetrack_mode
416: ,p_interview_details_id => p_rec.interview_details_id
417: ,p_object_version_number => p_rec.object_version_number

Line 472: l_rec irc_iid_shd.g_rec_type;

468: ,p_start_date out nocopy date
469: ,p_end_date out nocopy date
470: ) is
471: --
472: l_rec irc_iid_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'del';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);