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_CREATE_KLE_PVT dependencies on OKL_TXL_ITM_INSTS_V

Line 160: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)

156: p_token2_value => sqlerrm);
157: RETURN x_return_status;
158: END is_duplicate_serial_number;
159: ---------------------------------------------------------------------------------------------------------------
160: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)
161: RETURN VARCHAR2 IS
162: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
163: -- cursor to get sequence number for asset number
164: Cursor c_instance_no_ib IS

Line 1232: FUNCTION get_rec_itiv(p_itiv_id IN OKL_TXL_ITM_INSTS_V.KLE_ID%TYPE,

1228: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1229: return(x_return_status);
1230: END get_txdv_tbl;
1231: -----------------------------------------------------------------------------------------------
1232: FUNCTION get_rec_itiv(p_itiv_id IN OKL_TXL_ITM_INSTS_V.KLE_ID%TYPE,
1233: x_itiv_rec OUT NOCOPY itiv_rec_type)
1234: RETURN VARCHAR2 IS
1235:
1236: CURSOR okl_itiv_pk_csr (p_kle_id IN NUMBER) IS

Line 1717: FUNCTION get_party_site_id(p_object_id1_new IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,

1713: END IF;
1714: RETURN(x_return_status);
1715: END get_rec_update_cimv;
1716: ---------------------------------------------------------------------------------------------------------
1717: FUNCTION get_party_site_id(p_object_id1_new IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1718: x_object_id1_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1719: x_object_id2_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE)
1720: RETURN VARCHAR2 IS
1721: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 1718: x_object_id1_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,

1714: RETURN(x_return_status);
1715: END get_rec_update_cimv;
1716: ---------------------------------------------------------------------------------------------------------
1717: FUNCTION get_party_site_id(p_object_id1_new IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1718: x_object_id1_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1719: x_object_id2_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE)
1720: RETURN VARCHAR2 IS
1721: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1722:

Line 1719: x_object_id2_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE)

1715: END get_rec_update_cimv;
1716: ---------------------------------------------------------------------------------------------------------
1717: FUNCTION get_party_site_id(p_object_id1_new IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1718: x_object_id1_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
1719: x_object_id2_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE)
1720: RETURN VARCHAR2 IS
1721: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1722:
1723: CURSOR c_get_id1_id2(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) IS

Line 1723: CURSOR c_get_id1_id2(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) IS

1719: x_object_id2_new OUT NOCOPY OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE)
1720: RETURN VARCHAR2 IS
1721: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1722:
1723: CURSOR c_get_id1_id2(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) IS
1724: SELECT id1
1725: ,id2
1726: FROM OKX_PARTY_SITE_USES_V
1727: WHERE id1 = p_id1

Line 3536: p_ib_loc1 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,

3532: p_ast_no IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3533: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3534: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3535: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,
3536: p_ib_loc1 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
3537: p_ib_loc2 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE,
3538: p_fa_loc IN OKL_TXL_ASSETS_B.FA_LOCATION_ID%TYPE,
3539: p_refinance_amount IN OKL_K_LINES.REFINANCE_AMOUNT%TYPE,
3540: p_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

Line 3537: p_ib_loc2 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE,

3533: p_ast_desc IN OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE,
3534: p_cost IN OKL_TXL_ASSETS_B.ORIGINAL_COST%TYPE,
3535: p_units IN OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE,
3536: p_ib_loc1 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
3537: p_ib_loc2 IN OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE,
3538: p_fa_loc IN OKL_TXL_ASSETS_B.FA_LOCATION_ID%TYPE,
3539: p_refinance_amount IN OKL_K_LINES.REFINANCE_AMOUNT%TYPE,
3540: p_chr_id IN OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3541: RETURN VARCHAR2 IS

Line 3790: -- Description : validation with OKL_TXL_ITM_INSTS_V

3786: --------------------------------------------------------------------------------------------------
3787: -- Start of Commnets
3788: -- Badrinath Kuchibholta
3789: -- Procedure Name : validate_iti_kle_id
3790: -- Description : validation with OKL_TXL_ITM_INSTS_V
3791: -- Business Rules :
3792: -- Parameters :
3793: -- Version : 1.0
3794: -- End of Commnets

Line 3800: CURSOR c_iti_kle_id_validate(p_kle_id OKL_TXL_ITM_INSTS_V.KLE_ID%TYPE) IS

