APPS.OTA_INITIALIZATION_WF dependencies on DBMS_LOB

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

2123: -- start BE
2124:
2125: -- build the xml data for the event
2126: --
2127: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2128: l_text:='';
2129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2130:
2131: l_text:='';

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

2125: -- build the xml data for the event
2126: --
2127: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2128: l_text:='';
2129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2130:
2131: l_text:='';
2132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2133:

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

2128: l_text:='';
2129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2130:
2131: 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_person_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_person_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.delegate_contact_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.delegate_contact_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(rec.booking_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(rec.booking_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||fnd_number.number_to_canonical(l_location_id);
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||fnd_number.number_to_canonical(l_location_id);
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||irc_utilities_pkg.removeTags(l_location_name);
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||irc_utilities_pkg.removeTags(l_location_name);
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||fnd_number.number_to_canonical(l_training_center_id);
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||fnd_number.number_to_canonical(l_training_center_id);
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||irc_utilities_pkg.removeTags(l_training_center);
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||irc_utilities_pkg.removeTags(l_training_center);
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||fnd_number.number_to_canonical(p_eventid);
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||fnd_number.number_to_canonical(p_eventid);
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||irc_utilities_pkg.removeTags(p_event_fired);
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||irc_utilities_pkg.removeTags(p_event_fired);
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_start_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_start_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||fnd_date.date_to_canonical(l_end_date);
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||fnd_date.date_to_canonical(l_end_date);
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_start_time,'00:00'));
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_start_time,'00:00'));
2191: l_text:=l_text||'';
2192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2193:
2194: l_text:='';
2195: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2196: l_text:=l_text||'';

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

2193:
2194: l_text:='';
2195: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2196: l_text:=l_text||'';
2197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2198:
2199: l_text:='';
2200: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2201:

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

2196: l_text:=l_text||'';
2197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2198:
2199: l_text:='';
2200: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2201:
2202:
2203: wf_event.raise(p_event_name=>p_event_fired
2204: ,p_event_key=>l_item_key

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

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);
2228: l_text:='';
2229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2230:
2231: l_text:='';

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

2225: -- build the xml data for the event
2226: --
2227: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
2228: l_text:='';
2229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2230:
2231: l_text:='';
2232: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2233:

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

2228: l_text:='';
2229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2230:
2231: 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_person_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_person_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.delegate_contact_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.delegate_contact_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(rec.booking_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(rec.booking_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||fnd_number.number_to_canonical(l_location_id);
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||fnd_number.number_to_canonical(l_location_id);
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||irc_utilities_pkg.removeTags(l_location_name);
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||irc_utilities_pkg.removeTags(l_location_name);
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||fnd_number.number_to_canonical(p_eventid);
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||fnd_number.number_to_canonical(p_eventid);
2261: l_text:=l_text||'';
2262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2263:
2264: l_text:='';

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

2263:
2264: l_text:='';
2267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2268:
2269: l_text:='';
2270: l_text:=l_text||irc_utilities_pkg.removeTags(p_event_fired);
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||irc_utilities_pkg.removeTags(p_event_fired);
2271: l_text:=l_text||'';
2272: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2273:
2274: if p_type is not null then
2275: l_text:='';
2276: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);

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

2274: if p_type is not null then
2275: l_text:='';
2276: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);
2277: l_text:=l_text||'';
2278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2279: end if;
2280:
2281: l_text:='';
2282: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);

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

2280:
2281: l_text:='';
2282: l_text:=l_text||fnd_date.date_to_canonical(l_start_date);
2283: l_text:=l_text||'';
2284: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2285:
2286: l_text:='';
2287: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2288: l_text:=l_text||'';

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

2285:
2286: l_text:='';
2287: l_text:=l_text||fnd_date.date_to_canonical(l_end_date);
2288: l_text:=l_text||'';
2289: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2290:
2291: l_text:='';
2292: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2293: l_text:=l_text||'';

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

2290:
2291: l_text:='';
2292: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_start_time,'00:00'));
2293: l_text:=l_text||'';
2294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2295:
2296: l_text:='';
2297: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2298: l_text:=l_text||'';

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

2295:
2296: l_text:='';
2297: l_text:=l_text||irc_utilities_pkg.removeTags(nvl(l_end_time,'23:59'));
2298: l_text:=l_text||'';
2299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2300:
2301: l_text:='';
2302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2303:

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

2298: l_text:=l_text||'';
2299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2300:
2301: l_text:='';
2302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
2303:
2304:
2305: wf_event.raise(p_event_name=>p_event_fired
2306: ,p_event_key=>l_item_key