[Home] [Help]
11: CURSOR c1 is
12: select discount_line_id
13: from so_discount_lines
14: where entity_value in (select to_char(m.duplicate_site_id)
15: from ra_customer_merges m
16: where m.process_flag = 'N'
17: and m.request_id = req_id
18: and m.set_number = set_num)
19: and entity_id = 1009
22: CURSOR c2 is
23: select discount_line_id
24: from so_discount_lines
25: where entity_value in (select to_char(m.duplicate_site_id)
26: from ra_customer_merges m
27: where m.process_flag = 'N'
28: and m.request_id = req_id
29: and m.set_number = set_num)
30: and entity_id = 1008
33: CURSOR c3 is
34: select discount_line_id
35: from so_discount_lines
36: where entity_value in (select to_char(m.duplicate_site_id)
37: from ra_customer_merges m
38: where m.process_flag = 'N'
39: and m.request_id = req_id
40: and m.set_number = set_num)
41: and entity_id = 1007
44: CURSOR c4 is
45: select discount_line_id
46: from so_discount_lines
47: where entity_value in (select to_char(m.duplicate_id)
48: from ra_customer_merges m
49: where m.process_flag = 'N'
50: and m.request_id = req_id
51: and m.set_number = set_num)
52: and entity_id = 1000
86: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );
87:
88: UPDATE SO_DISCOUNT_LINES a
89: set (entity_value) = (select distinct to_char(m.customer_site_id)
90: from ra_customer_merges m
91: where to_number(a.entity_value) =
92: m.duplicate_site_id
93: and m.request_id = req_id
94: and m.process_flag = 'N'
96: last_update_date = sysdate,
97: last_updated_by = arp_standard.profile.user_id,
98: last_update_login = arp_standard.profile.last_update_login
99: where entity_value in (select to_char(m.duplicate_site_id)
100: from ra_customer_merges m
101: where m.process_flag = 'N'
102: and m.request_id = req_id
103: and m.set_number = set_num)
104: and entity_id = 1009;
114: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );
115:
116: UPDATE SO_DISCOUNT_LINES a
117: set (entity_value) = (select distinct to_char(m.customer_site_id)
118: from ra_customer_merges m
119: where to_number(a.entity_value) =
120: m.duplicate_site_id
121: and m.request_id = req_id
122: and m.process_flag = 'N'
124: last_update_date = sysdate,
125: last_updated_by = arp_standard.profile.user_id,
126: last_update_login = arp_standard.profile.last_update_login
127: where entity_value in (select to_char(m.duplicate_site_id)
128: from ra_customer_merges m
129: where m.process_flag = 'N'
130: and m.request_id = req_id
131: and m.set_number = set_num)
132: and entity_id = 1008;
142: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );
143:
144: UPDATE SO_DISCOUNT_LINES a
145: set (entity_value) = (select distinct to_char(m.customer_site_id)
146: from ra_customer_merges m
147: where to_number(a.entity_value) =
148: m.duplicate_site_id
149: and m.request_id = req_id
150: and m.process_flag = 'N'
152: last_update_date = sysdate,
153: last_updated_by = arp_standard.profile.user_id,
154: last_update_login = arp_standard.profile.last_update_login
155: where entity_value in (select to_char(m.duplicate_site_id)
156: from ra_customer_merges m
157: where m.process_flag = 'N'
158: and m.request_id = req_id
159: and m.set_number = set_num)
160: and entity_id = 1003;
170: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );
171:
172: UPDATE SO_DISCOUNT_LINES a
173: set entity_value = (select distinct to_char(m.customer_id)
174: from ra_customer_merges m
175: where to_number(a.entity_value) =
176: m.duplicate_id
177: and m.process_flag = 'N'
178: and m.request_id = req_id
180: last_update_date = sysdate,
181: last_updated_by = arp_standard.profile.user_id,
182: last_update_login = arp_standard.profile.last_update_login
183: where entity_value in (select to_char(m.duplicate_id)
184: from ra_customer_merges m
185: where m.process_flag = 'N'
186: and m.request_id = req_id
187: and m.set_number = set_num)
188: and entity_id = 1000;
216: CURSOR c1 is
217: select discount_customer_id
218: from so_discount_customers
219: where site_use_id in (select m.duplicate_site_id
220: from ra_customer_merges m
221: where m.process_flag = 'N'
222: and m.request_id = req_id
223: and m.set_number = set_num)
224: for update nowait;
226: CURSOR c2 is
227: select discount_customer_id
228: from so_discount_customers
229: where customer_id in (select m.duplicate_id
230: from ra_customer_merges m
231: where m.process_flag = 'N'
232: and m.request_id = req_id
233: and m.set_number = set_num)
234: for update nowait;
261: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
262:
263: UPDATE SO_DISCOUNT_CUSTOMERS a
264: set (site_use_id) = (select distinct m.customer_site_id
265: from ra_customer_merges m
266: where a.site_use_id =
267: m.duplicate_site_id
268: and m.request_id = req_id
269: and m.process_flag = 'N'
271: last_update_date = sysdate,
272: last_updated_by = arp_standard.profile.user_id,
273: last_update_login = arp_standard.profile.last_update_login
274: where site_use_id in (select m.duplicate_site_id
275: from ra_customer_merges m
276: where m.process_flag = 'N'
277: and m.request_id = req_id
278: and m.set_number = set_num);
279:
287: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_CUSTOMERS', FALSE );
288:
289: UPDATE SO_DISCOUNT_CUSTOMERS a
290: set customer_id = (select distinct m.customer_id
291: from ra_customer_merges m
292: where a.customer_id =
293: m.duplicate_id
294: and m.process_flag = 'N'
295: and m.request_id = req_id
297: last_update_date = sysdate,
298: last_updated_by = arp_standard.profile.user_id,
299: last_update_login = arp_standard.profile.last_update_login
300: where customer_id in (select m.duplicate_id
301: from ra_customer_merges m
302: where m.process_flag = 'N'
303: and m.request_id = req_id
304: and m.set_number = set_num);
305: