APPS.JL_CMERGE dependencies on JL_BR_AR_BANK_RETURNS

Line 13: -- JL_BR_AR_BANK_RETURNS_ALL that refers to cust_account_id column of --

9: -- jl_br_bnk_rtrn_upd --
10: -- --
11: -- DESCRIPTION --
12: -- Merge duplicate customer_id stored in column of table --
13: -- JL_BR_AR_BANK_RETURNS_ALL that refers to cust_account_id column of --
14: -- HZ_CUST_ACCOUNTS --
15: -- --
16: -- PURPOSE: --
17: -- Oracle Applications Rel 11.5 --

Line 38: JL_BR_AR_BANK_RETURNS.RETURN_ID%TYPE

34: INDEX BY BINARY_INTEGER;
35: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
36:
37: TYPE RETURN_ID_LIST_TYPE IS TABLE OF
38: JL_BR_AR_BANK_RETURNS.RETURN_ID%TYPE
39: INDEX BY BINARY_INTEGER;
40: PRIMARY_KEY_ID_LIST RETURN_ID_LIST_TYPE;
41:
42: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 43: JL_BR_AR_BANK_RETURNS.CUSTOMER_ID%TYPE

39: INDEX BY BINARY_INTEGER;
40: PRIMARY_KEY_ID_LIST RETURN_ID_LIST_TYPE;
41:
42: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
43: JL_BR_AR_BANK_RETURNS.CUSTOMER_ID%TYPE
44: INDEX BY BINARY_INTEGER;
45: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
46: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
47:

Line 54: FROM JL_BR_AR_BANK_RETURNS yt, ra_customer_merges m

50: CURSOR merged_records IS
51: SELECT distinct CUSTOMER_MERGE_HEADER_ID
52: ,RETURN_ID
53: ,yt.CUSTOMER_ID
54: FROM JL_BR_AR_BANK_RETURNS yt, ra_customer_merges m
55: WHERE (
56: yt.CUSTOMER_ID = m.DUPLICATE_ID
57: ) AND m.process_flag = 'N'
58: AND m.request_id = req_id

Line 67: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_BANK_RETURNS',FALSE);

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

Line 104: 'JL_BR_AR_BANK_RETURNS',

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

Line 119: UPDATE JL_BR_AR_BANK_RETURNS yt SET

115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
119: UPDATE JL_BR_AR_BANK_RETURNS yt SET
120: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
121: , LAST_UPDATE_DATE=SYSDATE
122: , last_updated_by=arp_standard.profile.user_id
123: , last_update_login=arp_standard.profile.last_update_login