APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_CNSLD_AR_HDRS_B

Line 5220: | Account merge procedure for the table, OKL_CNSLD_AR_HDRS_B

5216: /*-------------------------------------------------------------
5217: | PROCEDURE
5218: | CNR_ACCOUNT_MERGE
5219: | DESCRIPTION :
5220: | Account merge procedure for the table, OKL_CNSLD_AR_HDRS_B
5221: |
5222: | NOTES:
5223: |--------------------------------------------------------------*/
5224: PROCEDURE CNR_ACCOUNT_MERGE (

Line 5235: OKL_CNSLD_AR_HDRS_B.ID%TYPE

5231: INDEX BY BINARY_INTEGER;
5232: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
5233:
5234: TYPE ID_LIST_TYPE IS TABLE OF
5235: OKL_CNSLD_AR_HDRS_B.ID%TYPE
5236: INDEX BY BINARY_INTEGER;
5237: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5238:
5239: TYPE IXX_ID_LIST_TYPE IS TABLE OF

Line 5240: OKL_CNSLD_AR_HDRS_B.IXX_ID%TYPE

5236: INDEX BY BINARY_INTEGER;
5237: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5238:
5239: TYPE IXX_ID_LIST_TYPE IS TABLE OF
5240: OKL_CNSLD_AR_HDRS_B.IXX_ID%TYPE
5241: INDEX BY BINARY_INTEGER;
5242: NUM_COL1_ORIG_LIST IXX_ID_LIST_TYPE;
5243: NUM_COL1_NEW_LIST IXX_ID_LIST_TYPE;
5244:

Line 5246: OKL_CNSLD_AR_HDRS_B.IBT_ID%TYPE

5242: NUM_COL1_ORIG_LIST IXX_ID_LIST_TYPE;
5243: NUM_COL1_NEW_LIST IXX_ID_LIST_TYPE;
5244:
5245: TYPE IBT_ID_LIST_TYPE IS TABLE OF
5246: OKL_CNSLD_AR_HDRS_B.IBT_ID%TYPE
5247: INDEX BY BINARY_INTEGER;
5248: NUM_COL2_ORIG_LIST IBT_ID_LIST_TYPE;
5249: NUM_COL2_NEW_LIST IBT_ID_LIST_TYPE;
5250:

Line 5257: FROM OKL_CNSLD_AR_HDRS_B yt, ra_customer_merges m

5253: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5254: ,ID
5255: ,IXX_ID
5256: ,IBT_ID
5257: FROM OKL_CNSLD_AR_HDRS_B yt, ra_customer_merges m
5258: WHERE (
5259: yt.IXX_ID = m.DUPLICATE_ID
5260: OR yt.IBT_ID = m.DUPLICATE_SITE_ID
5261: ) AND m.process_flag = 'N'

Line 5272: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNSLD_AR_HDRS_B',FALSE);

5268: IF process_mode='LOCK' THEN
5269: NULL;
5270: ELSE
5271: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5272: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNSLD_AR_HDRS_B',FALSE);
5273: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5274: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5275:
5276: open merged_records;

Line 5313: 'OKL_CNSLD_AR_HDRS_B',

5309: LAST_UPDATE_LOGIN,
5310: LAST_UPDATE_DATE,
5311: LAST_UPDATED_BY
5312: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5313: 'OKL_CNSLD_AR_HDRS_B',
5314: MERGE_HEADER_ID_LIST(I),
5315: PRIMARY_KEY_ID_LIST(I),
5316: NUM_COL1_ORIG_LIST(I),
5317: NUM_COL1_NEW_LIST(I),

Line 5331: UPDATE OKL_CNSLD_AR_HDRS_B yt SET

5327: );
5328:
5329: END IF;
5330: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5331: UPDATE OKL_CNSLD_AR_HDRS_B yt SET
5332: IXX_ID=NUM_COL1_NEW_LIST(I)
5333: ,IBT_ID=NUM_COL2_NEW_LIST(I)
5334: , LAST_UPDATE_DATE=SYSDATE
5335: , last_updated_by=arp_standard.profile.user_id