APPS.CSC_ACCOUNT_MERGE_PKG dependencies on CSC_CUST_PLANS_AUDIT

Line 47: CSC_CUST_PLANS_AUDIT_MERGE(

43: req_id => req_id,
44: set_num => set_num,
45: process_mode => process_mode );
46:
47: CSC_CUST_PLANS_AUDIT_MERGE(
48: req_id => req_id,
49: set_num => set_num,
50: process_mode => process_mode );
51:

Line 572: PROCEDURE CSC_CUST_PLANS_AUDIT_MERGE (

568: arp_message.set_line( 'CSC_CUST_PLANS_MERGE');
569: RAISE;
570: END CSC_CUST_PLANS_MERGE;
571:
572: PROCEDURE CSC_CUST_PLANS_AUDIT_MERGE (
573: req_id NUMBER,
574: set_num NUMBER,
575: process_mode VARCHAR2) IS
576:

Line 583: CSC_CUST_PLANS_AUDIT.PLAN_AUDIT_ID%TYPE

579: INDEX BY BINARY_INTEGER;
580: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
581:
582: TYPE PLAN_AUDIT_ID_LIST_TYPE IS TABLE OF
583: CSC_CUST_PLANS_AUDIT.PLAN_AUDIT_ID%TYPE
584: INDEX BY BINARY_INTEGER;
585: PRIMARY_KEY_ID_LIST PLAN_AUDIT_ID_LIST_TYPE;
586:
587: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 588: CSC_CUST_PLANS_AUDIT.cust_account_id%TYPE

584: INDEX BY BINARY_INTEGER;
585: PRIMARY_KEY_ID_LIST PLAN_AUDIT_ID_LIST_TYPE;
586:
587: TYPE cust_account_id_LIST_TYPE IS TABLE OF
588: CSC_CUST_PLANS_AUDIT.cust_account_id%TYPE
589: INDEX BY BINARY_INTEGER;
590: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
591: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
592:

Line 604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca

600: CURSOR merged_records IS
601: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
602: ,yt.plan_audit_id
603: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
604: FROM CSC_CUST_PLANS_AUDIT yt, ra_customer_merges m , hz_cust_accounts hzca
605: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
606: AND m.process_flag = 'N'
607: AND m.request_id = req_id
608: AND m.set_number = set_num;

Line 616: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS_AUDIT',FALSE);

612: IF process_mode='LOCK' THEN
613: NULL;
614: ELSE
615: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
616: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS_AUDIT',FALSE);
617: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
618: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
619:
620: open merged_records;

Line 658: 'CSC_CUST_PLANS_AUDIT',

654: LAST_UPDATE_LOGIN,
655: LAST_UPDATE_DATE,
656: LAST_UPDATED_BY
657: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
658: 'CSC_CUST_PLANS_AUDIT',
659: MERGE_HEADER_ID_LIST(I),
660: PRIMARY_KEY_ID_LIST(I),
661: NUM_COL1_ORIG_LIST(I),
662: NUM_COL1_NEW_LIST(I),

Line 675: UPDATE CSC_CUST_PLANS_AUDIT yt SET

671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
674: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
675: UPDATE CSC_CUST_PLANS_AUDIT yt SET
676: cust_account_id=NUM_COL1_NEW_LIST(I)
677: , party_id=NUM_COL2_NEW_LIST(I)
678: , LAST_UPDATE_DATE=SYSDATE
679: , last_updated_by=arp_standard.profile.user_id

Line 691: csc_cust_plans_audit yts, ra_customer_merges m WHERE

687: m.process_flag = 'N'
688: AND m.request_id = req_id
689: AND m.set_number = set_num )
690: AND plan_id not in ( SELECT yts.plan_id FROM
691: csc_cust_plans_audit yts, ra_customer_merges m WHERE
692: yts.cust_account_id = m.customer_id
693: AND m.process_flag = 'N'
694: AND m.request_id = req_id
695: AND m.set_number = set_num )

Line 708: arp_message.set_line( 'CSC_CUST_PLANS_AUDIT_MERGE');

704: arp_message.set_token('NUM_ROWS',to_char(l_count));
705: END IF;
706: EXCEPTION
707: WHEN OTHERS THEN
708: arp_message.set_line( 'CSC_CUST_PLANS_AUDIT_MERGE');
709: RAISE;
710: END CSC_CUST_PLANS_AUDIT_MERGE;
711:
712: END CSC_ACCOUNT_MERGE_PKG;

Line 710: END CSC_CUST_PLANS_AUDIT_MERGE;

706: EXCEPTION
707: WHEN OTHERS THEN
708: arp_message.set_line( 'CSC_CUST_PLANS_AUDIT_MERGE');
709: RAISE;
710: END CSC_CUST_PLANS_AUDIT_MERGE;
711:
712: END CSC_ACCOUNT_MERGE_PKG;