[Home] [Help]
1973:
1974: cursor c_getItemInfo (l_inventory_item_id number, l_organization_id number)
1975: is
1976: select PRIMARY_UOM_CODE uomCode, SERVICE_DURATION_PERIOD_CODE period, SERVICE_DURATION duration
1977: from MTL_SYSTEM_ITEMS_VL
1978: where inventory_item_id = l_inventory_item_id and
1979: organization_id = l_organization_id;
1980:
1981: Cursor c_find_service(c_service_ref_line_id number) is
2298: quote_line_tbl
2299: quote_line_details_tbl - pass in the correct line_index corresponding to the lines in quote_line_tbl
2300: */
2301:
2302: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2303: IF (l_uomCodeListSRV is null) THEN
2304: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2305: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2306: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2310:
2311: l_itemIdListSRVSize := l_itemIdListSRV.count;
2312: FOR j in 1..l_itemIdListSRVSize LOOP
2313:
2314: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2315: IF (l_hasQueriedItems = 'N') THEN
2316: OPEN c_getItemInfo (l_itemIdListSRV(j), l_Qte_Line_Tbl(i).organization_id);
2317: fetch c_getItemInfo into rec_itemInfo;
2318: close c_getItemInfo;
2325: l_durationListSRV(j):= rec_itemInfo.duration;
2326: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2327: IBE_Util.Debug('Quertying mtl_sytem_items_vl the first time');
2328: END IF;
2329: END IF; -- if we haven't queried mtl_system_items_vl table
2330:
2331: l_Qte_Line_Tbl(l_quoteLineSize+j).quote_header_id := p_Qte_Header_Rec.quote_header_id;
2332: l_Qte_Line_Tbl(l_quoteLineSize+j).inventory_item_id := l_itemIdListSRV(j);
2333: l_Qte_Line_Tbl(l_quoteLineSize+j).organization_id := l_Qte_Line_Tbl(i).organization_id;
7942:
7943:
7944: CURSOR c_get_svc_detail(p_svc_item_id NUMBER, p_org_id NUMBER) IS
7945: SELECT primary_uom_code, service_duration_period_code, service_duration
7946: FROM mtl_system_items
7947: WHERE inventory_item_id = p_svc_item_id and organization_id = p_org_id;
7948:
7949: BEGIN
7950: