APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_EXT_SELL_INVS_B

Line 4254: | Account merge procedure for the table, OKL_EXT_SELL_INVS_B

4250: /*-------------------------------------------------------------
4251: | PROCEDURE
4252: | XSI_ACCOUNT_MERGE
4253: | DESCRIPTION :
4254: | Account merge procedure for the table, OKL_EXT_SELL_INVS_B
4255: |
4256: | NOTES:
4257: |--------------------------------------------------------------*/
4258: PROCEDURE XSI_ACCOUNT_MERGE (

Line 4269: OKL_EXT_SELL_INVS_B.ID%TYPE

4265: INDEX BY BINARY_INTEGER;
4266: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
4267:
4268: TYPE ID_LIST_TYPE IS TABLE OF
4269: OKL_EXT_SELL_INVS_B.ID%TYPE
4270: INDEX BY BINARY_INTEGER;
4271: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4272:
4273: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 4274: OKL_EXT_SELL_INVS_B.CUSTOMER_ID%TYPE

4270: INDEX BY BINARY_INTEGER;
4271: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4272:
4273: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
4274: OKL_EXT_SELL_INVS_B.CUSTOMER_ID%TYPE
4275: INDEX BY BINARY_INTEGER;
4276: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
4277: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
4278:

Line 4280: OKL_EXT_SELL_INVS_B.CUSTOMER_ADDRESS_ID%TYPE

4276: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
4277: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
4278:
4279: TYPE CUSTOMER_ADDRESS_ID_LIST_TYPE IS TABLE OF
4280: OKL_EXT_SELL_INVS_B.CUSTOMER_ADDRESS_ID%TYPE
4281: INDEX BY BINARY_INTEGER;
4282: NUM_COL2_ORIG_LIST CUSTOMER_ADDRESS_ID_LIST_TYPE;
4283: NUM_COL2_NEW_LIST CUSTOMER_ADDRESS_ID_LIST_TYPE;
4284:

Line 4291: FROM OKL_EXT_SELL_INVS_B yt, ra_customer_merges m

4287: SELECT distinct CUSTOMER_MERGE_HEADER_ID
4288: ,yt.ID
4289: ,yt.CUSTOMER_ID
4290: ,yt.CUSTOMER_ADDRESS_ID
4291: FROM OKL_EXT_SELL_INVS_B yt, ra_customer_merges m
4292: WHERE (
4293: yt.CUSTOMER_ID = m.DUPLICATE_ID
4294: OR yt.CUSTOMER_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
4295: ) AND m.process_flag = 'N'

Line 4306: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_EXT_SELL_INVS_B',FALSE);

4302: IF process_mode='LOCK' THEN
4303: NULL;
4304: ELSE
4305: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4306: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_EXT_SELL_INVS_B',FALSE);
4307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4309:
4310: open merged_records;

Line 4348: 'OKL_EXT_SELL_INVS_B',

4344: LAST_UPDATE_LOGIN,
4345: LAST_UPDATE_DATE,
4346: LAST_UPDATED_BY
4347: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
4348: 'OKL_EXT_SELL_INVS_B',
4349: MERGE_HEADER_ID_LIST(I),
4350: PRIMARY_KEY_ID_LIST(I),
4351: NUM_COL1_ORIG_LIST(I),
4352: NUM_COL1_NEW_LIST(I),

Line 4366: UPDATE OKL_EXT_SELL_INVS_B yt SET

4362: );
4363:
4364: END IF;
4365: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4366: UPDATE OKL_EXT_SELL_INVS_B yt SET
4367: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
4368: ,CUSTOMER_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
4369: , LAST_UPDATE_DATE=SYSDATE
4370: , last_updated_by=arp_standard.profile.user_id