APPS.AHL_PRD_PRINT_PVT dependencies on AHL_OSP_UTIL_PKG

Line 1255: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

1251: l_api_version NUMBER := 1.0;
1252: l_workorder_tbl WORKORDER_TBL_TYPE;
1253: l_wo_count NUMBER;
1254: l_clob CLOB;
1255: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1256: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
1257: l_bind_index NUMBER;
1258: l_query_string VARCHAR2(2000);
1259: i NUMBER;

Line 1256: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;

1252: l_workorder_tbl WORKORDER_TBL_TYPE;
1253: l_wo_count NUMBER;
1254: l_clob CLOB;
1255: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
1256: l_vst_wocard_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
1257: l_bind_index NUMBER;
1258: l_query_string VARCHAR2(2000);
1259: i NUMBER;
1260: l_workorder_id NUMBER;

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

1334: END IF;
1335:
1336: fnd_file.put_line(fnd_file.log, l_query_string);
1337:
1338: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_vst_wocard_csr, l_bind_value_tbl, l_query_string);
1339:
1340: i := 1;
1341: LOOP
1342: FETCH l_vst_wocard_csr INTO l_workorder_id;