APPS.JL_CMERGE dependencies on JL_BR_AR_OCCURRENCE_DOCS

Line 149: -- JL_BR_AR_OCCURRENCE_DOCS_ALL that refers to site_use_id column of --

145: -- jl_br_occ_doc_upd --
146: -- --
147: -- DESCRIPTION --
148: -- Merge duplicate customer_id and site_use_id stored in column of --
149: -- JL_BR_AR_OCCURRENCE_DOCS_ALL that refers to site_use_id column of --
150: -- HZ_CUST_ACCT_SITES_ALL and cust_account_id of HZ_CUST_ACCOUNTS --
151: -- --
152: -- PURPOSE: --
153: -- Oracle Applications Rel 11.5 --

Line 174: JL_BR_AR_OCCURRENCE_DOCS.OCCURRENCE_ID%TYPE

170: INDEX BY BINARY_INTEGER;
171: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
172:
173: TYPE OCCURRENCE_ID_LIST_TYPE IS TABLE OF
174: JL_BR_AR_OCCURRENCE_DOCS.OCCURRENCE_ID%TYPE
175: INDEX BY BINARY_INTEGER;
176: PRIMARY_KEY_ID_LIST OCCURRENCE_ID_LIST_TYPE;
177:
178: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 179: JL_BR_AR_OCCURRENCE_DOCS.CUSTOMER_ID%TYPE

175: INDEX BY BINARY_INTEGER;
176: PRIMARY_KEY_ID_LIST OCCURRENCE_ID_LIST_TYPE;
177:
178: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
179: JL_BR_AR_OCCURRENCE_DOCS.CUSTOMER_ID%TYPE
180: INDEX BY BINARY_INTEGER;
181: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
182: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
183:

Line 185: JL_BR_AR_OCCURRENCE_DOCS.SITE_USE_ID%TYPE

181: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
182: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
183:
184: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
185: JL_BR_AR_OCCURRENCE_DOCS.SITE_USE_ID%TYPE
186: INDEX BY BINARY_INTEGER;
187: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
188: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
189:

Line 196: FROM JL_BR_AR_OCCURRENCE_DOCS yt, ra_customer_merges m

192: SELECT distinct CUSTOMER_MERGE_HEADER_ID
193: ,OCCURRENCE_ID
194: ,yt.CUSTOMER_ID
195: ,yt.SITE_USE_ID
196: FROM JL_BR_AR_OCCURRENCE_DOCS yt, ra_customer_merges m
197: WHERE (
198: yt.CUSTOMER_ID = m.DUPLICATE_ID
199: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
200: ) AND m.process_flag = 'N'

Line 210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);

206: IF process_mode='LOCK' THEN
207: NULL;
208: ELSE
209: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);
211: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
212: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
213:
214: open merged_records;

Line 251: 'JL_BR_AR_OCCURRENCE_DOCS',

247: LAST_UPDATE_LOGIN,
248: LAST_UPDATE_DATE,
249: LAST_UPDATED_BY
250: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
251: 'JL_BR_AR_OCCURRENCE_DOCS',
252: MERGE_HEADER_ID_LIST(I),
253: PRIMARY_KEY_ID_LIST(I),
254: NUM_COL1_ORIG_LIST(I),
255: NUM_COL1_NEW_LIST(I),

Line 269: UPDATE JL_BR_AR_OCCURRENCE_DOCS yt SET

265: );
266: END IF;
267:
268: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
269: UPDATE JL_BR_AR_OCCURRENCE_DOCS yt SET
270: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
271: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
272: , LAST_UPDATE_DATE=SYSDATE
273: , last_updated_by=arp_standard.profile.user_id