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.ARP_TAX_INTERFACE dependencies on STANDARD

Line 96: nvl(ci.end_date, arp_standard.max_end_date) end_date,

92: ci.interface_line_id,
93: ci.location_segment_id,
94: ci.segment_qualifier,
95: trunc(nvl(ci.start_date, default_start_date)) start_date,
96: nvl(ci.end_date, arp_standard.max_end_date) end_date,
97: nvl(ci.from_postal_code,arp_standard.sysparm.from_postal_code ) from_postal_code,
98: nvl(ci.to_postal_code,arp_standard.sysparm.to_postal_code ) to_postal_code,
99: ci.rate_type,
100: ci.tax_rate,

Line 97: nvl(ci.from_postal_code,arp_standard.sysparm.from_postal_code ) from_postal_code,

93: ci.location_segment_id,
94: ci.segment_qualifier,
95: trunc(nvl(ci.start_date, default_start_date)) start_date,
96: nvl(ci.end_date, arp_standard.max_end_date) end_date,
97: nvl(ci.from_postal_code,arp_standard.sysparm.from_postal_code ) from_postal_code,
98: nvl(ci.to_postal_code,arp_standard.sysparm.to_postal_code ) to_postal_code,
99: ci.rate_type,
100: ci.tax_rate,
101: ci.parent_location_id,

Line 98: nvl(ci.to_postal_code,arp_standard.sysparm.to_postal_code ) to_postal_code,

94: ci.segment_qualifier,
95: trunc(nvl(ci.start_date, default_start_date)) start_date,
96: nvl(ci.end_date, arp_standard.max_end_date) end_date,
97: nvl(ci.from_postal_code,arp_standard.sysparm.from_postal_code ) from_postal_code,
98: nvl(ci.to_postal_code,arp_standard.sysparm.to_postal_code ) to_postal_code,
99: ci.rate_type,
100: ci.tax_rate,
101: ci.parent_location_id,
102: ci.location_id,

Line 119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)

115: where t1.location_value = t2.location_value
116: and t1.segment_qualifier = 'CITY'
117: and t1.parent_location_id = t2.parent_location_id
118: and t1.interface_line_id <> t2.interface_line_id
119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)
120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

Line 120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

116: and t1.segment_qualifier = 'CITY'
117: and t1.parent_location_id = t2.parent_location_id
118: and t1.interface_line_id <> t2.interface_line_id
119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)
120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

Line 121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

117: and t1.parent_location_id = t2.parent_location_id
118: and t1.interface_line_id <> t2.interface_line_id
119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)
120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

Line 122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))

118: and t1.interface_line_id <> t2.interface_line_id
119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)
120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))

Line 123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

119: and ( ((( nvl(t1.from_postal_code,arp_standard.sysparm.from_postal_code)
120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

Line 124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

120: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

Line 125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

121: and ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

Line 126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))

122: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))

Line 127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

123: or (( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

Line 128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

124: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

Line 129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

125: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

Line 130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))

126: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )))
127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )

Line 131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

127: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )

Line 132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )

128: <= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

Line 133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

129: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))

Line 134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )

130: >= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ))
131: and not (( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))
138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

Line 136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)

132: >= nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code) )
133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))
138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
139: = nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ) )
140: )

Line 137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))

133: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))
138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
139: = nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ) )
140: )
141: and st.location_value like nvl(senior_segment,'%')

Line 138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)

134: <= nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) )) )
135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))
138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
139: = nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ) )
140: )
141: and st.location_value like nvl(senior_segment,'%')
142: and co.parent_location_id = st.location_id

Line 139: = nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ) )

135: and ( trunc(nvl(t1.start_date, default_start_date)) = trunc(nvl(t2.start_date, default_start_date)) )
136: and not( ( nvl(t1.from_postal_code, arp_standard.sysparm.from_postal_code)
137: = nvl(t2.from_postal_code, arp_standard.sysparm.from_postal_code))
138: and ( nvl(t1.to_postal_code, arp_standard.sysparm.to_postal_code)
139: = nvl(t2.to_postal_code, arp_standard.sysparm.to_postal_code) ) )
140: )
141: and st.location_value like nvl(senior_segment,'%')
142: and co.parent_location_id = st.location_id
143: and ci.parent_location_id = co.location_id

Line 160: nvl(end_date, arp_standard.max_end_date) end_date,

