eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_TAX_SOURCES

Line 2050: -- Description : Updating the table: OKL_TAX_SOURCES for column:

2046:
2047: ------------------------------------------------------------------------------
2048: -- Start of comments
2049: -- Procedure Name : TXS_BILL_TO_PARTY_MERGE
2050: -- Description : Updating the table: OKL_TAX_SOURCES for column:
2051: -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2052: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
2053: -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2054: -- Parameters :

Line 2052: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES

2048: -- Start of comments
2049: -- Procedure Name : TXS_BILL_TO_PARTY_MERGE
2050: -- Description : Updating the table: OKL_TAX_SOURCES for column:
2051: -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2052: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
2053: -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2054: -- Parameters :
2055: -- Version : 1.0
2056: -- End of comments

Line 2115: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);

2111: -- not transfer and return the id of the duplicate record as the Merged To Id
2112: if p_from_fk_id <> p_to_fk_id then
2113: begin
2114: arp_message.set_name('AR','AR_UPDATING_TABLE');
2115: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2116:
2117: IF p_parent_entity_name = 'HZ_PARTIES'
2118: THEN
2119: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_ID

Line 2119: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_ID

2115: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2116:
2117: IF p_parent_entity_name = 'HZ_PARTIES'
2118: THEN
2119: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_ID
2120: UPDATE OKL_TAX_SOURCES TAB
2121: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2122: , TAB.object_version_number = TAB.object_version_number + 1
2123: , TAB.last_update_date = SYSDATE

Line 2120: UPDATE OKL_TAX_SOURCES TAB

2116:
2117: IF p_parent_entity_name = 'HZ_PARTIES'
2118: THEN
2119: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_ID
2120: UPDATE OKL_TAX_SOURCES TAB
2121: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2122: , TAB.object_version_number = TAB.object_version_number + 1
2123: , TAB.last_update_date = SYSDATE
2124: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2129: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_SITE_ID

2125: , TAB.last_update_login = arp_standard.profile.last_update_login
2126: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2128: THEN
2129: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_SITE_ID
2130: UPDATE OKL_TAX_SOURCES TAB
2131: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2132: , TAB.object_version_number = TAB.object_version_number + 1
2133: , TAB.last_update_date = SYSDATE

Line 2130: UPDATE OKL_TAX_SOURCES TAB

2126: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2128: THEN
2129: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_SITE_ID
2130: UPDATE OKL_TAX_SOURCES TAB
2131: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2132: , TAB.object_version_number = TAB.object_version_number + 1
2133: , TAB.last_update_date = SYSDATE
2134: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2147: 'OKL_TAX_SOURCES for = '|| p_from_id));

2143: exception
2144: when others then
2145: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2146: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2147: 'OKL_TAX_SOURCES for = '|| p_from_id));
2148: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2149: x_return_status := FND_API.G_RET_STS_ERROR;
2150: end;
2151: end if;

Line 2157: -- Description : Updating the table: OKL_TAX_SOURCES for column:

2153:
2154: ------------------------------------------------------------------------------
2155: -- Start of comments
2156: -- Procedure Name : TXS_SHIP_TO_PARTY_MERGE
2157: -- Description : Updating the table: OKL_TAX_SOURCES for column:
2158: -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2159: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
2160: -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2161: -- Parameters :

Line 2159: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES

2155: -- Start of comments
2156: -- Procedure Name : TXS_SHIP_TO_PARTY_MERGE
2157: -- Description : Updating the table: OKL_TAX_SOURCES for column:
2158: -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2159: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES
2160: -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2161: -- Parameters :
2162: -- Version : 1.0
2163: -- End of comments

Line 2224: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);

2220:
2221: if p_from_fk_id <> p_to_fk_id then
2222: begin
2223: arp_message.set_name('AR','AR_UPDATING_TABLE');
2224: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2225:
2226: IF p_parent_entity_name = 'HZ_PARTIES'
2227: THEN
2228: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_ID

Line 2228: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_ID

