APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_CNTR_LVLNG_GRPS_B

Line 5362: | Account merge procedure for the table, OKL_CNTR_LVLNG_GRPS_B

5358: /*-------------------------------------------------------------
5359: | PROCEDURE
5360: | CLG_ACCOUNT_MERGE
5361: | DESCRIPTION :
5362: | Account merge procedure for the table, OKL_CNTR_LVLNG_GRPS_B
5363: |
5364: | NOTES:
5365: |--------------------------------------------------------------*/
5366: PROCEDURE CLG_ACCOUNT_MERGE (

Line 5377: OKL_CNTR_LVLNG_GRPS_B.ID%TYPE

5373: INDEX BY BINARY_INTEGER;
5374: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
5375:
5376: TYPE ID_LIST_TYPE IS TABLE OF
5377: OKL_CNTR_LVLNG_GRPS_B.ID%TYPE
5378: INDEX BY BINARY_INTEGER;
5379: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5380:
5381: TYPE ICA_ID_LIST_TYPE IS TABLE OF

Line 5382: OKL_CNTR_LVLNG_GRPS_B.ICA_ID%TYPE

5378: INDEX BY BINARY_INTEGER;
5379: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5380:
5381: TYPE ICA_ID_LIST_TYPE IS TABLE OF
5382: OKL_CNTR_LVLNG_GRPS_B.ICA_ID%TYPE
5383: INDEX BY BINARY_INTEGER;
5384: NUM_COL1_ORIG_LIST ICA_ID_LIST_TYPE;
5385: NUM_COL1_NEW_LIST ICA_ID_LIST_TYPE;
5386:

Line 5392: FROM OKL_CNTR_LVLNG_GRPS_B yt, ra_customer_merges m

5388: CURSOR merged_records IS
5389: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5390: ,ID
5391: ,ICA_ID
5392: FROM OKL_CNTR_LVLNG_GRPS_B yt, ra_customer_merges m
5393: WHERE (
5394: yt.ICA_ID = m.DUPLICATE_ID
5395: ) AND m.process_flag = 'N'
5396: AND m.request_id = req_id

Line 5406: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNTR_LVLNG_GRPS_B',FALSE);

5402: IF process_mode='LOCK' THEN
5403: NULL;
5404: ELSE
5405: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5406: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNTR_LVLNG_GRPS_B',FALSE);
5407: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5408: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5409:
5410: open merged_records;

Line 5443: 'OKL_CNTR_LVLNG_GRPS_B',

5439: LAST_UPDATE_LOGIN,
5440: LAST_UPDATE_DATE,
5441: LAST_UPDATED_BY
5442: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5443: 'OKL_CNTR_LVLNG_GRPS_B',
5444: MERGE_HEADER_ID_LIST(I),
5445: PRIMARY_KEY_ID_LIST(I),
5446: NUM_COL1_ORIG_LIST(I),
5447: NUM_COL1_NEW_LIST(I),

Line 5459: UPDATE OKL_CNTR_LVLNG_GRPS_B yt SET

5455: );
5456:
5457: END IF;
5458: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5459: UPDATE OKL_CNTR_LVLNG_GRPS_B yt SET
5460: ICA_ID=NUM_COL1_NEW_LIST(I)
5461: , LAST_UPDATE_DATE=SYSDATE
5462: , last_updated_by=arp_standard.profile.user_id
5463: , last_update_login=arp_standard.profile.last_update_login