[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 |
680: ( 'Etax: clearing existing records from GT '
681: , 9
682: );
683: /* 5084307 - Start */
684: /* delete from ZX_TRX_HEADERS_GT if records already exist to
685: to prevent duplicate records from being entered */
686: /*bug#7120486 delete statement is moved at end after calling ebtax API */
687: /* 5084307 - end */
688:
694:
695: /*5488006 - End */
696:
697:
698: INSERT INTO ZX_TRX_HEADERS_GT
699: ( internal_organization_id
700: , application_id
701: , entity_code
702: , event_class_code
970: one transaction then the GT tables still have previous record hence it tries to
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:
975: ZX_TRANSACTION_LINES_GT
976: ZX_ITM_DISTRIBUTIONS_GT
977: */
978:
979: DELETE FROM ZX_TRX_HEADERS_GT
980: WHERE APPLICATION_ID = l_application_id
981: AND ENTITY_CODE = l_entity_code
982: AND EVENT_CLASS_CODE = l_event_class_code
983: AND TRX_ID = p_header_id;