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 1560: -- table zx_detail_tax_lines_gt

1556: END IF; -- ctrl_total_line_tx_amt IS NOT NULL
1557:
1558: -- If the number of tax lines in g_detail_tax_lines_tbl is greater than,
1559: -- or equals to 1000, dump the detail tax lines to the global temporary
1560: -- table zx_detail_tax_lines_gt
1561: --
1562: IF ( g_detail_tax_lines_tbl.LAST >= 1000) THEN
1563:
1564: dump_detail_tax_lines_into_gt (x_return_status);

Line 2035: -- zx_detail_tax_lines_gt

2031: RETURN;
2032: END IF;
2033:
2034: -- dump detail tax lines created from summary tax lines into
2035: -- zx_detail_tax_lines_gt
2036: --
2037: dump_detail_tax_lines_into_gt (x_return_status);
2038:
2039: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2473: p_detail_tax_lines_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

2469: | Bug fix 3423300 |
2470: * =====================================================================*/
2471:
2472: PROCEDURE set_detail_tax_line_def_val (
2473: p_detail_tax_lines_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
2474: x_return_status OUT NOCOPY VARCHAR2
2475: ) IS
2476: BEGIN
2477: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

2548: END set_detail_tax_line_def_val;
2549:
2550: /* ======================================================================*
2551: | Procedure dump_detail_tax_lines_into_gt is called to insert detail |
2552: | tax lines into the global temporary table zx_detail_tax_lines_gt |
2553: | when the number of tax lines in the g_detail_tax_line_tbl |
2554: | reaches 1000 |
2555: * =====================================================================*/
2556:

Line 2596: INSERT INTO zx_detail_tax_lines_gt

2592:
2593: FORALL tax_line_index IN p_detail_tax_lines_tbl.FIRST ..
2594: p_detail_tax_lines_tbl.LAST
2595:
2596: INSERT INTO zx_detail_tax_lines_gt
2597: VALUES p_detail_tax_lines_tbl(tax_line_index);
2598:
2599: -- Flush g_detail_tax_lines_tbl
2600: --p_detail_tax_lines_tbl.DELETE;

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

2623: END dump_detail_tax_lines_into_gt;
2624:
2625: /* ======================================================================*
2626: | Procedure dump_detail_tax_lines_into_gt is called to insert detail |
2627: | tax lines into the global temporary table zx_detail_tax_lines_gt |
2628: * =====================================================================*/
2629:
2630: PROCEDURE dump_detail_tax_lines_into_gt (
2631: x_return_status OUT NOCOPY VARCHAR2) IS

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

2754: PROCEDURE fetch_detail_tax_lines (
2755: x_return_status OUT NOCOPY VARCHAR2) IS
2756:
2757: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2758: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2759: FROM zx_detail_tax_lines_gt
2760: WHERE trx_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2762: AND application_id =

Line 2759: FROM zx_detail_tax_lines_gt

2755: x_return_status OUT NOCOPY VARCHAR2) IS
2756:
2757: CURSOR fetch_detail_tax_lines(p_line_index NUMBER) IS
2758: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */ *
2759: FROM zx_detail_tax_lines_gt
2760: WHERE trx_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_line_index)
2762: AND application_id =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_line_index)

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

2818: -- p_event_class_rec IN zx_api_pub.event_class_rec_type,
2819: x_return_status OUT NOCOPY VARCHAR2) IS
2820:
2821: CURSOR get_total_line_tax_amt_csr IS
2822: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2823: tax_line.application_id,
2824: tax_line.event_class_code,
2825: tax_line.entity_code,
2826: tax_line.trx_id,

Line 2831: FROM zx_detail_tax_lines_gt tax_line

2827: tax_line.trx_line_id,
2828: tax_line.trx_level_type,
2829: tax_line.ctrl_total_line_tx_amt,
2830: ROUND(SUM(tax_line.unrounded_tax_amt), 20)
2831: FROM zx_detail_tax_lines_gt tax_line
2832: WHERE
2833: -- commented out for bug fix 5417887
2834: -- tax_line.application_id = p_event_class_rec.application_id
2835: -- AND tax_line.event_class_code = p_event_class_rec.event_class_code

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

