APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 3752: P_WORK_ORDER_ID_TBL AHL_PRD_WORKORDER_PVT.WORKORDER_ID_TBL_TYPE;

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;
3756:

Line 3818: AHL_PRD_WORKORDER_PVT.UPDATE_WO_AOG_STATUS(P_API_VERSION => P_API_VERSION,

3814: X_MSG_COUNT => X_MSG_COUNT,
3815: X_MSG_DATA => X_MSG_DATA
3816: );
3817:
3818: AHL_PRD_WORKORDER_PVT.UPDATE_WO_AOG_STATUS(P_API_VERSION => P_API_VERSION,
3819: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
3820: P_COMMIT => P_COMMIT,
3821: P_WORKORDER_ID_TBL => P_WORK_ORDER_ID_TBL,
3822: X_RETURN_STATUS => X_RETURN_STATUS,