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_RETRO_PRC_PKG dependencies on JAI_CMN_TAXES_ALL

Line 82: CURSOR get_jai_cmn_taxes_all_cur

78: )
79: RETURN NUMBER
80: IS
81:
82: CURSOR get_jai_cmn_taxes_all_cur
83: IS
84: SELECT
85: mod_cr_percentage
86: , rounding_factor

Line 88: jai_cmn_taxes_all

84: SELECT
85: mod_cr_percentage
86: , rounding_factor
87: FROM
88: jai_cmn_taxes_all
89: WHERE tax_id = pn_tax_id;
90:
91: ln_re_tax_amount NUMBER;
92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

Line 92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

88: jai_cmn_taxes_all
89: WHERE tax_id = pn_tax_id;
90:
91: ln_re_tax_amount NUMBER;
92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
93: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
94: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
95: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 93: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;

89: WHERE tax_id = pn_tax_id;
90:
91: ln_re_tax_amount NUMBER;
92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
93: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
94: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
95: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
97: BEGIN

Line 107: OPEN get_jai_cmn_taxes_all_cur;

103: , 'Enter procedure'
104: );
105: END IF; --l_proc_level>=l_dbg_level
106:
107: OPEN get_jai_cmn_taxes_all_cur;
108: FETCH get_jai_cmn_taxes_all_cur
109: INTO
110: ln_mod_cr_percent
111: , ln_rounding_factor;

Line 108: FETCH get_jai_cmn_taxes_all_cur

104: );
105: END IF; --l_proc_level>=l_dbg_level
106:
107: OPEN get_jai_cmn_taxes_all_cur;
108: FETCH get_jai_cmn_taxes_all_cur
109: INTO
110: ln_mod_cr_percent
111: , ln_rounding_factor;
112: CLOSE get_jai_cmn_taxes_all_cur;

Line 112: CLOSE get_jai_cmn_taxes_all_cur;

108: FETCH get_jai_cmn_taxes_all_cur
109: INTO
110: ln_mod_cr_percent
111: , ln_rounding_factor;
112: CLOSE get_jai_cmn_taxes_all_cur;
113:
114: ln_mod_cr_percent := NVL(ln_mod_cr_percent,0)/100;
115: ln_rounding_factor := NVL(NVL(pn_rounding_factor,ln_rounding_factor),0);
116: ln_re_tax_amount := pn_tax_amount * ln_mod_cr_percent *pn_conver_rate;

Line 195: CURSOR get_jai_cmn_taxes_all_cur

191: )
192: RETURN NUMBER
193: IS
194:
195: CURSOR get_jai_cmn_taxes_all_cur
196: IS
197: SELECT
198: mod_cr_percentage
199: , rounding_factor

Line 201: jai_cmn_taxes_all

197: SELECT
198: mod_cr_percentage
199: , rounding_factor
200: FROM
201: jai_cmn_taxes_all
202: WHERE tax_id = pn_tax_id;
203:
204: ln_nr_tax_amount NUMBER;
205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

Line 205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

201: jai_cmn_taxes_all
202: WHERE tax_id = pn_tax_id;
203:
204: ln_nr_tax_amount NUMBER;
205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
208: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

202: WHERE tax_id = pn_tax_id;
203:
204: ln_nr_tax_amount NUMBER;
205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
208: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
210: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;

203:
204: ln_nr_tax_amount NUMBER;
205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
208: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
210: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
211: BEGIN

Line 221: OPEN get_jai_cmn_taxes_all_cur;

217: , 'Enter procedure'
218: );
219: END IF; --l_proc_level>=l_dbg_level
220:
221: OPEN get_jai_cmn_taxes_all_cur;
222: FETCH get_jai_cmn_taxes_all_cur
223: INTO
224: ln_mod_cr_percent
225: , ln_rounding_factor;

Line 222: FETCH get_jai_cmn_taxes_all_cur

218: );
219: END IF; --l_proc_level>=l_dbg_level
220:
221: OPEN get_jai_cmn_taxes_all_cur;
222: FETCH get_jai_cmn_taxes_all_cur
223: INTO
224: ln_mod_cr_percent
225: , ln_rounding_factor;
226: CLOSE get_jai_cmn_taxes_all_cur;

Line 226: CLOSE get_jai_cmn_taxes_all_cur;

222: FETCH get_jai_cmn_taxes_all_cur
223: INTO
224: ln_mod_cr_percent
225: , ln_rounding_factor;
226: CLOSE get_jai_cmn_taxes_all_cur;
227:
228: ln_nr_mod_cr_percent := (100-NVL(ln_mod_cr_percent,0))/100;
229: ln_rounding_factor := NVL(NVL(pn_rounding_factor,ln_rounding_factor),0);
230: ln_nr_tax_amount := pn_tax_amount * ln_nr_mod_cr_percent *pn_conver_rate;

Line 576: , jai_cmn_taxes_all jtc

572: , nvl(decode(pv_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage
573: , nvl(jtc.rounding_factor, 0) rnd
574: FROM
575: jai_retro_tax_changes jrtc
576: , jai_cmn_taxes_all jtc
577: , jai_retro_line_changes jrlc
578: WHERE jrlc.doc_line_id = pn_shipment_line_id
579: AND jrtc.line_change_id = jrlc.line_change_id
580: AND jrlc.doc_type = 'RECEIPT'

Line 1936: -- Use mod_cr_percentage from jai_cmn_taxes_all

1932: --LOOP through jai_retro_tax_changes where recoverable_flag is 'Y' and tax_type is one of tax types attached to VAT regime
1933: FOR jai_retor_tax_changes_rec IN jai_retro_tax_changes_cur
1934: LOOP
1935: -- calculate the recoverable portion of the difference in modified and original tax_amount
1936: -- Use mod_cr_percentage from jai_cmn_taxes_all
1937: ln_new_re_tax_amt := Get_Recoverable_Amount ( pn_tax_id => jai_retor_tax_changes_rec.tax_id
1938: , pn_tax_amount => jai_retor_tax_changes_rec.modified_tax_amount
1939: );
1940: ln_orig_re_tax_amt := Get_Recoverable_Amount ( pn_tax_id => jai_retor_tax_changes_rec.tax_id

Line 2665: , jai_cmn_taxes_all jcta

2661: jrlt.*,
2662: jcta.adhoc_flag
2663: FROM
2664: jai_rcv_line_taxes jrlt
2665: , jai_cmn_taxes_all jcta
2666: WHERE jrlt.transaction_id = pn_transaction_id
2667: AND jrlt.tax_id = jcta.tax_id;
2668:
2669: CURSOR get_jai_retro_line_change_cur

Line 2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id

2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2994: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2995: , SYSDATE --=> sysdate
2996: , fnd_global.user_id --=> fnd_global.user_id
2997: , SYSDATE --=> sysdate

Line 3355: , jai_cmn_taxes_all jcta

3351: , jpt.modvat_flag
3352: , jpt.vendor_id
3353: FROM
3354: jai_po_taxes jpt
3355: , jai_cmn_taxes_all jcta
3356: WHERE jpt.tax_id = jcta.tax_id
3357: AND jpt.line_location_id = pr_old.line_location_id;
3358:
3359: lv_doc_number po_headers_all.segment1%TYPE;