APPS.OEP_CMERGE_OENTS dependencies on SO_NOTE_ADDITION_RULES

Line 15: from so_note_addition_rules

11: PROCEDURE oe_ar (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
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

Line 26: from so_note_addition_rules

22: for update nowait;
23:
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

Line 37: from so_note_addition_rules

33: for update nowait;
34:
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

Line 48: from so_note_addition_rules

44: for update nowait;
45:
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

Line 62: | SO_NOTE_ADDITION_RULES |

58:
59: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()+' );
60:
61: /*-----------------------------+
62: | SO_NOTE_ADDITION_RULES |
63: +-----------------------------*/
64: /* both customer and site level */
65:
66: IF( process_mode = 'LOCK' ) THEN

Line 69: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

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

Line 88: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

84:
85:
86: /* site level update */
87: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 90: UPDATE SO_NOTE_ADDITION_RULES a

86: /* site level update */
87: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 116: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

112:
113:
114: /* site level update */
115: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 118: UPDATE SO_NOTE_ADDITION_RULES a

114: /* site level update */
115: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 144: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

140:
141:
142: /* site level update */
143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 146: UPDATE SO_NOTE_ADDITION_RULES a

142: /* site level update */
143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 172: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

168:
169:
170: /* customer level update */
171: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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

Line 174: UPDATE SO_NOTE_ADDITION_RULES a

170: /* customer level update */
171: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
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