eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 4143: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;

4139: l_date DATE;
4140: l_return_status VARCHAR2(30);
4141: l_error_buffer VARCHAR2(240);
4142: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4143: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
4144: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4145: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4146: l_tax_rate_id zx_rates_b.tax_rate_id%type;
4147:

Line 4144: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

4140: l_return_status VARCHAR2(30);
4141: l_error_buffer VARCHAR2(240);
4142: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4143: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
4144: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4145: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4146: l_tax_rate_id zx_rates_b.tax_rate_id%type;
4147:
4148:

Line 4145: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;

4141: l_error_buffer VARCHAR2(240);
4142: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4143: l_tax_rec zx_tds_utilities_pkg.zx_tax_info_cache_rec;
4144: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4145: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4146: l_tax_rate_id zx_rates_b.tax_rate_id%type;
4147:
4148:
4149:

Line 4387: 'Calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info to populate tax_cache...');

4383:
4384: IF (g_level_statement >= g_current_runtime_level ) THEN
4385: FND_LOG.STRING(g_level_statement,
4386: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.prepare_detail_tax_line',
4387: 'Calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info to populate tax_cache...');
4388: END IF;
4389:
4390: /******
4391: ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(

Line 4420: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

4416: --
4417: -- Bug#5395227- get tax_regime_id if it is null
4418: --
4419: IF p_tax_out_rec.tax_regime_id IS NULL THEN
4420: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
4421: p_tax_out_rec.tax_regime_code,
4422: p_tax_out_rec.TRX_DATE,
4423: l_tax_regime_rec,
4424: l_return_status,

Line 4436: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');

4432: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4433: FND_LOG.STRING(g_level_unexpected,
4434: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4435: 'Incorrect return_status after calling ' ||
4436: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
4437: FND_LOG.STRING(g_level_unexpected,
4438: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4439: 'RETURN_STATUS = ' || l_return_status);
4440: FND_LOG.STRING(g_level_unexpected,

Line 4457: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

4453: -- populate tax_cache in Tax Determination Services for tail end processing
4454: -- Bug#5395227- call cache structure to get place of supply
4455: -- type code
4456: --
4457: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
4458: p_tax_regime_code => p_tax_out_rec.TAX_REGIME_CODE,
4459: p_tax => p_tax_out_rec.TAX,
4460: p_tax_determine_date => p_tax_out_rec.TRX_DATE,
4461: x_tax_rec => l_tax_rec,

Line 4486: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()')

4482: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4483: FND_LOG.STRING(g_level_unexpected,
4484: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4485: 'Incorrect return_status after calling ' ||
4486: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()')
4487: ;
4488: FND_LOG.STRING(g_level_unexpected,
4489: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4490: 'RETURN_STATUS = ' || l_return_status);

Line 4501: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

4497: END IF;
4498:
4499: IF p_tax_out_rec.TAX_JURISDICTION_CODE IS NOT NULL THEN
4500:
4501: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
4502: p_tax_regime_code => p_tax_out_rec.TAX_REGIME_CODE,
4503: p_tax => p_tax_out_rec.TAX,
4504: p_tax_jurisdiction_code => p_tax_out_rec.TAX_JURISDICTION_CODE,
4505: p_tax_determine_date => p_tax_out_rec.TRX_DATE,

Line 4518: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');

4514: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4515: FND_LOG.STRING(g_level_unexpected,
4516: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4517: 'Incorrect return_status after calling ' ||
4518: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
4519: FND_LOG.STRING(g_level_unexpected,
4520: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4521: 'RETURN_STATUS = ' || l_return_status);
4522: FND_LOG.STRING(g_level_unexpected,

Line 4537: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

4533: --
4534: -- Bug#5395227- get tax_status_id only if it is null
4535: --
4536: IF p_tax_out_rec.tax_status_id IS NULL THEN
4537: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
4538: p_tax_out_rec.tax,
4539: p_tax_out_rec.tax_regime_code,
4540: p_tax_out_rec.tax_status_code,
4541: p_tax_out_rec.TRX_DATE,

Line 4554: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');

4550: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4551: FND_LOG.STRING(g_level_unexpected,
4552: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4553: 'Incorrect return_status after calling ' ||
4554: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
4555: FND_LOG.STRING(g_level_unexpected,
4556: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4557: 'RETURN_STATUS = ' || l_return_status);
4558: FND_LOG.STRING(g_level_unexpected,

Line 4753: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

4749: p_new_row_num IN NUMBER,
4750: x_return_status OUT NOCOPY VARCHAR2) IS
4751:
4752: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4753: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4754: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4755: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4756:
4757: l_tax_date DATE;

Line 4754: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

4750: x_return_status OUT NOCOPY VARCHAR2) IS
4751:
4752: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4753: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4754: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4755: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4756:
4757: l_tax_date DATE;
4758: l_tax_determine_date DATE;

Line 4755: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;

4751:
4752: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
4753: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
4754: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
4755: l_tax_jurisdiction_rec zx_tds_utilities_pkg.zx_jur_info_cache_rec_type;
4756:
4757: l_tax_date DATE;
4758: l_tax_determine_date DATE;
4759: l_tax_point_date DATE;

Line 4809: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(

4805: END IF;
4806:
4807: -- populate tax_regime_cache_info
4808: --
4809: ZX_TDS_UTILITIES_PKG.get_regime_cache_info(
4810: p_tax_line_rec.tax_regime_code,
4811: l_tax_determine_date,
4812: l_tax_regime_rec,
4813: x_return_status,

Line 4821: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');

4817: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4818: FND_LOG.STRING(g_level_unexpected,
4819: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4820: 'Incorrect return_status after calling ' ||
4821: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
4822: FND_LOG.STRING(g_level_unexpected,
4823: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4824: 'RETURN_STATUS = ' || x_return_status);
4825: FND_LOG.STRING(g_level_unexpected,

Line 4835: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

4831: END IF;
4832:
4833: -- populate tax cache, if it does not exist there.
4834: --
4835: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
4836: p_tax_line_rec.tax_regime_code,
4837: p_tax_line_rec.tax,
4838: l_tax_determine_date,
4839: l_tax_rec,

Line 4848: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');

4844: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4845: FND_LOG.STRING(g_level_unexpected,
4846: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4847: 'Incorrect return_status after calling ' ||
4848: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
4849: FND_LOG.STRING(g_level_unexpected,
4850: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4851: 'RETURN_STATUS = ' || x_return_status);
4852: FND_LOG.STRING(g_level_unexpected,

Line 4861: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(

4857: RETURN;
4858: END IF;
4859:
4860: IF p_tax_line_rec.TAX_JURISDICTION_CODE IS NOT NULL THEN
4861: ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(
4862: p_tax_regime_code => p_tax_line_rec.TAX_REGIME_CODE,
4863: p_tax => p_tax_line_rec.TAX,
4864: p_tax_jurisdiction_code => p_tax_line_rec.TAX_JURISDICTION_CODE,
4865: p_tax_determine_date => l_tax_determine_date,

Line 4875: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');

4871: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4872: FND_LOG.STRING(g_level_unexpected,
4873: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4874: 'Incorrect return_status after calling ' ||
4875: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
4876: FND_LOG.STRING(g_level_unexpected,
4877: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4878: 'RETURN_STATUS = ' || x_return_status);
4879: FND_LOG.STRING(g_level_unexpected,

Line 4889: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

4885: END IF;
4886: END IF;
4887: -- populate tax_status_cahce_info
4888: --
4889: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
4890: p_tax_line_rec.tax,
4891: p_tax_line_rec.tax_regime_code,
4892: p_tax_line_rec.tax_status_code,
4893: l_tax_determine_date,

Line 4903: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');

4899: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4900: FND_LOG.STRING(g_level_unexpected,
4901: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4902: 'Incorrect return_status after calling ' ||
4903: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
4904: FND_LOG.STRING(g_level_unexpected,
4905: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line',
4906: 'RETURN_STATUS = ' || x_return_status);
4907: FND_LOG.STRING(g_level_unexpected,

Line 5134: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

5130: (p_tax_determine_date <= effective_to OR effective_to IS NULL));
5131:
5132: */
5133: -- Bug#5395227
5134: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
5135:
5136: BEGIN
5137: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5138:

Line 5173: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

5169: */
5170:
5171: /* 5395227- this procedure get_tax_rate_id is
5172: currently not used
5173: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
5174: p_tax_regime_code,
5175: p_tax,
5176: p_tax_jurisdiction_code,
5177: p_tax_status_code,