APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_GENERAL

Line 1070: ota_general.get_location_code(ota_utility.get_event_location(evt.event_id)) Location_Name,

1066: Ctl.Category,
1067: -- Modified for bug 3389890 as usage of inline query in CURSOR is not supported in 8.1.7
1068: -- (Select Category from ota_category_usages_tl where Category_Usage_Id = ofr.Delivery_Mode_Id
1069: -- and Language = userenv('LANG')) Delivery_Mode,
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,

Line 2213: --l_course_name := ota_general.get_course_name(l_act_ver_id);

2209: open get_lang_det;
2210: fetch get_lang_det into l_lang_id,l_delivery_method;
2211: close get_lang_det;
2212:
2213: --l_course_name := ota_general.get_course_name(l_act_ver_id);
2214: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
2215: l_curr_name := l_actual_cost || ' ' || l_curr_name;
2216:
2217: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);

Line 2214: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);

2210: fetch get_lang_det into l_lang_id,l_delivery_method;
2211: close get_lang_det;
2212:
2213: --l_course_name := ota_general.get_course_name(l_act_ver_id);
2214: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
2215: l_curr_name := l_actual_cost || ' ' || l_curr_name;
2216:
2217: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
2218:

Line 2217: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);

2213: --l_course_name := ota_general.get_course_name(l_act_ver_id);
2214: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
2215: l_curr_name := l_actual_cost || ' ' || l_curr_name;
2216:
2217: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
2218:
2219: --set wf item attributes
2220:
2221: --wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );