DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_HEADERS_ALL_S

Line 542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;

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;

Line 543: l_new_status Jmf_Gta_Trx_Headers_All.Status%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;

Line 856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL

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