APPS.CSC_ACCOUNT_MERGE_PKG dependencies on CSC_CUSTOMERS_AUDIT_HIST

Line 32: CSC_CUSTOMERS_AUDIT_HIST_MERGE(

28: req_id => req_id,
29: set_num => set_num,
30: process_mode => process_mode );
31:
32: CSC_CUSTOMERS_AUDIT_HIST_MERGE(
33: req_id => req_id,
34: set_num => set_num,
35: process_mode => process_mode );
36:

Line 179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (

175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
176: RAISE;
177: END CSC_CUSTOMERS_MERGE;
178:
179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
180: req_id NUMBER,
181: set_num NUMBER,
182: process_mode VARCHAR2) IS
183:

Line 190: CSC_CUSTOMERS_AUDIT_HIST.cust_account_id%TYPE

186: INDEX BY BINARY_INTEGER;
187: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
188:
189: TYPE cust_account_id_LIST_TYPE IS TABLE OF
190: CSC_CUSTOMERS_AUDIT_HIST.cust_account_id%TYPE
191: INDEX BY BINARY_INTEGER;
192: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
193: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
194:

Line 199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca

195: l_profile_val VARCHAR2(30);
196: CURSOR merged_records IS
197: SELECT distinct CUSTOMER_MERGE_HEADER_ID
198: ,m.customer_id, m.duplicate_id
199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca
200: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
201: AND m.process_flag = 'N'
202: AND m.request_id = req_id
203: AND m.set_number = set_num;

Line 211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);

207: IF process_mode='LOCK' THEN
208: NULL;
209: ELSE
210: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);
212: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
213: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
214:
215: open merged_records;

Line 247: 'CSC_CUSTOMERS_AUDIT_HIST',

243: LAST_UPDATE_LOGIN,
244: LAST_UPDATE_DATE,
245: LAST_UPDATED_BY
246: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
247: 'CSC_CUSTOMERS_AUDIT_HIST',
248: MERGE_HEADER_ID_LIST(I),
249: NUM_COL1_ORIG_LIST(I),
250: NUM_COL1_NEW_LIST(I),
251: 'U',

Line 261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET

257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET
262: cust_account_id=NUM_COL1_NEW_LIST(I)
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login

Line 287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');

283: arp_message.set_token('NUM_ROWS',to_char(l_count));
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
288: RAISE;
289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;
290:
291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (

Line 289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;

285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
288: RAISE;
289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;
290:
291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
292: req_id NUMBER,
293: set_num NUMBER,