eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_CMERGE_BB8 dependencies on CS_INCIDENTS

Line 29: /* This procedure handles the merge process for the CS_INCIDENTS.

25: process_mode IN VARCHAR2 );
26:
27: /* -------------- End Local Procedures ------------------------------- */
28:
29: /* This procedure handles the merge process for the CS_INCIDENTS.
30: It calls 4 seperate procedures to accomplish the task. The tasks are listed
31: below:
32: 1) Update the bill_to_site_use_id
33: 2) Update the install_site_use_id

Line 59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );

55: arp_message.set_line('CP_CMERGE_BB8.MERGE()+');
56:
57: IF ( process_mode = 'LOCK' ) Then
58: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

Line 64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );

60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
65: message_text := 'The merge is done in block CSP_CMERGE_BB8';
66: arp_message.set_line(message_text);
67: END IF;
68:

Line 69: /* merge the CS_INCIDENTS table update bill_to_site_use_id */

65: message_text := 'The merge is done in block CSP_CMERGE_BB8';
66: arp_message.set_line(message_text);
67: END IF;
68:
69: /* merge the CS_INCIDENTS table update bill_to_site_use_id */
70:
71: message_text := '***-- Procedure CS_MERGE_BILL_TO_SITE_ID --**';
72: arp_message.set_line(message_text);
73:

Line 79: /* merge the CS_INCIDENTS table update install_site_use_id */

75:
76: message_text := '***-- End CS_MERGE_BILL_TO_SITE_ID --**';
77: arp_message.set_line(message_text);
78:
79: /* merge the CS_INCIDENTS table update install_site_use_id */
80:
81: message_text := '***-- Procedure CS_MERGE_INSTALL_SITE_ID --**';
82: arp_message.set_line(message_text);
83:

Line 89: /* merge the CS_INCIDENTS table update ship_to_site_use_id */

85:
86: message_text := '***-- End CS_MERGE_INSTALL_SITE_ID --**';
87: arp_message.set_line(message_text);
88:
89: /* merge the CS_INCIDENTS table update ship_to_site_use_id */
90:
91: message_text := '***-- Procedure CS_MERGE_SHIP_TO_SITE_ID --**';
92: arp_message.set_line(message_text);
93:

Line 100: /* merge the CS_INCIDENTS table update the customer_id */

96: message_text := '***-- End CS_MERGE_SHIP_TO_SITE_ID --**';
97: arp_message.set_line(message_text);
98:
99:
100: /* merge the CS_INCIDENTS table update the customer_id */
101:
102: message_text := '***-- Procedure CS_MERGE_CUSTOMER_ID --**';
103: arp_message.set_line(message_text);
104:

Line 110: /* The merge of CS_INCIDENTS is complete, use a cursor to

106:
107: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';
108: arp_message.set_line(message_text);
109:
110: /* The merge of CS_INCIDENTS is complete, use a cursor to
111: check to make sure all data has been updated. If not report it to the
112: log file. */
113:
114: CS_CHECK_MERGE_DATA ( req_id, set_number, process_mode );

Line 116: /* Report that the process for CS_INCIDENTS is complete */

112: log file. */
113:
114: CS_CHECK_MERGE_DATA ( req_id, set_number, process_mode );
115:
116: /* Report that the process for CS_INCIDENTS is complete */
117:
118: IF ( process_mode = 'LOCK' ) Then
119: message_text := '** LOCKING completed for table CS_INCIDENTS **';
120: arp_message.set_line(message_text);

Line 119: message_text := ' LOCKING completed for table CS_INCIDENTS ';

115:
116: /* Report that the process for CS_INCIDENTS is complete */
117:
118: IF ( process_mode = 'LOCK' ) Then
119: message_text := '** LOCKING completed for table CS_INCIDENTS **';
120: arp_message.set_line(message_text);
121: ELSE
122: message_text := '** MERGE completed for table CS_INCIDENTS **';
123: arp_message.set_line(message_text);

Line 122: message_text := ' MERGE completed for table CS_INCIDENTS ';

118: IF ( process_mode = 'LOCK' ) Then
119: message_text := '** LOCKING completed for table CS_INCIDENTS **';
120: arp_message.set_line(message_text);
121: ELSE
122: message_text := '** MERGE completed for table CS_INCIDENTS **';
123: arp_message.set_line(message_text);
124: END IF;
125:
126: arp_message.set_line('CP_CMERGE_BB8.MERGE()-');

Line 132: /* Update the bill to site use id of CS_INCIDENTS */

128: END MERGE;
129:
130: /* ------------------------------------------------------------------------*/
131:
132: /* Update the bill to site use id of CS_INCIDENTS */
133:
134: PROCEDURE CS_MERGE_BILL_TO_SITE_ID ( req_id IN NUMBER,
135: set_number IN NUMBER,
136: process_mode IN VARCHAR2 ) IS

Line 148: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

144: number_of_rows NUMBER;
145:
146: Cursor LOCK_BILL_TO_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
147: SELECT bill_to_site_use_id
148: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
149: WHERE
150: yt.bill_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
151: FROM RA_CUSTOMER_MERGES RACM
152: WHERE RACM.PROCESS_FLAG = 'N'

Line 177: UPDATE CS_INCIDENTS yt

173:
174: message_text := 'Updating the bill_to_site_use_id ( 1/6 )';
175: arp_message.set_line(message_text);
176:
177: UPDATE CS_INCIDENTS yt
178: SET
179: yt.bill_to_site_use_id =
180: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
181: FROM RA_CUSTOMER_MERGES RACM

Line 226: /* Update the install site use id of CS_INCIDENTS */