2851: tax_line.ctrl_total_line_tx_amt
2852: HAVING NVL(SUM(tax_line.unrounded_tax_amt),0) <> 0;
2853:
2854: CURSOR get_mismatch_tax_lines_csr IS
2855: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2856: -- Added following columns for Bug#13093258 --
2857: tax_line.application_id,
2858: tax_line.event_class_code,
2859: tax_line.entity_code,

Line 2863: FROM zx_detail_tax_lines_gt tax_line

2859: tax_line.entity_code,
2860: tax_line.trx_id,
2861: tax_line.trx_line_id,
2862: ROUND(SUM(tax_line.unrounded_tax_amt), 20) total_line_tx_amt
2863: FROM zx_detail_tax_lines_gt tax_line
2864: WHERE tax_line.ctrl_total_line_tx_amt <> 0
2865: AND tax_line.self_assessed_flag <> 'Y'
2866: AND tax_line.offset_flag <> 'Y'
2867: AND tax_line.offset_link_to_tax_line_id IS NULL

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

2933: --l_context_info_rec.TRX_ID := l_trx_id_tbl(i);
2934: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
2935:
2936: --Added following update for Bug#13893772
2937: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
2938: zx_detail_tax_lines_gt
2939: SET tax_hold_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
2940: tax_hold_released_code = BITAND(ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
2941: NVL(tax_hold_released_code,0))

Line 2938: zx_detail_tax_lines_gt

2934: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
2935:
2936: --Added following update for Bug#13893772
2937: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
2938: zx_detail_tax_lines_gt
2939: SET tax_hold_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
2940: tax_hold_released_code = BITAND(ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
2941: NVL(tax_hold_released_code,0))
2942: WHERE application_id = l_application_id_tbl(i)

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

2997: -- 3. for now set the original tax_amt, taxable_amt to the unrounded tax_amt
2998: -- and taxable_amount since rounded amounts are not available yet. This
2999: -- logic may need to change based on later Reporting requirements.
3000:
3001: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3002: zx_detail_tax_lines_gt line
3003: SET line.orig_tax_amt = line.unrounded_tax_amt,
3004: line.orig_taxable_amt = line.unrounded_taxable_amt,
3005: line.orig_tax_rate = line.tax_rate,

Line 3002: zx_detail_tax_lines_gt line

2998: -- and taxable_amount since rounded amounts are not available yet. This
2999: -- logic may need to change based on later Reporting requirements.
3000:
3001: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3002: zx_detail_tax_lines_gt line
3003: SET line.orig_tax_amt = line.unrounded_tax_amt,
3004: line.orig_taxable_amt = line.unrounded_taxable_amt,
3005: line.orig_tax_rate = line.tax_rate,
3006: line.tax_amt = NULL,

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

3096: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3097: x_return_status OUT NOCOPY VARCHAR2) IS
3098:
3099: CURSOR get_total_trx_tax_amt_csr IS
3100: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3101: tax_line.application_id,
3102: tax_line.event_class_code,
3103: tax_line.entity_code,
3104: tax_line.trx_id,

Line 3107: FROM zx_detail_tax_lines_gt tax_line,

3103: tax_line.entity_code,
3104: tax_line.trx_id,
3105: trx_line.ctrl_total_hdr_tx_amt,
3106: ROUND(SUM(tax_line.unrounded_tax_amt), 20)
3107: FROM zx_detail_tax_lines_gt tax_line,
3108: zx_lines_det_factors trx_line
3109: WHERE tax_line.application_id = trx_line.application_id
3110: AND tax_line.event_class_code = trx_line.event_class_code
3111: AND tax_line.entity_code = trx_line.entity_code

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

3127: HAVING NVL(SUM(tax_line.unrounded_tax_amt), 0) <> 0;
3128:
3129:
3130: CURSOR get_mismatch_tax_lines_csr IS
3131: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3132: -- Added following columns for Bug#13093258 --
3133: tax_line.application_id,
3134: tax_line.event_class_code,
3135: tax_line.entity_code,

Line 3138: FROM zx_detail_tax_lines_gt tax_line,

3134: tax_line.event_class_code,
3135: tax_line.entity_code,
3136: tax_line.trx_id,
3137: ROUND(SUM(tax_line.unrounded_tax_amt), 20) total_trx_tax_amt
3138: FROM zx_detail_tax_lines_gt tax_line,
3139: zx_lines_det_factors trx_line
3140: WHERE tax_line.application_id = trx_line.application_id
3141: AND tax_line.event_class_code = trx_line.event_class_code
3142: AND tax_line.entity_code = trx_line.entity_code

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

