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_COPY_ASSET_PVT dependencies on OKC_K_ITEMS_V

Line 101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,

97: TYPE g_ib_id_tbl IS TABLE OF g_ib_id_rec
98: INDEX BY BINARY_INTEGER;
99:
100: TYPE g_ib_item_type IS RECORD (
101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,
102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);
103:
104: TYPE g_ib_item_tbl IS TABLE OF g_ib_item_type
105: INDEX BY BINARY_INTEGER;

Line 102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);

98: INDEX BY BINARY_INTEGER;
99:
100: TYPE g_ib_item_type IS RECORD (
101: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR,
102: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR);
103:
104: TYPE g_ib_item_tbl IS TABLE OF g_ib_item_type
105: INDEX BY BINARY_INTEGER;
106: -----------------------------------------------------------------------------------------------------------

Line 494: -- Description : validation with OKC_K_ITEMS_V

490: -------------------------------------------------------------------------------------------------
491: -- Start of Commnets
492: -- Badrinath Kuchibholta
493: -- Procedure Name : validate_items_ids
494: -- Description : validation with OKC_K_ITEMS_V
495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v
496: -- we need to get current info from FA and
497: -- populate the txl_assets table
498: -- if id1 and id2 are null then we there is already info

Line 495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v

491: -- Start of Commnets
492: -- Badrinath Kuchibholta
493: -- Procedure Name : validate_items_ids
494: -- Description : validation with OKC_K_ITEMS_V
495: -- Business Rules : If the id1 and id2 are populated in okc_k_items_v
496: -- we need to get current info from FA and
497: -- populate the txl_assets table
498: -- if id1 and id2 are null then we there is already info
499: -- in txl_assets tables and now we copy that info and

Line 509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

505: -- Version : 1.0
506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)

506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 518: FROM okc_k_items_v cim

514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
515: IS
516: SELECT object1_id1,
517: object1_id2
518: FROM okc_k_items_v cim
519: WHERE cim.cle_id = p_cle_id
520: AND cim.dnz_chr_id = p_dnz_chr_id
521: AND cim.object1_id1 IS NOT NULL
522: AND cim.object1_id2 IS NOT NULL;

Line 1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V

1778: END IF;
1779: RETURN(x_return_status);
1780: END get_try_id;
1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)

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

1780: END get_try_id;
1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,

Line 1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,

1781: --4-------------------------------------------------------------------------
1782: -- FUNCTION get_rec for: OKC_K_ITEMS_V
1783: ---------------------------------------------------------------------------
1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

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

1784: FUNCTION get_rec_cimv(p_cle_id IN OKC_K_ITEMS_V.CLE_ID%TYPE,
1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1790: SELECT CIM.ID,
1791: CIM.OBJECT_VERSION_NUMBER,
1792: CIM.CLE_ID,

Line 1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS

1785: p_dnz_chr_id IN OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE,
1786: x_cimv_rec OUT NOCOPY cimv_rec_type)
1787: RETURN VARCHAR2 IS
1788: CURSOR okc_cimv_pk_csr(p_cle_id OKC_K_ITEMS_V.CLE_ID%TYPE,
1789: p_dnz_chr_id OKC_K_ITEMS_V.DNZ_CHR_ID%TYPE) IS
1790: SELECT CIM.ID,
1791: CIM.OBJECT_VERSION_NUMBER,
1792: CIM.CLE_ID,
1793: CIM.CHR_ID,

Line 1810: FROM okc_k_items_v cim

1806: CIM.CREATION_DATE,
1807: CIM.LAST_UPDATED_BY,
1808: CIM.LAST_UPDATE_DATE,
1809: CIM.LAST_UPDATE_LOGIN
1810: FROM okc_k_items_v cim
1811: WHERE cim.dnz_chr_id = p_dnz_chr_id
1812: AND cim.cle_id = p_cle_id;
1813: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
1814: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

4096: lx_fa_klev_rec klev_rec_type;
4097:
4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;

Line 4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

4097:
4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;

Line 4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;

4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;
4106: lt_ib_item_tbl g_ib_item_tbl;

Line 4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4104: lt_ib_id_tbl g_ib_id_tbl;
4105: lt_new_ib_id_tbl g_ib_id_tbl;
4106: lt_ib_item_tbl g_ib_item_tbl;
4107: l_cimv_rec cimv_rec_type;

Line 4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

