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.ZX_TDS_CALC_SERVICES_PUB_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 1506: -- table zx_detail_tax_lines_gt

1502: END IF; -- ctrl_total_line_tx_amt IS NOT NULL
1503:
1504: -- If the number of tax lines in g_detail_tax_lines_tbl is greater than,
1505: -- or equals to 1000, dump the detail tax lines to the global temporary
1506: -- table zx_detail_tax_lines_gt
1507: --
1508: IF ( g_detail_tax_lines_tbl.LAST >= 1000) THEN
1509:
1510: dump_detail_tax_lines_into_gt (x_return_status);

Line 1981: -- zx_detail_tax_lines_gt

1977: RETURN;
1978: END IF;
1979:
1980: -- dump detail tax lines created from summary tax lines into
1981: -- zx_detail_tax_lines_gt
1982: --
1983: dump_detail_tax_lines_into_gt (x_return_status);
1984:
1985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2419: p_detail_tax_lines_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

2415: | Bug fix 3423300 |
2416: * =====================================================================*/
2417:
2418: PROCEDURE set_detail_tax_line_def_val (
2419: p_detail_tax_lines_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
2420: x_return_status OUT NOCOPY VARCHAR2
2421: ) IS
2422: BEGIN
2423: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2490: | tax lines into the global temporary table zx_detail_tax_lines_gt |

2486: END set_detail_tax_line_def_val;
2487:
2488: /* ======================================================================*
2489: | Procedure dump_detail_tax_lines_into_gt is called to insert detail |
2490: | tax lines into the global temporary table zx_detail_tax_lines_gt |
2491: | when the number of tax lines in the g_detail_tax_line_tbl |
2492: | reaches 1000 |
2493: * =====================================================================*/
2494:

Line 2534: INSERT INTO zx_detail_tax_lines_gt

2530:
2531: FORALL tax_line_index IN p_detail_tax_lines_tbl.FIRST ..
2532: p_detail_tax_lines_tbl.LAST
2533:
2534: INSERT INTO zx_detail_tax_lines_gt
2535: VALUES p_detail_tax_lines_tbl(tax_line_index);
2536:
2537: -- Flush g_detail_tax_lines_tbl
2538: --p_detail_tax_lines_tbl.DELETE;

Line 2565: | tax lines into the global temporary table zx_detail_tax_lines_gt |

2561: END dump_detail_tax_lines_into_gt;
2562:
2563: /* ======================================================================*
2564: | Procedure dump_detail_tax_lines_into_gt is called to insert detail |
2565: | tax lines into the global temporary table zx_detail_tax_lines_gt |
2566: * =====================================================================*/
2567:
2568: PROCEDURE dump_detail_tax_lines_into_gt (
2569: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2696: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) / *

2692: PROCEDURE fetch_detail_tax_lines (
2693: x_return_status OUT NOCOPY VARCHAR2) IS
2694:
2695: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2696: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2697: FROM zx_detail_tax_lines_gt
2698: WHERE trx_id =
2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2700: AND application_id =

Line 2697: FROM zx_detail_tax_lines_gt

2693: x_return_status OUT NOCOPY VARCHAR2) IS
2694:
2695: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2696: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2697: FROM zx_detail_tax_lines_gt
2698: WHERE trx_id =
2699: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2700: AND application_id =
2701: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)

Line 2760: SELECT /+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) /

2756: -- p_event_class_rec IN zx_api_pub.event_class_rec_type,
2757: x_return_status OUT NOCOPY VARCHAR2) IS
2758:
2759: CURSOR get_total_line_tax_amt_csr IS
2760: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2761: SUM(tax_line.unrounded_tax_amt),
2762: tax_line.application_id,
2763: tax_line.event_class_code,
2764: tax_line.entity_code,

Line 2769: FROM zx_detail_tax_lines_gt tax_line

