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.

[Home] [Help]

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 1316: okc_k_items cim,

1312: FROM okc_subclass_top_line stl,
1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,
1315: okx_assets_v av,
1316: okc_k_items cim,
1317: okc_k_lines_b cle
1318: WHERE cle.dnz_chr_id = p_dnz_chr_id
1319: AND cle.id = cim.cle_id
1320: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 2478: okc_k_items cim,

2474: select fb.asset_id,
2475: fb.book_type_code
2476: from fa_books fb,
2477: fa_book_controls fbc,
2478: okc_k_items cim,
2479: okc_k_lines_b cleb_fa
2480: where fb.asset_id = cim.object1_id1
2481: and fb.book_type_code = fbc.book_type_code
2482: and fbc.book_class = 'CORPORATE'

Line 2500: okc_k_items cim_model

2496: p_chr_id in number) is
2497: select cleb_model.id model_cle_id,
2498: cim_model.number_of_items
2499: from okc_k_lines_b cleb_model,
2500: okc_k_items cim_model
2501: where cim_model.cle_id = cleb_model.id
2502: and cim_model.dnz_chr_id = p_chr_id
2503: and cleb_model.cle_id = p_cle_id
2504: and cleb_model.dnz_chr_id = p_chr_id

Line 2550: from okc_k_items UITEM ,

2546: cursor l_chk_link_usage_csr (p_source_trx_id NUMBER) IS
2547: select '!' from dual
2548: where exists (
2549: select 1
2550: from okc_k_items UITEM ,
2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,

Line 2553: okc_k_items LINK_ITEM,

2549: select 1
2550: from okc_k_items UITEM ,
2551: OKC_K_LINES_B USAGE,
2552: OKC_K_LINES_B USUB_LINE,
2553: okc_k_items LINK_ITEM,
2554: okc_k_lines_b top_line,
2555: okl_txl_cntrct_lns tcl
2556: where UITEM.dnz_chr_id=tcl.khr_id
2557: and UITEM.JTOT_OBJECT1_CODE = 'OKL_USAGE'

Line 4232: FROM okc_k_items fee_cim

4228: CURSOR fee_item_csr(p_chr_id IN NUMBER,
4229: p_cle_id IN NUMBER) IS
4230: SELECT fee_cim.id,
4231: fee_cim.object1_id1
4232: FROM okc_k_items fee_cim
4233: WHERE fee_cim.cle_id = p_cle_id
4234: AND fee_cim.dnz_chr_id = p_chr_id
4235: AND fee_cim.jtot_object1_code = 'OKL_STRMTYP';
4236:

Line 6976: FROM okc_k_items model_cim

6972:
6973: CURSOR modelline_csr(p_chr_id IN NUMBER,
6974: p_model_cle_id IN NUMBER) IS
6975: SELECT model_cim.id model_cim_id
6976: FROM okc_k_items model_cim
6977: WHERE model_cim.cle_id = p_model_cle_id
6978: AND model_cim.dnz_chr_id = p_chr_id;
6979:
6980: modelline_rec modelline_csr%ROWTYPE;

Line 8766: FROM okc_k_items

8762: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
8763: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
8764: SELECT object1_id1,
8765: object1_id2
8766: FROM okc_k_items
8767: WHERE cle_id = p_orig_cle_id
8768: AND dnz_chr_Id = p_orig_chr_id;
8769:
8770: Cursor l_asr_csr(p_rel_chr_id IN NUMBER) IS

Line 8778: OKC_K_ITEMS cim_orig,

8774: asr.id asset_return_id
8775: FROM OKL_ASSET_RETURNS_B asr,
8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,

Line 8779: OKC_K_ITEMS cim,

8775: FROM OKL_ASSET_RETURNS_B asr,
8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,
8783: OKL_TXL_ASSETS_B txl

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

8887: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8888: OKL_API.set_message(p_app_name => G_APP_NAME,
8889: p_msg_name => G_NO_MATCHING_RECORD,
8890: p_token1 => G_COL_NAME_TOKEN,
8891: p_token1_value => 'OKC_K_ITEMS_V record');
8892: x_return_status := OKL_API.G_RET_STS_ERROR;
8893: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8895: OKL_API.set_message(p_app_name => G_APP_NAME,

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

8894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8895: OKL_API.set_message(p_app_name => G_APP_NAME,
8896: p_msg_name => G_NO_MATCHING_RECORD,
8897: p_token1 => G_COL_NAME_TOKEN,
8898: p_token1_value => 'OKC_K_ITEMS_V record');
8899: x_return_status := OKL_API.G_RET_STS_ERROR;
8900: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8901: END IF;
8902: -- To get the old information of the old asset

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

8939: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8940: OKL_API.set_message(p_app_name => G_APP_NAME,
8941: p_msg_name => G_NO_MATCHING_RECORD,
8942: p_token1 => G_COL_NAME_TOKEN,
8943: p_token1_value => 'OKC_K_ITEMS_V record');
8944: x_return_status := OKL_API.G_RET_STS_ERROR;
8945: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8947: OKL_API.set_message(p_app_name => G_APP_NAME,

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

8946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8947: OKL_API.set_message(p_app_name => G_APP_NAME,
8948: p_msg_name => G_NO_MATCHING_RECORD,
8949: p_token1 => G_COL_NAME_TOKEN,
8950: p_token1_value => 'OKC_K_ITEMS_V record');
8951: x_return_status := OKL_API.G_RET_STS_ERROR;
8952: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
8953: END IF;
8954: -- To get the old information of the old asset