156: interface_line_id,
157: location_segment_id,
158: segment_qualifier,
159: nvl(start_date, default_start_date) start_date,
160: nvl(end_date, arp_standard.max_end_date) end_date,
161: nvl(from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
162: nvl(to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
163: rate_type,
164: tax_rate,

Line 161: nvl(from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,

157: location_segment_id,
158: segment_qualifier,
159: nvl(start_date, default_start_date) start_date,
160: nvl(end_date, arp_standard.max_end_date) end_date,
161: nvl(from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
162: nvl(to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
163: rate_type,
164: tax_rate,
165: parent_location_id,

Line 162: nvl(to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,

158: segment_qualifier,
159: nvl(start_date, default_start_date) start_date,
160: nvl(end_date, arp_standard.max_end_date) end_date,
161: nvl(from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
162: nvl(to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
163: rate_type,
164: tax_rate,
165: parent_location_id,
166: location_value

Line 175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

171: and parent_location_id = p_parent_location_id
172: and location_value = p_location_value
173: and rate_type = p_rate_type
174: and status is null
175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

Line 176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

172: and location_value = p_location_value
173: and rate_type = p_rate_type
174: and status is null
175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

Line 177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

173: and rate_type = p_rate_type
174: and status is null
175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

Line 178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))

174: and status is null
175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))

Line 179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

175: and ( ((nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

Line 180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

176: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

Line 181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

177: and nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

Line 182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))

178: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))

Line 183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

179: or (nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

Line 184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

180: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

Line 185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

181: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

Line 186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))

182: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))

Line 187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

183: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

Line 188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

184: >= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

Line 189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

185: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

Line 190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))

186: <= nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))

Line 191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)

187: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
195: and trunc(nvl(p_start_date,default_start_date)) = trunc(nvl(start_date, default_start_date));

Line 192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)

188: <= nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
195: and trunc(nvl(p_start_date,default_start_date)) = trunc(nvl(start_date, default_start_date));
196:

Line 193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)

189: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
195: and trunc(nvl(p_start_date,default_start_date)) = trunc(nvl(start_date, default_start_date));
196:
197: l_interface_line_id number;

Line 194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))

190: >= nvl(to_postal_code, arp_standard.sysparm.to_postal_code)))
191: and not (nvl(p_from_postal_code, arp_standard.sysparm.from_postal_code)
192: = nvl(from_postal_code, arp_standard.sysparm.from_postal_code)
193: and nvl(p_to_postal_code, arp_standard.sysparm.to_postal_code)
194: = nvl(to_postal_code, arp_standard.sysparm.to_postal_code))
195: and trunc(nvl(p_start_date,default_start_date)) = trunc(nvl(start_date, default_start_date));
196:
197: l_interface_line_id number;
198: l_location_segment_id number;

Line 494: if ( old_end >= trunc(arp_standard.max_end_date) ) and

490: -- old: |-----------|
491: -- new: |------------------------->
492: -- Action: UPDATE-INSERT
493: --
494: if ( old_end >= trunc(arp_standard.max_end_date) ) and
495: ( trunc(new_start) > arp_standard.min_start_date ) then
496:
497: if new_start < old_start then
498:

Line 495: ( trunc(new_start) > arp_standard.min_start_date ) then

491: -- new: |------------------------->
492: -- Action: UPDATE-INSERT
493: --
494: if ( old_end >= trunc(arp_standard.max_end_date) ) and
495: ( trunc(new_start) > arp_standard.min_start_date ) then
496:
497: if new_start < old_start then
498:
499: /* The new record starts before the existing record, update the new */

Line 502: new_end := arp_standard.ceil(trunc( old_start -1 ));

498:
499: /* The new record starts before the existing record, update the new */
500: /* record so that it has an end date */
501:
502: new_end := arp_standard.ceil(trunc( old_start -1 ));
503: action := 'INSERT';
504:
505: else
506:

Line 510: old_end := arp_standard.ceil(new_start - 1);

506:
507: /* The new record, requires that the old record is terminated, before */
508: /* it can be inserted */
509:
510: old_end := arp_standard.ceil(new_start - 1);
511: action := 'UPDATE-INSERT';
512:
513: end if;
514:

