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_RULES_PKG dependencies on ZX_TAXES_B

Line 51: --update zx_taxes_b entity for the flags, as per the latest UE changes

47:
48: begin
49:
50: -- Bug 5501831 - If no tax exists then Update the GCO Tax
51: --update zx_taxes_b entity for the flags, as per the latest UE changes
52: IF (X_SERVICE_TYPE_CODE = 'DET_PLACE_OF_SUPPLY') THEN
53:
54: UPDATE ZX_TAXES_B
55: SET PLACE_OF_SUPPLY_RULE_FLAG = 'Y'

Line 54: UPDATE ZX_TAXES_B

50: -- Bug 5501831 - If no tax exists then Update the GCO Tax
51: --update zx_taxes_b entity for the flags, as per the latest UE changes
52: IF (X_SERVICE_TYPE_CODE = 'DET_PLACE_OF_SUPPLY') THEN
53:
54: UPDATE ZX_TAXES_B
55: SET PLACE_OF_SUPPLY_RULE_FLAG = 'Y'
56: WHERE
57: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
58: TAX = X_TAX AND

Line 62: UPDATE ZX_TAXES_B

58: TAX = X_TAX AND
59: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
60:
61: IF (SQL%NOTFOUND) THEN
62: UPDATE ZX_TAXES_B
63: SET PLACE_OF_SUPPLY_RULE_FLAG = 'Y'
64: WHERE
65: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
66: TAX = X_TAX AND

Line 72: UPDATE ZX_TAXES_B

68: END IF;
69:
70: ELSIF (X_SERVICE_TYPE_CODE = 'DET_TAX_REGISTRATION') THEN
71:
72: UPDATE ZX_TAXES_B
73: SET REGISTRATION_TYPE_RULE_FLAG = 'Y'
74: WHERE
75: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
76: TAX = X_TAX AND

Line 80: UPDATE ZX_TAXES_B

76: TAX = X_TAX AND
77: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
78:
79: IF (SQL%NOTFOUND) THEN
80: UPDATE ZX_TAXES_B
81: SET REGISTRATION_TYPE_RULE_FLAG = 'Y'
82: WHERE
83: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
84: TAX = X_TAX AND

Line 90: UPDATE ZX_TAXES_B

86: END IF;
87:
88: ELSIF(X_SERVICE_TYPE_CODE = 'CALCULATE_TAX_AMOUNTS') THEN
89:
90: UPDATE ZX_TAXES_B
91: SET TAX_CALC_RULE_FLAG = 'Y'
92: WHERE
93: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
94: TAX = X_TAX AND

Line 98: UPDATE ZX_TAXES_B

94: TAX = X_TAX AND
95: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
96:
97: IF (SQL%NOTFOUND) THEN
98: UPDATE ZX_TAXES_B
99: SET TAX_CALC_RULE_FLAG = 'Y'
100: WHERE
101: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
102: TAX = X_TAX AND

Line 108: UPDATE ZX_TAXES_B

104: END IF;
105:
106: ELSIF (X_SERVICE_TYPE_CODE = 'DET_TAXABLE_BASIS') THEN
107:
108: UPDATE ZX_TAXES_B
109: SET TAXABLE_BASIS_RULE_FLAG = 'Y'
110: WHERE
111: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
112: TAX = X_TAX AND

Line 116: UPDATE ZX_TAXES_B

112: TAX = X_TAX AND
113: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
114:
115: IF (SQL%NOTFOUND) THEN
116: UPDATE ZX_TAXES_B
117: SET TAXABLE_BASIS_RULE_FLAG = 'Y'
118: WHERE
119: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
120: TAX = X_TAX AND

Line 126: UPDATE ZX_TAXES_B

122: END IF;
123:
124: ELSIF (X_SERVICE_TYPE_CODE = 'DET_TAX_RATE') THEN
125:
126: UPDATE ZX_TAXES_B
127: SET TAX_RATE_RULE_FLAG = 'Y'
128: WHERE
129: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
130: TAX = X_TAX AND

Line 134: UPDATE ZX_TAXES_B

130: TAX = X_TAX AND
131: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
132:
133: IF (SQL%NOTFOUND) THEN
134: UPDATE ZX_TAXES_B
135: SET TAX_RATE_RULE_FLAG = 'Y'
136: WHERE
137: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
138: TAX = X_TAX AND

