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_RGM_TAXES

Line 150: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;

146: ln_surcharge_doc_amt number;
147: ln_surcharge_doc_cess_amt number;
148: ln_surcharge_line_no number;
149: ln_surcharge_cess_line_no number;
150: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
151: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
154:

Line 151: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;

147: ln_surcharge_doc_cess_amt number;
148: ln_surcharge_line_no number;
149: ln_surcharge_cess_line_no number;
150: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
151: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
154:
155: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;

Line 152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;

148: ln_surcharge_line_no number;
149: ln_surcharge_cess_line_no number;
150: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
151: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
154:
155: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
156: ln_currency_code jai_rgm_taxes.currency_code%type;

Line 153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;

149: ln_surcharge_cess_line_no number;
150: ln_surcharge_tax_id jai_rgm_taxes.tax_id%type;
151: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
154:
155: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
156: ln_currency_code jai_rgm_taxes.currency_code%type;
157:

Line 156: ln_currency_code jai_rgm_taxes.currency_code%type;

152: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
153: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
154:
155: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
156: ln_currency_code jai_rgm_taxes.currency_code%type;
157:
158: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
159: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
160:

Line 162: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;

158: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
159: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
160:
161: -- start, Bgowrava for Forward porting Bug#5989740
162: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;
163: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;
164: ln_surcharge_sh_cess_line_no number;
165: ln_surcharge_doc_sh_cess_amt number;
166: -- end Bgowrava for Forward porting Bug#5989740

Line 163: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;

159: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;
160:
161: -- start, Bgowrava for Forward porting Bug#5989740
162: ln_surcharge_sh_cess_tax_id jai_rgm_taxes.tax_id%type;
163: ln_surcharge_sh_cess_tax_rate jai_rgm_taxes.tax_rate%type;
164: ln_surcharge_sh_cess_line_no number;
165: ln_surcharge_doc_sh_cess_amt number;
166: -- end Bgowrava for Forward porting Bug#5989740
167:

Line 212: from jai_rgm_taxes

208: is
209: select tax_id
210: ,tax_type
211: ,tax_rate
212: from jai_rgm_taxes
213: where trx_ref_id = ( select max(trx_ref_id)
214: from jai_rgm_refs_all
215: where source_document_id = jai_constants.tcs_surcharge_id
216: and org_tan_no = cp_org_tan_no

Line 1521: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)

1517: from JAI_CMN_CUS_ADDRESSES
1518: where customer_id = cp_customer_id
1519: and confirm_pan = jai_constants.yes;
1520:
1521: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)
1522: is
1523: select sum(rtax.func_tax_amt)
1524: from jai_rgm_taxes rtax
1525: , jai_rgm_refs_all refs

Line 1524: from jai_rgm_taxes rtax

1520:
1521: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)
1522: is
1523: select sum(rtax.func_tax_amt)
1524: from jai_rgm_taxes rtax
1525: , jai_rgm_refs_all refs
1526: where rtax.trx_ref_id = refs.trx_ref_id
1527: and refs.transaction_id = p_transaction_id
1528: and rtax.tax_type = cp_base_tax_type;

Line 1535: from jai_rgm_taxes rtax

1531: ,cp_tax_modified_by varchar2
1532: )
1533: is
1534: select sum(rtax.func_tax_amt)
1535: from jai_rgm_taxes rtax
1536: , jai_rgm_refs_all refs
1537: where rtax.trx_ref_id = refs.trx_ref_id
1538: and rtax.tax_type = cp_tax_type
1539: and refs.transaction_id = p_transaction_id

Line 1552: from jai_rgm_taxes rtax

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
1554: , JAI_CMN_TAX_CTG_LINES srch
1555: , JAI_CMN_TAX_CTG_LINES srchcess
1556: , JAI_CMN_TAXES_ALL tax

Line 1572: from jai_rgm_taxes rtax

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
1574: , JAI_CMN_TAX_CTG_LINES srch
1575: , JAI_CMN_TAX_CTG_LINES srchcess
1576: , JAI_CMN_TAXES_ALL tax