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_RATES_B

Line 12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';
9:
10: PROCEDURE get_tax_rate_by_jur_gt(
11: p_tax_class IN VARCHAR2,
12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 13: p_tax IN ZX_RATES_B.tax%TYPE,

9:
10: PROCEDURE get_tax_rate_by_jur_gt(
11: p_tax_class IN VARCHAR2,
12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 15: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

11: p_tax_class IN VARCHAR2,
12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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: );

Line 16: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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:

Line 23: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

19: );
20:
21: PROCEDURE get_def_tax_rate_by_jur_gt(
22: p_tax_class IN VARCHAR2,
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,

Line 24: p_tax IN ZX_RATES_B.tax%TYPE,

20:
21: PROCEDURE get_def_tax_rate_by_jur_gt(
22: p_tax_class IN VARCHAR2,
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

Line 26: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

22: p_tax_class IN VARCHAR2,
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:

Line 33: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

29: );
30:
31: PROCEDURE get_tax_rate_by_jur_code(
32: p_tax_class IN VARCHAR2,
33: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

30:
31: PROCEDURE get_tax_rate_by_jur_code(
32: p_tax_class IN VARCHAR2,
33: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 35: p_tax IN ZX_RATES_B.tax%TYPE,

31: PROCEDURE get_tax_rate_by_jur_code(
32: p_tax_class IN VARCHAR2,
33: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 37: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

33: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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: );

Line 38: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

34: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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:

Line 45: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

41: );
42:
43: PROCEDURE get_tax_rate_no_jur_code(
44: p_tax_class IN VARCHAR2,
45: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 46: p_tax IN ZX_RATES_B.tax%TYPE,

42:
43: PROCEDURE get_tax_rate_no_jur_code(
44: p_tax_class IN VARCHAR2,
45: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 48: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

44: p_tax_class IN VARCHAR2,
45: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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: );

Line 49: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

45: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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(

Line 55: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

51: x_return_status OUT NOCOPY VARCHAR2
52: );
53: PROCEDURE get_def_tax_rate_by_jur_code(
54: p_tax_class IN VARCHAR2,
55: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 56: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

52: );
53: PROCEDURE get_def_tax_rate_by_jur_code(
54: p_tax_class IN VARCHAR2,
55: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 57: p_tax IN ZX_RATES_B.tax%TYPE,

53: PROCEDURE get_def_tax_rate_by_jur_code(
54: p_tax_class IN VARCHAR2,
55: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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

Line 59: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

55: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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:

Line 66: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

62: );
63:
64: PROCEDURE get_def_tax_rate_no_jur_code(
65: p_tax_class IN VARCHAR2,
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,

Line 67: p_tax IN ZX_RATES_B.tax%TYPE,

63:
64: PROCEDURE get_def_tax_rate_no_jur_code(
65: p_tax_class IN VARCHAR2,
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

Line 69: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

65: p_tax_class IN VARCHAR2,
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:

Line 76: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

72: );
73:
74: PROCEDURE get_tax_rate_internal(
75: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
76: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
77: p_tax IN ZX_RATES_B.tax%TYPE,
78: p_tax_date IN DATE,
79: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
80: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 77: p_tax IN ZX_RATES_B.tax%TYPE,

73:
74: PROCEDURE get_tax_rate_internal(
75: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
76: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
77: p_tax IN ZX_RATES_B.tax%TYPE,
78: p_tax_date IN DATE,
79: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 79: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

75: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
76: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
77: p_tax IN ZX_RATES_B.tax%TYPE,
78: p_tax_date IN DATE,
79: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 80: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

76: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
77: p_tax IN ZX_RATES_B.tax%TYPE,
78: p_tax_date IN DATE,
79: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 90: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

86: );
87:
88: PROCEDURE get_tax_rate_pvt(
89: p_tax_class IN VARCHAR2,
90: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
92: p_tax IN ZX_RATES_B.tax%TYPE,
93: p_tax_date IN DATE,
94: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

87:
88: PROCEDURE get_tax_rate_pvt(
89: p_tax_class IN VARCHAR2,
90: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
92: p_tax IN ZX_RATES_B.tax%TYPE,
93: p_tax_date IN DATE,
94: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
95: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 92: p_tax IN ZX_RATES_B.tax%TYPE,

88: PROCEDURE get_tax_rate_pvt(
89: p_tax_class IN VARCHAR2,
90: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
92: p_tax IN ZX_RATES_B.tax%TYPE,
93: p_tax_date IN DATE,
94: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 94: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

90: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
92: p_tax IN ZX_RATES_B.tax%TYPE,
93: p_tax_date IN DATE,
94: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 95: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

91: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
92: p_tax IN ZX_RATES_B.tax%TYPE,
93: p_tax_date IN DATE,
94: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 105: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

101: );
102:
103: PROCEDURE get_def_tax_rate_pvt(
104: p_tax_class IN VARCHAR2,
105: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
106: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
107: p_tax IN ZX_RATES_B.tax%TYPE,
108: p_tax_date IN DATE,
109: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 106: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

102:
103: PROCEDURE get_def_tax_rate_pvt(
104: p_tax_class IN VARCHAR2,
105: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
106: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
107: p_tax IN ZX_RATES_B.tax%TYPE,
108: p_tax_date IN DATE,
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,

Line 107: p_tax IN ZX_RATES_B.tax%TYPE,

103: PROCEDURE get_def_tax_rate_pvt(
104: p_tax_class IN VARCHAR2,
105: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
106: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
107: p_tax IN ZX_RATES_B.tax%TYPE,
108: p_tax_date IN DATE,
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,

Line 109: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

105: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
106: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
107: p_tax IN ZX_RATES_B.tax%TYPE,
108: p_tax_date IN DATE,
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,

Line 128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

124: -- information and the jurisdiction info in zx_jurisdictions_gt
125: ------------------------------------------------------------------------------
126: PROCEDURE get_tax_rate_by_jur_gt(
127: p_tax_class IN VARCHAR2,
128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 129: p_tax IN ZX_RATES_B.tax%TYPE,

125: ------------------------------------------------------------------------------
126: PROCEDURE get_tax_rate_by_jur_gt(
127: p_tax_class IN VARCHAR2,
128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 131: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

127: p_tax_class IN VARCHAR2,
128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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

Line 132: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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:

Line 243: -- get the tax rate information from zx_rates_b

239: -- p_tax_status_code,
240: -- p_tax_rate_code,
241: -- p_tax_date
242: -- and jurisdiction info in zx_jurisdictions_gt to
243: -- get the tax rate information from zx_rates_b
244: --
245: OPEN get_tax_rate_csr;
246:
247: -- the first rate(the one with smallest precedence_level value) from the

Line 394: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

390: -- information and the jurisdiction info in zx_jurisdictions_gt
391: ------------------------------------------------------------------------------
392: PROCEDURE get_def_tax_rate_by_jur_gt(
393: p_tax_class IN VARCHAR2,
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,

Line 395: p_tax IN ZX_RATES_B.tax%TYPE,

391: ------------------------------------------------------------------------------
392: PROCEDURE get_def_tax_rate_by_jur_gt(
393: p_tax_class IN VARCHAR2,
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

Line 397: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

393: p_tax_class IN VARCHAR2,
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:

Line 652: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

648: -- information
649: ------------------------------------------------------------------------------
650: PROCEDURE get_tax_rate_by_jur_code(
651: p_tax_class IN VARCHAR2,
652: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

649: ------------------------------------------------------------------------------
650: PROCEDURE get_tax_rate_by_jur_code(
651: p_tax_class IN VARCHAR2,
652: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 654: p_tax IN ZX_RATES_B.tax%TYPE,

650: PROCEDURE get_tax_rate_by_jur_code(
651: p_tax_class IN VARCHAR2,
652: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 656: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

652: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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

Line 657: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

653: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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:

Line 904: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

900: ------------------------------------------------------------------------------
901:
902: PROCEDURE get_tax_rate_no_jur_code(
903: p_tax_class IN VARCHAR2,
904: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 905: p_tax IN ZX_RATES_B.tax%TYPE,

901:
902: PROCEDURE get_tax_rate_no_jur_code(
903: p_tax_class IN VARCHAR2,
904: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 907: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

903: p_tax_class IN VARCHAR2,
904: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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

Line 908: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

904: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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:

Line 1146: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1142: ------------------------------------------------------------------------------
1143:
1144: PROCEDURE get_def_tax_rate_by_jur_code(
1145: p_tax_class IN VARCHAR2,
1146: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 1147: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

1143:
1144: PROCEDURE get_def_tax_rate_by_jur_code(
1145: p_tax_class IN VARCHAR2,
1146: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 1148: p_tax IN ZX_RATES_B.tax%TYPE,

1144: PROCEDURE get_def_tax_rate_by_jur_code(
1145: p_tax_class IN VARCHAR2,
1146: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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

Line 1150: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1146: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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:

Line 1392: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1388: ------------------------------------------------------------------------------
1389:
1390: PROCEDURE get_def_tax_rate_no_jur_code(
1391: p_tax_class IN VARCHAR2,
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,

Line 1393: p_tax IN ZX_RATES_B.tax%TYPE,

1389:
1390: PROCEDURE get_def_tax_rate_no_jur_code(
1391: p_tax_class IN VARCHAR2,
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

Line 1395: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1391: p_tax_class IN VARCHAR2,
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:

Line 1640: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1636: ------------------------------------------------------------------------------
1637:
1638: PROCEDURE get_tax_rate_internal(
1639: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1640: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1641: p_tax IN ZX_RATES_B.tax%TYPE,
1642: p_tax_date IN DATE,
1643: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1644: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 1641: p_tax IN ZX_RATES_B.tax%TYPE,

1637:
1638: PROCEDURE get_tax_rate_internal(
1639: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1640: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1641: p_tax IN ZX_RATES_B.tax%TYPE,
1642: p_tax_date IN DATE,
1643: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1643: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1639: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1640: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1641: p_tax IN ZX_RATES_B.tax%TYPE,
1642: p_tax_date IN DATE,
1643: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1644: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

1640: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1641: p_tax IN ZX_RATES_B.tax%TYPE,
1642: p_tax_date IN DATE,
1643: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1655: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

1651:
1652: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_internal';
1653: l_structure_name VARCHAR2(30);
1654: l_location_id NUMBER;
1655: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1656: l_tax_param_code VARCHAR2(30);
1657: l_jurisdictions_found VARCHAR2(1);
1658: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1659: l_multiple_jurisdictions_flag VARCHAR2(1);

Line 1830: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1826: ------------------------------------------------------------------------------
1827:
1828: PROCEDURE get_tax_rate_pvt(
1829: p_tax_class IN VARCHAR2,
1830: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1832: p_tax IN ZX_RATES_B.tax%TYPE,
1833: p_tax_date IN DATE,
1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

1827:
1828: PROCEDURE get_tax_rate_pvt(
1829: p_tax_class IN VARCHAR2,
1830: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1832: p_tax IN ZX_RATES_B.tax%TYPE,
1833: p_tax_date IN DATE,
1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1835: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 1832: p_tax IN ZX_RATES_B.tax%TYPE,

1828: PROCEDURE get_tax_rate_pvt(
1829: p_tax_class IN VARCHAR2,
1830: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1832: p_tax IN ZX_RATES_B.tax%TYPE,
1833: p_tax_date IN DATE,
1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1830: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1832: p_tax IN ZX_RATES_B.tax%TYPE,
1833: p_tax_date IN DATE,
1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1835: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

1831: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1832: p_tax IN ZX_RATES_B.tax%TYPE,
1833: p_tax_date IN DATE,
1834: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1844: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

1840: x_return_status OUT NOCOPY VARCHAR2
1841: ) IS
1842:
1843: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_pvt';
1844: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1845: l_ind_rec NUMBER;
1846: BEGIN
1847:
1848: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2024: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

2020: ------------------------------------------------------------------------------
2021:
2022: PROCEDURE get_def_tax_rate_pvt(
2023: p_tax_class IN VARCHAR2,
2024: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2025: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2026: p_tax IN ZX_RATES_B.tax%TYPE,
2027: p_tax_date IN DATE,
2028: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 2025: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

2021:
2022: PROCEDURE get_def_tax_rate_pvt(
2023: p_tax_class IN VARCHAR2,
2024: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2025: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2026: p_tax IN ZX_RATES_B.tax%TYPE,
2027: p_tax_date IN DATE,
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,

Line 2026: p_tax IN ZX_RATES_B.tax%TYPE,

2022: PROCEDURE get_def_tax_rate_pvt(
2023: p_tax_class IN VARCHAR2,
2024: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2025: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2026: p_tax IN ZX_RATES_B.tax%TYPE,
2027: p_tax_date IN DATE,
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,

Line 2028: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

2024: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2025: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2026: p_tax IN ZX_RATES_B.tax%TYPE,
2027: p_tax_date IN DATE,
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,

Line 2216: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

2212: ------------------------------------------------------------------------------
2213:
2214: PROCEDURE get_tax_rate(
2215: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2216: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2218: p_tax IN ZX_RATES_B.tax%TYPE,
2219: p_tax_date IN DATE,
2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

2213:
2214: PROCEDURE get_tax_rate(
2215: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2216: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2218: p_tax IN ZX_RATES_B.tax%TYPE,
2219: p_tax_date IN DATE,
2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
2221: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 2218: p_tax IN ZX_RATES_B.tax%TYPE,

2214: PROCEDURE get_tax_rate(
2215: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2216: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2218: p_tax IN ZX_RATES_B.tax%TYPE,
2219: p_tax_date IN DATE,
2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

2216: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2218: p_tax IN ZX_RATES_B.tax%TYPE,
2219: p_tax_date IN DATE,
2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 2221: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

2217: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2218: p_tax IN ZX_RATES_B.tax%TYPE,
2219: p_tax_date IN DATE,
2220: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,