DBA Data[Home] [Help]

APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_TRX_HEADERS_ALL_S

Line 581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;

577: l_fix_field VARCHAR2(100);
578: l_str VARCHAR2(100);
579: l_failed BOOLEAN;
580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

Line 582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;

578: l_str VARCHAR2(100);
579: l_failed BOOLEAN;
580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

Line 965: SELECT ar_gta_trx_headers_all_s.NEXTVAL

961:
962:
963:
964:
965: SELECT ar_gta_trx_headers_all_s.NEXTVAL
966: INTO l_trx_header_rec.gta_trx_header_id
967: FROM dual;
968:
969: EXCEPTION