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_COPY_ASSET_PVT dependencies on OKL_TXL_ASSETS_V

Line 155: FUNCTION generate_asset_number(p_old_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

151: RETURN x_return_status;
152: END generate_instance_number_ib;
153: ---------------------------------------------------------------------------------------------------------------
154: /*
155: FUNCTION generate_asset_number(p_old_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
156: x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
157: RETURN VARCHAR2 IS
158: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
159: -- cursor to get sequence number for asset number

Line 156: x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)

152: END generate_instance_number_ib;
153: ---------------------------------------------------------------------------------------------------------------
154: /*
155: FUNCTION generate_asset_number(p_old_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
156: x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
157: RETURN VARCHAR2 IS
158: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
159: -- cursor to get sequence number for asset number
160: Cursor c_asset_no(p_old_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE) IS

Line 160: Cursor c_asset_no(p_old_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE) IS

156: x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
157: RETURN VARCHAR2 IS
158: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
159: -- cursor to get sequence number for asset number
160: Cursor c_asset_no(p_old_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE) IS
161: select p_old_asset_number||'_'||OKL_FAN_SEQ.NEXTVAL
162: FROM dual;
163: BEGIN
164: OPEN c_asset_no(p_old_asset_number);

Line 192: FUNCTION generate_asset_number(x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)

188: p_token2_value => sqlerrm);
189: RETURN x_return_status;
190: END generate_asset_number;
191: */
192: FUNCTION generate_asset_number(x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
193: RETURN VARCHAR2 IS
194: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
195: ln_dummy1 NUMBER := 0;
196: ln_dummy2 NUMBER := 0;

Line 1358: FROM Okl_Txl_Assets_V tal

1354: CURRENCY_CONVERSION_TYPE,
1355: CURRENCY_CONVERSION_RATE,
1356: CURRENCY_CONVERSION_DATE
1357: -- Multi-Currency Change
1358: FROM Okl_Txl_Assets_V tal
1359: WHERE tal.kle_id = p_kle_id;
1360: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
1361: BEGIN
1362: -- Get current database values

Line 2805: p_token1_value => 'OKL_TXL_ASSETS_V record');

2801: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2802: OKL_API.set_message(p_app_name => G_APP_NAME,
2803: p_msg_name => G_NO_MATCHING_RECORD,
2804: p_token1 => G_COL_NAME_TOKEN,
2805: p_token1_value => 'OKL_TXL_ASSETS_V record');
2806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2807: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2808: OKL_API.set_message(p_app_name => G_APP_NAME,
2809: p_msg_name => G_NO_MATCHING_RECORD,

Line 2811: p_token1_value => 'OKL_TXL_ASSETS_V record');

2807: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2808: OKL_API.set_message(p_app_name => G_APP_NAME,
2809: p_msg_name => G_NO_MATCHING_RECORD,
2810: p_token1 => G_COL_NAME_TOKEN,
2811: p_token1_value => 'OKL_TXL_ASSETS_V record');
2812: RAISE OKL_API.G_EXCEPTION_ERROR;
2813: END IF;
2814: -- Since the above get rec itiv will get the old kle_id
2815: -- w.r.t p_from cle_id(top Line).

Line 3145: p_token1_value => 'OKL_TXL_ASSETS_V record');

3141: IF get_txl_csr%NOTFOUND Then
3142: OKL_API.set_message(p_app_name => G_APP_NAME,
3143: p_msg_name => G_NO_MATCHING_RECORD,
3144: p_token1 => G_COL_NAME_TOKEN,
3145: p_token1_value => 'OKL_TXL_ASSETS_V record');
3146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3147: Else
3148: --get try id
3149: Open try_id_csr(p_try_name => 'Internal Asset Creation');

Line 4136: FROM OKL_TXL_ASSETS_V

4132: IS
4133: SELECT 1
4134: FROM DUAL
4135: WHERE EXISTS (SELECT '1'
4136: FROM OKL_TXL_ASSETS_V
4137: WHERE kle_Id = p_fa_kle_id);
4138:
4139: CURSOR c_check_iti_rec(p_ib_kle_id OKL_K_LINES_V.ID%TYPE)
4140: IS

Line 4478: p_token1_value => 'OKL_TXL_ASSETS_V.KLE_ID');

4474: IF c_check_txl_rec%NOTFOUND THEN
4475: OKL_API.set_message(p_app_name => G_APP_NAME,
4476: p_msg_name => G_NO_MATCHING_RECORD,
4477: p_token1 => G_COL_NAME_TOKEN,
4478: p_token1_value => 'OKL_TXL_ASSETS_V.KLE_ID');
4479: RAISE OKL_API.G_EXCEPTION_ERROR;
4480: END IF;
4481: FETCH c_check_txl_rec INTO ln_txl_rec;
4482: CLOSE c_check_txl_rec;