2765: tax_line.trx_id,
2766: tax_line.trx_line_id,
2767: tax_line.trx_level_type,
2768: tax_line.ctrl_total_line_tx_amt
2769: FROM zx_detail_tax_lines_gt tax_line
2770: WHERE
2771: -- commented out for bug fix 5417887
2772: -- tax_line.application_id = p_event_class_rec.application_id
2773: -- AND tax_line.event_class_code = p_event_class_rec.event_class_code

Line 2791: SELECT /+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) /

2787: tax_line.trx_level_type,
2788: tax_line.ctrl_total_line_tx_amt;
2789:
2790: CURSOR get_mismatch_tax_lines_csr IS
2791: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2792: SUM(tax_line.unrounded_tax_amt)
2793: FROM zx_detail_tax_lines_gt tax_line
2794: WHERE tax_line.ctrl_total_line_tx_amt <> 0
2795: AND tax_line.self_assessed_flag <> 'Y'

Line 2793: FROM zx_detail_tax_lines_gt tax_line

2789:
2790: CURSOR get_mismatch_tax_lines_csr IS
2791: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2792: SUM(tax_line.unrounded_tax_amt)
2793: FROM zx_detail_tax_lines_gt tax_line
2794: WHERE tax_line.ctrl_total_line_tx_amt <> 0
2795: AND tax_line.self_assessed_flag <> 'Y'
2796: AND tax_line.offset_flag <> 'Y'
2797: AND tax_line.offset_link_to_tax_line_id IS NULL

Line 2898: UPDATE /+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) /

2894: -- 3. for now set the original tax_amt, taxable_amt to the unrounded tax_amt
2895: -- and taxable_amount since rounded amounts are not available yet. This
2896: -- logic may need to change based on later Reporting requirements.
2897:
2898: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
2899: zx_detail_tax_lines_gt line
2900: SET line.orig_tax_amt = line.unrounded_tax_amt,
2901: line.orig_taxable_amt = line.unrounded_taxable_amt,
2902: line.orig_tax_rate = line.tax_rate,

Line 2899: zx_detail_tax_lines_gt line

2895: -- and taxable_amount since rounded amounts are not available yet. This
2896: -- logic may need to change based on later Reporting requirements.
2897:
2898: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
2899: zx_detail_tax_lines_gt line
2900: SET line.orig_tax_amt = line.unrounded_tax_amt,
2901: line.orig_taxable_amt = line.unrounded_taxable_amt,
2902: line.orig_tax_rate = line.tax_rate,
2903: line.tax_amt = NULL,

Line 2993: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

2989: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
2990: x_return_status OUT NOCOPY VARCHAR2) IS
2991:
2992: CURSOR get_total_trx_tax_amt_csr IS
2993: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
2994: SUM(tax_line.unrounded_tax_amt),
2995: tax_line.application_id,
2996: tax_line.event_class_code,
2997: tax_line.entity_code,

Line 3000: FROM zx_detail_tax_lines_gt tax_line,

2996: tax_line.event_class_code,
2997: tax_line.entity_code,
2998: tax_line.trx_id,
2999: trx_line.ctrl_total_hdr_tx_amt
3000: FROM zx_detail_tax_lines_gt tax_line,
3001: zx_lines_det_factors trx_line
3002: WHERE tax_line.application_id = trx_line.application_id
3003: AND tax_line.event_class_code = trx_line.event_class_code
3004: AND tax_line.entity_code = trx_line.entity_code

Line 3022: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3018: trx_line.ctrl_total_hdr_tx_amt;
3019:
3020:
3021: CURSOR get_mismatch_tax_lines_csr IS
3022: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3023: SUM(tax_line.unrounded_tax_amt)
3024: FROM zx_detail_tax_lines_gt tax_line,
3025: zx_lines_det_factors trx_line
3026: WHERE tax_line.application_id = trx_line.application_id

Line 3024: FROM zx_detail_tax_lines_gt tax_line,

3020:
3021: CURSOR get_mismatch_tax_lines_csr IS
3022: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3023: SUM(tax_line.unrounded_tax_amt)
3024: FROM zx_detail_tax_lines_gt tax_line,
3025: zx_lines_det_factors trx_line
3026: WHERE tax_line.application_id = trx_line.application_id
3027: AND tax_line.event_class_code = trx_line.event_class_code
3028: AND tax_line.entity_code = trx_line.entity_code

