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 3045: -- Call this process to update status (TSU_CODE) of okl_trx_assets_v with

3041: END update_mass_rbk_contract;
3042:
3043: ------------------------------------------------------------------------------
3044: -- PROCEDURE update_trx_asset
3045: -- Call this process to update status (TSU_CODE) of okl_trx_assets_v with
3046: -- p_status.
3047: -- Calls:
3048: -- Called by:
3049: ------------------------------------------------------------------------------

Line 3064: --FROM okl_trx_assets_v trx

3060: --SELECT txl.tas_id
3061: --FROM okl_txl_assets_v txl
3062: --WHERE txl.dnz_khr_id = p_chr_id
3063: --AND EXISTS (SELECT 'Y'
3064: --FROM okl_trx_assets_v trx
3065: --WHERE trx.id = txl.tas_id
3066: --AND trx.tsu_code = 'ENTERED');
3067: ---------------------------------------------------------------*/
3068: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 3070: FROM okl_trx_assets trx,

3066: --AND trx.tsu_code = 'ENTERED');
3067: ---------------------------------------------------------------*/
3068: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3069: SELECT trx.id
3070: FROM okl_trx_assets trx,
3071: okl_trx_types_tl ttyp,
3072: okl_txl_assets_b txl
3073: WHERE trx.id = txl.tas_id
3074: AND trx.try_id = ttyp.id

Line 3094: okl_trx_assets_pub.update_trx_ass_h_def(

3090: LOOP
3091: l_thpv_rec.id := trx_rec.id;
3092: l_thpv_rec.tsu_code := p_status;
3093:
3094: okl_trx_assets_pub.update_trx_ass_h_def(
3095: p_api_version => 1.0,
3096: p_init_msg_list => OKL_API.G_FALSE,
3097: x_return_status => x_return_status,
3098: x_msg_count => x_msg_count,