eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_INITIALIZATION_WF dependencies on DBMS_LOB

Line 2122: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

2118: -- start BE
2119:
2120: -- build the xml data for the event
2121: --
2122: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2123: l_text:='';
2124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2125:
2126: l_text:='';

Line 2124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2120: -- build the xml data for the event
2121: --
2122: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2123: l_text:='';
2124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2125:
2126: l_text:='';
2127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2128:

Line 2127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2123: l_text:='';
2124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2125:
2126: l_text:='';
2127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2128:
2129: l_text:='';
2130: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_person_id);
2131: l_text:=l_text||'';

Line 2132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2128:
2129: l_text:='';
2130: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_person_id);
2131: l_text:=l_text||'';
2132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2133:
2134: l_text:='';
2135: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_contact_id);
2136: l_text:=l_text||'';

Line 2137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2133:
2134: l_text:='';
2135: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_contact_id);
2136: l_text:=l_text||'';
2137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2138:
2139: l_text:='';
2140: l_text:=l_text||fnd_number.number_to_canonical(rec.booking_id);
2141: l_text:=l_text||'';

Line 2142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2138:
2139: l_text:='';
2140: l_text:=l_text||fnd_number.number_to_canonical(rec.booking_id);
2141: l_text:=l_text||'';
2142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2143:
2144: l_text:='';
2145: l_text:=l_text||fnd_number.number_to_canonical(l_location_id);
2146: l_text:=l_text||'';

Line 2147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2143:
2144: l_text:='';
2145: l_text:=l_text||fnd_number.number_to_canonical(l_location_id);
2146: l_text:=l_text||'';
2147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2148:
2149: l_text:='';
2150: l_text:=l_text||irc_utilities_pkg.removeTags(l_location_name);
2151: l_text:=l_text||'';

Line 2152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2148:
2149: l_text:='';
2150: l_text:=l_text||irc_utilities_pkg.removeTags(l_location_name);
2151: l_text:=l_text||'';
2152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2153:
2154: l_text:='';
2155: l_text:=l_text||fnd_number.number_to_canonical(l_training_center_id);
2156: l_text:=l_text||'';

Line 2157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2153:
2154: l_text:='';
2155: l_text:=l_text||fnd_number.number_to_canonical(l_training_center_id);
2156: l_text:=l_text||'';
2157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2158:
2159: l_text:='';
2160: l_text:=l_text||irc_utilities_pkg.removeTags(l_training_center);
2161: l_text:=l_text||'';

Line 2162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2158:
2159: l_text:='';
2160: l_text:=l_text||irc_utilities_pkg.removeTags(l_training_center);
2161: l_text:=l_text||'';
2162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2163:
2164: l_text:='';
2165: l_text:=l_text||fnd_number.number_to_canonical(p_eventid);
2166: l_text:=l_text||'';

Line 2167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2163:
2164: l_text:='';
2165: l_text:=l_text||fnd_number.number_to_canonical(p_eventid);
2166: l_text:=l_text||'';
2167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2168:
2169: l_text:='';
2170: l_text:=l_text||irc_utilities_pkg.removeTags(p_event_fired);
2171: l_text:=l_text||'';

Line 2172: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2168:
2169: l_text:='';
2170: l_text:=l_text||irc_utilities_pkg.removeTags(p_event_fired);
2171: l_text:=l_text||'';
2172: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2173:
2174: l_text:='';
2175: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);
2176: l_text:=l_text||'';

Line 2177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2173:
2174: l_text:='';
2175: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);
2176: l_text:=l_text||'';
2177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2178:
2179: l_text:='';
2180: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2181: l_text:=l_text||'';

Line 2182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2178:
2179: l_text:='';
2180: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2181: l_text:=l_text||'';
2182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2183:
2184: l_text:='';
2185: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2186: l_text:=l_text||'';

Line 2187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2183:
2184: l_text:='';
2185: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2186: l_text:=l_text||'';
2187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2188:
2189: l_text:='';
2190: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2191: l_text:=l_text||'';

