APPS.AHL_WORKORDER_SEARCH_PUB dependencies on AHL_OSP_UTIL_PKG

Line 40: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;

36:
37: l_bind_index NUMBER;
38: i NUMBER;
39: j NUMBER;
40: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
41: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
42: l_work_order_rec WORK_ORDER_REC_TYPE;
43:
44: BEGIN

Line 41: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

37: l_bind_index NUMBER;
38: i NUMBER;
39: j NUMBER;
40: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
41: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
42: l_work_order_rec WORK_ORDER_REC_TYPE;
43:
44: BEGIN
45:

Line 403: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_search_wo_csr, l_bind_value_tbl, l_query_string);

399: l_bind_index := l_bind_index + 1;
400: END IF;
401:
402: --OPEN l_search_wo_csr FOR l_query_string
403: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_search_wo_csr, l_bind_value_tbl, l_query_string);
404: i := 0;
405: j := 0;
406: LOOP
407: --Get search results