[Home] [Help]
51:
52: ln_reg_id number;
53: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
54: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
55: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
56:
57: ln_surcharge_doc_amt number;
58: ln_surcharge_doc_cess_amt number;
59: ln_surcharge_line_no number;
148:
149: /*-------------------------------BEGIN LOCAL METHOD CALCULATE_TCS_DOC_AMOUNT -----------------------------*/
150:
151: procedure calculate_tcs_doc_amount
152: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
153: , p_tcs_amt in number
154: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
155: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
156: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type
699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
700: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
701: , p_source_trx_date in date default null
702: , p_called_from in varchar2 default null
703: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
704: , p_process_flag out nocopy varchar2
969: /*------------------------------------------------------------------------------------------------------------*/
970: procedure get_threshold_tax_cat_id
971: (
972: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
973: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
974: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
975: , p_process_flag out nocopy varchar2
976: , p_process_message out nocopy varchar2
977: )
970: procedure get_threshold_tax_cat_id
971: (
972: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
973: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
974: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
975: , p_process_flag out nocopy varchar2
976: , p_process_message out nocopy varchar2
977: )
978: is
982: is
983: select
984: thtaxes.tax_category_id
985: from
986: jai_ap_tds_thhold_taxes thtaxes
987: where
988: thtaxes.threshold_slab_id = p_threshold_slab_id
989: and operating_unit_id = p_org_id;
990:
1056: p_source_trx_id in number
1057: , p_source_trx_line_id in number
1058: , p_source_event in varchar2
1059: , p_action in varchar2
1060: , p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
1061: , p_tax_base_line_number in number default 0
1062: , p_last_line_number in number default 0
1063: , p_currency_code in varchar2 default null
1064: , p_currency_conv_rate in number default null
1446: || looking at tax_type and precedence_1 (which should be line number of TCS_SURCHARGE type of tax ). Functionally, SURCHARGE_CESS should depende
1447: || upon SURCHARGE type of tax
1448: */
1449:
1450: cursor c_get_surcharge_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1451: is
1452: select sum(rtax.func_tax_amt)
1453: from jai_rgm_taxes rtax
1454: , jai_rgm_refs_all refs
1466: and refs.transaction_id = p_transaction_id;
1467:
1468: -- start Bgowrava for forward porting bug#5989740
1469:
1470: cursor c_get_surcharge_sh_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1471: is
1472: select sum(rtax.func_tax_amt)
1473: from jai_rgm_taxes rtax
1474: , jai_rgm_refs_all refs
1504: ln_surcharge_cess_amt number;
1505: ln_surcharge_sh_cess_amt number; --Bgowrava for forward porting bug#5989740
1506: lv_thhold_slab_change_flag varchar2(2);
1507: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
1508: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1509:
1510:
1511: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1512: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;