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 223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

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

Line 224: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

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

Line 398: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

394: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
395: p_tax IN ZX_RATES_B.tax%TYPE,
396: p_tax_date IN DATE,
397: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
398: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
399: x_return_status OUT NOCOPY VARCHAR2
400: )IS
401:
402: -- the condition of tax_class is added for migration_data compatibility

Line 490: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

486: AND rate.tax_class = p_tax_class
487: ORDER BY jur.precedence_level, rate.subscription_level_code;
488:
489: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_gt';
490: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
491: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
492:
493: BEGIN
494: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 491: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

487: ORDER BY jur.precedence_level, rate.subscription_level_code;
488:
489: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_gt';
490: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
491: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
492:
493: BEGIN
494: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:

Line 658: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

654: p_tax IN ZX_RATES_B.tax%TYPE,
655: p_tax_date IN DATE,
656: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
657: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
658: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
659: x_return_status OUT NOCOPY VARCHAR2
660: ) IS
661:
662: -- the condition of tax_class is added for migration_data compatibility

Line 742: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

738: AND tax_class = p_tax_class
739: ORDER BY subscription_level_code; -- Bug#5395227
740:
741: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_code';
742: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
743: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
744:
745: BEGIN
746: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 743: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

739: ORDER BY subscription_level_code; -- Bug#5395227
740:
741: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_by_jur_code';
742: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
743: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
744:
745: BEGIN
746: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747:

Line 909: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

905: p_tax IN ZX_RATES_B.tax%TYPE,
906: p_tax_date IN DATE,
907: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
908: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
909: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
910: x_return_status OUT NOCOPY VARCHAR2
911: ) IS
912:
913: -- the condition of tax_class is added for migration_data compatibility

Line 993: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

989: AND tax_class = p_tax_class
990: ORDER BY subscription_level_code; -- Bug#5395227
991:
992: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_no_jur_code';
993: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
994: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
995:
996: BEGIN
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 994: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

990: ORDER BY subscription_level_code; -- Bug#5395227
991:
992: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_no_jur_code';
993: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
994: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
995:
996: BEGIN
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:

Line 1151: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1147: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1148: p_tax IN ZX_RATES_B.tax%TYPE,
1149: p_tax_date IN DATE,
1150: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1151: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1152: x_return_status OUT NOCOPY VARCHAR2
1153: ) IS
1154:
1155: -- the condition of tax_class is added for migration_data compatibility

Line 1237: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1233: AND tax_class = p_tax_class
1234: ORDER BY subscription_level_code; -- Bug#5395227
1235:
1236: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_code';
1237: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1238: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1239:
1240: BEGIN
1241: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1238: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1234: ORDER BY subscription_level_code; -- Bug#5395227
1235:
1236: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_by_jur_code';
1237: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1238: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1239:
1240: BEGIN
1241: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1242:

Line 1396: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1392: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1393: p_tax IN ZX_RATES_B.tax%TYPE,
1394: p_tax_date IN DATE,
1395: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1396: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1397: x_return_status OUT NOCOPY VARCHAR2
1398: ) IS
1399:
1400: -- the condition of tax_class is added for migration_data compatibility

Line 1482: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1478: AND tax_class = p_tax_class
1479: ORDER BY subscription_level_code; -- Bug#5395227
1480:
1481: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_no_jur_code';
1482: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1483: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1484:
1485: BEGIN
1486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1483: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1479: ORDER BY subscription_level_code; -- Bug#5395227
1480:
1481: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_no_jur_code';
1482: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1483: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1484:
1485: BEGIN
1486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1487:

Line 1648: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1644: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
1645: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
1646: p_structure_index IN NUMBER,
1647: p_multiple_jurisdictions_flag IN VARCHAR2,
1648: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1649: x_return_status OUT NOCOPY VARCHAR2
1650: ) IS
1651:
1652: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_internal';

Line 1839: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

1835: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
1836: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
1837: p_structure_index IN NUMBER,
1838: p_multiple_jurisdictions_flag IN VARCHAR2,
1839: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
1840: x_return_status OUT NOCOPY VARCHAR2
1841: ) IS
1842:
1843: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_pvt';

Line 2032: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

2028: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
2029: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
2030: p_structure_index IN NUMBER,
2031: p_multiple_jurisdictions_flag IN VARCHAR2,
2032: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
2033: x_return_status OUT NOCOPY VARCHAR2
2034: ) IS
2035:
2036: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_pvt';

Line 2225: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,

2221: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,
2222: p_place_of_supply_type_code IN ZX_LINES.place_of_supply_type_code%TYPE,
2223: p_structure_index IN NUMBER,
2224: p_multiple_jurisdictions_flag IN VARCHAR2,
2225: x_tax_rate_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type,
2226: x_return_status OUT NOCOPY VARCHAR2
2227: ) IS
2228: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate';
2229: l_count_jur NUMBER;

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

2416: 'offset_tax_rate_code = ' || x_tax_rate_rec.offset_tax_rate_code);
2417: END IF;
2418: END IF;
2419:
2420: -- populate the cached structure ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash
2421: -- for reference by ZX_TDS_APPLICABILITY_DETM_PKG.get_process_Results for batch calculation calls
2422: -- since this procedure only checks the existence of a rate record having the same tax class
2423: -- it should be ok to refecene this record.
2424:

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

2427: x_tax_rate_rec.tax_status_code||x_tax_rate_rec.tax_rate_code,
2428: 1,
2429: 8192);
2430:
2431: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index) := x_tax_rate_rec;
2432:
2433: IF (g_level_procedure >= g_current_runtime_level ) THEN
2434: FND_LOG.STRING(g_level_procedure,
2435: g_module_name||'.'||l_procedure_name||'.END',