Line 581: nvl(i.from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,

577: upper(i.location_value) location_value,
578: i.location_value location_user_value,
579: nvl(i.location_description, initcap(i.location_value)) location_description,
580: i.parent_location_id,
581: nvl(i.from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
582: nvl(i.to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
583: trunc(nvl(i.start_date, default_start_date)) start_date,
584: nvl(i.end_date, arp_standard.max_end_date) end_date,
585: i.tax_rate,

Line 582: nvl(i.to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,

578: i.location_value location_user_value,
579: nvl(i.location_description, initcap(i.location_value)) location_description,
580: i.parent_location_id,
581: nvl(i.from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
582: nvl(i.to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
583: trunc(nvl(i.start_date, default_start_date)) start_date,
584: nvl(i.end_date, arp_standard.max_end_date) end_date,
585: i.tax_rate,
586: i.location_segment_id,

Line 584: nvl(i.end_date, arp_standard.max_end_date) end_date,

580: i.parent_location_id,
581: nvl(i.from_postal_code, arp_standard.sysparm.from_postal_code ) from_postal_code,
582: nvl(i.to_postal_code, arp_standard.sysparm.to_postal_code ) to_postal_code,
583: trunc(nvl(i.start_date, default_start_date)) start_date,
584: nvl(i.end_date, arp_standard.max_end_date) end_date,
585: i.tax_rate,
586: i.location_segment_id,
587: i.status,
588: location_attribute_category,

Line 622: arp_standard.sysparm.location_structure_id),

618: rate_attribute14,
619: rate_attribute15,
620: decode(i.segment_qualifier, 'CITY',
621: nvl(i.override_structure_id,
622: arp_standard.sysparm.location_structure_id),
623: null) override_structure_id,
624: override_rate1,
625: override_rate2,
626: override_rate3,

Line 730: nvl( arp_standard.sysparm.default_country, 'US'),

726:
727: /* Defaults the country correctly */
728: location_id( current_level ) := arp_adds.find_location_segment_id(
729: 'COUNTRY',
730: nvl( arp_standard.sysparm.default_country, 'US'),
731: nvl( arp_standard.sysparm.default_country, 'US'),
732: null,
733: attribute_category => 'TRIGGER' );
734:

Line 731: nvl( arp_standard.sysparm.default_country, 'US'),

727: /* Defaults the country correctly */
728: location_id( current_level ) := arp_adds.find_location_segment_id(
729: 'COUNTRY',
730: nvl( arp_standard.sysparm.default_country, 'US'),
731: nvl( arp_standard.sysparm.default_country, 'US'),
732: null,
733: attribute_category => 'TRIGGER' );
734:
735: if arp_adds.location_segment_inserted then

Line 738: arp_standard.sysparm.from_postal_code,

734:
735: if arp_adds.location_segment_inserted then
736:
737: arp_adds.ins_location_rates( location_id(current_level),
738: arp_standard.sysparm.from_postal_code,
739: arp_standard.sysparm.to_postal_code,
740: arp_standard.min_start_date,
741: arp_standard.max_end_date,
742: 0,

Line 739: arp_standard.sysparm.to_postal_code,

735: if arp_adds.location_segment_inserted then
736:
737: arp_adds.ins_location_rates( location_id(current_level),
738: arp_standard.sysparm.from_postal_code,
739: arp_standard.sysparm.to_postal_code,
740: arp_standard.min_start_date,
741: arp_standard.max_end_date,
742: 0,
743: attribute_category => 'TRIGGER' );

Line 740: arp_standard.min_start_date,

736:
737: arp_adds.ins_location_rates( location_id(current_level),
738: arp_standard.sysparm.from_postal_code,
739: arp_standard.sysparm.to_postal_code,
740: arp_standard.min_start_date,
741: arp_standard.max_end_date,
742: 0,
743: attribute_category => 'TRIGGER' );
744: end if;

Line 741: arp_standard.max_end_date,

737: arp_adds.ins_location_rates( location_id(current_level),
738: arp_standard.sysparm.from_postal_code,
739: arp_standard.sysparm.to_postal_code,
740: arp_standard.min_start_date,
741: arp_standard.max_end_date,
742: 0,
743: attribute_category => 'TRIGGER' );
744: end if;
745:

Line 746: location_value( current_level ) := nvl( arp_standard.sysparm.default_country, 'US' );

742: 0,
743: attribute_category => 'TRIGGER' );
744: end if;
745:
746: location_value( current_level ) := nvl( arp_standard.sysparm.default_country, 'US' );
747: qual_adjust := 0;
748:
749: end;
750:

Line 759: location_from_postal_code( current_level ) := arp_standard.sysparm.from_postal_code;

755: location_id( current_level ) := null;
756:
757: end if;
758:
759: location_from_postal_code( current_level ) := arp_standard.sysparm.from_postal_code;
760: location_to_postal_code( current_level ) := arp_standard.sysparm.to_postal_code;
761: location_start_date( current_level ) := arp_standard.min_start_date;
762: location_end_date( current_level ) := arp_standard.max_end_date;
763:

Line 760: location_to_postal_code( current_level ) := arp_standard.sysparm.to_postal_code;

756:
757: end if;
758:
759: location_from_postal_code( current_level ) := arp_standard.sysparm.from_postal_code;
760: location_to_postal_code( current_level ) := arp_standard.sysparm.to_postal_code;
761: location_start_date( current_level ) := arp_standard.min_start_date;
762: location_end_date( current_level ) := arp_standard.max_end_date;
763:
764: /*--------------------------------------------------------------------------+

Line 761: location_start_date( current_level ) := arp_standard.min_start_date;

757: end if;
758:
759: location_from_postal_code( current_level ) := arp_standard.sysparm.from_postal_code;
760: location_to_postal_code( current_level ) := arp_standard.sysparm.to_postal_code;
761: location_start_date( current_level ) := arp_standard.min_start_date;
762: location_end_date( current_level ) := arp_standard.max_end_date;
763:
764: /*--------------------------------------------------------------------------+
765: | Loop over each record of the tax_interface table, selecting the rows |

Line 762: location_end_date( current_level ) := arp_standard.max_end_date;

758:
759: location_from_postal_code( current_level ) := arp_standard.sysparm.from_postal_code;
760: location_to_postal_code( current_level ) := arp_standard.sysparm.to_postal_code;
761: location_start_date( current_level ) := arp_standard.min_start_date;
762: location_end_date( current_level ) := arp_standard.max_end_date;
763:
764: /*--------------------------------------------------------------------------+
765: | Loop over each record of the tax_interface table, selecting the rows |
766: | in the hierarchy of the location flexfield. |

Line 784: FOR interface in interface_c( arp_standard.profile.request_id, senior_segment )

780: | unchanged. |
781: +--------------------------------------------------------------------------*/
782:
783:
784: FOR interface in interface_c( arp_standard.profile.request_id, senior_segment )
785: LOOP
786: BEGIN
787: interface.start_date := trunc( interface.start_date );
788: interface.end_date := arp_standard.ceil( interface.end_date );

Line 788: interface.end_date := arp_standard.ceil( interface.end_date );

784: FOR interface in interface_c( arp_standard.profile.request_id, senior_segment )
785: LOOP
786: BEGIN
787: interface.start_date := trunc( interface.start_date );
788: interface.end_date := arp_standard.ceil( interface.end_date );
789:
790: if pg_debug='Y' then
791: arp_util_tax.debug( 'INTERFACE: ' || to_char( interface.level, 0)
792: || '.' || interface.location_value || ' '

Line 815: arp_standard.fnd_message( 'AR_TAXI_LEVEL_TOO_DEEP' );

811: | raise an error. |
812: *------------------------------------------------------------------------*/
813:
814: if interface.level > segment then
815: arp_standard.fnd_message( 'AR_TAXI_LEVEL_TOO_DEEP' );
816: end if;
817:
818: if qualifier( interface.level - qual_adjust ) <> interface.segment_qualifier then
819:

Line 820: arp_standard.fnd_message( 'AR_TAXI_UNEXPECTED_QUALIFIER',

816: end if;
817:
818: if qualifier( interface.level - qual_adjust ) <> interface.segment_qualifier then
819:
820: arp_standard.fnd_message( 'AR_TAXI_UNEXPECTED_QUALIFIER',
821: 'EXPECTED', qualifier( interface.level - qual_adjust ),
822: 'FOUND', interface.segment_qualifier );
823:
824: end if;

Line 827: arp_standard.fnd_message( 'AR_TAXI_LOC_SEG_ID_HAS_VALUE' );

823:
824: end if;
825:
826: if interface.location_segment_id is not null then
827: arp_standard.fnd_message( 'AR_TAXI_LOC_SEG_ID_HAS_VALUE' );
828: end if;
829:
830: /*-----------------------------------------------------------------------+
831: | Populate table: AR_LOCATION_VALUES |

Line 883: arp_standard.fnd_message( 'AR_TAXI_LOCATION_BAD_PARENT',

879: basically a cmparsion */
880: if substrb( interface.location_id, 1, lengthb(interface.parent_location_id ) )
881: <> interface.parent_location_id then
882:
883: arp_standard.fnd_message( 'AR_TAXI_LOCATION_BAD_PARENT',
884: 'LOCATION_ID', interface.location_id,
885: 'PARENT_LOCATION_ID', interface.parent_location_id );
886: end if;
887:

Line 956: interface.from_postal_code = arp_standard.sysparm.from_postal_code and

952:
953: if new_location then
954:
955: if interface.tax_rate is NULL and
956: interface.from_postal_code = arp_standard.sysparm.from_postal_code and
957: interface.to_postal_code = arp_standard.sysparm.to_postal_code then
958: action := 'NEW-LOCATION';
959: else
960: action := 'NEW-LOCATION-INSERT';

Line 957: interface.to_postal_code = arp_standard.sysparm.to_postal_code then

953: if new_location then
954:
955: if interface.tax_rate is NULL and
956: interface.from_postal_code = arp_standard.sysparm.from_postal_code and
957: interface.to_postal_code = arp_standard.sysparm.to_postal_code then
958: action := 'NEW-LOCATION';
959: else
960: action := 'NEW-LOCATION-INSERT';
961: end if;

Line 971: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code),

967: /* for each existing location_rate assigned to sales tax see if the
968: record needs updating or inserting */
969: -- Bug 2609220 added parameter rate_attribute1 to cursor
970: for rates in location_rates_c( location_id(current_level),
971: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code),
972: nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code),
973: interface.start_date,
974: interface.end_date,
975: interface.rate_attribute1 )

Line 972: nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code),

968: record needs updating or inserting */
969: -- Bug 2609220 added parameter rate_attribute1 to cursor
970: for rates in location_rates_c( location_id(current_level),
971: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code),
972: nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code),
973: interface.start_date,
974: interface.end_date,
975: interface.rate_attribute1 )
976:

Line 995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||

991: arp_util_tax.debug('');
992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));

