DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_LINES_ALL

Line 913: UPDATE jmf_gta_trx_lines_all

909: --put_log('import log:10--');
910: l_trx_line_rec :=NULL;
911:
912: --compare whether there's record matched in GTA
913: UPDATE jmf_gta_trx_lines_all
914: SET matched_flag='Y'
915: WHERE gta_trx_header_id=l_header_id
916: AND enabled_flag='Y'
917: AND item_description=l_values(2)

Line 946: SELECT jmf_gta_trx_lines_all_s.NEXTVAL

942: l_trx_line_rec.org_id :=l_org_id;
943: l_trx_line_rec.gta_trx_header_id
944: :=l_trx_header_rec.gta_trx_header_id;
945:
946: SELECT jmf_gta_trx_lines_all_s.NEXTVAL
947: INTO l_trx_line_rec.gta_trx_line_id
948: FROM dual;
949:
950: l_line_num:=l_line_num+1;