APPS.OTA_EVENT_SWI dependencies on OTA_EVENTS

Line 89: l_event_id ota_events.event_id%TYPE;

85: l_validate boolean;
86: --
87: -- Variables for IN/OUT parameters
88: --
89: l_event_id ota_events.event_id%TYPE;
90: -- Other variables
91: l_proc varchar2(72) := g_package ||'create_event';
92: Begin
93: hr_utility.set_location(' Entering:' || l_proc,10);

Line 118: ota_utility.ignore_dff_validation(p_dff_name => 'OTA_EVENTS');

114: IF p_event_type = 'SELFPACED' THEN
115:
116:
117:
118: ota_utility.ignore_dff_validation(p_dff_name => 'OTA_EVENTS');
119:
120: END IF;
121: --
122: -- Register Surrogate ID or user key values

Line 681: l_event_title ota_events.title%type;

677:
678: l_different_hours number(13,2);
679: l_current_date date;
680: l_event_date date;
681: l_event_title ota_events.title%type;
682: l_owner_id ota_events.owner_id%type;
683: l_sysdate varchar2(60);
684: l_boolean boolean;
685:

Line 682: l_owner_id ota_events.owner_id%type;

678: l_different_hours number(13,2);
679: l_current_date date;
680: l_event_date date;
681: l_event_title ota_events.title%type;
682: l_owner_id ota_events.owner_id%type;
683: l_sysdate varchar2(60);
684: l_boolean boolean;
685:
686: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS

Line 686: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS

682: l_owner_id ota_events.owner_id%type;
683: l_sysdate varchar2(60);
684: l_boolean boolean;
685:
686: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
687: SELECT to_date(to_char(evt.Course_start_date,'DD-MM-YYYY')||EVT.Course_start_time,'DD-MM-YYYYHH24:MI'),EVENT_TYPE,TITLE,OWNER_ID,MAXIMUM_ATTENDEES
688: FROM OTA_EVENTS EVT
689: WHERE evt.event_id = p_event_id;
690:

Line 688: FROM OTA_EVENTS EVT

684: l_boolean boolean;
685:
686: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
687: SELECT to_date(to_char(evt.Course_start_date,'DD-MM-YYYY')||EVT.Course_start_time,'DD-MM-YYYYHH24:MI'),EVENT_TYPE,TITLE,OWNER_ID,MAXIMUM_ATTENDEES
688: FROM OTA_EVENTS EVT
689: WHERE evt.event_id = p_event_id;
690:
691: CURSOR C_DATE IS
692: SELECT SYSDATE

Line 899: from ota_events

895:
896: cursor c_get_session is
897: select nvl(course_start_time, '-99:99') course_start_time,
898: nvl(course_end_time, '99:99') course_end_time
899: from ota_events
900: where event_id <> p_event_id
901: and parent_event_id = p_parent_event_id
902: and nvl(course_start_date, sysdate) = nvl(p_session_date, sysdate)
903: and event_type = 'SESSION';