APPS.JL_CMERGE dependencies on JL_BR_AR_PAY_SCHED_AUX

Line 324: JL_BR_AR_PAY_SCHED_AUX.PAYMENT_SCHEDULE_ID%TYPE

320: INDEX BY BINARY_INTEGER;
321: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
322:
323: TYPE PAYMENT_SCHEDULE_ID_LIST_TYPE IS TABLE OF
324: JL_BR_AR_PAY_SCHED_AUX.PAYMENT_SCHEDULE_ID%TYPE
325: INDEX BY BINARY_INTEGER;
326: PRIMARY_KEY_ID_LIST PAYMENT_SCHEDULE_ID_LIST_TYPE;
327:
328: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 329: JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_SITE_USE_ID%TYPE

325: INDEX BY BINARY_INTEGER;
326: PRIMARY_KEY_ID_LIST PAYMENT_SCHEDULE_ID_LIST_TYPE;
327:
328: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
329: JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_SITE_USE_ID%TYPE
330: INDEX BY BINARY_INTEGER;
331: NUM_COL1_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
332: NUM_COL1_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
333:

Line 339: FROM JL_BR_AR_PAY_SCHED_AUX yt, ra_customer_merges m

335: CURSOR merged_records IS
336: SELECT distinct CUSTOMER_MERGE_HEADER_ID
337: ,PAYMENT_SCHEDULE_ID
338: ,yt.CUSTOMER_SITE_USE_ID
339: FROM JL_BR_AR_PAY_SCHED_AUX yt, ra_customer_merges m
340: WHERE (
341: yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
342: ) AND m.process_flag = 'N'
343: AND m.request_id = req_id

Line 352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);

348: IF process_mode='LOCK' THEN
349: NULL;
350: ELSE
351: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);
353: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
354: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
355:
356: open merged_records;

Line 389: 'JL_BR_AR_PAY_SCHED_AUX',

385: LAST_UPDATE_LOGIN,
386: LAST_UPDATE_DATE,
387: LAST_UPDATED_BY
388: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
389: 'JL_BR_AR_PAY_SCHED_AUX',
390: MERGE_HEADER_ID_LIST(I),
391: PRIMARY_KEY_ID_LIST(I),
392: NUM_COL1_ORIG_LIST(I),
393: NUM_COL1_NEW_LIST(I),

Line 404: UPDATE JL_BR_AR_PAY_SCHED_AUX yt SET

400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
403: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
404: UPDATE JL_BR_AR_PAY_SCHED_AUX yt SET
405: CUSTOMER_SITE_USE_ID=NUM_COL1_NEW_LIST(I)
406: WHERE PAYMENT_SCHEDULE_ID=PRIMARY_KEY_ID_LIST(I)
407: ;
408: l_count := l_count + SQL%ROWCOUNT;