DBA Data[Home] [Help]

APPS.JTF_FM_IH_LOGGER_PVT dependencies on FND_GLOBAL

Line 316: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10);

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) ||'
';

Line 341: 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 :='';

Line 342: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';

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:

Line 352: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';

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:

Line 388: l_interaction := l_interaction || FND_GLOBAL.Local_Chr(10) ||'';

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