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 4874: DELETE JAI_CMN_MATCH_TAXES

4870: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4871: AND transaction_commit_date is null
4872: );
4873:
4874: DELETE JAI_CMN_MATCH_TAXES
4875: WHERE ref_line_id IN
4876: (
4877: SELECT transaction_temp_id
4878: FROM jai_mtl_trxs

Line 5002: DELETE JAI_CMN_MATCH_TAXES

4998:
4999: DELETE jai_mtl_match_receipts
5000: WHERE transaction_temp_id = p_line_id ;
5001:
5002: DELETE JAI_CMN_MATCH_TAXES
5003: WHERE ref_line_id = p_line_id
5004: AND order_invoice = 'X' ;
5005:
5006: COMMIT;