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'
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'
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
1313: --bug#7695189
1314: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1315: -- l_rownum).summary_tax_line_id := NULL;
1316:
1317: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1318: p_trx_line_index) <> 'OVERRIDE_TAX' AND
1319: NVL(tax_line_rec.associated_child_frozen_flag, 'N') = 'Y'
1320: THEN
1321:
1353: x_begin_index := l_rownum;
1354: END IF;
1355: END LOOP; -- tax_line_rec IN get_all_tax_lines_migrated
1356:
1357: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1358: p_trx_line_index) = 'OVERRIDE_TAX'
1359: THEN
1360:
1361: -- For OVERRIDE_TAX
1360:
1361: -- For OVERRIDE_TAX
1362: --
1363:
1364: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1365: p_trx_line_index), 'N') = 'N' AND
1366: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1367: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1368: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1364: IF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1365: p_trx_line_index), 'N') = 'N' AND
1366: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1367: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1368: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1369: p_trx_line_index), 'N') = 'N'))
1370: THEN
1371:
1372: -- For OVERRIDE_TAX, fetch all tax lines with recalc_required_flag = 'Y'.
1512: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1513:
1514: END LOOP;
1515:
1516: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1517: p_trx_line_index), 'N') = 'N' AND
1518: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1519: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1520: p_trx_line_index), 'N') = 'Y')
1515:
1516: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1517: p_trx_line_index), 'N') = 'N' AND
1518: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1519: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1520: p_trx_line_index), 'N') = 'Y')
1521: THEN
1522:
1523: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1614: END IF;
1615: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1616:
1617: END LOOP;
1618: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1619: p_trx_line_index), 'N') = 'Y' AND
1620: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1621: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1622: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1618: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1619: p_trx_line_index), 'N') = 'Y' AND
1620: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'N' OR
1621: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1622: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1623: p_trx_line_index), 'N') = 'N'))
1624: THEN
1625:
1626: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1718: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1719:
1720: END LOOP;
1721:
1722: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1723: p_trx_line_index), 'N') = 'Y' AND
1724: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1725: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1726: p_trx_line_index), 'N') = 'Y')
1721:
1722: ELSIF NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1723: p_trx_line_index), 'N') = 'Y' AND
1724: (p_event_class_rec.ctrl_eff_ovrd_calc_lines_flag = 'Y' AND
1725: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1726: p_trx_line_index), 'N') = 'Y')
1727: THEN
1728:
1729: -- For OVERRIDE_TAX, Need to fetch all tax lines with
1821: END IF; -- last_manual_entry NOT IN ('TAX_AMOUNT', 'TAX_RATE')
1822:
1823: END LOOP;
1824: END IF;
1825: ELSIF ((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1826: p_trx_line_index) = 'UPDATE')
1827: OR
1828: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1829: p_trx_line_index) ='UPDATE' AND
1824: END IF;
1825: ELSIF ((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1826: p_trx_line_index) = 'UPDATE')
1827: OR
1828: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1829: p_trx_line_index) ='UPDATE' AND
1830: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1831: p_trx_line_index) = 'LINE_INFO_TAX_ONLY')) THEN -- Bug 5291394
1832:
1826: p_trx_line_index) = 'UPDATE')
1827: OR
1828: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(
1829: p_trx_line_index) ='UPDATE' AND
1830: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1831: p_trx_line_index) = 'LINE_INFO_TAX_ONLY')) THEN -- Bug 5291394
1832:
1833: -- For Update
1834: --
2072: --
2073: IF p_event_class_rec.allow_manual_lin_recalc_flag ='Y' THEN
2074:
2075: l_current_line_amt :=
2076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt( p_trx_line_index);
2077:
2078: IF tax_line_rec.line_amt <> 0 THEN
2079: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2080: l_rownum).unrounded_tax_amt :=
2181: END IF;
2182:
2183: --Besides update action, also need to populate the trx line info onto tax lines for
2184: --manually entered tax lines.
2185: --IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2186: -- p_trx_line_index) = 'UPDATE' THEN
2187: -- copy transaction info to manual tax lines
2188: --
2189: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
2423: AND entity_code = p_event_class_rec.entity_code
2424: AND event_class_code = p_event_class_rec.event_class_code
2425: AND trx_id = p_event_class_rec.trx_id
2426: AND trx_line_id =
2427: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
2428: AND trx_level_type =
2429: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
2430: AND tax_regime_code = p_tax_regime_code
2431: AND tax = p_tax
2425: AND trx_id = p_event_class_rec.trx_id
2426: AND trx_line_id =
2427: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
2428: AND trx_level_type =
2429: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
2430: AND tax_regime_code = p_tax_regime_code
2431: AND tax = p_tax
2432: AND mrc_tax_line_flag = 'N';
2433:
2440: tax_amt,
2441: taxable_amt
2442: FROM zx_lines
2443: WHERE application_id =
2444: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2445: AND event_class_code =
2446: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2447: AND entity_code =
2448: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2442: FROM zx_lines
2443: WHERE application_id =
2444: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2445: AND event_class_code =
2446: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2447: AND entity_code =
2448: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2449: AND trx_id =
2450: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2444: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2445: AND event_class_code =
2446: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2447: AND entity_code =
2448: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2449: AND trx_id =
2450: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2451: AND trx_line_id =
2452: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2446: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2447: AND entity_code =
2448: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2449: AND trx_id =
2450: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2451: AND trx_line_id =
2452: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2453: AND trx_level_type =
2454: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2448: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
2449: AND trx_id =
2450: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2451: AND trx_line_id =
2452: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2453: AND trx_level_type =
2454: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2455: AND tax_regime_code = c_tax_regime_code
2456: AND tax = c_tax
2450: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
2451: AND trx_line_id =
2452: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
2453: AND trx_level_type =
2454: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
2455: AND tax_regime_code = c_tax_regime_code
2456: AND tax = c_tax
2457: AND cancel_flag <> 'Y'
2458: AND mrc_tax_line_flag = 'N';
2498: l_tax_class := 'INPUT';
2499: END IF;
2500:
2501: l_trx_line_id :=
2502: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
2503: l_trx_level_type :=
2504: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
2505:
2506: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2500:
2501: l_trx_line_id :=
2502: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
2503: l_trx_level_type :=
2504: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
2505:
2506: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2507: -- init_for_line in the wrapper
2508:
2505:
2506: -- bugfix 5024740: move delete from jurisdictions gt to init_for_header and
2507: -- init_for_line in the wrapper
2508:
2509: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2510: p_trx_line_index) = 'CREATE' OR
2511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2512: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2507: -- init_for_line in the wrapper
2508:
2509: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2510: p_trx_line_index) = 'CREATE' OR
2511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2512: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2514: p_trx_line_index) = 'UPDATE' OR
2515: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2509: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2510: p_trx_line_index) = 'CREATE' OR
2511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2512: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2514: p_trx_line_index) = 'UPDATE' OR
2515: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2516: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2517: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2511: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2512: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2514: p_trx_line_index) = 'UPDATE' OR
2515: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2516: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2517: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2518: p_trx_line_index) = 'COPY_AND_CREATE'
2519: THEN
2513: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2514: p_trx_line_index) = 'UPDATE' OR
2515: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2516: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
2517: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2518: p_trx_line_index) = 'COPY_AND_CREATE'
2519: THEN
2520:
2521: FOR l_tax_rec IN get_all_taxes_for_regime_cur LOOP
2619: --
2620: -- Bug 4277751: For intercompany transaction, need to pull in detail
2621: -- tax lines from source documnet.
2622: --
2623: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2624: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2625: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2626: p_trx_line_index) = 'UPDATE' OR
2627: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2621: -- tax lines from source documnet.
2622: --
2623: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2624: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2625: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2626: p_trx_line_index) = 'UPDATE' OR
2627: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2628: p_trx_line_index) IN ('CREATE', 'UPDATE')
2629: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2623: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2624: p_trx_line_index) = 'CREATE_WITH_TAX' OR
2625: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2626: p_trx_line_index) = 'UPDATE' OR
2627: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2628: p_trx_line_index) IN ('CREATE', 'UPDATE')
2629: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2630: p_trx_line_index) = 'INTERCOMPANY_TRX')
2631: THEN
2625: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2626: p_trx_line_index) = 'UPDATE' OR
2627: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2628: p_trx_line_index) IN ('CREATE', 'UPDATE')
2629: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
2630: p_trx_line_index) = 'INTERCOMPANY_TRX')
2631: THEN
2632: -- Check if this tax line exists in the new created applicable tax lines
2633: --
2952: IF (x_begin_index is null) THEN
2953: x_begin_index := l_new_row_num;
2954: END IF;
2955:
2956: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2957: p_trx_line_index)='UPDATE') THEN
2958:
2959: -- Bug 4959835. Moved the code to a private procedure.
2960: handle_update_scenarios( p_trx_line_index,
3166: -- populate hq_estb_party_tax_prof_id
3167: --
3168: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3169: l_new_row_num).hq_estb_party_tax_prof_id :=
3170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
3171: p_trx_line_index);
3172:
3173: -- populate tax registration info
3174: --
3238: -- Bug 5705976: Since, we stamp 'INTERCOMPANY_TRX' on both AR and AP
3239: -- transactions, the following code has become incorrect.
3240: --
3241: /*
3242: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3243: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
3244: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
3245: p_trx_line_index) = 'INTERCOMPANY_TRX'
3246: THEN
3240: --
3241: /*
3242: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3243: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
3244: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
3245: p_trx_line_index) = 'INTERCOMPANY_TRX'
3246: THEN
3247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3248: l_new_row_num).self_assessed_flag := 'Y';
3272: /* Move to ZX_TDS_TAXABLE_BASIS_DETM_PKG
3273: *
3274: * -- Populate tax_inclusion_flag and line_amt_includes_tax_flag
3275: * --
3276: * IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3277: * p_trx_line_index) = 'A') THEN
3278: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3279: * l_new_row_num).tax_amt_included_flag := 'Y';
3280: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3279: * l_new_row_num).tax_amt_included_flag := 'Y';
3280: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3281: * l_new_row_num).line_amt_includes_tax_flag := 'A';
3282: *
3283: * ELSIF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3284: * p_trx_line_index) = 'N') THEN
3285: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3286: * l_new_row_num).tax_amt_included_flag := 'N';
3287: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3286: * l_new_row_num).tax_amt_included_flag := 'N';
3287: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3288: * l_new_row_num).line_amt_includes_tax_flag := 'N';
3289: *
3290: * ELSIF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3291: * p_trx_line_index) IN ('S', 'I')) THEN
3292: * -- Remain the value of tax_inclusion_flag returned by
3293: * -- get_tax_regostration and set line_amt_includes_tax_flag to 'STANDARD'
3294: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3297: * END IF;
3298: */
3299: -- populate Tax_Only_Line_Flag if line_level_action is 'CREATE_TAX_ONLY'
3300: --
3301: IF (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3302: p_trx_line_index) = 'CREATE_TAX_ONLY') THEN
3303:
3304: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3305: l_new_row_num).tax_only_line_flag := 'Y';
3317: -- trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index) IS NOT NULL,
3318: -- get tax rate code from refefence document
3319: --
3320: IF p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
3321: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
3322: p_trx_line_index) IS NOT NULL
3323: THEN
3324:
3325: enforce_tax_from_ref_doc(
3480:
3481: CURSOR get_tax_lines IS
3482: SELECT * FROM zx_lines
3483: WHERE application_id =
3484: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3485: AND entity_code =
3486: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3487: AND event_class_code =
3488: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3482: SELECT * FROM zx_lines
3483: WHERE application_id =
3484: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3485: AND entity_code =
3486: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3487: AND event_class_code =
3488: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3489: AND trx_id =
3490: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3484: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3485: AND entity_code =
3486: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3487: AND event_class_code =
3488: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3489: AND trx_id =
3490: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3491: AND trx_line_id =
3492: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3486: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3487: AND event_class_code =
3488: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3489: AND trx_id =
3490: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3491: AND trx_line_id =
3492: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3493: AND trx_level_type =
3494: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3488: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
3489: AND trx_id =
3490: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3491: AND trx_line_id =
3492: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3493: AND trx_level_type =
3494: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3495: AND tax_provider_id IS NULL
3496: AND Cancel_Flag<> 'Y'
3490: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
3491: AND trx_line_id =
3492: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
3493: AND trx_level_type =
3494: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
3495: AND tax_provider_id IS NULL
3496: AND Cancel_Flag<> 'Y'
3497: AND offset_link_to_tax_line_id IS NULL
3498: AND mrc_tax_line_flag = 'N';
3641: FND_MESSAGE.SET_NAME('ZX','ZX_STATUS_NOT_FOUND');
3642: FND_MESSAGE.SET_TOKEN('TAX',tax_line_rec.tax);
3643:
3644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3645: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
3646: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
3647: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
3648:
3649: ZX_API_PUB.add_msg(
3643:
3644: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3645: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
3646: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
3647: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
3648:
3649: ZX_API_PUB.add_msg(
3650: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
3651:
3707: -- prorate prd_total_tax_amt, prd_total_tax_amt_tax_curr and
3708: -- prd_total_tax_amt_funcl_curr
3709: --
3710: l_line_amt_current :=
3711: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
3712:
3713: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3714: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
3715: (l_line_amt_current/tax_line_rec.line_amt);
3817: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
3818:
3819: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
3820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
3821: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
3822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
3823:
3824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
3825:
3823:
3824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
3825:
3826: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
3827: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
3828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
3829:
3830:
3831: ELSE -- other_doc_line_amt = 0 OR IS NULL
4032:
4033: CURSOR get_tax_lines IS
4034: SELECT * FROM zx_lines
4035: WHERE application_id =
4036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4037: AND entity_code =
4038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4039: AND event_class_code =
4040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4034: SELECT * FROM zx_lines
4035: WHERE application_id =
4036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4037: AND entity_code =
4038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4039: AND event_class_code =
4040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4041: AND trx_id =
4042: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4037: AND entity_code =
4038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4039: AND event_class_code =
4040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4041: AND trx_id =
4042: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4043: AND trx_line_id =
4044: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4039: AND event_class_code =
4040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4041: AND trx_id =
4042: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4043: AND trx_line_id =
4044: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4045: p_trx_line_index), trx_line_id)
4046: AND trx_level_type =
4040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
4041: AND trx_id =
4042: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
4043: AND trx_line_id =
4044: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4045: p_trx_line_index), trx_line_id)
4046: AND trx_level_type =
4047: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
4048: p_trx_line_index), trx_level_type)
4043: AND trx_line_id =
4044: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
4045: p_trx_line_index), trx_line_id)
4046: AND trx_level_type =
4047: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
4048: p_trx_line_index), trx_level_type)
4049: /* Bug 5131206:
4050: For partner integration, when the line_level_action is 'ALLOCATE_TAX_ONLY_ADJUSTMENT',
4051: eBTax needs to create prorated tax lines.
4052: In other cases, partner tax lines should be excluded.
4053: */
4054: -- AND tax_provider_id IS NULL
4055: AND (tax_provider_id IS NULL
4056: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')
4057: AND Cancel_Flag <> 'Y'
4058: AND offset_link_to_tax_line_id IS NULL
4059: AND mrc_tax_line_flag = 'N';
4060:
4069: AND entity_code = p_event_class_rec.entity_code
4070: AND event_class_code = p_event_class_rec.event_class_code
4071: AND trx_id = p_event_class_rec.trx_id
4072: AND trx_line_id =
4073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
4074: AND trx_level_type =
4075: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
4076: AND tax_regime_code = c_tax_regime_code
4077: AND tax = c_tax
4071: AND trx_id = p_event_class_rec.trx_id
4072: AND trx_line_id =
4073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
4074: AND trx_level_type =
4075: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
4076: AND tax_regime_code = c_tax_regime_code
4077: AND tax = c_tax
4078: AND tax_apportionment_line_number = c_apportionment_line_number
4079: AND mrc_tax_line_flag = 'N';
4139:
4140: -- bug 5675944: retain tax_line_id for UPDATE
4141: --
4142: IF p_event_class_rec.tax_event_type_code = 'UPDATE' AND
4143: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'UPDATE'
4144: THEN
4145: OPEN get_key_columns_cur(tax_line_rec.tax_regime_code, tax_line_rec.tax,tax_line_rec.tax_apportionment_line_number); -- Bug7597449
4146:
4147: FETCH get_key_columns_cur INTO l_tax_line_rec;
4342:
4343: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4344: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
4345:
4346: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
4347: tax_line_rec.tax_provider_id is not null ) THEN
4348: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
4349: end if;
4350:
4392: tax_line_rec.hq_estb_party_tax_prof_id;
4393:
4394: -- If line_amt_include_tax_flag on trx line is A, then set to 'Y'
4395: -- for other cases, set to the one from adjusted doc.
4396: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
4397: p_trx_line_index) = 'A'
4398: THEN
4399: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4400: l_new_row_num).tax_amt_included_flag := 'Y';
4408: --Bug 7133202 Added NVL for deriving unrounded taxable amt and unrounded tax amt. For migrated invoices unrounded taxable amt and unrounded tax amt can be NULL,so in this scenario taxable amt and tax amt values will be used for tax calculation.
4409:
4410: IF NVL(tax_line_rec.historical_flag, 'N') = 'Y' THEN
4411:
4412: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
4413: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4414: THEN
4415:
4416: -- for tax only adjustment set the unrounded tax amount to the
4432: -- tax exclusive trx.
4433: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
4434: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4435: l_new_row_num).unrounded_taxable_amt
4436: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4437: ( NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) /
4438: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4439:
4440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4438: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4439:
4440: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4441: l_new_row_num).unrounded_tax_amt
4442: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4443: (NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt) /
4444: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4445: ELSE
4446: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4452: END IF;
4453: ELSE -- both current tax line and original tax line are inclusive and exclusive
4454: IF tax_line_rec.line_amt <> 0 THEN
4455: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4456: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4457: (NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) / tax_line_rec.line_amt);
4458:
4459: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4460: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4456: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4457: (NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt) / tax_line_rec.line_amt);
4458:
4459: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4460: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4461: (NVL(tax_line_rec.unrounded_tax_amt,tax_line_rec.tax_amt) / tax_line_rec.line_amt );
4462: ELSE -- equal to that the original trx is a tax only trx
4463: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4464: := NVL(tax_line_rec.unrounded_taxable_amt,tax_line_rec.taxable_amt);
4468: END IF; -- tax_line_rec.tax_amt_included_flag = 'N'
4469:
4470: END IF; -- 'ALLOCATE_TAX_ONLY_ADJUSTMENT' trx and else
4471: ELSE -- Historical Flag is 'N'
4472: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
4473: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
4474: THEN
4475:
4476: -- for tax only adjustment set the unrounded tax amount to the
4492: -- tax exclusive trx.
4493: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
4494: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4495: l_new_row_num).unrounded_taxable_amt
4496: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4497: ( tax_line_rec.unrounded_taxable_amt /
4498: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4499:
4500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4498: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4499:
4500: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4501: l_new_row_num).unrounded_tax_amt
4502: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4503: ( tax_line_rec.unrounded_tax_amt /
4504: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
4505: ELSE
4506: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4512: END IF;
4513: ELSE -- both current tax line and original tax line are inclusive and exclusive
4514: IF tax_line_rec.line_amt <> 0 THEN
4515: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4516: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4517: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
4518:
4519: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4520: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4516: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4517: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
4518:
4519: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
4520: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
4521: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
4522: ELSE -- equal to that the original trx is a tax only trx
4523: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
4524: := tax_line_rec.unrounded_taxable_amt;
4547:
4548: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4549: l_new_row_num).tax_amt_included_flag = 'Y' THEN
4550:
4551: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
4552: p_trx_line_index) := 'Y';
4553: END IF;
4554:
4555: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4554:
4555: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4556: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
4557:
4558: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
4559: p_trx_line_index) := 'Y';
4560: END IF;
4561:
4562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
4779: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
4780: --FND_MSG_PUB.Add;
4781:
4782: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4783: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4785: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4786:
4787: ZX_API_PUB.add_msg(
4781:
4782: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4783: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4785: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4786:
4787: ZX_API_PUB.add_msg(
4788: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4789:
4813: -- TCM procedure called in get_pos_parameter_name will set the error msg
4814: -- here we just need to populate the context information.
4815:
4816: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4817: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4818: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4819: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4820:
4821: ZX_API_PUB.add_msg(
4815:
4816: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4817: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4818: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4819: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4820:
4821: ZX_API_PUB.add_msg(
4822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4823:
4875: -- TCM procedure called in get_pos_parameter_name will set the error msg
4876: -- here we just need to populate the context information.
4877:
4878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4879: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4881: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4882:
4883: ZX_API_PUB.add_msg(
4877:
4878: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4879: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4880: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4881: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4882:
4883: ZX_API_PUB.add_msg(
4884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4885:
4943: -- populate the trx line context info if jurisdiction API return error
4944: -- jurisdiction API should have populated the error message name and text.
4945:
4946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4947: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4949: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4950:
4951: ZX_API_PUB.add_msg(
4945:
4946: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4947: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4948: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4949: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4950:
4951: ZX_API_PUB.add_msg(
4952: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4953:
4976: FND_MESSAGE.SET_TOKEN('POS_TYPE', l_pos_type);
4977: -- FND_MSG_PUB.Add;
4978:
4979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4982: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4983:
4984: ZX_API_PUB.add_msg(
4978:
4979: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
4980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
4981: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
4982: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
4983:
4984: ZX_API_PUB.add_msg(
4985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4986: */
6337: CURSOR get_chart_of_accts_id_csr IS
6338: SELECT chart_of_accounts_id
6339: FROM gl_sets_of_books
6340: WHERE set_of_books_id =
6341: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ledger_id(p_trx_line_index);
6342:
6343: CURSOR get_default_jurisdiction_csr(c_tax_regime_code VARCHAR2, c_tax VARCHAR2) IS
6344: SELECT tax_jurisdiction_id,
6345: tax_jurisdiction_code
6400: zx_sco_taxes zxt,
6401: fnd_lookups lc
6402: WHERE zxtr.content_owner_id = p_event_class_rec.first_pty_org_id
6403: AND zxtr.ledger_id =
6404: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ledger_id(p_trx_line_index)
6405: AND zxtr.account_segment_value= c_account_seg_value
6406: AND zxt.tax_regime_code = zxtr.tax_regime_code
6407: AND zxt.tax = zxtr.tax
6408: AND zxt.tax_type_code = lc.lookup_code
6435: l_end_index BINARY_INTEGER;
6436: l_begin_index_from_acct BINARY_INTEGER;
6437: l_end_index_from_acct BINARY_INTEGER;
6438:
6439: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
6440: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6441: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6442:
6443: l_jurisdiction_id NUMBER;
6465: l_tax_class := 'INPUT';
6466: END IF;
6467:
6468: l_account_ccid :=
6469: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_ccid(p_trx_line_index);
6470: l_account_string :=
6471: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_string(p_trx_line_index);
6472:
6473: -- get chart_of_account_id
6467:
6468: l_account_ccid :=
6469: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_ccid(p_trx_line_index);
6470: l_account_string :=
6471: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.account_string(p_trx_line_index);
6472:
6473: -- get chart_of_account_id
6474: --
6475: OPEN get_chart_of_accts_id_csr;
6572:
6573: -- Get detail tax lines from account
6574: --
6575: l_trx_line_id :=
6576: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
6577: l_trx_level_type :=
6578: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
6579:
6580: FOR l_tax_rec IN get_det_tax_lines_frm_acct_csr(l_account_seg_value) LOOP
6574: --
6575: l_trx_line_id :=
6576: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
6577: l_trx_level_type :=
6578: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
6579:
6580: FOR l_tax_rec IN get_det_tax_lines_frm_acct_csr(l_account_seg_value) LOOP
6581:
6582: l_tax_tbl_subscript := NULL;
6898: -- populate hq_estb_party_tax_prof_id
6899: --
6900: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
6901: l_new_row_num).hq_estb_party_tax_prof_id :=
6902: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
6903: p_trx_line_index);
6904:
6905: -- bug 5077691: populate legal_reporting_status
6906: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
7035: CURSOR get_taxes_f_intercomp_trx_csr IS
7036: SELECT zxl.*
7037: FROM zx_lines zxl, zx_evnt_cls_mappings map
7038: WHERE map.application_id =
7039: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7040: AND map.entity_code =
7041: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7042: AND map.event_class_code =
7043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7037: FROM zx_lines zxl, zx_evnt_cls_mappings map
7038: WHERE map.application_id =
7039: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7040: AND map.entity_code =
7041: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7042: AND map.event_class_code =
7043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7044: AND zxl.application_id = map.intrcmp_src_appln_id
7045: AND zxl.entity_code = map.intrcmp_src_entity_code
7039: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7040: AND map.entity_code =
7041: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7042: AND map.event_class_code =
7043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7044: AND zxl.application_id = map.intrcmp_src_appln_id
7045: AND zxl.entity_code = map.intrcmp_src_entity_code
7046: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7047: 'INTERCOMPANY_TRX',
7042: AND map.event_class_code =
7043: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index)
7044: AND zxl.application_id = map.intrcmp_src_appln_id
7045: AND zxl.entity_code = map.intrcmp_src_entity_code
7046: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7047: 'INTERCOMPANY_TRX',
7048: decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index),
7049: 'AP_CREDIT_MEMO', 'CREDIT_MEMO',
7050: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7044: AND zxl.application_id = map.intrcmp_src_appln_id
7045: AND zxl.entity_code = map.intrcmp_src_entity_code
7046: AND zxl.event_class_code = decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index),
7047: 'INTERCOMPANY_TRX',
7048: decode(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_class(p_trx_line_index),
7049: 'AP_CREDIT_MEMO', 'CREDIT_MEMO',
7050: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7051: map.intrcmp_src_evnt_cls_code), map.intrcmp_src_evnt_cls_code)
7052: AND zxl.trx_id =
7049: 'AP_CREDIT_MEMO', 'CREDIT_MEMO',
7050: 'AP_DEBIT_MEMO', 'DEBIT_MEMO',
7051: map.intrcmp_src_evnt_cls_code), map.intrcmp_src_evnt_cls_code)
7052: AND zxl.trx_id =
7053: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7054: AND zxl.trx_line_id =
7055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7056: AND zxl.trx_level_type =
7057: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7051: map.intrcmp_src_evnt_cls_code), map.intrcmp_src_evnt_cls_code)
7052: AND zxl.trx_id =
7053: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7054: AND zxl.trx_line_id =
7055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7056: AND zxl.trx_level_type =
7057: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7058: AND zxl.tax_provider_id IS NULL
7059: AND zxl.cancel_flag <> 'Y'
7053: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)
7054: AND zxl.trx_line_id =
7055: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_line_id(p_trx_line_index)
7056: AND zxl.trx_level_type =
7057: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_level_type(p_trx_line_index)
7058: AND zxl.tax_provider_id IS NULL
7059: AND zxl.cancel_flag <> 'Y'
7060: AND zxl.mrc_tax_line_flag = 'N';
7061:
7112: AND active_flag = 'Y'
7113: AND tax_class <> 'INPUT'
7114: ORDER BY subscription_level_code;
7115:
7116: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
7117: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
7118: l_tax_status_rec zx_tds_utilities_pkg.zx_status_info_rec;
7119: l_tax_rate_rec zx_tds_utilities_pkg.zx_rate_info_rec_type;
7120: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8117: l_tax_regime_code_tbl tax_regime_code_tbl;
8118: l_tax_tbl tax_tbl;
8119: l_result_id_tbl result_id_tbl;
8120: l_query_num_tbl ZX_GLOBAL_STRUCTURES_PKG.NUMBER_tbl_type;
8121: l_status_result_tbl status_result_tbl;
8122: l_rate_result_tbl rate_result_tbl;
8123: l_condition_set_tbl condition_set_tbl;
8124: l_exception_set_tbl exception_set_tbl;
8123: l_condition_set_tbl condition_set_tbl;
8124: l_exception_set_tbl exception_set_tbl;
8125: l_counter NUMBER;
8126: i NUMBER;
8127: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
8128: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
8129: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
8130: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8131: l_error_buffer VARCHAR2(200);
8170:
8171: x_return_status := FND_API.G_RET_STS_SUCCESS;
8172:
8173: l_tax_classification_code :=
8174: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8175: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8176:
8177: l_internal_organization_id :=
8178: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8171: x_return_status := FND_API.G_RET_STS_SUCCESS;
8172:
8173: l_tax_classification_code :=
8174: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8175: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8176:
8177: l_internal_organization_id :=
8178: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8179:
8174: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index),
8175: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index));
8176:
8177: l_internal_organization_id :=
8178: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(p_trx_line_index);
8179:
8180: l_condition_group_code := l_tax_classification_code;
8181:
8182: IF p_event_class_rec.prod_family_grp_code = 'O2C' THEN
8185: l_tax_class := 'INPUT';
8186: END IF;
8187:
8188: l_trx_line_id :=
8189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
8190: l_trx_level_type :=
8191: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8192:
8193: IF l_tax_classification_code IS NOT NULL THEN
8187:
8188: l_trx_line_id :=
8189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
8190: l_trx_level_type :=
8191: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8192:
8193: IF l_tax_classification_code IS NOT NULL THEN
8194: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8195: p_trx_line_index) = 'CREATE' OR
8190: l_trx_level_type :=
8191: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
8192:
8193: IF l_tax_classification_code IS NOT NULL THEN
8194: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8195: p_trx_line_index) = 'CREATE' OR
8196: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8197: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8198: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8192:
8193: IF l_tax_classification_code IS NOT NULL THEN
8194: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8195: p_trx_line_index) = 'CREATE' OR
8196: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8197: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8198: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8199: p_trx_line_index) = 'UPDATE' OR
8200: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8194: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8195: p_trx_line_index) = 'CREATE' OR
8196: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8197: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8198: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8199: p_trx_line_index) = 'UPDATE' OR
8200: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8201: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8196: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8197: p_trx_line_index) = 'CREATE_WITH_TAX' OR
8198: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8199: p_trx_line_index) = 'UPDATE' OR
8200: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8201: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8203: p_trx_line_index) = 'COPY_AND_CREATE'
8204: THEN
8198: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8199: p_trx_line_index) = 'UPDATE' OR
8200: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8201: p_trx_line_index) = 'CREATE_TAX_ONLY' OR
8202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
8203: p_trx_line_index) = 'COPY_AND_CREATE'
8204: THEN
8205:
8206:
9009:
9010: END IF; --l_rate_result_tbl(j) IS NOT NULL
9011:
9012: -- >> Update call
9013: IF(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9014: p_trx_line_index)='UPDATE') THEN
9015:
9016: handle_update_scenarios(p_trx_line_index,
9017: p_event_class_rec,
9070: -- stamp trx_level_type and trx_line_id, since they are used for
9071: -- tax line index checking.
9072: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9073: l_rownum).trx_level_type :=
9074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
9075:
9076: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9077: l_rownum).trx_line_id :=
9078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
9075:
9076: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9077: l_rownum).trx_line_id :=
9078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9079:
9080: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
9081: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
9082: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
9158: -- populate hq_estb_party_tax_prof_id
9159: --
9160: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9161: l_rownum).hq_estb_party_tax_prof_id :=
9162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
9163: p_trx_line_index);
9164:
9165: -- populate tax registration info
9166: --
9232: -- Bug 5705976: Since, we stamp 'INTERCOMPANY_TRX' on both AR and AP
9233: -- transactions, the following code has become incorrect.
9234: --
9235: /*
9236: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9237: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
9238: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
9239: p_trx_line_index) = 'INTERCOMPANY_TRX'
9240: THEN
9234: --
9235: /*
9236: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
9237: p_trx_line_index) IN ('CREATE', 'UPDATE') AND
9238: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
9239: p_trx_line_index) = 'INTERCOMPANY_TRX'
9240: THEN
9241: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9242: l_rownum).self_assessed_flag := 'Y';
9248: --
9249: -- Bug#5440023- do not poplate detail_tax_regime_tbl
9250: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
9251: --
9252: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
9253: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
9254:
9255:
9256: l_regimerownum :=
9249: -- Bug#5440023- do not poplate detail_tax_regime_tbl
9250: -- for partner integration with 'LINE_INFO_TAX_ONLY' lines
9251: --
9252: IF NOT (NVL(ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag, 'N') = 'Y' AND
9253: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
9254:
9255:
9256: l_regimerownum :=
9257: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
9253: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action (p_trx_line_index ) = 'LINE_INFO_TAX_ONLY' ) THEN
9254:
9255:
9256: l_regimerownum :=
9257: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
9258:
9259: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9260: l_regimerownum).trx_line_index := p_trx_line_index;
9261: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9255:
9256: l_regimerownum :=
9257: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
9258:
9259: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9260: l_regimerownum).trx_line_index := p_trx_line_index;
9261: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9262: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
9263: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9257: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.last, 0) + 1;
9258:
9259: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9260: l_regimerownum).trx_line_index := p_trx_line_index;
9261: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9262: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
9263: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9264: l_regimerownum).tax_regime_precedence :=
9265: l_tax_regime_rec.tax_regime_precedence;
9259: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9260: l_regimerownum).trx_line_index := p_trx_line_index;
9261: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9262: l_regimerownum).tax_regime_id:= l_tax_regime_rec.tax_regime_id;
9263: ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
9264: l_regimerownum).tax_regime_precedence :=
9265: l_tax_regime_rec.tax_regime_precedence;
9266:
9267: END IF;
9319: -- trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index) IS NOT NULL,
9320: -- get tax rate code from refefence document
9321: --
9322: IF p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
9323: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
9324: p_trx_line_index) IS NOT NULL
9325: THEN
9326:
9327: enforce_tax_from_ref_doc(
9469: AND entity_code = p_event_class_rec.entity_code
9470: AND event_class_code = p_event_class_rec.event_class_code
9471: AND trx_id = p_event_class_rec.trx_id
9472: AND trx_line_id =
9473: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
9474: AND trx_level_type =
9475: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
9476: AND tax_regime_code = p_tax_regime_code
9477: AND tax = p_tax
9471: AND trx_id = p_event_class_rec.trx_id
9472: AND trx_line_id =
9473: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
9474: AND trx_level_type =
9475: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index)
9476: AND tax_regime_code = p_tax_regime_code
9477: AND tax = p_tax
9478: AND mrc_tax_line_flag = 'N'
9479: AND tax_apportionment_line_number > 0
9588:
9589:
9590: IF p_event_class_rec.prod_family_grp_code = 'P2P' THEN
9591: l_current_line_amt :=
9592: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
9593:
9594: IF l_tax_line_rec.line_amt <> 0 AND
9595: l_tax_line_rec.line_amt <> l_current_line_amt THEN
9596:
9948:
9949: -- prorate tax amount and taxable amount
9950: --
9951: l_current_line_amt :=
9952: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(
9953: p_trx_line_index);
9954:
9955: IF l_tax_line_rec.line_amt <> 0 THEN
9956: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
10066: tax_apportionment_line_number
10067: -- nipatel bug 6648042
10068: FROM zx_lines
10069: WHERE application_id =
10070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10071: AND event_class_code =
10072: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10073: AND entity_code =
10074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10068: FROM zx_lines
10069: WHERE application_id =
10070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10071: AND event_class_code =
10072: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10073: AND entity_code =
10074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10075: AND trx_id =
10076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10071: AND event_class_code =
10072: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10073: AND entity_code =
10074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10075: AND trx_id =
10076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10077: AND trx_line_id =
10078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10072: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
10073: AND entity_code =
10074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10075: AND trx_id =
10076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10077: AND trx_line_id =
10078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10079: AND trx_level_type =
10080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_index)
10075: AND trx_id =
10076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10077: AND trx_line_id =
10078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10079: AND trx_level_type =
10080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10081: AND tax_regime_code = c_tax_regime_code
10082: AND tax = c_tax
10076: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_index)
10077: AND trx_line_id =
10078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_index)
10079: AND trx_level_type =
10080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_index)
10081: AND tax_regime_code = c_tax_regime_code
10082: AND tax = c_tax
10083: AND cancel_flag <> 'Y'
10084: AND mrc_tax_line_flag = 'N';