Line 996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));

992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||

Line 998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||

994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||
1001: ' - '||to_char(trunc(rates.end_date)));
1002: arp_util_tax.debug('Effective Date New: '||to_char(trunc(interface.start_date))||

Line 999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));

995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||
1001: ' - '||to_char(trunc(rates.end_date)));
1002: arp_util_tax.debug('Effective Date New: '||to_char(trunc(interface.start_date))||
1003: ' - '||to_char(trunc(interface.end_date)));

Line 1013: ( arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) ) THEN

1009: --arp_util_tax.debug('Interface postal code range identical to existing one');
1010:
1011: /* Checking Date Range */
1012: IF ( trunc(rates.start_date) = trunc(interface.start_date) ) and
1013: ( arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) ) THEN
1014:
1015: /* Compare Tax Rates */
1016: IF ( rates.tax_rate > interface.tax_rate ) THEN
1017:

Line 1092: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN

1088: arp_util_tax.debug('Postal Code Range in interface table is Narrower than existing one.');
1089: end if;
1090:
1091: IF trunc(rates.start_date) = trunc(interface.start_date) and
1092: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN
1093: ACTION := 'ZIP-RANGE-UPDATED'; -- logic to end date broader range later in the code
1094: if pg_debug='Y' then
1095: arp_util_tax.debug('Narrower zip range with same geocode and dates same');
1096: end if;

