APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_OSP_UTIL_PKG

Line 202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

198: l_cur_index NUMBER;
199: l_start_row NUMBER;
200: l_msg_index NUMBER;
201: l_translated_msg VARCHAR2(100);
202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
203: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
204:
205: BEGIN
206: --Initialize API return status to success

Line 203: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

199: l_start_row NUMBER;
200: l_msg_index NUMBER;
201: l_translated_msg VARCHAR2(100);
202: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
203: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
204:
205: BEGIN
206: --Initialize API return status to success
207: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

434: --dbms_output.put_line(substr(l_sql_str,255, 500));
435:
436: l_count_query := 'SELECT COUNT(*) FROM (' || l_sql_str || ')';
437: BEGIN
438: AHL_OSP_UTIL_PKG.EXEC_IMMEDIATE(l_conditions, l_count_query, x_results_count);
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: x_results_count := 0;
442: END;

Line 447: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_cur, l_conditions, l_sql_str);

443:
444: IF x_results_count > 0 THEN
445: l_sql_str := l_sql_str || ' ORDER BY DIS.disposition_id ';
446:
447: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_cur, l_conditions, l_sql_str);
448: i := 1;
449: l_cur_index := 1;
450:
451: IF p_start_row > x_results_count THEN