APPS.FV_IPAC dependencies on DUAL

Line 180: -- Cursor to select individual transactions which have not been yet processed

176: AND customer_trx_id = p_customer_trx_id
177: AND trx_line_no = rctl.line_number
178: )
179: ;
180: -- Cursor to select individual transactions which have not been yet processed
181: -- for creating and applying receipts
182: -- Bug 12609586. Added fit.trn_set_id to the select clause
183: CURSOR trx_receipt_cur
184: IS

Line 680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;

676: BEGIN
677: v_trx_excl_flag := 'N';
678: v_trx_proc_flag := 'N';
679: l_module_name := g_module_name || 'insert_trx_rec';
680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
681: INSERT
682: INTO fv_ipac_trx_all
683: (
684: set_of_books_id,

Line 1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;

1243: del_exception_recs;
1244: get_bal_seg_name;
1245:
1246: --get the start of billing Id
1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1248: FOR trx_select_rec IN trx_select
1249: LOOP -- trx_select
1250: init_vars;
1251: v_receipt_method_id := trx_select_rec.receipt_method_id;

Line 1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;

1337: init_vars;
1338: END LOOP; -- detail_select
1339: END LOOP; -- trx_SELECT
1340: --get the end of billing id
1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1342: -- To create REC line equal to a detail lines for each transaction
1343: -- equalize_rec_lines;
1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1345: -- FOR each distibution line of a transaction

Line 1434: v_statement := 'SELECT ''PCA '' FROM dual';

1430: v_statement VARCHAR2(200);
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: -- -----------------------------------------------------------------------------

Line 1520: v_statement := 'SELECT ''No transactions found to report for Bulk File!'' FROM dual' ;

1516:
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:

Line 1561: FROM DUAL;

1557: SELECT lpad(lv_sender_alc,8,'0')||
1558: to_char(sysdate,'YYYYMMDD')||
1559: lpad(FV_IPAC_AR_BATCH_HDR_S.nextval,3,'0')
1560: INTO l_file_id
1561: FROM DUAL;
1562:
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1564: 'l_file_id = '||l_file_id);
1565:

Line 1568: '''||l_file_id||''' FROM dual' ;

1564: 'l_file_id = '||l_file_id);
1565:
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

Line 1649: FROM dual ;

1645: || RPAD(' ',8) || RPAD(' ',9) || RPAD(' ',4) || RPAD(' ',15) || DECODE(trx_details_rec.unt_iss,NULL,' ',
1646: RPAD(SUBSTR(trx_details_rec.unt_iss,1,2),2,' '))|| DECODE(trx_details_rec.unt_prc,NULL,RPAD('0',14,'0'),
1647: REPLACE(TO_CHAR(trx_details_rec.unt_prc,'FM099999999999D00') ,'.',''))|| RPAD(' ',15) trx_line_rec
1648: INTO l_trx_detail_rec
1649: FROM dual ;
1650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_trx_detail_rec);
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: errcode :=SQLCODE;