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 2111: l_location_name := ota_general.get_Location_code(l_location_id);

2107: into l_item_key
2108: from sys.dual;
2109:
2110: -- get location
2111: l_location_name := ota_general.get_Location_code(l_location_id);
2112:
2113: -- get Traininig center
2114: l_training_center := ota_general.get_training_center(l_training_center_id);
2115:

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

2110: -- get location
2111: l_location_name := ota_general.get_Location_code(l_location_id);
2112:
2113: -- get Traininig center
2114: l_training_center := ota_general.get_training_center(l_training_center_id);
2115:
2116:
2117: -- raise the event with the event data
2118: -- start BE

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

2214: into l_item_key
2215: from sys.dual;
2216:
2217: -- get location
2218: l_location_name := ota_general.get_Location_code(l_location_id);
2219:
2220: -- build the xml data for the event
2221: --
2222: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);