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 1989: l_synchronous_flag ota_category_usages.synchronous_flag%type;

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

Line 1990: l_online_flag ota_category_usages.online_flag%type;

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

Line 1996: ota_category_usages OCU

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