[Home] [Help]
1552: cursor c_get_threshold_xcep(
1553: p_vendor_id number,
1554: p_vendor_site_id number,
1555: p_tds_section_code varchar2,
1556: p_section_type jai_ap_tds_inv_taxes.section_type%type
1557: )
1558: IS
1559: select threshold_hdr_id
1560: from JAI_AP_TDS_TH_VSITE_V
1570: cursor c_get_threshold_normal(
1571: p_vendor_id number,
1572: p_vendor_site_id number,
1573: p_tds_section_code varchar2,
1574: p_section_type jai_ap_tds_inv_taxes.section_type%type
1575: )
1576: IS
1577: select threshold_hdr_id
1578: from JAI_AP_TDS_TH_VSITE_V
2442: '. Setup needs modification.' tax_end_dated_message
2443: from JAI_CMN_TAXES_ALL
2444: where tax_id = p_tax_id;
2445: /*Bug 5751783 - Selected non-rounded value for calculation*/
2446: cursor c_for_each_tds_section(p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type, p_prepay_amt number) is--rchandan for bug#4428980 --add by xiao for bug#6596019
2447: select actual_section_code, (sum(amount*p_exchange_rate)-p_prepay_amt) invoice_amount, sum(calc_tax_amount) section_amount,
2448: sum(tax_amount) tax_amount_orig
2449: from jai_ap_tds_inv_taxes
2450: where nvl(consider_amt_for_tds, 'Y') = 'Y' -- Added by mmurtuza for bug12858951
2459: from JAI_AP_TDS_VNDR_TYPE_V
2460: where vendor_id = p_vendor_id;
2461:
2462: cursor c_get_threshold
2463: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
2464: select threshold_hdr_id
2465: from JAI_AP_TDS_TH_VSITE_V
2466: where vendor_id = p_vendor_id
2467: and vendor_site_id = p_vendor_site_id
2473: p_tan_no varchar2,
2474: p_pan_no varchar2,
2475: p_tds_section_code varchar2 ,
2476: p_fin_year number,
2477: p_section_type jai_ap_tds_inv_taxes.section_type%type)
2478: IS --rchandan for bug#4428980
2479: select threshold_grp_id
2480: from jai_ap_tds_thhold_grps
2481: where vendor_id = p_vendor_id
2539: /*Bug 5751783. Selected non-rounded value for calculation*/
2540:
2541: cursor c_get_taxes_to_generate_tds
2542: (p_invoice_id number, p_tds_section_code varchar2, p_generate_all_invoices varchar2,
2543: p_exchange_rate number, p_threshold_slab_id_single number,p_section_type jai_ap_tds_inv_taxes.section_type%type, p_prepay_amt number) IS --rchandan for bug#4428980--add by xiao for bug#6596019
2544: -- select nvl(actual_tax_id,default_tax_id) actual_tax_id, --added nvl by Xiao for Bug#7154864
2545: select tax_category_id ,
2546: ( sum(amount*p_exchange_rate)-p_prepay_amt) taxable_amount, --Xiao for bug#6596019
2547: --sum(calc_tax_amount) tax_amount,--Comment by Zhiwei on 20120111
2649: where set_of_books_id = cp_set_of_books_id;
2650:
2651: /*Bug 5751783. Selected non-rounded value for calculation*/
2652:
2653: cursor c_get_non_tds_section_tax (p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
2654: select section_type,
2655: actual_tax_id,
2656: sum(amount*p_exchange_rate) taxable_amount,
2657: sum(calc_tax_amount) tax_amount,
2664: group by section_type, actual_tax_id;
2665:
2666: --Add by Zhiwei Hou on 20120111 begin
2667: -----------------------------------------------
2668: cursor c_get_non_tds_sec_tax_cat (p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
2669: select section_type,
2670: actual_section_code,
2671: tax_category_id,
2672: sum(amount*p_exchange_rate) taxable_amount,
2879:
2880: cursor c_for_each_tds_section_new(
2881: p_invoice_id number,
2882: p_exchange_rate number,
2883: p_section_type jai_ap_tds_inv_taxes.section_type%type,
2884: p_section_code jai_ap_tds_inv_taxes.actual_section_code%type,
2885: p_prepay_amt number) is
2886: select actual_section_code,
2887: (sum(amount*p_exchange_rate)-p_prepay_amt) invoice_amount,
2943: cursor c_get_threshold_xcep(
2944: p_vendor_id number,
2945: p_vendor_site_id number,
2946: p_tds_section_code varchar2,
2947: p_section_type jai_ap_tds_inv_taxes.section_type%type
2948: )
2949: IS
2950: select threshold_hdr_id
2951: from JAI_AP_TDS_TH_VSITE_V
2971: cursor c_get_threshold_normal(
2972: p_vendor_id number,
2973: p_vendor_site_id number,
2974: p_tds_section_code varchar2,
2975: p_section_type jai_ap_tds_inv_taxes.section_type%type
2976: )
2977: IS
2978: select threshold_hdr_id
2979: from JAI_AP_TDS_TH_VSITE_V
3021: p_tan_no varchar2,
3022: p_pan_no varchar2,
3023: p_tds_section_code varchar2 ,
3024: p_fin_year number,
3025: p_section_type jai_ap_tds_inv_taxes.section_type%type,
3026: p_thhold_hdr_id number
3027: )
3028: IS
3029: select threshold_grp_id
3041: p_tan_no varchar2,
3042: p_pan_no varchar2,
3043: p_tds_section_code varchar2 ,
3044: p_fin_year number,
3045: p_section_type jai_ap_tds_inv_taxes.section_type%type
3046: )
3047: IS
3048: select threshold_grp_id
3049: from jai_ap_tds_thhold_grps
5466: THRESHOLD_TRANSITION
5467: )
5468: VALUES
5469: (
5470: JAI_AP_TDS_INV_TAXES_S.NEXTVAL,
5471: TRAN_TAB(i).INVOICE_ID,
5472: 1,
5473: 1,
5474: 1,
9467: ln_tax_category_id NUMBER;
9468: ln_threshold_trx_id NUMBER;
9469: lv_tds_invoice_num ap_invoices_all.invoice_num%TYPE;
9470: lv_cm_invoice_num ap_invoices_all.invoice_num%TYPE;
9471: lv_section_type JAI_AP_TDS_INV_TAXES.section_type%TYPE;
9472: lv_section_code JAI_AP_TDS_INV_TAXES.actual_section_code%TYPE;
9473: lv_prepay_invoice_num ap_invoices_all.invoice_num%TYPE;
9474: lv_prepay_invoice_id NUMBER;
9475: ln_threshold_grp_audit_id NUMBER;