[Home] [Help]
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,
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;
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
1957: VALUES
1958: (
1959: v_set_of_books_id,
1960: v_org_id,
1961: fv_ipac_billing_id_s.NEXTVAL,
1962: l_amount,
1963: nvl(trx_receipt_rec.cnt_nm,-99),
1964: trx_receipt_rec.trx_number,
1965: trx_receipt_rec.trx_date,
2024: VALUES
2025: (
2026: v_set_of_books_id,
2027: v_org_id,
2028: fv_ipac_billing_id_s.NEXTVAL,
2029: trx_receipt_rec.amount,
2030: '-99',
2031: trx_receipt_rec.trx_number,
2032: trx_receipt_rec.trx_date,
2264: VALUES
2265: (
2266: v_set_of_books_id,
2267: v_org_id,
2268: fv_ipac_billing_id_s.NEXTVAL,
2269: trx_receipt_rec.amount,
2270: '-99',
2271: trx_receipt_rec.trx_number,
2272: trx_receipt_rec.trx_date,