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_TCM_TAX_RATE_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 17: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

13: p_tax IN ZX_RATES_B.tax%TYPE,
14: p_tax_date IN DATE,
15: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
16: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
17: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
18: x_return_status OUT NOCOPY VARCHAR2
19: );
20:
21: PROCEDURE get_def_tax_rate_by_jur_gt(

Line 27: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

23: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
24: p_tax IN ZX_RATES_B.tax%TYPE,
25: p_tax_date IN DATE,
26: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
27: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
28: x_return_status OUT NOCOPY VARCHAR2
29: );
30:
31: PROCEDURE get_tax_rate_by_jur_code(

Line 39: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

35: p_tax IN ZX_RATES_B.tax%TYPE,
36: p_tax_date IN DATE,
37: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
38: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
39: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
40: x_return_status OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE get_tax_rate_no_jur_code(

Line 50: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

46: p_tax IN ZX_RATES_B.tax%TYPE,
47: p_tax_date IN DATE,
48: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
49: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
50: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
51: x_return_status OUT NOCOPY VARCHAR2
52: );
53: PROCEDURE get_def_tax_rate_by_jur_code(
54: p_tax_class IN VARCHAR2,

Line 60: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

56: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
57: p_tax IN ZX_RATES_B.tax%TYPE,
58: p_tax_date IN DATE,
59: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
60: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2
62: );
63:
64: PROCEDURE get_def_tax_rate_no_jur_code(

Line 70: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

66: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
67: p_tax IN ZX_RATES_B.tax%TYPE,
68: p_tax_date IN DATE,
69: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
70: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
71: x_return_status OUT NOCOPY VARCHAR2
72: );
73:
74: PROCEDURE get_tax_rate_internal(

Line 84: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

80: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
81: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
82: p_structure_index IN NUMBER,
83: p_multiple_jurisdictions_flag IN VARCHAR2,
84: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2
86: );
87:
88: PROCEDURE get_tax_rate_pvt(

Line 99: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

95: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
96: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
97: p_structure_index IN NUMBER,
98: p_multiple_jurisdictions_flag IN VARCHAR2,
99: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
100: x_return_status OUT NOCOPY VARCHAR2
101: );
102:
103: PROCEDURE get_def_tax_rate_pvt(

Line 113: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

109: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
110: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
111: p_structure_index IN NUMBER,
112: p_multiple_jurisdictions_flag IN VARCHAR2,
113: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
114: x_return_status OUT NOCOPY VARCHAR2
115: );
116:
117:

Line 133: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

129: p_tax IN ZX_RATES_B.tax%TYPE,
130: p_tax_date IN DATE,
131: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
132: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
133: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
134: x_return_status OUT NOCOPY VARCHAR2
135: ) IS
136:
137: -- the condition of tax_class is added for migration_data compatibility

Line 221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

217: AND rate.tax_class = p_tax_class
218: ORDER BY jur.precedence_level, rate.subscription_level_code;
219:
220: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_gt';
221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
223:
224: BEGIN
225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

218: ORDER BY jur.precedence_level, rate.subscription_level_code;
219:
220: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_gt';
221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
223:
224: BEGIN
225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
226:

Line 393: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

389: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
390: p_tax IN ZX_RATES_B.tax%TYPE,
391: p_tax_date IN DATE,
392: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
393: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
394: x_return_status OUT NOCOPY VARCHAR2
395: )IS
396:
397: -- the condition of tax_class is added for migration_data compatibility

Line 483: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

479: AND rate.tax_class = p_tax_class
480: ORDER BY jur.precedence_level, rate.subscription_level_code;
481:
482: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_gt';
483: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
484: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
485:
486: BEGIN
487: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 484: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

480: ORDER BY jur.precedence_level, rate.subscription_level_code;
481:
482: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_gt';
483: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
484: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
485:
486: BEGIN
487: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
488:

Line 648: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

644: p_tax IN ZX_RATES_B.tax%TYPE,
645: p_tax_date IN DATE,
646: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
647: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
648: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
649: x_return_status OUT NOCOPY VARCHAR2
650: ) IS
651:
652: -- the condition of tax_class is added for migration_data compatibility

Line 732: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

728: AND tax_class = p_tax_class
729: ORDER BY subscription_level_code; -- Bug#5395227
730:
731: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_code';
732: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
733: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
734:
735: BEGIN
736: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 733: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

