[Home] [Help]
1351: l_line_check varchar2(20); --result of a line's validation
1352: l_line_err_msg varchar2(2000); --error message of the line
1353:
1354: -- trx_batch
1355: l_trxb_id fun_trx_batches.batch_id%TYPE;
1356: l_trxb_num fun_trx_batches.batch_number%TYPE;
1357:
1358: -- trx_headers
1359: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1352: l_line_err_msg varchar2(2000); --error message of the line
1353:
1354: -- trx_batch
1355: l_trxb_id fun_trx_batches.batch_id%TYPE;
1356: l_trxb_num fun_trx_batches.batch_number%TYPE;
1357:
1358: -- trx_headers
1359: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1360: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1360: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1361: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1362: l_trx_send_name hz_parties.party_name%TYPE;
1363: l_trx_recv_name hz_parties.party_name%TYPE;
1364: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1365: l_trx_desc fun_trx_headers.description%TYPE;
1366: l_trx_line_num varchar2(20);
1367: l_trx_line_sob NUMBER;
1368: l_trx_line_le NUMBER;
1365: l_trx_desc fun_trx_headers.description%TYPE;
1366: l_trx_line_num varchar2(20);
1367: l_trx_line_sob NUMBER;
1368: l_trx_line_le NUMBER;
1369: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1370:
1371: -- trx_lines
1372: l_trxl_num fun_trx_lines.line_id%TYPE;
1373: l_trxl_id fun_trx_lines.trx_id%TYPE;
1463: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
1464: 'ATTRIBUTE15',trxh.attribute15)
1465: , '') trxh_cash_related_item*/
1466: FROM FUN_TRX_HEADERS trxh
1467: ,FUN_TRX_BATCHES trxb
1468: ,FUN_TRX_TYPES_TL trxtype
1469: ,HZ_PARTIES party_init
1470: ,HZ_PARTIES party_reci
1471: --,JA_CN_DFF_ASSIGNMENTS dff
1556: -- Fix bug#7487439 added begin
1557: AND EXISTS
1558: (
1559: SELECT * FROM FUN_TRX_HEADERS trxh
1560: ,FUN_TRX_BATCHES trxb
1561: WHERE trxh.batch_id=trxb.batch_id
1562: AND trxh.invoice_flag='N'
1563: AND trxh.trx_id=l_trx_id --using variable l_trx_id
1564: AND