203: l_header NUMBER := 0;
204:
205:
206: BEGIN
207: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
208: l_export_message := FND_MESSAGE.Get;
209:
210: WriteOutput('
204:
205:
206: BEGIN
207: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT');
208: l_export_message := FND_MESSAGE.Get;
209:
210: WriteOutput('
214:
215: WriteOutput('
');
216: WriteOutput('
'||l_export_message||' | ');
'||l_export_message||' | ');'||l_export_message||' | ');||||||
'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');
221: fnd_message.set_name('SQLAP', 'AP_APXXTR_PREPAY_1');
222: l_export_message := FND_MESSAGE.Get;
223: WriteOutput('
247: IF(l_header > 0) THEN
248: WriteOutput('');
249: WriteOutput('
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
291: END IF;
292: WriteOutput('
'||l_org_name||' | '); 295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 296: l_export_message := FND_MESSAGE.Get; 297: WriteOutput(' | '||l_export_message||' | '); 298: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); Line 296: l_export_message := FND_MESSAGE.Get; |
'||l_org_name||' | '); 295: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 296: l_export_message := FND_MESSAGE.Get; 297: WriteOutput(' | '||l_export_message||' | '); 298: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 300: l_export_message := FND_MESSAGE.Get; Line 299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); | '||l_export_message||' | '); 298: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 299: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 300: l_export_message := FND_MESSAGE.Get; 301: WriteOutput(' | '||l_export_message||': '||l_page_count||' | '); 302: WriteOutput(' |
296: l_export_message := FND_MESSAGE.Get;
297: WriteOutput('
301: WriteOutput('
'||l_export_message||' | ');
---|
'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');
---|
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
386: WriteOutput('');
387: WriteOutput('
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' ' || l_total_func_amount || ' | ');
'||l_export_message||' ' || l_total_func_amount || ' | ');
477: END IF;
478: WriteOutput('
'||l_org_name||' | '); 481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 482: l_export_message := FND_MESSAGE.Get; 483: WriteOutput(' | '||l_export_message||' | '); 484: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); Line 482: l_export_message := FND_MESSAGE.Get; |
'||l_org_name||' | '); 481: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 482: l_export_message := FND_MESSAGE.Get; 483: WriteOutput(' | '||l_export_message||' | '); 484: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 486: l_export_message := FND_MESSAGE.Get; Line 485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); | '||l_export_message||' | '); 484: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 485: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 486: l_export_message := FND_MESSAGE.Get; 487: WriteOutput(' | '||l_export_message||': '||l_page_count||' | '); 488: WriteOutput(' |
482: l_export_message := FND_MESSAGE.Get;
483: WriteOutput('
487: WriteOutput('
'||l_export_message||' | ');
---|
'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');
---|
'||l_export_message||' ' || l_total_func_amount || ' | ');
'||l_export_message||' ' || l_total_func_amount || ' | ');
568: END IF;
569:
570: --WriteOutput('
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
660:
661: WriteOutput('
'||l_org_name||' | '); 664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 665: l_export_message := FND_MESSAGE.Get; 666: WriteOutput(' | '||l_export_message||' | '); 667: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); Line 665: l_export_message := FND_MESSAGE.Get; |
'||l_org_name||' | '); 664: fnd_message.set_name('SQLAP', 'OIE_EXPENSE_REPORT_EXPORT'); 665: l_export_message := FND_MESSAGE.Get; 666: WriteOutput(' | '||l_export_message||' | '); 667: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 669: l_export_message := FND_MESSAGE.Get; Line 668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); | '||l_export_message||' | '); 667: WriteOutput(' | '||to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||' | '); 668: fnd_message.set_name('SQLAP', 'OIE_EXPORT_PAGE'); 669: l_export_message := FND_MESSAGE.Get; 670: WriteOutput(' | '||l_export_message||': '||l_page_count||' | '); 671: WriteOutput(' |
665: l_export_message := FND_MESSAGE.Get;
666: WriteOutput('
670: WriteOutput('
'||l_export_message||' | ');
---|
'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');'||l_export_message||' | ');
---|
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
752: WriteOutput('');
753: WriteOutput('
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');
'||l_export_message||' | ');