APPS.CSP_CMERGE_BB7 dependencies on CS_REPAIRS

Line 12: /* This procedure handles the merge process for the CS_REPAIRS.

8: process_mode IN VARCHAR2 );
9:
10: /* ------------------- End Local Procedures ------------------------------------ */
11:
12: /* This procedure handles the merge process for the CS_REPAIRS.
13: It calls 1 seperate procedures to accomplish the task. The tasts are listed
14: below:
15: 1) Update the customer_id
16:

Line 39: arp_message.set_token('TABLE_NAME', 'CS_REPAIRS',FALSE );

35: arp_message.set_line('CP_CMERGE_BB7.MERGE()+');
36:
37: IF ( process_mode = 'LOCK' ) Then
38: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
39: arp_message.set_token('TABLE_NAME', 'CS_REPAIRS',FALSE );
40: message_text := 'The locking is done in block CSP_CMERGE_BB7';
41: arp_message.set_line(message_text);
42: ELSE
43: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

Line 44: arp_message.set_token('TABLE_NAME', 'CS_REPAIRS',FALSE );

40: message_text := 'The locking is done in block CSP_CMERGE_BB7';
41: arp_message.set_line(message_text);
42: ELSE
43: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
44: arp_message.set_token('TABLE_NAME', 'CS_REPAIRS',FALSE );
45: message_text := 'The merge is done in block CSP_CMERGE_BB7';
46: arp_message.set_line(message_text);
47: END IF;
48:

Line 49: /* merge the CS_REPAIRS table update the customer_id */

45: message_text := 'The merge is done in block CSP_CMERGE_BB7';
46: arp_message.set_line(message_text);
47: END IF;
48:
49: /* merge the CS_REPAIRS table update the customer_id */
50:
51: message_text := '***-- Procedure CS_MERGE_CUSTOMER_ID --**';
52: arp_message.set_line(message_text);
53:

Line 59: /* Report that the process for CS_REPAIRS is complete */

55:
56: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';
57: arp_message.set_line(message_text);
58:
59: /* Report that the process for CS_REPAIRS is complete */
60:
61: IF ( process_mode = 'LOCK' ) Then
62: message_text := '** LOCKING completed for table CS_REPAIRS **';
63: arp_message.set_line(message_text);

Line 62: message_text := '** LOCKING completed for table CS_REPAIRS **';

58:
59: /* Report that the process for CS_REPAIRS is complete */
60:
61: IF ( process_mode = 'LOCK' ) Then
62: message_text := '** LOCKING completed for table CS_REPAIRS **';
63: arp_message.set_line(message_text);
64: ELSE
65: message_text := '** MERGE completed for table CS_REPAIRS **';
66: arp_message.set_line(message_text);

Line 65: message_text := '** MERGE completed for table CS_REPAIRS **';

61: IF ( process_mode = 'LOCK' ) Then
62: message_text := '** LOCKING completed for table CS_REPAIRS **';
63: arp_message.set_line(message_text);
64: ELSE
65: message_text := '** MERGE completed for table CS_REPAIRS **';
66: arp_message.set_line(message_text);
67: END IF;
68:
69: arp_message.set_line('CP_CMERGE_BB7.MERGE()-');

Line 75: /* This process updates the customer_id of the CS_REPAIRS table */

71: END MERGE;
72:
73: /* -----------------------------------------------------------------------------*/
74:
75: /* This process updates the customer_id of the CS_REPAIRS table */
76:
77: PROCEDURE CS_MERGE_CUSTOMER_ID (req_id IN NUMBER,
78: set_number IN NUMBER,
79: process_mode IN VARCHAR2 ) IS

Line 91: FROM CS_REPAIRS yt, RA_CUSTOMER_MERGES RACM

87: number_of_rows NUMBER;
88:
89: Cursor LOCK_CUSTOMER_ID ( req_id NUMBER, set_number NUMBER ) IS
90: SELECT yt.rma_customer_id
91: FROM CS_REPAIRS yt, RA_CUSTOMER_MERGES RACM
92: WHERE
93: yt.rma_customer_id IN ( SELECT RACM.DUPLICATE_ID
94: FROM RA_CUSTOMER_MERGES RACM
95: WHERE RACM.PROCESS_FLAG = 'N'

Line 117: UPDATE CS_REPAIRS yt

113:
114: message_text := 'Starting to update the rma_customer_id ( 1/1 )';
115: arp_message.set_line(message_text);
116:
117: UPDATE CS_REPAIRS yt
118: SET
119: yt.rma_customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID
120: FROM RA_CUSTOMER_MERGES RACM
121: WHERE yt.rma_customer_id = DUPLICATE_ID