APPS.AR_CMGT_ACCOUNT_MERGE dependencies on AR_CMGT_CASE_FOLDERS

Line 8: | Account merge procedure for the table, AR_CMGT_CASE_FOLDERS

4: |
5: | PROCEDURE
6: | CASE_FOLDER_ACCOUNT_MERGE
7: | DESCRIPTION :
8: | Account merge procedure for the table, AR_CMGT_CASE_FOLDERS
9: |
10: |--------------------------------------------------------------*/
11:
12: PROCEDURE CASE_FOLDER_ACCOUNT_MERGE (

Line 23: AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE

19: INDEX BY BINARY_INTEGER;
20: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
21:
22: TYPE CASE_FOLDER_ID_LIST_TYPE IS TABLE OF
23: AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE
24: INDEX BY BINARY_INTEGER;
25: PRIMARY_KEY_ID_LIST CASE_FOLDER_ID_LIST_TYPE;
26:
27: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 28: AR_CMGT_CASE_FOLDERS.CUST_ACCOUNT_ID%TYPE

24: INDEX BY BINARY_INTEGER;
25: PRIMARY_KEY_ID_LIST CASE_FOLDER_ID_LIST_TYPE;
26:
27: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
28: AR_CMGT_CASE_FOLDERS.CUST_ACCOUNT_ID%TYPE
29: INDEX BY BINARY_INTEGER;
30: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
31: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
32:

Line 34: AR_CMGT_CASE_FOLDERS.SITE_USE_ID%TYPE

30: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
31: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
32:
33: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
34: AR_CMGT_CASE_FOLDERS.SITE_USE_ID%TYPE
35: INDEX BY BINARY_INTEGER;
36: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
37: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
38:

Line 45: FROM ar_cmgt_case_folders yt,

41: SELECT distinct CUSTOMER_MERGE_HEADER_ID
42: ,CASE_FOLDER_ID
43: ,CUST_ACCOUNT_ID
44: ,SITE_USE_ID
45: FROM ar_cmgt_case_folders yt,
46: ra_customer_merges m
47: WHERE yt.cust_account_id = m.duplicate_id
48: AND DECODE( yt.site_use_id , -99, m.duplicate_site_id,
49: yt.site_use_id ) = m.duplicate_site_id

Line 61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CMGT_CASE_FOLDERS',FALSE);

57: IF process_mode='LOCK' THEN
58: NULL;
59: ELSE
60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CMGT_CASE_FOLDERS',FALSE);
62: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
63: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
64:
65: open merged_records;

Line 102: 'AR_CMGT_CASE_FOLDERS',

98: LAST_UPDATE_LOGIN,
99: LAST_UPDATE_DATE,
100: LAST_UPDATED_BY
101: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
102: 'AR_CMGT_CASE_FOLDERS',
103: MERGE_HEADER_ID_LIST(I),
104: PRIMARY_KEY_ID_LIST(I),
105: NUM_COL1_ORIG_LIST(I),
106: NUM_COL1_NEW_LIST(I),

Line 123: FROM ar_cmgt_case_folders

119: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
120: DELETE FROM ar_cmgt_cf_dtls
121: WHERE case_folder_id in (
122: SELECT case_folder_id
123: FROM ar_cmgt_case_folders
124: WHERE case_folder_id = PRIMARY_KEY_ID_LIST(I)
125: AND type = 'DATA');
126:
127: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 128: DELETE FROM ar_cmgt_case_folders

124: WHERE case_folder_id = PRIMARY_KEY_ID_LIST(I)
125: AND type = 'DATA');
126:
127: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
128: DELETE FROM ar_cmgt_case_folders
129: WHERE case_folder_id = PRIMARY_KEY_ID_LIST(I)
130: AND type = 'DATA';
131:
132: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 133: UPDATE AR_CMGT_CASE_FOLDERS yt SET

129: WHERE case_folder_id = PRIMARY_KEY_ID_LIST(I)
130: AND type = 'DATA';
131:
132: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
133: UPDATE AR_CMGT_CASE_FOLDERS yt SET
134: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
135: ,SITE_USE_ID=DECODE( SITE_USE_ID, -99,-99,NUM_COL2_NEW_LIST(I))
136: , LAST_UPDATE_DATE=SYSDATE
137: , last_updated_by=arp_standard.profile.user_id