APPS.IRC_INTERVIEW_DETAILS_API dependencies on PER_EVENTS

Line 480: l_event_id per_events.event_id%type;

476: -- Declare cursors and local variables
477: --
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;

Line 481: l_event_ovn per_events.object_version_number%type;

477: --
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;

Line 484: l_event_rec per_events%rowtype;

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: --
487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
488: --

Line 489: Cursor csr_event_rec (p_assignment_id per_events.assignment_id%type)

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 *
492: from per_events
493: where assignment_id=p_assignment_id;

Line 492: from per_events

488: --
489: Cursor csr_event_rec (p_assignment_id per_events.assignment_id%type)
490: is
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

Line 515: per_events_api.create_event

511: --
512: FOR l_event_rec IN csr_event_rec(p_source_assignment_id)
513: LOOP
514: --
515: per_events_api.create_event
516: (p_validate => false
517: ,p_date_start => l_event_rec.date_start
518: ,p_type => l_event_rec.type
519: ,p_business_group_id => l_event_rec.business_group_id