APPS.FV_IPAC dependencies on FV_FLATFILES

Line 1435: fv_flatfiles.create_flat_file(v_statement);

1431: l_module_name VARCHAR2(200) ;
1432: BEGIN
1433: l_module_name := g_module_name || 'create_file_id_rec';
1434: v_statement := 'SELECT ''PCA '' FROM dual';
1435: fv_flatfiles.create_flat_file(v_statement);
1436: END ; -- create_file_id_rec
1437:
1438: -- -----------------------------------------------------------------------------
1439: -- -----------------------------------------------------------------------------

Line 1521: fv_flatfiles.create_flat_file(v_statement);

1517: --IF total ussgl count is 0 then nothing to report
1518: --write message and return
1519: IF l_total_ussgl_count = 0 THEN
1520: v_statement := 'SELECT ''No transactions found to report for Bulk File!'' FROM dual' ;
1521: fv_flatfiles.create_flat_file(v_statement);
1522: RETURN;
1523: END IF;
1524:
1525: --Geting the count of total detail record

Line 1570: fv_flatfiles.create_flat_file(v_statement);

1566: v_statement := 'SELECT ''B''||''IPAC'' || LPAD('
1567: || v_total_count||',8,''0'') ||
1568: '''||l_file_id||''' FROM dual' ;
1569:
1570: fv_flatfiles.create_flat_file(v_statement);
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN