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 77: CURSOR get_jai_cmn_taxes_all_cur

73: )
74: RETURN NUMBER
75: IS
76:
77: CURSOR get_jai_cmn_taxes_all_cur
78: IS
79: SELECT
80: mod_cr_percentage
81: , rounding_factor

Line 83: jai_cmn_taxes_all

79: SELECT
80: mod_cr_percentage
81: , rounding_factor
82: FROM
83: jai_cmn_taxes_all
84: WHERE tax_id = pn_tax_id;
85:
86: ln_re_tax_amount NUMBER;
87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

Line 87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

83: jai_cmn_taxes_all
84: WHERE tax_id = pn_tax_id;
85:
86: ln_re_tax_amount NUMBER;
87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
88: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
89: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
90: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
91: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 88: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;

84: WHERE tax_id = pn_tax_id;
85:
86: ln_re_tax_amount NUMBER;
87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
88: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
89: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
90: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
91: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
92: BEGIN

Line 102: OPEN get_jai_cmn_taxes_all_cur;

98: , 'Enter procedure'
99: );
100: END IF; --l_proc_level>=l_dbg_level
101:
102: OPEN get_jai_cmn_taxes_all_cur;
103: FETCH get_jai_cmn_taxes_all_cur
104: INTO
105: ln_mod_cr_percent
106: , ln_rounding_factor;

Line 103: FETCH get_jai_cmn_taxes_all_cur

99: );
100: END IF; --l_proc_level>=l_dbg_level
101:
102: OPEN get_jai_cmn_taxes_all_cur;
103: FETCH get_jai_cmn_taxes_all_cur
104: INTO
105: ln_mod_cr_percent
106: , ln_rounding_factor;
107: CLOSE get_jai_cmn_taxes_all_cur;

Line 107: CLOSE get_jai_cmn_taxes_all_cur;

103: FETCH get_jai_cmn_taxes_all_cur
104: INTO
105: ln_mod_cr_percent
106: , ln_rounding_factor;
107: CLOSE get_jai_cmn_taxes_all_cur;
108:
109: ln_mod_cr_percent := NVL(ln_mod_cr_percent,0)/100;
110: ln_rounding_factor := NVL(NVL(pn_rounding_factor,ln_rounding_factor),0);
111: ln_re_tax_amount := pn_tax_amount * ln_mod_cr_percent *pn_conver_rate;

Line 190: CURSOR get_jai_cmn_taxes_all_cur

186: )
187: RETURN NUMBER
188: IS
189:
190: CURSOR get_jai_cmn_taxes_all_cur
191: IS
192: SELECT
193: mod_cr_percentage
194: , rounding_factor

Line 196: jai_cmn_taxes_all

192: SELECT
193: mod_cr_percentage
194: , rounding_factor
195: FROM
196: jai_cmn_taxes_all
197: WHERE tax_id = pn_tax_id;
198:
199: ln_nr_tax_amount NUMBER;
200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

Line 200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

196: jai_cmn_taxes_all
197: WHERE tax_id = pn_tax_id;
198:
199: ln_nr_tax_amount NUMBER;
200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
203: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

197: WHERE tax_id = pn_tax_id;
198:
199: ln_nr_tax_amount NUMBER;
200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
203: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
205: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;

198:
199: ln_nr_tax_amount NUMBER;
200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
203: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
205: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
206: BEGIN

Line 216: OPEN get_jai_cmn_taxes_all_cur;

212: , 'Enter procedure'
213: );
214: END IF; --l_proc_level>=l_dbg_level
215:
216: OPEN get_jai_cmn_taxes_all_cur;
217: FETCH get_jai_cmn_taxes_all_cur
218: INTO
219: ln_mod_cr_percent
220: , ln_rounding_factor;

Line 217: FETCH get_jai_cmn_taxes_all_cur

213: );
214: END IF; --l_proc_level>=l_dbg_level
215:
216: OPEN get_jai_cmn_taxes_all_cur;
217: FETCH get_jai_cmn_taxes_all_cur
218: INTO
219: ln_mod_cr_percent
220: , ln_rounding_factor;
221: CLOSE get_jai_cmn_taxes_all_cur;

Line 221: CLOSE get_jai_cmn_taxes_all_cur;

217: FETCH get_jai_cmn_taxes_all_cur
218: INTO
219: ln_mod_cr_percent
220: , ln_rounding_factor;
221: CLOSE get_jai_cmn_taxes_all_cur;
222:
223: ln_nr_mod_cr_percent := (100-NVL(ln_mod_cr_percent,0))/100;
224: ln_rounding_factor := NVL(NVL(pn_rounding_factor,ln_rounding_factor),0);
225: ln_nr_tax_amount := pn_tax_amount * ln_nr_mod_cr_percent *pn_conver_rate;

Line 571: , jai_cmn_taxes_all jtc

567: , nvl(decode(pv_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage
568: , nvl(jtc.rounding_factor, 0) rnd
569: FROM
570: jai_retro_tax_changes jrtc
571: , jai_cmn_taxes_all jtc
572: , jai_retro_line_changes jrlc
573: WHERE jrlc.doc_line_id = pn_shipment_line_id
574: AND jrtc.line_change_id = jrlc.line_change_id
575: AND jrlc.doc_type = 'RECEIPT'

Line 1931: -- Use mod_cr_percentage from jai_cmn_taxes_all

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

Line 2652: , jai_cmn_taxes_all jcta

2648: jrlt.*,
2649: jcta.adhoc_flag
2650: FROM
2651: jai_rcv_line_taxes jrlt
2652: , jai_cmn_taxes_all jcta
2653: WHERE jrlt.transaction_id = pn_transaction_id
2654: AND jrlt.tax_id = jcta.tax_id;
2655:
2656: CURSOR get_jai_retro_line_change_cur

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

2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2982: , SYSDATE --=> sysdate
2983: , fnd_global.user_id --=> fnd_global.user_id
2984: , SYSDATE --=> sysdate

Line 3310: , jai_cmn_taxes_all jcta

3306: , jpt.modvat_flag
3307: , jpt.vendor_id
3308: FROM
3309: jai_po_taxes jpt
3310: , jai_cmn_taxes_all jcta
3311: WHERE jpt.tax_id = jcta.tax_id
3312: AND jpt.line_location_id = pr_old.line_location_id;
3313:
3314: lv_doc_number po_headers_all.segment1%TYPE;