Line 2192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2188:
2189: l_text:='';
2190: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2191: l_text:=l_text||'';
2192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2193:
2194: l_text:='';
2195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2196:

Line 2195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2191: l_text:=l_text||'';
2192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2193:
2194: l_text:='';
2195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2196:
2197:
2198: wf_event.raise(p_event_name=>p_event_fired
2199: ,p_event_key=>l_item_key

Line 2222: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

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);
2223: l_text:='';
2224: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2225:
2226: l_text:='';

Line 2224: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2220: -- build the xml data for the event
2221: --
2222: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2223: l_text:='';
2224: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2225:
2226: l_text:='';
2227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2228:

Line 2227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2223: l_text:='';
2224: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2225:
2226: l_text:='';
2227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2228:
2229: l_text:='';
2230: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_person_id);
2231: l_text:=l_text||'';

Line 2232: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2228:
2229: l_text:='';
2230: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_person_id);
2231: l_text:=l_text||'';
2232: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2233:
2234: l_text:='';
2235: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_contact_id);
2236: l_text:=l_text||'';

Line 2237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2233:
2234: l_text:='';
2235: l_text:=l_text||fnd_number.number_to_canonical(rec.delegate_contact_id);
2236: l_text:=l_text||'';
2237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2238:
2239: l_text:='';
2240: l_text:=l_text||fnd_number.number_to_canonical(rec.booking_id);
2241: l_text:=l_text||'';

Line 2242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2238:
2239: l_text:='';
2240: l_text:=l_text||fnd_number.number_to_canonical(rec.booking_id);
2241: l_text:=l_text||'';
2242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2243:
2244: l_text:='';
2245: l_text:=l_text||fnd_number.number_to_canonical(l_location_id);
2246: l_text:=l_text||'';

Line 2247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2243:
2244: l_text:='';
2245: l_text:=l_text||fnd_number.number_to_canonical(l_location_id);
2246: l_text:=l_text||'';
2247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2248:
2249: l_text:='';
2250: l_text:=l_text||irc_utilities_pkg.removeTags(l_location_name);
2251: l_text:=l_text||'';

Line 2252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2248:
2249: l_text:='';
2250: l_text:=l_text||irc_utilities_pkg.removeTags(l_location_name);
2251: l_text:=l_text||'';
2252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2253:
2254: l_text:='';
2255: l_text:=l_text||fnd_number.number_to_canonical(p_eventid);
2256: l_text:=l_text||'';

Line 2257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2253:
2254: l_text:='';
2255: l_text:=l_text||fnd_number.number_to_canonical(p_eventid);
2256: l_text:=l_text||'';
2257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2258:
2259: l_text:='';
2260: l_text:=l_text||irc_utilities_pkg.removeTags(p_event_fired);
2261: l_text:=l_text||'';

Line 2262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2258:
2259: l_text:='';
2260: l_text:=l_text||irc_utilities_pkg.removeTags(p_event_fired);
2261: l_text:=l_text||'';
2262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2263:
2264: l_text:='';
2265: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);
2266: l_text:=l_text||'';

Line 2267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2263:
2264: l_text:='';
2265: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);
2266: l_text:=l_text||'';
2267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2268:
2269: l_text:='';
2270: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2271: l_text:=l_text||'';

Line 2272: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2268:
2269: l_text:='';
2270: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2271: l_text:=l_text||'';
2272: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2273:
2274: l_text:='';
2275: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2276: l_text:=l_text||'';

Line 2277: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2273:
2274: l_text:='';
2275: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2276: l_text:=l_text||'';
2277: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2278:
2279: l_text:='';
2280: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2281: l_text:=l_text||'';

Line 2282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2278:
2279: l_text:='';
2280: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2281: l_text:=l_text||'';
2282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2283:
2284: l_text:='';
2285: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2286:

Line 2285: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

2281: l_text:=l_text||'';
2282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2283:
2284: l_text:='';
2285: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2286:
2287:
2288: wf_event.raise(p_event_name=>p_event_fired
2289: ,p_event_key=>l_item_key