[Home] [Help]
1314: l_line_check varchar2(20); --result of a line's validation
1315: l_line_err_msg varchar2(2000); --error message of the line
1316:
1317: -- trx_batch
1318: l_trxb_id fun_trx_batches.batch_id%TYPE;
1319: l_trxb_num fun_trx_batches.batch_number%TYPE;
1320:
1321: -- trx_headers
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1315: l_line_err_msg varchar2(2000); --error message of the line
1316:
1317: -- trx_batch
1318: l_trxb_id fun_trx_batches.batch_id%TYPE;
1319: l_trxb_num fun_trx_batches.batch_number%TYPE;
1320:
1321: -- trx_headers
1322: l_trx_id fun_trx_headers.Trx_Id%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1323: l_trx_num fun_trx_headers.Trx_Number%TYPE;
1324: l_trx_type fun_trx_types_tl.trx_type_name%TYPE;
1325: l_trx_send_name hz_parties.party_name%TYPE;
1326: l_trx_recv_name hz_parties.party_name%TYPE;
1327: l_trx_gl_date fun_trx_batches.gl_date%TYPE;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1330: l_trx_line_sob NUMBER;
1331: l_trx_line_le NUMBER;
1328: l_trx_desc fun_trx_headers.description%TYPE;
1329: l_trx_line_num varchar2(20);
1330: l_trx_line_sob NUMBER;
1331: l_trx_line_le NUMBER;
1332: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1333:
1334: -- trx_lines
1335: l_trxl_num fun_trx_lines.line_id%TYPE;
1336: l_trxl_id fun_trx_lines.trx_id%TYPE;
1426: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
1427: 'ATTRIBUTE15',trxh.attribute15)
1428: , '') trxh_cash_related_item*/
1429: FROM FUN_TRX_HEADERS trxh
1430: ,FUN_TRX_BATCHES trxb
1431: ,FUN_TRX_TYPES_TL trxtype
1432: ,HZ_PARTIES party_init
1433: ,HZ_PARTIES party_reci
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1519: -- Fix bug#7487439 added begin
1520: AND EXISTS
1521: (
1522: SELECT * FROM FUN_TRX_HEADERS trxh
1523: ,FUN_TRX_BATCHES trxb
1524: WHERE trxh.batch_id=trxb.batch_id
1525: AND trxh.invoice_flag='N'
1526: AND trxh.trx_id=l_trx_id --using variable l_trx_id
1527: AND