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

Line 200: -- FUNCTION get_rec for: OKC_K_ITEMS_V

196: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
197: RETURN(x_return_status);
198: END get_tasv_rec;
199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)

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

198: END get_tasv_rec;
199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

199: ----------------------------------------------------------------------------
200: -- FUNCTION get_rec for: OKC_K_ITEMS_V
201: ---------------------------------------------------------------------------
202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

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

202: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
208: SELECT CIM.ID,
209: CIM.OBJECT_VERSION_NUMBER,
210: CIM.CLE_ID,

Line 207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

203: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
204: x_cimv_rec OUT NOCOPY cimv_rec_type)
205: RETURN VARCHAR2 IS
206: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
207: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
208: SELECT CIM.ID,
209: CIM.OBJECT_VERSION_NUMBER,
210: CIM.CLE_ID,
211: CIM.CHR_ID,

Line 228: FROM okc_k_items_v cim

224: CIM.CREATION_DATE,
225: CIM.LAST_UPDATED_BY,
226: CIM.LAST_UPDATE_DATE,
227: CIM.LAST_UPDATE_LOGIN
228: FROM okc_k_items_v cim
229: WHERE cim.dnz_chr_id = p_dnz_chr_id
230: AND cim.cle_id = p_cle_id;
231: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
232: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 2283: from okc_k_items tcim,

2279: -- Get the top fee lines which are not having any assets link attached to it
2280: CURSOR get_item_info_tls(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2281: IS
2282: select tcle.id id
2283: from okc_k_items tcim,
2284: okc_k_lines_b tcle,
2285: okc_line_styles_b lse
2286: where tcim.dnz_chr_id = p_dnz_chr_id
2287: and tcle.lse_id = lse.id

Line 2292: from okc_k_items cim,

2288: and tcim.cle_id = tcle.id
2289: and tcim.dnz_chr_id = tcle.dnz_chr_id
2290: and lse.lty_code in (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2291: and exists (select 1
2292: from okc_k_items cim,
2293: okc_k_lines_b cle
2294: where cim.dnz_chr_id = p_dnz_chr_id
2295: and cle.cle_id = tcle.id
2296: and cim.cle_id = cle.id

Line 2317: okc_k_items scim

2313: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2314: and lse.lse_type = G_TLS_TYPE
2315: and exists(select 1
2316: from okc_k_lines_b scle,
2317: okc_k_items scim
2318: where scle.id = scim.cle_id -- sub line join with item
2319: and scim.dnz_chr_id = p_dnz_chr_id
2320: and scim.dnz_chr_id = tcle.dnz_chr_id
2321: and scle.cle_id = tcle.id -- fee top line join

Line 2329: okc_k_items cim

2325: CURSOR get_item_info(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2326: IS
2327: SELECT DISTINCT(cle.id) id
2328: FROM okl_k_lines_full_v cle,
2329: okc_k_items cim
2330: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2331: AND cle.id = cim.cle_id
2332: AND cim.jtot_object1_code = 'OKX_COVASST'
2333: AND cim.object1_id1 NOT IN (SELECT cle.id

Line 2346: FROM okc_k_items cim,

2342: -- rravikir commented for bug 3504415
2343: /* CURSOR get_item_info_tls(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2344: IS
2345: SELECT cle.cle_id fee_top_line_id, cim.cle_id linked_asset_id
2346: FROM okc_k_items cim,
2347: okc_k_lines_b cle
2348: WHERE cim.dnz_chr_id = p_dnz_chr_Id
2349: AND cim.cle_id = cle.id
2350: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 2363: FROM okc_k_items cim

2359:
2360: CURSOR get_item_info(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2361: IS
2362: SELECT cim.cle_id cle_id
2363: FROM okc_k_items cim
2364: WHERE cim.dnz_chr_id = p_dnz_chr_Id
2365: AND cim.jtot_object1_code = 'OKX_COVASST'
2366: AND cim.object1_id1 not in (SELECT cle.id
2367: FROM okc_k_lines_b cle,

Line 3405: FROM okc_k_items

3401: CURSOR get_item_info(p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE,
3402: p_orig_cle_id OKC_K_LINES_B.ID%TYPE) IS
3403: SELECT object1_id1,
3404: object1_id2
3405: FROM okc_k_items
3406: WHERE cle_id = p_orig_cle_id
3407: AND dnz_chr_Id = p_orig_chr_id;
3408:
3409: -- To get the Contract number and Split contract transaction date

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

3508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3509: OKL_API.set_message(p_app_name => G_APP_NAME,
3510: p_msg_name => G_NO_MATCHING_RECORD,
3511: p_token1 => G_COL_NAME_TOKEN,
3512: p_token1_value => 'OKC_K_ITEMS_V record');
3513: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
3514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3515: OKL_API.set_message(p_app_name => G_APP_NAME,
3516: p_msg_name => G_NO_MATCHING_RECORD,

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

3514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3515: OKL_API.set_message(p_app_name => G_APP_NAME,
3516: p_msg_name => G_NO_MATCHING_RECORD,
3517: p_token1 => G_COL_NAME_TOKEN,
3518: p_token1_value => 'OKC_K_ITEMS_V record');
3519: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3520: END IF;
3521:
3522: -- To get the old information of the old asset

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

3603: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3604: OKL_API.set_message(p_app_name => G_APP_NAME,
3605: p_msg_name => G_NO_MATCHING_RECORD,
3606: p_token1 => G_COL_NAME_TOKEN,
3607: p_token1_value => 'OKC_K_ITEMS_V record');
3608: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
3609: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3610: OKL_API.set_message(p_app_name => G_APP_NAME,
3611: p_msg_name => G_NO_MATCHING_RECORD,

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

3609: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3610: OKL_API.set_message(p_app_name => G_APP_NAME,
3611: p_msg_name => G_NO_MATCHING_RECORD,
3612: p_token1 => G_COL_NAME_TOKEN,
3613: p_token1_value => 'OKC_K_ITEMS_V record');
3614: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3615: END IF;
3616: -- To get the old information of the old asset
3617: OPEN get_item_info(p_orig_chr_id => ln_orig_system_id1,