[Home] [Help]
983: CURSOR get_tax_ar_count_cur
984: IS
985: SELECT
986: COUNT(CUSTOMER_TRX_LINE_ID)
987: FROM JAI_AR_TRX_TAX_LINES
988: WHERE LINK_TO_CUST_TRX_LINE_ID --= pn_trx_line_id;--Commented by zhiwei for bug#12560873
989: --Added by zhiwei for bug#12560873 begin
990: ----------------------------------------
991: IN (
5407:
5408: CURSOR get_trx_gl_date_cur IS
5409: SELECT rda.gl_date
5410: FROM ra_cust_trx_line_gl_dist_all rda,
5411: jai_ar_trx_tax_lines rla
5412: WHERE rda.account_class = 'REV'
5413: AND rda.customer_trx_line_id = rla.link_to_cust_trx_line_id
5414: AND rla.customer_trx_line_id = pn_customer_trx_line_id;
5415:
5467: FROM ra_customer_trx_lines
5468: WHERE customer_trx_line_id IN
5469: (
5470: select link_to_cust_trx_line_id
5471: from jai_ar_trx_tax_lines
5472: where customer_trx_line_id = pn_customer_trx_line_id
5473: )
5474: );
5475:
5587: a.tax_amount tax_amt,
5588: b.tax_type t_type,
5589: a.customer_trx_line_id line_id,
5590: a.tax_line_no tax_line_no
5591: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
5592: WHERE link_to_cust_trx_line_id = pn_customer_trx_line_id
5593: and a.tax_id = b.tax_id
5594: AND NVL(b.inclusive_tax_flag, 'N') = 'N' --Added by Jia Li for Tax inclusive Computations on 2007/11/22
5595: ORDER BY 1;
6661: cursor chk_service_tax
6662: is
6663: select 1
6664: from
6665: JAI_AR_TRX_TAX_LINES taxes ,
6666: JAI_CMN_TAXES_ALL define
6667: where taxes.tax_id = define.tax_id
6668: and taxes.customer_trx_line_id = pn_customer_trx_line_id
6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),
6920:
6921: --added 12-Mar-2002
6922: CURSOR tax_type IS
6923: SELECT b.tax_type t_type, a.customer_trx_line_id line_id
6924: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
6925: WHERE link_to_cust_trx_line_id = pn_customer_trx_line_id
6926: and A.tax_id = B.tax_id;
6927:
6928:
6947:
6948: --added the following cursor for bug#8476512
6949: CURSOR cur_chk_jai_tax_dtls(cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE, cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE) IS
6950: SELECT 1
6951: FROM jai_ar_trx_tax_lines
6952: WHERE customer_trx_line_id = cp_customer_trx_line_id
6953: AND link_to_cust_trx_line_id = cp_link_to_cust_trx_line_id;
6954:
6955: ln_tax_line_exists NUMBER; --added for bug#8476512
7406: v_exter_request_id;
7407: CLOSE cur_get_external_dis_detail;
7408:
7409:
7410: --jai_ar_trx_tax_lines get tax_line_no base TEMP_REC.customer_trx_line_id and TEMP_REC.link_to_cust_trx_line_id
7411: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER
7412: --JAI-INTERFACE_DIS_LINES_ALL GET CODE_COMBINATION_ID PERCENT AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 REQUEST_ID
7413: OPEN SO_AR_HDR_INFO;
7414: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;
7609: v_exter_request_id;
7610: CLOSE cur_get_external_dis_detail;
7611:
7612:
7613: --jai_ar_trx_tax_lines get tax_line_no base TEMP_REC.customer_trx_line_id and TEMP_REC.link_to_cust_trx_line_id
7614: --jai_interface_tax_lines_all get interface_TAX_line_id base pn_interface_line_id and TEMP_REC.LINE_NUMBER
7615: --JAI-INTERFACE_DIS_LINES_ALL GET CODE_COMBINATION_ID PERCENT AMOUNT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 REQUEST_ID
7616: OPEN SO_AR_HDR_INFO;
7617: FETCH SO_AR_HDR_INFO INTO v_organization_id, v_location_id, v_batch_source_id;
8110: --Added by zhiwei for bug#12564566 end
8111:
8112:
8113: --VARIABLE DEFINITION
8114: ln_sum_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE;
8115: ln_vat_invoice_no JAI_INTERFACE_LINES_ALL.VAT_INVOICE_NO%TYPE;
8116: ln_excise_invoice_no JAI_INTERFACE_LINES_ALL.EXCISE_INVOICE_NO%TYPE;
8117: rec_interface_line get_interface_line_cur%ROWTYPE;
8118:
8182:
8183: ln_phase := 90.2;
8184:
8185: SELECT SUM(TAX_AMOUNT) INTO ln_sum_tax_amount
8186: FROM JAI_AR_TRX_TAX_LINES
8187: WHERE LINK_TO_CUST_TRX_LINE_ID = ln_customer_trx_line_id;
8188:
8189: ln_phase := 90.3;
8190:
8858:
8859: lv_recalculation_sql :=
8860: REPLACE ( lv_recalculation_sql
8861: , '$$TAX_SOURCE_TABLE$$'
8862: , 'JAI_AR_TRX_TAX_LINES'
8863: );
8864: /* replace join condition */
8865: lv_recalculation_sql :=
8866: REPLACE ( lv_recalculation_sql
10220: IF transaction_name = 'AR_LINES' THEN
10221: --Added by zhiwei for Bug#12604133 on 20110628 begin
10222: ------------------------------------------------------
10223: if adhoc_flag_tab(row_count) = 'Y' and vat_flag_tab(row_count) = 'Q' and nvl(reverse_flag_tab(I),0) = 1 then
10224: UPDATE JAI_AR_TRX_TAX_LINES
10225:
10226: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
10227: base_tax_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0), NVL(base_tax_amt_tab(row_count), 0)),
10228: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
10236: else
10237: ------------------------------------------------------
10238: --Added by zhiwei for Bug#12604133 on 20110628 end
10239:
10240: UPDATE JAI_AR_TRX_TAX_LINES
10241: SET tax_amount = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
10242: base_tax_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0), NVL(base_tax_amt_tab(row_count), 0)),
10243: func_tax_amount = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
10244: last_update_date = p_last_update_date,
10616: , :33
10617: , :34
10618: )';
10619: lv_insert_jai_ar_tax_sql :=
10620: 'insert into jai_ar_trx_tax_lines
10621: ( tax_line_no
10622: , customer_trx_line_id
10623: , link_to_cust_trx_line_id
10624: , precedence_1