APPS.ARP_CMERGE_ARCOL dependencies on AR_CUSTOMER_CALL_TOPICS

Line 22: AR_CUSTOMER_CALL_TOPICS.customer_call_topic_id%TYPE

18: INDEX BY BINARY_INTEGER;
19: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
20:
21: TYPE cust_call_topic_id_LIST_TYPE IS TABLE OF
22: AR_CUSTOMER_CALL_TOPICS.customer_call_topic_id%TYPE
23: INDEX BY BINARY_INTEGER;
24: PRIMARY_KEY_ID_LIST cust_call_topic_id_LIST_TYPE;
25:
26: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 27: AR_CUSTOMER_CALL_TOPICS.customer_id%TYPE

23: INDEX BY BINARY_INTEGER;
24: PRIMARY_KEY_ID_LIST cust_call_topic_id_LIST_TYPE;
25:
26: TYPE customer_id_LIST_TYPE IS TABLE OF
27: AR_CUSTOMER_CALL_TOPICS.customer_id%TYPE
28: INDEX BY BINARY_INTEGER;
29: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
30: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
31:

Line 33: AR_CUSTOMER_CALL_TOPICS.site_use_id%TYPE

29: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
30: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
31:
32: TYPE site_use_id_LIST_TYPE IS TABLE OF
33: AR_CUSTOMER_CALL_TOPICS.site_use_id%TYPE
34: INDEX BY BINARY_INTEGER;
35: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
36: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
37:

Line 44: FROM AR_CUSTOMER_CALL_TOPICS yt, ra_customer_merges m

40: SELECT distinct CUSTOMER_MERGE_HEADER_ID
41: ,customer_call_topic_id
42: ,yt.customer_id
43: ,site_use_id
44: FROM AR_CUSTOMER_CALL_TOPICS yt, ra_customer_merges m
45: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
46: nvl(yt.site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
47: AND m.process_flag = 'N'
48: AND m.request_id = req_id

Line 57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALL_TOPICS',FALSE);

53: IF process_mode='LOCK' THEN
54: NULL;
55: ELSE
56: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALL_TOPICS',FALSE);
58: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
59: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
60:
61: open merged_records;

Line 98: 'AR_CUSTOMER_CALL_TOPICS',

94: LAST_UPDATE_LOGIN,
95: LAST_UPDATE_DATE,
96: LAST_UPDATED_BY
97: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
98: 'AR_CUSTOMER_CALL_TOPICS',
99: MERGE_HEADER_ID_LIST(I),
100: PRIMARY_KEY_ID_LIST(I),
101: NUM_COL1_ORIG_LIST(I),
102: NUM_COL1_NEW_LIST(I),

Line 115: UPDATE AR_CUSTOMER_CALL_TOPICS yt SET

111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
114: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
115: UPDATE AR_CUSTOMER_CALL_TOPICS yt SET
116: customer_id=NUM_COL1_NEW_LIST(I)
117: ,site_use_id=NUM_COL2_NEW_LIST(I)
118: , LAST_UPDATE_DATE=SYSDATE
119: , last_updated_by=arp_standard.profile.user_id