312: l_header_status_failure_flag := 'T';
313: end if;
314:
315:
316: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10);
317: l_attribute1 := to_char(l_header_rec.hist_req_id ||'_'|| j.job);
318:
319: --Interaction
320: l_interaction := l_interaction || '
328:
329: --activity
330: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) || '
336:
337: --Media Item
338: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) || '
341: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'
342: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'
337: --Media Item
338: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) || '
341: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'
342: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';
343:
344: dbms_lob.writeappend(l_interaction_clob, LENGTH(l_interaction), l_interaction);
345: l_interaction :='';
338: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) || '
341: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'
342: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';
343:
344: dbms_lob.writeappend(l_interaction_clob, LENGTH(l_interaction), l_interaction);
345: l_interaction :='';
346:
348:
349: --Maximum records for one interaction is 1000. Create a new interaction if counter has reached 1000
350: if l_counter = TOTAL_INTERACTIONS THEN
351:
352: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';
353:
354: dbms_lob.writeappend(l_interaction_clob, LENGTH(l_interaction), l_interaction);
355: l_interaction :='';
356:
384:
385: --Enqueue for interaction created from less than 1000 records
386: if l_counter < TOTAL_INTERACTIONS THEN
387:
388: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';
389: dbms_lob.writeappend(l_interaction_clob, LENGTH(l_interaction), l_interaction);
390: l_interaction :='';
391:
392: --Enqueueu