2224: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2225:
2226: IF p_parent_entity_name = 'HZ_PARTIES'
2227: THEN
2228: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_ID
2229: UPDATE OKL_TAX_SOURCES TAB
2230: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2231: , TAB.object_version_number = TAB.object_version_number + 1
2232: , TAB.last_update_date = SYSDATE

Line 2229: UPDATE OKL_TAX_SOURCES TAB

2225:
2226: IF p_parent_entity_name = 'HZ_PARTIES'
2227: THEN
2228: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_ID
2229: UPDATE OKL_TAX_SOURCES TAB
2230: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2231: , TAB.object_version_number = TAB.object_version_number + 1
2232: , TAB.last_update_date = SYSDATE
2233: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2238: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_SITE_ID

2234: , TAB.last_update_login = arp_standard.profile.last_update_login
2235: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2237: THEN
2238: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_SITE_ID
2239: UPDATE OKL_TAX_SOURCES TAB
2240: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2241: , TAB.object_version_number = TAB.object_version_number + 1
2242: , TAB.last_update_date = SYSDATE

Line 2239: UPDATE OKL_TAX_SOURCES TAB

2235: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2237: THEN
2238: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_SITE_ID
2239: UPDATE OKL_TAX_SOURCES TAB
2240: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2241: , TAB.object_version_number = TAB.object_version_number + 1
2242: , TAB.last_update_date = SYSDATE
2243: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2266: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:

2262:
2263: ------------------------------------------------------------------------------
2264: -- Start of comments
2265: -- Procedure Name : TXST_BILL_TO_PARTY_MERGE
2266: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
2267: -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2268: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
2269: -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2270: -- Parameters :

Line 2268: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T

2264: -- Start of comments
2265: -- Procedure Name : TXST_BILL_TO_PARTY_MERGE
2266: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
2267: -- BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2268: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
2269: -- and col: BILL_TO_PARTY_ID and BILL_TO_PARTY_SITE_ID
2270: -- Parameters :
2271: -- Version : 1.0
2272: -- End of comments

Line 2334: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);

2330:
2331: if p_from_fk_id <> p_to_fk_id then
2332: begin
2333: arp_message.set_name('AR','AR_UPDATING_TABLE');
2334: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2335:
2336: IF p_parent_entity_name = 'HZ_PARTIES'
2337: THEN
2338: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_ID

Line 2338: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_ID

2334: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2335:
2336: IF p_parent_entity_name = 'HZ_PARTIES'
2337: THEN
2338: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_ID
2339: UPDATE OKL_TAX_SOURCES_T TAB
2340: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2341: , TAB.object_version_number = TAB.object_version_number + 1
2342: , TAB.last_update_date = SYSDATE

Line 2339: UPDATE OKL_TAX_SOURCES_T TAB

2335:
2336: IF p_parent_entity_name = 'HZ_PARTIES'
2337: THEN
2338: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_ID
2339: UPDATE OKL_TAX_SOURCES_T TAB
2340: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id
2341: , TAB.object_version_number = TAB.object_version_number + 1
2342: , TAB.last_update_date = SYSDATE
2343: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2348: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_SITE_ID

2344: , TAB.last_update_login = arp_standard.profile.last_update_login
2345: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2347: THEN
2348: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_SITE_ID
2349: UPDATE OKL_TAX_SOURCES_T TAB
2350: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2351: , TAB.object_version_number = TAB.object_version_number + 1
2352: , TAB.last_update_date = SYSDATE

Line 2349: UPDATE OKL_TAX_SOURCES_T TAB

2345: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2347: THEN
2348: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_SITE_ID
2349: UPDATE OKL_TAX_SOURCES_T TAB
2350: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id
2351: , TAB.object_version_number = TAB.object_version_number + 1
2352: , TAB.last_update_date = SYSDATE
2353: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2376: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:

2372:
2373: ------------------------------------------------------------------------------
2374: -- Start of comments
2375: -- Procedure Name : TXST_SHIP_TO_PARTY_MERGE
2376: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
2377: -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2378: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
2379: -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2380: -- Parameters :

Line 2378: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T