Line 3117: UPDATE /+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) /

3113: -- 2. for now set the original tax_amt, taxable_amt to the unrounded tax_amt
3114: -- and taxable_amount since rounded amounts are not available yet. This
3115: -- logic may need to change based on later Reporting requirements.
3116: --
3117: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3118: zx_detail_tax_lines_gt line
3119: SET line.orig_tax_amt = line.unrounded_tax_amt,
3120: line.orig_taxable_amt = line.unrounded_taxable_amt,
3121: line.orig_tax_rate = line.tax_rate,

Line 3118: zx_detail_tax_lines_gt line

3114: -- and taxable_amount since rounded amounts are not available yet. This
3115: -- logic may need to change based on later Reporting requirements.
3116: --
3117: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3118: zx_detail_tax_lines_gt line
3119: SET line.orig_tax_amt = line.unrounded_tax_amt,
3120: line.orig_taxable_amt = line.unrounded_taxable_amt,
3121: line.orig_tax_rate = line.tax_rate,
3122: line.tax_amt = NULL,

Line 3220: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3216: ---p_event_class_rec IN zx_api_pub.event_class_rec_type,
3217: x_return_status OUT NOCOPY VARCHAR2) IS
3218:
3219: CURSOR get_total_line_tax_amt_csr IS
3220: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3221: SUM(tax_amt),
3222: MAX(tax_amt),
3223: application_id,
3224: event_class_code,

Line 3230: FROM zx_detail_tax_lines_gt

3226: trx_id,
3227: trx_line_id,
3228: trx_level_type,
3229: ctrl_total_line_tx_amt
3230: FROM zx_detail_tax_lines_gt
3231: WHERE
3232: -- commented out for bug fix 5417887
3233: -- trx_id = p_event_class_rec.trx_id
3234: -- AND application_id = p_event_class_rec.application_id

Line 3306: UPDATE /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3302: FORALL i IN l_trx_line_id_tbl.FIRST ..l_trx_line_id_tbl.LAST
3303:
3304: -- adjust tax amount of the detail tax line with the maximum tax amount.
3305: --
3306: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3307: zx_detail_tax_lines_gt
3308: SET tax_amt = tax_amt + l_ctrl_total_line_tx_amt_tbl(i) - l_total_line_tx_amt_tbl(i)
3309: --sync_with_prvdr_flag = DECODE(tax_provider_id, NULL, 'N', 'Y') -- this should have already been set during proration
3310: WHERE application_id = l_application_id_tbl(i)

Line 3307: zx_detail_tax_lines_gt

3303:
3304: -- adjust tax amount of the detail tax line with the maximum tax amount.
3305: --
3306: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3307: zx_detail_tax_lines_gt
3308: SET tax_amt = tax_amt + l_ctrl_total_line_tx_amt_tbl(i) - l_total_line_tx_amt_tbl(i)
3309: --sync_with_prvdr_flag = DECODE(tax_provider_id, NULL, 'N', 'Y') -- this should have already been set during proration
3310: WHERE application_id = l_application_id_tbl(i)
3311: AND event_class_code = l_event_class_code_tbl(i)

Line 3361: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3357: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3358: x_return_status OUT NOCOPY VARCHAR2) IS
3359:
3360: CURSOR get_total_trx_tax_amt_csr IS
3361: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3362: SUM(tax_line.tax_amt),
3363: MAX(tax_line.tax_amt),
3364: tax_line.application_id,
3365: tax_line.event_class_code,

Line 3369: FROM zx_detail_tax_lines_gt tax_line,

3365: tax_line.event_class_code,
3366: tax_line.entity_code,
3367: tax_line.trx_id,
3368: trx_line.ctrl_total_hdr_tx_amt
3369: FROM zx_detail_tax_lines_gt tax_line,
3370: zx_lines_det_factors trx_line
3371: WHERE tax_line.application_id = trx_line.application_id
3372: AND tax_line.event_class_code = trx_line.event_class_code
3373: AND tax_line.entity_code = trx_line.entity_code

