[Home] [Help]
116: --For 'Ship To' Qualifier Attribute
117: CURSOR c1
118: IS
119: select qualifier_id
120: from qp_qualifiers
121: where qualifier_context = 'CUSTOMER'
122: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE11'
123: and qualifier_attr_value in (select to_char(m.duplicate_site_id)
124: from ra_customer_merges m
130: --For 'Site Use' Qualifier Attribute
131: CURSOR c2
132: IS
133: select qualifier_id
134: from qp_qualifiers
135: where qualifier_context = 'CUSTOMER'
136: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
137: and qualifier_attr_value in (select to_char(m.duplicate_site_id)
138: from ra_customer_merges m
144: --For 'Bill To' Qualifier Attribute
145: CURSOR c3
146: IS
147: select qualifier_id
148: from qp_qualifiers
149: where qualifier_context = 'CUSTOMER'
150: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE14'
151: and qualifier_attr_value in (select to_char(m.duplicate_site_id)
152: from ra_customer_merges m
158: --For 'Customer Name' Qualifier Attribute
159: CURSOR c4
160: IS
161: select qualifier_id
162: from qp_qualifiers
163: where qualifier_context = 'CUSTOMER'
164: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
165: and qualifier_attr_value in (select to_char(m.duplicate_id)
166: from ra_customer_merges m
178: **************************************************/
179:
180: IF (process_mode = 'LOCK') THEN
181:
182: oe_debug_pub.add('Locking Table QP_QUALIFIERS');
183:
184: open c1;
185: close c1;
186:
196: ELSE
197:
198: /** site level update **/
199:
200: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Ship To');
201:
202: --For 'Ship To' Qualifier Attribute
203: UPDATE qp_qualifiers
204: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
199:
200: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Ship To');
201:
202: --For 'Ship To' Qualifier Attribute
203: UPDATE qp_qualifiers
204: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
205: from ra_customer_merges m
206: where m.duplicate_site_id =
207: to_number(qualifier_attr_value)
223: g_count := sql%rowcount;
224: oe_debug_pub.add(g_count || ' rows updated');
225:
226:
227: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Site Use');
228:
229: --For 'Site Use' Qualifier Attribute
230: UPDATE qp_qualifiers
231: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
226:
227: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Site Use');
228:
229: --For 'Site Use' Qualifier Attribute
230: UPDATE qp_qualifiers
231: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
232: from ra_customer_merges m
233: where m.duplicate_site_id =
234: to_number(qualifier_attr_value)
250: g_count := sql%rowcount;
251: oe_debug_pub.add(g_count || ' rows updated');
252:
253:
254: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Bill To');
255:
256: --For 'Bill To' Qualifier Attribute
257: UPDATE qp_qualifiers
258: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
253:
254: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Site Data - Bill To');
255:
256: --For 'Bill To' Qualifier Attribute
257: UPDATE qp_qualifiers
258: SET qualifier_attr_value = (select distinct to_char(m.customer_site_id)
259: from ra_customer_merges m
260: where m.duplicate_site_id =
261: to_number(qualifier_attr_value)
279:
280:
281: /**customer level update**/
282:
283: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Data');
284:
285: --For 'Customer Name' Qualifier Attribute
286: UPDATE qp_qualifiers
287: SET qualifier_attr_value = (select distinct to_char(m.customer_id)
282:
283: oe_debug_pub.add('Updating Table QP_QUALIFIERS for Customer Data');
284:
285: --For 'Customer Name' Qualifier Attribute
286: UPDATE qp_qualifiers
287: SET qualifier_attr_value = (select distinct to_char(m.customer_id)
288: from ra_customer_merges m
289: where m.duplicate_id =
290: to_number(qualifier_attr_value)