2374: -- Start of comments
2375: -- Procedure Name : TXST_SHIP_TO_PARTY_MERGE
2376: -- Description : Updating the table: OKL_TAX_SOURCES_T for column:
2377: -- SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2378: -- Business Rules : performing PARTY MERGE for table: OKL_TAX_SOURCES_T
2379: -- and col: SHIP_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID
2380: -- Parameters :
2381: -- Version : 1.0
2382: -- End of comments

Line 2443: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);

2439:
2440: if p_from_fk_id <> p_to_fk_id then
2441: begin
2442: arp_message.set_name('AR','AR_UPDATING_TABLE');
2443: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2444:
2445: IF p_parent_entity_name = 'HZ_PARTIES'
2446: THEN
2447: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_ID

Line 2447: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_ID

2443: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2444:
2445: IF p_parent_entity_name = 'HZ_PARTIES'
2446: THEN
2447: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_ID
2448: UPDATE OKL_TAX_SOURCES_T TAB
2449: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2450: , TAB.object_version_number = TAB.object_version_number + 1
2451: , TAB.last_update_date = SYSDATE

Line 2448: UPDATE OKL_TAX_SOURCES_T TAB

2444:
2445: IF p_parent_entity_name = 'HZ_PARTIES'
2446: THEN
2447: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_ID
2448: UPDATE OKL_TAX_SOURCES_T TAB
2449: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id
2450: , TAB.object_version_number = TAB.object_version_number + 1
2451: , TAB.last_update_date = SYSDATE
2452: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2457: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_SITE_ID

2453: , TAB.last_update_login = arp_standard.profile.last_update_login
2454: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2456: THEN
2457: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_SITE_ID
2458: UPDATE OKL_TAX_SOURCES_T TAB
2459: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2460: , TAB.object_version_number = TAB.object_version_number + 1
2461: , TAB.last_update_date = SYSDATE

Line 2458: UPDATE OKL_TAX_SOURCES_T TAB

2454: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2456: THEN
2457: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_SITE_ID
2458: UPDATE OKL_TAX_SOURCES_T TAB
2459: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id
2460: , TAB.object_version_number = TAB.object_version_number + 1
2461: , TAB.last_update_date = SYSDATE
2462: , TAB.last_updated_by = arp_standard.profile.user_id

Line 4397: | Account merge procedure for the table, OKL_TAX_SOURCES_T

