DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_TRANSACTION_LINES_GT

Line 690: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT

686: /*bug#7120486 delete statement is moved at end after calling ebtax API */
687: /* 5084307 - end */
688:
689: /*5488006 - Start */
690: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT
691: before inserting records to prevent duplicate insertion of records -
692: this caused errors in tax calculation */
693: /*bug#7120486 delete statement is moved at end after calling ebtax API */
694:

Line 772: INSERT INTO ZX_TRANSACTION_LINES_GT

768:
769:
770: /*bug 5081702 End */
771:
772: INSERT INTO ZX_TRANSACTION_LINES_GT
773: ( application_id
774: , entity_code
775: , event_class_code
776: , trx_level_type

Line 975: ZX_TRANSACTION_LINES_GT

971: calculate tax for previous line again which result in unique constraint violation
972: in ebTax table.
973: we have to clear following tables :
974: ZX_TRX_HEADERS_GT
975: ZX_TRANSACTION_LINES_GT
976: ZX_ITM_DISTRIBUTIONS_GT
977: */
978:
979: DELETE FROM ZX_TRX_HEADERS_GT

Line 985: DELETE FROM ZX_TRANSACTION_LINES_GT

981: AND ENTITY_CODE = l_entity_code
982: AND EVENT_CLASS_CODE = l_event_class_code
983: AND TRX_ID = p_header_id;
984:
985: DELETE FROM ZX_TRANSACTION_LINES_GT
986: WHERE APPLICATION_ID = l_application_id
987: AND ENTITY_CODE = l_entity_code
988: AND EVENT_CLASS_CODE = l_event_class_code
989: AND TRX_ID = p_header_id;