APPS.OTA_EVENT_SWI dependencies on OTA_EVENTS

Line 90: l_event_id ota_events.event_id%TYPE;

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

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

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

Line 685: l_event_title ota_events.title%type;

681:
682: l_different_hours number(13,2);
683: l_current_date date;
684: l_event_date date;
685: l_event_title ota_events.title%type;
686: l_owner_id ota_events.owner_id%type;
687: l_sysdate varchar2(60);
688: l_boolean boolean;
689:

Line 686: l_owner_id ota_events.owner_id%type;

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

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

686: l_owner_id ota_events.owner_id%type;
687: l_sysdate varchar2(60);
688: l_boolean boolean;
689:
690: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
691: 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
692: FROM OTA_EVENTS EVT
693: WHERE evt.event_id = p_event_id;
694:

Line 692: FROM OTA_EVENTS EVT

688: l_boolean boolean;
689:
690: CURSOR C_EVENT_DATE (p_event_id ota_events.event_ID%type) IS
691: 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
692: FROM OTA_EVENTS EVT
693: WHERE evt.event_id = p_event_id;
694:
695: CURSOR C_DATE IS
696: SELECT SYSDATE

Line 903: from ota_events

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