538: l_fix_field VARCHAR2(100);
539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
852:
853:
854:
855:
856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL
857: INTO l_trx_header_rec.gta_trx_header_id
858: FROM dual;
859:
860: EXCEPTION