4143: WHERE EXISTS (SELECT '1'
4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4149: SELECT *
4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1

Line 4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS

4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4149: SELECT *
4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1
4152: AND id2 = p_object1_id2;

Line 4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

4164: FROM OKX_AST_BKS_V
4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4167:
4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4170: SELECT *
4171: FROM OKX_INSTALL_ITEMS_V
4172: WHERE id1 = p_object1_id1

Line 4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS

4165: WHERE id1 = p_object1_id1
4166: AND book_class = 'TAX';
4167:
4168: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4169: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4170: SELECT *
4171: FROM OKX_INSTALL_ITEMS_V
4172: WHERE id1 = p_object1_id1
4173: AND id2 = p_object1_id2;

Line 4216: OKC_K_ITEMS_V cim,

4212: IS
4213: SELECT cim.object1_id1,
4214: cim.object1_id2
4215: FROM OKC_LINE_STYLES_V lse,
4216: OKC_K_ITEMS_V cim,
4217: OKC_K_LINES_V cle
4218: WHERE cle.dnz_chr_id = p_dnz_chr_id
4219: AND cle.cle_id = p_cle_id
4220: AND cle.id = cim.cle_id

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

4879: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4880: OKL_API.set_message(p_app_name => G_APP_NAME,
4881: p_msg_name => G_NO_MATCHING_RECORD,
4882: p_token1 => G_COL_NAME_TOKEN,
4883: p_token1_value => 'OKC_K_ITEMS_V record');
4884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4885: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4886: OKL_API.set_message(p_app_name => G_APP_NAME,
4887: p_msg_name => G_NO_MATCHING_RECORD,

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

4885: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4886: OKL_API.set_message(p_app_name => G_APP_NAME,
4887: p_msg_name => G_NO_MATCHING_RECORD,
4888: p_token1 => G_COL_NAME_TOKEN,
4889: p_token1_value => 'OKC_K_ITEMS_V record');
4890: RAISE OKL_API.G_EXCEPTION_ERROR;
4891: END IF;
4892: IF l_cimv_rec.cle_id <> lx_txlv_rec.kle_id THEN
4893: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 4896: p_token1_value => 'OKC_K_ITEMS_V.CLE_ID');

4892: IF l_cimv_rec.cle_id <> lx_txlv_rec.kle_id THEN
4893: OKL_API.set_message(p_app_name => G_APP_NAME,
4894: p_msg_name => G_NO_MATCHING_RECORD,
4895: p_token1 => G_COL_NAME_TOKEN,
4896: p_token1_value => 'OKC_K_ITEMS_V.CLE_ID');
4897: RAISE OKL_API.G_EXCEPTION_ERROR;
4898: END IF;
4899: IF l_cimv_rec.dnz_chr_id <> p_to_chr_id THEN
4900: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 4903: p_token1_value => 'OKC_K_ITEMS_V.DNZ_CHR_ID');

4899: IF l_cimv_rec.dnz_chr_id <> p_to_chr_id THEN
4900: OKL_API.set_message(p_app_name => G_APP_NAME,
4901: p_msg_name => G_NO_MATCHING_RECORD,
4902: p_token1 => G_COL_NAME_TOKEN,
4903: p_token1_value => 'OKC_K_ITEMS_V.DNZ_CHR_ID');
4904: RAISE OKL_API.G_EXCEPTION_ERROR;
4905: END IF;
4906: l_cimv_rec.object1_id1 := null;
4907: l_cimv_rec.object1_id2 := null;

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

5208: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5209: OKL_API.set_message(p_app_name => G_APP_NAME,
5210: p_msg_name => G_NO_MATCHING_RECORD,
5211: p_token1 => G_COL_NAME_TOKEN,
5212: p_token1_value => 'OKC_K_ITEMS_V record');
5213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5214: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5215: OKL_API.set_message(p_app_name => G_APP_NAME,
5216: p_msg_name => G_NO_MATCHING_RECORD,

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

5214: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5215: OKL_API.set_message(p_app_name => G_APP_NAME,
5216: p_msg_name => G_NO_MATCHING_RECORD,
5217: p_token1 => G_COL_NAME_TOKEN,
5218: p_token1_value => 'OKC_K_ITEMS_V record');
5219: RAISE OKL_API.G_EXCEPTION_ERROR;
5220: END IF;
5221: IF l_cimv_rec.cle_id <> lx_itiv_rec.kle_id THEN
5222: OKL_API.set_message(p_app_name => G_APP_NAME,