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 2423: CURSOR zx_lines_csr(p_zx_lines_id IN NUMBER)

2419: AND tld.id = p_tld_id;
2420:
2421: tax_sources_rec tax_sources_csr%ROWTYPE;
2422: -- Bug 6619311
2423: CURSOR zx_lines_csr(p_zx_lines_id IN NUMBER)
2424: IS
2425: SELECT HISTORICAL_FLAG,
2426: TAX_REGIME_CODE,
2427: TAX,

Line 2433: FROM ZX_LINES

2429: TAX_RATE_CODE,
2430: TAX_JURISDICTION_CODE,
2431: TAXABLE_AMT,
2432: LEGAL_ENTITY_ID
2433: FROM ZX_LINES
2434: WHERE TAX_LINE_ID = p_zx_lines_id;
2435: zx_lines_rec zx_lines_csr%ROWTYPE;
2436:
2437: tx NUMBER;

Line 2434: WHERE TAX_LINE_ID = p_zx_lines_id;

2430: TAX_JURISDICTION_CODE,
2431: TAXABLE_AMT,
2432: LEGAL_ENTITY_ID
2433: FROM ZX_LINES
2434: WHERE TAX_LINE_ID = p_zx_lines_id;
2435: zx_lines_rec zx_lines_csr%ROWTYPE;
2436:
2437: tx NUMBER;
2438: l_tx NUMBER;

Line 2435: zx_lines_rec zx_lines_csr%ROWTYPE;

2431: TAXABLE_AMT,
2432: LEGAL_ENTITY_ID
2433: FROM ZX_LINES
2434: WHERE TAX_LINE_ID = p_zx_lines_id;
2435: zx_lines_rec zx_lines_csr%ROWTYPE;
2436:
2437: tx NUMBER;
2438: l_tx NUMBER;
2439: --akrangan added ebtax billing impacts coding end

Line 3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);

3323: -- Bug 6619311
3324: inv_lines_tbl(hdr_cnt).SOURCE_TRX_DETAIL_TAX_LINE_ID := tax_sources_rec.tax_line_id;
3325: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
3326: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;

Line 3328: FETCH zx_lines_csr into zx_lines_rec;

3324: inv_lines_tbl(hdr_cnt).SOURCE_TRX_DETAIL_TAX_LINE_ID := tax_sources_rec.tax_line_id;
3325: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
3326: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;

Line 3329: CLOSE zx_lines_csr;

3325: inv_lines_tbl(hdr_cnt).TAXED_UPSTREAM_FLAG := 'Y';
3326: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;

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

3326: inv_lines_tbl(hdr_cnt).TAXABLE_FLAG := 'N';
3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;

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

3327: OPEN zx_lines_csr(tax_sources_rec.tax_line_id);
3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;

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

3328: FETCH zx_lines_csr into zx_lines_rec;
3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;

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

3329: CLOSE zx_lines_csr;
3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
3337: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;

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

3330: inv_lines_tbl(hdr_cnt).HISTORICAL_FLAG := zx_lines_rec.HISTORICAL_FLAG;
3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
3337: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
3338: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;

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

3331: inv_lines_tbl(hdr_cnt).TAX_REGIME_CODE := zx_lines_rec.TAX_REGIME_CODE;
3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
3337: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
3338: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
3339: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;

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

3332: inv_lines_tbl(hdr_cnt).TAX := zx_lines_rec.TAX;
3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
3337: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
3338: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
3339: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;
3340: inv_lines_tbl(hdr_cnt).PRODUCT_CATEGORY := NULL;

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

3333: inv_lines_tbl(hdr_cnt).TAX_STATUS_CODE := zx_lines_rec.TAX_STATUS_CODE;
3334: inv_lines_tbl(hdr_cnt).TAX_RATE_CODE := zx_lines_rec.TAX_RATE_CODE;
3335: inv_lines_tbl(hdr_cnt).TAX_JURISDICTION_CODE := zx_lines_rec.TAX_JURISDICTION_CODE;
3336: inv_lines_tbl(hdr_cnt).TAXABLE_AMOUNT := zx_lines_rec.TAXABLE_AMT;
3337: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := zx_lines_rec.LEGAL_ENTITY_ID;
3338: /*inv_lines_tbl(hdr_cnt).TRX_BUSINESS_CATEGORY := NULL;
3339: inv_lines_tbl(hdr_cnt).TAX_CODE := NULL;
3340: inv_lines_tbl(hdr_cnt).PRODUCT_CATEGORY := NULL;
3341: inv_lines_tbl(hdr_cnt).PRODUCT_TYPE := NULL;