[Home] [Help]
28: --| 07-Mar-06 kdevadas BLANKET_PRICE and PO_DISTRIBUTION_ID |
29: --| columns added to MCT.PO price returned |
30: --| by get_break_price is inserted INTO |
31: --| MTL_CONSUMPTION_TRANSACTIONS-Bug 4969421 |
32: --| 22-May-06 kdevadas Delete from ZX_TRX_HEADERS_GT before |
33: --| insertion. This prevents 'Unique |
34: --| Constraint Violated' error- Bug 5084307 |
35: --| 18-Jul-06 kdevadas Get_Consumed_Amt procedure changed |
36: --| to use mct.blanket_price rather than |
688: ( 'Etax: clearing existing records from GT '
689: , 9
690: );
691: /* 5084307 - Start */
692: /* delete from ZX_TRX_HEADERS_GT if records already exist to
693: to prevent duplicate records from being entered */
694: /*bug#7120486 delete statement is moved at end after calling ebtax API */
695: /* 5084307 - end */
696:
702:
703: /*5488006 - End */
704:
705:
706: INSERT INTO ZX_TRX_HEADERS_GT
707: ( internal_organization_id
708: , application_id
709: , entity_code
710: , event_class_code
980: one transaction then the GT tables still have previous record hence it tries to
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:
985: ZX_TRANSACTION_LINES_GT
986: ZX_ITM_DISTRIBUTIONS_GT
987: */
988:
989: DELETE FROM ZX_TRX_HEADERS_GT
990: WHERE APPLICATION_ID = l_application_id
991: AND ENTITY_CODE = l_entity_code
992: AND EVENT_CLASS_CODE = l_event_class_code
993: AND TRX_ID = p_header_id;