1106:
1107: if (p_use_utl_file = 'Y') then
1108: UTL_FILE.PUT_LINE(g_outfile, l_header);
1109: else
1110: fnd_file.put(FND_FILE.OUTPUT, l_header);
1111: end if;
1112:
1113: build_anchors(g_anchor_tbl);
1114:
1120: UTL_FILE.PUT_LINE(g_outfile,g_output_tbl(i));
1121: --UTL_FILE.NEW_LINE(g_outfile,1);
1122: END LOOP;
1123: else
1124: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1125: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1126: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1127: fnd_file.new_line(FND_FILE.OUTPUT,1);
1128: END LOOP;
1122: END LOOP;
1123: else
1124: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1125: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1126: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1127: fnd_file.new_line(FND_FILE.OUTPUT,1);
1128: END LOOP;
1129: end if;
1130:
1123: else
1124: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1125: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1126: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1127: fnd_file.new_line(FND_FILE.OUTPUT,1);
1128: END LOOP;
1129: end if;
1130:
1131: l_no_rec := l_no_rec ||'The following table(s) contain no data for this asset:';
1139: l_no_rec := substr(l_no_rec, 1, length(l_no_rec) -4)||'';
1140: if p_use_utl_file = 'Y' then
1141: UTL_FILE.PUT_LINE(g_outfile,l_no_rec);
1142: else
1143: fnd_file.put(FND_FILE.OUTPUT,l_no_rec);
1144: end if;
1145:
1146: END IF;
1147: