APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_LINES

Line 740: DELETE JMF_GTA_TRX_LINES

736: DELETE JMF_GTA_TRX_HEADERS
737: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
738: AND SOURCE='GT';
739:
740: DELETE JMF_GTA_TRX_LINES
741: WHERE GTA_TRX_HEADER_ID IN
742: ( SELECT GTA_TRX_HEADER_ID
743: FROM JMF_GTA_TRX_HEADERS
744: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num

Line 748: UPDATE JMF_GTA_TRX_LINES

744: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
745: AND SOURCE='GT');
746:
747: --change the matched_flag to initiated status.
748: UPDATE JMF_GTA_TRX_LINES
749: SET matched_flag='N'
750: WHERE GTA_TRX_HEADER_ID=l_header_id;
751:
752: --Requested by Donghai, for workbench judge whether upgrade version

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;

Line 1380: FROM JMF_GTA_trx_lines

1376: l_index INTEGER;
1377:
1378: CURSOR c_trx_lines(p_header_id IN NUMBER) IS
1379: SELECT *
1380: FROM JMF_GTA_trx_lines
1381: WHERE GTA_trx_header_id = p_header_id
1382: AND Enabled_Flag='Y';
1383:
1384: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

Line 1539: UPDATE jmf_gta_trx_lines

1535: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1536:
1537: END IF;-- x_success = G_EXPORT_SUCC
1538:
1539: UPDATE jmf_gta_trx_lines
1540: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1541: , program_application_id =fnd_global.RESP_APPL_ID
1542: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1543: , PROGRAM_UPDATE_DATE =SYSDATE