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)
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;