[Home] [Help]
1332: WHEN NO_DATA_FOUND THEN
1333: NULL;
1334: END; -- X1
1335:
1336: DELETE JAI_AR_TRX_TAX_CALC_T;
1337:
1338: v_statement_id := '55';
1339: -- BLOCK DEALING WITH TAX CHANGES
1340: DECLARE -- 00X2
1364: TEMP.PRECEDENCE_8,
1365: TEMP.PRECEDENCE_9,
1366: TEMP.PRECEDENCE_10,
1367: COD.ADHOC_FLAG
1368: FROM JAI_AR_TRX_TAX_CALC_T TEMP,
1369: JAI_CMN_TAXES_ALL COD
1370: WHERE LINK_TO_CUST_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1371: AND TEMP.TAX_ID = COD.TAX_ID;
1372:
1381: T_mapping_id := null;
1382:
1383: v_statement_id := '56';
1384:
1385: INSERT INTO JAI_AR_TRX_TAX_CALC_T(
1386: TAX_LINE_NO,
1387: CUSTOMER_TRX_LINE_ID,
1388: LINK_TO_CUST_TRX_LINE_ID,
1389: PRECEDENCE_1,
1455:
1456: IF CTAX.EXISTING_TYPE_ID = GTAX.TAX_ID THEN
1457: TAX_LIST_CHANGE_INDICATOR := 'Y';
1458: v_statement_id := '60';
1459: UPDATE JAI_AR_TRX_TAX_CALC_T
1460: SET TAX_ID = CTAX.NEW_TYPE_ID,
1461: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1462: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1463: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1811: v_statement_id := '98';
1812: DELETE JAI_AR_SUP_INV_T;
1813:
1814: v_statement_id := '99';
1815: DELETE JAI_AR_TRX_TAX_CALC_T;
1816:
1817: v_statement_id := '100';
1818: COMMIT;
1819:
2561: 0
2562: ) tax_type_val,
2563: d.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/07
2564: FROM
2565: JAI_AR_TRX_TAX_CALC_T c,
2566: JAI_CMN_TAXES_ALL d
2567: WHERE
2568: c.link_to_cust_trx_line_id = p_line_id AND
2569: c.tax_id = d.tax_id
3264: END IF;
3265:
3266: IF transaction_name = 'OE_LINES_UPDATE' THEN
3267:
3268: UPDATE JAI_AR_TRX_TAX_CALC_T
3269: SET
3270: tax_amount = nvl(tax_amt_tab(rec.lno),0) ,
3271: base_tax_amount = decode(nvl(base_tax_amt_tab(rec.lno),0) ,
3272: 0 ,