Line 1125: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN

1121: end if;
1122:
1123: /* Checking Date Range */
1124: IF trunc(rates.start_date) = trunc(interface.start_date) and
1125: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN
1126: ACTION := 'ZIP-RANGE-UPDATED';
1127:
1128: if pg_debug='Y' then
1129: arp_util_tax.debug('Zip ranges are overlapping');

Line 1157: program_id = arp_standard.profile.program_id,

1153:
1154: update ar_location_rates
1155: set start_date = rates.start_date,
1156: end_date = rates.end_date,
1157: program_id = arp_standard.profile.program_id,
1158: program_application_id = arp_standard.profile.program_application_id,
1159: program_update_date = sysdate,
1160: request_id = arp_standard.profile.request_id,
1161: LAST_UPDATED_BY = arp_standard.profile.user_id,

Line 1158: program_application_id = arp_standard.profile.program_application_id,

1154: update ar_location_rates
1155: set start_date = rates.start_date,
1156: end_date = rates.end_date,
1157: program_id = arp_standard.profile.program_id,
1158: program_application_id = arp_standard.profile.program_application_id,
1159: program_update_date = sysdate,
1160: request_id = arp_standard.profile.request_id,
1161: LAST_UPDATED_BY = arp_standard.profile.user_id,
1162: LAST_UPDATE_DATE = sysdate