729: ORDER BY subscription_level_code; -- Bug#5395227
730:
731: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_code';
732: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
733: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
734:
735: BEGIN
736: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737:

Line 896: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

892: p_tax IN ZX_RATES_B.tax%TYPE,
893: p_tax_date IN DATE,
894: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
895: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
896: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
897: x_return_status OUT NOCOPY VARCHAR2
898: ) IS
899:
900: -- the condition of tax_class is added for migration_data compatibility

Line 980: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

976: AND tax_class = p_tax_class
977: ORDER BY subscription_level_code; -- Bug#5395227
978:
979: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_no_jur_code';
980: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
981: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
982:
983: BEGIN
984: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 981: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

977: ORDER BY subscription_level_code; -- Bug#5395227
978:
979: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_no_jur_code';
980: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
981: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
982:
983: BEGIN
984: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:

Line 1135: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1131: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1132: p_tax IN ZX_RATES_B.tax%TYPE,
1133: p_tax_date IN DATE,
1134: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1135: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1136: x_return_status OUT NOCOPY VARCHAR2
1137: ) IS
1138:
1139: -- the condition of tax_class is added for migration_data compatibility

Line 1221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1217: AND tax_class = p_tax_class
1218: ORDER BY subscription_level_code; -- Bug#5395227
1219:
1220: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_code';
1221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1223:
1224: BEGIN
1225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1218: ORDER BY subscription_level_code; -- Bug#5395227
1219:
1220: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_code';
1221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1223:
1224: BEGIN
1225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1226:

Line 1377: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1373: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1374: p_tax IN ZX_RATES_B.tax%TYPE,
1375: p_tax_date IN DATE,
1376: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1377: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1378: x_return_status OUT NOCOPY VARCHAR2
1379: ) IS
1380:
1381: -- the condition of tax_class is added for migration_data compatibility

Line 1463: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1459: AND tax_class = p_tax_class
1460: ORDER BY subscription_level_code; -- Bug#5395227
1461:
1462: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_no_jur_code';
1463: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1464: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1465:
1466: BEGIN
1467: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1464: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1460: ORDER BY subscription_level_code; -- Bug#5395227
1461:
1462: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_no_jur_code';
1463: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1464: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1465:
1466: BEGIN
1467: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1468:

Line 1626: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1622: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
1623: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
1624: p_structure_index IN NUMBER,
1625: p_multiple_jurisdictions_flag IN VARCHAR2,
1626: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1627: x_return_status OUT NOCOPY VARCHAR2
1628: ) IS
1629:
1630: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_internal';

Line 1817: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1813: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
1814: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
1815: p_structure_index IN NUMBER,
1816: p_multiple_jurisdictions_flag IN VARCHAR2,
1817: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1818: x_return_status OUT NOCOPY VARCHAR2
1819: ) IS
1820:
1821: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_pvt';

Line 2010: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

2006: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
2007: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
2008: p_structure_index IN NUMBER,
2009: p_multiple_jurisdictions_flag IN VARCHAR2,
2010: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
2011: x_return_status OUT NOCOPY VARCHAR2
2012: ) IS
2013:
2014: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_pvt';

Line 2203: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

2199: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
2200: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
2201: p_structure_index IN NUMBER,
2202: p_multiple_jurisdictions_flag IN VARCHAR2,
2203: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
2204: x_return_status OUT NOCOPY VARCHAR2
2205: ) IS
2206: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate';
2207: l_count_jur NUMBER;

Line 2398: -- populate the cached structure ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash

2394: 'offset_tax_rate_code = ' || x_tax_rate_rec.offset_tax_rate_code);
2395: END IF;
2396: END IF;
2397:
2398: -- populate the cached structure ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash
2399: -- for reference by ZX_TDS_APPLICABILITY_DETM_PKG.get_process_Results for batch calculation calls
2400: -- since this procedure only checks the existence of a rate record having the same tax class
2401: -- it should be ok to refecene this record.
2402:

Line 2409: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index) := x_tax_rate_rec;

2405: x_tax_rate_rec.tax_status_code||x_tax_rate_rec.tax_rate_code,
2406: 1,
2407: 8192);
2408:
2409: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index) := x_tax_rate_rec;
2410:
2411: IF (g_level_procedure >= g_current_runtime_level ) THEN
2412: FND_LOG.STRING(g_level_procedure,
2413: g_module_name||'.'||l_procedure_name||'.END',