APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_OSP_UTIL_PKG

Line 88: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

84: l_count NUMBER;
85: i NUMBER;
86: l_cur_index NUMBER;
87:
88: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
89: l_bind_index NUMBER := 1;
90: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
91:
92:

Line 90: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

86: l_cur_index NUMBER;
87:
88: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
89: l_bind_index NUMBER := 1;
90: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
91:
92:
93: CURSOR l_department_csr(dept_id IN NUMBER, dept_code IN VARCHAR2) IS
94: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;

Line 301: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_cur, l_conditions, l_sql_string);

297: --remove this line when not test
298: --l_sql_string := l_sql_string || ' WHERE ROWNUM < 3 ';
299:
300:
301: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_cur, l_conditions, l_sql_string);
302: i := 0;
303: l_cur_index := 0;
304:
305: LOOP

Line 348: AHL_OSP_UTIL_PKG.EXEC_IMMEDIATE(l_conditions, l_count_query, x_results_count);

344: CLOSE l_cur;
345:
346:
347: BEGIN
348: AHL_OSP_UTIL_PKG.EXEC_IMMEDIATE(l_conditions, l_count_query, x_results_count);
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: x_results_count := 0;
352: END;

Line 478: l_wo_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

474: Svc_Description VARCHAR2(240);
475: Suggested_Vendor VARCHAR2(240);
476: Department VARCHAR2(10);
477:
478: l_wo_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
479: l_bind_index NUMBER := 1;
480: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
481:
482: CURSOR l_department_csr(dept_id IN NUMBER, dept_code IN VARCHAR2) IS

Line 480: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

476: Department VARCHAR2(10);
477:
478: l_wo_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
479: l_bind_index NUMBER := 1;
480: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
481:
482: CURSOR l_department_csr(dept_id IN NUMBER, dept_code IN VARCHAR2) IS
483: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;
484:

Line 619: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_wo_cur, l_conditions, l_sql_string);

615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.debug(SUBSTR(l_sql_string,1, 1000), 'SEARCH_WO: ');
617: END IF;
618:
619: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_wo_cur, l_conditions, l_sql_string);
620: i := 0;
621: l_cur_index := 0;
622: LOOP
623: FETCH l_wo_cur INTO Workorder_ID,

Line 656: AHL_OSP_UTIL_PKG.EXEC_IMMEDIATE(l_conditions, l_count_query, x_results_count);

652:
653:
654:
655: BEGIN
656: AHL_OSP_UTIL_PKG.EXEC_IMMEDIATE(l_conditions, l_count_query, x_results_count);
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: x_results_count := 0;
660: END;