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_BB3 dependencies on CS_SYSTEMS

Line 28: /* This procedure handles the merge process for the CS_SYSTEMS.

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

Line 58: arp_message.set_token('TABLE_NAME', 'CS_SYSTEMS',FALSE );

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

Line 63: arp_message.set_token('TABLE_NAME', 'CS_SYSTEMS',FALSE );

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

Line 68: /* merge the CS_SYSTEMS table update bill_to_site_use_id */

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

Line 78: /* merge the CS_SYSTEMS table update install_site_use_id */

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

Line 88: /* merge the CS_SYSTEMS table update ship_to_site_use_id */

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

Line 98: /* merge the CS_SYSTEMS table update the customer_id */

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

Line 108: /* The merge of CS_SYSTEMS is complete, use a cursor to

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

Line 114: /* Report that the process for CS_SYSTEMS is complete */

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

Line 117: message_text := ' LOCKING completed for table CS_SYSTEMS ';

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

Line 120: message_text := ' MERGE completed for table CS_SYSTEMS ';

116: IF ( process_mode = 'LOCK' ) Then
117: message_text := '** LOCKING completed for table CS_SYSTEMS **';
118: arp_message.set_line(message_text);
119: ELSE
120: message_text := '** MERGE completed for table CS_SYSTEMS **';
121: arp_message.set_line(message_text);
122: END IF;
123:
124: arp_message.set_line('CP_CMERGE_BB3.MERGE()-');

Line 130: /* Update the ship use site id of CS_SYSTEMS */

126: END MERGE;
127:
128: /* -----------------------------------------------------------------------------*/
129:
130: /* Update the ship use site id of CS_SYSTEMS */
131:
132: PROCEDURE CS_MERGE_BILL_TO_SITE_ID ( req_id IN NUMBER,
133: set_number IN NUMBER,
134: process_mode IN VARCHAR2 ) IS

Line 146: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 175: UPDATE CS_SYSTEMS yt

171:
172: message_text := 'Updating the bill_to_site_use_id ( 1/4 )';
173: arp_message.set_line(message_text);
174:
175: UPDATE CS_SYSTEMS yt
176: SET
177: yt.bill_to_site_use_id =
178: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
179: FROM RA_CUSTOMER_MERGES RACM

Line 224: /* Update the ship use site id of CS_SYSTEMS */

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

Line 240: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 268: UPDATE CS_SYSTEMS yt

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

Line 317: /* Update the ship to site id of CS_SYSTEMS */

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

Line 333: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 360: UPDATE CS_SYSTEMS yt

356:
357: message_text := 'Starting to update the Ship_use_site_id ( 3/4 )';
358: arp_message.set_line(message_text);
359:
360: UPDATE CS_SYSTEMS yt
361: SET
362: yt.ship_to_site_use_id =
363: ( SELECT DISTINCT RACM.CUSTOMER_SITE_ID
364: FROM RA_CUSTOMER_MERGES RACM

Line 409: /* This process updates the customer_id of the CS_SYSTEMS table */

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

Line 425: FROM CS_SYSTEMS yt, RA_CUSTOMER_MERGES RACM

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

Line 451: UPDATE CS_SYSTEMS yt

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

Line 522: FROM CS_SYSTEMS CS,

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

Line 532: from CS_SYSTEMS CS,

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

Line 541: from CS_SYSTEMS CS,

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

Line 550: from CS_SYSTEMS CS,

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