[Home] [Help]
2845: l_cre_cimv_tbl(l_cre_counter).exception_yn := 'N';
2846: l_cre_cimv_tbl(l_cre_counter).number_of_items := l_asset_addon_rec.number_of_units;
2847: l_cre_cimv_tbl(l_cre_counter).object1_id1 := l_asset_addon_rec.INV_ITEM_ID;
2848: -- assigning OKL_K_ITEMS_INVENTORY_ORG instead of ORG_ID
2849: l_cre_cimv_tbl(l_cre_counter).object1_id2 := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);
2850: l_cre_klev_tbl(l_cre_counter).manufacturer_name := l_asset_addon_rec.manufacturer_name;
2851: l_cre_klev_tbl(l_cre_counter).model_number := l_asset_addon_rec.model_number;
2852: l_cre_klev_tbl(l_cre_counter).year_of_manufacture := l_asset_addon_rec.year_manufactured;
2853:
3502: --sechawla 7-dec-09 9120203 : begin
3503: --get the corporate book from system options
3504: cursor l_corp_book_csr IS
3505: select ASST_ADD_BOOK_TYPE_CODE
3506: from OKL_system_params ;
3507: l_corp_book VARCHAR2(15);
3508: --sechawla 7-dec-09 9120203 : end
3509:
3510: --Cursor declarations
3715:
3716: --create asset line
3717: FOR l_quote_asset_rec IN c_get_asset_dtls(l_lapv_rec.quote_id) LOOP
3718: l_cimv_model_rec.object1_id1 := l_quote_asset_rec.INV_ITEM_ID;
3719: l_cimv_model_rec.object1_id2 := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID);
3720: okl_context.set_okc_org_context(p_chr_id => l_chr_id);
3721: l_clev_fin_rec.exception_yn := 'N';
3722: l_clev_fin_rec.dnz_chr_id := l_chr_id;
3723: IF l_quote_asset_rec.short_description IS NOT NULL THEN