Line 1160: request_id = arp_standard.profile.request_id,

1156: end_date = rates.end_date,
1157: program_id = arp_standard.profile.program_id,
1158: program_application_id = arp_standard.profile.program_application_id,
1159: program_update_date = sysdate,
1160: request_id = arp_standard.profile.request_id,
1161: LAST_UPDATED_BY = arp_standard.profile.user_id,
1162: LAST_UPDATE_DATE = sysdate
1163: where current of location_rates_c;
1164: /* BUGFIX 1965591 : Continue in loop till all overlapping records handled */

Line 1161: LAST_UPDATED_BY = arp_standard.profile.user_id,

1157: program_id = arp_standard.profile.program_id,
1158: program_application_id = arp_standard.profile.program_application_id,
1159: program_update_date = sysdate,
1160: request_id = arp_standard.profile.request_id,
1161: LAST_UPDATED_BY = arp_standard.profile.user_id,
1162: LAST_UPDATE_DATE = sysdate
1163: where current of location_rates_c;
1164: /* BUGFIX 1965591 : Continue in loop till all overlapping records handled */
1165: --exit when true;

Line 1191: program_id = arp_standard.profile.program_id,

1187: override_rate7 = interface.override_rate7,
1188: override_rate8 = interface.override_rate8,
1189: override_rate9 = interface.override_rate9,
1190: override_rate10 = interface.override_rate10,
1191: program_id = arp_standard.profile.program_id,
1192: program_application_id = arp_standard.profile.program_application_id,
1193: program_update_date = sysdate,
1194: request_id = arp_standard.profile.request_id,
1195: LAST_UPDATED_BY = arp_standard.profile.user_id,

Line 1192: program_application_id = arp_standard.profile.program_application_id,

1188: override_rate8 = interface.override_rate8,
1189: override_rate9 = interface.override_rate9,
1190: override_rate10 = interface.override_rate10,
1191: program_id = arp_standard.profile.program_id,
1192: program_application_id = arp_standard.profile.program_application_id,
1193: program_update_date = sysdate,
1194: request_id = arp_standard.profile.request_id,
1195: LAST_UPDATED_BY = arp_standard.profile.user_id,
1196: LAST_UPDATE_DATE = sysdate,

Line 1194: request_id = arp_standard.profile.request_id,

1190: override_rate10 = interface.override_rate10,
1191: program_id = arp_standard.profile.program_id,
1192: program_application_id = arp_standard.profile.program_application_id,
1193: program_update_date = sysdate,
1194: request_id = arp_standard.profile.request_id,
1195: LAST_UPDATED_BY = arp_standard.profile.user_id,
1196: LAST_UPDATE_DATE = sysdate,
1197: attribute_category = interface.rate_attribute_category,
1198: attribute1 = interface.rate_attribute1,

Line 1195: LAST_UPDATED_BY = arp_standard.profile.user_id,

1191: program_id = arp_standard.profile.program_id,
1192: program_application_id = arp_standard.profile.program_application_id,
1193: program_update_date = sysdate,
1194: request_id = arp_standard.profile.request_id,
1195: LAST_UPDATED_BY = arp_standard.profile.user_id,
1196: LAST_UPDATE_DATE = sysdate,
1197: attribute_category = interface.rate_attribute_category,
1198: attribute1 = interface.rate_attribute1,
1199: attribute2 = interface.rate_attribute2,

Line 1226: program_id = arp_standard.profile.program_id,

