APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_OSP_UTIL_PKG

Line 1956: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1952:
1953: l_api_name CONSTANT VARCHAR2(30) := 'Filter_records_uc_details';
1954: l_api_version CONSTANT NUMBER := 1.0;
1955:
1956: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1957: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1958: l_sql_cri_str VARCHAR2(30000);
1959: l_buffer_limit NUMBER := 500;
1960: l_uc_node_id_tbl NBR_TBL_TYPE;

Line 1957: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

1953: l_api_name CONSTANT VARCHAR2(30) := 'Filter_records_uc_details';
1954: l_api_version CONSTANT NUMBER := 1.0;
1955:
1956: l_bindvar_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1957: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
1958: l_sql_cri_str VARCHAR2(30000);
1959: l_buffer_limit NUMBER := 500;
1960: l_uc_node_id_tbl NBR_TBL_TYPE;
1961: l_current_unit_node_id NUMBER;

Line 2042: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

2038: FETCH get_count INTO l_count;
2039: CLOSE get_count;
2040:
2041: IF l_count <> 0 THEN
2042: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
2043: (
2044: p_conditions_tbl => l_bindvar_tbl,
2045: p_sql_str => l_sql_cri_str,
2046: p_x_csr => l_cur