222: raise;
223:
224: END CS_MERGE_BILL_TO_SITE_ID;
225:
226: /* Update the install site use id of CS_INCIDENTS */
227:
228: PROCEDURE CS_MERGE_INSTALL_SITE_ID ( req_id IN NUMBER,
229: set_number IN NUMBER,
230: process_mode IN VARCHAR2 ) IS

Line 242: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

238: number_of_rows NUMBER;
239:
240: Cursor LOCK_INSTALL_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
241: SELECT install_site_use_id
242: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
243: WHERE
244: yt.install_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
245: FROM RA_CUSTOMER_MERGES RACM
246: WHERE RACM.PROCESS_FLAG = 'N'

Line 270: UPDATE CS_INCIDENTS yt

266: message_text :=
267: 'Starting to update the install_site_use_id ( 2/6 )';
268: arp_message.set_line(message_text);
269:
270: UPDATE CS_INCIDENTS yt
271: SET
272: yt.install_site_use_id =
273: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
274: FROM RA_CUSTOMER_MERGES RACM

Line 319: /* Update the ship to site id of CS_INCIDENTS */

315: raise;
316:
317: END CS_MERGE_INSTALL_SITE_ID;
318:
319: /* Update the ship to site id of CS_INCIDENTS */
320:
321: PROCEDURE CS_MERGE_SHIP_TO_SITE_ID( req_id IN NUMBER,
322: set_number IN NUMBER,
323: process_mode IN VARCHAR2 ) IS

Line 335: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

331: number_of_rows NUMBER;
332:
333: Cursor LOCK_SHIP_SITE_ID ( req_id NUMBER, set_number NUMBER ) IS
334: SELECT ship_to_site_use_id
335: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
336: WHERE
337: yt.ship_to_site_use_id IN ( SELECT RACM.DUPLICATE_SITE_ID
338: FROM RA_CUSTOMER_MERGES RACM
339: WHERE RACM.PROCESS_FLAG = 'N'

Line 362: UPDATE CS_INCIDENTS yt

358:
359: message_text := 'Starting to update the ship_to_site_use_id ( 3/6 )';
360: arp_message.set_line(message_text);
361:
362: UPDATE CS_INCIDENTS yt
363: SET
364: yt.ship_to_site_use_id =
365: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
366: FROM RA_CUSTOMER_MERGES RACM

Line 410: /* This process updates the customer_id of the CS_INCIDENTS table */

406: raise;
407:
408: END CS_MERGE_SHIP_TO_SITE_ID;
409:
410: /* This process updates the customer_id of the CS_INCIDENTS table */
411:
412: PROCEDURE CS_MERGE_CUSTOMER_ID (req_id IN NUMBER,
413: set_number IN NUMBER,
414: process_mode IN VARCHAR2 ) IS

Line 426: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM

422: number_of_rows NUMBER;
423:
424: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
425: SELECT yt.customer_id
426: FROM CS_INCIDENTS yt, RA_CUSTOMER_MERGES RACM
427: WHERE
428: yt.customer_id IN ( SELECT RACM.DUPLICATE_ID
429: FROM RA_CUSTOMER_MERGES RACM
430: WHERE RACM.PROCESS_FLAG = 'N'

Line 452: UPDATE CS_INCIDENTS yt

448:
449: message_text := 'Starting to update the customer_id ( 6/6 )';
450: arp_message.set_line(message_text);
451:
452: UPDATE CS_INCIDENTS yt
453: SET
454: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
455: FROM RA_CUSTOMER_MERGES RACM
456: WHERE yt.customer_id = DUPLICATE_ID

Line 523: FROM CS_INCIDENTS CS,

519: CURSOR CS_CHECK IS
520: SELECT
521: DISTINCT
522: cs.incident_id
523: FROM CS_INCIDENTS CS,
524: RA_CUSTOMER_MERGES RACM
525: WHERE
526: RACM.PROCESS_FLAG = 'N' AND
527: RACM.REQUEST_ID = req_id AND

Line 533: from CS_INCIDENTS CS,

529: ((( cs.customer_id = RACM.CUSTOMER_ID AND
530: cs.bill_to_site_use_id <> racm.customer_site_id AND
531: cs.bill_to_site_use_id IS NOT NULL ) AND
532: ( cs.customer_id NOT IN ( select racm.customer_id
533: from CS_INCIDENTS CS,
534: RA_CUSTOMER_MERGES RACM
535: where cs.customer_id = RACM.CUSTOMER_ID AND
536: cs.bill_to_site_use_id = racm.customer_site_id OR
537: cs.bill_to_site_use_id IS NULL ))) AND

Line 542: from CS_INCIDENTS CS,

538: (( cs.customer_id = RACM.CUSTOMER_ID AND
539: cs.install_site_use_id <> racm.customer_site_id AND
540: cs.install_site_use_id IS NOT NULL ) AND
541: ( cs.customer_id NOT IN ( select racm.customer_id
542: from CS_INCIDENTS CS,
543: RA_CUSTOMER_MERGES RACM
544: WHERE cs.customer_id = RACM.CUSTOMER_ID AND
545: cs.install_site_use_id = racm.customer_site_id OR
546: cs.install_site_use_id IS NULL ))) AND

Line 551: from CS_INCIDENTS CS,

547: (( cs.customer_id = RACM.CUSTOMER_ID AND
548: cs.ship_to_site_use_id <> racm.customer_site_id AND
549: cs.ship_to_site_use_id IS NOT NULL ) AND
550: ( cs.customer_id NOT IN ( select racm.customer_id
551: from CS_INCIDENTS CS,
552: RA_CUSTOMER_MERGES RACM
553: WHERE cs.customer_id = RACM.CUSTOMER_ID AND
554: cs.ship_to_site_use_id = racm.customer_site_id OR
555: cs.ship_to_site_use_id IS NULL ))));