APPS.AHL_WORKORDER_SEARCH_PUB dependencies on AHL_OSP_UTIL_PKG

Line 72: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;

68:
69: l_bind_index NUMBER;
70: i NUMBER;
71: j NUMBER;
72: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
73: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
74: l_work_order_rec WORK_ORDER_REC_TYPE;
75:
76: BEGIN

Line 73: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

69: l_bind_index NUMBER;
70: i NUMBER;
71: j NUMBER;
72: l_search_wo_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
73: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
74: l_work_order_rec WORK_ORDER_REC_TYPE;
75:
76: BEGIN
77: SAVEPOINT Search_Work_Orders;

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

416: l_bind_index := l_bind_index + 1;
417: END IF;
418:
419: --OPEN l_search_wo_csr FOR l_query_string
420: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_search_wo_csr, l_bind_value_tbl, l_query_string);
421: i := 0;
422: j := 0;
423: LOOP
424: --Get search results