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_ACTIVATE_IB_PVT dependencies on OKL_TRX_ASSETS

Line 184: and exists (select '1' from OKL_TRX_ASSETS

180: LAST_UPDATE_LOGIN
181: FROM OKL_TXL_ITM_INSTS iti
182: WHERE iti.kle_id = p_kle_id
183: and iti.tal_type = p_trx_type
184: and exists (select '1' from OKL_TRX_ASSETS
185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
186: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
187: and OKL_TRX_ASSETS.ID = iti.tas_id);
188:

Line 185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type

181: FROM OKL_TXL_ITM_INSTS iti
182: WHERE iti.kle_id = p_kle_id
183: and iti.tal_type = p_trx_type
184: and exists (select '1' from OKL_TRX_ASSETS
185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
186: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
187: and OKL_TRX_ASSETS.ID = iti.tas_id);
188:
189: l_iipv_rec iipv_rec_type;

Line 186: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED

182: WHERE iti.kle_id = p_kle_id
183: and iti.tal_type = p_trx_type
184: and exists (select '1' from OKL_TRX_ASSETS
185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
186: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
187: and OKL_TRX_ASSETS.ID = iti.tas_id);
188:
189: l_iipv_rec iipv_rec_type;
190: BEGIN

Line 187: and OKL_TRX_ASSETS.ID = iti.tas_id);

183: and iti.tal_type = p_trx_type
184: and exists (select '1' from OKL_TRX_ASSETS
185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type
186: and OKL_TRX_ASSETS.TSU_CODE = G_TSU_CODE_ENTERED
187: and OKL_TRX_ASSETS.ID = iti.tas_id);
188:
189: l_iipv_rec iipv_rec_type;
190: BEGIN
191: x_no_data_found := TRUE;

Line 258: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

254: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
255: l_api_name CONSTANT VARCHAR2(30) := 'update_trx_status';
256: l_api_version CONSTANT NUMBER := 1.0;
257:
258: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
259: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
260: --cursor to check existing tsu code
261: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
262: SELECT tsu_code

Line 259: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;

255: l_api_name CONSTANT VARCHAR2(30) := 'update_trx_status';
256: l_api_version CONSTANT NUMBER := 1.0;
257:
258: l_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
259: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
260: --cursor to check existing tsu code
261: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
262: SELECT tsu_code
263: FROM OKL_TRX_ASSETS

Line 263: FROM OKL_TRX_ASSETS

259: l_thpv_rec_out OKL_TRX_ASSETS_PUB.thpv_rec_type;
260: --cursor to check existing tsu code
261: CURSOR tsu_code_csr (p_tas_id IN NUMBER) is
262: SELECT tsu_code
263: FROM OKL_TRX_ASSETS
264: WHERE id = p_tas_id;
265:
266: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;
267: BEGIN

Line 266: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;

262: SELECT tsu_code
263: FROM OKL_TRX_ASSETS
264: WHERE id = p_tas_id;
265:
266: l_tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE;
267: BEGIN
268: --call start activity to set savepoint
269: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
270: p_init_msg_list,

Line 299: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

295: Raise OKL_API.G_EXCEPTION_ERROR;
296: Else
297: l_thpv_rec.id := p_tas_id;
298: l_thpv_rec.tsu_code := p_tsu_code;
299: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
300: p_api_version => p_api_version,
301: p_init_msg_list => p_init_msg_list,
302: x_return_status => x_return_status,
303: x_msg_count => x_msg_count,

Line 2451: okl_trx_assets trx,

2447: okc_k_lines_b cleb_ib,
2448: okc_line_styles_b lseb_ib,
2449: okc_statuses_b stsb,
2450: okl_txl_itm_insts iti,
2451: okl_trx_assets trx,
2452: okl_trx_types_tl ttyt
2453: where iti.kle_id = cleb_ib.id
2454: and iti.tas_id = trx.id
2455: and trx.tas_type = 'CRL'

Line 3062: okl_trx_assets tas

3058: CURSOR srl_num_new_csr(p_rbk_fin_ast_cle_id IN NUMBER,
3059: p_rbk_ib_cle_id IN NUMBER) IS
3060: SELECT serial_number
3061: FROM okl_txl_itm_insts iti,
3062: okl_trx_assets tas
3063: WHERE iti.dnz_cle_id = P_rbk_fin_ast_cle_id
3064: AND iti.kle_id = p_rbk_ib_cle_id
3065: AND iti.tal_type = G_TRX_LINE_TYPE_REBOOK
3066: AND tas.tas_type = G_TRX_LINE_TYPE_REBOOK