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 241: -- get the tax rate information from zx_rates_b

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

Line 389: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

385: -- information and the jurisdiction info in zx_jurisdictions_gt
386: ------------------------------------------------------------------------------
387: PROCEDURE get_def_tax_rate_by_jur_gt(
388: p_tax_class IN VARCHAR2,
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,

Line 390: p_tax IN ZX_RATES_B.tax%TYPE,

386: ------------------------------------------------------------------------------
387: PROCEDURE get_def_tax_rate_by_jur_gt(
388: p_tax_class IN VARCHAR2,
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

Line 392: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

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

Line 642: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

638: -- information
639: ------------------------------------------------------------------------------
640: PROCEDURE get_tax_rate_by_jur_code(
641: p_tax_class IN VARCHAR2,
642: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
643: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 643: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

639: ------------------------------------------------------------------------------
640: PROCEDURE get_tax_rate_by_jur_code(
641: p_tax_class IN VARCHAR2,
642: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
643: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 644: p_tax IN ZX_RATES_B.tax%TYPE,

640: PROCEDURE get_tax_rate_by_jur_code(
641: p_tax_class IN VARCHAR2,
642: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
643: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%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,

Line 646: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

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

Line 647: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

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

Line 891: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

887: ------------------------------------------------------------------------------
888:
889: PROCEDURE get_tax_rate_no_jur_code(
890: p_tax_class IN VARCHAR2,
891: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 892: p_tax IN ZX_RATES_B.tax%TYPE,

888:
889: PROCEDURE get_tax_rate_no_jur_code(
890: p_tax_class IN VARCHAR2,
891: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 894: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

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

Line 895: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

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

Line 1130: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1126: ------------------------------------------------------------------------------
1127:
1128: PROCEDURE get_def_tax_rate_by_jur_code(
1129: p_tax_class IN VARCHAR2,
1130: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 1131: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

1127:
1128: PROCEDURE get_def_tax_rate_by_jur_code(
1129: p_tax_class IN VARCHAR2,
1130: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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,

Line 1132: p_tax IN ZX_RATES_B.tax%TYPE,

1128: PROCEDURE get_def_tax_rate_by_jur_code(
1129: p_tax_class IN VARCHAR2,
1130: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%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

Line 1134: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

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

Line 1373: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1369: ------------------------------------------------------------------------------
1370:
1371: PROCEDURE get_def_tax_rate_no_jur_code(
1372: p_tax_class IN VARCHAR2,
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,

Line 1374: p_tax IN ZX_RATES_B.tax%TYPE,

1370:
1371: PROCEDURE get_def_tax_rate_no_jur_code(
1372: p_tax_class IN VARCHAR2,
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

Line 1376: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

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

Line 1618: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1614: ------------------------------------------------------------------------------
1615:
1616: PROCEDURE get_tax_rate_internal(
1617: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1618: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1619: p_tax IN ZX_RATES_B.tax%TYPE,
1620: p_tax_date IN DATE,
1621: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1622: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 1619: p_tax IN ZX_RATES_B.tax%TYPE,

1615:
1616: PROCEDURE get_tax_rate_internal(
1617: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1618: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1619: p_tax IN ZX_RATES_B.tax%TYPE,
1620: p_tax_date IN DATE,
1621: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1621: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1617: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
1618: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1619: p_tax IN ZX_RATES_B.tax%TYPE,
1620: p_tax_date IN DATE,
1621: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1622: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

1618: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1619: p_tax IN ZX_RATES_B.tax%TYPE,
1620: p_tax_date IN DATE,
1621: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1633: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

1629:
1630: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_internal';
1631: l_structure_name VARCHAR2(30);
1632: l_location_id NUMBER;
1633: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1634: l_tax_param_code VARCHAR2(30);
1635: l_jurisdictions_found VARCHAR2(1);
1636: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1637: l_multiple_jurisdictions_flag VARCHAR2(1);

Line 1808: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1804: ------------------------------------------------------------------------------
1805:
1806: PROCEDURE get_tax_rate_pvt(
1807: p_tax_class IN VARCHAR2,
1808: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1810: p_tax IN ZX_RATES_B.tax%TYPE,
1811: p_tax_date IN DATE,
1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

1805:
1806: PROCEDURE get_tax_rate_pvt(
1807: p_tax_class IN VARCHAR2,
1808: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1810: p_tax IN ZX_RATES_B.tax%TYPE,
1811: p_tax_date IN DATE,
1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
1813: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 1810: p_tax IN ZX_RATES_B.tax%TYPE,

1806: PROCEDURE get_tax_rate_pvt(
1807: p_tax_class IN VARCHAR2,
1808: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1810: p_tax IN ZX_RATES_B.tax%TYPE,
1811: p_tax_date IN DATE,
1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

1808: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1810: p_tax IN ZX_RATES_B.tax%TYPE,
1811: p_tax_date IN DATE,
1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1813: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

1809: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
1810: p_tax IN ZX_RATES_B.tax%TYPE,
1811: p_tax_date IN DATE,
1812: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 1822: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

1818: x_return_status OUT NOCOPY VARCHAR2
1819: ) IS
1820:
1821: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_rate_pvt';
1822: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1823: l_ind_rec NUMBER;
1824: BEGIN
1825:
1826: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2002: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

1998: ------------------------------------------------------------------------------
1999:
2000: PROCEDURE get_def_tax_rate_pvt(
2001: p_tax_class IN VARCHAR2,
2002: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2003: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2004: p_tax IN ZX_RATES_B.tax%TYPE,
2005: p_tax_date IN DATE,
2006: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 2003: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

1999:
2000: PROCEDURE get_def_tax_rate_pvt(
2001: p_tax_class IN VARCHAR2,
2002: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2003: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2004: p_tax IN ZX_RATES_B.tax%TYPE,
2005: p_tax_date IN DATE,
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,

Line 2004: p_tax IN ZX_RATES_B.tax%TYPE,

2000: PROCEDURE get_def_tax_rate_pvt(
2001: p_tax_class IN VARCHAR2,
2002: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2003: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2004: p_tax IN ZX_RATES_B.tax%TYPE,
2005: p_tax_date IN DATE,
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,

Line 2006: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

2002: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2003: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2004: p_tax IN ZX_RATES_B.tax%TYPE,
2005: p_tax_date IN DATE,
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,

Line 2194: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

2190: ------------------------------------------------------------------------------
2191:
2192: PROCEDURE get_tax_rate(
2193: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2194: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2196: p_tax IN ZX_RATES_B.tax%TYPE,
2197: p_tax_date IN DATE,
2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

Line 2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,

2191:
2192: PROCEDURE get_tax_rate(
2193: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2194: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2196: p_tax IN ZX_RATES_B.tax%TYPE,
2197: p_tax_date IN DATE,
2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,
2199: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

Line 2196: p_tax IN ZX_RATES_B.tax%TYPE,

2192: PROCEDURE get_tax_rate(
2193: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
2194: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2196: p_tax IN ZX_RATES_B.tax%TYPE,
2197: p_tax_date IN DATE,
2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%TYPE,

2194: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2196: p_tax IN ZX_RATES_B.tax%TYPE,
2197: p_tax_date IN DATE,
2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,

Line 2199: p_tax_rate_code IN ZX_RATES_B.tax_rate_code%TYPE,

2195: p_tax_jurisdiction_code IN ZX_RATES_B.tax_jurisdiction_code%TYPE,
2196: p_tax IN ZX_RATES_B.tax%TYPE,
2197: p_tax_date IN DATE,
2198: p_tax_status_code IN ZX_RATES_B.tax_status_code%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,