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.

[Home] [Help]

APPS.JAI_PO_WF_UTIL_PUB dependencies on JAI_PO_REQ_LINE_TAXES

Line 482: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;

478: ln_excl_nr_tax_amount NUMBER :=0;
479: ln_total_tax_amount NUMBER :=0;
480: ln_total_nr_tax_amount NUMBER :=0;
481: ln_currency_rate NUMBER;
482: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
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

Line 483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;

479: ln_total_tax_amount NUMBER :=0;
480: ln_total_nr_tax_amount NUMBER :=0;
481: ln_currency_rate NUMBER;
482: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
483: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
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;

Line 499: JAI_PO_REQ_LINE_TAXES

495: , currency
496: , requisition_line_id
497: , NVL(modvat_flag,'N') --add by Xiao Lv for IL po notification on Mar-25-2009
498: FROM
499: JAI_PO_REQ_LINE_TAXES
500: WHERE REQUISITION_HEADER_ID = pn_document_id
501: AND REQUISITION_LINE_ID = NVL(pn_requisition_line_id, REQUISITION_LINE_ID); --add by Xiao
502:
503:

Line 871: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;

867: ln_new_total_tax_amount NUMBER :=0; --total new tax amount for a req
868: ln_new_total_nr_tax_amount NUMBER :=0; --total new nr tax amount for a req
869:
870: ln_currency_rate NUMBER;
871: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
872: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
873: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
874: lv_adhoc_flag VARCHAR2(1); --add by Xiao Lv for adhoc tax flag.
875: ln_total_adhoc_tax_amount NUMBER :=0;

Line 872: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;

868: ln_new_total_nr_tax_amount NUMBER :=0; --total new nr tax amount for a req
869:
870: ln_currency_rate NUMBER;
871: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
872: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;
873: lv_modvat_flag VARCHAR2(1); --add by Xiao Lv for IL po notification on Mar-25-2009
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;

Line 889: JAI_PO_REQ_LINE_TAXES jprlt

885: , jprlt.currency
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;

Line 1306: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;

1302: ln_excl_nr_tax_amount NUMBER;
1303: ln_total_tax_amount NUMBER :=0;
1304: ln_total_nr_tax_amount NUMBER :=0;
1305: ln_currency_rate NUMBER;
1306: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
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);

Line 1307: lv_req_tax_currency JAI_PO_REQ_LINE_TAXES.currency%TYPE;

1303: ln_total_tax_amount NUMBER :=0;
1304: ln_total_nr_tax_amount NUMBER :=0;
1305: ln_currency_rate NUMBER;
1306: ln_req_line_id JAI_PO_REQ_LINE_TAXES.requisition_line_id%TYPE;
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

Line 1322: JAI_PO_REQ_LINE_TAXES

1318: , currency
1319: , requisition_line_id
1320: , modvat_flag
1321: FROM
1322: JAI_PO_REQ_LINE_TAXES
1323: WHERE REQUISITION_HEADER_ID = pn_document_id
1324: AND requisition_line_id = NVL(pn_line_id, requisition_line_id);
1325:
1326: