APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_ACCT_SOURCES

Line 5485: | Account merge procedure for the table, OKL_ACCT_SOURCES

5481: /*-------------------------------------------------------------
5482: | PROCEDURE
5483: | ASE_ACCOUNT_MERGE
5484: | DESCRIPTION :
5485: | Account merge procedure for the table, OKL_ACCT_SOURCES
5486: |--------------------------------------------------------------*/
5487: PROCEDURE ASE_ACCOUNT_MERGE (
5488: req_id NUMBER,
5489: set_num NUMBER,

Line 5498: OKL_ACCT_SOURCES.ID%TYPE

5494: INDEX BY BINARY_INTEGER;
5495: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
5496:
5497: TYPE ID_LIST_TYPE IS TABLE OF
5498: OKL_ACCT_SOURCES.ID%TYPE
5499: INDEX BY BINARY_INTEGER;
5500: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5501:
5502: TYPE REC_SITE_USES_PK_LIST_TYPE IS TABLE OF

Line 5503: OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE

5499: INDEX BY BINARY_INTEGER;
5500: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5501:
5502: TYPE REC_SITE_USES_PK_LIST_TYPE IS TABLE OF
5503: OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE
5504: INDEX BY BINARY_INTEGER;
5505: NUM_COL1_ORIG_LIST REC_SITE_USES_PK_LIST_TYPE;
5506: NUM_COL1_NEW_LIST REC_SITE_USES_PK_LIST_TYPE;
5507:

Line 5513: FROM OKL_ACCT_SOURCES yt, ra_customer_merges m

5509: CURSOR merged_records IS
5510: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5511: ,ID
5512: ,REC_SITE_USES_PK
5513: FROM OKL_ACCT_SOURCES yt, ra_customer_merges m
5514: WHERE (
5515: yt.REC_SITE_USES_PK = m.DUPLICATE_SITE_ID
5516: ) AND m.process_flag = 'N'
5517: AND m.request_id = req_id

Line 5526: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_ACCT_SOURCES',FALSE);

5522: IF process_mode='LOCK' THEN
5523: NULL;
5524: ELSE
5525: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5526: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_ACCT_SOURCES',FALSE);
5527: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5528: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5529:
5530: open merged_records;

Line 5563: 'OKL_ACCT_SOURCES',

5559: LAST_UPDATE_LOGIN,
5560: LAST_UPDATE_DATE,
5561: LAST_UPDATED_BY
5562: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5563: 'OKL_ACCT_SOURCES',
5564: MERGE_HEADER_ID_LIST(I),
5565: PRIMARY_KEY_ID_LIST(I),
5566: NUM_COL1_ORIG_LIST(I),
5567: NUM_COL1_NEW_LIST(I),

Line 5578: UPDATE OKL_ACCT_SOURCES yt SET

5574: hz_utility_pub.LAST_UPDATED_BY
5575: );
5576:
5577: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5578: UPDATE OKL_ACCT_SOURCES yt SET
5579: REC_SITE_USES_PK=NUM_COL1_NEW_LIST(I)
5580: , LAST_UPDATE_DATE=SYSDATE
5581: , last_updated_by=arp_standard.profile.user_id
5582: , last_update_login=arp_standard.profile.last_update_login