[Home] [Help]
124:
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: x_tax_date :=
128: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
129: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
130: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: x_tax_date :=
128: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
129: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
130: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
126:
127: x_tax_date :=
128: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
129: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
130: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
134: x_tax_determine_date :=
127: x_tax_date :=
128: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
129: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
130: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
128: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
129: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
130: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
131: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
133:
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
133:
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
134: x_tax_determine_date :=
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
135: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
136: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
137: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
138: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
146:
139: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
146:
147: IF (g_level_procedure >= g_current_runtime_level ) THEN
140: x_tax_point_date :=
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
146:
147: IF (g_level_procedure >= g_current_runtime_level ) THEN
148: FND_LOG.STRING(g_level_procedure,
141: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.related_doc_date(p_trx_line_index),
142: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.provnl_tax_determination_date(p_trx_line_index),
143: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_date(p_trx_line_index),
144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
146:
147: IF (g_level_procedure >= g_current_runtime_level ) THEN
148: FND_LOG.STRING(g_level_procedure,
149: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(-)',
428: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Unable to determine the Country code for the Location id: '||
429: l_location_id||' and Location type: '||l_location_type);
430:
431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
432: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
433: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
434: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
435:
436: ZX_API_PUB.add_msg(
430:
431: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
432: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
433: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
434: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
435:
436: ZX_API_PUB.add_msg(
437: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
438: RETURN;
471: FND_MESSAGE.SET_NAME ('ZX', 'ZX_NO_COUNTRY_CODE_FOUND');
472: FND_MESSAGE.SET_TOKEN('LOCATION_TYPE', l_location_type);
473:
474: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
475: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
476: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
477: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
478:
479: ZX_API_PUB.add_msg(
473:
474: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
475: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
476: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
477: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
478:
479: ZX_API_PUB.add_msg(
480: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
481:
507: FND_MESSAGE.SET_NAME ('ZX', 'ZX_NO_COUNTRY_CODE_FOUND');
508: FND_MESSAGE.SET_TOKEN('LOCATION_TYPE', l_null_country_loc_type);
509:
510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
512: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
514:
515: ZX_API_PUB.add_msg(
509:
510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
512: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
514:
515: ZX_API_PUB.add_msg(
516: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
517:
528: FND_MESSAGE.SET_TOKEN('TEMPLATE_NAME', p_event_class_rec.det_factor_templ_code);
529: FND_MESSAGE.SET_TOKEN('LOCATIONS_LIST', l_location_list);
530:
531: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
532: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
534: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
535:
536: ZX_API_PUB.add_msg(
530:
531: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
532: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
534: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
535:
536: ZX_API_PUB.add_msg(
537: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);*/
538:
586: --
587: -- Bug#5440023- do not poplate detail_tax_regime_tbl
588: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
589: --
590: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
591: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
592:
593: l_new_row_num :=
594: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
587: -- Bug#5440023- do not poplate detail_tax_regime_tbl
588: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
589: --
590: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
591: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
592:
593: l_new_row_num :=
594: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
595:
590: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
591: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
592:
593: l_new_row_num :=
594: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
595:
596: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
597: := p_trx_line_index;
598: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
592:
593: l_new_row_num :=
594: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
595:
596: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
597: := p_trx_line_index;
598: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
599: := l_regime_rec.tax_regime_id;
600: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
594: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
595:
596: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
597: := p_trx_line_index;
598: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
599: := l_regime_rec.tax_regime_id;
600: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
601: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
602: END IF;
596: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
597: := p_trx_line_index;
598: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
599: := l_regime_rec.tax_regime_id;
600: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
601: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
602: END IF;
603:
604: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(l_regime_rec.tax_regime_id)
600: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
601: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
602: END IF;
603:
604: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(l_regime_rec.tax_regime_id)
605: THEN
606: add_tax_regime (
607: l_regime_rec.regime_precedence,
608: l_regime_rec.tax_regime_id,
652: --
653: -- Bug#5440023- do not poplate detail_tax_regime_tbl
654: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
655: --
656: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
657: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
658:
659: l_new_row_num :=
660: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
653: -- Bug#5440023- do not poplate detail_tax_regime_tbl
654: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
655: --
656: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
657: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
658:
659: l_new_row_num :=
660: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
661:
656: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
657: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
658:
659: l_new_row_num :=
660: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
661:
662: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
663: := p_trx_line_index;
664: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
658:
659: l_new_row_num :=
660: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
661:
662: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
663: := p_trx_line_index;
664: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
665: := l_regime_rec.tax_regime_id;
666: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
660: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
661:
662: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
663: := p_trx_line_index;
664: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
665: := l_regime_rec.tax_regime_id;
666: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
667: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
668: END IF;
662: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).trx_line_index
663: := p_trx_line_index;
664: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(l_new_row_num).tax_regime_id
665: := l_regime_rec.tax_regime_id;
666: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
667: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
668: END IF;
669:
670: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(l_regime_rec.tax_regime_id)
666: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
667: l_new_row_num).tax_regime_precedence := l_regime_rec.regime_precedence;
668: END IF;
669:
670: IF NOT ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.EXISTS(l_regime_rec.tax_regime_id)
671: THEN
672: add_tax_regime (
673: l_regime_rec.regime_precedence,
674: l_regime_rec.tax_regime_id,
710: -- This also handles the validation of atleast one driver parameter having
711: -- value for a transaction.
712: --
713: IF ((NVL(l_country_tab.COUNT, 0) > 0 OR NVL(l_geography_tab.count, 0) > 0) AND
714: NVL(ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.COUNT, 0) = 0) THEN
715: -- x_return_status := FND_API.G_RET_STS_ERROR;
716: IF (g_level_statement >= g_current_runtime_level ) THEN
717: FND_LOG.STRING(g_level_statement,
718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
734: IF (g_level_procedure >= g_current_runtime_level ) THEN
735: FND_LOG.STRING(g_level_procedure,
736: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
737: 'Count for applicable regimes is: '||
738: nvl(ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.COUNT,0));
739: END IF;
740:
741: IF (g_level_procedure >= g_current_runtime_level ) THEN
742: FND_LOG.STRING(g_level_procedure,
795: -- insert the regime_id and the regime_precedence using the regime_id as the
796: -- subscript of the p_Tax_regime_tbl. Hence, when the same tax_regime_id is
797: -- passed multiple times, we overwrite the p_tax_regime_tbl(tax_regime_id) row
798:
799: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_precedence :=
800: p_tax_regime_precedence;
801: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_id :=
802: p_tax_regime_id;
803: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_code :=
797: -- passed multiple times, we overwrite the p_tax_regime_tbl(tax_regime_id) row
798:
799: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_precedence :=
800: p_tax_regime_precedence;
801: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_id :=
802: p_tax_regime_id;
803: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_code :=
804: p_tax_regime_code;
805: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).parent_regime_code :=
799: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_precedence :=
800: p_tax_regime_precedence;
801: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_id :=
802: p_tax_regime_id;
803: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_code :=
804: p_tax_regime_code;
805: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).parent_regime_code :=
806: p_parent_regime_code;
807: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).country_code :=
801: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_id :=
802: p_tax_regime_id;
803: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_code :=
804: p_tax_regime_code;
805: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).parent_regime_code :=
806: p_parent_regime_code;
807: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).country_code :=
808: p_country_code;
809: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_type :=
803: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).tax_regime_code :=
804: p_tax_regime_code;
805: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).parent_regime_code :=
806: p_parent_regime_code;
807: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).country_code :=
808: p_country_code;
809: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_type :=
810: p_geography_type;
811: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_id :=
805: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).parent_regime_code :=
806: p_parent_regime_code;
807: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).country_code :=
808: p_country_code;
809: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_type :=
810: p_geography_type;
811: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_id :=
812: p_geography_id;
813: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_from :=
807: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).country_code :=
808: p_country_code;
809: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_type :=
810: p_geography_type;
811: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_id :=
812: p_geography_id;
813: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_from :=
814: p_effective_from;
815: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_to :=
809: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_type :=
810: p_geography_type;
811: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_id :=
812: p_geography_id;
813: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_from :=
814: p_effective_from;
815: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_to :=
816: p_effective_to;
817:
811: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).geography_id :=
812: p_geography_id;
813: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_from :=
814: p_effective_from;
815: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(p_tax_regime_id).effective_to :=
816: p_effective_to;
817:
818: EXCEPTION
819: WHEN OTHERS THEN
1119: AND application_id = p_event_class_rec.application_id
1120: AND event_class_code = p_event_class_rec.event_class_code
1121: AND entity_code = p_event_class_rec.entity_code
1122: AND trx_line_id =
1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1124: AND trx_level_type =
1125: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1126: AND manually_entered_flag = 'Y'
1127: AND cancel_flag <> 'Y'
1121: AND entity_code = p_event_class_rec.entity_code
1122: AND trx_line_id =
1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1124: AND trx_level_type =
1125: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1126: AND manually_entered_flag = 'Y'
1127: AND cancel_flag <> 'Y'
1128: AND mrc_tax_line_flag = 'N'
1129: AND tax_provider_id IS NULL;
1134: AND application_id = p_event_class_rec.application_id
1135: AND event_class_code = p_event_class_rec.event_class_code
1136: AND entity_code = p_event_class_rec.entity_code
1137: AND trx_line_id =
1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1139: AND trx_level_type =
1140: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1141: AND tax_provider_id IS NULL
1142: AND cancel_flag <> 'Y'
1136: AND entity_code = p_event_class_rec.entity_code
1137: AND trx_line_id =
1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1139: AND trx_level_type =
1140: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1141: AND tax_provider_id IS NULL
1142: AND cancel_flag <> 'Y'
1143: AND offset_link_to_tax_line_id IS NULL
1144: AND mrc_tax_line_flag = 'N'
1151: AND application_id = p_event_class_rec.application_id
1152: AND event_class_code = p_event_class_rec.event_class_code
1153: AND entity_code = p_event_class_rec.entity_code
1154: AND trx_line_id =
1155: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1156: AND trx_level_type =
1157: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1158: AND tax_provider_id IS NULL
1159: AND cancel_flag <> 'Y'
1153: AND entity_code = p_event_class_rec.entity_code
1154: AND trx_line_id =
1155: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1156: AND trx_level_type =
1157: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1158: AND tax_provider_id IS NULL
1159: AND cancel_flag <> 'Y'
1160: AND offset_link_to_tax_line_id IS NULL
1161: AND mrc_tax_line_flag = 'N'
1168: AND application_id = p_event_class_rec.application_id
1169: AND event_class_code = p_event_class_rec.event_class_code
1170: AND entity_code = p_event_class_rec.entity_code
1171: AND trx_line_id =
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1173: AND trx_level_type =
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1175: AND tax_provider_id IS NULL
1176: AND cancel_flag <> 'Y'
1170: AND entity_code = p_event_class_rec.entity_code
1171: AND trx_line_id =
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1173: AND trx_level_type =
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1175: AND tax_provider_id IS NULL
1176: AND cancel_flag <> 'Y'
1177: AND offset_link_to_tax_line_id IS NULL
1178: AND mrc_tax_line_flag = 'N'
1186: AND application_id = p_event_class_rec.application_id
1187: AND event_class_code = p_event_class_rec.event_class_code
1188: AND entity_code = p_event_class_rec.entity_code
1189: AND trx_line_id =
1190: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1191: AND trx_level_type =
1192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1193: AND tax_provider_id IS NULL
1194: AND cancel_flag <> 'Y'
1188: AND entity_code = p_event_class_rec.entity_code
1189: AND trx_line_id =
1190: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1191: AND trx_level_type =
1192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1193: AND tax_provider_id IS NULL
1194: AND cancel_flag <> 'Y'
1195: AND offset_link_to_tax_line_id IS NULL
1196: AND mrc_tax_line_flag = 'N'
1207: AND application_id = p_event_class_rec.application_id
1208: AND event_class_code = p_event_class_rec.event_class_code
1209: AND entity_code = p_event_class_rec.entity_code
1210: AND trx_line_id =
1211: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1212: AND trx_level_type =
1213: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1214: AND tax_provider_id IS NULL
1215: -- AND cancel_flag <> 'Y' -- commented for Bug#13946670
1209: AND entity_code = p_event_class_rec.entity_code
1210: AND trx_line_id =
1211: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1212: AND trx_level_type =
1213: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
1214: AND tax_provider_id IS NULL
1215: -- AND cancel_flag <> 'Y' -- commented for Bug#13946670
1216: AND offset_link_to_tax_line_id IS NULL
1217: AND mrc_tax_line_flag = 'N'
1216: AND offset_link_to_tax_line_id IS NULL
1217: AND mrc_tax_line_flag = 'N'
1218: ORDER BY tax_regime_code, tax, tax_apportionment_line_number;
1219:
1220: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
1221: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1252: END IF;
1253:
1254: l_rownum := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST, 0);
1255:
1256: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_flag(
1257: p_trx_line_index), 'N') = 'Y'
1258: THEN
1259:
1260: -- For migrated transactions
1350: --bug#7695189
1351: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1352: -- l_rownum).summary_tax_line_id := NULL;
1353:
1354: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1355: p_trx_line_index) <> 'OVERRIDE_TAX' AND
1356: NVL(tax_line_rec.associated_child_frozen_flag, 'N') = 'Y'
1357: THEN
1358:
1391: x_begin_index := l_rownum;
1392: END IF;
1393: END LOOP; -- tax_line_rec IN get_all_tax_lines_migrated
1394:
1395: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1396: p_trx_line_index) = 'OVERRIDE_TAX'
1397: THEN
1398:
1399: -- For OVERRIDE_TAX
1398:
1399: -- For OVERRIDE_TAX
1400: --
1401:
1402: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1403: p_trx_line_index), 'N') = 'N' AND
1404: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1405: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1406: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1402: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1403: p_trx_line_index), 'N') = 'N' AND
1404: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1405: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1406: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1407: p_trx_line_index), 'N') = 'N'))
1408: THEN
1409:
1410: -- For OVERRIDE_TAX, fetch all tax lines with recalc_required_flag = 'Y'.
1550: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1551:
1552: END LOOP;
1553:
1554: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1555: p_trx_line_index), 'N') = 'N' AND
1556: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1557: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1558: p_trx_line_index), 'N') = 'Y')
1553:
1554: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1555: p_trx_line_index), 'N') = 'N' AND
1556: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1557: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1558: p_trx_line_index), 'N') = 'Y')
1559: THEN
1560:
1561: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1652: END IF;
1653: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1654:
1655: END LOOP;
1656: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1657: p_trx_line_index), 'N') = 'Y' AND
1658: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1659: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1660: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1656: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1657: p_trx_line_index), 'N') = 'Y' AND
1658: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1659: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1660: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1661: p_trx_line_index), 'N') = 'N'))
1662: THEN
1663:
1664: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1756: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1757:
1758: END LOOP;
1759:
1760: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1761: p_trx_line_index), 'N') = 'Y' AND
1762: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1763: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1764: p_trx_line_index), 'N') = 'Y')
1759:
1760: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1761: p_trx_line_index), 'N') = 'Y' AND
1762: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1763: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1764: p_trx_line_index), 'N') = 'Y')
1765: THEN
1766:
1767: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1859: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1860:
1861: END LOOP;
1862: END IF;
1863: ELSIF ((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1864: p_trx_line_index) = 'UPDATE')
1865: OR
1866: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1867: p_trx_line_index) ='UPDATE' AND
1862: END IF;
1863: ELSIF ((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1864: p_trx_line_index) = 'UPDATE')
1865: OR
1866: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1867: p_trx_line_index) ='UPDATE' AND
1868: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1869: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
1870: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1864: p_trx_line_index) = 'UPDATE')
1865: OR
1866: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1867: p_trx_line_index) ='UPDATE' AND
1868: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1869: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
1870: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1871: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
1872: )) THEN -- Bug 5291394
1866: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1867: p_trx_line_index) ='UPDATE' AND
1868: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1869: p_trx_line_index) = 'LINE_INFO_TAX_ONLY'
1870: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1871: p_trx_line_index) = 'CREATE_WITH_TAX') -- Bug 8205359
1872: )) THEN -- Bug 5291394
1873:
1874: -- For Update
2123: --
2124: IF p_event_class_rec.allow_manual_lin_recalc_flag ='Y' THEN
2125:
2126: l_current_line_amt :=
2127: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt( p_trx_line_index);
2128:
2129: IF tax_line_rec.line_amt <> 0 THEN
2130: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2131: l_rownum).unrounded_tax_amt :=
2239: END IF;
2240:
2241: --Besides update action, also need to populate the trx line info onto tax lines for
2242: --manually entered tax lines.
2243: --IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2244: -- p_trx_line_index) = 'UPDATE' THEN
2245: -- copy transaction info to manual tax lines
2246: --
2247: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
2493: AND entity_code = p_event_class_rec.entity_code
2494: AND event_class_code = p_event_class_rec.event_class_code
2495: AND trx_id = p_event_class_rec.trx_id
2496: AND trx_line_id =
2497: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
2498: AND trx_level_type =
2499: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
2500: AND tax_regime_code = p_tax_regime_code
2501: AND tax = p_tax
2495: AND trx_id = p_event_class_rec.trx_id
2496: AND trx_line_id =
2497: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
2498: AND trx_level_type =
2499: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
2500: AND tax_regime_code = p_tax_regime_code
2501: AND tax = p_tax
2502: AND mrc_tax_line_flag = 'N';
2503:
2510: tax_amt,
2511: taxable_amt
2512: FROM zx_lines
2513: WHERE application_id =
2514: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2515: AND event_class_code =
2516: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2517: AND entity_code =
2518: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2512: FROM zx_lines
2513: WHERE application_id =
2514: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2515: AND event_class_code =
2516: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2517: AND entity_code =
2518: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2519: AND trx_id =
2520: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2514: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2515: AND event_class_code =
2516: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2517: AND entity_code =
2518: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2519: AND trx_id =
2520: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2521: AND trx_line_id =
2522: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2516: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2517: AND entity_code =
2518: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2519: AND trx_id =
2520: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2521: AND trx_line_id =
2522: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2523: AND trx_level_type =
2524: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2518: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2519: AND trx_id =
2520: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2521: AND trx_line_id =
2522: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2523: AND trx_level_type =
2524: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2525: AND tax_regime_code = c_tax_regime_code
2526: AND tax = c_tax
2520: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2521: AND trx_line_id =
2522: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2523: AND trx_level_type =
2524: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2525: AND tax_regime_code = c_tax_regime_code
2526: AND tax = c_tax
2527: AND cancel_flag <> 'Y'
2528: AND mrc_tax_line_flag = 'N';
2568: l_tax_class := 'INPUT';
2569: END IF;
2570:
2571: l_trx_line_id :=
2572: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
2573: l_trx_level_type :=
2574: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
2575:
2576: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2570:
2571: l_trx_line_id :=
2572: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
2573: l_trx_level_type :=
2574: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
2575:
2576: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2577: -- init_for_line in the wrapper
2578:
2575:
2576: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2577: -- init_for_line in the wrapper
2578:
2579: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2580: p_trx_line_index) = 'CREATE' OR
2581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2582: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2577: -- init_for_line in the wrapper
2578:
2579: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2580: p_trx_line_index) = 'CREATE' OR
2581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2582: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2584: p_trx_line_index) = 'UPDATE' OR
2585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2579: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2580: p_trx_line_index) = 'CREATE' OR
2581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2582: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2584: p_trx_line_index) = 'UPDATE' OR
2585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2586: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2587: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2582: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2584: p_trx_line_index) = 'UPDATE' OR
2585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2586: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2587: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2588: p_trx_line_index) = 'COPY_AND_CREATE'
2589: THEN
2583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2584: p_trx_line_index) = 'UPDATE' OR
2585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2586: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2587: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2588: p_trx_line_index) = 'COPY_AND_CREATE'
2589: THEN
2590:
2591: FOR l_tax_rec IN get_all_taxes_for_regime_cur(l_tax_class) LOOP
2690: --
2691: -- Bug 4277751: For intercompany transaction, need to pull in detail
2692: -- tax lines from source documnet.
2693: --
2694: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2695: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2696: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2697: p_trx_line_index) = 'UPDATE' OR
2698: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2692: -- tax lines from source documnet.
2693: --
2694: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2695: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2696: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2697: p_trx_line_index) = 'UPDATE' OR
2698: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2699: p_trx_line_index) IN ('CREATE', 'UPDATE')
2700: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2694: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2695: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2696: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2697: p_trx_line_index) = 'UPDATE' OR
2698: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2699: p_trx_line_index) IN ('CREATE', 'UPDATE')
2700: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2701: p_trx_line_index) = 'INTERCOMPANY_TRX')
2702: THEN
2696: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2697: p_trx_line_index) = 'UPDATE' OR
2698: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2699: p_trx_line_index) IN ('CREATE', 'UPDATE')
2700: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2701: p_trx_line_index) = 'INTERCOMPANY_TRX')
2702: THEN
2703: -- Check if this tax line exists in the new created applicable tax lines
2704: --
3062: x_begin_index := l_new_row_num;
3063: END IF;
3064: END IF;
3065:
3066: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index)='UPDATE') AND
3067: NOT l_ref_doc_tax_applicable -- Bug 10184087
3068: -- Handle_update_scenario should not be called if zero amount
3069: -- refrence tax line is found and the PO tax becomes applicable
3070: THEN
3217: l_place_of_supply_result_id;
3218: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3219: l_new_row_num).legal_message_pos:=
3220: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_place_of_supply_result_id,
3221: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index));
3222:
3223: -- bug 5077691: populate legal_reporting_status
3224: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
3225: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3239: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3240: l_new_row_num).legal_message_appl_2 :=
3241: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
3242: l_applicability_result_id,
3243: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index));
3244: END IF;
3245:
3246: IF l_tax_rec.direct_rate_rule_flag = 'Y' AND
3247: l_direct_rate_result_id IS NOT NULL AND -- Bug 6816250, add NVL
3261: l_direct_rate_result_rec.rate_result;
3262: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3263: l_new_row_num).legal_message_rate:=
3264: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_direct_rate_result_id,
3265: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index));
3266:
3267:
3268: -- populate tax_status_id
3269: --
3316: -- populate hq_estb_party_tax_prof_id
3317: --
3318: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3319: l_new_row_num).hq_estb_party_tax_prof_id :=
3320: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
3321: p_trx_line_index);
3322:
3323: -- populate tax registration info
3324: --
3387: --
3388: -- Bug 5705976: Since, we stamp 'INTERCOMPANY_TRX' on both AR and AP
3389: -- transactions, the following code has become incorrect.
3390: --
3391: -- IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3392: -- p_trx_line_index) IN ('CREATE', 'UPDATE') AND
3393: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
3394: -- p_trx_line_index) = 'INTERCOMPANY_TRX'
3395: -- THEN
3389: -- transactions, the following code has become incorrect.
3390: --
3391: -- IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3392: -- p_trx_line_index) IN ('CREATE', 'UPDATE') AND
3393: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
3394: -- p_trx_line_index) = 'INTERCOMPANY_TRX'
3395: -- THEN
3396: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3397: -- l_new_row_num).self_assessed_flag := 'Y';
3421: /* Move to ZX_TDS_TAXABLE_BASIS_DETM_PKG
3422: *
3423: * -- Populate tax_inclusion_flag and line_amt_includes_tax_flag
3424: * --
3425: * IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3426: * p_trx_line_index) = 'A') THEN
3427: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3428: * l_new_row_num).tax_amt_included_flag := 'Y';
3429: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3428: * l_new_row_num).tax_amt_included_flag := 'Y';
3429: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3430: * l_new_row_num).line_amt_includes_tax_flag := 'A';
3431: *
3432: * ELSIF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3433: * p_trx_line_index) = 'N') THEN
3434: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3435: * l_new_row_num).tax_amt_included_flag := 'N';
3436: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3435: * l_new_row_num).tax_amt_included_flag := 'N';
3436: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3437: * l_new_row_num).line_amt_includes_tax_flag := 'N';
3438: *
3439: * ELSIF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3440: * p_trx_line_index) IN ('S', 'I')) THEN
3441: * -- Remain the value of tax_inclusion_flag returned by
3442: * -- get_tax_regostration and set line_amt_includes_tax_flag to 'STANDARD'
3443: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3447: */
3448:
3449: -- populate Tax_Only_Line_Flag if line_level_action is 'CREATE_TAX_ONLY'
3450: --
3451: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3452: p_trx_line_index) = 'CREATE_TAX_ONLY') THEN
3453: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3454: l_new_row_num).tax_only_line_flag := 'Y';
3455: END IF;
3468: -- trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index) IS NOT NULL,
3469: -- get tax rate code from refefence document
3470: --
3471: IF p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
3472: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
3473: p_trx_line_index) IS NOT NULL
3474: THEN
3475:
3476: enforce_tax_from_ref_doc(
3631:
3632: CURSOR get_tax_lines IS
3633: SELECT * FROM zx_lines
3634: WHERE application_id =
3635: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3636: AND entity_code =
3637: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3638: AND event_class_code =
3639: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3633: SELECT * FROM zx_lines
3634: WHERE application_id =
3635: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3636: AND entity_code =
3637: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3638: AND event_class_code =
3639: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3640: AND trx_id =
3641: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3635: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3636: AND entity_code =
3637: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3638: AND event_class_code =
3639: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3640: AND trx_id =
3641: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3642: AND trx_line_id =
3643: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3637: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3638: AND event_class_code =
3639: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3640: AND trx_id =
3641: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3642: AND trx_line_id =
3643: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3644: AND trx_level_type =
3645: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3639: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3640: AND trx_id =
3641: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3642: AND trx_line_id =
3643: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3644: AND trx_level_type =
3645: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3646: AND tax_provider_id IS NULL
3647: AND Cancel_Flag<> 'Y'
3641: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3642: AND trx_line_id =
3643: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3644: AND trx_level_type =
3645: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3646: AND tax_provider_id IS NULL
3647: AND Cancel_Flag<> 'Y'
3648: --AND offset_link_to_tax_line_id IS NULL Bug 8517610
3649: AND mrc_tax_line_flag = 'N'
3812: FND_MESSAGE.SET_NAME('ZX','ZX_STATUS_NOT_FOUND');
3813: FND_MESSAGE.SET_TOKEN('TAX',tax_line_rec.tax);
3814:
3815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3816: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
3817: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
3818: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
3819:
3820: ZX_API_PUB.add_msg(
3814:
3815: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3816: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
3817: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
3818: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
3819:
3820: ZX_API_PUB.add_msg(
3821: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
3822:
3869: -- prorate prd_total_tax_amt, prd_total_tax_amt_tax_curr and
3870: -- prd_total_tax_amt_funcl_curr
3871: --
3872: l_line_amt_current :=
3873: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
3874:
3875: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3876: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
3877: (l_line_amt_current/tax_line_rec.line_amt);
3982: -- do this check only for Payables.
3983:
3984: l_unrounded_tax_amt := NULL;
3985:
3986: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) = 200 THEN
3987: SELECT line_amt
3988: INTO l_orig_amt
3989: FROM zx_lines_det_factors
3990: WHERE application_id =
3987: SELECT line_amt
3988: INTO l_orig_amt
3989: FROM zx_lines_det_factors
3990: WHERE application_id =
3991: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3992: AND entity_code =
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3994: AND event_class_code =
3995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3989: FROM zx_lines_det_factors
3990: WHERE application_id =
3991: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3992: AND entity_code =
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3994: AND event_class_code =
3995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3996: AND trx_id =
3997: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3991: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3992: AND entity_code =
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3994: AND event_class_code =
3995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3996: AND trx_id =
3997: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3998: AND trx_line_id =
3999: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3994: AND event_class_code =
3995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3996: AND trx_id =
3997: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3998: AND trx_line_id =
3999: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4000: AND trx_level_type =
4001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
3995: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3996: AND trx_id =
3997: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3998: AND trx_line_id =
3999: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4000: AND trx_level_type =
4001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4002:
4003: SELECT sum(line_amt)
3997: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3998: AND trx_line_id =
3999: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4000: AND trx_level_type =
4001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4002:
4003: SELECT sum(line_amt)
4004: INTO l_appl_line_amt
4005: FROM zx_lines_det_factors
4003: SELECT sum(line_amt)
4004: INTO l_appl_line_amt
4005: FROM zx_lines_det_factors
4006: WHERE applied_from_application_id =
4007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4008: AND applied_from_entity_code =
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4010: AND applied_from_event_class_code =
4011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4005: FROM zx_lines_det_factors
4006: WHERE applied_from_application_id =
4007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4008: AND applied_from_entity_code =
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4010: AND applied_from_event_class_code =
4011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4012: AND applied_from_trx_id =
4013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4008: AND applied_from_entity_code =
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4010: AND applied_from_event_class_code =
4011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4012: AND applied_from_trx_id =
4013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4014: AND applied_from_line_id =
4015: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4010: AND applied_from_event_class_code =
4011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4012: AND applied_from_trx_id =
4013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4014: AND applied_from_line_id =
4015: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4016: AND applied_from_trx_level_type =
4017: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4012: AND applied_from_trx_id =
4013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4014: AND applied_from_line_id =
4015: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4016: AND applied_from_trx_level_type =
4017: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4018:
4019: SELECT sum(tax_amt)
4013: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4014: AND applied_from_line_id =
4015: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4016: AND applied_from_trx_level_type =
4017: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4018:
4019: SELECT sum(tax_amt)
4020: INTO l_appl_tax_amt
4021: FROM zx_lines
4019: SELECT sum(tax_amt)
4020: INTO l_appl_tax_amt
4021: FROM zx_lines
4022: WHERE applied_from_application_id =
4023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4024: AND applied_from_entity_code =
4025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4026: AND applied_from_event_class_code =
4027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4021: FROM zx_lines
4022: WHERE applied_from_application_id =
4023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4024: AND applied_from_entity_code =
4025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4026: AND applied_from_event_class_code =
4027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4028: AND applied_from_trx_id =
4029: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4024: AND applied_from_entity_code =
4025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4026: AND applied_from_event_class_code =
4027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4028: AND applied_from_trx_id =
4029: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4030: AND applied_from_line_id =
4031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4026: AND applied_from_event_class_code =
4027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4028: AND applied_from_trx_id =
4029: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4030: AND applied_from_line_id =
4031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4032: AND applied_from_trx_level_type =
4033: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
4027: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
4028: AND applied_from_trx_id =
4029: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4030: AND applied_from_line_id =
4031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4032: AND applied_from_trx_level_type =
4033: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
4034: -- Added Tax Regime and Tax condition for Bug#13397403 --
4035: AND tax_regime_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code
4029: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
4030: AND applied_from_line_id =
4031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
4032: AND applied_from_trx_level_type =
4033: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
4034: -- Added Tax Regime and Tax condition for Bug#13397403 --
4035: AND tax_regime_code = ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code
4036: AND tax = ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax
4037: AND tax_provider_id IS NULL
4044: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
4045: 'Variable Values : l_orig_amt = '||TO_CHAR(l_orig_amt)||
4046: ', l_appl_line_amt = ' ||TO_CHAR(l_appl_line_amt)||
4047: ', l_appl_tax_amt = ' ||TO_CHAR(l_appl_tax_amt) ||
4048: ', line_amt = ' ||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) ||
4049: ', applied_doc_tax_line_tax_amt = ' ||TO_CHAR(tax_line_rec.tax_amt)
4050: );
4051: END IF;
4052:
4051: END IF;
4052:
4053: --Bug 16400549, added nvl to l_appl_line_amt, l_appl_tax_amt
4054:
4055: IF l_orig_amt + (NVL(l_appl_line_amt,0) + ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) <= 0 THEN
4056: -- Final Application
4057: IF (tax_line_rec.tax_amt + NVL(l_appl_tax_amt,0) >= 0)
4058: THEN
4059: l_unrounded_tax_amt := sign(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) *
4055: IF l_orig_amt + (NVL(l_appl_line_amt,0) + ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) <= 0 THEN
4056: -- Final Application
4057: IF (tax_line_rec.tax_amt + NVL(l_appl_tax_amt,0) >= 0)
4058: THEN
4059: l_unrounded_tax_amt := sign(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) *
4060: (tax_line_rec.tax_amt + NVL(l_appl_tax_amt,0));
4061: END IF;
4062: END IF;
4063: ELSE
4067: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
4068:
4069: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
4070: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
4071: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
4072: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
4073:
4074: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
4075: NVL(l_unrounded_tax_amt,
4073:
4074: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
4075: NVL(l_unrounded_tax_amt,
4076: Round(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
4077: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
4078: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ), 20));
4079:
4080:
4081: ELSE -- other_doc_line_amt = 0 OR IS NULL
4352:
4353: CURSOR get_tax_lines IS
4354: SELECT * FROM zx_lines
4355: WHERE application_id =
4356: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4357: AND entity_code =
4358: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4359: AND event_class_code =
4360: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4354: SELECT * FROM zx_lines
4355: WHERE application_id =
4356: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4357: AND entity_code =
4358: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4359: AND event_class_code =
4360: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4361: AND trx_id =
4362: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4356: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4357: AND entity_code =
4358: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4359: AND event_class_code =
4360: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4361: AND trx_id =
4362: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4363: AND trx_line_id =
4364: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4358: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4359: AND event_class_code =
4360: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4361: AND trx_id =
4362: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4363: AND trx_line_id =
4364: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4365: p_trx_line_index), trx_line_id)
4366: AND trx_level_type =
4360: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4361: AND trx_id =
4362: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4363: AND trx_line_id =
4364: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4365: p_trx_line_index), trx_line_id)
4366: AND trx_level_type =
4367: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
4368: p_trx_line_index), trx_level_type)
4363: AND trx_line_id =
4364: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4365: p_trx_line_index), trx_line_id)
4366: AND trx_level_type =
4367: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
4368: p_trx_line_index), trx_level_type)
4369: /* Bug 5131206:
4370: For partner integration, when the line_level_action is 'ALLOCATE_TAX_ONLY_ADJUSTMENT',
4371: eBTax needs to create prorated tax lines.
4372: In other cases, partner tax lines should be excluded.
4373: */
4374: -- AND tax_provider_id IS NULL
4375: AND (tax_provider_id IS NULL
4376: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4377: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) = 'ADJUSTMENTS')
4378: AND Cancel_Flag <> 'Y'
4379: --Bug 8493615 AND offset_link_to_tax_line_id IS NULL
4380: AND mrc_tax_line_flag = 'N';
4373: */
4374: -- AND tax_provider_id IS NULL
4375: AND (tax_provider_id IS NULL
4376: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4377: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) = 'ADJUSTMENTS')
4378: AND Cancel_Flag <> 'Y'
4379: --Bug 8493615 AND offset_link_to_tax_line_id IS NULL
4380: AND mrc_tax_line_flag = 'N';
4381:
4390: AND entity_code = p_event_class_rec.entity_code
4391: AND event_class_code = p_event_class_rec.event_class_code
4392: AND trx_id = p_event_class_rec.trx_id
4393: AND trx_line_id =
4394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
4395: AND trx_level_type =
4396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
4397: AND tax_regime_code = c_tax_regime_code
4398: AND tax = c_tax
4392: AND trx_id = p_event_class_rec.trx_id
4393: AND trx_line_id =
4394: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
4395: AND trx_level_type =
4396: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
4397: AND tax_regime_code = c_tax_regime_code
4398: AND tax = c_tax
4399: AND tax_apportionment_line_number = c_apportionment_line_number
4400: AND mrc_tax_line_flag = 'N';
4468:
4469: -- bug 5675944: retain tax_line_id for UPDATE
4470: --
4471: IF p_event_class_rec.tax_event_type_code = 'UPDATE' AND
4472: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) IN ('UPDATE','CREATE_WITH_TAX')
4473: THEN
4474: OPEN get_key_columns_cur(tax_line_rec.tax_regime_code, tax_line_rec.tax,tax_line_rec.tax_apportionment_line_number); -- Bug7597449
4475:
4476: FETCH get_key_columns_cur INTO l_tax_line_rec;
4498: l_tax_line_rec.other_doc_source;
4499: IF p_event_class_rec.allow_manual_lin_recalc_flag ='Y' THEN
4500: IF l_tax_line_rec.line_amt <> 0 THEN
4501: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4502: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4503: (NVL(l_tax_line_rec.unrounded_taxable_amt,l_tax_line_rec.taxable_amt) / l_tax_line_rec.line_amt);
4504: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4505: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4506: (NVL(l_tax_line_rec.unrounded_tax_amt,l_tax_line_rec.tax_amt) / l_tax_line_rec.line_amt );
4501: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4502: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4503: (NVL(l_tax_line_rec.unrounded_taxable_amt,l_tax_line_rec.taxable_amt) / l_tax_line_rec.line_amt);
4504: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4505: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4506: (NVL(l_tax_line_rec.unrounded_tax_amt,l_tax_line_rec.tax_amt) / l_tax_line_rec.line_amt );
4507: ELSE
4508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4509: := NVL(l_tax_line_rec.unrounded_taxable_amt,l_tax_line_rec.taxable_amt);
4727:
4728: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4729: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
4730:
4731: if((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4732: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) = 'ADJUSTMENTS') and
4733: tax_line_rec.tax_provider_id is not null ) THEN
4734: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
4735: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4728: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4729: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
4730:
4731: if((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4732: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index) = 'ADJUSTMENTS') and
4733: tax_line_rec.tax_provider_id is not null ) THEN
4734: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
4735: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4736: l_new_row_num).global_attribute_category := tax_line_rec.global_attribute_category;
4788: tax_line_rec.hq_estb_party_tax_prof_id;
4789:
4790: -- If line_amt_include_tax_flag on trx line is A, then set to 'Y'
4791: -- for other cases, set to the one from adjusted doc.
4792: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
4793: p_trx_line_index) = 'A'
4794: THEN
4795: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4796: l_new_row_num).tax_amt_included_flag := 'Y';
4805:
4806: IF NVL(l_cm_manual_flag, 'N') = 'N' THEN
4807: IF NVL(tax_line_rec.historical_flag, 'N') = 'Y' THEN
4808:
4809: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
4810: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4811: THEN
4812:
4813: -- for tax only adjustment set the unrounded tax amount to the
4828: -- If current trx is a tax inclusive trx, while the original trx is
4829: -- tax exclusive trx.
4830:
4831: -- If-Else Condition added for Bug#8540809
4832: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4833: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4834: -- Added condition for Bug#13593659
4835: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4836: THEN
4829: -- tax exclusive trx.
4830:
4831: -- If-Else Condition added for Bug#8540809
4832: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4833: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4834: -- Added condition for Bug#13593659
4835: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4836: THEN
4837: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4831: -- If-Else Condition added for Bug#8540809
4832: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4833: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4834: -- Added condition for Bug#13593659
4835: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4836: THEN
4837: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4838: l_new_row_num).unrounded_taxable_amt
4839: := tax_line_rec.unrounded_taxable_amt;
4844: ELSE
4845: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
4846: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4847: l_new_row_num).unrounded_taxable_amt
4848: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4849: ( NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) /
4850: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4851:
4852: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4850: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4851:
4852: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4853: l_new_row_num).unrounded_tax_amt
4854: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4855: (NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt) /
4856: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4857: ELSE
4858: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4872: tax_line_rec.unrounded_tax_amt := tax_line_rec.line_amt * tax_line_rec.tax_rate / (100 + tax_line_rec.tax_rate);
4873: END IF;
4874: IF tax_line_rec.line_amt <> 0 THEN
4875: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4876: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4877: (NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) / tax_line_rec.line_amt);
4878:
4879: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4880: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4876: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4877: (NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) / tax_line_rec.line_amt);
4878:
4879: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4880: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4881: (NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt) / tax_line_rec.line_amt );
4882: ELSE -- equal to that the original trx is a tax only trx
4883: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
4884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4879: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4880: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4881: (NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt) / tax_line_rec.line_amt );
4882: ELSE -- equal to that the original trx is a tax only trx
4883: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
4884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4885: := -1 * NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt);
4886: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4887: := -1 * NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt);
4895: END IF; -- tax_line_rec.tax_amt_included_flag = 'N'
4896:
4897: END IF; -- 'ALLOCATE_TAX_ONLY_ADJUSTMENT' trx and else
4898: ELSE -- Historical Flag is 'N'
4899: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
4900: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4901: THEN
4902:
4903: -- for tax only adjustment set the unrounded tax amount to the
4918: -- If current trx is a tax inclusive trx, while the original trx is
4919: -- tax exclusive trx.
4920:
4921: -- If-Else Condition added for Bug#8540809
4922: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4924: -- Added condition for Bug#13593659
4925: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4926: THEN
4919: -- tax exclusive trx.
4920:
4921: -- If-Else Condition added for Bug#8540809
4922: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4924: -- Added condition for Bug#13593659
4925: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4926: THEN
4927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4921: -- If-Else Condition added for Bug#8540809
4922: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_trx_line_index) IS NOT NULL AND
4923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_hdr_tx_appl_flag(p_trx_line_index) = 'Y') OR
4924: -- Added condition for Bug#13593659
4925: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_trx_line_index) IS NOT NULL
4926: THEN
4927: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4928: l_new_row_num).unrounded_taxable_amt
4929: := tax_line_rec.unrounded_taxable_amt;
4933: ELSE
4934: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
4935: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4936: l_new_row_num).unrounded_taxable_amt
4937: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4938: ( tax_line_rec.unrounded_taxable_amt /
4939: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4941: l_new_row_num).unrounded_tax_amt
4938: ( tax_line_rec.unrounded_taxable_amt /
4939: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4940: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4941: l_new_row_num).unrounded_tax_amt
4942: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4943: ( tax_line_rec.unrounded_tax_amt /
4944: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4945: ELSE
4946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4953: END IF;
4954: ELSE -- both current tax line and original tax line are inclusive and exclusive
4955: IF tax_line_rec.line_amt <> 0 THEN
4956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4957: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4958: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
4959:
4960: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4961: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4957: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4958: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
4959:
4960: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4961: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4962: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
4963: ELSE -- equal to that the original trx is a tax only trx
4964: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
4965: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4960: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4961: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4962: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
4963: ELSE -- equal to that the original trx is a tax only trx
4964: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
4965: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4966: := -1 * tax_line_rec.unrounded_taxable_amt;
4967: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4968: := -1 * tax_line_rec.unrounded_tax_amt;
5000:
5001: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
5002: l_new_row_num).tax_amt_included_flag = 'Y' THEN
5003:
5004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
5005: p_trx_line_index) := 'Y';
5006: END IF;
5007:
5008: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
5007:
5008: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
5009: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
5010:
5011: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
5012: p_trx_line_index) := 'Y';
5013: END IF;
5014:
5015: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
5277: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
5278: --FND_MSG_PUB.Add;
5279:
5280: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5281: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5283: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5284:
5285: ZX_API_PUB.add_msg(
5279:
5280: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5281: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5283: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5284:
5285: ZX_API_PUB.add_msg(
5286: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5287:
5311: -- TCM procedure called in get_pos_parameter_name will set the error msg
5312: -- here we just need to populate the context information.
5313:
5314: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5315: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5316: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5317: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5318:
5319: ZX_API_PUB.add_msg(
5313:
5314: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5315: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5316: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5317: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5318:
5319: ZX_API_PUB.add_msg(
5320: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5321:
5373: -- TCM procedure called in get_pos_parameter_name will set the error msg
5374: -- here we just need to populate the context information.
5375:
5376: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5377: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5379: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5380:
5381: ZX_API_PUB.add_msg(
5375:
5376: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5377: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5378: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5379: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5380:
5381: ZX_API_PUB.add_msg(
5382: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5383:
5441: -- populate the trx line context info if jurisdiction API return error
5442: -- jurisdiction API should have populated the error message name and text.
5443:
5444: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5445: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5446: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5447: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5448:
5449: ZX_API_PUB.add_msg(
5443:
5444: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5445: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5446: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5447: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5448:
5449: ZX_API_PUB.add_msg(
5450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5451:
5474: FND_MESSAGE.SET_TOKEN('POS_TYPE', l_pos_type);
5475: -- FND_MSG_PUB.Add;
5476:
5477: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5478: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5479: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5480: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5481:
5482: ZX_API_PUB.add_msg(
5476:
5477: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
5478: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
5479: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
5480: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
5481:
5482: ZX_API_PUB.add_msg(
5483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5484: */
6839: CURSOR get_chart_of_accts_id_csr IS
6840: SELECT chart_of_accounts_id
6841: FROM gl_sets_of_books
6842: WHERE set_of_books_id =
6843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ledger_id(p_trx_line_index);
6844:
6845: CURSOR get_default_jurisdiction_csr(c_tax_regime_code VARCHAR2, c_tax VARCHAR2) IS
6846: SELECT tax_jurisdiction_id,
6847: tax_jurisdiction_code
6902: zx_sco_taxes zxt,
6903: fnd_lookups lc
6904: WHERE zxtr.content_owner_id = p_event_class_rec.first_pty_org_id
6905: AND zxtr.ledger_id =
6906: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ledger_id(p_trx_line_index)
6907: AND zxtr.account_segment_value= c_account_seg_value
6908: AND zxt.tax_regime_code = zxtr.tax_regime_code
6909: AND zxt.tax = zxtr.tax
6910: AND zxt.tax_type_code = lc.lookup_code
6937: l_end_index BINARY_INTEGER;
6938: l_begin_index_from_acct BINARY_INTEGER;
6939: l_end_index_from_acct BINARY_INTEGER;
6940:
6941: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6942: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6943: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6944:
6945: l_jurisdiction_id NUMBER;
6968: l_tax_class := 'INPUT';
6969: END IF;
6970:
6971: l_account_ccid :=
6972: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_ccid(p_trx_line_index);
6973: l_account_string :=
6974: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_string(p_trx_line_index);
6975:
6976: -- get chart_of_account_id
6970:
6971: l_account_ccid :=
6972: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_ccid(p_trx_line_index);
6973: l_account_string :=
6974: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_string(p_trx_line_index);
6975:
6976: -- get chart_of_account_id
6977: --
6978: OPEN get_chart_of_accts_id_csr;
7078:
7079: -- Get detail tax lines from account
7080: --
7081: l_trx_line_id :=
7082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
7083: l_trx_level_type :=
7084: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
7085:
7086: FOR l_tax_rec IN get_det_tax_lines_frm_acct_csr(l_account_seg_value) LOOP
7080: --
7081: l_trx_line_id :=
7082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
7083: l_trx_level_type :=
7084: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
7085:
7086: FOR l_tax_rec IN get_det_tax_lines_frm_acct_csr(l_account_seg_value) LOOP
7087:
7088: l_tax_tbl_subscript := NULL;
7440: -- populate hq_estb_party_tax_prof_id
7441: --
7442: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7443: l_new_row_num).hq_estb_party_tax_prof_id :=
7444: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
7445: p_trx_line_index);
7446:
7447: -- bug 5077691: populate legal_reporting_status
7448: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7577: CURSOR get_taxes_f_intercomp_trx_csr IS
7578: SELECT zxl.*
7579: FROM zx_lines zxl, zx_evnt_cls_mappings map
7580: WHERE map.application_id =
7581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7582: AND map.entity_code =
7583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7584: AND map.event_class_code =
7585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7579: FROM zx_lines zxl, zx_evnt_cls_mappings map
7580: WHERE map.application_id =
7581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7582: AND map.entity_code =
7583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7584: AND map.event_class_code =
7585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7586: AND zxl.application_id = map.intrcmp_src_appln_id
7587: AND zxl.entity_code = map.intrcmp_src_entity_code
7581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7582: AND map.entity_code =
7583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7584: AND map.event_class_code =
7585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7586: AND zxl.application_id = map.intrcmp_src_appln_id
7587: AND zxl.entity_code = map.intrcmp_src_entity_code
7588: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7589: 'INTERCOMPANY_TRX', zxl.event_class_code,
7584: AND map.event_class_code =
7585: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7586: AND zxl.application_id = map.intrcmp_src_appln_id
7587: AND zxl.entity_code = map.intrcmp_src_entity_code
7588: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7589: 'INTERCOMPANY_TRX', zxl.event_class_code,
7590: /* decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index),
7591: 'AP_CREDIT_MEMO', 'CREDIT_MEMO',
7592: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7586: AND zxl.application_id = map.intrcmp_src_appln_id
7587: AND zxl.entity_code = map.intrcmp_src_entity_code
7588: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7589: 'INTERCOMPANY_TRX', zxl.event_class_code,
7590: /* decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index),
7591: 'AP_CREDIT_MEMO', 'CREDIT_MEMO',
7592: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7593: map.intrcmp_src_evnt_cls_code), */ -- Bug9587918
7594: map.intrcmp_src_evnt_cls_code)
7592: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7593: map.intrcmp_src_evnt_cls_code), */ -- Bug9587918
7594: map.intrcmp_src_evnt_cls_code)
7595: AND zxl.trx_id =
7596: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7597: AND zxl.trx_line_id =
7598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7599: AND zxl.trx_level_type =
7600: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7594: map.intrcmp_src_evnt_cls_code)
7595: AND zxl.trx_id =
7596: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7597: AND zxl.trx_line_id =
7598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7599: AND zxl.trx_level_type =
7600: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7601: AND zxl.tax_provider_id IS NULL
7602: AND zxl.cancel_flag <> 'Y'
7596: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7597: AND zxl.trx_line_id =
7598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7599: AND zxl.trx_level_type =
7600: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7601: AND zxl.tax_provider_id IS NULL
7602: AND zxl.cancel_flag <> 'Y'
7603: AND zxl.mrc_tax_line_flag = 'N';
7604:
7655: AND active_flag = 'Y'
7656: AND tax_class <> 'INPUT'
7657: ORDER BY subscription_level_code;
7658:
7659: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7660: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7661: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7662: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7663: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
7714: l_rownum).tax_line_id := NULL;
7715: --Bug 9701132
7716: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
7717: l_rownum).hq_estb_party_tax_prof_id :=
7718: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(p_trx_line_index);
7719: --End Bug 9701132
7720: OPEN is_tax_migrated_in_ar_csr(tax_line_rec.tax_rate_id);
7721:
7722: FETCH is_tax_migrated_in_ar_csr INTO l_tax_regime_code, l_tax,
7949:
7950: FND_MESSAGE.SET_NAME('ZX','ZX_INTER_COMP_RATE');
7951:
7952: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
7953: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
7954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
7955: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
7956: ZX_API_PUB.add_msg(
7957: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
7951:
7952: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
7953: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
7954: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
7955: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
7956: ZX_API_PUB.add_msg(
7957: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
7958:
7959: IF (g_level_statement >= g_current_runtime_level ) THEN
8778: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8779: l_tax_regime_code_tbl tax_regime_code_tbl;
8780: l_tax_tbl tax_tbl;
8781: l_result_id_tbl result_id_tbl;
8782: l_query_num_tbl ZX_GLOBAL_STRUCTURES_PKG.NUMBER_tbl_type;
8783: l_status_result_tbl status_result_tbl;
8784: l_rate_result_tbl rate_result_tbl;
8785: l_condition_set_tbl condition_set_tbl;
8786: l_exception_set_tbl exception_set_tbl;
8785: l_condition_set_tbl condition_set_tbl;
8786: l_exception_set_tbl exception_set_tbl;
8787: l_counter NUMBER;
8788: i NUMBER;
8789: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8790: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8791: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8792: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8793: l_error_buffer VARCHAR2(200);
8838:
8839: x_return_status := FND_API.G_RET_STS_SUCCESS;
8840:
8841: l_tax_classification_code :=
8842: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8844:
8845: l_internal_organization_id :=
8846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8839: x_return_status := FND_API.G_RET_STS_SUCCESS;
8840:
8841: l_tax_classification_code :=
8842: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8844:
8845: l_internal_organization_id :=
8846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8847:
8842: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8843: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8844:
8845: l_internal_organization_id :=
8846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8847:
8848: l_condition_group_code := l_tax_classification_code;
8849:
8850: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
8853: l_tax_class := 'INPUT';
8854: END IF;
8855:
8856: l_trx_line_id :=
8857: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
8858: l_trx_level_type :=
8859: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8860:
8861: IF l_tax_classification_code IS NOT NULL THEN
8855:
8856: l_trx_line_id :=
8857: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
8858: l_trx_level_type :=
8859: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8860:
8861: IF l_tax_classification_code IS NOT NULL THEN
8862: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8863: p_trx_line_index) = 'CREATE' OR
8858: l_trx_level_type :=
8859: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8860:
8861: IF l_tax_classification_code IS NOT NULL THEN
8862: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8863: p_trx_line_index) = 'CREATE' OR
8864: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8865: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8866: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8860:
8861: IF l_tax_classification_code IS NOT NULL THEN
8862: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8863: p_trx_line_index) = 'CREATE' OR
8864: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8865: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8866: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8867: p_trx_line_index) = 'UPDATE' OR
8868: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8862: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8863: p_trx_line_index) = 'CREATE' OR
8864: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8865: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8866: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8867: p_trx_line_index) = 'UPDATE' OR
8868: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8869: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8870: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8864: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8865: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8866: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8867: p_trx_line_index) = 'UPDATE' OR
8868: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8869: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8870: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8871: p_trx_line_index) = 'COPY_AND_CREATE'
8872: THEN
8866: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8867: p_trx_line_index) = 'UPDATE' OR
8868: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8869: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8870: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8871: p_trx_line_index) = 'COPY_AND_CREATE'
8872: THEN
8873:
8874:
9718:
9719: END IF; --l_rate_result_tbl(j) IS NOT NULL
9720:
9721: -- >> Update call
9722: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index)='UPDATE') AND
9723: NOT l_ref_doc_tax_applicable -- Added for Bug 10184087
9724: THEN
9725: handle_update_scenarios(p_trx_line_index,
9726: p_event_class_rec,
9795: -- stamp trx_level_type and trx_line_id, since they are used for
9796: -- tax line index checking.
9797: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9798: l_rownum).trx_level_type :=
9799: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
9800:
9801: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9802: l_rownum).trx_line_id :=
9803: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9799: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
9800:
9801: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9802: l_rownum).trx_line_id :=
9803: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9804:
9805: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
9806: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
9807: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
9850: l_place_of_supply_result_id;
9851: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9852: l_rownum).legal_message_pos :=
9853: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_place_of_supply_result_id,
9854: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index));
9855: -- Populate direct_rate_rule_flag, as well as tax_status_code
9856: -- and tax_rate_code if direct_rate is applicable.
9857: --
9858: IF NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9866: l_rownum).tax_rate_code := l_rate_result_tbl(j);
9867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9868: l_rownum).legal_message_rate :=
9869: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_result_id_tbl(j),
9870: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index));
9871: END IF;
9872:
9873: --bug6604498
9874: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9891: -- populate hq_estb_party_tax_prof_id
9892: --
9893: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9894: l_rownum).hq_estb_party_tax_prof_id :=
9895: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
9896: p_trx_line_index);
9897:
9898: -- populate tax registration info
9899: --
9957: l_rownum).self_assessed_flag := 'N';
9958: END IF;
9959:
9960: -- bug#8592720
9961: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9962: p_trx_line_index) = 'CREATE_TAX_ONLY') THEN
9963:
9964: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9965: l_rownum).tax_only_line_flag := 'Y';
9975: -- Bug 5705976: Since, we stamp 'INTERCOMPANY_TRX' on both AR and AP
9976: -- transactions, the following code has become incorrect.
9977: --
9978: /*
9979: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9980: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
9981: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
9982: p_trx_line_index) = 'INTERCOMPANY_TRX'
9983: THEN
9977: --
9978: /*
9979: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9980: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
9981: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
9982: p_trx_line_index) = 'INTERCOMPANY_TRX'
9983: THEN
9984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9985: l_rownum).self_assessed_flag := 'Y';
9991: --
9992: -- Bug#5440023- do not poplate detail_tax_regime_tbl
9993: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
9994: --
9995: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
9996: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' )
9997: THEN
9998: l_regimerownum :=
9999: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
9992: -- Bug#5440023- do not poplate detail_tax_regime_tbl
9993: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
9994: --
9995: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
9996: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' )
9997: THEN
9998: l_regimerownum :=
9999: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
10000:
9995: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
9996: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' )
9997: THEN
9998: l_regimerownum :=
9999: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
10000:
10001: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10002: l_regimerownum).trx_line_index := p_trx_line_index;
10003: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9997: THEN
9998: l_regimerownum :=
9999: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
10000:
10001: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10002: l_regimerownum).trx_line_index := p_trx_line_index;
10003: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10004: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
10005: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9999: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
10000:
10001: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10002: l_regimerownum).trx_line_index := p_trx_line_index;
10003: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10004: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
10005: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10006: l_regimerownum).tax_regime_precedence :=
10007: l_tax_regime_rec.tax_regime_precedence;
10001: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10002: l_regimerownum).trx_line_index := p_trx_line_index;
10003: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10004: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
10005: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
10006: l_regimerownum).tax_regime_precedence :=
10007: l_tax_regime_rec.tax_regime_precedence;
10008:
10009: END IF;
10062: -- trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index) IS NOT NULL,
10063: -- get tax rate code from refefence document
10064: --
10065: IF p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
10066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
10067: p_trx_line_index) IS NOT NULL
10068: THEN
10069:
10070: enforce_tax_from_ref_doc(
10212: AND entity_code = p_event_class_rec.entity_code
10213: AND event_class_code = p_event_class_rec.event_class_code
10214: AND trx_id = p_event_class_rec.trx_id
10215: AND trx_line_id =
10216: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
10217: AND trx_level_type =
10218: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
10219: AND tax_regime_code = p_tax_regime_code
10220: AND tax = p_tax
10214: AND trx_id = p_event_class_rec.trx_id
10215: AND trx_line_id =
10216: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
10217: AND trx_level_type =
10218: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
10219: AND tax_regime_code = p_tax_regime_code
10220: AND tax = p_tax
10221: AND mrc_tax_line_flag = 'N'
10222: AND tax_apportionment_line_number > 0
10344:
10345:
10346: IF p_event_class_rec.prod_family_grp_code = 'P2P' THEN
10347: l_current_line_amt :=
10348: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
10349:
10350: IF l_tax_line_rec.line_amt <> 0 AND
10351: l_tax_line_rec.line_amt <> l_current_line_amt THEN
10352:
10714:
10715: -- prorate tax amount and taxable amount
10716: --
10717: l_current_line_amt :=
10718: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(
10719: p_trx_line_index);
10720:
10721: IF l_tax_line_rec.line_amt <> 0 THEN
10722: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
10832: tax_apportionment_line_number
10833: -- nipatel bug 6648042
10834: FROM zx_lines
10835: WHERE application_id =
10836: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10837: AND event_class_code =
10838: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10839: AND entity_code =
10840: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10834: FROM zx_lines
10835: WHERE application_id =
10836: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10837: AND event_class_code =
10838: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10839: AND entity_code =
10840: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10841: AND trx_id =
10842: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10836: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10837: AND event_class_code =
10838: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10839: AND entity_code =
10840: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10841: AND trx_id =
10842: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10843: AND trx_line_id =
10844: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10838: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10839: AND entity_code =
10840: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10841: AND trx_id =
10842: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10843: AND trx_line_id =
10844: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10845: AND trx_level_type =
10846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10840: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10841: AND trx_id =
10842: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10843: AND trx_line_id =
10844: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10845: AND trx_level_type =
10846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10847: AND tax_regime_code = c_tax_regime_code
10848: AND tax = c_tax
10842: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10843: AND trx_line_id =
10844: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10845: AND trx_level_type =
10846: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10847: AND tax_regime_code = c_tax_regime_code
10848: AND tax = c_tax
10849: AND cancel_flag <> 'Y'
10850: AND mrc_tax_line_flag = 'N';