1122:
1123: if (p_use_utl_file = 'Y') then
1124: UTL_FILE.PUT_LINE(g_outfile, l_header);
1125: else
1126: fnd_file.put(FND_FILE.OUTPUT, l_header);
1127: end if;
1128:
1129: build_anchors(g_anchor_tbl);
1130:
1136: UTL_FILE.PUT_LINE(g_outfile,g_output_tbl(i));
1137: --UTL_FILE.NEW_LINE(g_outfile,1);
1138: END LOOP;
1139: else
1140: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1141: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1142: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1143: fnd_file.new_line(FND_FILE.OUTPUT,1);
1144: END LOOP;
1138: END LOOP;
1139: else
1140: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1141: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1142: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1143: fnd_file.new_line(FND_FILE.OUTPUT,1);
1144: END LOOP;
1145: end if;
1146:
1139: else
1140: fnd_file.put(FND_FILE.OUTPUT,g_anchor);
1141: FOR i IN g_output_tbl.first .. g_output_tbl.last LOOP
1142: fnd_file.put(FND_FILE.OUTPUT,g_output_tbl(i));
1143: fnd_file.new_line(FND_FILE.OUTPUT,1);
1144: END LOOP;
1145: end if;
1146:
1147: l_no_rec := l_no_rec ||'The following table(s) contain no data for this asset:';
1155: l_no_rec := substr(l_no_rec, 1, length(l_no_rec) -4)||'';
1156: if p_use_utl_file = 'Y' then
1157: UTL_FILE.PUT_LINE(g_outfile,l_no_rec);
1158: else
1159: fnd_file.put(FND_FILE.OUTPUT,l_no_rec);
1160: end if;
1161:
1162: END IF;
1163: