eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AP_TDS_THHOLD_TAXES

Line 144: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;

140:
141: ln_reg_id number;
142: lr_dtl_record jai_rgm_threshold_dtls%rowtype;
143: ln_threshold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
144: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
145:
146: ln_surcharge_doc_amt number;
147: ln_surcharge_doc_cess_amt number;
148: ln_surcharge_line_no number;

Line 241: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type

237:
238: /*-------------------------------BEGIN LOCAL METHOD CALCULATE_TCS_DOC_AMOUNT -----------------------------*/
239:
240: procedure calculate_tcs_doc_amount
241: ( p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
242: , p_tcs_amt in number
243: , p_manual_surcharge_amt in jai_rgm_threshold_dtls.manual_surcharge_amt%type
244: , p_system_surcharge_amt in jai_rgm_threshold_dtls.system_surcharge_amt%type
245: , p_system_surcharge_cess_amt in jai_rgm_threshold_dtls.system_surcharge_cess_amt%type

Line 789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null

785: , p_organization_id in hr_organization_units.organization_id%type default null
786: , p_party_type in jai_rgm_thresholds.party_type%type
787: , p_party_id in jai_rgm_thresholds.party_id%type
788: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
789: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
790: , p_source_trx_date in date default null
791: , p_called_from in varchar2 default null
792: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
793: , p_process_flag out nocopy varchar2

Line 1068: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type

1064: /*------------------------------------------------------------------------------------------------------------*/
1065: procedure get_threshold_tax_cat_id
1066: (
1067: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
1068: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
1069: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
1070: , p_process_flag out nocopy varchar2
1071: , p_process_message out nocopy varchar2
1072: )

Line 1069: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type

1065: procedure get_threshold_tax_cat_id
1066: (
1067: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
1068: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
1069: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
1070: , p_process_flag out nocopy varchar2
1071: , p_process_message out nocopy varchar2
1072: )
1073: is

Line 1081: jai_ap_tds_thhold_taxes thtaxes

1077: is
1078: select
1079: thtaxes.tax_category_id
1080: from
1081: jai_ap_tds_thhold_taxes thtaxes
1082: where
1083: thtaxes.threshold_slab_id = p_threshold_slab_id
1084: and operating_unit_id = p_org_id;
1085:

Line 1155: , p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type

1151: p_source_trx_id in number
1152: , p_source_trx_line_id in number
1153: , p_source_event in varchar2
1154: , p_action in varchar2
1155: , p_threshold_tax_cat_id in jai_ap_tds_thhold_taxes.tax_category_id%type
1156: , p_tax_base_line_number in number default 0
1157: , p_last_line_number in number default 0
1158: , p_currency_code in varchar2 default null
1159: , p_currency_conv_rate in number default null

Line 1549: cursor c_get_surcharge_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)

1545: || looking at tax_type and precedence_1 (which should be line number of TCS_SURCHARGE type of tax ). Functionally, SURCHARGE_CESS should depende
1546: || upon SURCHARGE type of tax
1547: */
1548:
1549: cursor c_get_surcharge_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1550: is
1551: select sum(rtax.func_tax_amt)
1552: from jai_rgm_taxes rtax
1553: , jai_rgm_refs_all refs

Line 1569: cursor c_get_surcharge_sh_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)

1565: and refs.transaction_id = p_transaction_id;
1566:
1567: -- start Bgowrava for forward porting bug#5989740
1568:
1569: cursor c_get_surcharge_sh_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1570: is
1571: select sum(rtax.func_tax_amt)
1572: from jai_rgm_taxes rtax
1573: , jai_rgm_refs_all refs

Line 1607: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;

1603: ln_surcharge_cess_amt number;
1604: ln_surcharge_sh_cess_amt number; --Bgowrava for forward porting bug#5989740
1605: lv_thhold_slab_change_flag varchar2(2);
1606: ln_new_thhold_slab_id jai_rgm_thresholds.threshold_slab_id%type;
1607: ln_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1608:
1609:
1610: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
1611: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;