DBA Data[Home] [Help]

APPS.INV_THIRD_PARTY_STOCK_PVT dependencies on ZX_TRANSACTION_LINES_GT

Line 698: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT

694: /*bug#7120486 delete statement is moved at end after calling ebtax API */
695: /* 5084307 - end */
696:
697: /*5488006 - Start */
698: /* delete from ZX_TRANSACTION_LINES_GT and ZX_ITM_DISTRIBUTIONS_GT
699: before inserting records to prevent duplicate insertion of records -
700: this caused errors in tax calculation */
701: /*bug#7120486 delete statement is moved at end after calling ebtax API */
702:

Line 780: INSERT INTO ZX_TRANSACTION_LINES_GT

776:
777:
778: /*bug 5081702 End */
779:
780: INSERT INTO ZX_TRANSACTION_LINES_GT
781: ( application_id
782: , entity_code
783: , event_class_code
784: , trx_level_type

Line 985: ZX_TRANSACTION_LINES_GT

981: calculate tax for previous line again which result in unique constraint violation
982: in ebTax table.
983: we have to clear following tables :
984: ZX_TRX_HEADERS_GT
985: ZX_TRANSACTION_LINES_GT
986: ZX_ITM_DISTRIBUTIONS_GT
987: */
988:
989: DELETE FROM ZX_TRX_HEADERS_GT

Line 995: DELETE FROM ZX_TRANSACTION_LINES_GT

991: AND ENTITY_CODE = l_entity_code
992: AND EVENT_CLASS_CODE = l_event_class_code
993: AND TRX_ID = p_header_id;
994:
995: DELETE FROM ZX_TRANSACTION_LINES_GT
996: WHERE APPLICATION_ID = l_application_id
997: AND ENTITY_CODE = l_entity_code
998: AND EVENT_CLASS_CODE = l_event_class_code
999: AND TRX_ID = p_header_id;