APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_TRX_ASSETS

Line 1485: okl_trx_assets_pub.create_trx_ass_h_def(

1481: p_token1_value => l_cntrct_number);
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: okl_trx_assets_pub.create_trx_ass_h_def(
1486: p_api_version => 1.0,
1487: p_init_msg_list => OKL_API.G_FALSE,
1488: x_return_status => x_return_status,
1489: x_msg_count => x_msg_count,

Line 3169: -- Call this process to update status (TSU_CODE) of okl_trx_assets_v with

3165: END update_mass_rbk_contract;
3166:
3167: ------------------------------------------------------------------------------
3168: -- PROCEDURE update_trx_asset
3169: -- Call this process to update status (TSU_CODE) of okl_trx_assets_v with
3170: -- p_status.
3171: -- Calls:
3172: -- Called by:
3173: ------------------------------------------------------------------------------

Line 3188: --FROM okl_trx_assets_v trx

3184: --SELECT txl.tas_id
3185: --FROM okl_txl_assets_v txl
3186: --WHERE txl.dnz_khr_id = p_chr_id
3187: --AND EXISTS (SELECT 'Y'
3188: --FROM okl_trx_assets_v trx
3189: --WHERE trx.id = txl.tas_id
3190: --AND trx.tsu_code = 'ENTERED');
3191: ---------------------------------------------------------------*/
3192: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 3194: FROM okl_trx_assets trx,

3190: --AND trx.tsu_code = 'ENTERED');
3191: ---------------------------------------------------------------*/
3192: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3193: SELECT trx.id
3194: FROM okl_trx_assets trx,
3195: okl_trx_types_tl ttyp,
3196: okl_txl_assets_b txl
3197: WHERE trx.id = txl.tas_id
3198: AND trx.try_id = ttyp.id

Line 3218: okl_trx_assets_pub.update_trx_ass_h_def(

3214: LOOP
3215: l_thpv_rec.id := trx_rec.id;
3216: l_thpv_rec.tsu_code := p_status;
3217:
3218: okl_trx_assets_pub.update_trx_ass_h_def(
3219: p_api_version => 1.0,
3220: p_init_msg_list => OKL_API.G_FALSE,
3221: x_return_status => x_return_status,
3222: x_msg_count => x_msg_count,