APPS.CSC_ACCOUNT_MERGE_PKG dependencies on CSC_CUSTOMIZED_PLANS

Line 15: -- 02-12-2003 bhroy LAST_UPDATE_DATE, Last_updated_by, Last_update_login commented for CSC_CUSTOMIZED_PLANS table

11: -- 02-02-2001 dejoseph Modified update stmt. to update the new columns that
12: -- were added. ie. request_id, program_application_id,
13: -- program_id, program_update_date.
14: -- 12-23-2002 bhroy All procedures body changed using the auto generated Perl script.
15: -- 02-12-2003 bhroy LAST_UPDATE_DATE, Last_updated_by, Last_update_login commented for CSC_CUSTOMIZED_PLANS table
16: -- 02-25-2003 bhroy l_count initialized, CSC_CUST_PLANS update where clause changed, delete redundant record
17: -- 04-28-2003 bhroy TCA sripts are inserting same record for ORIG and NEW columns, modified merge cursor
18: -- 06-26-2003 bhroy Fixed cross party merge, Bug# 2930337
19: --

Line 37: CSC_CUSTOMIZED_PLANS_MERGE(

33: req_id => req_id,
34: set_num => set_num,
35: process_mode => process_mode );
36:
37: CSC_CUSTOMIZED_PLANS_MERGE(
38: req_id => req_id,
39: set_num => set_num,
40: process_mode => process_mode );
41:

Line 291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (

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,
294: process_mode VARCHAR2) IS
295:

Line 302: CSC_CUSTOMIZED_PLANS.cust_account_id%TYPE

298: INDEX BY BINARY_INTEGER;
299: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
300:
301: TYPE cust_account_id_LIST_TYPE IS TABLE OF
302: CSC_CUSTOMIZED_PLANS.cust_account_id%TYPE
303: INDEX BY BINARY_INTEGER;
304: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
305: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
306:

Line 308: CSC_CUSTOMIZED_PLANS.PARTY_ID%TYPE

304: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
305: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
306:
307: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
308: CSC_CUSTOMIZED_PLANS.PARTY_ID%TYPE
309: INDEX BY BINARY_INTEGER;
310: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
311: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
312:

Line 317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca

313: l_profile_val VARCHAR2(30);
314: CURSOR merged_records IS
315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
316: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
317: FROM CSC_CUSTOMIZED_PLANS yt, ra_customer_merges m , hz_cust_accounts hzca
318: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
319: AND m.process_flag = 'N'
320: AND m.request_id = req_id
321: AND m.set_number = set_num;

Line 329: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMIZED_PLANS',FALSE);

325: IF process_mode='LOCK' THEN
326: NULL;
327: ELSE
328: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
329: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMIZED_PLANS',FALSE);
330: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
331: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
332:
333: open merged_records;

Line 369: 'CSC_CUSTOMIZED_PLANS',

365: LAST_UPDATE_LOGIN,
366: LAST_UPDATE_DATE,
367: LAST_UPDATED_BY
368: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
369: 'CSC_CUSTOMIZED_PLANS',
370: MERGE_HEADER_ID_LIST(I),
371: NUM_COL1_ORIG_LIST(I),
372: NUM_COL1_NEW_LIST(I),
373: NUM_COL2_ORIG_LIST(I),

Line 385: UPDATE CSC_CUSTOMIZED_PLANS yt SET

381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
384: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
385: UPDATE CSC_CUSTOMIZED_PLANS yt SET
386: cust_account_id=NUM_COL1_NEW_LIST(I)
387: , party_id=NUM_COL2_NEW_LIST(I)
388: -- , LAST_UPDATE_DATE=SYSDATE
389: -- , last_updated_by=arp_standard.profile.user_id

Line 412: arp_message.set_line( 'CSC_CUSTOMIZED_PLANS_MERGE');

408: arp_message.set_token('NUM_ROWS',to_char(l_count));
409: END IF;
410: EXCEPTION
411: WHEN OTHERS THEN
412: arp_message.set_line( 'CSC_CUSTOMIZED_PLANS_MERGE');
413: RAISE;
414: END CSC_CUSTOMIZED_PLANS_MERGE;
415:
416: PROCEDURE CSC_CUST_PLANS_MERGE (

Line 414: END CSC_CUSTOMIZED_PLANS_MERGE;

410: EXCEPTION
411: WHEN OTHERS THEN
412: arp_message.set_line( 'CSC_CUSTOMIZED_PLANS_MERGE');
413: RAISE;
414: END CSC_CUSTOMIZED_PLANS_MERGE;
415:
416: PROCEDURE CSC_CUST_PLANS_MERGE (
417: req_id NUMBER,
418: set_num NUMBER,