APPS.OEP_CMERGE_OEHLD dependencies on SO_HOLD_SOURCES

Line 14: from so_hold_sources

10: PROCEDURE oe_hs (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
11:
12: CURSOR c1 is
13: select hold_source_id
14: from so_hold_sources
15: where hold_entity_id in (select m.duplicate_site_id
16: from ra_customer_merges m
17: where m.process_flag = 'N'
18: and m.request_id = req_id

Line 25: from so_hold_sources

21: for update nowait;
22:
23: CURSOR c2 is
24: select hold_source_id
25: from so_hold_sources
26: where hold_entity_id in (select m.duplicate_site_id
27: from ra_customer_merges m
28: where m.process_flag = 'N'
29: and m.request_id = req_id

Line 36: from so_hold_sources

32: for update nowait;
33:
34: CURSOR c3 is
35: select hold_source_id
36: from so_hold_sources
37: where hold_entity_id in (select m.duplicate_site_id
38: from ra_customer_merges m
39: where m.process_flag = 'N'
40: and m.request_id = req_id

Line 47: from so_hold_sources

43: for update nowait;
44:
45: CURSOR c4 is
46: select hold_source_id
47: from so_hold_sources
48: where hold_entity_id in (select m.duplicate_id
49: from ra_customer_merges m
50: where m.process_flag = 'N'
51: and m.request_id = req_id

Line 61: | SO_HOLD_SOURCES |

57:
58: arp_message.set_line( 'OEP_CMERGE_OEHLD.OE_HS()+' );
59:
60: /*-----------------------------+
61: | SO_HOLD_SOURCES |
62: +-----------------------------*/
63: /* both customer and site level */
64:
65: IF( process_mode = 'LOCK' ) THEN

Line 68: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

64:
65: IF( process_mode = 'LOCK' ) THEN
66:
67: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
68: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
69:
70: open c1;
71: close c1;
72:

Line 87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

83:
84:
85: /* site level update */
86: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
88:
89: UPDATE SO_HOLD_SOURCES a
90: set (hold_entity_id) = (select distinct m.customer_site_id
91: from ra_customer_merges m

Line 89: UPDATE SO_HOLD_SOURCES a

85: /* site level update */
86: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
87: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
88:
89: UPDATE SO_HOLD_SOURCES a
90: set (hold_entity_id) = (select distinct m.customer_site_id
91: from ra_customer_merges m
92: where a.hold_entity_id =
93: m.duplicate_site_id

Line 115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

111:
112:
113: /* site level update */
114: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
116:
117: UPDATE SO_HOLD_SOURCES a
118: set (hold_entity_id) = (select distinct m.customer_site_id
119: from ra_customer_merges m

Line 117: UPDATE SO_HOLD_SOURCES a

113: /* site level update */
114: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
115: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
116:
117: UPDATE SO_HOLD_SOURCES a
118: set (hold_entity_id) = (select distinct m.customer_site_id
119: from ra_customer_merges m
120: where a.hold_entity_id =
121: m.duplicate_site_id

Line 143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

139:
140:
141: /* site level update */
142: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
144:
145: UPDATE SO_HOLD_SOURCES a
146: set (hold_entity_id) = (select distinct m.customer_site_id
147: from ra_customer_merges m

Line 145: UPDATE SO_HOLD_SOURCES a

141: /* site level update */
142: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
143: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
144:
145: UPDATE SO_HOLD_SOURCES a
146: set (hold_entity_id) = (select distinct m.customer_site_id
147: from ra_customer_merges m
148: where a.hold_entity_id =
149: m.duplicate_site_id

Line 171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );

167:
168:
169: /* customer level update */
170: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
172:
173: UPDATE SO_HOLD_SOURCES a
174: set hold_entity_id = (select distinct m.customer_id
175: from ra_customer_merges m

Line 173: UPDATE SO_HOLD_SOURCES a

169: /* customer level update */
170: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
171: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
172:
173: UPDATE SO_HOLD_SOURCES a
174: set hold_entity_id = (select distinct m.customer_id
175: from ra_customer_merges m
176: where a.hold_entity_id =
177: m.duplicate_id