1222:
1223: end if;
1224: update ar_location_rates
1225: set end_date = start_date,
1226: program_id = arp_standard.profile.program_id,
1227: program_application_id = arp_standard.profile.program_application_id,
1228: program_update_date = sysdate,
1229: request_id = arp_standard.profile.request_id,
1230: LAST_UPDATED_BY = arp_standard.profile.user_id,

Line 1227: program_application_id = arp_standard.profile.program_application_id,

1223: end if;
1224: update ar_location_rates
1225: set end_date = start_date,
1226: program_id = arp_standard.profile.program_id,
1227: program_application_id = arp_standard.profile.program_application_id,
1228: program_update_date = sysdate,
1229: request_id = arp_standard.profile.request_id,
1230: LAST_UPDATED_BY = arp_standard.profile.user_id,
1231: LAST_UPDATE_DATE = sysdate

Line 1229: request_id = arp_standard.profile.request_id,

1225: set end_date = start_date,
1226: program_id = arp_standard.profile.program_id,
1227: program_application_id = arp_standard.profile.program_application_id,
1228: program_update_date = sysdate,
1229: request_id = arp_standard.profile.request_id,
1230: LAST_UPDATED_BY = arp_standard.profile.user_id,
1231: LAST_UPDATE_DATE = sysdate
1232: where current of location_rates_c;
1233: -- exit when true;

Line 1230: LAST_UPDATED_BY = arp_standard.profile.user_id,

1226: program_id = arp_standard.profile.program_id,
1227: program_application_id = arp_standard.profile.program_application_id,
1228: program_update_date = sysdate,
1229: request_id = arp_standard.profile.request_id,
1230: LAST_UPDATED_BY = arp_standard.profile.user_id,
1231: LAST_UPDATE_DATE = sysdate
1232: where current of location_rates_c;
1233: -- exit when true;
1234:

Line 1240: if (arp_standard.ceil(interface.end_date) = interface.start_date) then

1236: end loop; /* Overlapping Rates */
1237: end if; /* Check on new location */
1238:
1239: if action = 'ZIP-RANGE-UPDATED' then
1240: if (arp_standard.ceil(interface.end_date) = interface.start_date) then
1241: if interface.end_date is not null then
1242: interface.end_date := interface.end_date +1;
1243: end if;
1244: end if;

Line 1333: if interface.from_postal_code <> arp_standard.sysparm.from_postal_code then

1329: interface.override_rate8,
1330: interface.override_rate9,
1331: interface.override_rate10 );
1332:
1333: if interface.from_postal_code <> arp_standard.sysparm.from_postal_code then
1334:
1335: if interface.from_postal_code < location_from_postal_code( current_level -1 ) and
1336: interface.level > 1 then
1337:

