[Home] [Help]
2034: l_path varchar2(200);
2035: BEGIN
2036: l_path := g_path||'insert_batch_record';
2037: /* Check for mandatory parameters and all values that are going to be inserted */
2038: SELECT fun_net_batches_s.NEXTVAL
2039: INTO g_batch_id
2040: FROM DUAL;
2041: INSERT INTO FUN_NET_BATCHES_ALL
2042: (batch_id,
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3877: l_return_status VARCHAR2(1);
3878: l_exchange_rate_type varchar2(20);
3879: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;
3880: l_msg_count NUMBER;
3881: l_msg_data VARCHAR2(2000);
3882: CURSOR apply_trx_cur(p_cust_trx_id IN NUMBER)
3883: IS
3983: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3984: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3985: l_return_status VARCHAR2(1);
3986: l_exchange_rate_type varchar2(20);
3987: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;
3988: l_msg_count NUMBER;
3989: l_msg_data VARCHAR2(2000);
3990: l_path VARCHAR2(100);
3991: l_receipt_currecycode VARCHAR2(10); -- bug 52380292