APPS.OEP_CMERGE_OEDIS dependencies on SO_DISCOUNT_LINES

Line 13: from so_discount_lines

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

Line 24: from so_discount_lines

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

Line 35: from so_discount_lines

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

Line 46: from so_discount_lines

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

Line 60: | SO_DISCOUNT_LINES |

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

Line 67: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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:

Line 86: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

Line 88: UPDATE SO_DISCOUNT_LINES a

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

Line 114: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

Line 116: UPDATE SO_DISCOUNT_LINES a

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

Line 142: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

Line 144: UPDATE SO_DISCOUNT_LINES a

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

Line 170: arp_message.set_token( 'TABLE_NAME', 'SO_DISCOUNT_LINES', FALSE );

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

Line 172: UPDATE SO_DISCOUNT_LINES a

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