3796: PROCEDURE validate_iti_kle_id(p_klev_rec IN klev_rec_type,
3797: x_record_exists OUT NOCOPY VARCHAR2,
3798: x_return_status OUT NOCOPY VARCHAR2) IS
3799: ln_dummy NUMBER := 0;
3800: CURSOR c_iti_kle_id_validate(p_kle_id OKL_TXL_ITM_INSTS_V.KLE_ID%TYPE) IS
3801: SELECT 1
3802: --FROM dual
3803: --WHERE EXISTS (SELECT '1'
3804: FROM OKL_TXL_ITM_INSTS_V

Line 3804: FROM OKL_TXL_ITM_INSTS_V

3800: CURSOR c_iti_kle_id_validate(p_kle_id OKL_TXL_ITM_INSTS_V.KLE_ID%TYPE) IS
3801: SELECT 1
3802: --FROM dual
3803: --WHERE EXISTS (SELECT '1'
3804: FROM OKL_TXL_ITM_INSTS_V
3805: WHERE kle_id = p_kle_id; --);
3806: BEGIN
3807: -- initialize return status
3808: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3816: p_token1_value => 'OKL_TXL_ITM_INSTS_V.KLE_ID');

3812: -- store SQL error message on message stack
3813: OKL_API.set_message(p_app_name => G_APP_NAME,
3814: p_msg_name => G_REQUIRED_VALUE,
3815: p_token1 => G_COL_NAME_TOKEN,
3816: p_token1_value => 'OKL_TXL_ITM_INSTS_V.KLE_ID');
3817: -- halt validation as it is a required field
3818: RAISE G_EXCEPTION_STOP_VALIDATION;
3819: END IF;
3820: -- Enforce Foreign Key

Line 15204: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;

15200: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
15201: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15202: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15203: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15204: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15205: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15206: ln_dummy NUMBER := 0;
15207: ln_dummy1 NUMBER := 0;
15208: i NUMBER := 0;

Line 16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;

16329: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
16330: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
16336: ln_dummy NUMBER := 0;
16337: ln_dummy1 NUMBER := 0;

Line 17723: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');

17719: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17720: OKL_API.set_message(p_app_name => G_APP_NAME,
17721: p_msg_name => G_FETCHING_INFO,
17722: p_token1 => G_REC_NAME_TOKEN,
17723: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');
17724: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17725: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17726: OKL_API.set_message(p_app_name => G_APP_NAME,
17727: p_msg_name => G_FETCHING_INFO,

Line 17729: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');

17725: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17726: OKL_API.set_message(p_app_name => G_APP_NAME,
17727: p_msg_name => G_FETCHING_INFO,
17728: p_token1 => G_REC_NAME_TOKEN,
17729: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');
17730: RAISE OKL_API.G_EXCEPTION_ERROR;
17731: END IF;
17732: --Build itiv ib item rec
17733: l_itiv_ib_rec.id := r_itiv_ib_rec.id;

Line 17892: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');

17888: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17889: OKL_API.set_message(p_app_name => G_APP_NAME,
17890: p_msg_name => G_FETCHING_INFO,
17891: p_token1 => G_REC_NAME_TOKEN,
17892: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');
17893: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
17894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17895: OKL_API.set_message(p_app_name => G_APP_NAME,
17896: p_msg_name => G_FETCHING_INFO,

Line 17898: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');

17894: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17895: OKL_API.set_message(p_app_name => G_APP_NAME,
17896: p_msg_name => G_FETCHING_INFO,
17897: p_token1 => G_REC_NAME_TOKEN,
17898: p_token1_value => 'OKL_TXL_ITM_INSTS_V Record');
17899: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
17900: END IF;
17901: n_itiv_ib_rec.object_id1_new := p_itiv_ib_rec.object_id1_new;
17902: n_itiv_ib_rec.object_id1_old := p_itiv_ib_rec.object_id1_new;

Line 18052: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;

18048: l_klev_ib_rec_out klev_rec_type;
18049: l_itiv_ib_tbl_out itiv_tbl_type;
18050: x_clev_ib_rec clev_rec_type;
18051: l_trxv_ib_rec_out trxv_rec_type;
18052: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
18053: j NUMBER := 0;
18054: ln_dummy NUMBER := 0;
18055: ln_dummy1 NUMBER := 0;
18056: -- rravikir added