[Home] [Help]
1450: WHEN NO_DATA_FOUND THEN
1451: NULL;
1452: END; -- X1
1453:
1454: DELETE JAI_AR_TRX_TAX_CALC_T;
1455:
1456: v_statement_id := '55';
1457: -- BLOCK DEALING WITH TAX CHANGES
1458: DECLARE -- 00X2
1482: TEMP.PRECEDENCE_8,
1483: TEMP.PRECEDENCE_9,
1484: TEMP.PRECEDENCE_10,
1485: COD.ADHOC_FLAG
1486: FROM JAI_AR_TRX_TAX_CALC_T TEMP,
1487: JAI_CMN_TAXES_ALL COD
1488: WHERE LINK_TO_CUST_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1489: AND TEMP.TAX_ID = COD.TAX_ID;
1490:
1499: T_mapping_id := null;
1500:
1501: v_statement_id := '56';
1502:
1503: INSERT INTO JAI_AR_TRX_TAX_CALC_T(
1504: TAX_LINE_NO,
1505: CUSTOMER_TRX_LINE_ID,
1506: LINK_TO_CUST_TRX_LINE_ID,
1507: PRECEDENCE_1,
1573:
1574: IF CTAX.EXISTING_TYPE_ID = GTAX.TAX_ID THEN
1575: TAX_LIST_CHANGE_INDICATOR := 'Y';
1576: v_statement_id := '60';
1577: UPDATE JAI_AR_TRX_TAX_CALC_T
1578: SET TAX_ID = CTAX.NEW_TYPE_ID,
1579: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1580: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1581: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1939: v_statement_id := '98';
1940: DELETE JAI_AR_SUP_INV_T;
1941:
1942: v_statement_id := '99';
1943: DELETE JAI_AR_TRX_TAX_CALC_T;
1944:
1945: v_statement_id := '100';
1946: COMMIT;
1947:
2704: 0
2705: ) tax_type_val,
2706: d.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/07
2707: FROM
2708: JAI_AR_TRX_TAX_CALC_T c,
2709: JAI_CMN_TAXES_ALL d
2710: WHERE
2711: c.link_to_cust_trx_line_id = p_line_id AND
2712: c.tax_id = d.tax_id
3912: END IF;
3913:
3914: IF transaction_name = 'OE_LINES_UPDATE' THEN
3915:
3916: UPDATE JAI_AR_TRX_TAX_CALC_T
3917: SET
3918: tax_amount = nvl(tax_amt_tab(rec.lno),0) ,
3919: base_tax_amount = decode(nvl(base_tax_amt_tab(rec.lno),0) ,
3920: 0 ,