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_ASSETS_B

Line 480: TYPE ASSET_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.ID%TYPE

476: IS
477: l_api_name VARCHAR2(30) := 'UPDATE_ASSET_LOCATION';
478: l_return_status VARCHAR2(1);
479:
480: TYPE ASSET_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.ID%TYPE
481: INDEX BY BINARY_INTEGER;
482: ASSET_ID_LIST ASSET_ID_LIST_TYPE;
483:
484: TYPE IS_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.INSTALL_SITE_ID%TYPE

Line 484: TYPE IS_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.INSTALL_SITE_ID%TYPE

480: TYPE ASSET_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.ID%TYPE
481: INDEX BY BINARY_INTEGER;
482: ASSET_ID_LIST ASSET_ID_LIST_TYPE;
483:
484: TYPE IS_ID_LIST_TYPE IS TABLE OF OKL_ASSETS_B.INSTALL_SITE_ID%TYPE
485: INDEX BY BINARY_INTEGER;
486: IS_ID_LIST IS_ID_LIST_TYPE;
487: NEW_IS_ID_LIST IS_ID_LIST_TYPE;
488:

Line 500: FROM OKL_ASSETS_B ASS

496: CURSOR LAP_ASSET_CSR(l_lap_id NUMBER) IS
497: SELECT ASS.ID ASSET_ID
498: , ASS.INSTALL_SITE_ID
499: , HPS.PARTY_SITE_ID
500: FROM OKL_ASSETS_B ASS
501: , OKL_LEASE_QUOTES_B LSQ
502: , OKL_LEASE_APPLICATIONS_B LAP
503: , HZ_PARTY_SITE_USES HPSU
504: , HZ_PARTY_SITES HPS

Line 517: FROM OKL_ASSETS_B ASS

513: CURSOR LOP_ASSET_CSR(l_lop_id NUMBER) IS
514: SELECT ASS.ID ASSET_ID
515: , ASS.INSTALL_SITE_ID
516: , HPS.PARTY_SITE_ID
517: FROM OKL_ASSETS_B ASS
518: , OKL_LEASE_QUOTES_B LSQ
519: , OKL_LEASE_OPPORTUNITIES_B LOP
520: , HZ_PARTY_SITE_USES HPSU
521: , HZ_PARTY_SITES HPS

Line 693: 'OKL_ASSETS_B',

689: LAST_UPDATE_DATE,
690: LAST_UPDATED_BY
691: )VALUES(
692: HZ_CUSTOMER_MERGE_LOG_S.nextval,
693: 'OKL_ASSETS_B',
694: p_merge_header_id,
695: ASSET_ID_LIST(I),
696: IS_ID_LIST(I),
697: NEW_IS_ID_LIST(I),

Line 708: UPDATE OKL_ASSETS_B SET

704: hz_utility_pub.LAST_UPDATED_BY);
705: END IF;
706:
707: FORALL I IN 1..ASSET_ID_LIST.COUNT
708: UPDATE OKL_ASSETS_B SET
709: INSTALL_SITE_ID = NEW_IS_ID_LIST(I)
710: , LAST_UPDATE_DATE = SYSDATE
711: , last_updated_by = arp_standard.profile.user_id
712: , last_update_login = arp_standard.profile.last_update_login

Line 1627: -- Description : Updating the table: OKL_ASSETS_B for column: INSTALL_SITE_ID

1623:
1624: ----------------------------------------------------------------------------------------------------------
1625: -- Start of comments
1626: -- Procedure Name : ASS_INSTALL_SITE_ID
1627: -- Description : Updating the table: OKL_ASSETS_B for column: INSTALL_SITE_ID
1628: -- Business Rules : performing PARTY MERGE for table: OKL_ASSETS_B and col: INSTALL_SITE_ID
1629: -- Parameters :
1630: -- Version : 1.0
1631: -- End of comments

Line 1628: -- Business Rules : performing PARTY MERGE for table: OKL_ASSETS_B and col: INSTALL_SITE_ID

1624: ----------------------------------------------------------------------------------------------------------
1625: -- Start of comments
1626: -- Procedure Name : ASS_INSTALL_SITE_ID
1627: -- Description : Updating the table: OKL_ASSETS_B for column: INSTALL_SITE_ID
1628: -- Business Rules : performing PARTY MERGE for table: OKL_ASSETS_B and col: INSTALL_SITE_ID
1629: -- Parameters :
1630: -- Version : 1.0
1631: -- End of comments
1632: -----------------------------------------------------------------------------------------------------------

Line 1693: arp_message.set_token('TABLE_NAME','OKL_ASSETS_B',FALSE);

1689:
1690: if p_from_fk_id <> p_to_fk_id then
1691: begin
1692: arp_message.set_name('AR','AR_UPDATING_TABLE');
1693: arp_message.set_token('TABLE_NAME','OKL_ASSETS_B',FALSE);
1694:
1695: --updating the OKL_ASSETS_B table for column references INSTALL_SITE_ID
1696:
1697: UPDATE OKL_ASSETS_B TAB

Line 1695: --updating the OKL_ASSETS_B table for column references INSTALL_SITE_ID

1691: begin
1692: arp_message.set_name('AR','AR_UPDATING_TABLE');
1693: arp_message.set_token('TABLE_NAME','OKL_ASSETS_B',FALSE);
1694:
1695: --updating the OKL_ASSETS_B table for column references INSTALL_SITE_ID
1696:
1697: UPDATE OKL_ASSETS_B TAB
1698: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1699: ,TAB.object_version_number = TAB.object_version_number + 1

Line 1697: UPDATE OKL_ASSETS_B TAB

1693: arp_message.set_token('TABLE_NAME','OKL_ASSETS_B',FALSE);
1694:
1695: --updating the OKL_ASSETS_B table for column references INSTALL_SITE_ID
1696:
1697: UPDATE OKL_ASSETS_B TAB
1698: SET TAB.INSTALL_SITE_ID = p_to_fk_id
1699: ,TAB.object_version_number = TAB.object_version_number + 1
1700: ,TAB.last_update_date = SYSDATE
1701: ,TAB.last_updated_by = arp_standard.profile.user_id

Line 1713: 'OKL_ASSETS_B for INSTALL_SITE_ID = '|| p_from_id));

1709: exception
1710: when others then
1711: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1712: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1713: 'OKL_ASSETS_B for INSTALL_SITE_ID = '|| p_from_id));
1714: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1715: x_return_status := FND_API.G_RET_STS_ERROR;
1716: end;
1717: end if;

Line 3780: --Also update the install location id in okl_assets_b for all the lease quotes

3776: ,L_MODULE
3777: ,'begin debug call UPDATE_ASSET_LOCATION');
3778: END IF;
3779:
3780: --Also update the install location id in okl_assets_b for all the lease quotes
3781: --undet this lease application.
3782: UPDATE_ASSET_LOCATION(
3783: p_init_msg_list => FND_API.G_FALSE,
3784: p_cust_acct_id => NUM_COL1_NEW_LIST(I),

Line 4110: --Also update the install location id in okl_assets_b for all the lease quotes

4106: ,L_MODULE
4107: ,'begin debug call UPDATE_ASSET_LOCATION');
4108: END IF;
4109:
4110: --Also update the install location id in okl_assets_b for all the lease quotes
4111: --undet this lease application.
4112: UPDATE_ASSET_LOCATION(
4113: p_init_msg_list => FND_API.G_FALSE,
4114: p_cust_acct_id => NUM_COL1_NEW_LIST(I),