DBA Data[Home] [Help]

APPS.OZF_MULTI_CURR_MIG_PVT dependencies on FND_FILE

Line 132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------Accruals to be Migrated for Multi Currency Report ------------------------------*');

128:
129: BEGIN
130: SAVEPOINT Mig_Utilization_Records;
131:
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------Accruals to be Migrated for Multi Currency Report ------------------------------*');
133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');
135:
136: /*Update all 4 new columns. This will get executed only for the first time due to the where clause

Line 133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

129: BEGIN
130: SAVEPOINT Mig_Utilization_Records;
131:
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------Accruals to be Migrated for Multi Currency Report ------------------------------*');
133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');
135:
136: /*Update all 4 new columns. This will get executed only for the first time due to the where clause
137: 1) fund_request_amount

Line 134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');

130: SAVEPOINT Mig_Utilization_Records;
131:
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------Accruals to be Migrated for Multi Currency Report ------------------------------*');
133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');
135:
136: /*Update all 4 new columns. This will get executed only for the first time due to the where clause
137: 1) fund_request_amount
138: 2) fund_request_amount_remaining

Line 229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_report_header_rec.column_val);

225:
226: IF l_row_count > 0 THEN
227: OPEN c_report_header;
228: FETCH c_report_header INTO l_report_header_rec;
229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_report_header_rec.column_val);
230: CLOSE c_report_header;
231:
232: IF p_debug_flag = 'Y' THEN
233: ozf_utility_pvt.write_conc_log (' <===> Report Header Added <===>');

Line 240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_reportOfferRecTbl(t_i));

236: OPEN c_report_offers;
237: FETCH c_report_offers BULK COLLECT INTO l_reportOfferRecTbl,l_planIdTbl;
238: FOR t_i IN NVL(l_planIdTbl.FIRST, 1) .. NVL(l_planIdTbl.LAST, 0)
239: LOOP
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_reportOfferRecTbl(t_i));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');
242: END LOOP;
243: CLOSE c_report_offers;
244:

Line 241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');

237: FETCH c_report_offers BULK COLLECT INTO l_reportOfferRecTbl,l_planIdTbl;
238: FOR t_i IN NVL(l_planIdTbl.FIRST, 1) .. NVL(l_planIdTbl.LAST, 0)
239: LOOP
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_reportOfferRecTbl(t_i));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------------------------------------------------------------------------------------*');
242: END LOOP;
243: CLOSE c_report_offers;
244:
245: IF p_debug_flag = 'Y' THEN