APPS.OTA_COMPETENCE_SS dependencies on OTA_EVENTS

Line 179: p_id in ota_events.event_id%type,

175: -- ---------------------------------------------------------------------------
176: --
177: Function get_Competence_eff_date(
178: p_comp_id in per_competence_elements.competence_id%type,
179: p_id in ota_events.event_id%type,
180: p_obj_type in varchar2
181: ) return date
182: is
183:

Line 191: from ota_events oev,

187: l_eff_date date;
188:
189: Cursor course_eff_date is
190: select oev.course_end_date
191: from ota_events oev,
192: ota_offerings off, ota_category_usages ocu
193: where oev.event_id=p_id
194: and (oev.parent_offering_id = off.offering_id or oev.offering_id = off.offering_id)
195: and off.delivery_mode_id = ocu.category_usage_id

Line 198: from per_competence_elements pce , ota_offerings off,ota_events oev

194: and (oev.parent_offering_id = off.offering_id or oev.offering_id = off.offering_id)
195: and off.delivery_mode_id = ocu.category_usage_id
196: and ocu.synchronous_flag = 'Y';
197: /*select pce.effective_date_from
198: from per_competence_elements pce , ota_offerings off,ota_events oev
199: where oev.parent_offering_id=off.offering_id
200: and off.activity_version_id=pce.activity_version_id
201: and oev.event_id= p_id
202: and pce.competence_id =p_comp_id

Line 721: from ota_activity_versions oav,ota_offerings off,ota_events oev

717: where learning_path_id = l_id;
718:
719: cursor get_course_off_setting(l_id number) is
720: select oav.competency_update_level,off.competency_update_level
721: from ota_activity_versions oav,ota_offerings off,ota_events oev
722: where oav.activity_version_id = off.activity_version_id
723: and off.offering_id = oev.parent_offering_id
724: and
725: oev.event_id = l_id;

Line 1403: p_eventid in ota_Events.event_id%type,

1399:
1400: Procedure create_wf_process(p_process in wf_process_activities.process_name%type,
1401: p_itemtype in wf_items.item_type%type,
1402: p_person_id in number ,
1403: p_eventid in ota_Events.event_id%type,
1404: p_learningpath_ids in varchar2 ,
1405: p_certification_Id in number default null,
1406: p_itemkey out nocopy wf_items.item_key%type)
1407: is

Line 1447: l_event_name ota_events.title%type;

1443: l_supervisor_id per_all_people_f.person_id%Type;
1444: l_supervisor_username fnd_user.user_name%TYPE;
1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1446:
1447: l_event_name ota_events.title%type;
1448:
1449: l_course_name ota_activity_versions.version_name%type;
1450: l_process_display_name varchar2(240);
1451:

Line 1527: from ota_Events_vl oev ,ota_activity_versions_tl oav

1523: WHERE employee_id= l_supervisor_id;
1524:
1525: Cursor csr_name is
1526: select oev.title,oav.version_name
1527: from ota_Events_vl oev ,ota_activity_versions_tl oav
1528: --,ota_offerings off
1529: where
1530: --oev.parent_offering_id=off.offering_id and
1531: oev.activity_version_id= oav.activity_version_id

Line 1938: , ota_events EVT

1934: SELECT pce.competence_id CompetenceId
1935: ,nvl(pce.proficiency_level_id,-1) LevelId
1936: FROM per_competence_elements pce
1937: , ota_offerings OFF
1938: , ota_events EVT
1939: WHERE off.activity_version_id = pce.activity_version_id
1940: AND evt.parent_offering_id = off.offering_id
1941: AND evt.event_id = p_event_id;
1942: