APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_OSP_UTIL_PKG

Line 3747: L_CUR AHL_OSP_UTIL_PKG.AHL_SEARCH_CSR;

3743: X_MSG_DATA OUT NOCOPY VARCHAR2
3744: )
3745: IS
3746:
3747: L_CUR AHL_OSP_UTIL_PKG.AHL_SEARCH_CSR;
3748: L_SQL_STRING VARCHAR2(30000) := 'SELECT distinct AWO.WORKORDER_ID,AWO.OBJECT_VERSION_NUMBER FROM AHL_WORKORDERS AWO,
3749: AHL_SCHEDULE_MATERIALS ASM WHERE AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID
3750: AND AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID AND ASM.SCHEDULED_MATERIAL_ID in(';
3751: L_BINDVAR_TBL AHL_OSP_UTIL_PKG.AHL_CONDITIONS_TBL;

Line 3751: L_BINDVAR_TBL AHL_OSP_UTIL_PKG.AHL_CONDITIONS_TBL;

3747: L_CUR AHL_OSP_UTIL_PKG.AHL_SEARCH_CSR;
3748: L_SQL_STRING VARCHAR2(30000) := 'SELECT distinct AWO.WORKORDER_ID,AWO.OBJECT_VERSION_NUMBER FROM AHL_WORKORDERS AWO,
3749: AHL_SCHEDULE_MATERIALS ASM WHERE AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID
3750: AND AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID AND ASM.SCHEDULED_MATERIAL_ID in(';
3751: L_BINDVAR_TBL AHL_OSP_UTIL_PKG.AHL_CONDITIONS_TBL;
3752: P_WORK_ORDER_ID_TBL AHL_PRD_WORKORDER_PVT.WORKORDER_ID_TBL_TYPE;
3753: L_WORKORDER_ID NUMBER;
3754: L_OBJ_VER_NO NUMBER;
3755: COUNTER NUMBER := 1;

Line 3793: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR

3789: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
3790: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'Query Formed ' || L_SQL_STRING);
3791: END IF;
3792:
3793: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR
3794: (
3795: P_CONDITIONS_TBL => L_BINDVAR_TBL,
3796: P_SQL_STR => L_SQL_STRING,
3797: P_X_CSR => L_CUR