[Home] [Help]
1954:
1955: cursor c_getItemInfo (l_inventory_item_id number, l_organization_id number)
1956: is
1957: select PRIMARY_UOM_CODE uomCode, SERVICE_DURATION_PERIOD_CODE period, SERVICE_DURATION duration
1958: from MTL_SYSTEM_ITEMS_VL
1959: where inventory_item_id = l_inventory_item_id and
1960: organization_id = l_organization_id;
1961:
1962: Cursor c_find_service(c_service_ref_line_id number) is
2279: quote_line_tbl
2280: quote_line_details_tbl - pass in the correct line_index corresponding to the lines in quote_line_tbl
2281: */
2282:
2283: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2284: IF (l_uomCodeListSRV is null) THEN
2285: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2286: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2287: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2291:
2292: l_itemIdListSRVSize := l_itemIdListSRV.count;
2293: FOR j in 1..l_itemIdListSRVSize LOOP
2294:
2295: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2296: IF (l_hasQueriedItems = 'N') THEN
2297: OPEN c_getItemInfo (l_itemIdListSRV(j), l_Qte_Line_Tbl(i).organization_id);
2298: fetch c_getItemInfo into rec_itemInfo;
2299: close c_getItemInfo;
2306: l_durationListSRV(j):= rec_itemInfo.duration;
2307: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2308: IBE_Util.Debug('Quertying mtl_sytem_items_vl the first time');
2309: END IF;
2310: END IF; -- if we haven't queried mtl_system_items_vl table
2311:
2312: l_Qte_Line_Tbl(l_quoteLineSize+j).quote_header_id := p_Qte_Header_Rec.quote_header_id;
2313: l_Qte_Line_Tbl(l_quoteLineSize+j).inventory_item_id := l_itemIdListSRV(j);
2314: l_Qte_Line_Tbl(l_quoteLineSize+j).organization_id := l_Qte_Line_Tbl(i).organization_id;
7800:
7801:
7802: CURSOR c_get_svc_detail(p_svc_item_id NUMBER, p_org_id NUMBER) IS
7803: SELECT primary_uom_code, service_duration_period_code, service_duration
7804: FROM mtl_system_items
7805: WHERE inventory_item_id = p_svc_item_id and organization_id = p_org_id;
7806:
7807: BEGIN
7808: