APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_TRX_AR_INVOICES_B

Line 1408: --OKL_TRX_AR_INVOICES_B stores reference to Customer Account Site Use in column IBT_ID

1404: fnd_file.put_line(fnd_file.log, 'Okl_Tai_Pvt.OKL_TAI_PARTY_MERGE');
1405: arp_message.set_line('Okl_Tai_Pvt.OKL_TAI_PARTY_MERGE()+');
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407:
1408: --OKL_TRX_AR_INVOICES_B stores reference to Customer Account Site Use in column IBT_ID
1409: --Account Merge logic is moved to TAI_ACCOUNT_MERGE API which is called during
1410: --Account Merge process
1411:
1412: exception

Line 4951: | Account merge procedure for the table, OKL_TRX_AR_INVOICES_B

4947: /*-------------------------------------------------------------
4948: | PROCEDURE
4949: | TAI_ACCOUNT_MERGE
4950: | DESCRIPTION :
4951: | Account merge procedure for the table, OKL_TRX_AR_INVOICES_B
4952: |
4953: | NOTES:
4954: |--------------------------------------------------------------*/
4955: PROCEDURE TAI_ACCOUNT_MERGE (

Line 4966: OKL_TRX_AR_INVOICES_B.ID%TYPE

4962: INDEX BY BINARY_INTEGER;
4963: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
4964:
4965: TYPE ID_LIST_TYPE IS TABLE OF
4966: OKL_TRX_AR_INVOICES_B.ID%TYPE
4967: INDEX BY BINARY_INTEGER;
4968: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4969:
4970: TYPE IBT_ID_LIST_TYPE IS TABLE OF

Line 4971: OKL_TRX_AR_INVOICES_B.IBT_ID%TYPE

4967: INDEX BY BINARY_INTEGER;
4968: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4969:
4970: TYPE IBT_ID_LIST_TYPE IS TABLE OF
4971: OKL_TRX_AR_INVOICES_B.IBT_ID%TYPE
4972: INDEX BY BINARY_INTEGER;
4973: NUM_COL1_ORIG_LIST IBT_ID_LIST_TYPE;
4974: NUM_COL1_NEW_LIST IBT_ID_LIST_TYPE;
4975:

Line 4977: OKL_TRX_AR_INVOICES_B.IXX_ID%TYPE

4973: NUM_COL1_ORIG_LIST IBT_ID_LIST_TYPE;
4974: NUM_COL1_NEW_LIST IBT_ID_LIST_TYPE;
4975:
4976: TYPE IXX_ID_LIST_TYPE IS TABLE OF
4977: OKL_TRX_AR_INVOICES_B.IXX_ID%TYPE
4978: INDEX BY BINARY_INTEGER;
4979: NUM_COL2_ORIG_LIST IXX_ID_LIST_TYPE;
4980: NUM_COL2_NEW_LIST IXX_ID_LIST_TYPE;
4981:

Line 4988: FROM OKL_TRX_AR_INVOICES_B yt, ra_customer_merges m

4984: SELECT distinct CUSTOMER_MERGE_HEADER_ID
4985: ,ID
4986: ,IBT_ID
4987: ,IXX_ID
4988: FROM OKL_TRX_AR_INVOICES_B yt, ra_customer_merges m
4989: WHERE (
4990: yt.IBT_ID = m.DUPLICATE_SITE_ID
4991: OR yt.IXX_ID = m.DUPLICATE_ID
4992: ) AND m.process_flag = 'N'

Line 5003: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TRX_AR_INVOICES_B',FALSE);

4999: IF process_mode='LOCK' THEN
5000: NULL;
5001: ELSE
5002: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5003: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TRX_AR_INVOICES_B',FALSE);
5004: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5005: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5006:
5007: open merged_records;

Line 5044: 'OKL_TRX_AR_INVOICES_B',

5040: LAST_UPDATE_LOGIN,
5041: LAST_UPDATE_DATE,
5042: LAST_UPDATED_BY
5043: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5044: 'OKL_TRX_AR_INVOICES_B',
5045: MERGE_HEADER_ID_LIST(I),
5046: PRIMARY_KEY_ID_LIST(I),
5047: NUM_COL1_ORIG_LIST(I),
5048: NUM_COL1_NEW_LIST(I),

Line 5062: UPDATE OKL_TRX_AR_INVOICES_B yt SET

5058: );
5059:
5060: END IF;
5061: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5062: UPDATE OKL_TRX_AR_INVOICES_B yt SET
5063: IBT_ID=NUM_COL1_NEW_LIST(I)
5064: ,IXX_ID=NUM_COL2_NEW_LIST(I)
5065: , LAST_UPDATE_DATE=SYSDATE
5066: , last_updated_by=arp_standard.profile.user_id