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.OKL_ARINTF_PVT dependencies on ZX_LINES

Line 1457: CURSOR zx_lines_csr(p_zx_lines_id IN NUMBER)

1453: AND tld.id = p_tld_id;
1454:
1455: tax_sources_rec tax_sources_csr%ROWTYPE;
1456: -- Bug 6619311
1457: CURSOR zx_lines_csr(p_zx_lines_id IN NUMBER)
1458: IS
1459: SELECT HISTORICAL_FLAG,
1460: TAX_REGIME_CODE,
1461: TAX,

Line 1467: FROM ZX_LINES

1463: TAX_RATE_CODE,
1464: TAX_JURISDICTION_CODE,
1465: TAXABLE_AMT,
1466: LEGAL_ENTITY_ID
1467: FROM ZX_LINES
1468: WHERE TAX_LINE_ID = p_zx_lines_id;
1469: zx_lines_rec zx_lines_csr%ROWTYPE;
1470:
1471: tx NUMBER;

Line 1468: WHERE TAX_LINE_ID = p_zx_lines_id;

1464: TAX_JURISDICTION_CODE,
1465: TAXABLE_AMT,
1466: LEGAL_ENTITY_ID
1467: FROM ZX_LINES
1468: WHERE TAX_LINE_ID = p_zx_lines_id;
1469: zx_lines_rec zx_lines_csr%ROWTYPE;
1470:
1471: tx NUMBER;
1472: l_tx NUMBER;

Line 1469: zx_lines_rec zx_lines_csr%ROWTYPE;

1465: TAXABLE_AMT,
1466: LEGAL_ENTITY_ID
1467: FROM ZX_LINES
1468: WHERE TAX_LINE_ID = p_zx_lines_id;
1469: zx_lines_rec zx_lines_csr%ROWTYPE;
1470:
1471: tx NUMBER;
1472: l_tx NUMBER;
1473: --akrangan added ebtax billing impacts coding end

Line 2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);

2189: -- Bug 6619311
2190: inv_lines_tbl(hdr_cnt).SOURCE_TRX_DETAIL_TAX_LINE_ID := tax_sources_rec.tax_line_id;
2191: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
2192: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;

Line 2194: FETCH zx_lines_csr into zx_lines_rec;

2190: inv_lines_tbl(hdr_cnt).SOURCE_TRX_DETAIL_TAX_LINE_ID := tax_sources_rec.tax_line_id;
2191: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
2192: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;

Line 2195: CLOSE zx_lines_csr;

2191: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
2192: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;

Line 2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;

2192: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;

Line 2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;

2193: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;

Line 2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;

2194: FETCH zx_lines_csr into zx_lines_rec;
2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;

Line 2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;

2195: CLOSE zx_lines_csr;
2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;

Line 2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;

2196: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
2204: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;

Line 2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;

2197: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
2204: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
2205: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;

Line 2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;

2198: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
2204: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
2205: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;
2206: inv_lines_tbl(hdr_cnt).PRODUCT_CATEGORY := NULL;

Line 2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;

2199: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
2200: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
2201: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
2202: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
2203: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
2204: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
2205: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;
2206: inv_lines_tbl(hdr_cnt).PRODUCT_CATEGORY := NULL;
2207: inv_lines_tbl(hdr_cnt).PRODUCT_TYPE := NULL;