[Home] [Help]
13: CURSOR c1 is
14: select note_id
15: from so_note_addition_rules
16: where entity_value in (select m.duplicate_site_id
17: from ra_customer_merges m
18: where m.process_flag = 'N'
19: and m.request_id = req_id
20: and m.set_number = set_num)
21: and entity_id = 1009
24: CURSOR c2 is
25: select note_id
26: from so_note_addition_rules
27: where entity_value in (select m.duplicate_site_id
28: from ra_customer_merges m
29: where m.process_flag = 'N'
30: and m.request_id = req_id
31: and m.set_number = set_num)
32: and entity_id = 1008
35: CURSOR c3 is
36: select note_id
37: from so_note_addition_rules
38: where entity_value in (select m.duplicate_site_id
39: from ra_customer_merges m
40: where m.process_flag = 'N'
41: and m.request_id = req_id
42: and m.set_number = set_num)
43: and entity_id = 1007
46: CURSOR c4 is
47: select note_id
48: from so_note_addition_rules
49: where entity_value in (select m.duplicate_id
50: from ra_customer_merges m
51: where m.process_flag = 'N'
52: and m.request_id = req_id
53: and m.set_number = set_num)
54: and entity_id = 1000
88: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
89:
90: UPDATE SO_NOTE_ADDITION_RULES a
91: set (entity_value) = (select distinct m.customer_site_id
92: from ra_customer_merges m
93: where a.entity_value =
94: m.duplicate_site_id
95: and m.request_id = req_id
96: and m.process_flag = 'N'
98: last_update_date = sysdate,
99: last_updated_by = arp_standard.profile.user_id,
100: last_update_login = arp_standard.profile.last_update_login
101: where entity_value in (select m.duplicate_site_id
102: from ra_customer_merges m
103: where m.process_flag = 'N'
104: and m.request_id = req_id
105: and m.set_number = set_num)
106: and entity_id = 1009;
116: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
117:
118: UPDATE SO_NOTE_ADDITION_RULES a
119: set (entity_value) = (select distinct m.customer_site_id
120: from ra_customer_merges m
121: where a.entity_value =
122: m.duplicate_site_id
123: and m.request_id = req_id
124: and m.process_flag = 'N'
126: last_update_date = sysdate,
127: last_updated_by = arp_standard.profile.user_id,
128: last_update_login = arp_standard.profile.last_update_login
129: where entity_value in (select m.duplicate_site_id
130: from ra_customer_merges m
131: where m.process_flag = 'N'
132: and m.request_id = req_id
133: and m.set_number = set_num)
134: and entity_id = 1008;
144: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
145:
146: UPDATE SO_NOTE_ADDITION_RULES a
147: set (entity_value) = (select distinct m.customer_site_id
148: from ra_customer_merges m
149: where a.entity_value =
150: m.duplicate_site_id
151: and m.request_id = req_id
152: and m.process_flag = 'N'
154: last_update_date = sysdate,
155: last_updated_by = arp_standard.profile.user_id,
156: last_update_login = arp_standard.profile.last_update_login
157: where entity_value in (select m.duplicate_site_id
158: from ra_customer_merges m
159: where m.process_flag = 'N'
160: and m.request_id = req_id
161: and m.set_number = set_num)
162: and entity_id = 1003;
172: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
173:
174: UPDATE SO_NOTE_ADDITION_RULES a
175: set entity_value = (select distinct m.customer_id
176: from ra_customer_merges m
177: where a.entity_value =
178: m.duplicate_id
179: and m.process_flag = 'N'
180: and m.request_id = req_id
182: last_update_date = sysdate,
183: last_updated_by = arp_standard.profile.user_id,
184: last_update_login = arp_standard.profile.last_update_login
185: where entity_value in (select m.duplicate_id
186: from ra_customer_merges m
187: where m.process_flag = 'N'
188: and m.request_id = req_id
189: and m.set_number = set_num)
190: and entity_id = 1000;