APPS.AHL_PRD_PRINT_PVT dependencies on AHL_OSP_UTIL_PKG

Line 1227: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1223: l_api_version NUMBER := 1.0;
1224: l_workorder_tbl WORKORDER_TBL_TYPE;
1225: l_wo_count NUMBER;
1226: l_clob CLOB;
1227: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1228: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
1229: l_bind_index NUMBER;
1230: l_query_string VARCHAR2(2000);
1231: i NUMBER;

Line 1228: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;

1224: l_workorder_tbl WORKORDER_TBL_TYPE;
1225: l_wo_count NUMBER;
1226: l_clob CLOB;
1227: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1228: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
1229: l_bind_index NUMBER;
1230: l_query_string VARCHAR2(2000);
1231: i NUMBER;
1232: l_workorder_id NUMBER;

Line 1310: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_vst_wocard_csr, l_bind_value_tbl, l_query_string);

1306: END IF;
1307:
1308: fnd_file.put_line(fnd_file.log, l_query_string);
1309:
1310: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_vst_wocard_csr, l_bind_value_tbl, l_query_string);
1311:
1312: i := 1;
1313: LOOP
1314: FETCH l_vst_wocard_csr INTO l_workorder_id;