APPS.CS_SR_ACCOUNT_MERGE_PKG dependencies on CS_INCIDENTS_ALL_B

Line 25: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );

21: arp_message.set_line('CRM_MERGE.SR_MERGE()+');
22:
23: IF ( process_mode = 'LOCK' ) Then
24: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
25: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );
26: ELSE
27: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
28: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );
29:

Line 28: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );

24: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
25: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );
26: ELSE
27: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
28: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B',FALSE );
29:
30: END IF;
31:
32: ----Merge the CS_INCIDENTS table update the account_id

Line 48: message_text := '** LOCKING completed for table CS_INCIDENTS_ALL_B **';

44:
45: ---Report that the process for CS_INCIDENTS is complete
46:
47: IF ( process_mode = 'LOCK' ) Then
48: message_text := '** LOCKING completed for table CS_INCIDENTS_ALL_B **';
49: arp_message.set_line(message_text);
50: ELSE
51: message_text := '** MERGE completed for table CS_INCIDENTS_ALL_B **';
52: arp_message.set_line(message_text);

Line 51: message_text := '** MERGE completed for table CS_INCIDENTS_ALL_B **';

47: IF ( process_mode = 'LOCK' ) Then
48: message_text := '** LOCKING completed for table CS_INCIDENTS_ALL_B **';
49: arp_message.set_line(message_text);
50: ELSE
51: message_text := '** MERGE completed for table CS_INCIDENTS_ALL_B **';
52: arp_message.set_line(message_text);
53: END IF;
54:
55: arp_message.set_line('CRM_MERGE.SR_MERGE()-');

Line 59: -- The following procedure merges the following columns from CS_INCIDENTS_ALL_B

55: arp_message.set_line('CRM_MERGE.SR_MERGE()-');
56:
57: END MERGE_CUST_ACCOUNTS;
58:
59: -- The following procedure merges the following columns from CS_INCIDENTS_ALL_B
60: -- account_id
61: -- bill_to_account_id - added for 11.5.9
62: -- ship_to_account_id - added for 11.5.9
63:

Line 75: CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE

71: INDEX BY BINARY_INTEGER;
72: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
73:
74: TYPE INCIDENT_ID_LIST_TYPE IS TABLE OF
75: CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE
76: INDEX BY BINARY_INTEGER;
77: PRIMARY_KEY_ID_LIST INCIDENT_ID_LIST_TYPE;
78:
79: TYPE ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 80: CS_INCIDENTS_ALL_B.ACCOUNT_ID%TYPE

76: INDEX BY BINARY_INTEGER;
77: PRIMARY_KEY_ID_LIST INCIDENT_ID_LIST_TYPE;
78:
79: TYPE ACCOUNT_ID_LIST_TYPE IS TABLE OF
80: CS_INCIDENTS_ALL_B.ACCOUNT_ID%TYPE
81: INDEX BY BINARY_INTEGER;
82: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
83: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;
84:

Line 86: CS_INCIDENTS_ALL_B.BILL_TO_ACCOUNT_ID%TYPE

82: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
83: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;
84:
85: TYPE BILL_TO_ACCOUNT_ID_LIST_TYPE IS TABLE OF
86: CS_INCIDENTS_ALL_B.BILL_TO_ACCOUNT_ID%TYPE
87: INDEX BY BINARY_INTEGER;
88: NUM_COL2_ORIG_LIST BILL_TO_ACCOUNT_ID_LIST_TYPE;
89: NUM_COL2_NEW_LIST BILL_TO_ACCOUNT_ID_LIST_TYPE;
90:

Line 92: CS_INCIDENTS_ALL_B.SHIP_TO_ACCOUNT_ID%TYPE

88: NUM_COL2_ORIG_LIST BILL_TO_ACCOUNT_ID_LIST_TYPE;
89: NUM_COL2_NEW_LIST BILL_TO_ACCOUNT_ID_LIST_TYPE;
90:
91: TYPE SHIP_TO_ACCOUNT_ID_LIST_TYPE IS TABLE OF
92: CS_INCIDENTS_ALL_B.SHIP_TO_ACCOUNT_ID%TYPE
93: INDEX BY BINARY_INTEGER;
94: NUM_COL3_ORIG_LIST SHIP_TO_ACCOUNT_ID_LIST_TYPE;
95: NUM_COL3_NEW_LIST SHIP_TO_ACCOUNT_ID_LIST_TYPE;
96:

Line 104: FROM CS_INCIDENTS_ALL_B yt,

100: ,ACCOUNT_ID
101: ,BILL_TO_ACCOUNT_ID
102: ,SHIP_TO_ACCOUNT_ID
103: ,LAST_UPDATE_PROGRAM_CODE
104: FROM CS_INCIDENTS_ALL_B yt,
105: ra_customer_merges m
106: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID
107: OR yt.BILL_TO_ACCOUNT_ID = m.DUPLICATE_ID
108: OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)

Line 148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CS_INCIDENTS_ALL_B',FALSE);

144: IF process_mode='LOCK' THEN
145: NULL;
146: ELSE
147: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CS_INCIDENTS_ALL_B',FALSE);
149:
150: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
151: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
152:

Line 221: HZ_CUSTOMER_MERGE_LOG_s.nextval, 'CS_INCIDENTS_ALL_B',

217: CREATED_BY, CREATION_DATE,
218: LAST_UPDATE_LOGIN, LAST_UPDATE_DATE,
219: LAST_UPDATED_BY )
220: VALUES (
221: HZ_CUSTOMER_MERGE_LOG_s.nextval, 'CS_INCIDENTS_ALL_B',
222: MERGE_HEADER_ID_LIST(I), PRIMARY_KEY_ID_LIST(I),
223: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
224: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
225: NUM_COL3_ORIG_LIST(I), NUM_COL3_NEW_LIST(I),

Line 234: UPDATE CS_INCIDENTS_ALL_B yt SET

230:
231: END IF;
232:
233: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
234: UPDATE CS_INCIDENTS_ALL_B yt SET
235: ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
236: , BILL_TO_ACCOUNT_ID = NUM_COL2_NEW_LIST(I)
237: , SHIP_TO_ACCOUNT_ID = NUM_COL3_NEW_LIST(I)
238: , LAST_UPDATE_PROGRAM_CODE = 'ACCOUNT_MERGE'