APPS.FV_1219_TRANSACTIONS dependencies on FV_FLATFILES

Line 5078: fv_flatfiles.create_flat_file(v_stmt);

5074: RPAD(' ',10)||''''||
5075: ' FROM DUAL';
5076:
5077: v_total_line_count := v_total_line_count + 1;
5078: fv_flatfiles.create_flat_file(v_stmt);
5079:
5080:
5081: --TOTAL lines 1.00 thru 9.90
5082: total_tab.delete;

Line 5109: fv_flatfiles.create_flat_file(v_stmt);

5105: ''.'',''''),'' '','''')|| RPAD('' '',57)
5106: FROM DUAL';
5107:
5108: v_total_line_count := v_total_line_count + 1;
5109: fv_flatfiles.create_flat_file(v_stmt);
5110: END LOOP;
5111:
5112:
5113: -- DETAIL lines for TC 210

Line 5136: fv_flatfiles.create_flat_file(v_stmt);

5132: l_amt||'''||'' ''||'''||line_210.alc_code||''''||
5133: ' FROM DUAL';
5134:
5135: v_total_line_count := v_total_line_count + 1;
5136: fv_flatfiles.create_flat_file(v_stmt);
5137: END LOOP;
5138:
5139:
5140: -- Detail Lines for TC 211 to TC 420 (excluding TC 410)

Line 5171: fv_flatfiles.create_flat_file(v_stmt);

5167: '||'' ''||'||''''||line_211_420.accomplish_month||''''||
5168: ' FROM DUAL';
5169:
5170: v_total_line_count := v_total_line_count + 1;
5171: fv_flatfiles.create_flat_file(v_stmt);
5172: old_line_num := line_211_420.line_num;
5173: END LOOP;
5174:
5175:

Line 5224: fv_flatfiles.create_flat_file(v_stmt);

5220: '||RPAD('' '',17)'||
5221: ' FROM DUAL';
5222:
5223: v_total_line_count := v_total_line_count + 1;
5224: fv_flatfiles.create_flat_file(v_stmt);
5225:
5226: v_entry_number := v_entry_number + 1;
5227: v_line_count := v_line_count + 1;
5228:

Line 5254: fv_flatfiles.create_flat_file(v_stmt);

5250: '||RPAD('' '',17)'||
5251: ' FROM DUAL';
5252:
5253: v_total_line_count := v_total_line_count + 1;
5254: fv_flatfiles.create_flat_file(v_stmt);
5255:
5256: ELSE -- If either receipt or disbursement amount exist
5257:
5258: v_entry_number := v_entry_number + 1;

Line 5291: fv_flatfiles.create_flat_file(v_stmt);

5287: '||RPAD('' '',17)'||
5288: ' FROM DUAL';
5289:
5290: v_total_line_count := v_total_line_count + 1;
5291: fv_flatfiles.create_flat_file(v_stmt);
5292: END IF;
5293: END LOOP;
5294:
5295: --Print Trailer Line with following format. v_total_line_count

Line 5305: fv_flatfiles.create_flat_file(v_stmt);

5301: v_total_line_count||',8,'' '')'
5302: ||'||RPAD('' '',64)'||
5303: ' FROM DUAL';
5304:
5305: fv_flatfiles.create_flat_file(v_stmt);
5306:
5307: -- For the 'Final' run of the request set, delete all records
5308: -- from fv_sf1219_temp for the ALC
5309: -- but the P record and the M records that do not have any lines