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.IRC_INTERVIEW_DETAILS_API dependencies on IRC_INTERVIEW_DETAILS

Line 1: PACKAGE BODY IRC_INTERVIEW_DETAILS_API as

1: PACKAGE BODY IRC_INTERVIEW_DETAILS_API as
2: /* $Header: iriidapi.pkb 120.0.12010000.2 2010/04/07 09:55:12 vmummidi ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' irc_interview_details_api.';

2: /* $Header: iriidapi.pkb 120.0.12010000.2 2010/04/07 09:55:12 vmummidi ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' irc_interview_details_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_interview_details >--------------------|
10: -- ----------------------------------------------------------------------------

Line 9: -- |-------------------------< create_irc_interview_details >--------------------|

5: --
6: g_package varchar2(33) := ' irc_interview_details_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_interview_details >--------------------|
10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_irc_interview_details
13: (p_validate in boolean default false

Line 12: procedure create_irc_interview_details

8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_irc_interview_details >--------------------|
10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_irc_interview_details
13: (p_validate in boolean default false
14: ,p_status in varchar2 default hr_api.g_varchar2
15: ,p_feedback in varchar2 default hr_api.g_varchar2
16: ,p_notes in varchar2 default hr_api.g_varchar2

Line 50: l_proc varchar2(72) := g_package||'create_irc_interview_details';

46: ) is
47: --
48: -- Declare cursors and local variables
49: --
50: l_proc varchar2(72) := g_package||'create_irc_interview_details';
51: l_interview_details_id number;
52: l_object_version_number number;
53: l_start_date date;
54: l_end_date date;

Line 55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';

51: l_interview_details_id number;
52: l_object_version_number number;
53: l_start_date date;
54: l_end_date date;
55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';
56: l_effective_date date;
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --

Line 62: savepoint create_irc_interview_details;

58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_irc_interview_details;
63: --
64: -- Call Before Process User Hook
65: --
66: begin

Line 67: irc_interview_details_bk1.create_irc_interview_details_b

63: --
64: -- Call Before Process User Hook
65: --
66: begin
67: irc_interview_details_bk1.create_irc_interview_details_b
68: (p_status => p_status
69: ,p_feedback => p_feedback
70: ,p_notes => p_notes
71: ,p_notes_to_candidate => p_notes_to_candidate

Line 100: (p_module_name => 'create_irc_interview_details'

96: );
97: exception
98: when hr_api.cannot_find_prog_unit then
99: hr_api.cannot_find_prog_unit_error
100: (p_module_name => 'create_irc_interview_details'
101: ,p_hook_type => 'BP'
102: );
103: end;
104: --

Line 147: irc_interview_details_bk1.create_irc_interview_details_a

143: );
144: -- Call After Process User Hook
145: --
146: begin
147: irc_interview_details_bk1.create_irc_interview_details_a
148: (p_interview_details_id => l_interview_details_id
149: ,p_status => p_status
150: ,p_feedback => p_feedback
151: ,p_notes => p_notes

Line 184: (p_module_name => 'create_irc_interview_details'

180: );
181: exception
182: when hr_api.cannot_find_prog_unit then
183: hr_api.cannot_find_prog_unit_error
184: (p_module_name => 'create_irc_interview_details'
185: ,p_hook_type => 'AP'
186: );
187: end;
188: --

Line 209: rollback to create_irc_interview_details;

205: --
206: -- As the Validate_Enabled exception has been raised
207: -- we must rollback to the savepoint
208: --
209: rollback to create_irc_interview_details;
210: --
211: -- Reset IN OUT parameters and set OUT parameters
212: -- (Any key or derived arguments must be set to null
213: -- when validation only mode is being used.)

Line 224: rollback to create_irc_interview_details;

220: when others then
221: --
222: -- A validation or unexpected error has occured
223: --
224: rollback to create_irc_interview_details;
225: --
226: -- Reset IN OUT parameters and set all
227: -- OUT parameters, including warnings, to null
228: --

Line 235: end create_irc_interview_details;

231: p_start_date := null;
232: p_end_date := null;
233: hr_utility.set_location(' Leaving:'||l_proc, 90);
234: raise;
235: end create_irc_interview_details;
236: --
237: --
238: -- ----------------------------------------------------------------------------
239: -- |-----------------------< update_irc_interview_details >----------------------|

Line 239: -- |-----------------------< update_irc_interview_details >----------------------|

235: end create_irc_interview_details;
236: --
237: --
238: -- ----------------------------------------------------------------------------
239: -- |-----------------------< update_irc_interview_details >----------------------|
240: -- ----------------------------------------------------------------------------
241: --
242: procedure update_irc_interview_details
243: (p_validate in boolean default false

Line 242: procedure update_irc_interview_details

238: -- ----------------------------------------------------------------------------
239: -- |-----------------------< update_irc_interview_details >----------------------|
240: -- ----------------------------------------------------------------------------
241: --
242: procedure update_irc_interview_details
243: (p_validate in boolean default false
244: ,p_interview_details_id in number
245: ,p_status in varchar2 default hr_api.g_varchar2
246: ,p_feedback in varchar2 default hr_api.g_varchar2

Line 284: l_proc varchar2(72) := g_package||'update_irc_interview_details';

280: l_object_version_number number;
281: l_start_date date;
282: l_end_date date;
283: l_effective_date date;
284: l_proc varchar2(72) := g_package||'update_irc_interview_details';
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Issue a savepoint

Line 290: savepoint update_irc_interview_details;

286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Issue a savepoint
289: --
290: savepoint update_irc_interview_details;
291: --
292: -- Call Before Process User Hook
293: --
294: begin

Line 295: irc_interview_details_bk2.update_irc_interview_details_b

291: --
292: -- Call Before Process User Hook
293: --
294: begin
295: irc_interview_details_bk2.update_irc_interview_details_b
296: (p_interview_details_id => p_interview_details_id
297: ,p_status => p_status
298: ,p_feedback => p_feedback
299: ,p_notes => p_notes

Line 329: (p_module_name => 'update_irc_interview_details'

325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'update_irc_interview_details'
330: ,p_hook_type => 'BP'
331: );
332: end;
333: --

Line 383: irc_interview_details_bk2.update_irc_interview_details_a

379: --
380: -- Call After Process User Hook
381: --
382: begin
383: irc_interview_details_bk2.update_irc_interview_details_a
384: (p_interview_details_id => p_interview_details_id
385: ,p_status => p_status
386: ,p_feedback => p_feedback
387: ,p_notes => p_notes

Line 417: (p_module_name => 'update_irc_interview_details'

413: );
414: exception
415: when hr_api.cannot_find_prog_unit then
416: hr_api.cannot_find_prog_unit_error
417: (p_module_name => 'update_irc_interview_details'
418: ,p_hook_type => 'AP'
419: );
420: end;
421: --

Line 441: rollback to update_irc_interview_details;

437: --
438: -- As the Validate_Enabled exception has been raised
439: -- we must rollback to the savepoint
440: --
441: rollback to update_irc_interview_details;
442: --
443: -- Reset IN OUT parameters and set OUT parameters
444: -- (Any key or derived arguments must be set to null
445: -- when validation only mode is being used.)

Line 454: rollback to update_irc_interview_details;

450: when others then
451: --
452: -- A validation or unexpected error has occured
453: --
454: rollback to update_irc_interview_details;
455: --
456: -- Reset IN OUT parameters and set all
457: -- OUT parameters, including warnings, to null
458: --

Line 463: end update_irc_interview_details;

459: p_start_date := null;
460: p_end_date := null;
461: hr_utility.set_location(' Leaving:'||l_proc, 90);
462: raise;
463: end update_irc_interview_details;
464: --
465: --
466: -- ----------------------------------------------------------------------------
467: -- |-------------------------< copy_interview_details >--------------------|

Line 482: l_interview_details_id irc_interview_details.interview_details_id%type;

478: l_proc varchar2(72) := g_package||'copy_interview_details';
479: --
480: l_event_id per_events.event_id%type;
481: l_event_ovn per_events.object_version_number%type;
482: l_interview_details_id irc_interview_details.interview_details_id%type;
483: --
484: l_event_rec per_events%rowtype;
485: l_interview_det_rec irc_interview_details%rowtype;
486: --

Line 485: l_interview_det_rec irc_interview_details%rowtype;

481: l_event_ovn per_events.object_version_number%type;
482: l_interview_details_id irc_interview_details.interview_details_id%type;
483: --
484: l_event_rec per_events%rowtype;
485: l_interview_det_rec irc_interview_details%rowtype;
486: --
487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
488: --
489: Cursor csr_event_rec (p_assignment_id per_events.assignment_id%type)

Line 487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;

483: --
484: l_event_rec per_events%rowtype;
485: l_interview_det_rec irc_interview_details%rowtype;
486: --
487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
488: --
489: Cursor csr_event_rec (p_assignment_id per_events.assignment_id%type)
490: is
491: select *

Line 495: Cursor csr_interview_details(p_event_id irc_interview_details.event_id%type)

491: select *
492: from per_events
493: where assignment_id=p_assignment_id;
494: --
495: Cursor csr_interview_details(p_event_id irc_interview_details.event_id%type)
496: is
497: select *
498: from irc_interview_details
499: where event_id = p_event_id;

Line 498: from irc_interview_details

494: --
495: Cursor csr_interview_details(p_event_id irc_interview_details.event_id%type)
496: is
497: select *
498: from irc_interview_details
499: where event_id = p_event_id;
500: --
501: begin
502: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 564: insert into irc_interview_details

560: --
561: FOR l_interview_det_rec IN csr_interview_details(l_event_rec.event_id)
562: LOOP
563: --
564: insert into irc_interview_details
565: (interview_details_id
566: ,status
567: ,feedback
568: ,notes

Line 658: end irc_interview_details_api;

654: hr_utility.set_location(' Leaving:'||l_proc, 40);
655: raise;
656: end copy_interview_details;
657: --
658: end irc_interview_details_api;