9: PROCEDURE oe_dl (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
10:
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
20: for update nowait;
21:
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
31: for update nowait;
32:
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
42: for update nowait;
43:
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
56:
57: arp_message.set_line( 'OEP_CMERGE_OEDIS.OE_DL()+' );
58:
59: /*-----------------------------+
60: | SO_DISCOUNT_LINES |
61: +-----------------------------*/
62: /* both customer and site level */
63:
64: IF( process_mode = 'LOCK' ) THEN
63:
64: IF( process_mode = 'LOCK' ) THEN
65:
66: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
67: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );
68:
69: open c1;
70: close c1;
71:
82:
83:
84: /* site level update */
85: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
84: /* site level update */
85: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
110:
111:
112: /* site level update */
113: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
112: /* site level update */
113: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
138:
139:
140: /* site level update */
141: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
140: /* site level update */
141: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
166:
167:
168: /* customer level update */
169: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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
168: /* customer level update */
169: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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