APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_MATCH_TAXES

Line 29: Deletion from JAI_CMN_MATCH_TAXES was missing when quantity is changed after matching.

25: Modified procedure DEFAULT_TAXES to recalculate taxes if the quantity alone
26: is changed. In other cases it would redefault taxes
27:
28: 4 30-Jan-2007 rchandan for bug#942973 for File Version 115.11 (INTER ORG Impl.)
29: Deletion from JAI_CMN_MATCH_TAXES was missing when quantity is changed after matching.
30: So added this statement now
31:
32: 5. 5-mar-2007 kunkumar - bug#5907436 -file branch 6107 on 115 main code line.
33: Added higher education cess needed for implementing requirements imposed by budget of 2007.

Line 5317: DELETE JAI_CMN_MATCH_TAXES

5313: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
5314: AND transaction_commit_date is null
5315: );
5316:
5317: DELETE JAI_CMN_MATCH_TAXES
5318: WHERE ref_line_id IN
5319: (
5320: SELECT transaction_temp_id
5321: FROM jai_mtl_trxs

Line 5462: DELETE JAI_CMN_MATCH_TAXES

5458:
5459: DELETE jai_mtl_match_receipts
5460: WHERE transaction_temp_id = p_line_id ;
5461:
5462: DELETE JAI_CMN_MATCH_TAXES
5463: WHERE ref_line_id = p_line_id
5464: AND order_invoice = 'X' ;
5465:
5466: COMMIT;