APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_TRX_LINES

Line 797: DELETE AR_GTA_TRX_LINES

793: DELETE AR_GTA_TRX_HEADERS
794: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
795: AND SOURCE='GT';
796:
797: DELETE AR_GTA_TRX_LINES
798: WHERE GTA_TRX_HEADER_ID IN
799: ( SELECT GTA_TRX_HEADER_ID
800: FROM AR_GTA_TRX_HEADERS
801: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num

Line 804: UPDATE AR_GTA_TRX_LINES

800: FROM AR_GTA_TRX_HEADERS
801: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
802: AND SOURCE='GT');
803: --change the matched_flag to initiated status.
804: UPDATE AR_GTA_TRX_LINES
805: SET matched_flag='N'
806: WHERE GTA_TRX_HEADER_ID=l_header_id;
807: ELSE
808: --break this VAT invoice loop

Line 842: DELETE AR_GTA_TRX_LINES

838: DELETE AR_GTA_TRX_HEADERS
839: WHERE GTA_TRX_NUMBER = l_GTA_Invoice_num
840: AND SOURCE = 'GT';
841:
842: DELETE AR_GTA_TRX_LINES
843: WHERE GTA_TRX_HEADER_ID IN (SELECT GTA_TRX_HEADER_ID
844: FROM AR_GTA_TRX_HEADERS
845: WHERE GTA_TRX_NUMBER = l_GTA_Invoice_num
846: AND SOURCE = 'GT');

Line 848: UPDATE AR_GTA_TRX_LINES

844: FROM AR_GTA_TRX_HEADERS
845: WHERE GTA_TRX_NUMBER = l_GTA_Invoice_num
846: AND SOURCE = 'GT');
847: --change the matched_flag to initiated status.
848: UPDATE AR_GTA_TRX_LINES
849: SET matched_flag='N'
850: WHERE GTA_TRX_HEADER_ID=l_header_id;
851: END IF;--If l_values(1)='0'
852: END IF;--IF NOT l_vat_tbl.EXISTS(l_gta_invoice_num)

Line 1022: UPDATE ar_gta_trx_lines_all

1018: --put_log('import log:10--');
1019: l_trx_line_rec :=NULL;
1020:
1021: --compare whether there's record matched in GTA
1022: UPDATE ar_gta_trx_lines_all
1023: SET matched_flag='Y'
1024: WHERE gta_trx_header_id=l_header_id
1025: AND enabled_flag='Y'
1026: AND item_description=l_values(2)

Line 1055: SELECT ar_gta_trx_lines_all_s.NEXTVAL

1051: l_trx_line_rec.org_id :=l_org_id;
1052: l_trx_line_rec.gta_trx_header_id
1053: :=l_trx_header_rec.gta_trx_header_id;
1054:
1055: SELECT ar_gta_trx_lines_all_s.NEXTVAL
1056: INTO l_trx_line_rec.gta_trx_line_id
1057: FROM dual;
1058:
1059: l_line_num:=l_line_num+1;

Line 1544: FROM AR_GTA_trx_lines

1540: l_uom_name varchar2(25);--Yao Zhang add for bug 8339490
1541:
1542: CURSOR c_trx_lines(p_header_id IN NUMBER) IS
1543: SELECT *
1544: FROM AR_GTA_trx_lines
1545: WHERE GTA_trx_header_id = p_header_id
1546: AND Enabled_Flag='Y';
1547:
1548: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

Line 1722: UPDATE ar_gta_trx_lines

1718: WHERE GTA_TRX_HEADER_ID=l_invoice.gta_Trx_header_id;
1719:
1720: END IF;-- x_success = G_EXPORT_SUCC
1721:
1722: UPDATE ar_gta_trx_lines
1723: SET REQUEST_ID =fnd_global.CONC_REQUEST_ID
1724: , program_application_id =fnd_global.RESP_APPL_ID
1725: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID
1726: , PROGRAM_UPDATE_DATE =SYSDATE