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_RELEASE_PVT dependencies on OKC_K_ITEMS

Line 709: -- FUNCTION get_rec for: OKC_K_ITEMS_V

705: END IF;
706: RETURN(x_return_status);
707: END get_rec_chrv;
708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)

Line 711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,

707: END get_rec_chrv;
708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

708: ----------------------------------------------------------------------------
709: -- FUNCTION get_rec for: OKC_K_ITEMS_V
710: ---------------------------------------------------------------------------
711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

Line 715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

711: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
717: SELECT CIM.ID,
718: CIM.OBJECT_VERSION_NUMBER,
719: CIM.CLE_ID,

Line 716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

712: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
713: x_cimv_rec OUT NOCOPY cimv_rec_type)
714: RETURN VARCHAR2 IS
715: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
716: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
717: SELECT CIM.ID,
718: CIM.OBJECT_VERSION_NUMBER,
719: CIM.CLE_ID,
720: CIM.CHR_ID,

Line 737: FROM okc_k_items_v cim

733: CIM.CREATION_DATE,
734: CIM.LAST_UPDATED_BY,
735: CIM.LAST_UPDATE_DATE,
736: CIM.LAST_UPDATE_LOGIN
737: FROM okc_k_items_v cim
738: WHERE cim.dnz_chr_id = p_dnz_chr_id
739: AND cim.cle_id = p_cle_id;
740: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
741: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 1295: okc_k_items cim,

1291: FROM okc_subclass_top_line stl,
1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,
1294: okx_assets_v av,
1295: okc_k_items cim,
1296: okc_k_lines_b cle
1297: WHERE cle.dnz_chr_id = p_dnz_chr_id
1298: AND cle.id = cim.cle_id
1299: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 2454: okc_k_items cim,

2450: select fb.asset_id,
2451: fb.book_type_code
2452: from fa_books fb,
2453: fa_book_controls fbc,
2454: okc_k_items cim,
2455: okc_k_lines_b cleb_fa
2456: where fb.asset_id = cim.object1_id1
2457: and fb.book_type_code = fbc.book_type_code
2458: and fbc.book_class = 'CORPORATE'

Line 2476: okc_k_items cim_model

2472: p_chr_id in number) is
2473: select cleb_model.id model_cle_id,
2474: cim_model.number_of_items
2475: from okc_k_lines_b cleb_model,
2476: okc_k_items cim_model
2477: where cim_model.cle_id = cleb_model.id
2478: and cim_model.dnz_chr_id = p_chr_id
2479: and cleb_model.cle_id = p_cle_id
2480: and cleb_model.dnz_chr_id = p_chr_id

Line 2526: from okc_k_items UITEM ,

2522: cursor l_chk_link_usage_csr (p_source_trx_id NUMBER) IS
2523: select '!' from dual
2524: where exists (
2525: select 1
2526: from okc_k_items UITEM ,
2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,

Line 2529: okc_k_items LINK_ITEM,

2525: select 1
2526: from okc_k_items UITEM ,
2527: OKC_K_LINES_B USAGE,
2528: OKC_K_LINES_B USUB_LINE,
2529: okc_k_items LINK_ITEM,
2530: okc_k_lines_b top_line,
2531: okl_txl_cntrct_lns tcl
2532: where UITEM.dnz_chr_id=tcl.khr_id
2533: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'

Line 4172: FROM okc_k_items fee_cim

4168: CURSOR fee_item_csr(p_chr_id IN NUMBER,
4169: p_cle_id IN NUMBER) IS
4170: SELECT fee_cim.id,
4171: fee_cim.object1_id1
4172: FROM okc_k_items fee_cim
4173: WHERE fee_cim.cle_id = p_cle_id
4174: AND fee_cim.dnz_chr_id = p_chr_id
4175: AND fee_cim.jtot_object1_code = 'OKL_STRMTYP';
4176:

Line 6667: FROM okc_k_items model_cim

6663:
6664: CURSOR modelline_csr(p_chr_id IN NUMBER,
6665: p_model_cle_id IN NUMBER) IS
6666: SELECT model_cim.id model_cim_id
6667: FROM okc_k_items model_cim
6668: WHERE model_cim.cle_id = p_model_cle_id
6669: AND model_cim.dnz_chr_id = p_chr_id;
6670:
6671: modelline_rec modelline_csr%ROWTYPE;

Line 8437: FROM okc_k_items

8433: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8434: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8435: SELECT object1_id1,
8436: object1_id2
8437: FROM okc_k_items
8438: WHERE cle_id = p_orig_cle_id
8439: AND dnz_chr_Id = p_orig_chr_id;
8440:
8441: Cursor l_asr_csr(p_rel_chr_id IN NUMBER) IS

Line 8449: OKC_K_ITEMS cim_orig,

8445: asr.id asset_return_id
8446: FROM OKL_ASSET_RETURNS_B asr,
8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,
8453: OKC_STATUSES_B sts,

Line 8450: OKC_K_ITEMS cim,

8446: FROM OKL_ASSET_RETURNS_B asr,
8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,
8453: OKC_STATUSES_B sts,
8454: OKL_TXL_ASSETS_B txl

Line 8562: p_token1_value => 'OKC_K_ITEMS_V record');

8558: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8559: OKL_API.set_message(p_app_name => G_APP_NAME,
8560: p_msg_name => G_NO_MATCHING_RECORD,
8561: p_token1 => G_COL_NAME_TOKEN,
8562: p_token1_value => 'OKC_K_ITEMS_V record');
8563: x_return_status := OKL_API.G_RET_STS_ERROR;
8564: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8565: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8566: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 8569: p_token1_value => 'OKC_K_ITEMS_V record');

8565: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8566: OKL_API.set_message(p_app_name => G_APP_NAME,
8567: p_msg_name => G_NO_MATCHING_RECORD,
8568: p_token1 => G_COL_NAME_TOKEN,
8569: p_token1_value => 'OKC_K_ITEMS_V record');
8570: x_return_status := OKL_API.G_RET_STS_ERROR;
8571: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8572: END IF;
8573: -- To get the old information of the old asset

Line 8614: p_token1_value => 'OKC_K_ITEMS_V record');

8610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8611: OKL_API.set_message(p_app_name => G_APP_NAME,
8612: p_msg_name => G_NO_MATCHING_RECORD,
8613: p_token1 => G_COL_NAME_TOKEN,
8614: p_token1_value => 'OKC_K_ITEMS_V record');
8615: x_return_status := OKL_API.G_RET_STS_ERROR;
8616: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8617: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8618: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 8621: p_token1_value => 'OKC_K_ITEMS_V record');

8617: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8618: OKL_API.set_message(p_app_name => G_APP_NAME,
8619: p_msg_name => G_NO_MATCHING_RECORD,
8620: p_token1 => G_COL_NAME_TOKEN,
8621: p_token1_value => 'OKC_K_ITEMS_V record');
8622: x_return_status := OKL_API.G_RET_STS_ERROR;
8623: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8624: END IF;
8625: -- To get the old information of the old asset