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

Line 342: CURSOR get_jai_cmn_taxes_all_cur

338: , xv_tax_type OUT NOCOPY VARCHAR2 -- added by Eric Ma for bug10426971 on 28-Dec-2010
339: )
340: IS
341:
342: CURSOR get_jai_cmn_taxes_all_cur
343: IS
344: SELECT
345: NVL(inclusive_tax_flag,'N')
346: , NVL(mod_cr_percentage,0)

Line 350: jai_cmn_taxes_all

346: , NVL(mod_cr_percentage,0)
347: , NVL(rounding_factor,0)
348: , tax_type
349: FROM
350: jai_cmn_taxes_all
351: WHERE tax_id = pn_tax_id;
352:
353:
354: ln_nr_tax_amount NUMBER;

Line 355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;

351: WHERE tax_id = pn_tax_id;
352:
353:
354: ln_nr_tax_amount NUMBER;
355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;
356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

Line 356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

352:
353:
354: ln_nr_tax_amount NUMBER;
355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;
356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:

Line 357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;

353:
354: ln_nr_tax_amount NUMBER;
355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;
356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:
361: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Info';

Line 358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;

354: ln_nr_tax_amount NUMBER;
355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;
356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:
361: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Info';
362: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

355: lv_incl_tax_flag jai_cmn_taxes_all.inclusive_tax_flag%TYPE;
356: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
357: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:
361: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Info';
362: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
363: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 374: OPEN get_jai_cmn_taxes_all_cur;

370: , 'Enter procedure'
371: );
372: END IF; --l_proc_level>=l_dbg_level
373:
374: OPEN get_jai_cmn_taxes_all_cur;
375: FETCH get_jai_cmn_taxes_all_cur
376: INTO
377: lv_incl_tax_flag
378: , ln_mod_cr_percent

Line 375: FETCH get_jai_cmn_taxes_all_cur

371: );
372: END IF; --l_proc_level>=l_dbg_level
373:
374: OPEN get_jai_cmn_taxes_all_cur;
375: FETCH get_jai_cmn_taxes_all_cur
376: INTO
377: lv_incl_tax_flag
378: , ln_mod_cr_percent
379: , ln_rounding_factor

Line 381: CLOSE get_jai_cmn_taxes_all_cur;

377: lv_incl_tax_flag
378: , ln_mod_cr_percent
379: , ln_rounding_factor
380: , lv_tax_type;
381: CLOSE get_jai_cmn_taxes_all_cur;
382:
383: --dbms_output.put_line ( '-------Get_Tax_Amount_Info-------');
384: --dbms_output.put_line ( 'lv_incl_tax_flag ='||lv_incl_tax_flag);
385: --dbms_output.put_line ( 'ln_mod_cr_percent ='||ln_mod_cr_percent);

Line 488: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

484: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
485: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
486: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
487: ln_po_header_id PO_RELEASES_ALL.PO_HEADER_ID%TYPE;
488: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
489:
490: CURSOR Get_Req_tax_Cur
491: IS
492: SELECT

Line 878: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

874: lv_adhoc_flag VARCHAR2(1); --add by Xiao Lv for adhoc tax flag.
875: ln_total_adhoc_tax_amount NUMBER :=0;
876: ln_old_quantity NUMBER;
877: ln_new_quantity NUMBER;
878: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
879:
880: CURSOR Get_Req_tax_Cur
881: IS
882: SELECT

Line 890: , JAI_CMN_TAXES_ALL jcta

886: , NVL(jprlt.modvat_flag,'N')
887: , NVL(jcta.adhoc_flag, 'N')
888: FROM
889: JAI_PO_REQ_LINE_TAXES jprlt
890: , JAI_CMN_TAXES_ALL jcta
891: WHERE jcta.tax_id = jprlt.tax_id
892: AND jprlt.requisition_line_id = ln_req_line_id
893: AND jprlt.REQUISITION_HEADER_ID = pn_document_id;
894:

Line 1311: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010

1307: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
1308: lv_po_tax_currency JAI_PO_TAXES.currency%TYPE;
1309: lv_rel_tax_currency JAI_PO_TAXES.currency%TYPE;
1310: lv_modvat_flag VARCHAR2(1);
1311: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
1312:
1313: CURSOR Get_Req_tax_Cur
1314: IS
1315: SELECT