4393: /*-------------------------------------------------------------
4394: | PROCEDURE
4395: | TXST_ACCOUNT_MERGE
4396: | DESCRIPTION :
4397: | Account merge procedure for the table, OKL_TAX_SOURCES_T
4398: |
4399: | NOTES:
4400: |--------------------------------------------------------------*/
4401: PROCEDURE TXST_ACCOUNT_MERGE (

Line 4412: OKL_TAX_SOURCES_T.ID%TYPE

4408: INDEX BY BINARY_INTEGER;
4409: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
4410:
4411: TYPE ID_LIST_TYPE IS TABLE OF
4412: OKL_TAX_SOURCES_T.ID%TYPE
4413: INDEX BY BINARY_INTEGER;
4414: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4415:
4416: TYPE BILL_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF

Line 4417: OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_ID%TYPE

4413: INDEX BY BINARY_INTEGER;
4414: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4415:
4416: TYPE BILL_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
4417: OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_ID%TYPE
4418: INDEX BY BINARY_INTEGER;
4419: NUM_COL1_ORIG_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4420: NUM_COL1_NEW_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4421:

Line 4423: OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE

4419: NUM_COL1_ORIG_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4420: NUM_COL1_NEW_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4421:
4422: TYPE BT_CA_SU_ID_LIST_TYPE IS TABLE OF
4423: OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE
4424: INDEX BY BINARY_INTEGER;
4425: NUM_COL2_ORIG_LIST BT_CA_SU_ID_LIST_TYPE;
4426: NUM_COL2_NEW_LIST BT_CA_SU_ID_LIST_TYPE;
4427:

Line 4429: OKL_TAX_SOURCES_T.SHIP_TO_CUST_ACCT_SITE_USE_ID%TYPE

4425: NUM_COL2_ORIG_LIST BT_CA_SU_ID_LIST_TYPE;
4426: NUM_COL2_NEW_LIST BT_CA_SU_ID_LIST_TYPE;
4427:
4428: TYPE ST_CA_SU_ID_LIST_TYPE IS TABLE OF
4429: OKL_TAX_SOURCES_T.SHIP_TO_CUST_ACCT_SITE_USE_ID%TYPE
4430: INDEX BY BINARY_INTEGER;
4431: NUM_COL3_ORIG_LIST ST_CA_SU_ID_LIST_TYPE;
4432: NUM_COL3_NEW_LIST ST_CA_SU_ID_LIST_TYPE;
4433:

Line 4434: TYPE ST_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_PARTY_ID%TYPE

4430: INDEX BY BINARY_INTEGER;
4431: NUM_COL3_ORIG_LIST ST_CA_SU_ID_LIST_TYPE;
4432: NUM_COL3_NEW_LIST ST_CA_SU_ID_LIST_TYPE;
4433:
4434: TYPE ST_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_PARTY_ID%TYPE
4435: INDEX BY BINARY_INTEGER;
4436: ST_PAR_ID_ORIG_LIST ST_PAR_ID_LIST_TYPE;
4437: ST_PAR_ID_NEW_LIST ST_PAR_ID_LIST_TYPE;
4438:

Line 4439: TYPE ST_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_PARTY_SITE_ID%TYPE

4435: INDEX BY BINARY_INTEGER;
4436: ST_PAR_ID_ORIG_LIST ST_PAR_ID_LIST_TYPE;
4437: ST_PAR_ID_NEW_LIST ST_PAR_ID_LIST_TYPE;
4438:
4439: TYPE ST_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_PARTY_SITE_ID%TYPE
4440: INDEX BY BINARY_INTEGER;
4441: ST_PAR_SITE_ID_ORIG_LIST ST_PAR_SITE_ID_LIST_TYPE;
4442: ST_PAR_SITE_ID_NEW_LIST ST_PAR_SITE_ID_LIST_TYPE;
4443:

Line 4444: TYPE ST_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_LOCATION_ID%TYPE

4440: INDEX BY BINARY_INTEGER;
4441: ST_PAR_SITE_ID_ORIG_LIST ST_PAR_SITE_ID_LIST_TYPE;
4442: ST_PAR_SITE_ID_NEW_LIST ST_PAR_SITE_ID_LIST_TYPE;
4443:
4444: TYPE ST_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.SHIP_TO_LOCATION_ID%TYPE
4445: INDEX BY BINARY_INTEGER;
4446: ST_LOC_ID_ORIG_LIST ST_LOC_ID_LIST_TYPE;
4447: ST_LOC_ID_NEW_LIST ST_LOC_ID_LIST_TYPE;
4448:

Line 4449: TYPE BT_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_PARTY_ID%TYPE

4445: INDEX BY BINARY_INTEGER;
4446: ST_LOC_ID_ORIG_LIST ST_LOC_ID_LIST_TYPE;
4447: ST_LOC_ID_NEW_LIST ST_LOC_ID_LIST_TYPE;
4448:
4449: TYPE BT_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_PARTY_ID%TYPE
4450: INDEX BY BINARY_INTEGER;
4451: BT_PAR_ID_ORIG_LIST BT_PAR_ID_LIST_TYPE;
4452: BT_PAR_ID_NEW_LIST BT_PAR_ID_LIST_TYPE;
4453:

Line 4454: TYPE BT_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_PARTY_SITE_ID%TYPE

4450: INDEX BY BINARY_INTEGER;
4451: BT_PAR_ID_ORIG_LIST BT_PAR_ID_LIST_TYPE;
4452: BT_PAR_ID_NEW_LIST BT_PAR_ID_LIST_TYPE;
4453:
4454: TYPE BT_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_PARTY_SITE_ID%TYPE
4455: INDEX BY BINARY_INTEGER;
4456: BT_PAR_SITE_ID_ORIG_LIST BT_PAR_SITE_ID_LIST_TYPE;
4457: BT_PAR_SITE_ID_NEW_LIST BT_PAR_SITE_ID_LIST_TYPE;
4458:

Line 4459: TYPE BT_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_LOCATION_ID%TYPE

4455: INDEX BY BINARY_INTEGER;
4456: BT_PAR_SITE_ID_ORIG_LIST BT_PAR_SITE_ID_LIST_TYPE;
4457: BT_PAR_SITE_ID_NEW_LIST BT_PAR_SITE_ID_LIST_TYPE;
4458:
4459: TYPE BT_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES_T.BILL_TO_LOCATION_ID%TYPE
4460: INDEX BY BINARY_INTEGER;
4461: BT_LOC_ID_ORIG_LIST BT_LOC_ID_LIST_TYPE;
4462: BT_LOC_ID_NEW_LIST BT_LOC_ID_LIST_TYPE;
4463:

Line 4471: FROM OKL_TAX_SOURCES_T yt, ra_customer_merges m

4467: ,ID
4468: ,BILL_TO_CUST_ACCT_ID
4469: ,BILL_TO_CUST_ACCT_SITE_USE_ID
4470: ,SHIP_TO_CUST_ACCT_SITE_USE_ID
4471: FROM OKL_TAX_SOURCES_T yt, ra_customer_merges m
4472: WHERE (
4473: yt.BILL_TO_CUST_ACCT_ID = m.DUPLICATE_ID
4474: OR yt.BILL_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4475: OR yt.SHIP_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID

Line 4488: FROM OKL_TAX_SOURCES_T

4484: , BILL_TO_LOCATION_ID
4485: , SHIP_TO_PARTY_ID
4486: , SHIP_TO_PARTY_SITE_ID
4487: , SHIP_TO_LOCATION_ID
4488: FROM OKL_TAX_SOURCES_T
4489: WHERE id = l_tax_src_id;
4490:
4491: CURSOR bt_st_dtls_csr(l_site_use_id NUMBER)
4492: IS

Line 4511: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);

4507: IF process_mode='LOCK' THEN
4508: NULL;
4509: ELSE
4510: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4511: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
4512: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4513: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4514:
4515: open merged_records;

Line 4592: 'OKL_TAX_SOURCES_T',

4588: LAST_UPDATE_LOGIN,
4589: LAST_UPDATE_DATE,
4590: LAST_UPDATED_BY
4591: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
4592: 'OKL_TAX_SOURCES_T',
4593: MERGE_HEADER_ID_LIST(I),
4594: PRIMARY_KEY_ID_LIST(I),
4595: NUM_COL1_ORIG_LIST(I),
4596: NUM_COL1_NEW_LIST(I),

Line 4624: UPDATE OKL_TAX_SOURCES_T yt SET

4620: );
4621:
4622: END IF;
4623: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4624: UPDATE OKL_TAX_SOURCES_T yt SET
4625: BILL_TO_CUST_ACCT_ID=NUM_COL1_NEW_LIST(I)
4626: , BILL_TO_CUST_ACCT_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
4627: , SHIP_TO_CUST_ACCT_SITE_USE_ID=NUM_COL3_NEW_LIST(I)
4628: , BILL_TO_PARTY_ID = BT_PAR_ID_NEW_LIST(I)

