APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_OFFERINGS

Line 513: l_offering_id ota_offerings.offering_id%TYPE;

509: l_tdb_information17 ota_delegate_bookings.TDB_INFORMATION17%TYPE;
510: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
511: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
512: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
513: l_offering_id ota_offerings.offering_id%TYPE;
514: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
515: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
516: begin
517:

Line 776: l_offering_id ota_offerings.offering_id%TYPE;

772: l_tdb_information18 ota_delegate_bookings.TDB_INFORMATION18%TYPE;
773: l_tdb_information19 ota_delegate_bookings.TDB_INFORMATION19%TYPE;
774: l_tdb_information20 ota_delegate_bookings.TDB_INFORMATION20%TYPE;
775: l_trnorgnames varchar2(2000);
776: l_offering_id ota_offerings.offering_id%TYPE;
777: l_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE;
778: l_booking_justification ota_bkng_justifications_tl.justification_text%TYPE;
779:
780: begin

Line 1074: OTA_OFFERINGS ofr,

1070: ota_general.get_location_code(ota_utility.get_event_location(evt.event_id)) Location_Name,
1071: ota_timezone_util.get_timezone_name(evt.timezone) timezone,
1072: evt.course_end_time
1073: FROM OTA_EVENTS_VL evt,
1074: OTA_OFFERINGS ofr,
1075: OTA_CATEGORY_USAGES_TL ctl,
1076: HR_ALL_ORGANIZATION_UNITS hao
1077: WHERE evt.event_id = l_eventid
1078: AND evt.parent_offering_id = ofr.offering_id

Line 2190: from ota_offerings ofe, ota_category_usages_tl ocu

2186:
2187:
2188: cursor get_lang_det is
2189: select ofe.language_id, ocu.category
2190: from ota_offerings ofe, ota_category_usages_tl ocu
2191: where ofe.delivery_mode_id = ocu.category_usage_id
2192: and ocu.language=USERENV('LANG')
2193: and ofe.offering_id = l_off_id;
2194:

Line 2198: l_lang_id ota_offerings.language_id%type;

2194:
2195:
2196: l_lang_description fnd_languages_vl.description%TYPE;
2197: l_curr_name fnd_currencies_vl.name%TYPE;
2198: l_lang_id ota_offerings.language_id%type;
2199: l_delivery_method ota_category_usages.category%type;
2200:
2201: begin
2202:

Line 2257: ota_offerings OFR,

2253:
2254: CURSOR delivery_mode(p_event_id OTA_EVENTS.event_id%TYPE) IS
2255: Select OCU.synchronous_flag, OCU.online_flag
2256: From ota_events OEV,
2257: ota_offerings OFR,
2258: ota_category_usages OCU
2259: Where OFR.offering_id = OEV.parent_offering_id
2260: And OCU.category_usage_id = OFR.delivery_mode_id
2261: And OEV.event_id = p_event_id;