Line 1338: error_text := arp_standard.fnd_message( arp_standard.md_msg_text,

1334:
1335: if interface.from_postal_code < location_from_postal_code( current_level -1 ) and
1336: interface.level > 1 then
1337:
1338: error_text := arp_standard.fnd_message( arp_standard.md_msg_text,
1339: 'AR_TAXI_BAD_FROM_POSTAL_CODE',
1340: 'FOUND',
1341: interface.from_postal_code,
1342: 'EXPECTED',

Line 1347: if interface.to_postal_code <> arp_standard.sysparm.to_postal_code then

1343: location_from_postal_code(current_level-1));
1344: end if;
1345: end if;
1346:
1347: if interface.to_postal_code <> arp_standard.sysparm.to_postal_code then
1348:
1349: if interface.to_postal_code > location_to_postal_code( current_level -1 ) and
1350: interface.level > 1 then
1351:

Line 1352: error_text := arp_standard.fnd_message( arp_standard.md_msg_text,

1348:
1349: if interface.to_postal_code > location_to_postal_code( current_level -1 ) and
1350: interface.level > 1 then
1351:
1352: error_text := arp_standard.fnd_message( arp_standard.md_msg_text,
1353: 'AR_TAXI_BAD_TO_POSTAL_CODE',
1354: 'FOUND',
1355: interface.to_postal_code,
1356: 'EXPECTED',

Line 1378: if error_code = arp_standard.ar_error_number then

1374: arp_util_tax.debug(sqlerrm);
1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );
1376: end if;
1377:
1378: if error_code = arp_standard.ar_error_number then
1379: error_text := arp_standard.fnd_message( arp_standard.md_msg_text );
1380: end if;
1381:
1382: ACTION := 'ORA' || to_char( error_code, '09999' );

Line 1379: error_text := arp_standard.fnd_message( arp_standard.md_msg_text );

1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );
1376: end if;
1377:
1378: if error_code = arp_standard.ar_error_number then
1379: error_text := arp_standard.fnd_message( arp_standard.md_msg_text );
1380: end if;
1381:
1382: ACTION := 'ORA' || to_char( error_code, '09999' );
1383: error_count := error_count + 1;

Line 1388: arp_standard.fnd_message( 'AR_ALL_SQL_ERROR', 'ROUTINE', 'TAX_INTERFACE',

1384:
1385: /*Too Many Extents in table, index or rollback, failed to extend rollback segment, */
1386: if error_code in ( 1562, 1631, 1630, 1632, 1629 ) THEN
1387: /**** MB conversion substr to substrb ***/
1388: arp_standard.fnd_message( 'AR_ALL_SQL_ERROR', 'ROUTINE', 'TAX_INTERFACE',
1389: 'ERR_NUMBER', to_char(error_code, '09999' ),
1390: 'SQL_ERROR', substrb(error_text,1,60) );
1391: end if;
1392:

Line 1401: arp_standard.fnd_message( 'AR_STAX_TOO_MANY_ERRORS',

1397: commit work;
1398: end if;
1399:
1400: /**** MB conversion substr to substrb ***/
1401: arp_standard.fnd_message( 'AR_STAX_TOO_MANY_ERRORS',
1402: 'SQLCODE', to_char(error_code, '09999'),
1403: 'SQLERRM', substrb(error_text,1,60),
1404: 'MAX_ERRORS', to_char(max_error_count, '9999999999')) ;
1405: end if;

Line 1416: LAST_UPDATED_BY = arp_standard.profile.user_id,

1412: SET STATUS = action,
1413: /*** MB conversion substr to substrb ***/
1414: ERROR_MESSAGE = substrb(error_text,1,240),
1415: LOCATION_SEGMENT_ID = this_location,
1416: LAST_UPDATED_BY = arp_standard.profile.user_id,
1417: LAST_UPDATE_DATE = sysdate,
1418: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
1419: PROGRAM_ID = arp_standard.profile.program_id,
1420: REQUEST_ID = arp_standard.profile.request_id

Line 1418: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,

1414: ERROR_MESSAGE = substrb(error_text,1,240),
1415: LOCATION_SEGMENT_ID = this_location,
1416: LAST_UPDATED_BY = arp_standard.profile.user_id,
1417: LAST_UPDATE_DATE = sysdate,
1418: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
1419: PROGRAM_ID = arp_standard.profile.program_id,
1420: REQUEST_ID = arp_standard.profile.request_id
1421: WHERE interface_line_id = interface.interface_line_id;
1422:

Line 1419: PROGRAM_ID = arp_standard.profile.program_id,

1415: LOCATION_SEGMENT_ID = this_location,
1416: LAST_UPDATED_BY = arp_standard.profile.user_id,
1417: LAST_UPDATE_DATE = sysdate,
1418: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
1419: PROGRAM_ID = arp_standard.profile.program_id,
1420: REQUEST_ID = arp_standard.profile.request_id
1421: WHERE interface_line_id = interface.interface_line_id;
1422:
1423: END LOOP; /* For Each line of the Tax Interface Table */

Line 1420: REQUEST_ID = arp_standard.profile.request_id

1416: LAST_UPDATED_BY = arp_standard.profile.user_id,
1417: LAST_UPDATE_DATE = sysdate,
1418: PROGRAM_APPLICATION_ID = arp_standard.profile.program_application_id,
1419: PROGRAM_ID = arp_standard.profile.program_id,
1420: REQUEST_ID = arp_standard.profile.request_id
1421: WHERE interface_line_id = interface.interface_line_id;
1422:
1423: END LOOP; /* For Each line of the Tax Interface Table */
1424:

Line 1519: while arp_standard.get_next_word( LOCATION_SEGMENTS, qualifier( segment ) )

1515:
1516: segment := 0;
1517: qualifier( segment ) := null;
1518:
1519: while arp_standard.get_next_word( LOCATION_SEGMENTS, qualifier( segment ) )
1520: loop
1521: segment := segment + 1;
1522: qualifier( segment ) := null;
1523: end loop;