Line 4674: | Account merge procedure for the table, OKL_TAX_SOURCES

4670: /*-------------------------------------------------------------
4671: | PROCEDURE
4672: | TXS_ACCOUNT_MERGE
4673: | DESCRIPTION :
4674: | Account merge procedure for the table, OKL_TAX_SOURCES
4675: |
4676: | NOTES:
4677: |--------------------------------------------------------------*/
4678: PROCEDURE TXS_ACCOUNT_MERGE (

Line 4689: OKL_TAX_SOURCES.ID%TYPE

4685: INDEX BY BINARY_INTEGER;
4686: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
4687:
4688: TYPE ID_LIST_TYPE IS TABLE OF
4689: OKL_TAX_SOURCES.ID%TYPE
4690: INDEX BY BINARY_INTEGER;
4691: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4692:
4693: TYPE BILL_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF

Line 4694: OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_ID%TYPE

4690: INDEX BY BINARY_INTEGER;
4691: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
4692:
4693: TYPE BILL_TO_CUST_ACCT_ID_LIST_TYPE IS TABLE OF
4694: OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_ID%TYPE
4695: INDEX BY BINARY_INTEGER;
4696: NUM_COL1_ORIG_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4697: NUM_COL1_NEW_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4698:

Line 4700: OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE

4696: NUM_COL1_ORIG_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4697: NUM_COL1_NEW_LIST BILL_TO_CUST_ACCT_ID_LIST_TYPE;
4698:
4699: TYPE BT_CA_SU_ID_LIST_TYPE IS TABLE OF
4700: OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE
4701: INDEX BY BINARY_INTEGER;
4702: NUM_COL2_ORIG_LIST BT_CA_SU_ID_LIST_TYPE;
4703: NUM_COL2_NEW_LIST BT_CA_SU_ID_LIST_TYPE;
4704:

Line 4706: OKL_TAX_SOURCES.SHIP_TO_CUST_ACCT_SITE_USE_ID%TYPE

4702: NUM_COL2_ORIG_LIST BT_CA_SU_ID_LIST_TYPE;
4703: NUM_COL2_NEW_LIST BT_CA_SU_ID_LIST_TYPE;
4704:
4705: TYPE ST_CA_SU_ID_LIST_TYPE IS TABLE OF
4706: OKL_TAX_SOURCES.SHIP_TO_CUST_ACCT_SITE_USE_ID%TYPE
4707: INDEX BY BINARY_INTEGER;
4708: NUM_COL3_ORIG_LIST ST_CA_SU_ID_LIST_TYPE;
4709: NUM_COL3_NEW_LIST ST_CA_SU_ID_LIST_TYPE;
4710:

Line 4711: TYPE ST_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_PARTY_ID%TYPE

4707: INDEX BY BINARY_INTEGER;
4708: NUM_COL3_ORIG_LIST ST_CA_SU_ID_LIST_TYPE;
4709: NUM_COL3_NEW_LIST ST_CA_SU_ID_LIST_TYPE;
4710:
4711: TYPE ST_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_PARTY_ID%TYPE
4712: INDEX BY BINARY_INTEGER;
4713: ST_PAR_ID_ORIG_LIST ST_PAR_ID_LIST_TYPE;
4714: ST_PAR_ID_NEW_LIST ST_PAR_ID_LIST_TYPE;
4715:

Line 4716: TYPE ST_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_PARTY_SITE_ID%TYPE

4712: INDEX BY BINARY_INTEGER;
4713: ST_PAR_ID_ORIG_LIST ST_PAR_ID_LIST_TYPE;
4714: ST_PAR_ID_NEW_LIST ST_PAR_ID_LIST_TYPE;
4715:
4716: TYPE ST_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_PARTY_SITE_ID%TYPE
4717: INDEX BY BINARY_INTEGER;
4718: ST_PAR_SITE_ID_ORIG_LIST ST_PAR_SITE_ID_LIST_TYPE;
4719: ST_PAR_SITE_ID_NEW_LIST ST_PAR_SITE_ID_LIST_TYPE;
4720:

Line 4721: TYPE ST_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_LOCATION_ID%TYPE

4717: INDEX BY BINARY_INTEGER;
4718: ST_PAR_SITE_ID_ORIG_LIST ST_PAR_SITE_ID_LIST_TYPE;
4719: ST_PAR_SITE_ID_NEW_LIST ST_PAR_SITE_ID_LIST_TYPE;
4720:
4721: TYPE ST_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.SHIP_TO_LOCATION_ID%TYPE
4722: INDEX BY BINARY_INTEGER;
4723: ST_LOC_ID_ORIG_LIST ST_LOC_ID_LIST_TYPE;
4724: ST_LOC_ID_NEW_LIST ST_LOC_ID_LIST_TYPE;
4725:

Line 4726: TYPE BT_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_PARTY_ID%TYPE

4722: INDEX BY BINARY_INTEGER;
4723: ST_LOC_ID_ORIG_LIST ST_LOC_ID_LIST_TYPE;
4724: ST_LOC_ID_NEW_LIST ST_LOC_ID_LIST_TYPE;
4725:
4726: TYPE BT_PAR_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_PARTY_ID%TYPE
4727: INDEX BY BINARY_INTEGER;
4728: BT_PAR_ID_ORIG_LIST BT_PAR_ID_LIST_TYPE;
4729: BT_PAR_ID_NEW_LIST BT_PAR_ID_LIST_TYPE;
4730:

Line 4731: TYPE BT_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_PARTY_SITE_ID%TYPE

4727: INDEX BY BINARY_INTEGER;
4728: BT_PAR_ID_ORIG_LIST BT_PAR_ID_LIST_TYPE;
4729: BT_PAR_ID_NEW_LIST BT_PAR_ID_LIST_TYPE;
4730:
4731: TYPE BT_PAR_SITE_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_PARTY_SITE_ID%TYPE
4732: INDEX BY BINARY_INTEGER;
4733: BT_PAR_SITE_ID_ORIG_LIST BT_PAR_SITE_ID_LIST_TYPE;
4734: BT_PAR_SITE_ID_NEW_LIST BT_PAR_SITE_ID_LIST_TYPE;
4735:

Line 4736: TYPE BT_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_LOCATION_ID%TYPE

4732: INDEX BY BINARY_INTEGER;
4733: BT_PAR_SITE_ID_ORIG_LIST BT_PAR_SITE_ID_LIST_TYPE;
4734: BT_PAR_SITE_ID_NEW_LIST BT_PAR_SITE_ID_LIST_TYPE;
4735:
4736: TYPE BT_LOC_ID_LIST_TYPE IS TABLE OF OKL_TAX_SOURCES.BILL_TO_LOCATION_ID%TYPE
4737: INDEX BY BINARY_INTEGER;
4738: BT_LOC_ID_ORIG_LIST BT_LOC_ID_LIST_TYPE;
4739: BT_LOC_ID_NEW_LIST BT_LOC_ID_LIST_TYPE;
4740:

Line 4748: FROM OKL_TAX_SOURCES yt, ra_customer_merges m

4744: ,ID
4745: ,BILL_TO_CUST_ACCT_ID
4746: ,BILL_TO_CUST_ACCT_SITE_USE_ID
4747: ,SHIP_TO_CUST_ACCT_SITE_USE_ID
4748: FROM OKL_TAX_SOURCES yt, ra_customer_merges m
4749: WHERE (
4750: yt.BILL_TO_CUST_ACCT_ID = m.DUPLICATE_ID
4751: OR yt.BILL_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4752: OR yt.SHIP_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID

Line 4765: FROM OKL_TAX_SOURCES

4761: , BILL_TO_LOCATION_ID
4762: , SHIP_TO_PARTY_ID
4763: , SHIP_TO_PARTY_SITE_ID
4764: , SHIP_TO_LOCATION_ID
4765: FROM OKL_TAX_SOURCES
4766: WHERE id = l_tax_src_id;
4767:
4768: CURSOR bt_st_dtls_csr(l_site_use_id NUMBER)
4769: IS

Line 4788: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES',FALSE);

4784: IF process_mode='LOCK' THEN
4785: NULL;
4786: ELSE
4787: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4788: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
4789: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4790: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4791:
4792: open merged_records;

Line 4869: 'OKL_TAX_SOURCES',

4865: LAST_UPDATE_LOGIN,
4866: LAST_UPDATE_DATE,
4867: LAST_UPDATED_BY
4868: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
4869: 'OKL_TAX_SOURCES',
4870: MERGE_HEADER_ID_LIST(I),
4871: PRIMARY_KEY_ID_LIST(I),
4872: NUM_COL1_ORIG_LIST(I),
4873: NUM_COL1_NEW_LIST(I),

Line 4901: UPDATE OKL_TAX_SOURCES yt SET

4897: );
4898:
4899: END IF;
4900: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4901: UPDATE OKL_TAX_SOURCES yt SET
4902: BILL_TO_CUST_ACCT_ID=NUM_COL1_NEW_LIST(I)
4903: , BILL_TO_CUST_ACCT_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
4904: , SHIP_TO_CUST_ACCT_SITE_USE_ID=NUM_COL3_NEW_LIST(I)
4905: , BILL_TO_PARTY_ID = BT_PAR_ID_NEW_LIST(I)