APPS.OTA_INITIALIZATION_WF dependencies on OTA_CATEGORY_USAGES

Line 597: from ota_offerings ofe, ota_category_usages_tl ocu

593: and evt.language=USERENV('LANG');
594:
595: cursor get_lang_det is
596: select ofe.language_id, ocu.category
597: from ota_offerings ofe, ota_category_usages_tl ocu
598: where ofe.delivery_mode_id = ocu.category_usage_id
599: and ocu.language=USERENV('LANG')
600: and ofe.offering_id = l_off_id;
601:

Line 606: l_delivery_method ota_category_usages.category%type;

602: l_course_name OTA_ACTIVITY_VERSIONS_TL.version_name%TYPE;
603: l_lang_description fnd_languages_vl.description%TYPE;
604: l_curr_name fnd_currencies_vl.name%TYPE;
605: l_lang_id ota_offerings.language_id%type;
606: l_delivery_method ota_category_usages.category%type;
607: l_timezone varchar2(300);
608:
609: begin
610:

Line 1993: l_synchronous_flag ota_category_usages.synchronous_flag%type;

1989: funcmode IN VARCHAR2,
1990: resultout OUT nocopy VARCHAR2 ) is
1991:
1992: l_event_id varchar2(80);
1993: l_synchronous_flag ota_category_usages.synchronous_flag%type;
1994: l_online_flag ota_category_usages.online_flag%type;
1995:
1996: CURSOR delivery_mode(p_event_id varchar2) IS
1997: Select OCU.synchronous_flag, OCU.online_flag

Line 1994: l_online_flag ota_category_usages.online_flag%type;

1990: resultout OUT nocopy VARCHAR2 ) is
1991:
1992: l_event_id varchar2(80);
1993: l_synchronous_flag ota_category_usages.synchronous_flag%type;
1994: l_online_flag ota_category_usages.online_flag%type;
1995:
1996: CURSOR delivery_mode(p_event_id varchar2) IS
1997: Select OCU.synchronous_flag, OCU.online_flag
1998: From ota_events OEV,

Line 2000: ota_category_usages OCU

1996: CURSOR delivery_mode(p_event_id varchar2) IS
1997: Select OCU.synchronous_flag, OCU.online_flag
1998: From ota_events OEV,
1999: ota_offerings OFR,
2000: ota_category_usages OCU
2001: Where OFR.offering_id = OEV.parent_offering_id
2002: And OCU.category_usage_id = OFR.delivery_mode_id
2003: And OEV.event_id = p_event_id;
2004: