DBA Data[Home] [Help]

APPS.ZX_TDS_OFFSET_TAX_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 96: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

92: l_offset_tax ZX_TAXES_B.TAX%TYPE;
93: l_offset_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
94: l_offset_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE;
95: l_offset_tax_rate_code ZX_RATES_B.OFFSET_TAX_RATE_CODE%TYPE;
96: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
97: l_tax_class ZX_RATES_B.TAX_CLASS%TYPE;
98:
99: BEGIN
100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 122: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN

118: l_tax_rate_id := p_offset_tax_line_rec.tax_rate_id;
119: l_offset_tax_regime_code := p_offset_tax_line_rec.tax_regime_code;
120:
121:
122: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
123: l_offset_tax_rate_code :=
124: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax_rate_code;
125: l_offset_tax_status_code :=
126: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_status_code;

Line 124: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax_rate_code;

120:
121:
122: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
123: l_offset_tax_rate_code :=
124: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax_rate_code;
125: l_offset_tax_status_code :=
126: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_status_code;
127: l_offset_tax :=
128: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax;

Line 126: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_status_code;

122: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
123: l_offset_tax_rate_code :=
124: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax_rate_code;
125: l_offset_tax_status_code :=
126: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_status_code;
127: l_offset_tax :=
128: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax;
129:
130: l_initial_tax_rate :=

Line 128: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax;

124: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax_rate_code;
125: l_offset_tax_status_code :=
126: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_status_code;
127: l_offset_tax :=
128: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax;
129:
130: l_initial_tax_rate :=
131: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).percentage_rate;
132: ELSE

Line 131: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).percentage_rate;

127: l_offset_tax :=
128: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).offset_tax;
129:
130: l_initial_tax_rate :=
131: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).percentage_rate;
132: ELSE
133:
134: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
135: p_tax_rate_id => l_tax_rate_id,

Line 134: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

130: l_initial_tax_rate :=
131: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id).percentage_rate;
132: ELSE
133:
134: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
135: p_tax_rate_id => l_tax_rate_id,
136: p_tax_rate_rec => l_tax_rate_rec,
137: p_return_status => p_return_status,
138: p_error_buffer => p_error_buffer

Line 144: 'Incorrect status returned from ZX_TDS_UTILITIES_PKG.get_tax_rate_info'||

140: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
141: IF (g_level_error >= g_current_runtime_level) THEN
142: FND_LOG.STRING(g_level_error,
143: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',
144: 'Incorrect status returned from ZX_TDS_UTILITIES_PKG.get_tax_rate_info'||
145: 'p_return_status = ' || p_return_status);
146: FND_LOG.STRING(g_level_error,
147: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',
148: 'p_error_buffer = ' || p_error_buffer);

Line 153: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;

149: END IF;
150: RETURN;
151: END IF;
152:
153: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
154:
155: l_offset_tax_rate_code := l_tax_rate_rec.offset_tax_rate_code;
156: l_offset_tax_status_code := l_tax_rate_rec.offset_status_code;
157: l_offset_tax := l_tax_rate_rec.offset_tax;

Line 265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

261: IS
262: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
263: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
264: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
266:
267: /* Bug#5417753- use cache structure
268: CURSOR get_offset_info_csr
269: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,

Line 325: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

321: END IF;
322: CLOSE get_offset_info_csr;
323: */
324:
325: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
326: p_tax_regime_code,
327: p_tax,
328: p_tax_jurisdiction_code,
329: p_tax_status_code,

Line 602: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;

598: -- now round the tax amount tax currency
599: --
600:
601: l_tax_id := p_offset_tax_line_rec.tax_id;
602: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
603: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
604:
605: p_offset_tax_line_rec.tax_amt_tax_curr :=
606: ZX_TDS_TAX_ROUNDING_PKG.round_tax(

Line 603: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;

599: --
600:
601: l_tax_id := p_offset_tax_line_rec.tax_id;
602: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_precision;
603: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).minimum_accountable_unit;
604:
605: p_offset_tax_line_rec.tax_amt_tax_curr :=
606: ZX_TDS_TAX_ROUNDING_PKG.round_tax(
607: p_offset_tax_line_rec.tax_amt_tax_curr,

Line 679: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;

675: p_return_status OUT NOCOPY VARCHAR2,
676: p_error_buffer OUT NOCOPY VARCHAR2)
677:
678: IS
679: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
680:
681: BEGIN
682: IF (g_level_statement >= g_current_runtime_level) THEN
683: FND_LOG.STRING(g_level_statement,

Line 689: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

685: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');
686: END IF;
687: p_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
690: p_tax,
691: p_tax_regime_code,
692: p_tax_status_code,
693: p_tax_determine_date,

Line 737: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;

733: p_return_status OUT NOCOPY VARCHAR2,
734: p_error_buffer OUT NOCOPY VARCHAR2)
735:
736: IS
737: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
738: BEGIN
739: IF (g_level_statement >= g_current_runtime_level) THEN
740: FND_LOG.STRING(g_level_statement,
741: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',

Line 747: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

743: END IF;
744:
745: p_return_status := FND_API.G_RET_STS_SUCCESS;
746:
747: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
748: p_tax_regime_code,
749: p_tax,
750: p_tax_determine_date,
751: l_tax_rec,

Line 982: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_offset_tax_line_rec.tax_id).tax_type_code;

978: RETURN;
979: END IF;
980:
981: p_offset_tax_line_rec.tax_type_code :=
982: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_offset_tax_line_rec.tax_id).tax_type_code;
983:
984: --
985: -- populate amount columns
986: --

Line 1000: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

996:
997: -- bug 5580990: populate legal_reporting_status
998: IF p_event_class_rec.tax_reporting_flag = 'Y' THEN
999: p_offset_tax_line_rec.legal_reporting_status :=
1000: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1001: p_offset_tax_line_rec.tax_id).legal_reporting_status_def_val;
1002: END IF;
1003:
1004: --