APPS.FV_IPAC dependencies on DUAL

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

171: AND customer_trx_id = p_customer_trx_id
172: AND trx_line_no = rctl.line_number
173: )
174: ;
175: -- Cursor to select individual transactions which have not been yet processed
176: -- for creating and applying receipts
177: CURSOR trx_receipt_cur
178: IS
179: SELECT SUM(amount) amount,

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

660: BEGIN
661: v_trx_excl_flag := 'N';
662: v_trx_proc_flag := 'N';
663: l_module_name := g_module_name || 'insert_trx_rec';
664: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
665: INSERT
666: INTO fv_ipac_trx_all
667: (
668: set_of_books_id,

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

1227: del_exception_recs;
1228: get_bal_seg_name;
1229: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Default ALC is '||v_default_alc);
1230: --get the start of billing Id
1231: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1232: FOR trx_select_rec IN trx_select
1233: LOOP -- trx_select
1234: init_vars;
1235: v_receipt_method_id := trx_select_rec.receipt_method_id;

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

1321: init_vars;
1322: END LOOP; -- detail_select
1323: END LOOP; -- trx_SELECT
1324: --get the end of billing id
1325: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1326: -- To create REC line equal to a detail lines for each transaction
1327: -- equalize_rec_lines;
1328: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1329: -- FOR each distibution line of a transaction

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

1414: v_statement VARCHAR2(200);
1415: l_module_name VARCHAR2(200) ;
1416: BEGIN
1417: l_module_name := g_module_name || 'create_file_id_rec';
1418: v_statement := 'SELECT ''PCA '' FROM dual';
1419: fv_flatfiles.create_flat_file(v_statement);
1420: END ; -- create_file_id_rec
1421:
1422: -- -----------------------------------------------------------------------------

Line 1529: RPAD('' '',19,'' '') FROM dual';

1525: 'v_total_count = '||v_total_count);
1526:
1527: v_statement := 'SELECT ''B''||''IPAC'' || LPAD('
1528: || v_total_count||',8,''0'') ||
1529: RPAD('' '',19,'' '') FROM dual';
1530: fv_flatfiles.create_flat_file(v_statement);
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1608: FROM dual ;

1604: || RPAD(' ',8) || RPAD(' ',9) || RPAD(' ',4) || RPAD(' ',15) || DECODE(trx_details_rec.unt_iss,NULL,' ',
1605: RPAD(SUBSTR(trx_details_rec.unt_iss,1,2),2,' '))|| DECODE(trx_details_rec.unt_prc,NULL,RPAD('0',14,'0'),
1606: REPLACE(TO_CHAR(trx_details_rec.unt_prc,'FM099999999999D00') ,'.',''))|| RPAD(' ',15) trx_line_rec
1607: INTO l_trx_detail_rec
1608: FROM dual ;
1609: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_trx_detail_rec);
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: errcode :=SQLCODE;