Line 3426: UPDATE /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3422:
3423: -- adjust tax amount of the detail tax line with the maximum tax amount.
3424: --
3425: FORALL i IN l_trx_id_tbl.FIRST ..l_trx_id_tbl.LAST
3426: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3427: zx_detail_tax_lines_gt
3428: SET tax_amt = tax_amt + l_ctrl_total_hdr_tx_amt_tbl(i) - l_total_trx_tax_amt_tbl(i)
3429: --sync_with_prvdr_flag = DECODE(tax_provider_id, NULL, 'N', 'Y') -- this should have already been set during process proration
3430: WHERE application_id = l_application_id_tbl(i)

Line 3427: zx_detail_tax_lines_gt

3423: -- adjust tax amount of the detail tax line with the maximum tax amount.
3424: --
3425: FORALL i IN l_trx_id_tbl.FIRST ..l_trx_id_tbl.LAST
3426: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3427: zx_detail_tax_lines_gt
3428: SET tax_amt = tax_amt + l_ctrl_total_hdr_tx_amt_tbl(i) - l_total_trx_tax_amt_tbl(i)
3429: --sync_with_prvdr_flag = DECODE(tax_provider_id, NULL, 'N', 'Y') -- this should have already been set during process proration
3430: WHERE application_id = l_application_id_tbl(i)
3431: AND event_class_code = l_event_class_code_tbl(i)

Line 3494: SELECT /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3490: AND nvl(self_assessed_flag,'N') <> 'Y'
3491: AND tax_provider_id IS NULL;
3492:
3493: CURSOR get_det_tax_lines_sum_amt_csr(p_summary_tax_line_id NUMBER) IS
3494: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3495: SUM(tax_amt), MAX(tax_amt)
3496: FROM zx_detail_tax_lines_gt
3497: WHERE application_id = p_event_class_rec.application_id
3498: AND entity_code = p_event_class_rec.entity_code

Line 3496: FROM zx_detail_tax_lines_gt

3492:
3493: CURSOR get_det_tax_lines_sum_amt_csr(p_summary_tax_line_id NUMBER) IS
3494: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3495: SUM(tax_amt), MAX(tax_amt)
3496: FROM zx_detail_tax_lines_gt
3497: WHERE application_id = p_event_class_rec.application_id
3498: AND entity_code = p_event_class_rec.entity_code
3499: AND event_class_code = p_event_class_rec.event_class_code
3500: AND trx_id = p_event_class_rec.trx_id

Line 3549: UPDATE /+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) /

3545: -- adjust tax amount of the detail tax line with the maximum tax amount.
3546: --
3547: FORALL i IN l_summary_tax_line_id_tbl.FIRST .. l_summary_tax_line_id_tbl.LAST
3548:
3549: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3550: zx_detail_tax_lines_gt
3551: SET tax_amt = tax_amt + l_rounding_diff_tbl(i)
3552: WHERE trx_id = p_event_class_rec.trx_id
3553: AND application_id = p_event_class_rec.application_id

Line 3550: zx_detail_tax_lines_gt

3546: --
3547: FORALL i IN l_summary_tax_line_id_tbl.FIRST .. l_summary_tax_line_id_tbl.LAST
3548:
3549: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3550: zx_detail_tax_lines_gt
3551: SET tax_amt = tax_amt + l_rounding_diff_tbl(i)
3552: WHERE trx_id = p_event_class_rec.trx_id
3553: AND application_id = p_event_class_rec.application_id
3554: AND event_class_code = p_event_class_rec.event_class_code

Line 3605: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

3601:
3602: x_return_status := FND_API.G_RET_STS_SUCCESS;
3603:
3604: -- init gt tables
3605: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
3606:
3607: -- added the following initializations for bug fix 5417887
3608: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_line_tx_amt_flg := 'N';
3609: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'N';