APPS.ARP_CMERGE_ARCOL dependencies on AR_CUSTOMER_CALLS

Line 140: records in table ar_customer_calls_all

136: END ar_cct;
137:
138: /*--------------------------- PRIVATE ROUTINES ------------------------------*/
139: /* bug3541921 : Added following procedure ar_cc to update
140: records in table ar_customer_calls_all
141: */
142: PROCEDURE ar_ccalls (
143: req_id NUMBER,
144: set_num NUMBER,

Line 153: AR_CUSTOMER_CALLS.customer_call_id%TYPE

149: INDEX BY BINARY_INTEGER;
150: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
151:
152: TYPE customer_call_id_LIST_TYPE IS TABLE OF
153: AR_CUSTOMER_CALLS.customer_call_id%TYPE
154: INDEX BY BINARY_INTEGER;
155: PRIMARY_KEY_ID_LIST customer_call_id_LIST_TYPE;
156:
157: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 158: AR_CUSTOMER_CALLS.customer_id%TYPE

154: INDEX BY BINARY_INTEGER;
155: PRIMARY_KEY_ID_LIST customer_call_id_LIST_TYPE;
156:
157: TYPE customer_id_LIST_TYPE IS TABLE OF
158: AR_CUSTOMER_CALLS.customer_id%TYPE
159: INDEX BY BINARY_INTEGER;
160: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
161: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
162:

Line 164: AR_CUSTOMER_CALLS.site_use_id%TYPE

160: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
161: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
162:
163: TYPE site_use_id_LIST_TYPE IS TABLE OF
164: AR_CUSTOMER_CALLS.site_use_id%TYPE
165: INDEX BY BINARY_INTEGER;
166: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
167: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
168:

Line 175: FROM AR_CUSTOMER_CALLS yt, ra_customer_merges m

171: SELECT distinct CUSTOMER_MERGE_HEADER_ID
172: ,customer_call_id
173: ,yt.customer_id
174: ,site_use_id
175: FROM AR_CUSTOMER_CALLS yt, ra_customer_merges m
176: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
177: nvl(yt.site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
178: AND m.process_flag = 'N'
179: AND m.request_id = req_id

Line 188: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALLS',FALSE);

184: IF process_mode='LOCK' THEN
185: NULL;
186: ELSE
187: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
188: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALLS',FALSE);
189: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
190: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
191:
192: open merged_records;

Line 229: 'AR_CUSTOMER_CALLS',

225: LAST_UPDATE_LOGIN,
226: LAST_UPDATE_DATE,
227: LAST_UPDATED_BY
228: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
229: 'AR_CUSTOMER_CALLS',
230: MERGE_HEADER_ID_LIST(I),
231: PRIMARY_KEY_ID_LIST(I),
232: NUM_COL1_ORIG_LIST(I),
233: NUM_COL1_NEW_LIST(I),

Line 246: UPDATE AR_CUSTOMER_CALLS yt SET

242: hz_utility_pub.LAST_UPDATED_BY
243: );
244:
245: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
246: UPDATE AR_CUSTOMER_CALLS yt SET
247: customer_id=NUM_COL1_NEW_LIST(I)
248: ,site_use_id=NUM_COL2_NEW_LIST(I)
249: , LAST_UPDATE_DATE=SYSDATE
250: , last_updated_by=arp_standard.profile.user_id