3206: --l_context_info_rec.TRX_ID := l_trx_id_tbl(i);
3207: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
3208:
3209: --Added following update for Bug#13893772
3210: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3211: zx_detail_tax_lines_gt
3212: SET tax_hold_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
3213: tax_hold_released_code = BITAND(ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
3214: NVL(tax_hold_released_code,0))

Line 3211: zx_detail_tax_lines_gt

3207: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
3208:
3209: --Added following update for Bug#13893772
3210: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3211: zx_detail_tax_lines_gt
3212: SET tax_hold_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
3213: tax_hold_released_code = BITAND(ZX_TDS_CALC_SERVICES_PUB_PKG.g_tax_variance_hold_val,
3214: NVL(tax_hold_released_code,0))
3215: WHERE application_id = l_application_id_tbl(i)

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

3263: -- 2. for now set the original tax_amt, taxable_amt to the unrounded tax_amt
3264: -- and taxable_amount since rounded amounts are not available yet. This
3265: -- logic may need to change based on later Reporting requirements.
3266: --
3267: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3268: zx_detail_tax_lines_gt line
3269: SET line.orig_tax_amt = line.unrounded_tax_amt,
3270: line.orig_taxable_amt = line.unrounded_taxable_amt,
3271: line.orig_tax_rate = line.tax_rate,

Line 3268: zx_detail_tax_lines_gt line

3264: -- and taxable_amount since rounded amounts are not available yet. This
3265: -- logic may need to change based on later Reporting requirements.
3266: --
3267: UPDATE /*+ INDEX(line ZX_DETAIL_TAX_LINES_GT_U1) */
3268: zx_detail_tax_lines_gt line
3269: SET line.orig_tax_amt = line.unrounded_tax_amt,
3270: line.orig_taxable_amt = line.unrounded_taxable_amt,
3271: line.orig_tax_rate = line.tax_rate,
3272: line.tax_amt = NULL,

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

3367: ---p_event_class_rec IN zx_api_pub.event_class_rec_type,
3368: x_return_status OUT NOCOPY VARCHAR2) IS
3369:
3370: CURSOR get_total_line_tax_amt_csr IS
3371: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3372: SUM(tax_amt),
3373: MAX(tax_amt),
3374: SUM(tax_amt_funcl_curr),
3375: SUM(tax_amt_tax_curr),

Line 3383: FROM zx_detail_tax_lines_gt

3379: trx_id,
3380: trx_line_id,
3381: trx_level_type,
3382: ctrl_total_line_tx_amt
3383: FROM zx_detail_tax_lines_gt
3384: WHERE
3385: -- commented out for bug fix 5417887
3386: -- trx_id = p_event_class_rec.trx_id
3387: -- AND application_id = p_event_class_rec.application_id

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

