APPS.OTA_INITIALIZATION_WF dependencies on OTA_GENERAL

Line 631: l_course_name := ota_general.get_course_name(l_act_ver_id);

627: open get_lang_det;
628: fetch get_lang_det into l_lang_id,l_delivery_method;
629: close get_lang_det;
630:
631: l_course_name := ota_general.get_course_name(l_act_ver_id);
632: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
633: l_curr_name := l_actual_cost || ' ' || l_curr_name;
634:
635: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);

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

628: fetch get_lang_det into l_lang_id,l_delivery_method;
629: close get_lang_det;
630:
631: l_course_name := ota_general.get_course_name(l_act_ver_id);
632: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
633: l_curr_name := l_actual_cost || ' ' || l_curr_name;
634:
635: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
636:

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

631: l_course_name := ota_general.get_course_name(l_act_ver_id);
632: l_curr_name := ota_general.fnd_currency_name(l_budget_currency_code);
633: l_curr_name := l_actual_cost || ' ' || l_curr_name;
634:
635: l_lang_description := ota_general.fnd_lang_desc(l_lang_id);
636:
637: --set wf item attributes
638:
639: wf_engine.setItemAttrText(p_item_type,p_item_key,'COST',l_curr_name );

Line 759: l_location_name := ota_general.get_Location_code(l_location_id);

755:
756: hr_utility.trace ('after get_event_info ' ||l_title);
757:
758: -- get location
759: l_location_name := ota_general.get_Location_code(l_location_id);
760:
761: if p_event_fired = 'INSTRUCTOR_CANCEL' then
762:
763: -- Get the next item key from the sequence

Line 1036: l_location_name := ota_general.get_Location_code(l_location_id);

1032: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1033: WF_ENGINE.setitemattrNumber(p_item_type, l_item_key, 'BOOKING_ID', l_booking_id);
1034:
1035: -- get location
1036: l_location_name := ota_general.get_Location_code(l_location_id);
1037:
1038: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
1039:
1040: set_addnl_attributes(p_item_type => p_item_type,

Line 1079: l_location_name := ota_general.get_Location_code(l_location_id);

1075: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_START_TIME', nvl(l_start_time,'00:00'));
1076: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'OTA_END_TIME', nvl(l_end_time,'23:59'));
1077:
1078: -- get location
1079: l_location_name := ota_general.get_Location_code(l_location_id);
1080:
1081: WF_ENGINE.setitemattrText(p_item_type, l_item_key, 'LP_NAME', l_location_name);
1082:
1083: -- if l_process = 'OTA_ENROLL_STATUS_CHNG_JSP_PRC' then

Line 2116: l_location_name := ota_general.get_Location_code(l_location_id);

2112: into l_item_key
2113: from sys.dual;
2114:
2115: -- get location
2116: l_location_name := ota_general.get_Location_code(l_location_id);
2117:
2118: -- get Traininig center
2119: l_training_center := ota_general.get_training_center(l_training_center_id);
2120:

Line 2119: l_training_center := ota_general.get_training_center(l_training_center_id);

2115: -- get location
2116: l_location_name := ota_general.get_Location_code(l_location_id);
2117:
2118: -- get Traininig center
2119: l_training_center := ota_general.get_training_center(l_training_center_id);
2120:
2121:
2122: -- raise the event with the event data
2123: -- start BE

Line 2223: l_location_name := ota_general.get_Location_code(l_location_id);

2219: into l_item_key
2220: from sys.dual;
2221:
2222: -- get location
2223: l_location_name := ota_general.get_Location_code(l_location_id);
2224:
2225: -- build the xml data for the event
2226: --
2227: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);