Line 144: UPDATE ZX_TAXES_B

140: END IF;
141:
142: ELSIF (X_SERVICE_TYPE_CODE = 'DET_TAX_STATUS') THEN
143:
144: UPDATE ZX_TAXES_B
145: SET TAX_STATUS_RULE_FLAG = 'Y'
146: WHERE
147: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
148: TAX = X_TAX AND

Line 152: UPDATE ZX_TAXES_B

148: TAX = X_TAX AND
149: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
150:
151: IF (SQL%NOTFOUND) THEN
152: UPDATE ZX_TAXES_B
153: SET TAX_STATUS_RULE_FLAG = 'Y'
154: WHERE
155: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
156: TAX = X_TAX AND

Line 162: UPDATE ZX_TAXES_B

158: END IF;
159:
160: ELSIF (X_SERVICE_TYPE_CODE = 'DET_APPLICABLE_TAXES') THEN
161:
162: UPDATE ZX_TAXES_B
163: SET APPLICABILITY_RULE_FLAG = 'Y'
164: WHERE
165: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
166: TAX = X_TAX AND

Line 171: UPDATE ZX_TAXES_B

167: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
168:
169: -- Bug 5501831 - If no tax exists then Update the GCO Tax
170: /*IF (SQL%NOTFOUND) THEN
171: UPDATE ZX_TAXES_B
172: SET APPLICABILITY_RULE_FLAG = 'Y'
173: WHERE
174: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
175: TAX = X_TAX AND

Line 180: SELECT zx_taxes_b_s.nextval INTO l_tax_id from dual;

176: CONTENT_OWNER_ID = -99;
177: END IF;*/
178: -- Bug 5548613 - Copying tax in this case
179: IF (SQL%NOTFOUND) THEN
180: SELECT zx_taxes_b_s.nextval INTO l_tax_id from dual;
181:
182: INSERT INTO ZX_TAXES_B_TMP
183: (
184: TAX ,

Line 182: INSERT INTO ZX_TAXES_B_TMP

178: -- Bug 5548613 - Copying tax in this case
179: IF (SQL%NOTFOUND) THEN
180: SELECT zx_taxes_b_s.nextval INTO l_tax_id from dual;
181:
182: INSERT INTO ZX_TAXES_B_TMP
183: (
184: TAX ,
185: EFFECTIVE_FROM ,
186: EFFECTIVE_TO ,

Line 412: FROM ZX_TAXES_B

408: TAX_EXMPT_SOURCE_TAX ,
409: APPLICABLE_BY_DEFAULT_FLAG ,
410: ALLOW_DUP_REGN_NUM_FLAG ,
411: LEGAL_REPORTING_STATUS_DEF_VAL
412: FROM ZX_TAXES_B
413: WHERE TAX_REGIME_CODE = X_TAX_REGIME_CODE
414: AND TAX = X_TAX
415: AND CONTENT_OWNER_ID = -99;
416: --RETURNING TAX_ID INTO l_tax_id;

Line 442: ZX_TAXES_B ztb

438: X_LAST_UPDATE_DATE ,
439: X_LAST_UPDATE_LOGIN ,
440: l_tax_id
441: FROM ZX_TAXES_TL zttl,
442: ZX_TAXES_B ztb
443: WHERE ztb.TAX_REGIME_CODE = X_TAX_REGIME_CODE
444: AND ztb.TAX = X_TAX
445: AND ztb.CONTENT_OWNER_ID = -99
446: AND zttl.TAX_ID = ztb.TAX_ID;

Line 453: UPDATE ZX_TAXES_B

449: END IF;
450:
451: ELSIF (X_SERVICE_TYPE_CODE = 'DET_DIRECT_RATE') THEN
452:
453: UPDATE ZX_TAXES_B
454: SET DIRECT_RATE_RULE_FLAG = 'Y'
455: WHERE
456: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
457: TAX = X_TAX AND

Line 461: UPDATE ZX_TAXES_B

457: TAX = X_TAX AND
458: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
459:
460: IF (SQL%NOTFOUND) THEN
461: UPDATE ZX_TAXES_B
462: SET DIRECT_RATE_RULE_FLAG = 'Y'
463: WHERE
464: TAX_REGIME_CODE = X_TAX_REGIME_CODE AND
465: TAX = X_TAX AND