APPS.DPP_ACCOUNT_MERGE_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 13: | Account merge procedure for the table, dpp_customer_claims_all

9: |
10: | PROCEDURE
11: | merge_claim_account
12: | DESCRIPTION :
13: | Account merge procedure for the table, dpp_customer_claims_all
14: |
15: | NOTES:
16: |
17: |--------------------------------------------------------------*/

Line 31: DPP_CUSTOMER_CLAIMS_ALL.CUSTOMER_INV_LINE_ID%TYPE

27:
28: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
29:
30: TYPE CUSTOMER_INV_LINE_ID_LIST_TYPE IS TABLE OF
31: DPP_CUSTOMER_CLAIMS_ALL.CUSTOMER_INV_LINE_ID%TYPE
32: INDEX BY BINARY_INTEGER;
33:
34: PRIMARY_KEY_ID1_LIST CUSTOMER_INV_LINE_ID_LIST_TYPE;
35:

Line 49: FROM dpp_customer_claims_all yt, ra_customer_merges m

45: CURSOR merged_records IS
46: SELECT DISTINCT m.customer_merge_header_id
47: ,yt.customer_inv_line_id
48: ,m.customer_id
49: FROM dpp_customer_claims_all yt, ra_customer_merges m
50: WHERE (
51: yt.cust_account_id = m.duplicate_id
52: ) AND m.process_flag = 'N'
53: AND m.request_id = req_id

Line 65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_all',FALSE);

61: IF process_mode='LOCK' THEN
62: NULL;
63: ELSE
64: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
65: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','dpp_customer_claims_all',FALSE);
66: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
67: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
68:
69: open merged_records;

Line 105: 'dpp_customer_claims_all',

101: LAST_UPDATE_LOGIN,
102: LAST_UPDATE_DATE,
103: LAST_UPDATED_BY
104: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
105: 'dpp_customer_claims_all',
106: MERGE_HEADER_ID_LIST(I),
107: PRIMARY_KEY_ID1_LIST(I),
108: NUM_COL1_ORIG_LIST(I),
109: NUM_COL1_NEW_LIST(I),

Line 122: UPDATE dpp_customer_claims_all yt SET

118:
119: END IF;
120: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
121:
122: UPDATE dpp_customer_claims_all yt SET
123: cust_account_id = TO_CHAR(NUM_COL1_NEW_LIST(I))
124: , LAST_UPDATE_DATE = SYSDATE
125: , last_updated_by = arp_standard.profile.user_id
126: , last_update_login = arp_standard.profile.last_update_login