3461: FORALL i IN l_trx_line_id_tbl.FIRST ..l_trx_line_id_tbl.LAST
3462:
3463: -- adjust tax amount of the detail tax line with the maximum tax amount.
3464: --
3465: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3466: zx_detail_tax_lines_gt
3467: SET tax_amt = tax_amt + l_ctrl_total_line_tx_amt_tbl(i) - l_total_line_tx_amt_tbl(i)
3468: ,tax_amt_funcl_curr = Decode(tax_amt_funcl_curr * currency_conversion_rate,
3469: NULL, NULL,

Line 3466: zx_detail_tax_lines_gt

3462:
3463: -- adjust tax amount of the detail tax line with the maximum tax amount.
3464: --
3465: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3466: zx_detail_tax_lines_gt
3467: SET tax_amt = tax_amt + l_ctrl_total_line_tx_amt_tbl(i) - l_total_line_tx_amt_tbl(i)
3468: ,tax_amt_funcl_curr = Decode(tax_amt_funcl_curr * currency_conversion_rate,
3469: NULL, NULL,
3470: (tax_amt_funcl_curr

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

3571: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3572: x_return_status OUT NOCOPY VARCHAR2) IS
3573:
3574: CURSOR get_total_trx_tax_amt_csr IS
3575: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3576: SUM(tax_line.tax_amt),
3577: MAX(tax_line.tax_amt),
3578: SUM(tax_line.tax_amt_funcl_curr),
3579: SUM(tax_line.tax_amt_tax_curr),

Line 3585: FROM zx_detail_tax_lines_gt tax_line,

3581: tax_line.event_class_code,
3582: tax_line.entity_code,
3583: tax_line.trx_id,
3584: trx_line.ctrl_total_hdr_tx_amt
3585: FROM zx_detail_tax_lines_gt tax_line,
3586: zx_lines_det_factors trx_line
3587: WHERE tax_line.application_id = trx_line.application_id
3588: AND tax_line.event_class_code = trx_line.event_class_code
3589: AND tax_line.entity_code = trx_line.entity_code

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

3644:
3645: -- adjust tax amount of the detail tax line with the maximum tax amount.
3646: --
3647: FORALL i IN l_trx_id_tbl.FIRST ..l_trx_id_tbl.LAST
3648: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3649: zx_detail_tax_lines_gt
3650: SET tax_amt = tax_amt + l_ctrl_total_hdr_tx_amt_tbl(i) - l_total_trx_tax_amt_tbl(i)
3651: ,tax_amt_funcl_curr = Decode(tax_amt_funcl_curr * currency_conversion_rate,
3652: NULL, NULL,

Line 3649: zx_detail_tax_lines_gt

3645: -- adjust tax amount of the detail tax line with the maximum tax amount.
3646: --
3647: FORALL i IN l_trx_id_tbl.FIRST ..l_trx_id_tbl.LAST
3648: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3649: zx_detail_tax_lines_gt
3650: SET tax_amt = tax_amt + l_ctrl_total_hdr_tx_amt_tbl(i) - l_total_trx_tax_amt_tbl(i)
3651: ,tax_amt_funcl_curr = Decode(tax_amt_funcl_curr * currency_conversion_rate,
3652: NULL, NULL,
3653: (tax_amt_funcl_curr

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

3767: AND nvl(self_assessed_flag,'N') <> 'Y'
3768: AND tax_provider_id IS NULL;
3769:
3770: CURSOR get_det_tax_lines_sum_amt_csr(p_summary_tax_line_id NUMBER) IS
3771: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3772: SUM(tax_amt), MAX(tax_amt)
3773: FROM zx_detail_tax_lines_gt
3774: WHERE application_id = p_event_class_rec.application_id
3775: AND entity_code = p_event_class_rec.entity_code

Line 3773: FROM zx_detail_tax_lines_gt

3769:
3770: CURSOR get_det_tax_lines_sum_amt_csr(p_summary_tax_line_id NUMBER) IS
3771: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3772: SUM(tax_amt), MAX(tax_amt)
3773: FROM zx_detail_tax_lines_gt
3774: WHERE application_id = p_event_class_rec.application_id
3775: AND entity_code = p_event_class_rec.entity_code
3776: AND event_class_code = p_event_class_rec.event_class_code
3777: AND trx_id = p_event_class_rec.trx_id

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

3822: -- adjust tax amount of the detail tax line with the maximum tax amount.
3823: --
3824: FORALL i IN l_summary_tax_line_id_tbl.FIRST .. l_summary_tax_line_id_tbl.LAST
3825:
3826: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3827: zx_detail_tax_lines_gt
3828: SET tax_amt = tax_amt + l_rounding_diff_tbl(i)
3829: WHERE trx_id = p_event_class_rec.trx_id
3830: AND application_id = p_event_class_rec.application_id

Line 3827: zx_detail_tax_lines_gt

3823: --
3824: FORALL i IN l_summary_tax_line_id_tbl.FIRST .. l_summary_tax_line_id_tbl.LAST
3825:
3826: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3827: zx_detail_tax_lines_gt
3828: SET tax_amt = tax_amt + l_rounding_diff_tbl(i)
3829: WHERE trx_id = p_event_class_rec.trx_id
3830: AND application_id = p_event_class_rec.application_id
3831: AND event_class_code = p_event_class_rec.event_class_code

Line 3882: DELETE FROM ZX_DETAIL_TAX_LINES_GT;

3878:
3879: x_return_status := FND_API.G_RET_STS_SUCCESS;
3880:
3881: -- init gt tables
3882: DELETE FROM ZX_DETAIL_TAX_LINES_GT;
3883:
3884: -- added the following initializations for bug fix 5417887
3885: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_line_tx_amt_flg := 'N';
3886: ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_hdr_tx_amt_flg := 'N';